View previous topic :: View next topic
|
Author |
Message |
javed132
New User
Joined: 08 Apr 2005 Posts: 3
|
|
|
|
Hi,
I have a IMS transaction which calls a sub-program A. Also This transaction calls another sub-program B which calls sub-program C.
The problem is that I am getting -924 for sub-program A and also for Sub-Program C.
Can anyone suggest how to get over this issue?? I have put the load in IMS load lib also but its not helping me.
Please respond to e-addr removed |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Is this an IMS error or a DB2 error?
Did this ever work or is this some new (or newly modified) process. |
|
Back to top |
|
|
javed132
New User
Joined: 08 Apr 2005 Posts: 3
|
|
|
|
-924 is a DB2 error. We are eveloping a new system where a IMS transaction A calls sub-program B,C.
Sub program C also calls another sub program D.
So for Sub-program D and sometimes for Sub-program B and C also we get -924 not sure why?
We ensured that we did a promote of all the programs to IMS TEST region and also ensured that load module is present in IMS loadlib,but nothing seems to work. |
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10872 Location: italy
|
|
|
|
if You had read the manual You would have found that posting on a forum for such problems is a useless waste of time for everybody?
for You because the problem solution will be delayed
for us because we have to remind You about the proper way of doing Your job ...
do the manual reading on Your behalf, cut and paste the relevant message
here is an excerpt of the manual for the -924
Quote: |
DB2 Version 9.1 for z/OS > Troubleshooting for DB2 > DB2 codes > SQL codes > SQL error codes
-924
DB2 CONNECTION INTERNAL ERROR, function-code, return-code, reason-code
Explanation
Connection to DB2® has failed because of an unexpected internal error, identified by the 'reason-code'.
System action
The statement cannot be processed. The connection to DB2 is not established.
Programmer response
The reason code is described in Codes. The requested 'function-code' and 'return-code' may provide additional information. Any attempts to issue SQL statements following the SQLCODE -924 will cause unpredictable results.
SQLSTATE
58006
Parent topic: SQL error codes
|
next time read the manual Yourself and speak to Your support
The 'function-code' and 'return-code' will provide to Your support the info needed to fix the problem |
|
Back to top |
|
|
don.leahy
Active Member
Joined: 06 Jul 2010 Posts: 765 Location: Whitby, ON, Canada
|
|
|
|
Is this the first ever use of DB2 by this transaction? If so, then the IMS region it runs it may not be set up to connect to DB2. Talk to your IMS sysprog.
Are the subroutines statically linked? If so the incorrect DB2 attachment facility may have been linked into the subroutine. |
|
Back to top |
|
|
|