Results 1 to 5 of 5
  1. #1
    Join Date
    Sep 2008
    Location
    Toronto,Canada
    Posts
    655

    Unanswered: CLI0108E SQLSTATE 40003 , What is it ?

    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

  2. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    in the db2ini you can specify no timeout (value=0) conntimeout
    have a look in doc on db2cli parameters
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  3. #3
    Join Date
    Sep 2008
    Location
    Toronto,Canada
    Posts
    655
    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

  4. #4
    Join Date
    May 2007
    Location
    somewhere in dbforums
    Posts
    221
    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???
    IBM Certified Database Associate, DB2 9 for LUW

  5. #5
    Join Date
    Sep 2008
    Location
    Toronto,Canada
    Posts
    655
    Thanks ,

    I have forwarded this issue to System administrators.

    They are going to study it.

    DBFinder

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •