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



IBM's flagship relational database management system

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

Postby chavinash2004 » Fri Oct 06, 2017 4:16 pm

Hi Team,

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. Thanks in advance.
You do not have the required permissions to view the files attached to this post.
chavinash2004
 
Posts: 4
Joined: Tue Apr 26, 2011 1:46 pm
Has thanked: 0 time
Been thanked: 0 time

Re: 00D3003B - time outs in DB2 when invoking from java scre

Postby NicC » Fri Oct 06, 2017 4:35 pm

What has this to do with Easytrieve?

Please do not post attachments - a simple cut'n'paste will do, is quicker and takes less storage.
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
NicC
Global moderator
 
Posts: 3025
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisies (almost)
Has thanked: 4 times
Been thanked: 136 times

Re: 00D3003B - time outs in DB2 when invoking from java scre

Postby Robert Sample » Fri Oct 06, 2017 6:44 pm

The manual gives two possible reasons for the 00D3003B, but you only mentioned one possible value; ATTRIBUTE2 could be causing your problem.
00D3003B
Explanation
A distributed thread was canceled because one of the following values was exceeded:

The idle thread timeout value that is specified by DB2® subsystem parameter IDTHTOIN in macro DSN6FAC
The ATTRIBUTE2 value in a row with KEYWORD value MONITOR IDLE THREADS in the SYSIBM.DSN_PROFILE_ATTRIBUTES table, for a profile that monitors the thread

It does not appear that you have investigated enough. Furthermore, you need to get your site support group to perform the actions in the manual under System programmer response.
Robert Sample
Global moderator
 
Posts: 3720
Joined: Sat Dec 19, 2009 8:32 pm
Location: Dubuque, Iowa, USA
Has thanked: 1 time
Been thanked: 279 times

Re: 00D3003B - time outs in DB2 when invoking from java scre

Postby chavinash2004 » Mon Oct 09, 2017 5:11 pm

Thanks Nic. Will follow the same.

Hi Robert,

Please find the details below. Once more thing here is when we try to fetch data for larger vendors (User with more data). Please help us to resolve this issue thanks in advance.

CMD: ________
COLUMN: ATTRIBUTE2
TABLE: DSN_PROFILE_ATTRIBUTES
:
COLNO: 4 OF 7 TYPE: TABLE
OWNER: SYSIBM CREATEDBY: USERID

COLTYPE: INTEGER NULLS : Y
LENGTH : 4 UPDATES: Y PERIOD : N/A
SCALE : 0 DEFAULT: Y COLCARD : N/A
KEYSEQ : 0 FLDPROC: N SUBTYPE :
SCHEMA : SYSIBM TYPENAME: INTEGER SRC TYPE: BUILT-IN
LENGTH2: 0 COLSTATUS: COMPLETE
HIGH2KEY :
LOW2KEY :
STATSTIME: CREATEDTS: 2016-04-17-00.45.20.494243
ALTEREDTS: 2016-04-17-00.45.20.494243
HIDDEN : N STATS FORM: N/A RELCREATED: DB2v10
CCSID : 0 PARTKEY SEQ: N/A PARTKEY ORD: N/A

SECTIONS REQUIRING FULL DETAIL HAVE BEEN BYPASSED
chavinash2004
 
Posts: 4
Joined: Tue Apr 26, 2011 1:46 pm
Has thanked: 0 time
Been thanked: 0 time

Re: 00D3003B - time outs in DB2 when invoking from java scre

Postby Robert Sample » Mon Oct 09, 2017 5:15 pm

Why are you telling me anything? As I said in my previous post, CONTACT YOUR SITE SUPPORT GROUP! They are the ones that can help you.
Robert Sample
Global moderator
 
Posts: 3720
Joined: Sat Dec 19, 2009 8:32 pm
Location: Dubuque, Iowa, USA
Has thanked: 1 time
Been thanked: 279 times

Re: 00D3003B - time outs in DB2 when invoking from java scre

Postby NicC » Mon Oct 09, 2017 5:16 pm

You post in the wrong sections, you post on multiple forums, you do not use the code tags, you do not take the advice offered. LOCKED.
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
NicC
Global moderator
 
Posts: 3025
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisies (almost)
Has thanked: 4 times
Been thanked: 136 times


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post