name |
VARCHAR(60) |
Application group name |
description |
VARCHAR(120) |
Application group description |
agid |
INTEGER |
Application group identifier |
agid_name |
VARCHAR(8) |
Application group internal identifier |
db_seg |
CHAR(1) FOR BIT DATA (DB2®), BINARY(1) (SQL Server), RAW(1)
(Oracle) |
Segment type (Database Organization) |
ann_type |
CHAR(1) FOR BIT DATA (DB2), BINARY(1) (SQL Server), RAW(1)
(Oracle) |
Annotation update |
db_exp_date |
INTEGER |
Expire database indexes |
db_mgrt_date |
INTEGER |
Migrate database indexes |
sm_cache_doc |
INTEGER |
Storage manager cache definition |
resgrp |
INTEGER |
Resource group identifier |
load_id |
INTEGER |
Load Id counter |
log |
INTEGER |
Log mask |
load_id_suffix |
VARCHAR(8) |
Load Id suffix |
mgrt_cache_date |
INTEGER |
Copy cache to archive storage |
reimport_exp_date |
INTEGER |
Number of days to keep imported table before
re-expiring |
sid |
INTEGER |
Storage set identifier |
expire_type |
CHAR(1) FOR BIT DATA (DB2), BINARY(1) (SQL Server), RAW(1)
(Oracle) |
Expiration type |
seg_rows |
INTEGER |
Rows per segment (Maximum Rows) |
seg_id |
INTEGER |
Segment Id counter |
obj_size |
INTEGER |
Size of storage object |
type |
INTEGER |
Type of application group (Data Management;
Create Tablespace Type) |
upd_userid |
VARCHAR(128) |
Last user to update the application group |
upd_date |
BIGINT
(DB2, SQL Server), INT (Oracle) |
Date and time application group was last
updated |
last_doc_date |
BIGINT
(DB2, SQL Server),
INT (Oracle) |
Migrate last document date |
migr_srvr_str |
VARCHAR(254) |
Migrate server string |
sm_cache_delta |
INTEGER |
Delta value of the expiration (number of
days) of cached data |
database_name |
VARCHAR(8) |
Internal database alias name |
sm_cache_res |
INTEGER |
Storage manager resources cache definition |
fti_server |
VARCHAR |
Full text index server |
upd_dt |
TIMESTAMP (DB2, Oracle), DATETIME2(6) (SQL Server) |
Date and time application group
was last updated |
last_doc_dt |
TIMESTAMP (DB2, Oracle), DATETIME2(6) (SQL Server) |
Migrate last document date |
last_load_dt |
TIMESTAMP (DB2, Oracle), DATETIME2(6) (SQL Server) |
Date and time application group
was last loaded |
last_query_dt |
TIMESTAMP (DB2, Oracle), DATETIME2(6) (SQL Server) |
Date and time application group
was last queried |
last_retr_dt |
TIMESTAMP (DB2, Oracle), DATETIME2(6) (SQL Server) |
Date and time application group
was last retrieved |