home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

DB2 - Problembeschreibung

Problem IC65656 Status: Geschlossen

DB2LOOK GENERATE INCORRECT VIEW/PROCEDURE/FUNCTION/TRIGGER ... D DL IF
COMMENT CONTAINING A 'REPLACE' KEYWORD HAS BEEN ADDED AS P

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
Problem is reproducible by running the following DDL: 
 
db2start ; 
 
create db repro ; 
 
connect to repro ; 
 
CREATE TABLE "LSOTFORM_C"  ( 
                  "MANDT" VARCHAR(9) NOT NULL WITH DEFAULT '000' 
, 
                  "TFORM" VARCHAR(12) NOT NULL WITH DEFAULT 
'0000' , 
                  "TFORMP" VARCHAR(12) NOT NULL WITH DEFAULT 
'0000' ) 
                 VALUE COMPRESSION  ; 
 
CREATE TABLE "LSOTFORMT_C"  ( 
                  "MANDT" VARCHAR(9) NOT NULL WITH DEFAULT '000' 
, 
                  "TFORM" VARCHAR(12) NOT NULL WITH DEFAULT 
'0000' , 
                  "SPRAS" VARCHAR(3) NOT NULL WITH DEFAULT ' ' , 
 
                  "TXTSHORT" VARCHAR(60) NOT NULL WITH DEFAULT ' 
' , 
                  "TXTSING" VARCHAR(120) NOT NULL WITH DEFAULT ' 
' , 
                  "TXTPLUR" VARCHAR(120) NOT NULL WITH DEFAULT ' 
' ) 
                 VALUE COMPRESSION  ; 
 
CREATE TABLE "LSOTFORMP_C"  ( 
                  "TFORMP" VARCHAR(12) NOT NULL WITH DEFAULT 
'0000' , 
                  "OBJTYPE" VARCHAR(6) NOT NULL WITH DEFAULT ' ' 
, 
                  "OBJTYPETYPE" VARCHAR(6) NOT NULL WITH DEFAULT 
' ' , 
                  "RELATION" VARCHAR(12) NOT NULL WITH DEFAULT ' 
' , 
                  "GENTRAIN" VARCHAR(3) NOT NULL WITH DEFAULT ' 
' , 
                  "TYPE" VARCHAR(3) NOT NULL WITH DEFAULT ' ' , 
                  "SCHEDULE_DEP" VARCHAR(3) NOT NULL WITH 
DEFAULT ' ' , 
                  "LOCATION_DEP" VARCHAR(3) NOT NULL WITH 
DEFAULT ' ' , 
                  "RESOURCE_DEP" VARCHAR(3) NOT NULL WITH 
DEFAULT ' ' , 
                  "MEDIA_STORED" VARCHAR(3) NOT NULL WITH 
DEFAULT ' ' , 
                  "LA_WRITE" VARCHAR(3) NOT NULL WITH DEFAULT ' 
' , 
                  "TAC_WRITE" VARCHAR(3) NOT NULL WITH DEFAULT ' 
' , 
                  "MASSN" VARCHAR(12) NOT NULL WITH DEFAULT ' ' 
, 
                  "MASSN_TRAINING" VARCHAR(12) NOT NULL WITH 
DEFAULT ' ' , 
                  "CMD_BOOKBE" VARCHAR(3) NOT NULL WITH DEFAULT 
' ' , 
                  "CMD_REBOOKBE" VARCHAR(3) NOT NULL WITH 
DEFAULT ' ' , 
                  "CMD_PREBOOKBE" VARCHAR(3) NOT NULL WITH 
DEFAULT ' ' , 
                  "CMD_REPLACEBE" VARCHAR(3) NOT NULL WITH 
DEFAULT ' ' , 
                  "CMD_CANCELBE" VARCHAR(3) NOT NULL WITH 
DEFAULT ' ' , 
                  "CMD_BOOK_LISTBE" VARCHAR(3) NOT NULL WITH 
DEFAULT ' ' , 
                  "CMD_PREBK_LSTBE" VARCHAR(3) NOT NULL WITH 
DEFAULT ' ' , 
                  "CMD_BK_ATTBE" VARCHAR(3) NOT NULL WITH 
DEFAULT ' ' , 
                  "CMD_PREBK_TRNGBE" VARCHAR(3) NOT NULL WITH 
DEFAULT ' ' , 
                  "CMD_CREATEBE" VARCHAR(3) NOT NULL WITH 
DEFAULT ' ' , 
                  "CMD_CRRP_HISTOBE" VARCHAR(3) NOT NULL WITH 
DEFAULT ' ' , 
                  "CMD_FOLLOWUPBE" VARCHAR(3) NOT NULL WITH 
DEFAULT ' ' , 
                  "CMD_BILLINGBE" VARCHAR(3) NOT NULL WITH 
DEFAULT ' ' , 
                  "CMD_ACTIVALLBE" VARCHAR(3) NOT NULL WITH 
DEFAULT ' ' , 
                  "CMD_SCHEDULEBE" VARCHAR(3) NOT NULL WITH 
DEFAULT ' ' , 
                  "CMD_MODIFYBE" VARCHAR(3) NOT NULL WITH 
DEFAULT ' ' , 
                  "CMD_PLANBE" VARCHAR(3) NOT NULL WITH DEFAULT 
' ' , 
                  "CMD_DISPLAYBE" VARCHAR(3) NOT NULL WITH 
DEFAULT ' ' , 
                  "CMD_WEBLINKBE" VARCHAR(3) NOT NULL WITH 
DEFAULT ' ' , 
                  "CMD_KNLLINKBE" VARCHAR(3) NOT NULL WITH 
DEFAULT ' ' , 
                  "CMD_CORRESPBE" VARCHAR(3) NOT NULL WITH 
DEFAULT ' ' , 
                  "CMD_RESO_SHOWBE" VARCHAR(3) NOT NULL WITH 
DEFAULT ' ' , 
                  "CMD_LOCKBE" VARCHAR(3) NOT NULL WITH DEFAULT 
' ' , 
                  "CMD_FIXBE" VARCHAR(3) NOT NULL WITH DEFAULT ' 
' , 
                  "CMD_COST_TRANBE" VARCHAR(3) NOT NULL WITH 
DEFAULT ' ' , 
                  "CMD_PRICE_PROPBE" VARCHAR(3) NOT NULL WITH 
DEFAULT ' ' , 
                  "CMD_INS_ALLOCBE" VARCHAR(3) NOT NULL WITH 
DEFAULT ' ' , 
                  "CMD_MATERIALBE" VARCHAR(3) NOT NULL WITH 
DEFAULT ' ' , 
                  "CMD_BOOKFE" VARCHAR(3) NOT NULL WITH DEFAULT 
' ' , 
                  "CMD_REBOOKFE" VARCHAR(3) NOT NULL WITH 
DEFAULT ' ' , 
                  "CMD_PREBOOKFE" VARCHAR(3) NOT NULL WITH 
DEFAULT ' ' , 
                  "CMD_REPLACEFE" VARCHAR(3) NOT NULL WITH 
DEFAULT ' ' , 
                  "CMD_CANCELFE" VARCHAR(3) NOT NULL WITH 
DEFAULT ' ' , 
                  "CMD_BOOK_LISTFE" VARCHAR(3) NOT NULL WITH 
DEFAULT ' ' , 
                  "CMD_PREBK_LSTFE" VARCHAR(3) NOT NULL WITH 
DEFAULT ' ' , 
                  "CMD_BK_ATTFE" VARCHAR(3) NOT NULL WITH 
DEFAULT ' ' , 
                  "CMD_PREBK_TRNGFE" VARCHAR(3) NOT NULL WITH 
DEFAULT ' ' , 
                  "CMD_CREATEFE" VARCHAR(3) NOT NULL WITH 
DEFAULT ' ' , 
                  "CMD_CRRP_HISTOFE" VARCHAR(3) NOT NULL WITH 
DEFAULT ' ' , 
                  "CMD_FOLLOWUPFE" VARCHAR(3) NOT NULL WITH 
DEFAULT ' ' , 
                  "CMD_BILLINGFE" VARCHAR(3) NOT NULL WITH 
DEFAULT ' ' , 
                  "CMD_ACTIVALLFE" VARCHAR(3) NOT NULL WITH 
DEFAULT ' ' , 
                  "CMD_SCHEDULEFE" VARCHAR(3) NOT NULL WITH 
DEFAULT ' ' , 
                  "CMD_MODIFYFE" VARCHAR(3) NOT NULL WITH 
DEFAULT ' ' , 
                  "CMD_PLANFE" VARCHAR(3) NOT NULL WITH DEFAULT 
' ' , 
                  "CMD_DISPLAYFE" VARCHAR(3) NOT NULL WITH 
DEFAULT ' ' , 
                  "CMD_WEBLINKFE" VARCHAR(3) NOT NULL WITH 
DEFAULT ' ' , 
                  "CMD_KNLLINKFE" VARCHAR(3) NOT NULL WITH 
DEFAULT ' ' , 
                  "CMD_CORRESPFE" VARCHAR(3) NOT NULL WITH 
DEFAULT ' ' , 
                  "CMD_RESO_SHOWFE" VARCHAR(3) NOT NULL WITH 
DEFAULT ' ' , 
                  "CMD_LOCKFE" VARCHAR(3) NOT NULL WITH DEFAULT 
' ' , 
                  "CMD_FIXFE" VARCHAR(3) NOT NULL WITH DEFAULT ' 
' , 
                  "CMD_COST_TRANFE" VARCHAR(3) NOT NULL WITH 
DEFAULT ' ' , 
                  "CMD_PRICE_PROPFE" VARCHAR(3) NOT NULL WITH 
DEFAULT ' ' , 
                  "CMD_INS_ALLOCFE" VARCHAR(3) NOT NULL WITH 
DEFAULT ' ' , 
                  "CMD_MATERIALFE" VARCHAR(3) NOT NULL WITH 
DEFAULT ' ' ) 
                 VALUE COMPRESSION   ; 
 
CREATE VIEW "U_37180C" ( "MANDT", "TFORM", "SPRAS", "TXTSHORT", 
"TXTSING", "TXTPLUR", "TFORMP", "OBJTYPE", "OBJTYPETYPE", 
"RELATION", "GENTRAIN", "TYPE", "SCHEDULE_DEP", "LOCATION_DEP", 
"MEDIA_STORED", "LA_WRITE", "TAC_WRITE", "MASSN", "CMD_BOOKBE", 
"CMD_REBOOKBE", "CMD_PREBOOKBE", "CMD_REPLACEBE", 
"CMD_CANCELBE", "CMD_BOOK_LISTBE", "CMD_PREBK_LSTBE", 
"CMD_BK_ATTBE", "CMD_PREBK_TRNGBE", "CMD_CREATEBE", 
"CMD_CRRP_HISTOBE", "CMD_FOLLOWUPBE", "CMD_BOOKFE", 
"CMD_REBOOKFE", "CMD_PREBOOKFE", "CMD_REPLACEFE", 
"CMD_CANCELFE", "CMD_BOOK_LISTFE", "CMD_PREBK_LSTFE", 
"CMD_BK_ATTFE", "CMD_PREBK_TRNGFE", "CMD_CREATEFE", 
"CMD_CRRP_HISTOFE", "CMD_FOLLOWUPFE" ) AS SELECT T0001."MANDT", 
T0001."TFORM", T0002."SPRAS", T0002."TXTSHORT", T0002."TXTSING", 
 T0002."TXTPLUR", T0001."TFORMP", T0003."OBJTYPE", 
T0003."OBJTYPETYPE", T0003."RELATION", T0003."GENTRAIN", 
T0003."TYPE", T0003."SCHEDULE_DEP" , T0003."LOCATION_DEP", 
T0003."MEDIA_STORED", T0003."LA_WRITE", T0003."TAC_WRITE", 
T0003."MASSN", T0003."CMD_BOOKBE", T0003."CMD_REBOOKBE", 
T0003."CMD_PREBOOKBE", T0003."CMD_REPLACEBE", 
T0003."CMD_CANCELBE", T0003."CMD_BOOK_LISTBE", 
T0003."CMD_PREBK_LSTBE", T0003."CMD_BK_ATTBE", 
T0003."CMD_PREBK_TRNGBE", T0003."CMD_CREATEBE", 
T0003."CMD_CRRP_HISTOBE", T0003."CMD_FOLLOWUPBE", 
T0003."CMD_BOOKFE", T0003."CMD_REBOOKFE", T0003."CMD_PREBOOKFE", 
T0003."CMD_REPLACEFE", T0003."CMD_CANCELFE", 
T0003."CMD_BOOK_LISTFE", T0003."CMD_PREBK_LSTFE", 
T0003."CMD_BK_ATTFE", T0003."CMD_PREBK_TRNGFE", 
T0003."CMD_CREATEFE", T0003."CMD_CRRP_HISTOFE", 
T0003."CMD_FOLLOWUPFE" FROM "LSOTFORM_C" T0001, "LSOTFORMT_C" 
T0002, "LSOTFORMP_C" T0003 WHERE T0001."MANDT" = T0002."MANDT" 
AND T0001."TFORM" = T0002."TFORM" AND T0003."TFORMP" = 
T0001."TFORMP" ; 
 
and the running 
 
db2look -d repro -e 
 
in the output, the definition for the view will be incorrect.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* Software                                                     * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* db2look was generating incorrect DDL statement for           * 
* procedure, function , views, trigger for '-cor' option in    * 
* case the statement contain a replace word as part of comment * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* customer has to upgrade to v97 fp2 version                   * 
****************************************************************
Local-Fix:
verfügbare FixPacks:
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows

Lösung
the problem has been solved in v97 fp2
Workaround
keiner bekannt / siehe Local-Fix
Bug-Verfolgung
Vorgänger  : APAR is sysrouted TO one or more of the following: IC66954 
Nachfolger : 
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
19.01.2010
23.04.2010
23.04.2010
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.FP2
Problem behoben lt. FixList in der Version
9.7.0.2 FixList