SAP ABAP Table SYB_XCHG_TXNLOGUSAGE (SYB: exchange data structure for transaction log usage)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-SYB (Application Component) Sybase ASE Database Platform
     ⤷ SMSYB (Package) SYBASE Database Monitor

Basic Data

Table Category	INTTAB	Structure
Structure	SYB_XCHG_TXNLOGUSAGE	Table Relationship Diagram
Short Description	SYB: exchange data structure for transaction log usage

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	DATABASE	☐	SYB_TXNLOGUSAGE		STRU	0	0
2	DBID	☐	SYBOBJID		INT4	10	0	SYB: Object ID (Index, Table, DB, Partition, ...)
3	DBNAME	☐	SYBDBNAME	SYBDBNAME	CHAR	30	0	SYB: DB Name
4	CHECKPOINT_DATE	☐			STRG	0	0
5	UNTIL_TIME_DATE	☐			STRG	0	0
6	DB_HAS_ACTIVE_TXN	☐	WDY_BOOLEAN	WDY_BOOLEAN	CHAR	1	0	Replacement for Real Boolean Type: 'X' == True '' == False
7	IS_STP_BLOCKING_DUMP	☐	WDY_BOOLEAN	WDY_BOOLEAN	CHAR	1	0	Replacement for Real Boolean Type: 'X' == True '' == False
8	DUMP_CAN_FREE_PCT	☐			INT1	3	0
9	OAT_SPID	☐			INT4	10	0
10	OAT_SPAN_PCT	☐			INT1	3	0
11	OAT_RUNTIME_SEC	☐			INT4	10	0
12	OAT_DATE	☐			STRG	0	0
13	OAT_APPLICATION	☐			STRG	0	0
14	OAT_CLIENTAPPLNAME	☐			CHAR	30	0
15	OAT_CLIENTHOST	☐			CHAR	30	0
16	OAT_CLIENTHOSTNAME	☐			CHAR	30	0
17	OAT_CLIENTIP	☐			STRG	0	0
18	OAT_CLIENTNAME	☐			CHAR	30	0
19	OAT_CLIENTOSPID	☐			STRG	0	0
20	OAT_LOGIN	☐	SYBOBJOWNER	SYBOBJOWNER	CHAR	128	0	SYB: Object Owner (Index, Table, DB, Partition, ...)
21	OAT_STATE	☐			STRG	0	0
22	OAT_STMTDBID	☐	SYBOBJID		INT4	10	0	SYB: Object ID (Index, Table, DB, Partition, ...)
23	OAT_STMTPROCEDUREID	☐	SYBOBJID		INT4	10	0	SYB: Object ID (Index, Table, DB, Partition, ...)
24	OAT_STMTSQLTEXT	☐			STRG	0	0
25	OAT_STMTSTARTTIME	☐			STRG	0	0
26	LOG_TOTAL_MB	☐			INT4	10	0
27	LOG_RESERVED_MB	☐			INT4	10	0
28	LOG_ACTIVE_MB	☐			INT4	10	0
29	LOG_INACTIVE_MB	☐			INT4	10	0
30	LOG_STP_MB	☐			INT4	10	0
31	STP_SPAN_PCT	☐			INT1	3	0
32	SNAPSHOT_TIMESTAMP	☐	DB6TSTAMP		CHAR	14	0	DB6: Timestamp (Format: YYYYMMDDHHMMSS)
33	TIMESTAMP	☐	DBAFTTSTAMP		STRG	0	0	DBA Formatted Timestamp
34	TIME_PERIOD	☐			INT4	10	0
35	SOURCE_HOSTNAME	☐	SYBHOSTNAME	SYBHOSTNAME	CHAR	128	0	SYB: Hostname

History

Last changed by/on	SAP	20140117
SAP Release Created in	740