|
Problem IC95453
|
Status: Geschlossen |
DB2ADVIS MAY FAIL WITH SQL0304N WHEN PROCESSING LARGE INPUT FILES |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 |
| Problembeschreibung: |
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 |
| Problem-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* all using db2advis *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to version 10.5 FP3 *
**************************************************************** |
| Local-Fix: |
|
| verfügbare FixPacks: |
DB2 Version 10.5 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.5 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows
DB2 Version 10.5 Fix Pack 9 for Linux, UNIX, and Windows
|
| Lösung |
First fixed in version 10.5 FP3 |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 27.08.2013
27.02.2014
27.02.2014 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
|
| Problem behoben lt. FixList in der Version |
| 10.5.0.3
|
 |
| 10.5.0.3
|
|
