TSM instrumentation give statistics on the database usage. And for all threads.
Started using server command:
INSTrumentation Begin [MAXThread=nnnnn]
Stopped using server command:
INSTrumentation End
Output generated when instrumentation is stopped
Use the command line administrative client
dsmadmc -id=id -pass=pass inst begin dsmadmc -id=id -pass=pass inst end > filename
Use command redirection with storage agents
dsmadmc -id=id -pass=pass agentname: inst begin dsmadmc -id=id -pass=pass agentname: inst end > filename
Notes:
Administrator must have system privilege
| Disk Read | - reading from disk |
| Disk Write | - writing to disk |
| Disk Commit | - fsync or other system call to ensure writes are complete |
| Tape Read | - reading from tape |
| Tape Write | - writing to tape |
| Tape Locate | - locating to a tape block |
| Tape Commit | - tape synchronization to ensure data written from device buffers to media |
| Tape Data Copy | - copying data to tape buffers ( in memory) |
| Tape Misc | - other tape operations (open, rewind, …) |
| Data Copy | - copying data to various buffers (in memory) |
| Network Recv | - receiving data on a network |
| Network Send | - sending data on a network |
| Shmem Read | - reading data from shared memory buffer |
| Shmem Write | - writing data to shared memory buffer |
| Shmem Copy | - copying data to/from shared memory segment |
| Namedpipe Recv | - receiving data on a named pipe |
| Namedpipe Send | - sending data on a named pipe |
| CRC Processing | - computing or comparing CRC values |
| Tm Lock Wait | - acquiring transaction manager lock |
| Acquire Latch | - acquiring a database page (from disk or bufferpool) |
| Thread Wait | - waiting on some other thread |
| Unknown | - something not tracked above |
Identifies elapsed time spent performing certain activities
Enabled using:
dsmc -testflag=instrument:detail (command line) testflag instrument:detail (options file)
Output is appended to a file in the directory specified in DSM_LOG
| Process Dirs | - scanning for files to back up |
| Solve Tree | - determining directory structure |
| Compute | - computing throughput, compression ratio |
| BeginTxn Verb | - building transactions |
| Transaction | - file open, close, other misc. operations |
| File I/O | - file read, write |
| Compression | - compressing, uncompressing data |
| Encryption | - encrypting, decrypting data |
| CRC | - computing, comparing CRC values |
| Delta | - adaptive subfile back up processing |
| Data Verb | - sending, receiving data to/from the server |
| Confirm Verb | - response time during backup for server confirm verb |
| EndTxn Verb | - server transaction commit and tape synchronization |
| Other | - everything else |