One of the DSNTEP2 jobs terminated and the following messages were in the log:
XXXX 23172 17:07:57.43 STC01831 00000290 TERM LONG RUNNING THREAD
XXXX 23172 17:07:57.43 STC01831 00000090 IEE305I TERM COMMAND INVALID
XXXX 23172 17:07:57.43 00000090 DBG72098I ssid 17:07:57 INVOKING PTT COMMAND FOR EXCEPTION
XXXX 23172 17:07:57.43 00000090 DBG72036I ssid 17:07:57 PTT CMD: CANCEL PLAN=DSNTEP2 CONN=BATCH
AUTH=XXXXXX CORR=XXXXXXX ACE=1299AD20 TOKEN= 76087
XXXX 23172 17:07:57.43 00000090 DBG72112I ssid 17:07:57 EXCEPTION: High "IN DB2" time: PLAN=DSNTEP2 ,
AUTH=XXXXXX, CONN=BATCH, CORR=XXXXXXX , Resp= 10.1
XXXX 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
XXXX 23172 17:07:57.48 STC01831 00000290 PTT1098I THE FOLLOWING COMMAND EXECUTED AT 17:07:57 ON 2023-06-21 BY
USER XXXXXXXX JOB JJJJJJJJ SYSTEM XXXX FOR ssid.
XXXX 23172 17:07:57.55 STC01831 00000290 PTT1036I INPUT: CANCEL PLAN=DSNTEP2 CONN=BATCH AUTH=XXXXXX CORR=XXXXXX
1 ACE=1299AD20 TOKEN= 76087
XXXX 23172 17:07:57.62 STC01831 00000290 PTT1063I EXECUTING DB2 COMMAND: -CANCEL THREAD( 76087)
XXXX 23172 17:07:57.72 STC01831 00000290 PTT1061I DSNV426I -ssid DSNVCT THREAD '76087' HAS BEEN CANCELED
XXXX 23172 17:07:57.76 STC01831 00000290 PTT1030I CANCEL(CMD) ISSUED FOR THREAD TOKEN=76087
XXXX 23172 17:07:57.76 00000090 DBG72034I ssid 17:07:57 PTT API RETURNED RC= 0 RSN= 0
XXXX 23172 17:07:58.36 STC01818 00000291 DSN3201I -ssid 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?
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.