IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Encountered a DB2 SQL return code -923


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
krishnasaikiah

New User


Joined: 14 Mar 2007
Posts: 24
Location: gurgaon

PostPosted: Tue Mar 04, 2008 5:10 pm
Reply with quote

Hi all,

I have encountered a DB2 SQL return code -923 while trying to insert records in a table.
Please let me know the solution of this abend and the actual cause and what exactly can be the probable solutin.
Back to top
View user's profile Send private message
acevedo

Active User


Joined: 11 May 2005
Posts: 344
Location: Spain

PostPosted: Tue Mar 04, 2008 5:13 pm
Reply with quote

Quote:
DSNT408I SQLCODE = -923, ERROR: CONNECTION NOT ESTABLISHED: DB2 , REASON , TYPE , NAME
DSNT415I SQLERRP = SQL PROCEDURE DETECTING ERROR
Back to top
View user's profile Send private message
krishnasaikiah

New User


Joined: 14 Mar 2007
Posts: 24
Location: gurgaon

PostPosted: Tue Mar 04, 2008 6:35 pm
Reply with quote

what needs to be checked in this case?
A flaw in the logic ?????
Back to top
View user's profile Send private message
acevedo

Active User


Joined: 11 May 2005
Posts: 344
Location: Spain

PostPosted: Tue Mar 04, 2008 6:46 pm
Reply with quote

search for -923 in the DB2 forum.
;)
Back to top
View user's profile Send private message
acevedo

Active User


Joined: 11 May 2005
Posts: 344
Location: Spain

PostPosted: Tue Mar 04, 2008 6:48 pm
Reply with quote

maybe you have not BIND the plan or using a db2 batch program without IKJEFT01?
Back to top
View user's profile Send private message
krishnasaikiah

New User


Joined: 14 Mar 2007
Posts: 24
Location: gurgaon

PostPosted: Tue Mar 04, 2008 8:27 pm
Reply with quote

I have bind the plan and i am using IKJEFT01.

Can it be because the job has run for twelve long hours???
Back to top
View user's profile Send private message
socker_dad

Active User


Joined: 05 Dec 2006
Posts: 177
Location: Seattle, WA

PostPosted: Tue Mar 04, 2008 9:40 pm
Reply with quote

12 hours????

How many records are you trying to insert? A million should be loaded in less than a minute or two!


You have very serious logic errors here.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts run rexx code with jcl CLIST & REXX 15
No new posts Compile rexx code with jcl CLIST & REXX 6
No new posts Return codes-Normal & Abnormal te... JCL & VSAM 7
No new posts REXX code to expand copybook in a cob... CLIST & REXX 2
No new posts VSAM return code 23 - for a Random read COBOL Programming 4
Search our Forums:

Back to Top