| View previous topic :: View next topic |
| Author |
Message |
gupta
Beginner
Joined: 12 Feb 2005
Posts: 27
Topics: 15
|
 Posted: Wed Sep 20, 2006 4:53 am Post subject: -924 occurs too often |
 |
|
Hi,
Can you please let me know the cause for the following problem and how it can be rectified as i am getting them too often.
08I SQLCODE = -924, ERROR: DB2 CONNECTION INTERNAL ERROR, 0001, 0100, 00F30016
18I SQLSTATE = 58006 SQLSTATE RETURN CODE
15I SQLERRP = DSNAET03 SQL PROCEDURE DETECTING ERROR
Thanks a lot,
Gupta |
|
| Back to top |
|
 |
acevedo
Beginner
Joined: 03 Dec 2002
Posts: 127
Topics: 0
Location: Europe
|
| Posted: Wed Sep 20, 2006 5:24 am Post subject: |
|
|
| I would as your dba (presuming you're not..) |
|
| Back to top |
|
|
acevedo
Beginner
Joined: 03 Dec 2002
Posts: 127
Topics: 0
Location: Europe
|
| Posted: Wed Sep 20, 2006 5:25 am Post subject: |
|
|
I meant: I would asK your dba.
 |
|
| Back to top |
|
|
shekar123
Advanced
Joined: 22 Jul 2005
Posts: 528
Topics: 90
Location: Bangalore India
|
| Posted: Wed Sep 20, 2006 7:42 am Post subject: |
|
|
gupta,
I am pasting the info from the manuals:
| Code: |
In you case Function code : 0001,
Return code : 0100,
Reason code : 00F30016
-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 Part 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.
SQLSTATE: 58006
00F30016
Explanation: The attachment facility specified an
invalid FRBRALE value. The value is outside the limits
of those supported for the requesting connection. This
can occur in many cases, one of which is when an SQL
call is requested with a blank plan name by the
requester.
This reason code is issued by the following CSECT:
DSNAPRHX
System Action: The request is not processed.
User Response: A dump should be taken for problem
analysis.
System Programmer Response: Obtain all dumps
taken by the attachment facility and requesting
application.
Problem Determination: Register 1 contains a pointer
to the FRB at the entry to DSNAPRHX. FRBRALE
contains the invalid value that was passed. The value
passed is not consistent with the resources allocated to
the connected application.
If the plan name contains blanks, an SQL call is invalid.
The requester should respecify the plan name and issue
the request again.
|
_________________
Shekar
Grow Technically |
|
| Back to top |
|
|
|
|
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
