|
Problem IC88126
|
Status: Geschlossen |
SQL0901N IS RETURNED FOR A QUERY THAT FEATURES A UNION ALL VIEW WITH A HOST VARIABLE PREDICATE ON THAT VIEW. |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problembeschreibung: |
db2diag.log messages:
2012-08-27-08.55.33.950015+060 E1828223E780 LEVEL: Error
PID : 8636 TID : 46970030778688PROC :
db2sysc 0
INSTANCE: DB2INST1 NODE : 000 DB : TESTDB
APPHDL : 0-4075 APPID:
12.345.678.901.2345.67890123456
AUTHID : DBAUTH
EDUID : 343 EDUNAME: db2agent (TESTDB) 0
FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_ffdc, probe:10
MESSAGE : ADM14005E The following error occurred: "AppErr".
First Occurrence
Data Capture (FODC) has been invoked in the following
mode:
"Automatic". Diagnostic information has been recorded
in the
directory named
"/var/ibmdb2/db2inst1/sqllib/db2dump/FODC_AppErr_2012-08-27-08.5
5.33.
949844_8636_343_000/".
2012-08-27-08.55.33.951018+060 I1830911E856 LEVEL: Severe
PID : 8636 TID : 46970030778688PROC :
db2sysc 0
INSTANCE: DB2INST1 NODE : 000 DB : TESTDB
APPHDL : 0-4075 APPID:
12.345.678.901.2345.67890123456
AUTHID : DBAUTH
EDUID : 343 EDUNAME: db2agent (TESTDB) 0
FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_ffdc,
probe:300
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -901 sqlerrml: 19
sqlerrmc: Already found DOID1
sqlerrp : SQLNG0BD
sqlerrd : (1) 0x00000000 (2) 0x00000000 (3)
0x00000000
(4) 0x0000004C (5) 0xFFFFC86B (6)
0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:
2012-08-27-08.55.33.952324+060 I1835754E5488 LEVEL: Severe
PID : 8636 TID : 46970030778688PROC :
db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : TESTDB
APPHDL : 0-4075 APPID:
12.345.678.901.2345.67890123456
AUTHID : DBAUTH
EDUID : 343 EDUNAME: db2agent (TESTDB) 0
FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_sibling,
probe:200
MESSAGE : section stmt
DATA #1 : Hexdump, 985 bytes
<<Hex dump with SQL statement>>
The above -901 error happens due to a logic problem in a sanity
check where it has incorrectly flagged the SQL statement as an
error in the sql compiler when in fact, there is nothing wrong
with the compile and it should have been allowed to continue to
complete the SQL query compile. |
| Problem-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 Version 9.7 Fix pack 8. *
**************************************************************** |
| Local-Fix: |
|
| verfügbare FixPacks: |
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
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
|
| Lösung |
First fixed in DB2 Version 9.7 Fix pack 8. |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Bug-Verfolgung |
Vorgänger : APAR is sysrouted TO one or more of the following: IC91283
Nachfolger : |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 10.11.2012
01.04.2013
01.04.2013 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.7.FP8
|
| Problem behoben lt. FixList in der Version |
| 9.7.0.8
|
 |
