473,396 Members | 1,706 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

SQL0723N An error occurred in a triggered SQL statement in trigger "DB2ADMIN.TRG_MQ_

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
$
Dec 10 '13 #1
1 4456
Anas Mosaad
185 128KB
Please try to open a PMR with this issue.
Jan 12 '14 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: timVerizon | last post by:
Hoping someone can help here.. Our application (C#.Net) was receiving IBM.Data.DB2.DB2Exceptions ERROR SQL0904N Unsuccessful execution caused by an unavailable resource. Reason code: '', type...
1
by: Marco Gerlach | last post by:
Hello, on one of our customers servers we get following error on first ASPX-page: An error occurred while try to load the string resources (GetModuleHandle failed with error -2147023888) ...
1
by: Max | last post by:
Any idea why this happens? It only happens on the live machine, but not the test machine. I've heard this happens when you try to send too much data to SQL Server, but all I'm sending are 4 small...
1
by: campwes | last post by:
Hey, all! We're having trouble displaying SQL Server data in a web site as XML, using a transform. The query is a simple SELECT statement. When running the query, we get the following error from...
5
by: Vijayakrishna Pondala | last post by:
Hi, We are using the following error randomly, when accessing a webservice method/servlet hosted on JBoss application server: The underlying connection was closed: An unexpected error occurred...
15
by: David Lozzi | last post by:
Howdy, I have a function that uploads an image and that works great. I love ..Nets built in upload, so much easier than 3rd party uploaders! Now I am making a public function that will take the...
2
by: mike_li | last post by:
On Window 2000 Professional Server DB2 UDB Level: DB2 code release "SQL07029" with level identifie "030A0105" and informational tokens "DB2 v7.1.0.98", "n040510" and "WR21337". In the...
1
by: Anubhav | last post by:
Hello The problem is need to find out the querry that has updated or inserted into the table and in turn 'Triggered the Trigger'. I have the user name, the machine name, Application name, but...
5
by: dhanashivam | last post by:
hi all i am doing a web site with single sign on technique. I am getting the error "COMException (0x80072020): An operations error occurred" while executing the statement foreach (SearchResult...
0
by: Kristi | last post by:
This is the Command: CPYTOIMPF FROMFILE(LSPMPRDTA/LS600F) + TOSTMF('\KWIKTAG\KWIKTAG.TXT') + MBROPT(*REPLACE) STMFCODPAG(*PCASCII) +
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.