I am having db2 9.5 with no fix packs on AIX 6
When i am firing the below procedure getting error ,basically we are trying to approve 305 files in this query if try to approve a single file it works.
Request your help .
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
Also when i fire this query , a trap file is getting generated in diagpath and in the db2diag.log it shows only "marking fmp process as unstable " message
$ head -50 9764984.2314.000.app_trap.txt
<?xml version="1.0" encoding="ISO-8859-1"?>
<?xml-stylesheet href="http://raspd.torolab.ibm.com/db2trapfile.xsl" type="text/xsl"?>
<DB2TrapFile version="1.0">
*******************************************
* *
* DB2 USERS : *
* ----------- *
* A db2fmp thread terminated abnormally. *
* This may have been caused by a prog- *
* ramming error in the routine it was *
* executing. A stack trace-back follows. *
* The process remains active. *
* *
*******************************************
<Trap>
<Header>
DB2 build information: DB2 v9.5.0.0 s071001 SQL09050
timestamp: 2013-12-10-10.46.46.469957
instance name: db2inst1.000
EDU name : db2fmp (Java) 0
EDU ID : 2314
Signal #11
uname: S:AIX R:1 V:6 M:00F66EE74C00 N:DBServerDR
process id: 9764984
thread id : 2314 (0x90A)
kthread id : 26148905
</Header>
<SignalDetails>
<Siginfo_t length="64">
0000000B 00000000 00000033 00000000
00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000
</Siginfo_t>
Signal #11 (SIGSEGV): si_addr is 0x0000000000000000, si_code is 0x00000033 (SEGV_ACCERR:Invalid permissions for mapped object.)
</SignalDetails>
<ResourceLimits>
Data seg top [sbrk(0)] = 0x000000011239F440
Cur data size (bytes) = 0x7FFFFFFFFFFFFFFF
Cur stack size (bytes) = 0x0000000100000000
Cur core size (bytes) = 0x00000000FFFFFFFF
</ResourceLimits>
<Registers>
IAR: 0900000008925E30 MSR: A00000000000D032 LR: 000000011020E97C
CTR: 0900000008925E30 XER: E00FFFFF FPSCR: 82020000
CR: 5342109B
GPR[00]: 090000000890FEB8 GPR[01]: 0000000111CBA3A0 GPR[02]: 07000000000C9970
GPR[03]: 000000000000000B GPR[04]: 0000000000000000 GPR[05]: 090000000890FEB8
GPR[06]: 0000000111AB5399 GPR[07]: 0000000000000008 GPR[08]: 0000000111CBFF00
GPR[09]: 0000000013360000 GPR[10]: 0000000111520F98 GPR[11]: 0900000008925E30
$