Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2013
    Posts
    1

    Red face Unanswered: Getting "Semaphore Wait" error while executing procedure.

    I am having db2 9.5 database version.

    When we are trying to approve more than 300 records through a procedure we are getting the below error :-

    db2 => call "DB2ADMIN"."PUT_FILE_STATUS" ( 49023, "DB2ADMIN".GET_LKPID('FILE_APPROVED'), 'shr6323', '')
    SQL0723N An error occurred in a triggered SQL statement in trigger
    "DB2ADMIN.TRG_MQ_PUT". Information returned for the error includes SQLCODE
    "-1131", SQLSTATE "38503" and message tokens "-2097151964|*|*|*|*||SEMAPHORE
    WAIT|". SQLSTATE=09000

    Along with above error we found out that in /tmp partition 3 files are getting genrated :-

    -rw-r--r-- 1 db2fenc1 db2fenc1 520941648 Dec 03 14:39 core.20131203.203936.14549126.dmp
    -rw-r--r-- 1 db2fenc1 db2fenc1 59060 Dec 03 14:39 Snap0002.20131203.203936.14549126.trc
    -rw-r--r-- 1 db2fenc1 db2fenc1 126375 Dec 03 14:39 javacore.20131203.203936.14549126.txt


    I am new to db2 db and have searched a lot on this but never got close to this issue. Please somebody help me on this.

    ************************************************** **********************************************
    Thanks for rply .

    I tried dropping and recreating both procedure as well as trigger involved but still facing the same issue .

    I checked ,dont think there is any coding errors.How to Ensure that other application or users will not send termination signals to the db2fmp process by reviewing the activities of all applications that are running on the system and users who are accessing the system.

    Thanks and regards ,
    Gaurav


    Thanks & Regards ,
    Gaurav.
    Last edited by gauravganve; 12-05-13 at 07:01. Reason: Wasn't allowing to reply the post saying answer is not correct

  2. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    as indicated in doc :
    SQL0723N
    due to sqlcode -1131 (look it up in same infocenter)
    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

Posting Permissions

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