ODBSTATITM - Statistical data for individual SAP Tables (f. Rel. < 3.0)
ODBSTATITM - Statistical data for individual SAP Tables (f. Rel. < 3.0)
BAL_S_LOG - Application Log: Log header data
CPI1466 during Backup
This documentation is copyright by SAP AG.
Field
Type
Length
Data element
Description
TNAME
CHAR
000030
Table Name
REF
CHAR
000001
Table type (short text)
RNAME
CHAR
000010
Name of Pool/Cluster in the Database
BUF
CHAR
000001
Buffer mode of an SAP table
SQL
CHAR
000001
Flag: Table processed via EXEC SQL?
FILL1
CHAR
000001
Single-Character Flag
UPDCNT
INT4
000010
No. of UPDATE attempts
UPDFAIL
INT4
000010
No. of failed update attempts
DELCNT
INT4
000010
No. of DELETE attempts
DELFAIL
INT4
000010
No. of failed DELETE attempts
INSCNT
INT4
000010
No. of INSERT attempts
INSFAIL
INT4
000010
No. of failed INSERT attempts
DIRCNT
INT4
000010
Number of DIRECT READs
DIRFAIL
INT4
000010
Number of Failed DIRECT READs
SEQCNT
INT4
000010
No. of SEQUENTIAL READs
UPD_PREP
INT4
000010
No. of SQL PREPAREs
UPD_EXEC
INT4
000010
No of SQL EXECUTEs
UPD_ROW
INT4
000010
No. of tuples affected in a table
UPD_DUR
INT4
000010
Operation duration
DEL_PREP
INT4
000010
No. of SQL PREPAREs
DEL_EXEC
INT4
000010
No of SQL EXECUTEs
DEL_ROW
INT4
000010
No. of tuples affected in a table
DEL_DUR
INT4
000010
Operation duration
INS_PREP
INT4
000010
No. of SQL PREPAREs
INS_EXEC
INT4
000010
No of SQL EXECUTEs
INS_ROW
INT4
000010
No. of tuples affected in a table
INS_DUR
INT4
000010
Operation duration
DIR_PREP
INT4
000010
No. of SQL PREPAREs
DIR_OPEN
INT4
000010
No. of SQL OPENs
DIR_FETCH
INT4
000010
No. of SQL FETCHes
DIR_DUR
INT4
000010
Operation duration
SEQ_PREP
INT4
000010
No. of SQL PREPAREs
SEQ_OPEN
INT4
000010
No. of SQL OPENs
SEQ_FETCH
INT4
000010
No. of SQL FETCHes
SEQ_ROW
INT4
000010
No. of tuples affected in a table
SEQ_DUR
INT4
000010
Operation duration
UNUSED1
INT4
000010
4 Byte Signed Integer
UNUSED2
INT4
000010
4 Byte Signed Integer
UNUSED3
INT4
000010
4 Byte Signed Integer
UNUSED4
INT4
000010
4 Byte Signed Integer
FILL2
CHAR
000004
Undefined range (can be used for patch levels)
LOAD_PREP
INT4
000010
No. of SQL PREPAREs
LOAD_OPEN
INT4
000010
No. of SQL OPENs
LOAD_FETCH
INT4
000010
No. of SQL FETCHes
LOAD_ROW
INT4
000010
No. of tuples affected in a table
LOAD_DUR
INT4
000010
Operation duration
BUF_STATE
CHAR
000001
Status of the table in the table buffer
FILL3
CHAR
000003
3-Byte field
BUF_RESET
INT4
000010
No. of buffer resets
BUF_SIZE
INT4
000010
Size of the buffer for an object
BUF_SIZEMX
INT4
000010
Maximum buffer size for an object
BUF_RECS
INT4
000010
No. of buffered records for an object
BUF_RECSMX
INT4
000010
Maximum no. of buffered records for an object
BUF_DIR
INT4
000010
No. of direct hits in the buffer
BUF_SEQ
INT4
000010
No. of sequential buffer accesses
BUDIR
INT4
000010
4 Byte Signed Integer
BUSEQ
INT4
000010
4 Byte Signed Integer
This documentation is copyright by SAP AG.
Length: 15015 Date: 20240426 Time: 172155 sap01-206 ( 38 ms )
