IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

00D3003B - time outs in DB2 when invoking from java screen


IBM Mainframe Forums -> DB2
Post new topic   This topic is locked: you cannot edit posts or make replies.
View previous topic :: View next topic  
Author Message
chavinash2004

New User


Joined: 30 Jun 2010
Posts: 37
Location: hyderabad

PostPosted: Mon Oct 09, 2017 4:39 pm
Reply with quote

I have posted the same few days back but due to somereason it was not showing so posting again. Please ignore if this is duplicate.

Some of our stored procedures started timing out with reason code 00D3003B on z/OS. I have looked at the IDTHTOIN is set to 1800 seconds. We are using DB2 version V10NF. Recently we have changed the stored procedures to use temporary tables. Returning result sets from a temporary table but still getting deadlock. Can any one suggest a fix to this problem? These procedures are being called from Java.

I googled it but did not find the solution. Please someone help to resolve this.

Below is issue details from DB2 master log:
Code:
09.48.35 STC12001  DSNI031I  #XTD1 DSNILKES - LOCK ESCALATION HAS  571
    571             OCCURRED FOR
    571               RESOURCE NAME =<Table Name>
    571               LOCK STATE =  S
    571               PLAN NAME : PACKAGE NAME = DISTSERV : SYSLN300
    571               COLLECTION-ID = NULLID
    571               STATEMENT NUMBER = 00000003
    571               CORRELATION-ID = db2jcc_appli
    571               CONNECTION-ID = SERVER
    571               LUW-ID = GA812A2F.C0E8.D333BC43A1BC
    571               THREAD-INFO = X0AVDPTP : gvx0lwasa01q.ahold : x0avdptp         :
    571             db2jcc_application               : DYNAMIC :                  944 :
    571             *
 09.55.19 STC12001  DSNL027I  #XTD1 SERVER DISTRIBUTED AGENT WITH  900
    900                        LUWID=GA812A30.O69E.D333BC446DC0=55151
    900
    900             THREAD-INFO=X0AVDPTP:gvx0lwasa02q.ahold:x0avdptp:db2jcc_application:*
    900             :*:*:*
    900                        RECEIVED ABEND=04E
    900                        FOR REASON=00D3003B
 09.55.19 STC12001  DSNL028I  #XTD1 GA812A30.O69E.D333BC446DC0=55151  901
    901                        ACCESSING DATA FOR
    901                          LOCATION ::<IP address>
    901                          IPADDR ::<IP address>
 10.07.19 STC12001  DSNL027I  #XTD1 SERVER DISTRIBUTED AGENT WITH  616
    616                        LUWID=GA812A30.O696.D333BC2C6CF3=55092
Back to top
View user's profile Send private message
Nic Clouston

Global Moderator


Joined: 10 May 2007
Posts: 2455
Location: Hampshire, UK

PostPosted: Mon Oct 09, 2017 5:08 pm
Reply with quote

Probably because it is a DB2 query not a DFsort query and you did not use the code tags. Moving and fixing for you.
Back to top
View user's profile Send private message
Nic Clouston

Global Moderator


Joined: 10 May 2007
Posts: 2455
Location: Hampshire, UK

PostPosted: Mon Oct 09, 2017 5:14 pm
Reply with quote

It actually got locked and later deleted because it was also posted on the beginners forum and duplicate posting is bad manners. This will also be locked.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   This topic is locked: you cannot edit posts or make replies. View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts To get the the current time DFSORT/ICETOOL 13
No new posts Calling Java method from batch COBOL ... COBOL Programming 5
No new posts RC query -Time column CA Products 3
No new posts C Compile time time stamps Java & MQSeries 10
No new posts Parallelization in CICS to reduce res... CICS 4
Search our Forums:

Back to Top