|
Problem IC77688
|
Status: Closed |
FEDERATED QUERY FAILS WITH SQL901N |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
federated query fails with sql901n
Error received:
SQL0901N The SQL statement failed because of a non-severe
system error. Subsequent SQL statements can be processed.(Reason
"Source for input RCOB has not been instantiated".)
SQLSTATE=58004
In db2diag.log there is the following error:
--------------------------------------------------
2011-03-08-13.17.03.031284+060 I170273A874 LEVEL: Severe
PID : 6971 TID : 2590 PROC : db2sysc
0
INSTANCE: DB2INST1 NODE : 000 DB : SAMPEL
APPHDL : 0-57299 APPID:
159.213.1.247.49638.11030812170
AUTHID : db2admin
EDUID : 2590 EDUNAME: db2agent (SAMPEL) 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: 47
sqlerrmc: Source for input RCOB has not been instantiated
sqlerrp : SQLNG07A
sqlerrd : (1) 0x00000000 (2) 0x00000000 (3)
0x00000000
(4) 0x000039CD (5) 0xFFFFF340 (6)
0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:
Found the following compilation error in the trace which is the
cause of SQL0902 and SQL0901 4041674 data DB2 UDB SW- common
services sqlnn_cmpl fnc
(3.3.49.103.0.570)
pid 6971 tid 627 cpid 7141 node 0 probe 570 bytes 375
Compiler error stack for rc = -2145779603:
sqlnn_cmpl[415]
sqlng_main[3109]
sqlng_main[1684]
sqlng_build_thread[741]
sqlng_process_return_op[1066]
sqlng_process_pipe_op[1413]
sqlng_process_mate_op[1990]
sqlng_process_nljn_op[11037]
sqlng_build_thread[741]
sqlng_process_ship_op[1020]
sqlng_build_RQOB_obj[743]
sqlng_build_in_RCLB_obj[1847]
sqlng_build_RCOB_obj[3264] |
| Problem Summary: |
The fix is fixed in db2 v97 FP5 |
| Local Fix: |
|
| available fix packs: |
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 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
|
| Solution |
|
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 25.07.2011
12.12.2011
12.12.2011 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.5
|
 |
