INSTRUMENTATION BEGIN

Edit online

Use this command to start server instrumentation.

Privilege class

You must have system privilege to start server instrumentation.

Syntax

Read syntax diagramSkip visual syntax diagramINSTrumentation Begin MAXThread=nnnnn COLLECTStmt=FalseCOLLECTStmt=FalseTrue

Parameters

MAXThread
Specifies the maximum number of threads that you want to trace. The default is 4096. If more than 4096 threads might be running during the instrumentation interval, raise this value. The maximum number of threads that you can run is 100,000. The minimum number of threads that you can run is 512.
COLLECTStmt
Collects detailed information on SQL commands, especially SQL commands that take a long time to run. The default value is FALSE. If you suspect that the Db2 program that is the database manager for the server is causing the problem, change this value to TRUE.

Example: Start server instrumentation at the administrative command-line client

Start an administrative client session in command-line mode, and begin collecting data. Use a credentials file that is named secretpwdfile.

dsmadmc -credentialsfile=secretpwdfile instrumentation begin

Example: Use command redirection to start server instrumentation for a storage agent

Start server instrumentation on storage agent StgAgnt_375.

dsmadmc -credentialsfile=secretpwdfile
StgAgnt_375:instrumentation begin