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
 
00D3003B - time outs in DB2 when invoking from java screen

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

New User


Joined: 30 Jun 2010
Posts: 14
Location: hyderabad

PostPosted: Mon Oct 09, 2017 4:39 pm    Post subject: 00D3003B - time outs in DB2 when invoking from java screen
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: 1932
Location: UK

PostPosted: Mon Oct 09, 2017 5:08 pm    Post subject:
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: 1932
Location: UK

PostPosted: Mon Oct 09, 2017 5:14 pm    Post subject:
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.    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 Comparision with current time arunsoods DFSORT/ICETOOL 5 Thu Nov 09, 2017 10:37 am
This topic is locked: you cannot edit posts or make replies. Comparing current time with the time ... arunsoods SYNCSORT 1 Mon Oct 30, 2017 4:07 pm
This topic is locked: you cannot edit posts or make replies. Incrementing current time field by 30... arunsoods DFSORT/ICETOOL 11 Thu Oct 26, 2017 3:22 pm
No new posts VSAM RLS Wait time blayek JCL & VSAM 2 Mon Oct 02, 2017 9:05 pm
No new posts Partial color change of a field in CI... waseem0424 CICS 5 Fri Sep 29, 2017 7:56 pm

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