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 IC68365 Status: Geschlossen

DB2EXMIG MAY NOT MIGRATE THE ADVISE_INDEX TABLE PROPERLY

Produkt:
DB2 FOR LUW / DB2FORLUW / 950 - DB2
Problembeschreibung:
db2exmig may not migrate the ADVISE_INDEX table properly. 
 
This can be determined by executing the following query on a 
 
database with the suspect improperly migrated ADVISE_INDEX 
table: 
SELECT C.NAME, C.TBNAME, C.TBCREATOR 
FROM SYSIBM.SYSCOLUMNS AS C 
WHERE C.TBNAME = 'ADVISE_INDEX' 
AND C.TBCREATOR = UPPER('<schema>') 
AND C.NAME IN ('NLEAF', 'SEQUENTIAL_PAGES') 
AND C.DEFAULT IS NULL; 
 
If either the NLEAF or SEQUENTIAL_PAGES columns are in the 
output result-set, the table has not been migrated properly. 
 
 
Another symptom of improper migration is the unexpected 
termination of the DB2 Design Advisor (db2advis) with a return 
code of -407 and a corresponding entry in the db2diag.log that 
looks something like: 
 
YYYY-MM-dd-hh.mm.SS.ssssssssss ssssssssssss       LEVEL: Error 
PID     : nnnnnnn              TID  : n           PROC : 
db2advis 
INSTANCE: xxxxxxx              NODE : nnn 
APPID   : *xxxxx.xxxxxxx.nnnnnnnnnnnn 
EDUID   : n 
DATA #1 : String, 51 bytes 
***   Error at line nnnn, in file db2advindex.SQC 
DATA #2 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes 
 sqlcaid : SQLCA     sqlcabc: 136   sqlcode: -407   sqlerrml: 33 
 sqlerrmc: TBSPACEID=n, TABLEID=nn, COLNO=18 
 sqlerrp : SQLDFMT2 
 sqlerrd : (1) 0xhhhhhhhh      (2) 0xhhhhhhhh      (3) 
0xhhhhhhhh 
           (4) 0xhhhhhhhh      (5) 0xhhhhhhhh      (6) 
0xhhhhhhhh 
 sqlwarn : (1)      (2)      (3)      (4)        (5)       (6) 
           (7)      (8)      (9)      (10)        (11) 
 sqlstate: 23502 
 
The key problem identifiers in the db2diag.log entry are: 
"sqlcode: -407" and "COLNO=18".
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* After migration to 9.5                                       * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* db2exmig may not migrate the ADVISE_INDEX table properly     * 
* when upgrading to DB2 Version 9.5.                           * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Install Fixpack 6                                            * 
****************************************************************
Local-Fix:
Manually ALTER the ADVISE_INDEX table to account for the default 
values of the NLEAF and SEQUENTIAL_PAGES columns, i.e., 
ALTER TABLE <schema>.ADVISE_INDEX ALTER COLUMN NLEAF SET DEFAULT 
0 ALTER COLUMN SEQUENTIAL_PAGES SET DEFAULT 0;
verfügbare FixPacks:
DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows

Lösung
DB2 9.5 FP6
Workaround
keiner bekannt / siehe Local-Fix
Bug-Verfolgung
Vorgänger  : APAR is sysrouted TO one or more of the following: IC68415 IC68416 
Nachfolger : 
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
03.05.2010
22.06.2010
22.06.2010
Problem behoben ab folgender Versionen (IBM BugInfos)
9.5.FP6
Problem behoben lt. FixList in der Version