DB2 - Problem description
Problem IC97122 | Status: Closed |
DB2 CLIENT PRINTS -1013 IN DB2DIAG.LOG WHEN USING DB2DSDRIVER.CFG AND DB NOT EXIST IN DB CATALOG. | |
product: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
Problem description: | |
DB2 Client prints -1013 in the db2diag.log like as below if the specified database cannot be found in the database catalog (sqldbdir) even though applications can connect to the database by using db2dsdriver.cfg. 2013-10-17-09.36.24.431000+540 I2512H721 LEVEL: Warning PID : 892360 TID : 1 PROC : db2bp INSTANCE: db2inst1 NODE : 000 HOSTNAME: db2debug FUNCTION: DB2 UDB, Connection Manager, sqleUCgetDirInfo, probe:1012 DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes sqlcaid : SQLCA sqlcabc: 136 sqlcode: -1013 sqlerrml: 6 sqlerrmc: SAMPLE sqlerrp : SQLEUCCM sqlerrd : (1) 0x00000000 (2) 0x00000000 (3) 0x00000000 (4) 0x00000000 (5) 0x00000000 (6) 0x00000000 sqlwarn : (1) (2) (3) (4) (5) (6) (7) (8) (9) (10) (11) sqlstate: This APAR will remove the warning after directory lookup check in client layer. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users who use db2dsdriver.cfg. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Please upgrade to DB2 V10.5 FixPack 4 or later. * **************************************************************** | |
Local Fix: | |
This error message can eliminate by ether of the following ways. a) Catalog the database in the system database directory. b) Remove database catalog file (sqldbdir). | |
available fix packs: | |
DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows | |
Solution | |
This problem was first fixed in DB2 V10.5 FixPack 4. | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 23.10.2013 22.09.2014 22.09.2014 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) | |
10.5.0.4 |