Point
Field name sCLInfo of record name RDBPS_S and field names sCLInfo of record name RDBPS_R are information collected when the security audit evidence function is effective between Interstage Application Server and Symfoware Server. "---:---" is displayed in case of invalidity.
Table name | Record ID | Record No. | Field Name | Source | Unit of Measure | Description |
|---|---|---|---|---|---|---|
resource_data | RDBSAR_EM | FJ1010 | Used | rdbsar -e -m | Kbytes | The amount of memory being used |
Free | rdbsar -e -m | Kbytes | The amount of unused memory | |||
Total | rdbsar -e -m | Kbytes | The amount of memory that has been allocated | |||
emType | rdbsar -e -m | Memory type | ||||
resource_data_uwide | RDBSAR_EL | FJ1011 | BiBlock | rdbsar -e -l (-g) | Number of blocks written to the BI log area | |
AiBlock | rdbsar -e -l (-g) | Number of blocks written to the AI log area | ||||
BiWrite | rdbsar -e -l (-g) | Number of writes to the BI log area | ||||
AiWrite | rdbsar -e -l (-g) | Number of writes to the AI log area | ||||
IxWrite | rdbsar -e -l (-g) | Number of writes to the index section | ||||
RcpOver | rdbsar -e -l (-g) | Number of times that the recovery log has overflowed | ||||
TrnOver | rdbsar -e -l (-g) | Number of times that the transaction entry has been detected as being in danger of used up | ||||
BiOver | rdbsar -e -l (-g) | Number of times that the BI log area has been detected as being in danger of used up | ||||
LongTrn | rdbsar -e -l (-g) | Number of times that long transactions have been detected | ||||
BufReq | rdbsar -e -l (-g) | Number of requests sent to buffer control | ||||
ArcReq | rdbsar -e -l (-g) | Number of requests sent to archive control | ||||
DirReq | rdbsar -e -l (-g) | Number of RDB directory update requests made in order to reduce the size of the effective AI log | ||||
IxReq | rdbsar -e -l (-g) | Number of log index section rewrites made in order to reduce the size of the effective AI log | ||||
StqReq | rdbsar -e -l (-g) | Number of write requests sent from buffer control to the BI log | ||||
EmpBI | rdbsar -e -l (-g) | Kbytes | Current amount of free BI logs | |||
EmpAI | rdbsar -e -l (-g) | Kbytes | Current amount of free AI logs | |||
EmpEntry | rdbsar -e -l (-g) | Current number of free transaction entries | ||||
PostBI | rdbsar -e -l (-g) | Number of BI log write completion synchronization requests from transactions | ||||
PostAI | rdbsar -e -l (-g) | Number of AI log write completion synchronization requests from transactions | ||||
DryBI | rdbsar -e -l (-g) | Number of times that the entire area of a cyclic BI log buffer cycles without anything having been written to it | ||||
DryAI | rdbsar -e -l (-g) | Number of times that the entire area of a cyclic AI log buffer cycles without anything having been written to it | ||||
DryAIArc | rdbsar -e -l (-g) | Number of times that the entire area of a cyclic AI log buffer cycles without anything having been written to the archive log | ||||
elLogGroupName | rdbsar -e -l (-g) | The log group name for the temporary log file or archive log file where performance data has been collected | ||||
resource_data_wide | RDBSAR_EB | FJ1012 | ebPgSize | rdbsar -e -b | bytes | Page size |
ebBufNum | rdbsar -e -b | Page | Total number of buffers | |||
ebUseNum | rdbsar -e -b | Page | Number of buffers used | |||
ebWpPage | rdbsar -e -b | Page | Number of pages written to the database | |||
ebTbPage | rdbsar -e -b | Page | Number of pages flushed from the database | |||
Alarm | rdbsar -e -b | Number of times that buffer usage reached the critical rate for the buffer pool | ||||
ebHitRate | rdbsar -e -b | % | Percentage of times that the page accessed was in the buffer | |||
DryUp | rdbsar -e -b | Number of times that there were no free buffers in the buffer pool | ||||
MinFree | rdbsar -e -b | Page | Recent minimum number of free buffers | |||
ebBpName | rdbsar -e -b | Buffer pool name | ||||
resource_data_wide | RDBSAR_ED | FJ1014 | RTimes | rdbsar -e -d | Number of reads from pages | |
WTimes | rdbsar -e -d | Number of writes to pages | ||||
Rpage | rdbsar -e -d | Page | Number of pages read | |||
Wpage | rdbsar -e -d | Page | Number of pages written | |||
SystemRead | rdbsar -e -d | milliseconds | Time taken from when a read processing request was made to the reader until processing completed | |||
ServiceRead | rdbsar -e -d | milliseconds | Time taken from when the reader started read processing until processing completed | |||
SystemWrite | rdbsar -e -d | milliseconds | Time taken from when a write processing request was made to the writer until processing completed | |||
ServiceWrite | rdbsar -e -d | milliseconds | Time taken from when the writer started write processing until processing completed | |||
edDBName | rdbsar -e -d | Database name | ||||
edDBSpaceName | rdbsar -e -d | Database space name | ||||
DeviceName | rdbsar -e -d | Device name | ||||
resource_data | RDBSAR_AGE | FJ1015 | Write | rdbsar -a | Number of blocks written from the archive log buffer to the archive log file | |
IONUM | rdbsar -a | Number of I/Os written from the archive log buffer to the archive log file | ||||
ageLogGroupName | rdbsar -a | Log group name | ||||
resource_data_uuwide | RDBPS_S | FJ1017 | sPid | rdbps -s/sp | Process ID | |
sElapse | rdbps -s/sp | time | Time elapsed since connecting to the RDB | |||
T_BIND | rdbps -s/sp | time | Time spent translating | |||
EXECTIME | rdbps -s/sp | time | Time spent executing | |||
COMTIME | rdbps -s/sp | time | Time spent communicating | |||
ACCTBL | rdbps -s/sp | Number of tables accessed | ||||
REQCOM | rdbps -s/sp | Number of communication requests | ||||
REALCOM | rdbps -s/sp | Number of actual communications | ||||
REQFET | rdbps -s/sp | Number of data return requests | ||||
REALFET | rdbps -s/sp | Number of actual data return communications | ||||
CUROPL | rdbps -s/sp | Number of OPLs held | ||||
MAXOPL | rdbps -s/sp | Maximum number of OPLs held | ||||
TOTALEXEC | rdbps -s/sp | Number of times SQL statements have been executed | ||||
INSEXEC | rdbps -s/sp | Number of times INSERT statements have been executed | ||||
UPDEXEC | rdbps -s/sp | Number of times UPDATE statements have been executed | ||||
DELEXEC | rdbps -s/sp | Number of times DELETE statements have been executed | ||||
SELEXEC | rdbps -s/sp | Number of times SELECT statements have been executed | ||||
OPNEXEC | rdbps -s/sp | Number of times OPEN statements have been executed | ||||
CALEXEC | rdbps -s/sp | Number of times CALL statements have been executed | ||||
TOTALBIND | rdbps -s/sp | Number of times SQL statements have been translated | ||||
INSBIND | rdbps -s/sp | Number of times INSERT statements have been translated | ||||
UPDBIND | rdbps -s/sp | Number of times UPDATE statements have been translated | ||||
DELBIND | rdbps -s/sp | Number of times DELETE statements have been translated | ||||
SELBIND | rdbps -s/sp | Number of times SELECT statements have been translated | ||||
OPNBIND | rdbps -s/sp | Number of times OPEN statements have been translated | ||||
CALBIND | rdbps -s/sp | Number of times CALL statements have been translated | ||||
FILESORT | rdbps -s/sp | Number of times that sorting has been used by external files | ||||
TOTALSORT | rdbps -s/sp | Total number of times that sorting has been used | ||||
MAXSORT | rdbps -s/sp | Kbytes | Maximum size of the sort area | |||
FILEWORK | rdbps -s/sp | Number of times that work tables have been used by external files | ||||
TOTALWORK | rdbps -s/sp | Total number of times that work tables have been used | ||||
MAXWORK | rdbps -s/sp | Kbytes | Maximum size of work tables | |||
MEM | rdbps -s/sp | Kbytes | The amount of memory being used | |||
PARASQL | rdbps -s/sp | Number of times that SQL statements have been executed with parallel specifications | ||||
CURPARACNT | rdbps -s/sp | Current number of concurrent processes per section | ||||
MAXPARACNT | rdbps -s/sp | Maximum number of concurrent processes per section | ||||
sModuleName | rdbps -s/sp | Module name | ||||
sUid | rdbps -s/sp | Login name | ||||
sStatus | rdbps -s/sp | Operating status | ||||
sType | rdbps -s/sp | Client process type | ||||
sCLInfo | rdbps -s/sp | Client information: Action information. | ||||
resource_data_wide | RDBPS_R | FJ1018 | rPid | rdbps -r | Process ID | |
rElapse | rdbps -r | time | Time elapsed since connecting to the RDB | |||
rDeadLock | rdbps -r | Number of times the process has deadlocked | ||||
rLockWait | rdbps -r | Number of times the process has had to wait for exclusive use of resources | ||||
rWaitTime | rdbps -r | time | Total time spent waiting for exclusive use of resources | |||
rReadIndex | rdbps -r | Number of times the index was searched | ||||
rWriteIndex | rdbps -r | Number of times the index was updated | ||||
rReadPage | rdbps -r | Number of times page reads were requested | ||||
rWritePage | rdbps -r | Number of times page writes were requested | ||||
rReadRecord | rdbps -r | Number of times the record was searched | ||||
rWriteRecord | rdbps -r | Number of times the record was updated | ||||
rModuleName | rdbps -r | Module name | ||||
rUid | rdbps -r | Login name | ||||
rStatus | rdbps -r | Operating status | ||||
rType | rdbps -r | Client process type | ||||
rCLInfo | rdbps -r | Process ID | ||||
resource_data | RDBSPCINF_PD | FJ1020 | Static | rdbspcinf -p/-d | Kbytes | Amount of database space allocated statically |
Dynamic | rdbspcinf -p/-d | Kbytes | Amount of database space allocated dynamically | |||
FreeSize | rdbspcinf -p/-d | Kbytes | Amount of free database space | |||
pdDBName | rdbspcinf -p/-d | Database name | ||||
pdDBSpaceName | rdbspcinf -p/-d | name | Database space name | |||
resource_data_twide | RDBINF_AP | FJ1021 | apUsed | rdbinf -a -p | % | Percentage of database space used |
apFree | rdbinf -a -p | % | Percentage of free database space | |||
apSize | rdbinf -a -p | Size of the database space | ||||
apDBName | rdbinf -a -p | Database name | ||||
apDBSpaceName | rdbinf -a -p | Database space name | ||||
apCondition | rdbinf -a -p | Database usage status and DSI usage status | ||||
apStateK | rdbinf -a -p | Type of operational information that has been set in the database space | ||||
apStateT | rdbinf -a -p | Setting target of operational information that has been set in the database space | ||||
apCause | rdbinf -a -p | Reason why operational information was set | ||||
resource_data | RDBSAR_ER | FJ1013 | erPgSize | rdbsar -e -r | bytes | Page size |
erBufNum | rdbsar -e -r | Total number of buffers | ||||
erUseNum | rdbsar -e -r | Number of active buffers for each DSI | ||||
Rate | rdbsar -e -r | % | Percentage of active buffers to the total number of buffers for each DSI | |||
erWpPage | rdbsar -e -r | Number of pages within a DSI that have been written to the database | ||||
erTbPage | rdbsar -e -r | Number of pages within a DSI that have been flushed from the database | ||||
erHitRate | rdbsar -e -r | % | Percentage of times that the page accessed in the DSI was in the buffer for each DSI | |||
BpName | rdbsar -e -r | Buffer pool name | ||||
erDBName | rdbsar -e -r | Database name | ||||
erDSIName | rdbsar -e -r | DSI name | ||||
TypeName | rdbsar -e -r | DSI type | ||||
resource_data | RDBSAR_EC | FJ1016 | SendCnt | rdbsar -e -c | Number of times data was sent to an RDB system on another node | |
RevCnt | rdbsar -e -c | Number of times data was received from an RDB system on another node | ||||
SendQtty | rdbsar -e -c | Bytes | Amount of data sent to an RDB system on another node | |||
RecvQtty | rdbsar -e -c | Bytes | Amount of data received from an RDB system on another node | |||
System | rdbsar -e -c | The name of the RDB system with which data is being exchanged | ||||
resource_data_ttwide | RDBPS_IA | FJ1019 | iaPid | rdbps -ia | Process ID | |
iaElapse | rdbps -ia | Time elapsed since connecting to the RDB | ||||
iaDeadLock | rdbps -ia | Number of times the process has deadlocked | ||||
iaLockWait | rdbps -ia | Number of times the process has had to wait for exclusive use of resources | ||||
iaWaitTime | rdbps -ia | Total time spent waiting for exclusive use of resources | ||||
iaReadIndex | rdbps -ia | Number of times the index was searched | ||||
iaWriteIndex | rdbps -ia | Number of times the index was updated | ||||
iaReadPage | rdbps -ia | Number of times page reads were requested | ||||
iaWritePage | rdbps -ia | Number of times page writes were requested | ||||
iaReadRecord | rdbps -ia | Number of times the record was searched | ||||
iaWriteRecord | rdbps -ia | Number of times the record was updated | ||||
iaModuleName | rdbps -ia | Module name | ||||
iaUid | rdbps -ia | Login name | ||||
iaStatus | rdbps -ia | Operating status | ||||
iaType | rdbps -ia | Client process type | ||||
iaDBName | rdbps -ia | Database name | ||||
iaDSIName | rdbps -ia | DSI name | ||||
iaCLInfo | rdbps -ia | Client information. | ||||
resource_data_twide | RDBINF_AI | FJ1022 | aiUsed | rdbinf -a -i | % | Percentage of used DSI for each allocation target |
aiFree | rdbinf -a -i | % | Percentage of free DSI for each allocation target | |||
aiSize | rdbinf -a -i | bytes | Size of the DSI for each allocation target and size of the DSI allocated from the database space for each allocation target | |||
aiDBName | rdbinf -a -i | Database name | ||||
aiDSIName | rdbinf -a -i | DSI name | ||||
aiTypeName | rdbinf -a -i | DSI type | ||||
aiCondition | rdbinf -a -i | DSI usage status and database space usage status | ||||
aiStateK | rdbinf -a -i | Type of operational information that has been set in the database space | ||||
aiStateT | rdbinf -a -i | Setting target of operational information that has been set in the database space | ||||
aiCause | rdbinf -a -i | Reason why operational information was set |
