DB2 FOR LUW / DB2FORLUW / 970 - DB2

Depending on the size and content of the input file, db2advis 
may fail with error SQL0304N. Symptoms could look like the 
following in the output file: i 
 
    +1  execution started at timestamp 
2013-06-26-11.38.36.254710 
    +2  found [4945] SQL statements from the input file 
    +3  Recommending indexes... 
    +4 
    +5  0 solutions were evaluated by the advisor 
    +6 
    +7  exiting with error code [-304] 
 
and in db2diag.log: 
 
2013-06-26-17.07.01.758200+060 I165624A714        LEVEL: Error 
PID     : 54657106             TID  : 1           PROC : 
db2advis 
INSTANCE: db2inst1              NODE : 000 
APPID   : *N0.db2inst1.130906150326 
EDUID   : 1 
DATA #1 : String, 51 bytes 
 
***   Error at line 1372, in file db2advindex.SQC 
DATA #2 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes 
 sqlcaid : SQLCA     sqlcabc: 136   sqlcode: -304   sqlerrml: 0 
 sqlerrmc: 
 sqlerrp : SQLADRBO 
 sqlerrd : (1) 0x882A000C      (2) 0x0000000C      (3) 
0x00000000 
           (4) 0x00000000      (5) 0x00000000      (6) 
0x00000000 
 sqlwarn : (1)      (2)      (3)      (4)        (5)       (6) 
 
           (7)      (8)      (9)      (10)        (11) 
 sqlstate: 22003

**************************************************************** 
* USERS AFFECTED:                                              * 
* all using db2advis                                           * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to version 9.7 Fixpack 9                             * 
****************************************************************

DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
 

First fixed in version 9.7 Fixpack 9

keiner bekannt / siehe Local-Fix

Vorgänger  : APAR is sysrouted TO one or more of the following: IC95453 IC96285 
Nachfolger : 

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

03.07.2013
01.10.2013
01.10.2013

9.7.FP9