Server instrumentation categories
IBM Storage Protect server instrumentation can report on the elapsed times for the process categories that are documented in the table. Server instrumentation tracks all input and output on a thread-by-thread basis for the categories.
Table 1 lists the server instrumentation categories that are tracked and the activity that is timed.
| Category | Activity |
|---|---|
| Acquire Latch | The amount of time to acquire a database page from disk or a buffer pool. |
| Acquire XLatch | The amount of time to acquire a database page for update (from disk or a buffer pool). |
| Cloud Attach | The amount of time to attach a thread to the internal Oracle Java™ virtual machine (JVM) that makes Java Native Interface (JNI) method calls. |
| Cloud Close | The amount of time to close a connection to an IBM® Cloud Object Storage endpoint. |
| Cloud Connect | The amount of time to connect to an IBM Cloud Object Storage endpoint. |
| Cloud Delete | The amount of time to run an HTTP DELETE operation that deletes cloud object data. |
| Cloud Detach | The amount of time to detach a thread from the internal JVM that makes JNI method calls. |
| Cloud Stats | The amount of time to retrieve statistics that are related to the internal JVM and HTTP request methods that are used on the server. The methods can include PUT, GET, POST, and DELETE. |
| Cloud Stream | The amount of time to stream data buffers to object storage in the following
situations:
|
| Cloud Upload | The amount of time to upload a file from the cloud accelerator cache to object storage in a cloud-container storage pool. |
| Compression | The amount of time to compress data by using the LZ4 compression algorithm. |
| CRC Processing | The amount of time to compute or compare cyclic redundancy check (CRC) values in storage pools. |
| Data Copy | The amount of time to copy data to buffers in memory. |
| Db2 Commit | The amount of time to commit a Db2 transaction. |
| Db2 Connect | The amount of time to connect to a Db2 process. |
| Db2 CR Exec | The amount of time to run an SQL statement that counts rows. |
| Db2 CR Prep | The amount of time to prepare an SQL statement that counts rows. |
| Db2 Delet Exec | The amount of time for Db2 to run an SQL statement that deletes a row. |
| Db2 Delet Prep | The amount of time for Db2 to parse an SQL statement that deletes a row. |
| Db2 Fetch | The amount of time to prepare an SQL statement that retrieves one row from Db2. |
| Db2 Fetch Exec | The amount of time for Db2 to run an SQL statement that returns one row. |
| Db2 Fetch Prep | The amount of time for Db2 to prepare an SQL statement that returns one row. |
| Db2 Inser Exec | The amount of time for Db2 to run an SQL statement that inserts a row. |
| Db2 Inser Prep | The amount of time for Db2 to parse an SQL statement that inserts a row. |
| Db2 MFetch | The amount of time to prepare an SQL statement that retrieves many rows from Db2. |
| Db2 MFtch Exec | The amount of time for Db2 to run an SQL statement that returns many rows. |
| Db2 MFtch Prep | The amount of time for Db2 to prepare an SQL statement that returns many rows. |
| Db2 Reg Exec | The amount of time for Db2 to run complex SQL statements. |
| Db2 Reg Fetch | The amount of time for Db2 to retrieve rows for a complex SQL statement. |
| Db2 Reg Prep | The amount of time for Db2 to prepare complex SQL statements. |
| Db2 Rollback | The amount of time for Db2 to roll back a transaction instead of committing the transaction. |
| Db2 Updat Exec | The amount of time for Db2 to run an SQL statement that updates a row. |
| Db2 Updat Prep | The amount of time for Db2 to parse an SQL statement that updates a row. |
| Decrypt Data | The amount of time to decrypt data buffers during system-to-system communication. |
| Decrypt Final | The amount of time to decrypt the final piece of data during system-to-system communication. |
| Decrypt Init | The amount of time to initialize a system-to-system communication cipher for decryption. For example, the amount of time to initialize the AES-GCM mode of operation for decryption. |
| Disk Commit | The amount of time to run the FSYNC command or other system call to ensure that write operations are completed to disk. |
| Disk Read | The amount of time to read data from disk. |
| Disk Write | The amount of time to write data to disk. You can combine this amount with the Disk Commit amount to get the total write time. |
| DNS Lookup | The amount of time to run a system DNS lookup during TCP/IP session communication. |
| Encrypt Data | The amount of time to encrypt data buffers for system-to-system communication in a secure session. For example, sessions that use the AES-GCM mode of operation for encryption. |
| Encrypt Final | The amount of time to encrypt the final piece of data during system-to-system communication. |
| Encrypt Init | The amount of time to initialize a system-to-system communication cipher for encryption. For example, the amount of time to initialize the AES-GCM mode of operation for encryption. |
| Fingerprint | The amount of time used to find extent boundaries for data deduplication. |
| IBM C®rypto for C Digest | The amount of time to run an algorithm for data deduplication extents. |
| MD5 | The amount of time to compute the MD5 digest for a data buffer. |
| Namedpipe Recv | The amount of time to receive data on a named pipe. |
| Namedpipe Send | The amount of time to send data on a named pipe. |
| Network Recv | The amount of time to receive data on a network from a client. |
| Network Send | The amount of time to send data on a network to a client. |
| Queue Wait Get | The amount of time for an empty queue to become available for the next item in the queue. For example, the amount of time for a producer to put a work item in a worker thread queue. Long wait times might indicate that the producer is not creating work fast enough or that too many workers are involved in processing. |
| Queue Wait Put | The amount of time to put data into a first-in first-out queue with a fixed capacity that is full. A long wait time might indicate that worker threads are processing work slower than the producers can generate work. Adding worker threads might improve processing speed for the queue and reduce the wait time. |
| SHA1 | The amount of time to compute the SHA1 digest for a data buffer. |
| Shmem Copy | The amount of time to copy data to and from a shared memory segment. |
| Shmem Read | The amount of time to read data from a shared memory buffer. |
| Shmem Write | The amount of time to write data to a shared memory buffer. |
| Sleep | The amount of time to delay execution of a thread. |
| SSL Receive | The amount of time to receive data over a socket that is encrypted by using the SSL or TLS protocol. |
| SSL Send | The amount of time to send data over a socket that is encrypted by using the SSL or TLS protocol. |
| Tape Commit | The amount of time to synchronize tape to ensure that data is written from device buffers to media. |
| Tape Data Copy | The amount of time to copy data to tape buffers in memory. |
| Tape Locate | The amount of time to locate a tape block for read/write operations. |
| Tape Misc | The amount of time to process tape that is not tracked in another tape category (operations such as open or rewind). |
| Tape Read | The amount of time to read data from tape. |
| Tape Write | The amount of time to write data to tape. |
| TCP Read | The amount of time to read data from server. |
| Thread Wait | The amount of time to wait for another thread. |
| Tm Lock Wait | The amount of time to acquire the transaction manager lock. |
| Uncompress | The amount of time to uncompress data. |
| Unknown | The amount of time for an activity that is not tracked by another category. |
| xxHash | The amount of time to compute an xxHash digest for a data buffer. |