How to identify IDB2 exceptions?

Products

• Database Management for DB2 for z/OS - Administration Suite
• Database Management for DB2 for z/OS - Performance Suite
• Database Management for DB2 for z/OS - Recovery Suite
• Database Management for DB2 for z/OS - SQL Performance Suite
• Database Management for DB2 for z/OS - Utilities Suite

Issue/Introduction

One of the DSNTEP2 jobs terminated and the following messages were in the log:
SYSZ     23172 17:07:57.43 STC01831 00000290  TERM LONG RUNNING THREAD
SYSZ     23172 17:07:57.43 STC01831 00000090  IEE305I TERM     COMMAND INVALID
SYSZ     23172 17:07:57.43          00000090  DBG72098I DM21 17:07:57 INVOKING PTT COMMAND FOR EXCEPTION
SYSZ     23172 17:07:57.43          00000090  DBG72036I DM21 17:07:57 PTT CMD: CANCEL PLAN=DSNTEP2 CONN=BATCH
                                              AUTH=XXXXXX CORR=XXXXXXX ACE=1299AD20 TOKEN= 76087
SYSZ     23172 17:07:57.43          00000090  DBG72112I DM21 17:07:57 EXCEPTION: High "IN DB2" time: PLAN=DSNTEP2 ,
                                              AUTH=XXXXXX , CONN=BATCH , CORR=XXXXXXX , Resp= 10.1
SYSZ     23172 17:07:57.45 STC01820 00000291  ARC0581I ON-DEMAND MIGRATION ENDED SUCCESSFULLY AT 090
                                090 00000291  ARC0581I (CONT.) 17:07:57 ON 2023/06/21
SYSZ     23172 17:07:57.48 STC01831 00000290  PTT1098I THE FOLLOWING COMMAND EXECUTED AT 17:07:57 ON 2023-06-21 BY
                                              USER IDB2PC   JOB IDB2DM21 SYSTEM SYSZ     FOR DM21.
SYSZ     23172 17:07:57.55 STC01831 00000290  PTT1036I INPUT: CANCEL PLAN=DSNTEP2 CONN=BATCH AUTH=XXXXXX CORR=XXXXXX
                                              1 ACE=1299AD20 TOKEN= 76087
SYSZ     23172 17:07:57.62 STC01831 00000290  PTT1063I EXECUTING DB2 COMMAND: -CANCEL THREAD(   76087)
SYSZ     23172 17:07:57.72 STC01831 00000290  PTT1061I DSNV426I  -DM21 DSNVCT THREAD '76087' HAS BEEN CANCELED
SYSZ     23172 17:07:57.76 STC01831 00000290  PTT1030I CANCEL(CMD) ISSUED FOR THREAD TOKEN=76087
SYSZ     23172 17:07:57.76          00000090  DBG72034I DM21 17:07:57 PTT API RETURNED RC=        0 RSN=        0
SYSZ     23172 17:07:58.36 STC01818 00000291  DSN3201I  -DM21 ABNORMAL EOT IN PROGRESS FOR 097
                                097 00000291  USER=XXXXXX CONNECTION-ID=BATCH CORRELATION-ID=XXXXXXX
                                097 00000291  JOBNAME=XXXXXXX ASID=004F TCB=009A3528

Message indicates this:

DBG72112I EXCEPTION: exception text

Reason:

This message identifies the exception that has been triggered and defined to invoke Thread Termination/Dynamic DSNZPARM.

Where to find those exception definitions and how to control them?

 

Environment

Release : 20.0

Resolution

 AUTH=XXXXXX , CONN=BATCH , CORR=XXXXXXX , Resp= 10.1 The Exceptions are part of IDB2(Insight Performance for Db2) options 9 and 0 from IDB2 Main Menu.