/SDF/DB6PMCD - DB2 Universal Database: Configuration Database

DB2 Universal Database: Configuration Database information is stored in SAP table /SDF/DB6PMCD.
It is part of development package /SDF/STPI_DDIC in software component SV-SMG-SDD. This development package consists of objects that can be grouped under "DDIC for /SDF/STPI Development".

Fields for table /SDF/DB6PMCD

Field Name
Description
Is Key
Data Element
Data Type
Length
Check Table
COMPTIMEDB2 Universal Database: Timestamp (Format: YYYYMMDDHHMMSS)XCHAR14
PARTITNPartition NumberXINT44
CALLERFLAGWho Has Called this ProgramXCHAR1
DBMSTRTTMEDB2 Universal Database: Timestamp (Format: YYYYMMDDHHMMSS)CHAR14
PRGVERSVersion of Program Inserted this RowCHAR20
ADSM_MGMTadsm_mgmtclass: ADSM Management ClassCHAR30
ADSM_NODEadsm_nodename: ADSM Node NameCHAR64
ADSM_OWNERADSM Owner NameCHAR64
ADSM_PWADSM PasswordCHAR64
AP_CTL_HPapp_ctl_heap_sz: Application Control Heap Size (Pages 4 KB)INT22
APPLHEAPSZapplheapsz: Application Heap Size (4 KB Pages)INT22
AUTORESTRTautorestart: Auto Restart EnabledCHAR10
AVG_APPLSavg_appls: Average Number of Active ApplicationsINT22
BUFFPAGEbuffpage: Buffer Pool Size (Pages 4 KB)INT44
CATCA_SZcatalogcache_sz: Catalog Cache Size (Pages 4 KB)INT44
CHGPGS_THRchngpgs_thresh: Changed Pages ThresholdINT22
CPPROTECTcopyprotect: Copy Protection EnabledCHAR25
DBHEAPdbheap: Database Heap (Pages 4 KB)INT22
DFT_DEGREEdft_degree: Default DegreeINT44
DFT_EXTSZdft_extent_sz: Default Extent Size of Tablespace (Pages 4KB)INT44
DFT_LDRECSdft_loadrec_ses: Default Number of Load Recovery SessionsINT22
DFT_PF_SZdft_prefetch_sz: Default Prefetch Size (Pages 4 KB)INT22
DFT_QOPTdft_queryopt: Default Query Optimization ClassINT44
DFT_SQLMWdft_sqlmathwarn: Continue at Arithmetic ExceptionCHAR25
DIR_OBJ_NMDB2 Universal Database: File pathCHAR255
DISCOVERdiscover: Discovery ModeCHAR10
DL_EXPINTdl_expint: DataLink Access Token Expiry IntervalINT44
DL_NUM_BUPdl_num_backup: DataLink Number of BackupsINT22
DL_NIM_CPSdl_num_copies: DataLink Number of CopiesINT22
DL_TM_DROPdl_time_drop: DataLink Time After DropINT22
DLCHKTIMEdlchktime: Time Interval for Checking DeadlockINT44
ESTOR_SQSZestore_seg_sz:Extended Storage Memory Segment Size (Pages 4INT44
INDEXRECindexrec: Index RecreationCHAR25
INDEXSORTindexsort: Index Sort FlagCHAR25
LCKLISTlocklist: Maximum Storage for Lock List (Pages 4 KB)INT22
LCKTMOUTlocktimeout: Lock TimeoutINT22
LOGBUFSZlogbufsz: Log Buffer Size (Pages 4 KB)INT22
LOGFILSIZlogfilsiz: Log File Size (Pages 4 KB)INT44
LOGPRIMARYlogprimary: Number of Primary Log FilesINT22
LOGRETAINlogretain: Log Retain EnabledCHAR10
LOGSECONDlogsecond: Number of Secondary Log FilesINT22
MAXAPPLSmaxappls: Maximum Number of Active ApplicationsINT22
MAXFILOPmaxfilop: Maximum No. of Database Files Open per ApplicationINT22
MAXLOCKSmaxlocks: Maximum Percentage of Log List Before EscalationINT22
MINCOMMITmincommit: Numbers of COMMITs to GroupINT22
NEWLOGPATHDB2 Universal Database: File pathCHAR255
NUM_EST_SGnum_estore_segs: Number of Extended Storage Memory SegmentsINT44
NUM_FRQVALnum_freqvalues: Number of Frequent Values RetainedINT22
NUM_IOCLNSnum_iocleaners: Number of Asynchronous Page CleanersINT22
NUM_IOSVRSnum_ioservers: Number of I/O ServersINT22
NUM_QUANTnum_quantiles: Number of Quantiles of ColumnsINT22
PCKCACHESZpckcachesz: Package Cache Size (Pages 4 KB)INT22
REC_HIS_RTrec_his_retentn: Recovery History Retention PeriodINT22
SEQDETECTseqdetect: Sequential Detection FlagCHAR25
SOFTMAXsoftmax: Recovery Range and Soft Checkpoint IntervalINT22
SORTHEAPsortheap: Sort Heap Size (Pages 4 KB)INT44
STA_HP_SZstat_heap_sz: Statistics Heap Size (Pages 4 KB)INT44
STMTHEAPstmtheap: Statement Heap Size (Pages 4 KB)INT22
USEREXITuserexit: User Exit EnabledCHAR10
UTIL_HP_SZutil_heap_sz: Utility Heap Size (Pages 4 KB)INT44
BACKUP_PNDbackup_pending: Backup Pending IndicatorCHAR25
CODEPAGEcodepage: Code Page for the DatabaseINT22
CODESETcodeset: Code Set for the DatabaseCHAR17
COUNTRYcountry: Country Code for the DatabaseINT22
DB_CONSISTdatabase_consistent: Database is ConsistentCHAR25
DB_LEVELdatabase_level: Database Release LevelINT22
LOG_RET_STlog_retain_status: Log Retain Status IndicatorCHAR25
LOGHEADloghead: Log Head IdentificationCHAR12
LOGPATHDB2 Universal Database: File pathCHAR255
MULTPG_ALOmultipage_alloc: MultiPage File Allocation EnabledCHAR25
NEXTACTIVEnextactive: Next Active LogCHAR12
NUMSEGSnumsegs: Default Number of SMS ContainerINT22
REL_LEVELrelease: Configuration File Release LevelINT22
REST_PENDrestore_pending: Restore PendingCHAR25
RFWD_PENDrollfwd_pending: Rollforward Pending IndicatorCHAR25
TERRITORYterritory: Territory of the DatabaseCHAR33
UEXIT_STATuser_exit_status: User Exit StatusCHAR25
Privacy Policy