Hierarchy
☛
SAP_BASIS (Software Component) SAP Basis Component
⤷
BC-DB-SYB (Application Component) Sybase ASE Database Platform
⤷
SMSYB (Package) SYBASE Database Monitor
Basic Data
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 |
SYBDATABASE |
|
SYB_SYSDATABASES |
|
STRU |
0 |
0 |
|
|
2 |
NAME |
|
SYBDBNAME |
SYBDBNAME |
CHAR |
30 |
0 |
SYB: DB Name |
|
3 |
DBID |
|
SYBOBJID |
|
INT4 |
10 |
0 |
SYB: Object ID (Index, Table, DB, Partition, ...) |
|
4 |
SUSER_NAME |
|
SYBOBJOWNER |
SYBOBJOWNER |
CHAR |
128 |
0 |
SYB: Object Owner (Index, Table, DB, Partition, ...) |
|
5 |
SUID |
|
SYBOBJID |
|
INT4 |
10 |
0 |
SYB: Object ID (Index, Table, DB, Partition, ...) |
|
6 |
STATUS |
|
|
|
INT2 |
5 |
0 |
|
|
7 |
LOGPTR |
|
|
|
INT4 |
10 |
0 |
|
|
8 |
CRDATE |
|
|
|
STRG |
0 |
0 |
|
|
9 |
DUMPTRDATE |
|
|
|
STRG |
0 |
0 |
|
|
10 |
STATUS2 |
|
|
|
INT2 |
5 |
0 |
|
|
11 |
STATUS3 |
|
|
|
INT4 |
10 |
0 |
|
|
12 |
STATUS4 |
|
|
|
INT4 |
10 |
0 |
|
|
13 |
DURABILITY |
|
|
|
CHAR |
20 |
0 |
|
|
14 |
SIZE_MB |
|
SYBBIGINT |
|
DEC |
22 |
0 |
SYB: Big Integer |
|
15 |
VDEVNO |
|
|
|
INT2 |
5 |
0 |
|
|
16 |
IN_DROP |
|
|
|
CHAR |
3 |
0 |
|
|
17 |
MIXEDLOG |
|
|
|
CHAR |
3 |
0 |
|
|
18 |
SUSPECT_PAGES |
|
|
|
CHAR |
3 |
0 |
|
|
19 |
BGCOLOR |
|
LVC_CIFNM |
CHAR30 |
CHAR |
30 |
0 |
ALV control: Field name with simple row color coding |
|
20 |
SUSPECT_DB |
|
|
|
CHAR |
3 |
0 |
|
|
21 |
LOG_FREE_PAGES |
|
|
|
INT4 |
10 |
0 |
|
|
22 |
LOG_FREE_MB |
|
|
|
INT4 |
10 |
0 |
|
|
23 |
LOG_TOTAL_MB |
|
|
|
INT4 |
10 |
0 |
|
|
24 |
DATA_RESERVED_PCT |
|
|
|
DEC |
6 |
2 |
|
|
25 |
LOG_RESERVED_PCT |
|
|
|
DEC |
6 |
2 |
|
|
26 |
DATA_MB |
|
|
|
INT4 |
10 |
0 |
|
|
27 |
DATA_FREE_MB |
|
|
|
INT4 |
10 |
0 |
|
|
28 |
AEXP_ENABLED |
|
WDY_BOOLEAN |
WDY_BOOLEAN |
CHAR |
1 |
0 |
Replacement for Real Boolean Type: 'X' == True '' == False |
|
29 |
AEXP_ENABLED_ICON |
|
|
|
STRG |
0 |
0 |
|
|
30 |
AEXP_ENABLED_TEXT |
|
|
|
STRG |
0 |
0 |
|
|
31 |
AEXP_LAST_DATA_EXP |
|
|
|
STRG |
0 |
0 |
|
|
32 |
AEXP_LAST_LOG_EXP |
|
|
|
STRG |
0 |
0 |
|
|
33 |
AEXP_INH_FROM_DEFAULT |
|
WDY_BOOLEAN |
WDY_BOOLEAN |
CHAR |
1 |
0 |
Replacement for Real Boolean Type: 'X' == True '' == False |
|
34 |
SEGMENTS |
|
SYBSPACE_PHYSICAL_TAB |
|
TTYP |
0 |
0 |
|
|
35 |
DEVICES |
|
SYB_SYSDEVICES_TAB |
|
TTYP |
0 |
0 |
|
|
36 |
USAGES |
|
SYB_SYSUSAGES_TAB |
|
TTYP |
0 |
0 |
|
|
37 |
DB_OPTIONS |
|
SYB_DB_DETAILS |
|
STRU |
0 |
0 |
|
|
38 |
DBID |
|
SYBOBJID |
|
INT4 |
10 |
0 |
SYB: Object ID (Index, Table, DB, Partition, ...) |
|
39 |
BULKCOPY |
|
|
|
CHAR |
3 |
0 |
|
|
40 |
TRUNC_LOG_ON_CHKPT |
|
|
|
CHAR |
3 |
0 |
|
|
41 |
NO_CHKPT_ON_RECOVERY |
|
|
|
CHAR |
3 |
0 |
|
|
42 |
RECOVERY_STARTED |
|
|
|
CHAR |
3 |
0 |
|
|
43 |
DDL_IN_TRAN |
|
|
|
CHAR |
3 |
0 |
|
|
44 |
READ_ONLY |
|
|
|
CHAR |
3 |
0 |
|
|
45 |
DBO_USE_ONLY |
|
|
|
CHAR |
3 |
0 |
|
|
46 |
SINGLE_USER |
|
|
|
CHAR |
3 |
0 |
|
|
47 |
NULLS_BY_DEFAULT |
|
|
|
CHAR |
3 |
0 |
|
|
48 |
ABORT_TRAN_ON_LOG_FULL |
|
|
|
CHAR |
3 |
0 |
|
|
49 |
NO_FREE_SPACE_ACCTG |
|
|
|
CHAR |
3 |
0 |
|
|
50 |
AUTO_IDENTITY |
|
|
|
CHAR |
3 |
0 |
|
|
51 |
IDENTITY_IN_NONUNIQUE_IDX |
|
|
|
CHAR |
3 |
0 |
|
|
52 |
AUTO_IDENTITY_UNIQUE_CONSTR |
|
|
|
CHAR |
3 |
0 |
|
|
53 |
ASYNC_LOG_SERVICE |
|
|
|
CHAR |
3 |
0 |
|
|
54 |
DELAYED_COMMIT |
|
|
|
CHAR |
3 |
0 |
|
|
55 |
SCRATCH_DB |
|
|
|
CHAR |
3 |
0 |
|
|
History
Last changed by/on | SAP | 20140117 |
SAP Release Created in | 703 | |