Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist 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: 10326
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
This topic is locked: you cannot edit posts or make replies. 00D3003B - time outs in DB2 when invo... chavinash2004 DB2 2 Mon Oct 09, 2017 4:39 pm
No new posts VSAM RLS Wait time blayek JCL & VSAM 2 Mon Oct 02, 2017 9:05 pm
No new posts Comparing 2 Files using Current time arunsoods SYNCSORT 9 Fri Sep 22, 2017 6:00 pm
No new posts Regarding time parameter shanthi gude JCL & VSAM 7 Mon Sep 04, 2017 2:31 pm
No new posts C03 ABEND sjiraga PL/I & Assembler 1 Thu Jun 01, 2017 4:51 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us