COMPTIME | DB2 Universal Database: Timestamp (Format: YYYYMMDDHHMMSS) | X | | CHAR | 14 | |
PARTITN | Partition Number | X | | INT4 | 4 | |
CALLERFLAG | Who Has Called this Program | X | | CHAR | 1 | |
DBMSTRTTME | DB2 Universal Database: Timestamp (Format: YYYYMMDDHHMMSS) | | | CHAR | 14 | |
PRGVERS | Version of Program Inserted this Row | | | CHAR | 20 | |
ADSM_MGMT | adsm_mgmtclass: ADSM Management Class | | | CHAR | 30 | |
ADSM_NODE | adsm_nodename: ADSM Node Name | | | CHAR | 64 | |
ADSM_OWNER | ADSM Owner Name | | | CHAR | 64 | |
ADSM_PW | ADSM Password | | | CHAR | 64 | |
AP_CTL_HP | app_ctl_heap_sz: Application Control Heap Size (Pages 4 KB) | | | INT2 | 2 | |
APPLHEAPSZ | applheapsz: Application Heap Size (4 KB Pages) | | | INT2 | 2 | |
AUTORESTRT | autorestart: Auto Restart Enabled | | | CHAR | 10 | |
AVG_APPLS | avg_appls: Average Number of Active Applications | | | INT2 | 2 | |
BUFFPAGE | buffpage: Buffer Pool Size (Pages 4 KB) | | | INT4 | 4 | |
CATCA_SZ | catalogcache_sz: Catalog Cache Size (Pages 4 KB) | | | INT4 | 4 | |
CHGPGS_THR | chngpgs_thresh: Changed Pages Threshold | | | INT2 | 2 | |
CPPROTECT | copyprotect: Copy Protection Enabled | | | CHAR | 25 | |
DBHEAP | dbheap: Database Heap (Pages 4 KB) | | | INT2 | 2 | |
DFT_DEGREE | dft_degree: Default Degree | | | INT4 | 4 | |
DFT_EXTSZ | dft_extent_sz: Default Extent Size of Tablespace (Pages 4KB) | | | INT4 | 4 | |
DFT_LDRECS | dft_loadrec_ses: Default Number of Load Recovery Sessions | | | INT2 | 2 | |
DFT_PF_SZ | dft_prefetch_sz: Default Prefetch Size (Pages 4 KB) | | | INT2 | 2 | |
DFT_QOPT | dft_queryopt: Default Query Optimization Class | | | INT4 | 4 | |
DFT_SQLMW | dft_sqlmathwarn: Continue at Arithmetic Exception | | | CHAR | 25 | |
DIR_OBJ_NM | DB2 Universal Database: File path | | | CHAR | 255 | |
DISCOVER | discover: Discovery Mode | | | CHAR | 10 | |
DL_EXPINT | dl_expint: DataLink Access Token Expiry Interval | | | INT4 | 4 | |
DL_NUM_BUP | dl_num_backup: DataLink Number of Backups | | | INT2 | 2 | |
DL_NIM_CPS | dl_num_copies: DataLink Number of Copies | | | INT2 | 2 | |
DL_TM_DROP | dl_time_drop: DataLink Time After Drop | | | INT2 | 2 | |
DLCHKTIME | dlchktime: Time Interval for Checking Deadlock | | | INT4 | 4 | |
ESTOR_SQSZ | estore_seg_sz:Extended Storage Memory Segment Size (Pages 4 | | | INT4 | 4 | |
INDEXREC | indexrec: Index Recreation | | | CHAR | 25 | |
INDEXSORT | indexsort: Index Sort Flag | | | CHAR | 25 | |
LCKLIST | locklist: Maximum Storage for Lock List (Pages 4 KB) | | | INT2 | 2 | |
LCKTMOUT | locktimeout: Lock Timeout | | | INT2 | 2 | |
LOGBUFSZ | logbufsz: Log Buffer Size (Pages 4 KB) | | | INT2 | 2 | |
LOGFILSIZ | logfilsiz: Log File Size (Pages 4 KB) | | | INT4 | 4 | |
LOGPRIMARY | logprimary: Number of Primary Log Files | | | INT2 | 2 | |
LOGRETAIN | logretain: Log Retain Enabled | | | CHAR | 10 | |
LOGSECOND | logsecond: Number of Secondary Log Files | | | INT2 | 2 | |
MAXAPPLS | maxappls: Maximum Number of Active Applications | | | INT2 | 2 | |
MAXFILOP | maxfilop: Maximum No. of Database Files Open per Application | | | INT2 | 2 | |
MAXLOCKS | maxlocks: Maximum Percentage of Log List Before Escalation | | | INT2 | 2 | |
MINCOMMIT | mincommit: Numbers of COMMITs to Group | | | INT2 | 2 | |
NEWLOGPATH | DB2 Universal Database: File path | | | CHAR | 255 | |
NUM_EST_SG | num_estore_segs: Number of Extended Storage Memory Segments | | | INT4 | 4 | |
NUM_FRQVAL | num_freqvalues: Number of Frequent Values Retained | | | INT2 | 2 | |
NUM_IOCLNS | num_iocleaners: Number of Asynchronous Page Cleaners | | | INT2 | 2 | |
NUM_IOSVRS | num_ioservers: Number of I/O Servers | | | INT2 | 2 | |
NUM_QUANT | num_quantiles: Number of Quantiles of Columns | | | INT2 | 2 | |
PCKCACHESZ | pckcachesz: Package Cache Size (Pages 4 KB) | | | INT2 | 2 | |
REC_HIS_RT | rec_his_retentn: Recovery History Retention Period | | | INT2 | 2 | |
SEQDETECT | seqdetect: Sequential Detection Flag | | | CHAR | 25 | |
SOFTMAX | softmax: Recovery Range and Soft Checkpoint Interval | | | INT2 | 2 | |
SORTHEAP | sortheap: Sort Heap Size (Pages 4 KB) | | | INT4 | 4 | |
STA_HP_SZ | stat_heap_sz: Statistics Heap Size (Pages 4 KB) | | | INT4 | 4 | |
STMTHEAP | stmtheap: Statement Heap Size (Pages 4 KB) | | | INT2 | 2 | |
USEREXIT | userexit: User Exit Enabled | | | CHAR | 10 | |
UTIL_HP_SZ | util_heap_sz: Utility Heap Size (Pages 4 KB) | | | INT4 | 4 | |
BACKUP_PND | backup_pending: Backup Pending Indicator | | | CHAR | 25 | |
CODEPAGE | codepage: Code Page for the Database | | | INT2 | 2 | |
CODESET | codeset: Code Set for the Database | | | CHAR | 17 | |
COUNTRY | country: Country Code for the Database | | | INT2 | 2 | |
DB_CONSIST | database_consistent: Database is Consistent | | | CHAR | 25 | |
DB_LEVEL | database_level: Database Release Level | | | INT2 | 2 | |
LOG_RET_ST | log_retain_status: Log Retain Status Indicator | | | CHAR | 25 | |
LOGHEAD | loghead: Log Head Identification | | | CHAR | 12 | |
LOGPATH | DB2 Universal Database: File path | | | CHAR | 255 | |
MULTPG_ALO | multipage_alloc: MultiPage File Allocation Enabled | | | CHAR | 25 | |
NEXTACTIVE | nextactive: Next Active Log | | | CHAR | 12 | |
NUMSEGS | numsegs: Default Number of SMS Container | | | INT2 | 2 | |
REL_LEVEL | release: Configuration File Release Level | | | INT2 | 2 | |
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 | |