Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

SQLCODE = -4499, SQLSTATE = null

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
darakhshan

New User


Joined: 03 Mar 2008
Posts: 32
Location: India

PostPosted: Thu Jul 10, 2008 7:05 pm    Post subject: SQLCODE = -4499, SQLSTATE = null
Reply with quote

I'm getting this abend while running an SP

Abend occurred in DB2, Driver successfully retry, SQLCODE = -4499, SQLSTATE = null

can anyone please tell me what the reason is??
Back to top
View user's profile Send private message

ashimer

Active Member


Joined: 13 Feb 2004
Posts: 551
Location: Bangalore

PostPosted: Thu Jul 10, 2008 7:13 pm    Post subject:
Reply with quote

What message did you get along with this ? if it is communicatio error chk your driver ....
Back to top
View user's profile Send private message
darakhshan

New User


Joined: 03 Mar 2008
Posts: 32
Location: India

PostPosted: Thu Jul 10, 2008 7:19 pm    Post subject:
Reply with quote

error tokens = signal:18,acode:0004E000,reas:00E50013,con:26F0E7B8,tcb:26A99F48


i'm getting this message only for this SP.. not others.. so i doubt if its a driver issue..
Back to top
View user's profile Send private message
ascelepius

New User


Joined: 16 Jun 2008
Posts: 35
Location: bangalore

PostPosted: Thu Jul 10, 2008 8:18 pm    Post subject: Reply to: SQLCODE = -4499, SQLSTATE = null
Reply with quote

Okay...

Heres something from Messages & Codes(for V8)

Quote:
-4499 text-from-getMessage

Explanation: A fatal error occurred that resulted in a disconnect from the data source. The existing connection has become unusable.

User response: Call SQLException.getMessage to retrieve specific information about the problem.


and from your reason code,
Quote:

0E50013
Explanation:

A DB2 execution unit has been abended. This abend code must ultimately be issued by resource managers when the CANCEL exit is driven as a result of a suspend request.

This abend reason code is issued by the following CSECTs:
DSNVEUS1
DSNVDST0
DSNVXLT0

DSNVEUS3
DSNVFEB

DSNVASTM
DSNVSLT0

DSNVCST0
DSNVSUL0
System action:

The agent cancel processing continues.
Operator response:

Notify the system programmer only if the abend results in the termination of the DB2 subsystem.
System programmer response:

This reason code may be issued as a result of any connected TCB abend, or operator -STOP DB2 MODE(FORCE) command. No further action is required.

The recovery routine for the CSECT issuing this reason code records information in the variable recording area (VRA). If you suspect an error in DB2, refer to Part 2 of DB2 Diagnosis Guide and Reference for information on identifying and reporting the problem.


If this error only occurs for this SP, check if an operator has CANCELed your thread or if someone has STOPed your Procedure... I cant think of any other reason...
Back to top
View user's profile Send private message
darakhshan

New User


Joined: 03 Mar 2008
Posts: 32
Location: India

PostPosted: Fri Jul 11, 2008 1:20 pm    Post subject:
Reply with quote

Hi All..

Thanks for the responses. The problem with the SP was resolved. This was happening because there was an infinite loop in the program that was continuously causing inserts into the database. The database was getting suspended because the connection was expiring.

Thanks again.
Back to top
View user's profile Send private message
ascelepius

New User


Joined: 16 Jun 2008
Posts: 35
Location: bangalore

PostPosted: Fri Jul 11, 2008 2:16 pm    Post subject: Reply to: SQLCODE = -4499, SQLSTATE = null
Reply with quote

Wonderful! Nice to know its resolved icon_smile.gif
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Fileaid Update Replace with null string descann Compuware & Other Tools 4 Mon May 15, 2017 3:00 pm
No new posts DB2 SQL Error: SQLCODE=-440, SQLSTATE... kishpra DB2 1 Sat Feb 18, 2017 2:31 am
No new posts VALIDATE NULL VALUE IN DB2 CASE STATE... useit DB2 5 Thu Feb 09, 2017 4:34 pm
No new posts Syncsort - NULL in Integer field chec... nartcr SYNCSORT 4 Thu Oct 06, 2016 6:47 am
No new posts Converting NULL column into NOT NULL ... Raghu navaikulam DB2 5 Sat Aug 06, 2016 3:45 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us