CLI0108E SQLSTATE 40003 , What is it ?

DBFinder · #1 (**permalink**) 03-22-09, 08:11

Hi Guys,

One of our application returned errror CLI0108E sqlstate 40003.

Definitely, it means Communication link failure and sqlstate indicates that link was broken while execution was in progress and DB2 did not get full SQL statement text.

But in db2diag.log I found only following error

Code:

2009-03-21-20.52.41.094000-240 E59304532F450      LEVEL: Error (OS)
PID     : 2364                 TID  : 11644       PROC : db2syscs.exe
INSTANCE: DB2                  NODE : 000         DB   : TRIUMPH
APPHDL  : 0-515                APPID: GA07022A.E210.020742004041
FUNCTION: DB2 UDB, oper system services, sqloReadFileInterrupt, probe:4
CALLED  : OS, -, unspecified_system_function
OSERR   : 121 "The semaphore timeout period has expired."

Can some one help me interpret this error, cause this happened about 50 times in period of an hour.

DB2 v 8.1.5 windows server 2003

Thanks
DBFinder

przytula_guy · #2 (**permalink**) 03-22-09, 10:26

in the db2ini you can specify no timeout (value=0) conntimeout
have a look in doc on db2cli parameters

DBFinder · #3 (**permalink**) 03-22-09, 11:09

Thanks,

But I want to understand the diaglog entry.

It says OSERR: ". . . . . ."

Is this error from windows or DB2 ?

The database is running for months. What might have happened in these 45 minutes.

Thanks Again,
DBFinder

nick.ncs · #4 (**permalink**) 03-23-09, 02:26

sqloReadFileInterrupt means it is an OS level call such as opening or closing of files.

Also A semaphore timeout occurs when your drive loses communication with the rest of your system. Are your drives in SAN or in network by any chance???

DBFinder · #5 (**permalink**) 03-23-09, 11:34

Thanks ,

I have forwarded this issue to System administrators.

They are going to study it.

DBFinder

Internet Services

Web Development

Digital Marketing

Consumer Tech