467,118 Members | 916 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,118 developers. It's quick & easy.

IDTHTOIN

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
  • viewed: 3812
Share:
1 Reply
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.

By using this site, you agree to our Privacy Policy and Terms of Use.