SQL5005C error IBM DB2 LUW


Product : IBM DB2 LUW
Product version : 9.1,9.5,9.7
Platform: Linux ,Unix and Windows

Title : SQL5005C error

Question :
SQL5005C error window pop up.
Cause :

1. DB2SYSTM not found in installation directory.

Following entries are seen in db2diag file.

2010-12-03-03.06.32.584000+540 I22054739H284 LEVEL: Error
PID : 5352 TID : 5376 PROC : db2fmp.exe
INSTANCE: DB2 NODE : 000
EDUID : 5376
FUNCTION: DB2 UDB, config/install, sqlfGetDbmCfg, probe:10
RETCODE : ZRC=0xFFFFEC73=-5005
2010-12-03-03.06.32.584000+540 I22055025H339 LEVEL: Severe
PID : 5352 TID : 5376 PROC : db2fmp.exe
INSTANCE: DB2 NODE : 000
EDUID : 5376
FUNCTION: DB2 UDB, config/install, sqlf_alert, probe:8
DATA #1 : Hexdump, 4 bytes
0x05CAE74C : 73EC FFFF s…
2. File permission changed from 755 to 775,700 and 744 because of rmsoke

Following entries are seen in db2diag

2011-05-27-13.04.18.619309-240 I95211A453 LEVEL: Error
PID : 847920 TID : 1 PROC : db2agent
(instance) 0
INSTANCE: qasa12 NODE : 000
APPHDL : 0-24 APPID: *LOCAL.qasa12.110527170418
FUNCTION: DB2 UDB, config/install, sqlf_read_db_and_verify, probe:30
MESSAGE : SQL5005: sqlf_openfile rc =
DATA #1 : Hexdump, 4 bytes
0x0FFFFFFFFFFE9820 : 840F 0001 ….

2011-05-27-13.04.18.619937-240 I95665A348 LEVEL: Error
PID : 847920 TID : 1 PROC : db2agent
(instance) 0
INSTANCE: qasa12 NODE : 000
APPHDL : 0-24 APPID: *LOCAL.qasa12.110527170418
FUNCTION: DB2 UDB, config/install, sqlf_read_db_and_verify, probe:0
RETCODE : ZRC=0xFFFFEC73=-5005

2011-05-27-13.04.18.620423-240 I96014A420 LEVEL: Severe
PID : 847920 TID : 1 PROC : db2agent
(instance) 0
INSTANCE: qasa12 NODE : 000
APPHDL : 0-24 APPID: *LOCAL.qasa12.110527170418
FUNCTION: DB2 UDB, config/install, sqlf_alert, probe:9
MESSAGE : DiagData
DATA #1 : Hexdump, 4 bytes
0x0FFFFFFFFFFE99F0 : FFFF EC73 …s

2011-05-27-13.04.18.620591-240 I96435A315 LEVEL: Severe
PID : 847920 TID : 1 PROC : db2agent
(instance) 0
INSTANCE: qasa12 NODE : 000
APPHDL : 0-24 APPID: *LOCAL.qasa12.110527170418
FUNCTION: , , , probe:9
RETCODE : ZRC=0xFFFFEC73=-5005

Trace shows following entries

db2trace file showS:

2466 | | | | | | | | | | | | | | | | sqlf_read_db_and_verify data
[probe 0]
2467 | | | | | | | | | | | | | | | | | | | | sqloclose entry
2468 | | | | | | | | | | | | | | | | | | | | sqloclose exit
2469 | | | | | | | | | | | | | | | | | | | _pdlogInt exit
2470 | | | | | | | | | | | | | | | | | | pdLogRC exit
2471 | | | | | | | | | | | | | | | | | sqlt_logerr_zrc exit
2472 | | | | | | | | | | | | | | | | sqlf_read_db_and_verify exit
[rc = 0xFFFFEC73 = -5005]

3. Open control center in Windows 2003 server gets SQL5005C error

The user needs to have read,write and execute access on db2 directory.

More On DB2 support, DBAWorkDatabase support, Database services, Oracle ADF

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: