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
 

 

Encountered a DB2 SQL return code -923

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
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    Post subject: Encountered a DB2 SQL return code -923
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    Post subject:
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    Post subject:
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    Post subject:
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    Post subject:
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    Post subject:
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: 147
Location: Columbia, MO

PostPosted: Tue Mar 04, 2008 9:40 pm    Post subject: Reply to: Encountered a DB2 SQL return code -923
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    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 EXIT or RETURN cvnlynn CLIST & REXX 9 Wed Jul 19, 2017 2:50 am
No new posts UNIT=AFF for Easytrieve code gandikk JCL & VSAM 7 Wed Jul 12, 2017 11:42 pm
No new posts DB2 Program abending without giving a... rahulgarg14 DB2 7 Mon May 29, 2017 8:10 pm
No new posts Job failing with USER = 4093 REASON C... Pradeepa S ABENDS & Debugging 1 Wed May 17, 2017 3:35 pm
No new posts COBOL Code Parsers and Lineage Establ... balimanja COBOL Programming 2 Tue May 02, 2017 3:30 am


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