|
Problem IC75628
|
Status: Closed |
WHEN USING CONTROL CENTER TO CONNECT TO ISERIES, THE ISERIES JOB LOG REPORTS A -204 ON SYSIBM.SYSTABLES |
| product: |
DB2 CONNECT / DB2CONNCT / 950 - DB2 |
| Problem description: |
When using Control Center to connect from a Client, V9.5 fp4
thru a DB2 Gateway V9.5
fp5, to an iSeries V6R1, the iSeries joblog shows:
SQL0204 SYSTABLES in SYSIBM type *FILE not found
The connection to iSeries succeeds.
No errors are are found in the client trace, but the gateway
trace shows:
3317 data DB2 UDB common communication tcprecv fnc
(3.3.43.22.0.2)
pid 1452 tid 3508 cpid 2940 node 0 sec 2 nsec 335101035 probe 2
bytes 181
Data1 (PD_TYPE_DEFAULT,8) Hexdump:
8407 0000 0000 0000 ........
Data2 (PD_TYPE_DEFAULT,4) Hexdump:
9100 0000 ....
Data3 (PD_TYPE_DEFAULT,145) Hexdump:
004E D051 0001 0048 200D 0044 2113 C4C5 .N.Q...H ..D!...
E5C9 C1D9 C440 4040 4040 4040 4040 4040 .....@@@@@@@@@@@
D5E4 D3D3 C9C4 4040 4040 4040 4040 4040 ......@@@@@@@@@@
4040 E2D8 D3C3 F2C7 F1F5 4040 4040 4040 @@........@@@@@@
4040 4040 4141 4141 414C 4959 00E5 0043 @@@@AAAAALIY...C
D003 0001 003D 2414 0000 0000 3353 454C .....=$.....3SEL
4543 5420 4449 5354 494E 4354 2043 5552 ECT DISTINCT CUR
5245 4E54 2053 514C 4944 2046 524F 4D20 RENT SQLID FROM
5359 5349 424D 2E53 5953 5441 424C 4553 SYSIBM.SYSTABLES
The SYSIBM schema is not present in DB2 ISeries implemenation.
DB2 LUW should not be referencing it. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* DB2 Connect to iSeries DB2 *
****************************************************************
* PROBLEM DESCRIPTION: *
* When using Control Center to connect from a Client, V9.5 *
* thru a DB2 Gateway V9.5 *
* to an iSeries V6R1, the iSeries joblog shows: *
* *
* SQL0204 SYSTABLES in SYSIBM type *FILE not found *
* *
* The connection to iSeries succeeds. *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 UDB Version 9.5 Fix Pack 9. *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
Problem was first fixed in DB2 UDB Version 9.5 Fix Pack 9. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 06.04.2011
28.03.2012
28.03.2012 |
| Problem solved at the following versions (IBM BugInfos) |
9.5.FP9
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.5.0.9
|
 |
