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
 

 

SQLCODE=-911 and it is Time out abend

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
sriram.mukundan

New User


Joined: 20 Nov 2007
Posts: 28
Location: chennai

PostPosted: Thu Jun 26, 2008 10:56 am    Post subject: SQLCODE=-911 and it is Time out abend
Reply with quote

HI all,

I have a table which has only 2 rows.
i want to delete the Rows in the table. We identified this is due to Timeout because as the Reason code is 00C9008E.

So kindly let me know how to over come this problem.
Back to top
View user's profile Send private message

Sinkaravelan S

New User


Joined: 21 Apr 2008
Posts: 27
Location: coimbatore-TN india

PostPosted: Thu Jun 26, 2008 11:19 am    Post subject: Reply to: SQLCODE=-911 and it is Time out abend
Reply with quote

00C9008E
Explanation:
A lock request for the resource identified by NAME could not be granted, and the request waited for a period longer than the maximum specified by the installation.

Troubleshooting

Error SQL0913N Received: Unsuccessful execution caused by deadlock or timeout
There is a known problem that most often occurs when running one of the DYK ETL processes against a IBM Tivoli Service Level Advisor database that is located on a DB2 for z/OS operating system. The ETL step fails with a message that indicates a deadlock or timeout condition has occurred. The message is similar to the following example:

CDWEX8087E A general SQL error occurred: SQL_ERROR: 'ExecDirect' 2004.06.04


10:52:30.718 sqlState = 57033, nativeErr = -913, errorMsg = [IBM][CLI Driver][DB2]


SQL0913N Unsuccessful execution caused by deadlock or timeout. Reason code


"00C9008E". SQLSTATE=57033

This error usually follows a drop table or a create table command. The error is typically caused by multiple outside connections to the same location, for example, connections opened through the DB2 Control Center or by DB2 command prompts. To recover from this error, close all extraneous connections other than those opened by IBM Tivoli Service Level Advisor components, and try the failed ETL step again.


Thanks,
Back to top
View user's profile Send private message
sriram.mukundan

New User


Joined: 20 Nov 2007
Posts: 28
Location: chennai

PostPosted: Thu Jun 26, 2008 11:55 am    Post subject:
Reply with quote

There is no Extraneous connections. we are doing in SPUFI not in control center or in DB2 command prompts.

FYI i have pasted the SQLCODE AND SQLSTATE below.

DSNT408I SQLCODE = -911, ERROR: THE CURRENT UNIT OF WORK HAS BEEN ROLLED BACK DUE TO DEADLOCK OR TIMEOUT.
DSNT418I SQLSTATE = 40001 SQLSTATE RETURN CODE
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10256
Location: italy

PostPosted: Thu Jun 26, 2008 1:05 pm    Post subject: Reply to: SQLCODE=-911 and it is Time out abend
Reply with quote

the message is clear, it' s a lock timeout...

the locks are being held until changes are committed.

are You running another spufi session on the same table ?

check the commit options of spufi

Quote:
Specify processing options:
5 CHANGE DEFAULTS... ===> Y (Y/N - Display SPUFI defaults panel?)
6 EDIT INPUT........ ===> Y (Y/N - Enter SQL statements?)
7 EXECUTE........... ===> Y (Y/N - Execute SQL statements?)
8 AUTOCOMMIT........ ===> Y (Y/N - Commit after successful run?)
9 BROWSE OUTPUT..... ===> Y (Y/N - Browse output data set?)


without autocommit ( IIRC )
if You run a command and leave the spufi session open the table will have locks left around for the duration of Your coffe break icon_biggrin.gif
Back to top
View user's profile Send private message
sriram.mukundan

New User


Joined: 20 Nov 2007
Posts: 28
Location: chennai

PostPosted: Thu Jun 26, 2008 2:55 pm    Post subject:
Reply with quote

Hi Enrico,

Thanks for the suggestion. Our settings in the spufi is same as you mentioned.
we didnt open the same table in another spufi session also.

Quote:
the message is clear, it' s a lock timeout...
as u mentioned. This i also know clearly.

I want a solution for this. only 2 rows exists in the table.

im not able to dop the table also. It is also givng the same issue.

Pls help regarding this.
Back to top
View user's profile Send private message
am_ne

New User


Joined: 24 Mar 2007
Posts: 25
Location: Bangalore

PostPosted: Mon Jun 30, 2008 6:39 pm    Post subject:
Reply with quote

Hi Sriram,

Did you check for any unsuccessfull utility-ids ? May be some util-id is hanging there with exclusive locks and not allowing any other connections.

If you are having DROP authority on the database then you must be having the DISPLAYDB authority.

Issue following commands to see if anything holding the tablespace.

-DIS DATABASE(databse name) SPACE(tablespace name) LOCKS

AND

-DIS DATABASE(databse name) SPACE(tablespace name) CLAIMERS

These commands will give you the current locks and the claimers information.

Thanks,
Amit
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 DSNACCOX (can it be run on 1 db/ts, t... SRICOBSAS DB2 3 Sat May 06, 2017 12:59 am
No new posts LISTIDR compiled date/time jerryte IBM Tools 3 Thu Apr 20, 2017 7:37 pm
No new posts Application not run by time HH:MM tri... jzhardy IBM Tools 1 Sun Apr 09, 2017 3:22 pm
No new posts Date and time format in CICS Chandru3183 CICS 2 Sat Mar 18, 2017 12:46 pm
No new posts How to get current date -1 and curren... murali.andaluri DFSORT/ICETOOL 3 Wed Mar 08, 2017 2:09 pm


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