Facing -901 SQL error

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.

dbzTHEdinosauer · Posted: Tue Jun 09, 2009 3:41 pm

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.

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.