How / Where to code a START TRACE cmmand at startup?
book
Article ID: 145393
calendar_today
Updated On:
Products
SYSVIEW Performance Management Option for DB2 for z/OSDatabase Management for DB2 for z/OS - Performance SuiteDatabase Management for DB2 for z/OS - SQL Performance SuiteInsight 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.