View previous topic :: View next topic
|
Author |
Message |
krishnasaikiah
New User
Joined: 14 Mar 2007 Posts: 24 Location: gurgaon
|
|
|
|
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 |
|
|
acevedo
Active User
Joined: 11 May 2005 Posts: 344 Location: Spain
|
|
|
|
Quote: |
DSNT408I SQLCODE = -923, ERROR: CONNECTION NOT ESTABLISHED: DB2 , REASON , TYPE , NAME
DSNT415I SQLERRP = SQL PROCEDURE DETECTING ERROR |
|
|
Back to top |
|
|
krishnasaikiah
New User
Joined: 14 Mar 2007 Posts: 24 Location: gurgaon
|
|
|
|
what needs to be checked in this case?
A flaw in the logic ????? |
|
Back to top |
|
|
acevedo
Active User
Joined: 11 May 2005 Posts: 344 Location: Spain
|
|
|
|
search for -923 in the DB2 forum.
;) |
|
Back to top |
|
|
acevedo
Active User
Joined: 11 May 2005 Posts: 344 Location: Spain
|
|
|
|
maybe you have not BIND the plan or using a db2 batch program without IKJEFT01? |
|
Back to top |
|
|
krishnasaikiah
New User
Joined: 14 Mar 2007 Posts: 24 Location: gurgaon
|
|
|
|
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 |
|
|
socker_dad
Active User
Joined: 05 Dec 2006 Posts: 177 Location: Seattle, WA
|
|
|
|
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 |
|
|
|