Statistics are gathered on the Image Services internal database files.
Soft Report Symbol | Definition | Counter |
---|---|---|
mkf.find[BaseFile=x] | Find operation on the database. | MKF_FIND |
mkf.sop_find[BaseFile=x] | Find on the database that occurred in a single operation. | MKF_SOP_FIND |
mkf.insert[BaseFile=x] | Insert operation on the database. | MKF_INSERT |
mkf.sop_insert[BaseFile=x] | Insert on the database that occurred in a single operation. | MKF_SOP_INSERT |
mkf.update[BaseFile=x] | Update operation on the database. | MKF_UPDATE |
mkf.delete[BaseFile=x] | Delete operation on the database. | MKF_DELETE |
mkf.set_position[BaseFile=x] | Call to set forward or backward find on database. | MKF_SET_POSITION |
mkf.begin_trans[BaseFile=x] | There are transactions that provide locking around the database operations. | MKF_BEGIN_TRANS |
mkf.end_trans[BaseFile=x] | Transactions that provide locking around the database operations. | MKF_END_TRANS |
mkf.abort_trans[BaseFile=x] | Transactions that provide locking around the database operations. | MKF_ABORT_TRANS |
mkf.short_start[BaseFile=x] | Short transaction buffer that fits in the buffer pool. Fast and requires no IO. | MKF_SHORT_START |
mkf.short_compl[BaseFile=x] | Short transaction buffer that fits in the buffer pool. Fast and requires no IO. | MKF_SHORT_COMPL |
mkf.short_abort[BaseFile=x] | Short transaction buffer that fits in the buffer pool. Fast and requires no IO. | MKF_SHORT_ABORT |
mkf.long_start[BaseFile=x] | Long transactions require more buffers and do not fit in the buffer pool. IO is required. | MKF_LONG_START |
mkf.long_compl[BaseFile=x] | Long transactions require more buffers and do not fit in the buffer pool. IO is required. | MKF_LONG_COMPL |
mkf.long_abort[BaseFile=x] | Long transactions require more buffers and do not fit in the buffer pool. IO is required. | MKF_LONG_ABORT |
mkf.short->long[BaseFile=x] | Short transaction that is converted to a long transaction, short->long. | MKF_SHORT2LONG |
mkf.short->longok[BaseFile=x] | Displays if the short-> long transaction conversion succeeded. | MKF_SHORT2LONGOK |
mkf.deadlocks[BaseFile=x] | When 2 transactions are both locked on each other's buffer. One transaction must end to start over. | MKF_DEADLOCKS |
mkf.readblock[BaseFile=x] | Blocks that are read from the B-tree into the buffer pool. | MKF_READBLOCK |
mkf.cachehits[BaseFile=x] | Cache hits is the number of times blocks are found in the buffer pool. | MKF_CACHEHITS |
mkf.buffers[BaseFile=x] | Buffer pool. | MKF_BUFFERS |
mkf.aij_read[BaseFile=x] | After image journal reads. | MKF_AIJ_READ |
mkf.b_aij_read[BaseFile=x] | After image journal blocks read. | MKF_B_AIJ_READ |
mkf.aij_write[BaseFile=x] | After image journal writes. | MKF_AIJ_WRITE |
mkf.b_aij_write[BaseFile=x] | After image journal blocks that are written. | MKF_B_AIJ_WRITE |
mkf.bij_read[BaseFile=x] | Before image journal reads. | MKF_BIJ_READ |
mkf.b_bij_read[BaseFile=x] | Before image journal blocks read. | MKF_B_BIJ_READ |
mkf.bij_write[BaseFile=x] | Before image journal writes. | MKF_BIJ_WRITE |
mkf.b_bij_write[BaseFile=x] | Before image journal blocks that are written. | MKF_B_BIJ_WRITE |
mkf.data_read[BaseFile=x] | Database reads. | MKF_DATA_READ |
mkf.data_write[BaseFile=x] | Database blocks that are read. | MKF_DATA_WRITE |
mkf.b_data_read[BaseFile=x] | Database writes. | MKF_B_DATA_READ |
mkf.b_data_write[BaseFile=x] | Database blocks that are written. | MKF_B_DATA_WRITE |
mkf.shutdown[BaseFile=x] | Database shutdown calls. | MKF_SHUTDOWN |
mkf.open[BaseFile=x] | Occur once per startup. | MKF_OPEN |
mkf.close[BaseFile=x] | Occur once per startup. | MKF_CLOSE |
mkf.open_cursor[BaseFile=x] | Occur once per startup. | MKF_OPEN_CURSOR |
mkf.close_cursor[BaseFile=x] | Occur once per startup. | MKF_CLOSE_CURSOR |
mkf.get_item_number[BaseFile=x] | Occur once per startup. | MKF_GET_ITEM_NUM |
mkf.bind[BaseFile=x] | Occur once per startup. | MKF_BIND |
mkf.open_description[BaseFile=x] | MKF_ddl calls only. | MKF_OPEN_DESC |
mkf.close_description[BaseFile=x] | MKF_ddl calls only. | MKF_CLOSE_DESC |
mkf.get_parameters[BaseFile=x] | MKF_ddl calls only. | MKF_GET_PARAM |
mkf.set_parameters[BaseFile=x] | MKF_ddl calls only. | MKF_SET_PARAM |
mkf.get_file[BaseFile=x] | MKF_ddl calls only | MKF_GET_FILE |
mkf.set_file[BaseFile=x] | MKF_ddl calls only | MKF_SET_FILE |
mkf.get_record[BaseFile=x] | MKF_GET_RECORD | |
mkf.set_record[BaseFile=x] | MKF_SET_RECORD | |
mkf.get_item[BaseFile=x] | MKF_GET_ITEM | |
mkf.set_item[BaseFile=x] | MKF_SET_ITEM | |
mkf.get_aij_bsn[BaseFile=x] | MKF_GET_AIJ_BSN | |
mkf.update_avsp[BaseFile=x] | MKF_UPDATE_AVSP | |
mkf.transaction_state[BaseFile=x] | MKF_TRANS_STATE | |
mkf.set_abortmode[BaseFile=x] | MKF_SET_ABORTMODE | |
mkf.getbuffer[BaseFile=x] | If readblock calls do not find block in cache, getbuffer gets a buffer. | MKF_GET_BUFFER |
mkf.divest[BaseFile=x] | Divests and divest releases the interlocks on the buffer. | MKF_DIVEST |
mkf.divestcompletely[BaseFile=x] | Divests and divest releases the interlocks on the buffer. | MKF_DIVESTCOMPL |
mkf.search[BaseFile=x] | Search is the call to walk the B-tree. | MKF_SEARCH |
mkf.searchfirst[BaseFile=x] | First try occurs when the find completes by the end of the search without having to split. | MKF_SEARCHFIRST |
mkf.searchupdate[BaseFile=x] | For update occurs when the B-tree search is run to update the B-tree. | MKF_SEARCHUPDATE |
mkf.searchtable[BaseFile=x] | Search table represents the number of tables searched in the B-tree. | MKF_SEARCHTABLE |
mkf.insertkey[BaseFile=x] | Insert key and delete key indicate operations to the B-tree. | MKF_INSERTKEY |
mkf.deletekey[BaseFile=x] | Insert key and delete key indicate operations to the B-tree. | MKF_DELETEKEY |
mkf.mergecalls[BaseFile=x] | Merge calls occur when partially full tables are merged. | MKF_MERGECALL |
mkf.tablemerges[BaseFile=x] | Number of merged tables. | MKF_TABLEMERGE |
mkf.tablesplits[BaseFile=x] | Table splits occur when the key does not fit. | MKF_TABLESPLIT |