SAP ABAP Table SYB_TXNLOGUSAGE (SYB: transaction log usage (loginfo))

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_TXNLOGUSAGE	Table Relationship Diagram
Short Description	SYB: transaction log usage (loginfo)

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

History

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