home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

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
DB2 Version 10.5 Fix Pack 9 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 FixList