By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,558 Members | 1,068 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,558 IT Pros & Developers. It's quick & easy.

IDTHTOIN

P: n/a
How could I set this parameter?

Does this parameter only release connecttion that ended abnormally?
I just want that locks belonging to a "crashed" connection be removed;
does this parameter will do that?

Thanks
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Hello,

assuming you're on DB2 for OS/390 and z/OS:

This parm can be set in the DSN6FAC section of your DSNZPARM assembly and
link job (usually found in "db2prefix.SDSNSAMP(DSNTIJUZ)"). You must run
this job and either recycle DB2 or issue the SET SYSPARM-command afterwards
to make DB2 pick up the new values.

The value you give there for IDTHTOIN means the seconds until an idle
DDF-thread will be timed out and terminated, so this should exactly do what
you want. But be aware, that "innocent" threads that do not hold any locks
will also be terminated, if they do nothing for longer than the specified
period. You may circumvent this collateral damage by simultaneously setting
the parm CMTSTAT to INACTIVE, so that well-behaving idle threads that do not
hold any locks will be set to a state that prevents them from being timed
out.

Cheers - Walter SCHNEIDER.

"worky" <wo***@netcourrier.com> schrieb im Newsbeitrag
news:36**************************@posting.google.c om...
How could I set this parameter?

Does this parameter only release connecttion that ended abnormally?
I just want that locks belonging to a "crashed" connection be removed;
does this parameter will do that?

Thanks

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.