Thread Terminator messages

[BETH HENSON]

​I am trying to locate the Thread Terminator messages documentation.  Can anyone point me in the right direction?  Specifically where are the TTH* message documentation?  Thanks.

TTH0001A THREAD TERM USER=UGDS263 , TYPE=M ON 2019-10-03 AT 05.52.13, DB2=DBPB,

TTH0001B TOKEN=000000, CORR=sqlservr.exe, AUTH=UVPA24  , OPID=UVPA24  , CONNTP=

TTH0001C THREAD TERMINATION FAILED       RETURN CODE=0004, REASON=0010        

Beth Henson

------------------------------
Systems Programmer
SunTrust
Georgia
------------------------------

[Lucinda Metzger]

Hi Beth,

These are actually log identifiers in the PTTLOG record, as opposed to product messages, so they are not documented with the product messages. 

They should be documented in CA Database Management Solutions for DB2 for z/OS, under Use Thread Termination\Dynamic DSNZPARM. However, this information appears to have gone missing. I will make sure it gets reinserted into the documentation. In the meantime, here is the missing content:

TTH0001A
Indicates the log message identifier. This line contains the following information:

• THREAD TERM USER
  Indicates the ID of the user who requested the thread termination.
• TYPE
  Indicates the type of termination requested:
  - D - DB2 termination
  - M - z/OS termination
• ON
  Indicates the date of the termination request.
• AT
  Indicates the time of the termination request.
• DB2
  Indicates the DB2 subsystem ID of the thread selected for termination.
• PLAN
  Indicates the plan name of the thread selected for termination.
• CONN
  Indicates the connection ID of the thread selected for termination.

TTH0001B
Indicates the log message identifier. This line contains the following information:

• CORR
  Indicates the correlation ID of the thread selected for termination.
• AUTH
  Indicates the authorization ID of the thread selected for termination.
• OPID
  Indicates the original authorization ID of the thread selected for termination.
• CONNTP
  Indicates the connection type of the thread selected for termination.
• JOB
  Indicates the job name of the thread selected for termination.
• ASID
  Indicates the address space ID of the thread selected for termination.
• PROFILE GROUP
  Indicates the name of the termination profile group that contains the termination profile that the thread matched.
  Note: This field will only appear when the thread was terminated by the thread monitor.

TTH0001C
Indicates the log message identifier. This line contains one of the following:

• THREAD TERMINATION SUCCESSFUL
  Indicates the thread was successfully terminated or will be terminated at an appropriate checkpoint.
• THREAD TERMINATION FAILED
  Indicates the thread was not terminated. Return and reason code is provided.

For future reference, the Thread Terminator messages are documented in Messages for CA DB Management Solutions for DB2 for z/OS, under Common Message Functions. The return and reason codes are documented on that same site, under Thread Termination\Dynamic DSNZPARM Return and Reason Codes.

Regards,
Lucinda Metzger
Staff Writer

------------------------------
Staff Technical Writer
Broadcom
------------------------------

[BETH HENSON]

Thank you Lucinda!  So until this documentation is put back I cannot see what the reason code 10 is you are saying?  Beth Henson​

------------------------------
Systems Programmer
SunTrust
Georgia
------------------------------

[Lucinda Metzger]

Sorry, no, I was unclear about that. The return and reason code information is still available:

Thread Termination\Dynamic DSNZPARM Return and Reason Codes

Hope this helps!
Lucinda

------------------------------
Staff Technical Writer
Broadcom
------------------------------

[BETH HENSON]

Thanks again Lucinda.  I see the link is for R20.  The error we had was actually on R19, but it says it is not supported for R20 so I would assume not supported for R19.

10

Indicates that you requested to kill a distributed thread. That feature is not currently supported.

  ​

------------------------------
Systems Programmer
SunTrust
Georgia
------------------------------

[Lucinda Metzger]

I just checked the R19 doc, and you are correct. 

If you feel that this support should be added to Thread Terminator, you can post a request to the Ideation section of this community site, where the Product Owner will see it.

Regards,
Lucinda

------------------------------
Staff Technical Writer
Broadcom
------------------------------