COMPTIME |
✔ |
DB6: Timestamp (Format: YYYYMMDDHHMMSS) |
DB6TSTAMP |
CHAR |
14 |
|
PARTITN |
✔ |
Partition Number |
|
INT4 |
10 |
|
CALLERFLAG |
✔ |
Who Has Called this Program |
|
CHAR |
1 |
|
DBMSTRTTME |
|
DB6: Timestamp (Format: YYYYMMDDHHMMSS) |
DB6TSTAMP |
CHAR |
14 |
|
PRGVERS |
|
Version of Program Inserted this Row |
|
CHAR |
20 |
|
TSM_MGMT |
|
tsm_mgmtclass: TSM Management Class |
|
CHAR |
30 |
|
TSM_NODE |
|
tssm_nodename: TSM Node Name |
|
CHAR |
64 |
|
TSM_OWNER |
|
tsm_owner: TSM Owner Name |
|
CHAR |
64 |
|
TSM_PW |
|
tsm_Password: TSM Password |
|
CHAR |
64 |
|
AP_CTL_HP |
|
app_ctl_heap_sz: Application Control Heap Size (Pages 4 KB) |
|
INT4 |
10 |
|
APPLHEAPSZ |
|
applheapsz: Application Heap Size (4 KB Pages) |
|
INT4 |
10 |
|
AUTORESTRT |
|
autorestart: Auto Restart Enabled |
|
CHAR |
10 |
|
AVG_APPLS |
|
avg_appls: Average Number of Active Applications |
|
INT4 |
10 |
|
BUFFPAGE |
|
buffpage: Buffer Pool Size (Pages 4 KB) |
|
DEC |
22 |
|
CATCA_SZ |
|
catalogcache_sz: Catalog Cache Size (Pages 4 KB) |
|
DEC |
22 |
|
CHGPGS_THR |
|
chngpgs_thresh: Changed Pages Threshold |
|
INT4 |
10 |
|
CPPROTECT |
|
copyprotect: Copy Protection Enabled |
|
CHAR |
25 |
|
DBHEAP |
|
dbheap: Database Heap (Pages 4 KB) |
|
DEC |
22 |
|
DFT_DEGREE |
|
dft_degree: Default Degree |
|
DEC |
22 |
|
DFT_EXTSZ |
|
dft_extent_sz: Default Extent Size of Tablespace (Pages 4KB) |
|
DEC |
22 |
|
DFT_LDRECS |
|
dft_loadrec_ses: Default Number of Load Recovery Sessions |
|
INT4 |
10 |
|
DFT_PF_SZ |
|
dft_prefetch_sz: Default Prefetch Size (Pages 4 KB) |
|
INT4 |
10 |
|
DFT_QOPT |
|
dft_queryopt: Default Query Optimization Class |
|
DEC |
22 |
|
DFT_SQLMW |
|
dft_sqlmathwarn: Continue at Arithmetic Exception |
|
CHAR |
25 |
|
DIR_OBJ_NM |
|
DB6: File Path |
DB6PATH |
CHAR |
255 |
|
DISCOVER |
|
discover: Discovery Mode |
|
CHAR |
10 |
|
DL_EXPINT |
|
dl_expint: DataLink Access Token Expiry Interval |
|
DEC |
22 |
|
DL_NIM_CPS |
|
dl_num_copies: DataLink Number of Copies |
|
INT4 |
10 |
|
DL_TM_DROP |
|
dl_time_drop: DataLink Time After Drop |
|
INT4 |
10 |
|
DLCHKTIME |
|
dlchktime: Time Interval for Checking Deadlock |
|
DEC |
22 |
|
ESTOR_SQSZ |
|
estore_seg_sz:Extended Storage Memory Segment Size (Pages 4 |
|
DEC |
22 |
|
INDEXREC |
|
indexrec: Index Recreation |
|
CHAR |
25 |
|
INDEXSORT |
|
indexsort: Index Sort Flag |
|
CHAR |
25 |
|
LCKLIST |
|
locklist: Maximum Storage for Lock List (Pages 4 KB) |
|
INT4 |
10 |
|
LCKTMOUT |
|
locktimeout: Lock Timeout |
|
INT4 |
10 |
|
LOGBUFSZ |
|
logbufsz: Log Buffer Size (Pages 4 KB) |
|
INT4 |
10 |
|
LOGFILSIZ |
|
logfilsiz: Log File Size (Pages 4 KB) |
|
DEC |
22 |
|
LOGPRIMARY |
|
logprimary: Number of Primary Log Files |
|
INT4 |
10 |
|
LOGRETAIN |
|
logretain: Log Retain Enabled |
|
CHAR |
10 |
|
LOGSECOND |
|
logsecond: Number of Secondary Log Files |
|
INT4 |
10 |
|
MAXAPPLS |
|
maxappls: Maximum Number of Active Applications |
|
INT4 |
10 |
|
MAXFILOP |
|
maxfilop: Maximum No. of Database Files Open per Application |
|
INT4 |
10 |
|
MAXLOCKS |
|
maxlocks: Maximum Percentage of Log List Before Escalation |
|
INT4 |
10 |
|
MINCOMMIT |
|
mincommit: Numbers of COMMITs to Group |
|
INT4 |
10 |
|
NEWLOGPATH |
|
DB6: File Path |
DB6PATH |
CHAR |
255 |
|
NUM_EST_SG |
|
num_estore_segs: Number of Extended Storage Memory Segments |
|
DEC |
22 |
|
NUM_FRQVAL |
|
num_freqvalues: Number of Frequent Values Retained |
|
INT4 |
10 |
|
NUM_IOCLNS |
|
num_iocleaners: Number of Asynchronous Page Cleaners |
|
INT4 |
10 |
|
NUM_IOSVRS |
|
num_ioservers: Number of I/O Servers |
|
INT4 |
10 |
|
NUM_QUANT |
|
num_quantiles: Number of Quantiles of Columns |
|
INT4 |
10 |
|
PCKCACHESZ |
|
pckcachesz: Package Cache Size (Pages 4 KB) |
|
DEC |
22 |
|
REC_HIS_RT |
|
rec_his_retentn: Recovery History Retention Period |
|
INT4 |
10 |
|
SEQDETECT |
|
seqdetect: Sequential Detection Flag |
|
CHAR |
25 |
|
SOFTMAX |
|
softmax: Recovery Range and Soft Checkpoint Interval |
|
INT4 |
10 |
|
SORTHEAP |
|
sortheap: Sort Heap Size (Pages 4 KB) |
|
DEC |
22 |
|
STA_HP_SZ |
|
stat_heap_sz: Statistics Heap Size (Pages 4 KB) |
|
DEC |
22 |
|
STMTHEAP |
|
stmtheap: Statement Heap Size (Pages 4 KB) |
|
INT4 |
10 |
|
USEREXIT |
|
userexit: User Exit Enabled |
|
CHAR |
10 |
|
UTIL_HP_SZ |
|
util_heap_sz: Utility Heap Size (Pages 4 KB) |
|
DEC |
22 |
|
BACKUP_PND |
|
backup_pending: Backup Pending Indicator |
|
CHAR |
25 |
|
CODEPAGE |
|
codepage: Code Page for the Database |
|
INT4 |
10 |
|
CODESET |
|
codeset: Code Set for the Database |
|
CHAR |
17 |
|
COUNTRY |
|
country: Country Code for the Database |
|
INT4 |
10 |
|
DB_CONSIST |
|
database_consistent: Database is Consistent |
|
CHAR |
25 |
|
DB_LEVEL |
|
database_level: Database Release Level |
|
INT4 |
10 |
|
LOG_RET_ST |
|
log_retain_status: Log Retain Status Indicator |
|
CHAR |
25 |
|
LOGHEAD |
|
loghead: Log Head Identification |
|
CHAR |
12 |
|
LOGPATH |
|
DB6: File Path |
DB6PATH |
CHAR |
255 |
|
MULTPG_ALO |
|
multipage_alloc: MultiPage File Allocation Enabled |
|
CHAR |
25 |
|
NUMSEGS |
|
numsegs: Default Number of SMS Container |
|
INT4 |
10 |
|
REL_LEVEL |
|
release: Configuration File Release Level |
|
INT4 |
10 |
|
REST_PEND |
|
restore_pending: Restore Pending |
|
CHAR |
25 |
|
RFWD_PEND |
|
rollfwd_pending: Rollforward Pending Indicator |
|
CHAR |
25 |
|
TERRITORY |
|
territory: Territory of the Database |
|
CHAR |
33 |
|
UEXIT_STAT |
|
user_exit_status: User Exit Status |
|
CHAR |
25 |
|
DYNQRYMGMT |
|
dyn_query_mgmt: dynamic query management |
|
CHAR |
10 |
|
DFT_REFAGE |
|
dft_refresh_age: default refresh age |
|
CHAR |
25 |
|
DL_UPPER |
|
dl_upper: Data links token in uppercase |
|
CHAR |
25 |
|
DL_TOKEN |
|
dl_token: Data links token algorithem |
|
CHAR |
10 |
|
NUM_DBBKPS |
|
num_db_backups: number of database backups to retain |
|
INT4 |
10 |
|
COLLATESEQ |
|
collating sequence (SYSTEM,COMPATIBILITY,IDENT) |
|
CHAR |
25 |
|