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