View previous topic :: View next topic
|
Author |
Message |
vimalonline Warnings : 1 New User
Joined: 08 Apr 2006 Posts: 14 Location: In front of my PC
|
|
|
|
Hi,
Consider the scenario, we have two LPARS namely TSOA1 and TSOB1.
DB subsystem DB2A is connected with TSOA1 and DB2B is connected with TSOB1.
I could successfully query the table in DB2A from TSOA1. But when i try to execute the same REXX from TSOB1, am getting -924.
Is there any way to overcome this problem in REXX.
Kindly help me in this regard. |
|
Back to top |
|
|
William Thompson
Global Moderator
Joined: 18 Nov 2006 Posts: 3156 Location: Tucson AZ
|
|
|
|
Did you look up the error in the Fine Manual?
-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 executed. The connection to DB2 is not established.
Programmer Response: Look up the abend 'reason-code' in Section 4. DB2 Codes for further information. 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. |
|
Back to top |
|
|
vimalonline Warnings : 1 New User
Joined: 08 Apr 2006 Posts: 14 Location: In front of my PC
|
|
|
|
William Thompson wrote: |
Did you look up the error in the Fine Manual?
-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 executed. The connection to DB2 is not established.
Programmer Response: Look up the abend 'reason-code' in Section 4. DB2 Codes for further information. 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. |
itz showing -924 since am quering the table which is in another LPAR. is there any commands lik SCHENV in REXX so i can make the REXX to execute in another LPAR.. |
|
Back to top |
|
|
William Thompson
Global Moderator
Joined: 18 Nov 2006 Posts: 3156 Location: Tucson AZ
|
|
|
|
OK, in plain talk....
What was the reason-code?
What does Section 4. DB2 Codes say about it?
Does the function-code and return-code provide any additional information? |
|
Back to top |
|
|
avaneendra_linga
New User
Joined: 13 Dec 2006 Posts: 73 Location: Hyderabad
|
|
|
|
vimal me too getting the same problem....if you got the solution can you please let me know..? |
|
Back to top |
|
|
sathya.P
New User
Joined: 17 Sep 2007 Posts: 6 Location: chennai
|
|
|
|
Hi All,
I too got the same error when i moved the db2 program to test region.
Their may problem with the bind process.
The thing this we need to check for the PLAN name which need to be same has the name of the program.
then need to rebind it.then try.
This wat i did.I execute the program successfully....& am sry if it was wrong.!!!!!!!!!
Thanks,
Sathya.P |
|
Back to top |
|
|
Escapa
Senior Member
Joined: 16 Feb 2007 Posts: 1399 Location: IL, USA
|
|
|
|
Quote: |
Posted: Tue May 08, 2007 11:17 am Post subject:
--------------------------------------------------------------------------------
vimal me too getting the same problem....if you got the solution can you please let me know..? |
Sathya wrote: |
The thing this we need to check for the PLAN name which need to be same has the name of the program.
then need to rebind it.then try.
This wat i did.I execute the program successfully....& am sry if it was wrong.!!!!!!!!!
|
What you are saying may not be wrong but I pray your message will reach to one who has posted this problem in may 2007 |
|
Back to top |
|
|
|