Db2 for z/OS & Db2ZAI

 View Only

 Command DIS THREAD(*) SERVICE(STG)

Jump to  Best Answer
  • IBMChampion
Soledad Martinez's profile image
Soledad Martinez IBM Champion posted Wed May 07, 2025 07:21 AM

Hello Db2 people, 

I am searching information about the SERVICE parameter at the DISPLAY THREAD, and I am not able to find it.

The only reference I found is at the Commands manual, and at the DIS THREAD site examples, when showing how to display information about autonomous procedures:

19.26.27 >dis thd(*) service(stg) 
19.26.27 STC00065 DSNV401I > DISPLAY THREAD REPORT FOLLOWS -

Are there any other values other than STG for this parameter? I tried the * but ... doesn't work :-)

Thanks,

Ramon Palmé's profile image
Ramon Palmé posted Thu May 08, 2025 02:41 AM  Best Answer

Hello Sole,

In the past I always had this more than very old informational Apar II06335 in my bedside table. It addresses you the best way to cancel a Db2 (hope no)

DISPLAY THD SERVICE used to get documentation for post-mortem analysis.

Best Regards

Sergi Padró i Blasi's profile image
Sergi Padró i Blasi posted Wed May 07, 2025 07:26 AM

SERVICE(WAIT)
Displays threads that are in a long-term suspend. If a thread is suspended on a latch, the command
displays latch details, and Db2 attempts to boost the holder to relieve the latch contention. If the
thread is suspended on a lock, the command displays lock detail information.

Soledad Martinez's profile image
Soledad Martinez IBM Champion posted Wed May 07, 2025 07:46 AM

Hello Sergi, 

thanks a lot!

I now can find this SERVICE(WAIT) at this link with trouble shooting commands.

Db2 commands for troubleshooting - IBM Documentation

Thank you very much!

Soledad Martinez's profile image
Soledad Martinez IBM Champion posted Thu May 08, 2025 12:14 PM

Hola Ramón!

wow, what a relic, an APAR from the 90's, but still modified in 2020. Very interesting, From it, it also sends you to II14016 more recent, thanks for this.

Hope I don't have to use either :-)

Graciassss

Bruce Williamson's profile image
Bruce Williamson posted Thu May 08, 2025 07:28 PM

II APARs are my favourites, I have dozens bookmarked 😁
FYI: Do an APAR search for "LIB INFO" when your having a siesta to get a list o II* APARs (plus a lot of others …)

DSN Commands I use for various performance related troubleshooting are:

  • -DIS THD(*) SERVICE(STORAGE) SCOPE(GROUP) LIMIT(*) DETAIL

  • -DIS THD(*) SERVICE(WAIT) SCOPE(GROUP) LIMIT(*) DETAIL

  • -DIS THD(*) TYPE(SYSTEM) SCOPE(GROUP) LIMIT(*) DETAIL

  • -DIS THD(*) TYPE(POSTPONED)

¡Hasta luego!

Soledad Martinez's profile image
Soledad Martinez IBM Champion posted Fri May 09, 2025 03:08 AM

Hello Bruce, 

thanks for this, I will definitely add the commands to my list of lifeguards commands!

About the II Apars, I have been taking a look, but not able to find the name conventions for IBM apars, what are the II* for?

Just one point from my side, I will search for "LIB INFO" after or before the siesta but ... never during ... you know that siesta es sacred. It's just for relaxing :-)

¡Muchas gracias, Bruce! ¡Hasta Luego!

Bruce Williamson's profile image
Bruce Williamson posted Wed May 14, 2025 09:14 PM

I hear you about siesta time being sacred, as I get older I love them more ❤️

II* Are informational APARs as opposed to a potential programming error i.e. Authorized Program Analysis Report

Below is an example of the "INFO LIB" APAR search:

Results:

This is a bit of a shotgun approach but sometimes "stuff" moves or "memory" fails and then this approach may be appropriate

Soledad Martinez's profile image
Soledad Martinez IBM Champion posted Thu May 15, 2025 02:44 AM

Hello Bruce, 

great answer, even including screenshots, crystal clear :-)

Thank you very much!!!!

Bruce Williamson's profile image
Bruce Williamson posted Thu May 15, 2025 06:27 PM

As they say, a picture paints a 1,000 words 😁

Glad it was helpful

¡Hasta Luego!

Related Content