IBM Mainframe Forum

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.

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 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.

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

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.

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.