|
   
Appendix
B . System Catalog Reference
 B.1
The System Catalog
B.2
DBMaker System Catalog Tables
B.3
SYSAUTHCOL
B.4
SYSAUTHEXE
B.5
SYSAUTHGROUP
B.6
SYSAUTHMEMBER
B.7
SYSAUTHTABLE
B.8
SYSAUTHUSER
B.9
SYSCFGINFO
B.10
SYSCMDINFO
B.11
SYSCOLUMN
B.12
SYSDBLINK
B.13
SYSDOMAIN
B.14
SYSFILE
B.15
SYSFILEOBJ
B.16
SYSFOREIGNKEY
B.17
SYSGLBTRANX
B.18
SYSINDEX
B.19
SYSINFO
B.20
SYSLOCK
B.21
SYSOPENLINK
B.22
SYSPROCINFO
B.23
SYSPROCPARAM
B.24
SYSPROJECT
B.25
SYSPUBLISH
B.26
SYSSUBSCRIBE
B.27
SYSSYNONYM
B.28
SYSTABLE
B.29
SYSTABLESPACE
B.30
SYSTEXTINDEX
B.31
SYSTRIGGER
B.32
SYSUSER
B.33
SYSUSERFUNC
B.34
SYSVIEWDATA
B.35
SYSWAIT
B. System Catalog Reference
Part of
the definition of what makes a relational database is that all information
about the database must be represented at the logical level in the same
way as user data. This information is stored in the system catalog.
This allows authorized users to use SQL to access information about
the database in the same way they access data in their own tables. This
appendix contains descriptions of the system catalog tables and views,
organized alphabetically by name. You can query these system catalog
tables to see the detailed status of your database.
B.1 The System Catalog
The system
catalog is a set of tables that contain information about all objects
in the database. The system catalog is also known as the data dictionary.
All system
catalogs are owned by SYSTEM, and can be read by any user with at least
connect authority. Since system catalogs belong to SYSTEM, you cannot
DROP a system table or a system defined column, and you cannot INSERT
or DELETE rows in a system table.
B.2 DBMaker System Catalog Tables
The following
table lists all of the system catalog tables in DBMaker, and a brief
description of what is contained in each table.
|
Table
Name
|
Contents
|
|
SYSAUTHCOL
|
Column
privilege information.
|
|
SYSAUTHEXE
|
Executable
object privilege information.
|
|
SYSAUTHGROUP
|
Group
information.
|
|
SYSAUTHMEMBER
|
Group
member information.
|
|
SYSAUTHTABLE
|
Table
privilege information.
|
|
SYSAUTHUSER
|
Security
level information.
|
|
SYSCFGINFO
|
Database
configuration information.
|
|
SYSCMDINFO
|
Stored
command information.
|
|
SYSCONINFO
|
Console
information
|
|
SYSCOLUMN
|
Column
information.
|
|
SYSDBLINK
|
Database
link information.
|
|
SYSDOMAIN
|
Domain
information.
|
|
SYSEVENTINFO
|
Event
information.
|
|
SYSFILE
|
File
information.
|
|
SYSFILEOBJ
|
File
object information.
|
|
SYSFOREIGNKEY
|
Foreign
key information.
|
|
SYSGLBTRANX
|
DDB
global transaction information.
|
|
SYSINDEX
|
Index
information.
|
|
SYSIOINFO
|
I/O
Information.
|
|
SYSINFO
|
Database
system information.
|
|
SYSJNLINFO
|
Journal
information.
|
|
SYSLOCK
|
Lock
information.
|
|
SYSOPENLINK
|
Open
link information.
|
|
SYSPENDTRANX
|
Pending
distributed transaction information.
|
|
SYSPROCINFO
|
Stored
procedure information.
|
|
SYSPROCPARAM
|
Stored
procedure parameter information.
|
|
SYSPROJECT
|
ESQL
project information.
|
|
SYSPUBLISH
|
Table
replication source information.
|
|
SYSSUBSCRIBE
|
Table
replication destination information.
|
|
SYSSYNONYM
|
Synonym
information.
|
|
SYSTABLE
|
Table
information.
|
|
SYSTABLESPACE
|
Tablespace
information.
|
|
SYSTEXTINDEX
|
Text
index information.
|
|
SYSTRIGGER
|
Trigger
information.
|
|
SYSTRPDEST
|
Table
replication information.
|
|
SYSUSER
|
Information
on users logged into the database.
|
|
SYSUSERFUNC
|
User-defined
function information.
|
|
SYSVIEWDATA
|
View
information.
|
|
SYSWAIT
|
Waiting
connection information.
|
B.3 SYSAUTHCOL
The SYSAUTHCOL
table lists all columns in all tables on which a user has been granted
object privileges. If a user is allowed to perform some operations such
as INSERT, UPDATE or REFERENCE on the authorized table with all columns
(i.e. the return value of INS_ALL, UPD_ALL, or REF_ALL in SYSAUTHTABLE
is 1), then the return values of the columns, INS, UPD, REF in SYSAUTHCOL
should be ignored.
|
Column
Name
|
Description
|
|
COLUMN_NAME
|
Name
of the column on which privileges have been granted.
|
|
TABLE_NAME
|
Name
of the table the column belongs to.
|
|
GRANTEE
|
Name
of the user granted privileges on the column. Must be a valid
user or group name.
|
|
TABLE_OWNER
|
Name
of the user who created the table.
|
|
INS
|
1
- User has the privilege to insert data into the specified column.
0
- User does not have the privilege to insert data into the specified
column.
|
|
UPD
|
1
- User has the privilege to update data in the specified column.
0
- User does not have the privilege to update data in the specified
column.
|
|
REF
|
1
- User has the privilege to create a constraint which refers to
the specified column.
0
- User does not have the privilege to create a constraint which
refers to the specified column.
|
B.4 SYSAUTHEXE
The SYSAUTHEXE
table contains executable object information.
|
Column
Name
|
Description
|
|
OBJNAME
|
Name
of the executable object.
|
|
OWNER
|
User
who created the executable object.
|
|
OBJTYPE
|
Type
of executable object.
|
|
GRANTEE
|
Name
of the user granted privileges on the executable object.
|
B.5 SYSAUTHGROUP
The SYSAUTHGROUP
table gives the names of all valid groups in the database.
|
Column
Name
|
Description
|
|
GROUP_NAME
|
Name
of the group.
|
|
GROUP_OWNER
|
User
who created the group.
|
|
NUM_MEMBERS
|
Number
of members in this group.
|
B.6 SYSAUTHMEMBER
The SYSAUTHMEMBER
table list all members who belong to a group.
|
Column
Name
|
Description
|
|
MEMBER_NAME
|
Name
of the member who belongs to the group.
|
|
GROUP_NAME
|
Name
of the group.
|
B.7 SYSAUTHTABLE
The SYSAUTHTABLE
table is a list of all privileges which have been granted on tables,
and who they were granted to.
|
Column
Name
|
Description
|
|
TABLE_NAME
|
Name
of the table or view on which privileges have been granted.
|
|
GRANTEE
|
Name
of the user granted privileges on the table.
|
|
TABLE_OWNER
|
User
who created the table or view.
|
|
NUM_RPI_COLS
|
Number
of columns that have privileges granted on them in the table or
view.
|
|
SEL_ALL
|
1
- User has the privilege to select data from all columns in the
specified table or view.
0
- User does not have the privilege to select data from columns
in the specified table or view.
|
|
DEL_ALL
|
1
- User has the privilege to delete data in all columns in the
specified table or view;
0
- User does not have the privilege to delete data from columns
in the specified table or view.
|
|
INS
|
1
- User has the privilege to insert data into specific columns
in the specified table or view.
0
- User does not have the privilege to insert data into any columns
in the specified table or view.
|
|
INS_ALL
|
1
- User has the privilege to insert data into all columns in the
specified table or view;
0
- User does not have the privilege to insert data into all columns
in the specified table or view, but may still have privileges
on individual columns (see INS).
|
|
UPD
|
1
- User has the privilege to update data in specific columns in
the specified table or view.
0
- User does not have the privilege to update data in any columns
in the specified table or view.
|
|
UPD_ALL
|
1
- User has the privilege to update data in all columns in the
specified table or view.
0
- User does not have the privilege to update data in all columns
in the specified table or view, but may still have privileges
on individual columns (see UPD).
|
|
ALT_ALL
|
1
- User has the privilege to alter the definition of the specified
table or view.
0
- User does not have permission to alter the definition of the
specified table or view.
|
|
IDX_ALL
|
1
- User has the privilege to create or drop indexes on the specified
table or view.
0
- User does not have the privilege to create or drop indexes on
the specified table or view.
|
|
REF
|
1
- User has the privilege to create a constraint which refers to
specific columns in the specified table or view.
0
- User does not have the privilege to create a constraint on any
columns in the specified table or view.
|
|
REF_ALL
|
1
- User has the privilege to create a constraint which refers to
any/all columns in the specified table or view.
0
- User does not have the privilege to create a constraint which
refers to any/all columns in the specified table or view, but
may still have privileges on individual columns (see REF).
|
B.8 SYSAUTHUSER
The SYSAUTHUSER
table lists the names and authority levels of all valid users in the
database.
|
Column
Name
|
Description
|
|
USER_NAME
|
User
ID of each valid user in the database. A user is considered valid
if they have been granted CONNECT authority.
|
|
DBA
|
1
- User has DBA authority.
0
- User does not have DBA authority.
|
|
RESOURCE
|
1
- User has RESOURCE authority.
0
- User does not have RESOURCE authority.
|
B.9 SYSCFGINFO
The SYSCFGINFO
table contains information about the configuration of the database.
|
Column
Name
|
Description
|
|
DCCA_SIZE
|
Size
in bytes of the database communication and control area.
|
|
NUM_MAX_TRANX
|
Maximum
number of transactions.
|
|
NUM_PAGE_BUF
|
Number
of page buffers.
|
|
DDB_MODE
|
Distributed
database mode.
|
|
BACKUP_MODE
|
Backup
mode.
|
|
USER_FO_MODE
|
User
file object mode.
|
|
READ_ONLY_MODE
|
|
|
NO_JOURNAL_MODE
|
|
|
TURBO_MODE
|
|
|
FRAME_SIZE
|
|
|
NUM_JOURNAL_FILE
|
|
|
NUM_JOURNAL_BLOCKS
|
|
B.10 SYSCMDINFO
The SYSCMDINFO
table contains stored command information.
|
Column
Name
|
Description
|
|
MODULENAME
|
Module
name.
|
|
CMDNAME
|
Command
name.
|
|
CMDOWNER
|
Command
owner.
|
|
STATEMENT
|
Command
statement.
|
|
NUM_PARM
|
|
|
STATUS
|
|
B.11 SYSCOLUMN
This table
lists every column in each table and view, including the columns in
the system catalog tables. In the SCALE and RADIX columns, a value of
-1 is returned where SCALE and RADIX are not applicable to the data
type found in that column.
|
Column
Name
|
Description
|
|
COLUMN_NAME
|
Name
of the column.
|
|
TABLE_NAME
|
Name
of the table that owns this column.
|
|
TABLE_OWNER
|
Name
of the user who created the table.
|
|
COLUMN_ORDER
|
Order
of the column in the table.
|
|
NULLABLE
|
1
- Column allows null values.
0
- Column does not allow null values.
|
|
TYPE_NAME
|
Type
name of the column. Can be any of: BINARY, CHAR, DATE, DECIMAL,
DOUBLE, FILE, FLOAT, INTEGER, LONG VARCHAR, LONG VARBINARY, SERIAL,
SMALLINT, TIME, TIMESTAMP, or VARCHAR.
|
|
PRECISION
|
Precision
of the column.
|
|
SCALE
|
Scale
of the column.
|
|
RADIX
|
Radix
of the column.
|
|
ASCII_DEF
|
Default
value of ASCII form for the column.
|
|
CONSTRAINT
|
Constraint
for the column.
|
|
REMARKS
|
A
description of the column.
|
B.12 SYSDBLINK
The SYSDBLINK
table contains information on remote database links.
|
Column
Name
|
Description
|
|
OWNER
|
Link
Owner.
|
|
DB_LINK
|
Link.
|
|
DBSVR
|
Server.
|
|
USER_NAME
|
User
Name.
|
B.13 SYSDOMAIN
The SYSDOMAIN
table contains information on domains created in the database.
|
Column
Name
|
Description
|
|
DOMAIN_NAME
|
The
name of the domain.
|
|
DOMAIN_OWNER
|
The
name of the user who created the domain.
|
|
ASCII_DEF
|
Default
value of ASCII form for the domain.
|
|
TYPE_NAME
|
Type
name of the domain. Can be any of : BINARY, CHAR, DATE, DECIMAL,
DOUBLE, FILE, FLOAT, INTEGER, LONG VARCHAR, LONG VARBINARY, SMALLINT,
TIME, TIMESTAMP, or VARCHAR.
|
|
DATA_LEN
|
The
size of the data type for the domain.
|
|
PRECISION
|
Precision
of the domain.
|
|
SCALE
|
Scale
of the domain.
|
|
CONSTRAINT
|
Constraint
of the domain.
|
B.14 SYSFILE
The SYSFILE
table contains information on files in the database.
|
Column
Name
|
Description
|
|
FILE_NAME
|
Logical
file name.
|
|
FILE_TYPE
|
File
type: 1 (data file) or 2 (BLOB file).
|
|
TS_NAME
|
Name
of the tablespace the file is in.
|
|
FILE_NPAGES
|
Number
of pages in the file. If the tablespace is an AUTOEXTEND tablespace,
then FILE_NPAGES may be less than the physical FILE_NPAGES in
the file.
|
|
RAWDEV_OFFSET
|
Not
supported in this version of DBMaker.
|
B.15 SYSFILEOBJ
The SYSFILEOBJ
table contains information on the file objects in the database. This
includes both system and user file objects.
|
Column
Name
|
Description
|
|
FILE_TYPE
|
00
- system file object.
01
- user file object.
|
|
SHARE
|
The
number of records that share the file object.
|
|
FILE_NAME
|
The
full path with the filename to show where the file object is located.
|
B.16 SYSFOREIGNKEY
The SYSFOREIGNKEY
table contains information on all foreign keys in the database.
|
Column
Name
|
Description
|
|
FK_TBL_NAME
|
Name
of the child table (the table the foreign key is defined on).
|
|
PK_TBL_NAME
|
Name
of the parent table for the foreign key.
|
|
FK_TBL_OWNER
|
Owner
of the child table.
|
|
PK_TBL_OWNER
|
Owner
of the parent table.
|
|
FK_NAME
|
Name
of the foreign key.
|
|
UPD_ACT
|
Update
referential action.
|
|
DEL_ACT
|
Delete
referential action.
|
B.17 SYSGLBTRANX
The SYSGLBTRANX
table contains information on global transactions.
|
Column
Name
|
Description
|
|
STATE
|
Global
transaction state.
|
|
PARTICIPANT
|
Global
transaction participant.
|
|
GLBTRANXID
|
Global
transaction ID.
|
B.18 SYSINDEX
The SYSINDEX
table contains information on indexes in the database. A -1 in the NUM_PAGE,
NUM_LEVEL, NUM_LEAF, DIST_KEY, NUM_PAGE_KEY, or CLSTR_COUNT columns
means those values are not applicable.
|
Column
Name
|
Description
|
|
INDEX_NAME
|
Name
of the index.
|
|
TABLE_NAME
|
Name
of the table which the index is defined on.
|
|
TABLE_OWNER
|
Owner
of the table which the index is defined on.
|
|
UNIQUE
|
Status
flag to indicate uniqueness of the index:
0
- non-unique
1
- unique
3
- primary key
|
|
NUM_COL
|
Number
of columns in the index.
|
|
NUM_PAGE
|
Number
of index pages.
|
|
NUM_LEVEL
|
Number
of levels.
|
|
NUM_LEAF
|
Number
of leaf pages.
|
|
DIST_KEY
|
Number
of distinct keys.
|
|
NUM_PAGE_KEY
|
Number
of pages per key.
|
|
CLSTR_COUNT
|
Cluster
count; the number of page I/O while we use the index to access
data page. It is related to the number of buffers.
|
B.19 SYSINFO
The SYSINFO
table gives status information about the current state of the database.
|
Column
Name
|
Description
|
|
DCCA_SIZE
|
Total
size of DCCA.
|
|
FREE_DCCA_SIZE
|
Available
size of DCCA.
|
|
NUM_MAX_TRANX
|
Maximum
number of transactions at a time.
|
|
NUM_ACT_TRANX
|
Number
of currently active transactions.
|
|
NUM_PAGE_BUF
|
Number
of page buffers.
|
|
NUM_STARTED_TRANX
|
Number
of started transactions.
|
|
NUM_COMMITED_TRANX
|
Number
of committed transactions.
|
|
NUM_ABORTED_TRANX
|
Number
of aborted transactions.
|
|
NUM_CHECKPOINT
|
Number
of specified checkpoints.
|
|
NUM_LOCK_REQUEST
|
Number
of locks requested.
|
|
NUM_SHARE_SEM
|
Number
of share semaphores requested.
|
|
NUM_EX_SEM
|
Number
of exclusive semaphores requested.
|
|
NUM_DEADLOCK
|
Number
of deadlocks detected.
|
|
NUM_PHYSICAL_READ
|
Number
of physical disk reads
|
|
NUM_PHYSICAL_WRITE
|
Number
of physical disk writes
|
|
NUM_LOGICAL_READ
|
Number
of logical reads
|
|
NUM_LOGICAL_WRITE
|
Number
of logical writes
|
|
NUM_JNL_BLK_READ
|
Number
of journal blocks read.
|
|
NUM_JNL_BLK_WRITE
|
Number
of journal blocks written.
|
|
NUM_JNL_REC_WRITE
|
Number
of journal records written.
|
|
NUM_JNL_FRC_WRITE
|
Number
of journal forced writes.
|
|
NUM_COMMIT_WAITER
|
Number
of transactions waiting group commit.
|
|
DDB_MODE
|
Distributed
database mode.
|
|
BACKUP_MODE
|
Backup
mode.
|
|
USER_FO_MODE
|
User
file object mode.
|
|
READ_ONLY_MODE
|
Read-only
mode.
|
|
NO_JOURNAL_MODE
|
No
journal mode.
|
|
TURBO_MODE
|
Turbo
mode.
|
|
FRAME_SIZE
|
BLOB
frame size.
|
|
NUM_JOURNAL_FILE
|
Number
of journal files.
|
|
NUM_JOURNAL_BLOCKS
|
Number
of journal blocks.
|
|
NUM_JNR_BLOCK_FREE
|
Number
of free journal blocks.
|
|
CURRENT_JOURNAL_FN
|
Journal
info.
|
|
CURRENT_JOURNAL_BN
|
Journal
info.
|
|
CREATE_DB_TIME
|
Time
database was created.
|
|
START_DB_TIME
|
Time
database was started.
|
|
VERSION
|
DBMaker
version.
|
|
FILE_VERSION
|
Database
file version.
|
B.20 SYSLOCK
The SYSLOCK
table contains information about the current status of locks on objects
in the database. Note: lock granularity can be SYSTEM, TABLE, PAGE,
or TUPLE, lock status can be GRANTED, WAITING, or CONVERT, and lock
mode can be NONE, IS, S, IX, SIX, or X.
|
Column
Name
|
Description
|
|
LK_OBJECT_ID
|
OID
of locked object.
|
|
TABLE_ID
|
OID
of the table containing the locked object.
|
|
LK_GRAN
|
Lock
granularity.
|
|
HOLD_LK_CONNECTION
|
Connection
ID which is holding the lock on the object.
|
|
LK_STATUS
|
Lock
status.
|
|
LK_CURRENT_MODE
|
Current
lock mode of object.
|
|
LK_NEW_MODE
|
New
lock mode of object.
|
B.21 SYSOPENLINK
The SYSOPENLINK
table contains information on open database links.
|
Column
Name
|
Description
|
|
DB_LINK
|
Open
link.
|
|
DBSVR
|
Server.
|
|
USER_NAME
|
User
name.
|
|
TXN_STATUS
|
Transaction
status.
|
B.22 SYSPROCINFO
The SYSPROCINFO
table contains information on stored procedures.
|
Column
Name
|
Description
|
|
QUALIFIER
|
Qualifier.
|
|
PROC_OWNER
|
Procedure
owner.
|
|
NAME
|
Procedure
name.
|
|
NUM_INPUT_PARAMS
|
Number
of input parameters.
|
|
NUM_OUTPUT_PARAMS
|
Number
of output parameters.
|
|
NUM_RESULT_SETS
|
Number
of result sets.
|
|
REMARKS
|
Remarks.
|
|
PROC_TYPE
|
Procedure
type.
|
B.23 SYSPROCPARAM
The SYSPROCPARAM
table contains information on stored procedure parameters.
|
Column
Name
|
Description
|
|
QUALIFIER
|
Qualifier.
|
|
OWNER
|
Procedure
owner.
|
|
PROC_NAME
|
Procedure
name.
|
|
PARAM_NAME
|
Parameter
name.
|
|
PARAM_TYPE
|
Parameter
type.
|
|
DATA_TYPE
|
Data
type.
|
|
TYPE_NAME
|
Type
name.
|
|
PRECISION
|
Precision.
|
|
LENGTH
|
Length.
|
|
SCALE
|
Scale.
|
|
RADIX
|
Radix.
|
|
NULLABLE
|
Nullable
column.
|
|
REMARKS
|
Remarks.
|
B.24 SYSPROJECT
The SYSPROJECT
table contains information on ESQL projects.
|
Column
Name
|
Description
|
|
PROJECT_NAME
|
Project
name.
|
|
PROJECT_OWNER
|
Project
owner.
|
|
MODULE_NAME
|
Module
name.
|
|
MODULE_OWNER
|
Module
owner.
|
|
MODULE_SOURCE
|
Module
source.
|
|
REF_CMD
|
|
B.25 SYSPUBLISH
The SYSPUBLISH
table contains information on table replication sources.
|
Column
Name
|
Description
|
|
REPLICATION_NAME
|
Name
of replication.
|
|
TYPE
|
Synchronous
or Asynchronous.
|
|
TABLE_OWNER
|
Owner
of table being replicated.
|
|
TABLE_NAME
|
Name
of table being replicated.
|
|
NUM_PROJECT
|
Number
of projected columns.
|
|
FRAGMENT
|
Fragment
string.
|
|
NUM_SUBSCRIBER
|
Number
of subscribers.
|
B.26 SYSSUBSCRIBE
The SYSSUBSCRIBE
table contains information on table replication targets.
|
Column
Name
|
Description
|
|
BASE_TABLE_OWNER
|
Base
table owner.
|
|
BASE_TABLE_NAME
|
Base
table name.
|
|
REPLICATION_NAME
|
Replication
name.
|
|
DB_LINK
|
Database
link.
|
|
TABLE_OWNER
|
Table
owner.
|
|
TABLE_NAME
|
Table
name.
|
B.27 SYSSYNONYM
The SYSSYNONYM
table contains information about any synonyms defined in the database.
|
Column
Name
|
Description
|
|
SNAME
|
Synonym
name.
|
|
OWNER
|
Synonym
owner.
|
|
TV_NAME
|
The
source table/view name of the synonym.
|
|
TV_OWNER
|
Table/view
owner.
|
|
TV_LINK
|
|
|
TV_SERVER
|
|
B.28 SYSTABLE
The SYSTABLE
table contains information about all tables in the database.
|
Column
Name
|
Description
|
|
TABLE_NAME
|
Name
of the table.
|
|
TABLE_OWNER
|
Owner
of the table.
|
|
TABLE_TYPE
|
Table
type: SYSTEM TABLE, TABLE or VIEW.
|
|
LOCKMODE
|
Lock
mode applied to the table:
T
- table lock
P
- page lock
R
- row lock
The
default lock mode is page lock.
|
|
CACHEMODE
|
Cache
mode of the full table scan:
T
- there is caching (true).
F
- there is no caching (false).
|
|
TS_NAME
|
Name
of the tablespace the table is in.
|
|
TABLE_OID
|
The
OID of the table.
|
|
NUM_COL
|
Number
of columns in the table.
|
|
NUM_INDEX
|
Number
of indexes on the table.
|
|
NUM_PAGE
|
Number
of pages in the table. The default value is -1. When the user
updates statistics on the table, the true value of NUM_PAGE will
be returned.
|
|
NUM_ROW
|
Number
of rows in the table. The default value is -1. When the user updates
statistics on the table, the true value of NUM_ROW will be returned.
|
|
AVERAGE_LENGTH
|
Average
length for data in the table. Default value is -1. When the user
updates statistics on the table, the true value of AVERAGE_LENGTH
will be returned.
|
|
CONSTRAINT
|
Constraint
for the table.
|
|
FILLFACTOR
|
The
FILLFACTOR specifies the percentage of the page that can
be filled before it stops allowing new data to be inserted (to
allow room for updates). The default value is 100 (%).
|
|
SERIAL_COL_ID
|
Serial
column is located in the nth column in the table.
|
|
SERIAL_START_NO
|
Serial
column starting number. The default value is 1.
|
|
REMARKS
|
A
description of the table.
|
|
NUM_TRIG
|
Number
of triggers on table.
|
|
NUM_TEXTINDEX
|
Number
of text indexes on table.
|
|
NUM_PUBLICATION
|
Number
of publications on table.
|
|
NUM_DEST
|
Number
of target databases for asynchronous replication.
|
B.29 SYSTABLESPACE
The SYSTABLESPACE
table contains information on all tablespaces in the database.
|
Column
Name
|
Description
|
|
TS_NAME
|
Name
of the tablespace.
|
|
TS_TYPE
|
Type
of tablespace:
1
- AUTOEXTEND.
0
- NORMAL.
|
|
NUM_FILES
|
Number
of files in the tablespace.
|
|
NUM_PAGES
|
Number
of pages in the tablespace. If the tablespace is autoextend, then
NUM_PAGES may be less than the real NUM_PAGES in the tablespace.
|
|
NUM_FREE_PAGES
|
Number
of free pages available in the tablespace.
|
|
NUM_FRAMES
|
|
|
NUM_FREE_FRAMES
|
|
B.30 SYSTEXTINDEX
The SYSTEXTINDEX
table contains information on text indexes.
|
Column
Name
|
Description
|
|
TEXTINDEX_NAME
|
Text
index name.
|
|
TABLE_NAME
|
Table
name.
|
|
TABLE_OWNER
|
Table
owner.
|
|
COLUMN_ID
|
Column
ID.
|
|
TEXT_BLOCK_SIZE
|
Text
block size.
|
|
BASIC_BIT_LENGTH
|
Basic
bit length.
|
|
EXT_BIT_LENGTH
|
Extended
bit length.
|
|
CLUSTER_WIDTH
|
Cluster
width.
|
|
NUM_TEXT_BLOCK
|
Number
of text blocks.
|
|
AVG_TEXT_SIZE
|
Average
text size.
|
B.31 SYSTRIGGER
The SYSTRIGGER
table contains information on triggers.
|
Column
Name
|
Description
|
|
TBNAME
|
Table
name.
|
|
TBOWNER
|
Table
owner.
|
|
TRIGNAME
|
Trigger
name.
|
|
TRIGEVENT
|
Trigger
event.
|
|
NUM_COL
|
Number
of columns.
|
|
SCOL_NUM
|
|
|
TRIGTYPE
|
Trigger
type.
|
|
STATUS
|
Status.
|
|
OLD
|
Old
value.
|
|
NEW
|
New
value.
|
|
MODE
|
|
|
TRIGDEF
|
Trigger
definition.
|
B.32 SYSUSER
The SYSUSER
table contains information on the status of all users currently connected
to the database. Before killing a connection, you should query the SYSUSER
table for the ID of the connection you want to kill. If your login host
name is not registered in the network, LOGIN_HOST is anonymous.
|
Column
Name
|
Description
|
|
CONNECTION_ID
|
Connection
ID.
|
|
USER_NAME
|
Login
user name.
|
|
LOGIN_TIME
|
Login
time.
|
|
LOGIN_IP_ADDR
|
Login
IP address.
|
|
LOGIN_HOST
|
Login
host name.
|
|
NUM_SCAN
|
Number
of SELECT operations.
|
|
NUM_INSERT
|
Number
of INSERT operations.
|
|
NUM_UPDATE
|
Number
of UPDATE operations.
|
|
NUM_DELETE
|
Number
of DELETE operations.
|
|
NUM_TRANX
|
Number
of processed transactions.
|
|
NUM_JBYTE_PER_TRAN
|
Number
of journal bytes per transaction.
|
|
FIRST_W_JNL_FN
|
|
|
FIRST_W_JNL_BN
|
|
|
NUM_BYTE_JNR_DATA
|
|
|
NUM_J_BLOCK_DURATN
|
|
|
SQL_CMD
|
SQL
command.
|
|
TIME_OF_SQL_CMD
|
Time
of SQL command.
|
B.33 SYSUSERFUNC
The SYSUSERFUNC
table contains information on user-defined and built-in functions.
|
Column
Name
|
Description
|
|
MODE
|
Type
of function:
1
- built-in function
|
|
FILE_NAME
|
The
name of the file that the built-in function is in.
|
|
FUNC_NAME
|
The
name of the built-in function.
|
|
RETURN_TYPE
|
Data
type the built-in function returns.
|
|
NUM_OF_PARAMETER
|
The
number of parameters in the function
|
|
PARAMETER
|
Data
type of each parameter. The number of parameters is given by the
value of NUM_OF_PARAMETER.
|
B.34 SYSVIEWDATA
The SYSVIEWDATA
table gives information on the table views in the database.
|
Column
Name
|
Description
|
|
VIEW_NAME
|
Table
view name.
|
|
VIEW_OWNER
|
Table
view owner.
|
|
STATUS
|
0
- invalid view.
1
- valid view.
|
|
VIEW_DEFINITION
|
View
definition.
|
B.35 SYSWAIT
The SYSWAIT
table gives the status of locks which are currently waiting for another
lock on the same object to be released.
|
Column
Name
|
Description
|
|
WAITING_CONNECTION
|
ID
of connection which is waiting.
|
|
WAITED_CONNECTION
|
ID
of connection which is being waited for.
|
|
