View previous topic :: View next topic
|
Author |
Message |
tarun_bhardwaj
New User
Joined: 18 Jul 2003 Posts: 39 Location: delhi
|
|
|
|
Iam unable to find the exact cause of -901 SQL error. The SQL guide says "UNSUCCESSFUL EXECUTION CAUSED BY A SYSTEM ERROR THAT DOES NOT PRECLUDE THE SUCCESSFUL EXECUTION OF SUBSEQUENT SQL STATEMENTS".
Could someone please elaborate on this or tell me the exact reason for -901?
Thanks in advance. |
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
I would start by looking at the sql that received the -901.
manual says something about 0 length sql statements
and sql statements that exceed the maximum length. |
|
Back to top |
|
|
tarun_bhardwaj
New User
Joined: 18 Jul 2003 Posts: 39 Location: delhi
|
|
|
|
Thanks for your reply Dick.
We are at DB2 ver 8.1 . The problem is encountered when a commit statement is executed after an update statement in batch but the same query runs fine in an online scenario. Also, the update/commit statements work fine at times and fails with -901 at times. This seems to be a DB2 system problem. I suppose the a ticket needs to be opened with IBM in this regard so that they can provide an appropriate PTF to fix this. Please correct me if Iam wrong.
Thanks in advance. |
|
Back to top |
|
|
|