How / Where to code a START TRACE cmmand at startup?

book

Article ID: 145393

calendar_today

Updated On:

Products

CA Sysview Performance Management Option for DB2 for z/OS CA Database Management for DB2 for z/OS - Performance Suite CA Database Management for DB2 for z/OS - SQL Performance Suite CA-Insight Performance Monitor for DB2 UDB for z/OS

Issue/Introduction

Where(SYSP, IDDCPRMS, DC job,...) in IDB2 can you start some traces at Collector startup? What is the format?

Environment

Release : 20.0

Component : CA Insight Database Performance Monitor for DB for z/OS

Resolution

IDB2 doesn't have anything like that but starts its own traces and they look like this:

DSNW130I  !DT11 MON TRACE STARTED, ASSIGNED TRACE NUMBER 03
DSN9022I  !DT11 DSNWVCM1 '-START TRACE' NORMAL COMPLETION
DBG37003I DT11 21:53:09 START TRACE FOR DEST(OPX) ISSUED TO DB2 SUBSYSTEM DT11
 
DSNW130I  !DT11 MON TRACE STARTED, ASSIGNED TRACE NUMBER 04
DSN9022I  !DT11 DSNWVCM1 '-START TRACE' NORMAL COMPLETION
DBG76022I DT11 21:53:13         0 BLOCKS  READ FROM INPUT FILE DB2DDN  .
DBG76021I DT11 21:53:13         0 RECORDS READ FROM INPUT FILE DB2DDN  .
DSNW130I  !DT11 MON TRACE STARTED, ASSIGNED TRACE NUMBER 03
DSN9022I  !DT11 DSNWVCM1 '-MODIFY TRACE' NORMAL COMPLETION
DSNW130I  !DT11 MON TRACE STARTED, ASSIGNED TRACE NUMBER 03
DSN9022I  !DT11 DSNWVCM1 '-MODIFY TRACE' NORMAL COMPLETION
DSNW130I  !DT11 MON TRACE STARTED, ASSIGNED TRACE NUMBER 03
DSN9022I  !DT11 DSNWVCM1 '-MODIFY TRACE' NORMAL COMPLETION
DSNW130I  !DT11 MON TRACE STARTED, ASSIGNED TRACE NUMBER 03
DSN9022I  !DT11 DSNWVCM1 '-MODIFY TRACE' NORMAL COMPLETION
DSNW130I  !DT11 MON TRACE STARTED, ASSIGNED TRACE NUMBER 03
DSN9022I  !DT11 DSNWVCM1 '-MODIFY TRACE' NORMAL COMPLETION
DSNW130I  !DT11 MON TRACE STARTED, ASSIGNED TRACE NUMBER 03
DSN9022I  !DT11 DSNWVCM1 '-MODIFY TRACE' NORMAL COMPLETION
DSNW130I  !DT11 MON TRACE STARTED, ASSIGNED TRACE NUMBER 03
DSN9022I  !DT11 DSNWVCM1 '-MODIFY TRACE' NORMAL COMPLETION
DSNW130I  !DT11 MON TRACE STARTED, ASSIGNED TRACE NUMBER 03
DSN9022I  !DT11 DSNWVCM1 '-MODIFY TRACE' NORMAL COMPLETION
Start traces would be more under the category of Automated Ops. You would want to tie it to the startup of DB2.