Example of the System Parameters Report
This section shows an example of the System Parameters report.
Example of the System Parameters report
LOCATION: OMPDA5 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 1-1
GROUP: N/P SYSTEM PARAMETERS REPORT
MEMBER: N/P
SUBSYSTEM: DA5 ACTUAL FROM: 08/24/16 07:01:00.00
DB2 VERSION: V10
MVS PARMLIB UPDATE PARAMETERS (DSNTIPM) IRLM INSTALLATION PARAMETERS (DSNTIPI)
--------------------------------------- --------------------------------------
SUBSYSTEM DEFAULT (SSID)....................................DA5 IRLM SUBSYSTEM NAME (IRLMSID)...............................IA5
SUPPRESS SOFT ERRORS (SUPERRS)..............................YES IRLM RESOURCE TIMEOUT IN SECONDS (IRLMRWT)...................60
IRLM AUTOMATIC START (IRLMAUT)..............................YES
STORAGE SIZES INSTALLATION PARMS (DSNTIPC,DSNTIPE,DSNTIPE1) IRLM START PROCEDURE NAME (IRLMPRC).....................DA5IRLM
--------------------------------------------------------------- SECONDS DB2 WILL WAIT FOR IRLM START (IRLMSWT)..............120
MAX NO OF DATA SETS CONCURRENTLY IN USE (DSMAX)..........20,000 U LOCK FOR REPEATABLE READ OR READ STABILITY (RRULOCK)......YES
EDM STATEMENT CACHE SIZE IN KB (EDMSTMTC)...............113,386 X LOCK FOR SEARCHED UPDATE/DELETE (XLKUPDLT).................NO
EDM DBD CACHE SIZE IN KB (EDMDBDC)......................102,400 IMS/BMP TIMEOUT FACTOR (BMPTOUT)..............................4
EDM SKELETON POOL SIZE IN KB (EDM_SKELETON_POOL)........102,400 IMS/DLI TIMEOUT FACTOR (DLITOUT)..............................6
MAXIMUM SIZE OF EDM POOL IN BYTES (EDMPOOL)...................0 WAIT FOR RETAINED LOCKS (RETLWAIT)............................0
MAXIMUM SIZE OF SORT POOL IN BYTES (SRTPOOL).........10,240,000 ENABLE DB CHECKING...........................................NO
MAX IN-MEMORY SORT SIZE (MAXSORT_IN_MEMORY).................N/A IRLM INITIALIZATION TIME......................................1
MAXIMUM SIZE OF RID POOL IN KB (MAXRBLK)................400,000
MAX NO OF USERS CONCURRENTLY RUNNING IN DB2 (CTHREAD).......400 IRLM PROCESSING PARAMETERS
MAX NO OF CONCURRENT REMOTE ACTIVE CONNECTIONS (MAXDBAT)....200 --------------------------
MAX NO OF REMOTE CONNECTIONS (CONDBAT)...................10,000 WAIT TIME FOR LOCAL DEADLOCK..............................5,000
MAX NO OF TSO CONNECTIONS (IDFORE)..........................200 NUMBER OF LOCAL CYCLES PER GLOBAL CYCLE.......................1
MAX NO OF BATCH CONNECTIONS (IDBACK)........................200 TIMEOUT INTERVAL.............................................60
MAXIMUM KEPT DYNAMIC STATEMENTS (MAXKEEPD)................5,000 IRLM MAXIMUM CSA USAGE ALLOWED................................0
MAX OPEN FILE REFS (MAXOFILR)...............................100 Z/OS LOCK TABLE HASH ENTRIES..................................0
MANAGE REAL STORAGE (REALSTORAGE_MANAGEMENT)...............AUTO PENDING NUMBER OF HASH ENTRIES................................0
MAXIMUM REAL STORAGE (REALSTORAGE_MAX)........................0 Z/OS LOCK TABLE LIST ENTRIES..................................0
CONTRACT THREAD STORAGE (CONTSTOR)..........................YES MAX 31-BIT IRLM PRIVATE STORAGE.............................N/A
MANAGE THREAD STORAGE (MINSTOR).............................YES MAX 64-BIT IRLM PRIVATE STORAGE.............................N/A
LONG-RUNNING READER IN MINUTES (LRDRTHLD)....................10
DDL TIMEOUT FACTOR (DDLTOX)...................................1 ARCHIVE LOG INSTALLATION PARAMETERS (DSNTIPA)
INDEX CLEANUP THREADS (INDEX_CLEANUP_THREADS)...............N/A ---------------------------------------------
3990 CACHE (SEQCACH)........................................SEQ CATALOG ARCHIVE DATASETS (CATALOG)..........................YES
COPY1 ARCHIVE LOG DEVICE TYPE (UNIT).......................DASD
TRACING, CHECKPOINT < PSEUDO-CLOSE PARAMETERS (DSNTIPN) COPY2 ARCHIVE LOG DEVICE TYPE (UNIT2)...................'BLANK'
------------------------------------------------------- SPACE ALLOCATION METHOD (ALCUNIT)......................CYLINDER
START AUDIT TRACE (AUDITST)..................................NO PRIMARY SPACE ALLOCATION (PRIQTY)...........................100
START GLOBAL TRACE (TRACSTR).................................NO SECONDARY SPACE ALLOCATION (SECQTY)..........................10
TRACE TABLE SIZE IN 4K BYTES (TRACTBL).......................16 ARCHIVE LOG BLOCK SIZE IN BYTES (BLKSIZE)................24,576
LOCAL TRACE TABLE SIZE IN 4K BYTES (TRACLOC).................16 MAXIMUM READ TAPE UNITS (MAXRTU)..............................2
START SMF ACCOUNTING (SMFACCT)................................1 TAPE UNIT DEALLOCATION PERIOD (DEALLCT).................0000:00
START SMF STATISTICS (SMFSTAT)........................1,3,4,5,6 MAX NUMBER OF DATASETS RECORDED IN BSDS (MAXARCH)........10,000
STATISTICS TIME INTERVAL IN MINUTES (STATIME).................1 FIRST ARCHIVE COPY MASS STG GROUP NAME...................'NONE'
SYNCHRONIZATION INTERVAL WITHIN THE HOUR (SYNCVAL)...........NO SECOND ARCHIVE COPY MASS STG GROUP NAME..................'NONE'
ONLINE DATASET STATISTICS TIME INTERVAL IN MIN.(DSSTIME)......5 DAYS TO RETAIN ARCHIVE LOG DATA SETS (ARCRETN)...............30
START MONITOR TRACE (MON).....................................1 ISSUE WTOR BEFORE MOUNT FOR ARCHIVE VOLUME (ARCWTOR)........YES
MONITOR BUFFER SIZE IN BYTES (MONSIZE)................1,048,576 COMPACT DATA (COMPACT).......................................NO
UNICODE IFCIDS (UIFCIDS).....................................NO QUIESCE PERIOD (QUIESCE)......................................5
DDF/RRSAF ACCUM (ACCUMACC)...................................10 SINGLE VOLUME (SVOLARC)......................................NO
AGGREGATION FIELDS (ACCUMUID).................................1
COMPRESS SMF RECS (SMFCOMP).................................OFF
LOCATION: OMPDA5 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 1-2
GROUP: N/P SYSTEM PARAMETERS REPORT
MEMBER: N/P
SUBSYSTEM: DA5 ACTUAL FROM: 08/24/16 07:01:00.00
DB2 VERSION: V10
DISTRIBUTED DATA FACILITY PANEL 2 (DSNTIP5) DEFINE GROUP OR MEMBER (DSNTIPK)
------------------------------------------- --------------------------------
TCP/IP ALREADY VERIFIED (TCPALVER)...........................NO GROUP NAME (GRPNAME)........................................N/P
EXTRA BLOCKS REQ (EXTRAREQ).................................100 MEMBER NAME (MEMBNAME)......................................DA5
EXTRA BLOCKS SRV (EXTRASRV).................................100 MAX NUMBER OF MEMBERS.......................................248
TCP/IP KEEPALIVE (TCPKPALV).................................120 RANDOM ATTACH (RANDOMATT)...................................YES
CONNECTION QUEUE MAX DEPTH (MAXCONQN).......................N/A DEL CF STRUCTS (DEL_CFSTRUCTS_ON_RESTART)....................NO
CONNECTION QUEUE MAX WAIT (MAXCONQW)........................N/A PARALLELISM ASSISTANT (ASSIST)..............................YES
POOL THREAD TIMEOUT (POOLINAC)..............................120 PARALLELISM COORDINATOR (COORDNTR)..........................YES
PROTECTION INSTALLATION PARAMETERS (DSNTIPP) DISTRIBUTED DATA FACILITY PANEL 1 (DSNTIPR)
-------------------------------------------- -------------------------------------------
ARCHIVE LOG RACF PROTECTION (PROTECT)........................NO FACILITY NAME...............................................DDF
DB2 AUTHORIZATION ENABLED (AUTH)............................YES DDF STARTUP OPTION (DDF)...................................AUTO
PLAN AUTHORIZATION CACHE SIZE (AUTHCACH)..................3,072 RLST ACCESS ERROR (RLFERRD).............................NOLIMIT
PACKAGE AUTHORIZATION CACHE SIZE (CACHEPAC)...........5,242,880 RESYNCHRONIZATION INTERVAL IN MINUTES (RESYNC)................2
ROUTINE AUTHORIZATION CACHE SIZE (CACHERAC)...........5,242,880 DBAT STATUS (CMTSTAT)..................................INACTIVE
AUTH EXIT CHECK (AUTHEXIT_CHECK)............................N/A MAX TYPE 1 INACTIVE THREADS (MAXTYPE1)........................0
AUTH EXIT CACHE REFRESH (AUTHEXIT_CACHEREFRESH).............N/A IDLE THREAD TIMEOUT INTERVAL (IDTHTOIN).....................120
SYSTEM ADMINISTRATOR 1 AUTHORIZATION ID (SYSADM)...........LOGO EXTENDED SECURITY (EXTSEC)..................................YES
SYSTEM ADMINISTRATOR 2 AUTHORIZATION ID (SYSADM2)........SYSADM USER ID AND PASSWORD REQUIRED................................NO
SYSTEM OPERATOR 1 AUTHORIZATION ID (SYSOPR1)...............LOGO SQL INTERRUPT PROCESSING DISABLED (SQLINTRP).................NO
SYSTEM OPERATOR 2 AUTHORIZATION ID (SYSOPR2)...............EMIL PRIVATE PROTOCOL (PRIVATE_PROTOCOL)..........................NO
DEFAULT (UNKNOWN) USER AUTHORIZATION ID (DEFLTID).......IBMUSER
RESOURCE LIMIT TABLE CREATOR AUTH ID (RLFAUTH)...........SYSIBM LOCK ESCALATION PARAMETERS (DSNTIPJ)
BIND NEW PACKAGE (BINDNV)...............................BINDADD ------------------------------------
DBA CREATE VIEW (DBACRVW)...................................YES MAX PAGE OR ROW LOCKS PER TABLE SPACE (NUMLKTS)...........2,000
MAX PAGE OR ROW LOCKS PER USER (NUMLKUS).................10,000
DATA DEFINITION CONTROL SUPPORT (DSNTIPZ)
----------------------------------------- LOG INSTALLATION PARAMETERS (DSNTIPL,DSNTIPH)
INSTALL DD CONTROL (RGFINSTL)................................NO ---------------------------------------------
CONTROL ALL APPLICATIONS (RGFDEDPL)..........................NO OUTPUT BUFFER SIZE IN K BYTES (OUTBUFF)...................4,000
REQUIRE FULL NAMES (RGFFULLQ)...............................YES CHECKPOINT TYPE (CHKTYPE)................................SINGLE
UNREGISTERED DDL DEFAULT (RGFDEFLT)......................ACCEPT RECORDS/CHECKPOINT (CHKLOGR)................................N/P
REGISTER TABLE OWNER (RGFCOLID)........................DSNRGCOL MINUTES/CHECKPOINT (CHKMINS)................................N/P
DDL REGISTRATION DATABASE NAME (RGFDBNAM)..............DSNRGFDB CHECKPOINT FREQUENCY (CHKFREQ)..........................500,000
APPL REGISTRATION TABLE NAME (RGFNMPRT).......DSN_REGISTER_APPL UR CHECK FREQUENCY (URCHKTH)..................................0
OBJECT REGISTRATION TABLE NAME (RGFNMORT).....DSN_REGISTER_OBJT UR LOG RECORD WRITTEN THRESHOLD IN KB (URLGWTH)...............0
ESCAPE CHARACTER (RGFESCP)................................X'40' LIMIT BACKOUT (LBACKOUT)...................................AUTO
BACKOUT DURATION (BACKODUR)...................................5
DB2 VERSION INSTALL (DSNTIPA1) PSEUDO-CLOSE FREQUENCY (PCLOSEN)..............................5
------------------------------ PSEUDO-CLOSE TIMER (PCLOSET).................................10
DATA SHARING ENABLED (DSHARE)................................NO CHECKPOINTS BETWEEN LEVEL ID UPDATES (DLDFREQ)................5
CURRENT DB2 RELEASE (NEWFUN)................................YES NUMBER OF ACTIVE LOG COPIES (TWOACTV).........................1
CURRENT DB2 RELEASE - 1......................................NO NUMBER OF ARCHIVE LOG COPIES (TWOARCH)........................1
CURRENT DB2 RELEASE - 2......................................NO COPY 1 PREFIX (ARCPFX1)..........................DSNA5.ARCHLOG1
COMPRESS LOB TS FOR DIRECTORY (COMPRESS_DIRLOB).............N/A COPY 2 PREFIX (ARCPFX2)..........................DSNA5.ARCHLOG2
TIMESTAMP ARCHIVE LOG DATA SETS (TSTAMP)....................YES
LOCATION: OMPDA5 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 1-3
GROUP: N/P SYSTEM PARAMETERS REPORT
MEMBER: N/P
SUBSYSTEM: DA5 ACTUAL FROM: 08/24/16 07:01:00.00
DB2 VERSION: V10
APPLICATION PROGRAMMING DEFAULTS PANEL 1 (DSNTIPF) APPLICATION PROGRAMMING DEFAULTS PANEL 2 (DSNTIP4,DSNTIP41)
-------------------------------------------------- ---------------------------------------------------------------
DEFAULT HOST LANGUAGE (DEFLANG)..........................IBMCOB MINIMUM DIVIDE SCALE (DECDIV3)...............................NO
DECIMAL POINT OPTION (DECIMAL)...........................PERIOD DECIMAL ARITHMETIC (DECARTH)..............................DEC15
DEFAULT DELIMITER (DELIM)...............................DEFAULT USE FOR DYNAMIC RULES (DYNRULS).............................YES
DEFAULT SQL DELIMITER (SQLDELI).........................DEFAULT STATIC DESCRIBE (DESCSTAT)..................................YES
DIST SQL STRING DELIMITER (DSQLDELI)......................APOST DATE FORMAT (DATE)..........................................ISO
DEFAULT MIXED GRAPHIC (MIXED)................................NO TIME FORMAT (TIME)..........................................ISO
EBCDIC SBCS CCSID (SCCSID)................................1,148 LOCAL DATE LENGTH (DATELEN).................................N/A
EBCDIC MBCS CCSID (MCCSID)..................................N/P LOCAL TIME LENGTH (TIMELEN).................................N/A
EBCDIC GBCS CCSID (GCCSID)..................................N/P IMPLICIT TIMEZONE.......................................CURRENT
ASCII SBCS CCSID (ASCCSID)..................................819 STD SQL LANGUAGE (STDSQL)....................................NO
ASCII MBCS CCSID (AMCCSID)..................................N/P PAD NULL-TERMINATED (PADNTSTR)...............................NO
ASCII GBCS CCSID (AGCCSID)..................................N/P APPL COMPAT LEVEL (APPLCOMPAT)..............................N/A
UNICODE SBCS CCSID (USCCSID)................................367 LIKE BLANK INSIGNIFICANT (LIKE_BLANK_INSIGNIFICANT).........N/A
UNICODE MBCS CCSID (UMCCSID)..............................1,208 FULLY QUALIFIED NAME OF DSNHDECP LOAD MODULE...................
UNICODE GBCS CCSID (UGCCSID)..............................1,200 SYS1.DSN.DA5.SDSNEXIT(DSNHDECP)
DEFAULT ENCODING SCHEME (ENSCHEME).......................EBCDIC
APPLICATION ENCODING (APPENSCH)..........................EBCDIC OPERATOR FUNCTIONS INSTALLATION PARAMETERS (DSNTIPO)
LOCALE LC_TYPE (LC_CTYPE)...................................UNI ----------------------------------------------------
DECFLOAT ROUND MODE (DEF_DECFLOAT_ROUND_MODE)...ROUND_HALF_EVEN WTO ROUTE CODES (ROUTCDE).....................................1
DEFAULT CHARSET (CHARSET)..............................ALPHANUM RESOURCE LIMIT FACILITY AUTOMATIC START (RLF)................NO
RESOURCE LIMIT SPECIFICATION TABLE SUFFIX (RLFTBL)...........01
SQL OBJECT DEFAULTS PANEL (DSNTIP7,DSNTIP71,DSNTIP72) RESOURCE LIMIT SPEC TABLE ERROR ACTION (RLFERR).........NOLIMIT
----------------------------------------------------- AUTO BIND (ABIND)...........................................YES
REORDERED ROW FORMAT (RRF)..................................YES ALLOW EXPLAIN AT AUTOBIND (ABEXP)...........................YES
OBJECT CREATE FORMAT (OBJECT_CREATE_FORMAT).................N/A DPROP SUPPORT (EDPROP).......................................NO
UTILITY OBJECT CONVERSION (UTILITY_OBJECT_CONVERSION).......N/A SITE TYPE (SITETYP)...................................LOCALSITE
VARY DS CONTROL INTERVAL (DSVCI)............................YES TRACKER SITE (TRKRSITE)......................................NO
TABLE SPACE ALLOCATION IN KB (TSQTY)..........................0 READ COPY2 ARCHIVE (ARC2FRST)................................NO
INDEX SPACE ALLOCATION IN KB (IXQTY)..........................0 REAL TIME STATS (STATSINT)...................................30
OPTIMIZE EXTENT SIZING (MGEXTSZ)............................YES STATISTICS FEEDBACK (STATFDBK_SCOPE)........................N/A
PAD INDEX BY DEFAULT (PADIX).................................NO PROFILE AUTOSTART (PROFILE_AUTOSTART).......................N/A
DEFAULT PARTITION SEGSIZE (DPSEGSZ)..........................32
PERCENT FREE FOR UPDATE (PCTFREE_UPD).......................N/A ROUTINE PARAMETERS (DSNTIPX)
DEFINE DATA SETS (IMPDSDEF).................................YES ----------------------------
USE DATA COMPRESSION (IMPTSCMP)..............................NO MAX ABEND COUNT (STORMXAB)....................................0
LIMIT KEY CONV PART TAB (IX_TB_PART_CONV_EXCLUDE)...........YES TIMEOUT VALUE (STORTIME)....................................180
PAGE SET PAGE NUMBERING (PAGESET_PAGENUM)...................N/A WLM ENVIRONMENT (WLMENV)......................DSNWLMV10_GENERAL
RETRY STOPPED OBJECTS (RETRY_STOPPED_OBJECTS)................NO MAX OPEN CURSORS (MAX_NUM_CUR)..............................500
RENAME TABLE (RENAMETABLE)..................................N/A MAX STORED PROCS (MAX_ST_PROC)............................2,000
PREVENT ALTER LIMITKEY (PREVENT_ALTERTB_LIMITKEY)...........N/A MAXIMUM NUMBER OF LE TOKENS (LEMAX)..........................20
PREVENT INDEX PART CREATE (PREVENT_NEW_IXCTRL_PART)..........NO BIF COMPATIBILITY (BIF_COMPATIBILITY)...................CURRENT
DDL MATERIALIZATION (DDL_MATERIALIZATION)...................N/A
DEFAULT INSERT ALGORITHM (DEFAULT_INSERT_ALGORITHM).........N/A BUFFER POOL PARAMETERS (DSNTIP1)
--------------------------------
PERFORMANCE AND OPTIMIZATION (DSNTIP8,DSNTIP81) DEFAULT 4-KB BUFFER POOL FOR USER DATA (TBSBPOOL)..........BP2
----------------------------------------------- DEFAULT 8-KB BUFFER POOL FOR USER DATA (TBSBP8K).........BP8K0
CACHE DYNAMIC SQL (CACHEDYN)................................YES DEFAULT 16-KB BUFFER POOL FOR USER DATA (TBSBP16K).......BP16K0
CACHE DYN STABILITY (CACHEDYN_STABILIZATION)................N/P DEFAULT 32-KB BUFFER POOL FOR USER DATA (TBSBP32K)........BP32K
OPTIMIZATION HINTS ALLOWED (OPTHINTS)........................NO DEFAULT BUFFER POOL FOR USER LOB DATA (TBSBPLOB)............BP9
EVALUATE UNCOMMITTED (EVALUNC)...............................NO DEFAULT BUFFER POOL FOR USER XML DATA (TBSBPXML).........BP16K0
LOCATION: OMPDA5 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 1-4
GROUP: N/P SYSTEM PARAMETERS REPORT
MEMBER: N/P
SUBSYSTEM: DA5 ACTUAL FROM: 08/24/16 07:01:00.00
DB2 VERSION: V10
SKIP UNCOMM INSERTS (SKIPUNCI)...............................NO DEFAULT BUFFER POOL FOR USER INDEXES (IDXBPOOL).............BP1
IMMEDWRITE OVERRIDE FLAG (IMMEDWRI)..........................NO
REBIND PLANMGMT DEFAULT (PLANMGMT)..........................OFF QUERY ACCELERATOR PREFERENCES (DSNTIP82)
PLANMGMTSCOPE DEFAULT (PLANMGMTSCOPE)....................STATIC ----------------------------------------
PACKAGE RELEASE COMMIT (PKGREL_COMMIT)......................N/A ACCELERATOR STARTUP OPTION (ACCEL).........................AUTO
RANDOMIZE XML DOCID (XML_RANDOMIZE_DOCID)....................NO GET ACCEL ARCHIVE (GET_ACCEL_ARCHIVE)........................NO
DISABLE EDM RTS (DISABLE_EDMRTS).............................NO ACCELERATION OPTIONS (QUERY_ACCEL_OPTIONS)..............(1,2,3)
CURRENT DEGREE (CDSSRDEF)...................................ANY CURRENT QUERY ACCEL (QUERY_ACCELERATION)...................NONE
MAX DEGREE OF PARALLELISM (PARAMDEG)..........................0 ACCELERATION MODELING (ACCELMODEL)...........................NO
MAX DEGREE FOR DPSI (PARAMDEG_DPSI).........................N/A REMOTE COPY SW ACCEL (REMOTE_COPY_SW_ACCEL)..................NO
PARALLELISM EFFICIENCY (PARA_EFF)............................50
STAR JOIN ENABLING (STARJOIN) ..........................DISABLE WORKFILE DATABASE PANEL (DSNTIP91)
MAX DATA CACHING IN MB (MXDTCACH)............................20 ----------------------------------
CURRENT REFRESH AGE (REFSHAGE)................................0 MAX TEMP STORAGE PER AGENT IN MB (MAXTEMPS)...................0
CURRENT MAINT TYPE (MAINTYPE)............................SYSTEM SEPARATE WORK FILES (WFDBSEP)................................NO
VARCHAR FROM INDEX (RETVLCFK)................................NO MAX TEMP RID (MAXTEMPS_RID).............................NOLIMIT
STATS PROFILE FEEDBACK (STATFDBK_PROFILE)...................N/A AGENT LEVEL THRESHOLD (WFSTGUSE_AGENT_THRESHOLD)............N/A
SYSTEM LEVEL THRESHOLD (WFSTGUSE_SYSTEM_THRESHOLD)..........N/A
LOCATION: OMPDA5 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 1-5
GROUP: N/P SYSTEM PARAMETERS REPORT
MEMBER: N/P
SUBSYSTEM: DA5 ACTUAL FROM: 08/24/16 07:01:00.00
DB2 VERSION: V10
OTHER SYSTEM PARAMETERS DB2 UTILITIES PARAMETERS (DSNTIP6,DSNTIP61,DSNTIP62)
----------------------- ----------------------------------------------------
DUAL BSDS MODE (TWOBSDS)....................................YES TEMPORARY UNIT NAME (VOLTDEVT)............................SYSDA
ROLL UP PARALLEL TASK ACCOUNTING (PTASKROL).................YES UTIL TEMP STORCLAS (UTIL_TEMP_STORCLAS).....................N/P
NO. PAGES SMALL TABLE THRESHOLD (NPGTHRSH)....................0 STATISTICS HISTORY (STATHIST)..............................NONE
OFFLOAD OPTION (OFFLOAD)....................................YES STATISTICS ROLLUP (STATROLL)................................YES
SU CONVERSION FACTOR........................................247 UTILITY TIMEOUT FACTOR (UTIMOUT)..............................6
MINIMUM DIVIDE SCALE (MINDVSCL)............................NONE UT SORT DATA SET ALLOCATION (UTSORTAL)......................YES
STAR JOIN THRESHOLD (SJTABLES)...............................10 IGNORE SORTNUM STMT (IGNSORTN)...............................NO
ONLINE SYSTEM PARM USER ID MONITOR..........................N/P SET CHECK PENDING (CHECK_SETCHKP)............................NO
ONLINE SYSTEM PARM CORREL ID MONITOR........................N/P UT DB2 SORT USE (DB2SORT)...................................YES
ONLINE SYSTEM PARM TIME CHANGED.............................N/P TEMPLATE TIME (TEMPLATE_TIME)...............................N/A
ONLINE SYSTEM PARM TYPE.....................................N/P MAXIMUM DEGREE OF UTILITY PARALLELISM (PARAMDEG_UTIL).......N/A
DB2-SUPPLIED DECP INDICATOR...............................X'D5' FAST REPLICATION (CHECK_FASTREPLICATION)...............REQUIRED
MAX CONCURRENT PKG OPS (MAX_CONCURRENT_PKG_OPS)..............10 FAST RESTORE (REC_FASTREPLICATION)....................PREFERRED
ADMIN SCHEDULER JCL PROC NAME (ADMTPROC)....................N/P COPY FAST REPLICATION (COPY_FASTREPLICATION)................N/A
FREE LOCAL CACHED STATEMENTS (CACHEDYN_FREELOCAL).............0 FLASHCOPY PPRC (FLASHCOPY_PPRC)........................REQUIRED
INDEX I/O PARALLELISM (INDEX_IO_PARALLELISM)................YES DEFAULT TEMPLATE (FCCOPYDDN)...................................
ZOSMETRICS..................................................YES DSNA5.<DB..<SN..N<DSNUM..<UQ.
USE TRACKMOD FOR IMPLICIT TS (IMPTKMOD).....................YES FLASHCOPY COPY (FLASHCOPY_COPY)..............................NO
DSSIZE FOR IMPLICIT TS (IMPDSSIZE)............................4 FLASHCOPY LOAD (FLASHCOPY_LOAD)..............................NO
ENABLE MULTIPLE INDEX ACCESS (SUBQ_MIDX).....................NO FLASHCOPY REORG TABLESPACE (FLASHCOPY_REORG_TS)..............NO
SP_PARMS_JV (DDF_COMPATIBILITY)..............................NO FLASHCOPY REBUILD INDEX (FLASHCOPY_REBUILD_INDEX)............NO
SP_PARMS_NJV (DDF_COMPATIBILITY).............................NO FLASHCOPY REORG INDEX (FLASHCOPY_REORG_INDEX)................NO
DISABLE_IMPCAST_JV (DDF_COMPATIBILITY).......................NO SYSTEM-LEVEL BACKUPS (SYSTEM_LEVEL_BACKUPS)..................NO
DISABLE_IMPCAST_NJV (DDF_COMPATIBILITY)......................NO RESTORE/RECOVER (RESTORE_RECOVER_FROMDUMP)...................NO
IGNORE_TZ (DDF_COMPATIBILITY)...............................N/A DUMP CLASS NAME (UTILS_DUMP_CLASS_NAME).................'BLANK'
DDF COMP PRIOR VERSION (DDF_COMPATIBILITY)..................N/P MAXIMUM TAPE UNITS (RESTORE_TAPEUNITS)........................0
DYN STMT CACHE STOR (CACHE_DEP_TRACK_STOR_LIM)..............N/A REORG PART SORT NPSI (REORG_PART_SORT_NPSI).................N/A
ACTIVATE I/O SCHEDULING.....................................YES REORG LIST PROCESSING (REORG_LIST_PROCESSING)..........PARALLEL
VALUE FOR TRIGGER DRAIN.......................................1 REORG MAPPING DATABASE (REORG_MAPPING_DATABASE).............N/A
MAX NUMBER OF DDS WITH HOLD...................................3 REORG DROP PBG PARTS (REORG_DROP_PBG_PARTS).................N/A
FIELD PROCS FOR DESCRIBE TABLE BLOCK..........................5 REORG IGNORE FREESPACE (REORG_IGNORE_FREESPACE).............N/A
RESTRICT ALTER COLUMN FOR DCC (RESTRICT_ALT_COL_FOR_DCC).....NO UTILITY CACHE OPTION (SEQPRES)..............................YES
SPACE RESERVED FOR Z/OS FUNCTIONS........................40,960 STATISTICS CLUSTERING (STATCLUS).......................ENHANCED
SPACE RESERVED FOR CRITICAL WORK.....................39,387,136 ALTERNATE COPYPOOL (ALTERNATE_CP)...........................N/A
SPACE RESERVED ON TOP OF Z/OS AND CRITICAL SPACE.....39,387,136 DB BACKUP STG GROUP (UTIL_DBBSG)............................N/A
DETAILED MEASURED UNIT PRICE TRACKING........................NO LOG BACKUP STG GROUP (UTIL_LGBSG)...........................N/A
OTC LICENSE TERMS ACCEPTED...................................NO HSM MESSAGE DS HLQ (UTILS_HSM_MSGDS_HLQ)....................N/A
SIMULATED CPUS................................................0
EXECUTION TIME OF TASK/SRB IN MICROSECONDS....................0 DATABASES AND SPACES STARTED AUTOMATICALLY (DSNTIPS)
MAX 'NOT FOUND' HASH RECORDS................................100 ----------------------------------------------------
MAX EXTEND SERVICE TASKS.....................................20 ALL
PROJECT Z INSERTION THRESHOLD.................................2
MAX ZIVLEMPEL DICTIONARY ENTRIES..........................4,096 ICF CATALOG QUALIFIERS
REORG KEEPDICTIONARY IN BRF TO RRF CONVERSION................NO ----------------------
DRDA RESOLVE ALIAS (DRDA_RESOLVE_ALIAS).....................YES DSNA5
PC YES SPECIFIED............................................YES
BLOCK OPT 1 ROW SORT (OPT1ROWBLOCKSORT)......................NO SIZES PANEL 1 (DSNTIPD)
SMS DATACLASS NAME FOR TS (SMSDCFL).........................N/P -----------------------
SMS DATACLASS NAME FOR IS (SMSDCIX).........................N/P LOB INLINE LENGTH (LOB_INLINE_LENGTH).........................0
OUTER JOIN PERFORMANCE ENHANCEMENTS (OJPERFEH)..............YES USER LOB VALUE STORAGE IN KB (LOBVALA)...................10,240
LOCATION: OMPDA5 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 1-6
GROUP: N/P SYSTEM PARAMETERS REPORT
MEMBER: N/P
SUBSYSTEM: DA5 ACTUAL FROM: 08/24/16 07:01:00.00
DB2 VERSION: V10
EMPTY XML ELEMENT (XML_RESTRICT_EMPTY_TAG)...................NO SYSTEM LOB VALUE STORAGE IN MB (LOBVALS)..................4,096
SUPPRESS_HINT_SQLCODE_DYN (SUPPRESS_HINT_SQLCODE_DYN) .......NO USER XML VALUE STG IN KB (XMLVALA)......................204,800
INDEX MEMORY CONTROL (INDEX_MEMORY_CONTROL).................N/A SYSTEM XML VAL STG IN MB (XMLVALS).......................10,240
SELECT FOR UNLOAD (AUTH_COMPATIBILITY)......................N/A
MATERIALIZE NODET SQLTUDF (MATERIALIZE_NODET_SQLTUDF).......N/A PROTECTION PANEL (DSNTIPP1)
---------------------------
DEFAULT STARTUP MODULES (DSNTIPO3) SECURITY ADMINISTRATOR 1 AUTHORIZATION ID (SECADM1)......SECADM
---------------------------------- SECURITY ADMINISTRATOR 1 TYPE (SECADM1_TYPE).............AUTHID
PARAMETER MODULE.......................................DSNZPARM SECURITY ADMINISTRATOR 2 AUTHORIZATION ID (SECADM2)......SECADM
ACCESS CONTROL (ACCESS_CNTL_MODULE)....................DSNX§XAC SECURITY ADMINISTRATOR 2 TYPE (SECADM2_TYPE).............AUTHID
IDENTIFY/AUTH (IDAUTH_MODULE)..........................DSN3§ATH SEPARATE SECURITY DUTIES (SEPARATE_SECURITY).................NO
SIGNON (SIGNON_MODULE).................................DSN3§SGN INCLUDE DEPENDENT PRIVILEGES (REVOKE_DEP_PRIVILEGES).........NO
LOCATION: OMPDA5 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 1-7
GROUP: N/P SYSTEM PARAMETERS REPORT
MEMBER: N/P
SUBSYSTEM: DA5 ACTUAL FROM: 08/24/16 07:01:00.00
DB2 VERSION: V10
DB2 CATALOG AND DIRECTORY PANEL (DSNTIPA2)
------------------------------------------
SMS DATA CLASS FOR CATALOG DATA (CATDDACL)................XVSAM
SMS MANAGEMENT CLASS FOR CATALOG DATA (CATDMGCL)............DB2
SMS STORAGE CLASS FOR CATALOG DATA (CATDSTCL)...............DB2
SMS DATA CLASS FOR CATALOG INDEX DATA (CATXDACL)..........XVSAM
SMS MANAGEMENT CLASS FOR CATALOG INDEX DATA (CATXMGCL)......DB2
SMS STORAGE CLASS FOR CATALOG INDEX DATA (CATXSTCL).........DB2
COMPRESS SPT01 (COMPRESS_SPT01)..............................NO
SPT01 INLINE LENGTH (SPT01_INLINE_LENGTH)................32,138
LOCATION: OMPDA5 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 1-8
GROUP: N/P SYSTEM PARAMETERS REPORT
MEMBER: N/P
SUBSYSTEM: DA5 ACTUAL FROM: 08/24/16 07:01:00.00
DB2 VERSION: V10
BUFFER POOL PARAMETERS
--------------------------------------------------------------------------------------------------------------
TIMESTAMP 08/24/16 07:01:00.00 VPOOL SIZE (PAGES) 2000
BUFFER POOL ID BP0 VPOOL SEQ THRESH 80
HORIZ DEFER WRITE THRESH 30
VERT DEFER WRITE THRESH (%) 5
VERT DEFER WRITE THRESH (BUF) 0
VPOOL PARALLEL SEQ THRESH 50
ASSISTING PARALLEL SEQ THRESH 0
PGFIX ATTRIBUTE NO
PAGE STEAL METHOD LRU
AUTOSIZE NO
FRAMESIZE N/A
VPOOL SIZE MIN N/A
VPOOL SIZE MAX N/A
SIM POOL SIZE N/A
SIM POOL SEQ THRESH N/A
TIMESTAMP 08/24/16 07:01:00.00 VPOOL SIZE (PAGES) 10000
BUFFER POOL ID BP1 VPOOL SEQ THRESH 80
HORIZ DEFER WRITE THRESH 30
VERT DEFER WRITE THRESH (%) 5
VERT DEFER WRITE THRESH (BUF) 0
VPOOL PARALLEL SEQ THRESH 50
ASSISTING PARALLEL SEQ THRESH 0
PGFIX ATTRIBUTE NO
PAGE STEAL METHOD LRU
AUTOSIZE NO
FRAMESIZE N/A
VPOOL SIZE MIN N/A
VPOOL SIZE MAX N/A
SIM POOL SIZE N/A
SIM POOL SEQ THRESH N/A
TIMESTAMP 08/24/16 07:01:00.00 VPOOL SIZE (PAGES) 4
BUFFER POOL ID BP2 VPOOL SEQ THRESH 80
HORIZ DEFER WRITE THRESH 30
VERT DEFER WRITE THRESH (%) 5
VERT DEFER WRITE THRESH (BUF) 0
VPOOL PARALLEL SEQ THRESH 50
ASSISTING PARALLEL SEQ THRESH 0
PGFIX ATTRIBUTE NO
PAGE STEAL METHOD LRU
AUTOSIZE NO
FRAMESIZE N/A
VPOOL SIZE MIN N/A
VPOOL SIZE MAX N/A
SIM POOL SIZE N/A
SIM POOL SEQ THRESH N/A
LOCATION: OMPDA5 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 1-9
GROUP: N/P SYSTEM PARAMETERS REPORT
MEMBER: N/P
SUBSYSTEM: DA5 ACTUAL FROM: 08/24/16 07:01:00.00
DB2 VERSION: V10
BUFFER POOL PARAMETERS
--------------------------------------------------------------------------------------------------------------
TIMESTAMP 08/24/16 07:01:00.00 VPOOL SIZE (PAGES) 2000
BUFFER POOL ID BP3 VPOOL SEQ THRESH 80
HORIZ DEFER WRITE THRESH 30
VERT DEFER WRITE THRESH (%) 5
VERT DEFER WRITE THRESH (BUF) 0
VPOOL PARALLEL SEQ THRESH 50
ASSISTING PARALLEL SEQ THRESH 0
PGFIX ATTRIBUTE NO
PAGE STEAL METHOD LRU
AUTOSIZE NO
FRAMESIZE N/A
VPOOL SIZE MIN N/A
VPOOL SIZE MAX N/A
SIM POOL SIZE N/A
SIM POOL SEQ THRESH N/A
TIMESTAMP 08/24/16 07:01:00.00 VPOOL SIZE (PAGES) 2000
BUFFER POOL ID BP4 VPOOL SEQ THRESH 80
HORIZ DEFER WRITE THRESH 30
VERT DEFER WRITE THRESH (%) 5
VERT DEFER WRITE THRESH (BUF) 0
VPOOL PARALLEL SEQ THRESH 50
ASSISTING PARALLEL SEQ THRESH 0
PGFIX ATTRIBUTE NO
PAGE STEAL METHOD LRU
AUTOSIZE NO
FRAMESIZE N/A
VPOOL SIZE MIN N/A
VPOOL SIZE MAX N/A
SIM POOL SIZE N/A
SIM POOL SEQ THRESH N/A
TIMESTAMP 08/24/16 07:01:00.00 VPOOL SIZE (PAGES) 10000
BUFFER POOL ID BP7 VPOOL SEQ THRESH 80
HORIZ DEFER WRITE THRESH 30
VERT DEFER WRITE THRESH (%) 5
VERT DEFER WRITE THRESH (BUF) 0
VPOOL PARALLEL SEQ THRESH 50
ASSISTING PARALLEL SEQ THRESH 0
PGFIX ATTRIBUTE NO
PAGE STEAL METHOD LRU
AUTOSIZE NO
FRAMESIZE N/A
VPOOL SIZE MIN N/A
VPOOL SIZE MAX N/A
SIM POOL SIZE N/A
SIM POOL SEQ THRESH N/A
LOCATION: OMPDA5 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 1-10
GROUP: N/P SYSTEM PARAMETERS REPORT
MEMBER: N/P
SUBSYSTEM: DA5 ACTUAL FROM: 08/24/16 07:01:00.00
DB2 VERSION: V10
BUFFER POOL PARAMETERS
--------------------------------------------------------------------------------------------------------------
TIMESTAMP 08/24/16 07:01:00.00 VPOOL SIZE (PAGES) 100
BUFFER POOL ID BP9 VPOOL SEQ THRESH 80
HORIZ DEFER WRITE THRESH 30
VERT DEFER WRITE THRESH (%) 5
VERT DEFER WRITE THRESH (BUF) 0
VPOOL PARALLEL SEQ THRESH 50
ASSISTING PARALLEL SEQ THRESH 0
PGFIX ATTRIBUTE NO
PAGE STEAL METHOD LRU
AUTOSIZE NO
FRAMESIZE N/A
VPOOL SIZE MIN N/A
VPOOL SIZE MAX N/A
SIM POOL SIZE N/A
SIM POOL SEQ THRESH N/A
TIMESTAMP 08/24/16 07:01:00.00 VPOOL SIZE (PAGES) 2000
BUFFER POOL ID BP10 VPOOL SEQ THRESH 80
HORIZ DEFER WRITE THRESH 30
VERT DEFER WRITE THRESH (%) 5
VERT DEFER WRITE THRESH (BUF) 0
VPOOL PARALLEL SEQ THRESH 50
ASSISTING PARALLEL SEQ THRESH 0
PGFIX ATTRIBUTE NO
PAGE STEAL METHOD LRU
AUTOSIZE NO
FRAMESIZE N/A
VPOOL SIZE MIN N/A
VPOOL SIZE MAX N/A
SIM POOL SIZE N/A
SIM POOL SEQ THRESH N/A
TIMESTAMP 08/24/16 07:01:00.00 VPOOL SIZE (PAGES) 2000
BUFFER POOL ID BP11 VPOOL SEQ THRESH 80
HORIZ DEFER WRITE THRESH 30
VERT DEFER WRITE THRESH (%) 5
VERT DEFER WRITE THRESH (BUF) 0
VPOOL PARALLEL SEQ THRESH 50
ASSISTING PARALLEL SEQ THRESH 0
PGFIX ATTRIBUTE NO
PAGE STEAL METHOD LRU
AUTOSIZE NO
FRAMESIZE N/A
VPOOL SIZE MIN N/A
VPOOL SIZE MAX N/A
SIM POOL SIZE N/A
SIM POOL SEQ THRESH N/A
LOCATION: OMPDA5 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 1-11
GROUP: N/P SYSTEM PARAMETERS REPORT
MEMBER: N/P
SUBSYSTEM: DA5 ACTUAL FROM: 08/24/16 07:01:00.00
DB2 VERSION: V10
BUFFER POOL PARAMETERS
--------------------------------------------------------------------------------------------------------------
TIMESTAMP 08/24/16 07:01:00.00 VPOOL SIZE (PAGES) 2000
BUFFER POOL ID BP13 VPOOL SEQ THRESH 80
HORIZ DEFER WRITE THRESH 30
VERT DEFER WRITE THRESH (%) 5
VERT DEFER WRITE THRESH (BUF) 0
VPOOL PARALLEL SEQ THRESH 50
ASSISTING PARALLEL SEQ THRESH 0
PGFIX ATTRIBUTE NO
PAGE STEAL METHOD LRU
AUTOSIZE NO
FRAMESIZE N/A
VPOOL SIZE MIN N/A
VPOOL SIZE MAX N/A
SIM POOL SIZE N/A
SIM POOL SEQ THRESH N/A
TIMESTAMP 08/24/16 07:01:00.00 VPOOL SIZE (PAGES) 2000
BUFFER POOL ID BP14 VPOOL SEQ THRESH 80
HORIZ DEFER WRITE THRESH 30
VERT DEFER WRITE THRESH (%) 5
VERT DEFER WRITE THRESH (BUF) 0
VPOOL PARALLEL SEQ THRESH 50
ASSISTING PARALLEL SEQ THRESH 0
PGFIX ATTRIBUTE NO
PAGE STEAL METHOD LRU
AUTOSIZE NO
FRAMESIZE N/A
VPOOL SIZE MIN N/A
VPOOL SIZE MAX N/A
SIM POOL SIZE N/A
SIM POOL SEQ THRESH N/A
TIMESTAMP 08/24/16 07:01:00.00 VPOOL SIZE (PAGES) 1500
BUFFER POOL ID BP15 VPOOL SEQ THRESH 80
HORIZ DEFER WRITE THRESH 30
VERT DEFER WRITE THRESH (%) 5
VERT DEFER WRITE THRESH (BUF) 0
VPOOL PARALLEL SEQ THRESH 50
ASSISTING PARALLEL SEQ THRESH 0
PGFIX ATTRIBUTE NO
PAGE STEAL METHOD LRU
AUTOSIZE NO
FRAMESIZE N/A
VPOOL SIZE MIN N/A
VPOOL SIZE MAX N/A
SIM POOL SIZE N/A
SIM POOL SEQ THRESH N/A
LOCATION: OMPDA5 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 1-12
GROUP: N/P SYSTEM PARAMETERS REPORT
MEMBER: N/P
SUBSYSTEM: DA5 ACTUAL FROM: 08/24/16 07:01:00.00
DB2 VERSION: V10
BUFFER POOL PARAMETERS
--------------------------------------------------------------------------------------------------------------
TIMESTAMP 08/24/16 07:01:00.00 VPOOL SIZE (PAGES) 2200
BUFFER POOL ID BP17 VPOOL SEQ THRESH 80
HORIZ DEFER WRITE THRESH 30
VERT DEFER WRITE THRESH (%) 5
VERT DEFER WRITE THRESH (BUF) 0
VPOOL PARALLEL SEQ THRESH 50
ASSISTING PARALLEL SEQ THRESH 0
PGFIX ATTRIBUTE NO
PAGE STEAL METHOD LRU
AUTOSIZE NO
FRAMESIZE N/A
VPOOL SIZE MIN N/A
VPOOL SIZE MAX N/A
SIM POOL SIZE N/A
SIM POOL SEQ THRESH N/A
TIMESTAMP 08/24/16 07:01:00.00 VPOOL SIZE (PAGES) 1000
BUFFER POOL ID BP32K VPOOL SEQ THRESH 80
HORIZ DEFER WRITE THRESH 30
VERT DEFER WRITE THRESH (%) 5
VERT DEFER WRITE THRESH (BUF) 0
VPOOL PARALLEL SEQ THRESH 50
ASSISTING PARALLEL SEQ THRESH 0
PGFIX ATTRIBUTE NO
PAGE STEAL METHOD LRU
AUTOSIZE NO
FRAMESIZE N/A
VPOOL SIZE MIN N/A
VPOOL SIZE MAX N/A
SIM POOL SIZE N/A
SIM POOL SEQ THRESH N/A
TIMESTAMP 08/24/16 07:01:00.00 VPOOL SIZE (PAGES) 10000
BUFFER POOL ID BP8K0 VPOOL SEQ THRESH 80
HORIZ DEFER WRITE THRESH 30
VERT DEFER WRITE THRESH (%) 5
VERT DEFER WRITE THRESH (BUF) 0
VPOOL PARALLEL SEQ THRESH 50
ASSISTING PARALLEL SEQ THRESH 0
PGFIX ATTRIBUTE NO
PAGE STEAL METHOD LRU
AUTOSIZE NO
FRAMESIZE N/A
VPOOL SIZE MIN N/A
VPOOL SIZE MAX N/A
SIM POOL SIZE N/A
SIM POOL SEQ THRESH N/A
LOCATION: OMPDA5 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 1-13
GROUP: N/P SYSTEM PARAMETERS REPORT
MEMBER: N/P
SUBSYSTEM: DA5 ACTUAL FROM: 08/24/16 07:01:00.00
DB2 VERSION: V10
BUFFER POOL PARAMETERS
--------------------------------------------------------------------------------------------------------------
TIMESTAMP 08/24/16 07:01:00.00 VPOOL SIZE (PAGES) 5000
BUFFER POOL ID BP8K1 VPOOL SEQ THRESH 80
HORIZ DEFER WRITE THRESH 30
VERT DEFER WRITE THRESH (%) 5
VERT DEFER WRITE THRESH (BUF) 0
VPOOL PARALLEL SEQ THRESH 50
ASSISTING PARALLEL SEQ THRESH 0
PGFIX ATTRIBUTE NO
PAGE STEAL METHOD LRU
AUTOSIZE NO
FRAMESIZE N/A
VPOOL SIZE MIN N/A
VPOOL SIZE MAX N/A
SIM POOL SIZE N/A
SIM POOL SEQ THRESH N/A
TIMESTAMP 08/24/16 07:01:00.00 VPOOL SIZE (PAGES) 2000
BUFFER POOL ID BP8K4 VPOOL SEQ THRESH 80
HORIZ DEFER WRITE THRESH 30
VERT DEFER WRITE THRESH (%) 5
VERT DEFER WRITE THRESH (BUF) 0
VPOOL PARALLEL SEQ THRESH 50
ASSISTING PARALLEL SEQ THRESH 0
PGFIX ATTRIBUTE NO
PAGE STEAL METHOD LRU
AUTOSIZE YES
FRAMESIZE N/A
VPOOL SIZE MIN N/A
VPOOL SIZE MAX N/A
SIM POOL SIZE N/A
SIM POOL SEQ THRESH N/A
TIMESTAMP 08/24/16 07:01:00.00 VPOOL SIZE (PAGES) 2000
BUFFER POOL ID BP8K5 VPOOL SEQ THRESH 80
HORIZ DEFER WRITE THRESH 30
VERT DEFER WRITE THRESH (%) 5
VERT DEFER WRITE THRESH (BUF) 0
VPOOL PARALLEL SEQ THRESH 50
ASSISTING PARALLEL SEQ THRESH 0
PGFIX ATTRIBUTE NO
PAGE STEAL METHOD LRU
AUTOSIZE NO
FRAMESIZE N/A
VPOOL SIZE MIN N/A
VPOOL SIZE MAX N/A
SIM POOL SIZE N/A
SIM POOL SEQ THRESH N/A
LOCATION: OMPDA5 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 1-14
GROUP: N/P SYSTEM PARAMETERS REPORT
MEMBER: N/P
SUBSYSTEM: DA5 ACTUAL FROM: 08/24/16 07:01:00.00
DB2 VERSION: V10
BUFFER POOL PARAMETERS
--------------------------------------------------------------------------------------------------------------
TIMESTAMP 08/24/16 07:01:00.00 VPOOL SIZE (PAGES) 2200
BUFFER POOL ID BP8K8 VPOOL SEQ THRESH 80
HORIZ DEFER WRITE THRESH 30
VERT DEFER WRITE THRESH (%) 5
VERT DEFER WRITE THRESH (BUF) 0
VPOOL PARALLEL SEQ THRESH 50
ASSISTING PARALLEL SEQ THRESH 0
PGFIX ATTRIBUTE NO
PAGE STEAL METHOD LRU
AUTOSIZE NO
FRAMESIZE N/A
VPOOL SIZE MIN N/A
VPOOL SIZE MAX N/A
SIM POOL SIZE N/A
SIM POOL SEQ THRESH N/A
TIMESTAMP 08/24/16 07:01:00.00 VPOOL SIZE (PAGES) 2000
BUFFER POOL ID BP16K0 VPOOL SEQ THRESH 80
HORIZ DEFER WRITE THRESH 30
VERT DEFER WRITE THRESH (%) 5
VERT DEFER WRITE THRESH (BUF) 0
VPOOL PARALLEL SEQ THRESH 50
ASSISTING PARALLEL SEQ THRESH 0
PGFIX ATTRIBUTE NO
PAGE STEAL METHOD LRU
AUTOSIZE NO
FRAMESIZE N/A
VPOOL SIZE MIN N/A
VPOOL SIZE MAX N/A
SIM POOL SIZE N/A
SIM POOL SEQ THRESH N/A
TIMESTAMP 08/24/16 07:01:00.00 VPOOL SIZE (PAGES) 2000
BUFFER POOL ID BP16K1 VPOOL SEQ THRESH 80
HORIZ DEFER WRITE THRESH 30
VERT DEFER WRITE THRESH (%) 5
VERT DEFER WRITE THRESH (BUF) 0
VPOOL PARALLEL SEQ THRESH 50
ASSISTING PARALLEL SEQ THRESH 0
PGFIX ATTRIBUTE NO
PAGE STEAL METHOD LRU
AUTOSIZE NO
FRAMESIZE N/A
VPOOL SIZE MIN N/A
VPOOL SIZE MAX N/A
SIM POOL SIZE N/A
SIM POOL SEQ THRESH N/A
...
LOCATION: OMPDBEE OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 5-1
GROUP: DBEE SYSTEM PARAMETERS REPORT
MEMBER: SEE2
SUBSYSTEM: SEE2 ACTUAL FROM: 08/24/16 07:01:00.00
B2 VERSION: V11
MVS PARMLIB UPDATE PARAMETERS (DSNTIPM) IRLM INSTALLATION PARAMETERS (DSNTIPI)
--------------------------------------- --------------------------------------
SUBSYSTEM DEFAULT (SSID)...................................SEE2 IRLM SUBSYSTEM NAME (IRLMSID)..............................IEE2
SUPPRESS SOFT ERRORS (SUPERRS)..............................YES IRLM RESOURCE TIMEOUT IN SECONDS (IRLMRWT)...................60
IRLM AUTOMATIC START (IRLMAUT)..............................YES
STORAGE SIZES INSTALLATION PARMS (DSNTIPC,DSNTIPE,DSNTIPE1) IRLM START PROCEDURE NAME (IRLMPRC)....................SEE2IRLM
--------------------------------------------------------------- SECONDS DB2 WILL WAIT FOR IRLM START (IRLMSWT)..............120
MAX NO OF DATA SETS CONCURRENTLY IN USE (DSMAX)..........20,000 U LOCK FOR REPEATABLE READ OR READ STABILITY (RRULOCK)......YES
EDM STATEMENT CACHE SIZE IN KB (EDMSTMTC)...............113,386 X LOCK FOR SEARCHED UPDATE/DELETE (XLKUPDLT).................NO
EDM DBD CACHE SIZE IN KB (EDMDBDC)......................102,400 IMS/BMP TIMEOUT FACTOR (BMPTOUT)..............................4
EDM SKELETON POOL SIZE IN KB (EDM_SKELETON_POOL)........102,400 IMS/DLI TIMEOUT FACTOR (DLITOUT)..............................6
MAXIMUM SIZE OF EDM POOL IN BYTES (EDMPOOL)...................0 WAIT FOR RETAINED LOCKS (RETLWAIT)............................0
MAXIMUM SIZE OF SORT POOL IN BYTES (SRTPOOL).........10,240,000 ENABLE DB CHECKING...........................................NO
MAX IN-MEMORY SORT SIZE (MAXSORT_IN_MEMORY)...............1,000 IRLM INITIALIZATION TIME......................................1
MAXIMUM SIZE OF RID POOL IN KB (MAXRBLK)................400,000
MAX NO OF USERS CONCURRENTLY RUNNING IN DB2 (CTHREAD).......400 IRLM PROCESSING PARAMETERS
MAX NO OF CONCURRENT REMOTE ACTIVE CONNECTIONS (MAXDBAT)....200 --------------------------
MAX NO OF REMOTE CONNECTIONS (CONDBAT)...................10,000 WAIT TIME FOR LOCAL DEADLOCK..............................5,000
MAX NO OF TSO CONNECTIONS (IDFORE)..........................200 NUMBER OF LOCAL CYCLES PER GLOBAL CYCLE.......................1
MAX NO OF BATCH CONNECTIONS (IDBACK)........................200 TIMEOUT INTERVAL.............................................60
MAXIMUM KEPT DYNAMIC STATEMENTS (MAXKEEPD)................5,000 IRLM MAXIMUM CSA USAGE ALLOWED................................0
MAX OPEN FILE REFS (MAXOFILR)...............................100 Z/OS LOCK TABLE HASH ENTRIES..........................1,048,576
MANAGE REAL STORAGE (REALSTORAGE_MANAGEMENT)...............AUTO PENDING NUMBER OF HASH ENTRIES................................0
MAXIMUM REAL STORAGE (REALSTORAGE_MAX)........................0 Z/OS LOCK TABLE LIST ENTRIES..............................9,565
CONTRACT THREAD STORAGE (CONTSTOR)..........................YES MAX 31-BIT IRLM PRIVATE STORAGE...............................0
MANAGE THREAD STORAGE (MINSTOR)..............................NO MAX 64-BIT IRLM PRIVATE STORAGE...............................0
LONG-RUNNING READER IN MINUTES (LRDRTHLD)....................10
DDL TIMEOUT FACTOR (DDLTOX)...................................1 ARCHIVE LOG INSTALLATION PARAMETERS (DSNTIPA)
INDEX CLEANUP THREADS (INDEX_CLEANUP_THREADS)................10 ---------------------------------------------
CATALOG ARCHIVE DATASETS (CATALOG)..........................YES
TRACING, CHECKPOINT < PSEUDO-CLOSE PARAMETERS (DSNTIPN) COPY1 ARCHIVE LOG DEVICE TYPE (UNIT).......................DASD
------------------------------------------------------- COPY2 ARCHIVE LOG DEVICE TYPE (UNIT2)...................'BLANK'
START AUDIT TRACE (AUDITST)..................................NO SPACE ALLOCATION METHOD (ALCUNIT)......................CYLINDER
START GLOBAL TRACE (TRACSTR).................................NO PRIMARY SPACE ALLOCATION (PRIQTY)...........................100
TRACE TABLE SIZE IN 4K BYTES (TRACTBL).......................16 SECONDARY SPACE ALLOCATION (SECQTY)..........................10
LOCAL TRACE TABLE SIZE IN 4K BYTES (TRACLOC).................16 ARCHIVE LOG BLOCK SIZE IN BYTES (BLKSIZE)................24,576
START SMF ACCOUNTING (SMFACCT)................................1 MAXIMUM READ TAPE UNITS (MAXRTU)..............................2
START SMF STATISTICS (SMFSTAT)........................1,3,4,5,6 TAPE UNIT DEALLOCATION PERIOD (DEALLCT).................0000:00
STATISTICS TIME INTERVAL IN MINUTES (STATIME).................1 MAX NUMBER OF DATASETS RECORDED IN BSDS (MAXARCH)........10,000
SYNCHRONIZATION INTERVAL WITHIN THE HOUR (SYNCVAL)...........NO FIRST ARCHIVE COPY MASS STG GROUP NAME...................'NONE'
ONLINE DATASET STATISTICS TIME INTERVAL IN MIN.(DSSTIME)......5 SECOND ARCHIVE COPY MASS STG GROUP NAME..................'NONE'
START MONITOR TRACE (MON).....................................1 DAYS TO RETAIN ARCHIVE LOG DATA SETS (ARCRETN)...............30
MONITOR BUFFER SIZE IN BYTES (MONSIZE)................1,048,576 ISSUE WTOR BEFORE MOUNT FOR ARCHIVE VOLUME (ARCWTOR)........YES
UNICODE IFCIDS (UIFCIDS)....................................YES COMPACT DATA (COMPACT).......................................NO
DDF/RRSAF ACCUM (ACCUMACC)...................................10 QUIESCE PERIOD (QUIESCE)......................................5
AGGREGATION FIELDS (ACCUMUID).................................0 SINGLE VOLUME (SVOLARC)......................................NO
COMPRESS SMF RECS (SMFCOMP).................................OFF
LOCATION: OMPDBEE OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 5-2
GROUP: DBEE SYSTEM PARAMETERS REPORT
MEMBER: SEE2
SUBSYSTEM: SEE2 ACTUAL FROM: 08/24/16 07:01:00.00
B2 VERSION: V11
DISTRIBUTED DATA FACILITY PANEL 2 (DSNTIP5) DEFINE GROUP OR MEMBER (DSNTIPK)
------------------------------------------- --------------------------------
TCP/IP ALREADY VERIFIED (TCPALVER)...........................NO GROUP NAME (GRPNAME).......................................DBEE
EXTRA BLOCKS REQ (EXTRAREQ).................................100 MEMBER NAME (MEMBNAME).....................................SEE2
EXTRA BLOCKS SRV (EXTRASRV).................................100 MAX NUMBER OF MEMBERS.......................................248
TCP/IP KEEPALIVE (TCPKPALV).................................120 RANDOM ATTACH (RANDOMATT)...................................YES
CONNECTION QUEUE MAX DEPTH (MAXCONQN).........................0 DEL CF STRUCTS (DEL_CFSTRUCTS_ON_RESTART)....................NO
CONNECTION QUEUE MAX WAIT (MAXCONQW)..........................0
POOL THREAD TIMEOUT (POOLINAC)..............................120 DISTRIBUTED DATA FACILITY PANEL 1 (DSNTIPR)
-------------------------------------------
PROTECTION INSTALLATION PARAMETERS (DSNTIPP) FACILITY NAME...............................................DDF
-------------------------------------------- DDF STARTUP OPTION (DDF)...................................AUTO
ARCHIVE LOG RACF PROTECTION (PROTECT)........................NO RLST ACCESS ERROR (RLFERRD).............................NOLIMIT
DB2 AUTHORIZATION ENABLED (AUTH)............................YES RESYNCHRONIZATION INTERVAL IN MINUTES (RESYNC)................2
PLAN AUTHORIZATION CACHE SIZE (AUTHCACH)..................3,072 DBAT STATUS (CMTSTAT)..................................INACTIVE
PACKAGE AUTHORIZATION CACHE SIZE (CACHEPAC)...........5,242,880 MAX TYPE 1 INACTIVE THREADS (MAXTYPE1)........................0
ROUTINE AUTHORIZATION CACHE SIZE (CACHERAC)...........5,242,880 IDLE THREAD TIMEOUT INTERVAL (IDTHTOIN).....................120
AUTH EXIT CHECK (AUTHEXIT_CHECK)........................PRIMARY EXTENDED SECURITY (EXTSEC)..................................YES
AUTH EXIT CACHE REFRESH (AUTHEXIT_CACHEREFRESH)............NONE USER ID AND PASSWORD REQUIRED................................NO
SYSTEM ADMINISTRATOR 1 AUTHORIZATION ID (SYSADM)...........LOGO SQL INTERRUPT PROCESSING DISABLED (SQLINTRP).................NO
SYSTEM ADMINISTRATOR 2 AUTHORIZATION ID (SYSADM2)........SYSADM PRIVATE PROTOCOL (PRIVATE_PROTOCOL)..........................NO
SYSTEM OPERATOR 1 AUTHORIZATION ID (SYSOPR1)...............LOGO
SYSTEM OPERATOR 2 AUTHORIZATION ID (SYSOPR2)...............EMIL LOCK ESCALATION PARAMETERS (DSNTIPJ)
DEFAULT (UNKNOWN) USER AUTHORIZATION ID (DEFLTID).......IBMUSER ------------------------------------
RESOURCE LIMIT TABLE CREATOR AUTH ID (RLFAUTH)...........SYSIBM MAX PAGE OR ROW LOCKS PER TABLE SPACE (NUMLKTS)...........2,000
BIND NEW PACKAGE (BINDNV)...............................BINDADD MAX PAGE OR ROW LOCKS PER USER (NUMLKUS).................10,000
DBA CREATE VIEW (DBACRVW)....................................NO
LOG INSTALLATION PARAMETERS (DSNTIPL,DSNTIPH)
DATA DEFINITION CONTROL SUPPORT (DSNTIPZ) ---------------------------------------------
----------------------------------------- OUTPUT BUFFER SIZE IN K BYTES (OUTBUFF)...................4,000
INSTALL DD CONTROL (RGFINSTL)................................NO CHECKPOINT TYPE (CHKTYPE)................................SINGLE
CONTROL ALL APPLICATIONS (RGFDEDPL)..........................NO RECORDS/CHECKPOINT (CHKLOGR)................................N/P
REQUIRE FULL NAMES (RGFFULLQ)...............................YES MINUTES/CHECKPOINT (CHKMINS)................................N/P
UNREGISTERED DDL DEFAULT (RGFDEFLT)......................ACCEPT CHECKPOINT FREQUENCY (CHKFREQ)..........................500,000
REGISTER TABLE OWNER (RGFCOLID)........................DSNRGCOL UR CHECK FREQUENCY (URCHKTH)..................................0
DDL REGISTRATION DATABASE NAME (RGFDBNAM)..............DSNRGFDB UR LOG RECORD WRITTEN THRESHOLD IN KB (URLGWTH)...............0
APPL REGISTRATION TABLE NAME (RGFNMPRT).......DSN_REGISTER_APPL LIMIT BACKOUT (LBACKOUT)...................................AUTO
OBJECT REGISTRATION TABLE NAME (RGFNMORT).....DSN_REGISTER_OBJT BACKOUT DURATION (BACKODUR)...................................5
ESCAPE CHARACTER (RGFESCP)................................X'40' PSEUDO-CLOSE FREQUENCY (PCLOSEN).............................10
PSEUDO-CLOSE TIMER (PCLOSET).................................10
DB2 VERSION INSTALL (DSNTIPA1) CHECKPOINTS BETWEEN LEVEL ID UPDATES (DLDFREQ)................5
------------------------------ NUMBER OF ACTIVE LOG COPIES (TWOACTV).........................1
DATA SHARING ENABLED (DSHARE)...............................YES NUMBER OF ARCHIVE LOG COPIES (TWOARCH)........................1
CURRENT DB2 RELEASE (NEWFUN)................................YES COPY 1 PREFIX (ARCPFX1)......................DBEE.SEE2.ARCHLOG1
CURRENT DB2 RELEASE - 1......................................NO COPY 2 PREFIX (ARCPFX2)......................DBEE.SEE2.ARCHLOG2
CURRENT DB2 RELEASE - 2......................................NO TIMESTAMP ARCHIVE LOG DATA SETS (TSTAMP)....................YES
COMPRESS LOB TS FOR DIRECTORY (COMPRESS_DIRLOB).............N/A
LOCATION: OMPDBEE OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 5-3
GROUP: DBEE SYSTEM PARAMETERS REPORT
MEMBER: SEE2
SUBSYSTEM: SEE2 ACTUAL FROM: 08/24/16 07:01:00.00
B2 VERSION: V11
APPLICATION PROGRAMMING DEFAULTS PANEL 1 (DSNTIPF) APPLICATION PROGRAMMING DEFAULTS PANEL 2 (DSNTIP4,DSNTIP41)
-------------------------------------------------- ---------------------------------------------------------------
DEFAULT HOST LANGUAGE (DEFLANG)..........................IBMCOB MINIMUM DIVIDE SCALE (DECDIV3)...............................NO
DECIMAL POINT OPTION (DECIMAL)...........................PERIOD DECIMAL ARITHMETIC (DECARTH)..............................DEC15
DEFAULT DELIMITER (DELIM)...............................DEFAULT USE FOR DYNAMIC RULES (DYNRULS).............................YES
DEFAULT SQL DELIMITER (SQLDELI).........................DEFAULT STATIC DESCRIBE (DESCSTAT)..................................YES
DIST SQL STRING DELIMITER (DSQLDELI)......................APOST DATE FORMAT (DATE)..........................................ISO
DEFAULT MIXED GRAPHIC (MIXED)................................NO TIME FORMAT (TIME)..........................................ISO
EBCDIC SBCS CCSID (SCCSID)................................1,148 LOCAL DATE LENGTH (DATELEN).................................N/A
EBCDIC MBCS CCSID (MCCSID)..................................N/P LOCAL TIME LENGTH (TIMELEN).................................N/A
EBCDIC GBCS CCSID (GCCSID)..................................N/P IMPLICIT TIMEZONE.......................................CURRENT
ASCII SBCS CCSID (ASCCSID)..................................819 STD SQL LANGUAGE (STDSQL)....................................NO
ASCII MBCS CCSID (AMCCSID)..................................N/P PAD NULL-TERMINATED (PADNTSTR)...............................NO
ASCII GBCS CCSID (AGCCSID)..................................N/P APPL COMPAT LEVEL (APPLCOMPAT)............................V11R1
UNICODE SBCS CCSID (USCCSID)................................367 LIKE BLANK INSIGNIFICANT (LIKE_BLANK_INSIGNIFICANT)..........NO
UNICODE MBCS CCSID (UMCCSID)..............................1,208 FULLY QUALIFIED NAME OF DSNHDECP LOAD MODULE...................
UNICODE GBCS CCSID (UGCCSID)..............................1,200 SYS1.DSN.SEE2.SDSNEXIT(DSNHDECP)
DEFAULT ENCODING SCHEME (ENSCHEME).......................EBCDIC
APPLICATION ENCODING (APPENSCH)..........................EBCDIC OPERATOR FUNCTIONS INSTALLATION PARAMETERS (DSNTIPO)
LOCALE LC_TYPE (LC_CTYPE)...............................'BLANK' ----------------------------------------------------
DECFLOAT ROUND MODE (DEF_DECFLOAT_ROUND_MODE)...ROUND_HALF_EVEN WTO ROUTE CODES (ROUTCDE).....................................1
RESOURCE LIMIT FACILITY AUTOMATIC START (RLF)................NO
SQL OBJECT DEFAULTS PANEL (DSNTIP7,DSNTIP71,DSNTIP72) RESOURCE LIMIT SPECIFICATION TABLE SUFFIX (RLFTBL)...........01
----------------------------------------------------- RESOURCE LIMIT SPEC TABLE ERROR ACTION (RLFERR).........NOLIMIT
REORDERED ROW FORMAT (RRF)..................................YES AUTO BIND (ABIND)...........................................YES
OBJECT CREATE FORMAT (OBJECT_CREATE_FORMAT)............EXTENDED ALLOW EXPLAIN AT AUTOBIND (ABEXP)...........................YES
UTILITY OBJECT CONVERSION (UTILITY_OBJECT_CONVERSION)......NONE DPROP SUPPORT (EDPROP).......................................NO
VARY DS CONTROL INTERVAL (DSVCI)............................YES SITE TYPE (SITETYP)...................................LOCALSITE
TABLE SPACE ALLOCATION IN KB (TSQTY)..........................0 TRACKER SITE (TRKRSITE)......................................NO
INDEX SPACE ALLOCATION IN KB (IXQTY)..........................0 READ COPY2 ARCHIVE (ARC2FRST)................................NO
OPTIMIZE EXTENT SIZING (MGEXTSZ).............................NO REAL TIME STATS (STATSINT)...................................30
PAD INDEX BY DEFAULT (PADIX).................................NO STATISTICS FEEDBACK (STATFDBK_SCOPE)........................ALL
DEFAULT PARTITION SEGSIZE (DPSEGSZ)..........................32 PROFILE AUTOSTART (PROFILE_AUTOSTART).......................N/A
PERCENT FREE FOR UPDATE (PCTFREE_UPD).........................0
DEFINE DATA SETS (IMPDSDEF).................................YES ROUTINE PARAMETERS (DSNTIPX)
USE DATA COMPRESSION (IMPTSCMP)..............................NO ----------------------------
LIMIT KEY CONV PART TAB (IX_TB_PART_CONV_EXCLUDE)...........YES MAX ABEND COUNT (STORMXAB)....................................0
PAGE SET PAGE NUMBERING (PAGESET_PAGENUM)...................N/A TIMEOUT VALUE (STORTIME)....................................180
RETRY STOPPED OBJECTS (RETRY_STOPPED_OBJECTS)................NO WLM ENVIRONMENT (WLMENV)......................DSNWLMV11_GENERAL
RENAME TABLE (RENAMETABLE)...................................NO MAX OPEN CURSORS (MAX_NUM_CUR)..............................500
PREVENT ALTER LIMITKEY (PREVENT_ALTERTB_LIMITKEY)............NO MAX STORED PROCS (MAX_ST_PROC)............................2,000
PREVENT INDEX PART CREATE (PREVENT_NEW_IXCTRL_PART)..........NO MAXIMUM NUMBER OF LE TOKENS (LEMAX)..........................20
DDL MATERIALIZATION (DDL_MATERIALIZATION)...................N/A BIF COMPATIBILITY (BIF_COMPATIBILITY)...................CURRENT
DEFAULT INSERT ALGORITHM (DEFAULT_INSERT_ALGORITHM).........N/A
BUFFER POOL PARAMETERS (DSNTIP1)
PERFORMANCE AND OPTIMIZATION (DSNTIP8,DSNTIP81) --------------------------------
----------------------------------------------- DEFAULT 4-KB BUFFER POOL FOR USER DATA (TBSBPOOL)..........BP2
CACHE DYNAMIC SQL (CACHEDYN)................................YES DEFAULT 8-KB BUFFER POOL FOR USER DATA (TBSBP8K).........BP8K0
CACHE DYN STABILITY (CACHEDYN_STABILIZATION)................N/P DEFAULT 16-KB BUFFER POOL FOR USER DATA (TBSBP16K).......BP16K0
OPTIMIZATION HINTS ALLOWED (OPTHINTS)........................NO DEFAULT 32-KB BUFFER POOL FOR USER DATA (TBSBP32K)........BP32K
EVALUATE UNCOMMITTED (EVALUNC)...............................NO DEFAULT BUFFER POOL FOR USER LOB DATA (TBSBPLOB)............BP9
SKIP UNCOMM INSERTS (SKIPUNCI)...............................NO DEFAULT BUFFER POOL FOR USER XML DATA (TBSBPXML).........BP16K0
LOCATION: OMPDBEE OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 5-4
GROUP: DBEE SYSTEM PARAMETERS REPORT
MEMBER: SEE2
SUBSYSTEM: SEE2 ACTUAL FROM: 08/24/16 07:01:00.00
B2 VERSION: V11
IMMEDWRITE OVERRIDE FLAG (IMMEDWRI)..........................NO DEFAULT BUFFER POOL FOR USER INDEXES (IDXBPOOL).............BP1
REBIND PLANMGMT DEFAULT (PLANMGMT).....................EXTENDED
PLANMGMTSCOPE DEFAULT (PLANMGMTSCOPE)....................STATIC QUERY ACCELERATOR PREFERENCES (DSNTIP82)
PACKAGE RELEASE COMMIT (PKGREL_COMMIT)......................YES ----------------------------------------
RANDOMIZE XML DOCID (XML_RANDOMIZE_DOCID)....................NO ACCELERATOR STARTUP OPTION (ACCEL).........................AUTO
DISABLE EDM RTS (DISABLE_EDMRTS).............................NO GET ACCEL ARCHIVE (GET_ACCEL_ARCHIVE)........................NO
CURRENT DEGREE (CDSSRDEF).....................................1 ACCELERATION OPTIONS (QUERY_ACCEL_OPTIONS)..............(1,2,3)
MAX DEGREE OF PARALLELISM (PARAMDEG)..........................0 CURRENT QUERY ACCEL (QUERY_ACCELERATION)...................NONE
MAX DEGREE FOR DPSI (PARAMDEG_DPSI)...........................0 ACCELERATION MODELING (ACCELMODEL)...........................NO
PARALLELISM EFFICIENCY (PARA_EFF)............................50 REMOTE COPY SW ACCEL (REMOTE_COPY_SW_ACCEL)..................NO
STAR JOIN ENABLING (STARJOIN) ..........................DISABLE
MAX DATA CACHING IN MB (MXDTCACH)............................20 WORKFILE DATABASE PANEL (DSNTIP91)
CURRENT REFRESH AGE (REFSHAGE)................................0 ----------------------------------
CURRENT MAINT TYPE (MAINTYPE)............................SYSTEM MAX TEMP STORAGE PER AGENT IN MB (MAXTEMPS)...................0
STATS PROFILE FEEDBACK (STATFDBK_PROFILE)...................N/A SEPARATE WORK FILES (WFDBSEP)................................NO
MAX TEMP RID (MAXTEMPS_RID).............................NOLIMIT
AGENT LEVEL THRESHOLD (WFSTGUSE_AGENT_THRESHOLD)..............0
SYSTEM LEVEL THRESHOLD (WFSTGUSE_SYSTEM_THRESHOLD)...........90
LOCATION: OMPDBEE OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 5-5
GROUP: DBEE SYSTEM PARAMETERS REPORT
MEMBER: SEE2
SUBSYSTEM: SEE2 ACTUAL FROM: 08/24/16 07:01:00.00
B2 VERSION: V11
OTHER SYSTEM PARAMETERS DB2 UTILITIES PARAMETERS (DSNTIP6,DSNTIP61,DSNTIP62)
----------------------- ----------------------------------------------------
DUAL BSDS MODE (TWOBSDS)....................................YES TEMPORARY UNIT NAME (VOLTDEVT)............................SYSDA
ROLL UP PARALLEL TASK ACCOUNTING (PTASKROL).................YES UTIL TEMP STORCLAS (UTIL_TEMP_STORCLAS).....................N/P
NO. PAGES SMALL TABLE THRESHOLD (NPGTHRSH)....................0 STATISTICS HISTORY (STATHIST)..............................NONE
OFFLOAD OPTION (OFFLOAD)....................................YES STATISTICS ROLLUP (STATROLL)................................YES
SU CONVERSION FACTOR........................................247 UTILITY TIMEOUT FACTOR (UTIMOUT)..............................6
MINIMUM DIVIDE SCALE (MINDVSCL)............................NONE UT SORT DATA SET ALLOCATION (UTSORTAL)......................YES
STAR JOIN THRESHOLD (SJTABLES)...............................10 IGNORE SORTNUM STMT (IGNSORTN)...............................NO
ONLINE SYSTEM PARM USER ID MONITOR..........................N/P SET CHECK PENDING (CHECK_SETCHKP)............................NO
ONLINE SYSTEM PARM CORREL ID MONITOR........................N/P UT DB2 SORT USE (DB2SORT)...................................YES
ONLINE SYSTEM PARM TIME CHANGED.............................N/P TEMPLATE TIME (TEMPLATE_TIME)...............................UTC
ONLINE SYSTEM PARM TYPE.....................................N/P MAXIMUM DEGREE OF UTILITY PARALLELISM (PARAMDEG_UTIL)........99
DB2-SUPPLIED DECP INDICATOR...............................X'D5' FAST REPLICATION (CHECK_FASTREPLICATION)...............REQUIRED
MAX CONCURRENT PKG OPS (MAX_CONCURRENT_PKG_OPS)..............10 FAST RESTORE (REC_FASTREPLICATION)....................PREFERRED
ADMIN SCHEDULER JCL PROC NAME (ADMTPROC)....................N/P COPY FAST REPLICATION (COPY_FASTREPLICATION)................N/A
FREE LOCAL CACHED STATEMENTS (CACHEDYN_FREELOCAL).............1 FLASHCOPY PPRC (FLASHCOPY_PPRC)........................REQUIRED
INDEX I/O PARALLELISM (INDEX_IO_PARALLELISM)................YES DEFAULT TEMPLATE (FCCOPYDDN)...................................
ZOSMETRICS..................................................YES DBEE.<DB..<SN..N<DSNUM..<UQ.
USE TRACKMOD FOR IMPLICIT TS (IMPTKMOD).....................YES FLASHCOPY COPY (FLASHCOPY_COPY)..............................NO
DSSIZE FOR IMPLICIT TS (IMPDSSIZE)............................4 FLASHCOPY LOAD (FLASHCOPY_LOAD)..............................NO
ENABLE MULTIPLE INDEX ACCESS (SUBQ_MIDX)....................YES FLASHCOPY REORG TABLESPACE (FLASHCOPY_REORG_TS)..............NO
SP_PARMS_JV (DDF_COMPATIBILITY)..............................NO FLASHCOPY REBUILD INDEX (FLASHCOPY_REBUILD_INDEX)............NO
SP_PARMS_NJV (DDF_COMPATIBILITY).............................NO FLASHCOPY REORG INDEX (FLASHCOPY_REORG_INDEX)................NO
DISABLE_IMPCAST_JV (DDF_COMPATIBILITY).......................NO SYSTEM-LEVEL BACKUPS (SYSTEM_LEVEL_BACKUPS)..................NO
DISABLE_IMPCAST_NJV (DDF_COMPATIBILITY)......................NO RESTORE/RECOVER (RESTORE_RECOVER_FROMDUMP)...................NO
IGNORE_TZ (DDF_COMPATIBILITY)...............................N/A DUMP CLASS NAME (UTILS_DUMP_CLASS_NAME).................'BLANK'
DDF COMP PRIOR VERSION (DDF_COMPATIBILITY)..................N/P MAXIMUM TAPE UNITS (RESTORE_TAPEUNITS)........................0
DYN STMT CACHE STOR (CACHE_DEP_TRACK_STOR_LIM)................2 REORG PART SORT NPSI (REORG_PART_SORT_NPSI)................AUTO
ACTIVATE I/O SCHEDULING.....................................YES REORG LIST PROCESSING (REORG_LIST_PROCESSING)..........PARALLEL
VALUE FOR TRIGGER DRAIN.......................................1 REORG MAPPING DATABASE (REORG_MAPPING_DATABASE).............N/P
MAX NUMBER OF DDS WITH HOLD...................................3 REORG DROP PBG PARTS (REORG_DROP_PBG_PARTS)..................NO
FIELD PROCS FOR DESCRIBE TABLE BLOCK..........................5 REORG IGNORE FREESPACE (REORG_IGNORE_FREESPACE)..............NO
RESTRICT ALTER COLUMN FOR DCC (RESTRICT_ALT_COL_FOR_DCC).....NO ALTERNATE COPYPOOL (ALTERNATE_CP)...........................N/A
SPACE RESERVED FOR Z/OS FUNCTIONS........................40,960 DB BACKUP STG GROUP (UTIL_DBBSG)............................N/A
SPACE RESERVED FOR CRITICAL WORK.....................39,387,136 LOG BACKUP STG GROUP (UTIL_LGBSG)...........................N/A
SPACE RESERVED ON TOP OF Z/OS AND CRITICAL SPACE.....39,387,136 HSM MESSAGE DS HLQ (UTILS_HSM_MSGDS_HLQ)....................N/A
DETAILED MEASURED UNIT PRICE TRACKING........................NO
OTC LICENSE TERMS ACCEPTED...................................NO DATABASES AND SPACES STARTED AUTOMATICALLY (DSNTIPS)
SIMULATED CPUS................................................0 ----------------------------------------------------
EXECUTION TIME OF TASK/SRB IN MICROSECONDS....................0 ALL
MAX 'NOT FOUND' HASH RECORDS................................100
MAX EXTEND SERVICE TASKS.....................................20 ICF CATALOG QUALIFIERS
PROJECT Z INSERTION THRESHOLD.................................2 ----------------------
MAX ZIVLEMPEL DICTIONARY ENTRIES..........................4,096 DBEE
REORG KEEPDICTIONARY IN BRF TO RRF CONVERSION................NO
DRDA RESOLVE ALIAS (DRDA_RESOLVE_ALIAS).....................YES SIZES PANEL 1 (DSNTIPD)
PC YES SPECIFIED............................................YES -----------------------
BLOCK OPT 1 ROW SORT (OPT1ROWBLOCKSORT)......................NO LOB INLINE LENGTH (LOB_INLINE_LENGTH).........................0
EMPTY XML ELEMENT (XML_RESTRICT_EMPTY_TAG)...................NO USER LOB VALUE STORAGE IN KB (LOBVALA)...................10,240
SUPPRESS_HINT_SQLCODE_DYN (SUPPRESS_HINT_SQLCODE_DYN) .......NO SYSTEM LOB VALUE STORAGE IN MB (LOBVALS)..................4,096
INDEX MEMORY CONTROL (INDEX_MEMORY_CONTROL).................N/A USER XML VALUE STG IN KB (XMLVALA)......................204,800
LOCATION: OMPDBEE OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 5-6
GROUP: DBEE SYSTEM PARAMETERS REPORT
MEMBER: SEE2
SUBSYSTEM: SEE2 ACTUAL FROM: 08/24/16 07:01:00.00
B2 VERSION: V11
SELECT FOR UNLOAD (AUTH_COMPATIBILITY)......................N/A SYSTEM XML VAL STG IN MB (XMLVALS).......................10,240
MATERIALIZE NODET SQLTUDF (MATERIALIZE_NODET_SQLTUDF).......N/A
PROTECTION PANEL (DSNTIPP1)
DEFAULT STARTUP MODULES (DSNTIPO3) ---------------------------
---------------------------------- SECURITY ADMINISTRATOR 1 AUTHORIZATION ID (SECADM1)......SECADM
PARAMETER MODULE.......................................DSNZPARM SECURITY ADMINISTRATOR 1 TYPE (SECADM1_TYPE).............AUTHID
ACCESS CONTROL (ACCESS_CNTL_MODULE)....................DSNX§XAC SECURITY ADMINISTRATOR 2 AUTHORIZATION ID (SECADM2)......SECADM
IDENTIFY/AUTH (IDAUTH_MODULE)..........................DSN3§ATH SECURITY ADMINISTRATOR 2 TYPE (SECADM2_TYPE).............AUTHID
SIGNON (SIGNON_MODULE).................................DSN3§SGN SEPARATE SECURITY DUTIES (SEPARATE_SECURITY).................NO
INCLUDE DEPENDENT PRIVILEGES (REVOKE_DEP_PRIVILEGES)....SQLSTMT
LOCATION: OMPDBEE OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 5-7
GROUP: DBEE SYSTEM PARAMETERS REPORT
MEMBER: SEE2
SUBSYSTEM: SEE2 ACTUAL FROM: 08/24/16 07:01:00.00
B2 VERSION: V11
DB2 CATALOG AND DIRECTORY PANEL (DSNTIPA2)
------------------------------------------
SMS DATA CLASS FOR CATALOG DATA (CATDDACL)................XVSAM
SMS MANAGEMENT CLASS FOR CATALOG DATA (CATDMGCL)............DB2
SMS STORAGE CLASS FOR CATALOG DATA (CATDSTCL)...............DB2
SMS DATA CLASS FOR CATALOG INDEX DATA (CATXDACL)..........XVSAM
SMS MANAGEMENT CLASS FOR CATALOG INDEX DATA (CATXMGCL)......DB2
SMS STORAGE CLASS FOR CATALOG INDEX DATA (CATXSTCL).........DB2
COMPRESS SPT01 (COMPRESS_SPT01)..............................NO
SPT01 INLINE LENGTH (SPT01_INLINE_LENGTH)................32,138
LOCATION: OMPDBEE OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 5-8
GROUP: DBEE SYSTEM PARAMETERS REPORT
MEMBER: SEE2
SUBSYSTEM: SEE2 ACTUAL FROM: 08/24/16 07:01:00.00
B2 VERSION: V11
BUFFER POOL PARAMETERS
--------------------------------------------------------------------------------------------------------------
TIMESTAMP 08/24/16 07:01:00.00 VPOOL SIZE (PAGES) 5000
BUFFER POOL ID BP0 VPOOL SEQ THRESH 80
HORIZ DEFER WRITE THRESH 30
VERT DEFER WRITE THRESH (%) 5
VERT DEFER WRITE THRESH (BUF) 0
VPOOL PARALLEL SEQ THRESH 50
ASSISTING PARALLEL SEQ THRESH 0
PGFIX ATTRIBUTE NO
PAGE STEAL METHOD LRU
AUTOSIZE NO
FRAMESIZE 4K
VPOOL SIZE MIN 0
VPOOL SIZE MAX 0
SIM POOL SIZE 0
SIM POOL SEQ THRESH 0
TIMESTAMP 08/24/16 07:01:00.00 VPOOL SIZE (PAGES) 10000
BUFFER POOL ID BP1 VPOOL SEQ THRESH 80
HORIZ DEFER WRITE THRESH 30
VERT DEFER WRITE THRESH (%) 5
VERT DEFER WRITE THRESH (BUF) 0
VPOOL PARALLEL SEQ THRESH 50
ASSISTING PARALLEL SEQ THRESH 0
PGFIX ATTRIBUTE NO
PAGE STEAL METHOD LRU
AUTOSIZE NO
FRAMESIZE 4K
VPOOL SIZE MIN 0
VPOOL SIZE MAX 0
SIM POOL SIZE 0
SIM POOL SEQ THRESH 0
TIMESTAMP 08/24/16 07:01:00.00 VPOOL SIZE (PAGES) 20000
BUFFER POOL ID BP2 VPOOL SEQ THRESH 80
HORIZ DEFER WRITE THRESH 30
VERT DEFER WRITE THRESH (%) 5
VERT DEFER WRITE THRESH (BUF) 0
VPOOL PARALLEL SEQ THRESH 50
ASSISTING PARALLEL SEQ THRESH 0
PGFIX ATTRIBUTE NO
PAGE STEAL METHOD LRU
AUTOSIZE NO
FRAMESIZE 4K
VPOOL SIZE MIN 0
VPOOL SIZE MAX 0
SIM POOL SIZE 0
SIM POOL SEQ THRESH 0
LOCATION: OMPDBEE OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 5-9
GROUP: DBEE SYSTEM PARAMETERS REPORT
MEMBER: SEE2
SUBSYSTEM: SEE2 ACTUAL FROM: 08/24/16 07:01:00.00
B2 VERSION: V11
BUFFER POOL PARAMETERS
--------------------------------------------------------------------------------------------------------------
TIMESTAMP 08/24/16 07:01:00.00 VPOOL SIZE (PAGES) 2000
BUFFER POOL ID BP3 VPOOL SEQ THRESH 80
HORIZ DEFER WRITE THRESH 30
VERT DEFER WRITE THRESH (%) 5
VERT DEFER WRITE THRESH (BUF) 0
VPOOL PARALLEL SEQ THRESH 50
ASSISTING PARALLEL SEQ THRESH 0
PGFIX ATTRIBUTE NO
PAGE STEAL METHOD LRU
AUTOSIZE NO
FRAMESIZE 4K
VPOOL SIZE MIN 0
VPOOL SIZE MAX 0
SIM POOL SIZE 0
SIM POOL SEQ THRESH 0
TIMESTAMP 08/24/16 07:01:00.00 VPOOL SIZE (PAGES) 2000
BUFFER POOL ID BP4 VPOOL SEQ THRESH 80
HORIZ DEFER WRITE THRESH 30
VERT DEFER WRITE THRESH (%) 5
VERT DEFER WRITE THRESH (BUF) 0
VPOOL PARALLEL SEQ THRESH 50
ASSISTING PARALLEL SEQ THRESH 0
PGFIX ATTRIBUTE NO
PAGE STEAL METHOD LRU
AUTOSIZE NO
FRAMESIZE 4K
VPOOL SIZE MIN 0
VPOOL SIZE MAX 0
SIM POOL SIZE 0
SIM POOL SEQ THRESH 0
TIMESTAMP 08/24/16 07:01:00.00 VPOOL SIZE (PAGES) 10000
BUFFER POOL ID BP7 VPOOL SEQ THRESH 80
HORIZ DEFER WRITE THRESH 30
VERT DEFER WRITE THRESH (%) 5
VERT DEFER WRITE THRESH (BUF) 0
VPOOL PARALLEL SEQ THRESH 50
ASSISTING PARALLEL SEQ THRESH 0
PGFIX ATTRIBUTE NO
PAGE STEAL METHOD LRU
AUTOSIZE NO
FRAMESIZE 4K
VPOOL SIZE MIN 0
VPOOL SIZE MAX 0
SIM POOL SIZE 0
SIM POOL SEQ THRESH 0
LOCATION: OMPDBEE OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 5-10
GROUP: DBEE SYSTEM PARAMETERS REPORT
MEMBER: SEE2
SUBSYSTEM: SEE2 ACTUAL FROM: 08/24/16 07:01:00.00
B2 VERSION: V11
BUFFER POOL PARAMETERS
--------------------------------------------------------------------------------------------------------------
TIMESTAMP 08/24/16 07:01:00.00 VPOOL SIZE (PAGES) 2000
BUFFER POOL ID BP9 VPOOL SEQ THRESH 80
HORIZ DEFER WRITE THRESH 30
VERT DEFER WRITE THRESH (%) 5
VERT DEFER WRITE THRESH (BUF) 0
VPOOL PARALLEL SEQ THRESH 50
ASSISTING PARALLEL SEQ THRESH 0
PGFIX ATTRIBUTE NO
PAGE STEAL METHOD LRU
AUTOSIZE NO
FRAMESIZE 4K
VPOOL SIZE MIN 0
VPOOL SIZE MAX 0
SIM POOL SIZE 0
SIM POOL SEQ THRESH 0
TIMESTAMP 08/24/16 07:01:00.00 VPOOL SIZE (PAGES) 2000
BUFFER POOL ID BP10 VPOOL SEQ THRESH 80
HORIZ DEFER WRITE THRESH 30
VERT DEFER WRITE THRESH (%) 5
VERT DEFER WRITE THRESH (BUF) 0
VPOOL PARALLEL SEQ THRESH 50
ASSISTING PARALLEL SEQ THRESH 0
PGFIX ATTRIBUTE NO
PAGE STEAL METHOD LRU
AUTOSIZE NO
FRAMESIZE 4K
VPOOL SIZE MIN 2000
VPOOL SIZE MAX 2000
SIM POOL SIZE 0
SIM POOL SEQ THRESH 0
TIMESTAMP 08/24/16 07:01:00.00 VPOOL SIZE (PAGES) 2000
BUFFER POOL ID BP11 VPOOL SEQ THRESH 80
HORIZ DEFER WRITE THRESH 30
VERT DEFER WRITE THRESH (%) 5
VERT DEFER WRITE THRESH (BUF) 0
VPOOL PARALLEL SEQ THRESH 50
ASSISTING PARALLEL SEQ THRESH 0
PGFIX ATTRIBUTE NO
PAGE STEAL METHOD LRU
AUTOSIZE NO
FRAMESIZE 4K
VPOOL SIZE MIN 2000
VPOOL SIZE MAX 2000
SIM POOL SIZE 0
SIM POOL SEQ THRESH 0
LOCATION: OMPDBEE OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 5-11
GROUP: DBEE SYSTEM PARAMETERS REPORT
MEMBER: SEE2
SUBSYSTEM: SEE2 ACTUAL FROM: 08/24/16 07:01:00.00
B2 VERSION: V11
BUFFER POOL PARAMETERS
--------------------------------------------------------------------------------------------------------------
TIMESTAMP 08/24/16 07:01:00.00 VPOOL SIZE (PAGES) 2200
BUFFER POOL ID BP17 VPOOL SEQ THRESH 80
HORIZ DEFER WRITE THRESH 30
VERT DEFER WRITE THRESH (%) 5
VERT DEFER WRITE THRESH (BUF) 0
VPOOL PARALLEL SEQ THRESH 50
ASSISTING PARALLEL SEQ THRESH 0
PGFIX ATTRIBUTE NO
PAGE STEAL METHOD LRU
AUTOSIZE NO
FRAMESIZE 4K
VPOOL SIZE MIN 0
VPOOL SIZE MAX 0
SIM POOL SIZE 0
SIM POOL SEQ THRESH 0
TIMESTAMP 08/24/16 07:01:00.00 VPOOL SIZE (PAGES) 1000
BUFFER POOL ID BP32K VPOOL SEQ THRESH 80
HORIZ DEFER WRITE THRESH 30
VERT DEFER WRITE THRESH (%) 5
VERT DEFER WRITE THRESH (BUF) 0
VPOOL PARALLEL SEQ THRESH 50
ASSISTING PARALLEL SEQ THRESH 0
PGFIX ATTRIBUTE NO
PAGE STEAL METHOD LRU
AUTOSIZE NO
FRAMESIZE 4K
VPOOL SIZE MIN 0
VPOOL SIZE MAX 0
SIM POOL SIZE 0
SIM POOL SEQ THRESH 0
TIMESTAMP 08/24/16 07:01:00.00 VPOOL SIZE (PAGES) 5000
BUFFER POOL ID BP32K1 VPOOL SEQ THRESH 80
HORIZ DEFER WRITE THRESH 30
VERT DEFER WRITE THRESH (%) 5
VERT DEFER WRITE THRESH (BUF) 0
VPOOL PARALLEL SEQ THRESH 50
ASSISTING PARALLEL SEQ THRESH 0
PGFIX ATTRIBUTE NO
PAGE STEAL METHOD LRU
AUTOSIZE NO
FRAMESIZE 4K
VPOOL SIZE MIN 0
VPOOL SIZE MAX 0
SIM POOL SIZE 0
SIM POOL SEQ THRESH 0
LOCATION: OMPDBEE OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 5-12
GROUP: DBEE SYSTEM PARAMETERS REPORT
MEMBER: SEE2
SUBSYSTEM: SEE2 ACTUAL FROM: 08/24/16 07:01:00.00
B2 VERSION: V11
BUFFER POOL PARAMETERS
--------------------------------------------------------------------------------------------------------------
TIMESTAMP 08/24/16 07:01:00.00 VPOOL SIZE (PAGES) 2000
BUFFER POOL ID BP8K0 VPOOL SEQ THRESH 80
HORIZ DEFER WRITE THRESH 30
VERT DEFER WRITE THRESH (%) 5
VERT DEFER WRITE THRESH (BUF) 0
VPOOL PARALLEL SEQ THRESH 50
ASSISTING PARALLEL SEQ THRESH 0
PGFIX ATTRIBUTE NO
PAGE STEAL METHOD LRU
AUTOSIZE NO
FRAMESIZE 4K
VPOOL SIZE MIN 0
VPOOL SIZE MAX 0
SIM POOL SIZE 0
SIM POOL SEQ THRESH 0
TIMESTAMP 08/24/16 07:01:00.00 VPOOL SIZE (PAGES) 2000
BUFFER POOL ID BP8K1 VPOOL SEQ THRESH 80
HORIZ DEFER WRITE THRESH 30
VERT DEFER WRITE THRESH (%) 5
VERT DEFER WRITE THRESH (BUF) 0
VPOOL PARALLEL SEQ THRESH 50
ASSISTING PARALLEL SEQ THRESH 0
PGFIX ATTRIBUTE NO
PAGE STEAL METHOD LRU
AUTOSIZE NO
FRAMESIZE 4K
VPOOL SIZE MIN 0
VPOOL SIZE MAX 0
SIM POOL SIZE 0
SIM POOL SEQ THRESH 0
TIMESTAMP 08/24/16 07:01:00.00 VPOOL SIZE (PAGES) 2200
BUFFER POOL ID BP8K8 VPOOL SEQ THRESH 80
HORIZ DEFER WRITE THRESH 30
VERT DEFER WRITE THRESH (%) 5
VERT DEFER WRITE THRESH (BUF) 0
VPOOL PARALLEL SEQ THRESH 50
ASSISTING PARALLEL SEQ THRESH 0
PGFIX ATTRIBUTE NO
PAGE STEAL METHOD LRU
AUTOSIZE NO
FRAMESIZE 4K
VPOOL SIZE MIN 0
VPOOL SIZE MAX 0
SIM POOL SIZE 0
SIM POOL SEQ THRESH 0
LOCATION: OMPDBEE OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 5-13
GROUP: DBEE SYSTEM PARAMETERS REPORT
MEMBER: SEE2
SUBSYSTEM: SEE2 ACTUAL FROM: 08/24/16 07:01:00.00
B2 VERSION: V11
BUFFER POOL PARAMETERS
--------------------------------------------------------------------------------------------------------------
TIMESTAMP 08/24/16 07:01:00.00 VPOOL SIZE (PAGES) 2000
BUFFER POOL ID BP16K0 VPOOL SEQ THRESH 80
HORIZ DEFER WRITE THRESH 30
VERT DEFER WRITE THRESH (%) 5
VERT DEFER WRITE THRESH (BUF) 0
VPOOL PARALLEL SEQ THRESH 50
ASSISTING PARALLEL SEQ THRESH 0
PGFIX ATTRIBUTE NO
PAGE STEAL METHOD LRU
AUTOSIZE NO
FRAMESIZE 4K
VPOOL SIZE MIN 0
VPOOL SIZE MAX 0
SIM POOL SIZE 0
SIM POOL SEQ THRESH 0
TIMESTAMP 08/24/16 07:01:00.00 VPOOL SIZE (PAGES) 2000
BUFFER POOL ID BP16K1 VPOOL SEQ THRESH 80
HORIZ DEFER WRITE THRESH 30
VERT DEFER WRITE THRESH (%) 5
VERT DEFER WRITE THRESH (BUF) 0
VPOOL PARALLEL SEQ THRESH 50
ASSISTING PARALLEL SEQ THRESH 0
PGFIX ATTRIBUTE NO
PAGE STEAL METHOD LRU
AUTOSIZE NO
FRAMESIZE 4K
VPOOL SIZE MIN 0
VPOOL SIZE MAX 0
SIM POOL SIZE 0
SIM POOL SEQ THRESH 0
...
LOCATION: OMPDBZ2 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 8-1
GROUP: DBZ2 SYSTEM PARAMETERS REPORT
ACTUAL FROM: 08/24/16 07:01:00.00
B2 VERSION: V10
GROUP BUFFER POOL PARAMETERS
-------------------------------------------------------------------------------------------------
TIMESTAMP 08/24/16 07:01:00.01 CURRENT DIRECTORY TO DATA RATIO 7
MEMBER SZ22 CLASS CASTOUT THRESHOLD (%) 5
GBP ID GBP0 CLASS CASTOUT THRESHOLD (PAGES) 0
ALLOCATED GBP SIZE (4K) 2048 GBP CASTOUT THRESHOLD (%) 30
ACTUAL DIRECTORY 5007 GBP CHECKPOINT INTERVAL (MIN) 4
ACTUAL DATA ENTRY 714 GBP CACHE SETTING YES
PENDING DIRECTORY TO DATA RATIO 7 AUTO REC NO
MODE SIMPLEX
TIMESTAMP 08/24/16 07:01:00.01 CURRENT DIRECTORY TO DATA RATIO 5
MEMBER SZ22 CLASS CASTOUT THRESHOLD (%) 5
GBP ID GBP32K CLASS CASTOUT THRESHOLD (PAGES) 0
ALLOCATED GBP SIZE (4K) 2304 GBP CASTOUT THRESHOLD (%) 30
ACTUAL DIRECTORY 523 GBP CHECKPOINT INTERVAL (MIN) 4
ACTUAL DATA ENTRY 104 GBP CACHE SETTING YES
PENDING DIRECTORY TO DATA RATIO 5 AUTO REC YES
MODE SIMPLEX
TIMESTAMP 08/24/16 07:01:00.01 CURRENT DIRECTORY TO DATA RATIO 5
MEMBER SZ22 CLASS CASTOUT THRESHOLD (%) 5
GBP ID GBP8K0 CLASS CASTOUT THRESHOLD (PAGES) 0
ALLOCATED GBP SIZE (4K) 1280 GBP CASTOUT THRESHOLD (%) 30
ACTUAL DIRECTORY 1101 GBP CHECKPOINT INTERVAL (MIN) 5
ACTUAL DATA ENTRY 219 GBP CACHE SETTING YES
PENDING DIRECTORY TO DATA RATIO 5 AUTO REC YES
MODE SIMPLEX
..
LOCATION: OMPDC51 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 10-1
GROUP: N/P SYSTEM PARAMETERS REPORT
MEMBER: N/P
SUBSYSTEM: DC51 ACTUAL FROM: 08/24/16 07:01:00.00
B2 VERSION: V12
MVS PARMLIB UPDATE PARAMETERS (DSNTIPM) IRLM INSTALLATION PARAMETERS (DSNTIPI)
--------------------------------------- --------------------------------------
SUBSYSTEM DEFAULT (SSID)...................................DC51 IRLM SUBSYSTEM NAME (IRLMSID)..............................IC51
SUPPRESS SOFT ERRORS (SUPERRS)..............................YES IRLM RESOURCE TIMEOUT IN SECONDS (IRLMRWT)...................60
IRLM AUTOMATIC START (IRLMAUT)..............................YES
STORAGE SIZES INSTALLATION PARMS (DSNTIPC,DSNTIPE,DSNTIPE1) IRLM START PROCEDURE NAME (IRLMPRC)....................DC51IRLM
--------------------------------------------------------------- SECONDS DB2 WILL WAIT FOR IRLM START (IRLMSWT)..............120
MAX NO OF DATA SETS CONCURRENTLY IN USE (DSMAX)..........20,000 U LOCK FOR REPEATABLE READ OR READ STABILITY (RRULOCK)......YES
EDM STATEMENT CACHE SIZE IN KB (EDMSTMTC)...............113,386 X LOCK FOR SEARCHED UPDATE/DELETE (XLKUPDLT).................NO
EDM DBD CACHE SIZE IN KB (EDMDBDC).......................23,400 IMS/BMP TIMEOUT FACTOR (BMPTOUT)..............................4
EDM SKELETON POOL SIZE IN KB (EDM_SKELETON_POOL).........81,920 IMS/DLI TIMEOUT FACTOR (DLITOUT)..............................6
MAXIMUM SIZE OF EDM POOL IN BYTES (EDMPOOL).................N/A WAIT FOR RETAINED LOCKS (RETLWAIT)............................0
MAXIMUM SIZE OF SORT POOL IN BYTES (SRTPOOL).........10,240,000 ENABLE DB CHECKING...........................................NO
MAX IN-MEMORY SORT SIZE (MAXSORT_IN_MEMORY)...............1,000 IRLM INITIALIZATION TIME......................................1
MAXIMUM SIZE OF RID POOL IN KB (MAXRBLK)................400,000
MAX NO OF USERS CONCURRENTLY RUNNING IN DB2 (CTHREAD).......400 IRLM PROCESSING PARAMETERS
MAX NO OF CONCURRENT REMOTE ACTIVE CONNECTIONS (MAXDBAT)....200 --------------------------
MAX NO OF REMOTE CONNECTIONS (CONDBAT)...................10,000 WAIT TIME FOR LOCAL DEADLOCK..............................5,000
MAX NO OF TSO CONNECTIONS (IDFORE)..........................200 NUMBER OF LOCAL CYCLES PER GLOBAL CYCLE.......................1
MAX NO OF BATCH CONNECTIONS (IDBACK)........................200 TIMEOUT INTERVAL.............................................60
MAXIMUM KEPT DYNAMIC STATEMENTS (MAXKEEPD)................5,000 IRLM MAXIMUM CSA USAGE ALLOWED................................0
MAX OPEN FILE REFS (MAXOFILR)...............................100 Z/OS LOCK TABLE HASH ENTRIES..................................0
MANAGE REAL STORAGE (REALSTORAGE_MANAGEMENT)...............AUTO PENDING NUMBER OF HASH ENTRIES................................0
MAXIMUM REAL STORAGE (REALSTORAGE_MAX)........................0 Z/OS LOCK TABLE LIST ENTRIES..................................0
CONTRACT THREAD STORAGE (CONTSTOR)..........................N/A MAX 31-BIT IRLM PRIVATE STORAGE...............................0
MANAGE THREAD STORAGE (MINSTOR).............................N/A MAX 64-BIT IRLM PRIVATE STORAGE...............................0
LONG-RUNNING READER IN MINUTES (LRDRTHLD)....................10
DDL TIMEOUT FACTOR (DDLTOX)...................................1 ARCHIVE LOG INSTALLATION PARAMETERS (DSNTIPA)
INDEX CLEANUP THREADS (INDEX_CLEANUP_THREADS)................10 ---------------------------------------------
CATALOG ARCHIVE DATASETS (CATALOG)...........................NO
TRACING, CHECKPOINT < PSEUDO-CLOSE PARAMETERS (DSNTIPN) COPY1 ARCHIVE LOG DEVICE TYPE (UNIT).......................DASD
------------------------------------------------------- COPY2 ARCHIVE LOG DEVICE TYPE (UNIT2)...................'BLANK'
START AUDIT TRACE (AUDITST)..................................NO SPACE ALLOCATION METHOD (ALCUNIT)......................CYLINDER
START GLOBAL TRACE (TRACSTR).................................NO PRIMARY SPACE ALLOCATION (PRIQTY)...........................125
TRACE TABLE SIZE IN 4K BYTES (TRACTBL).......................16 SECONDARY SPACE ALLOCATION (SECQTY)..........................15
LOCAL TRACE TABLE SIZE IN 4K BYTES (TRACLOC).................16 ARCHIVE LOG BLOCK SIZE IN BYTES (BLKSIZE)................24,576
START SMF ACCOUNTING (SMFACCT)................................1 MAXIMUM READ TAPE UNITS (MAXRTU)..............................2
START SMF STATISTICS (SMFSTAT)........................1,3,4,5,6 TAPE UNIT DEALLOCATION PERIOD (DEALLCT).................0000:00
STATISTICS TIME INTERVAL IN MINUTES (STATIME).................1 MAX NUMBER OF DATASETS RECORDED IN BSDS (MAXARCH)........10,000
SYNCHRONIZATION INTERVAL WITHIN THE HOUR (SYNCVAL)...........NO FIRST ARCHIVE COPY MASS STG GROUP NAME...................'NONE'
ONLINE DATASET STATISTICS TIME INTERVAL IN MIN.(DSSTIME)......5 SECOND ARCHIVE COPY MASS STG GROUP NAME..................'NONE'
START MONITOR TRACE (MON).....................................1 DAYS TO RETAIN ARCHIVE LOG DATA SETS (ARCRETN)............9,999
MONITOR BUFFER SIZE IN BYTES (MONSIZE)................1,048,576 ISSUE WTOR BEFORE MOUNT FOR ARCHIVE VOLUME (ARCWTOR)........YES
UNICODE IFCIDS (UIFCIDS)....................................YES COMPACT DATA (COMPACT).......................................NO
DDF/RRSAF ACCUM (ACCUMACC)...................................10 QUIESCE PERIOD (QUIESCE)......................................5
AGGREGATION FIELDS (ACCUMUID).................................0 SINGLE VOLUME (SVOLARC)......................................NO
COMPRESS SMF RECS (SMFCOMP).................................OFF
LOCATION: OMPDC51 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 10-2
GROUP: N/P SYSTEM PARAMETERS REPORT
MEMBER: N/P
SUBSYSTEM: DC51 ACTUAL FROM: 08/24/16 07:01:00.00
B2 VERSION: V12
DISTRIBUTED DATA FACILITY PANEL 2 (DSNTIP5) DEFINE GROUP OR MEMBER (DSNTIPK)
------------------------------------------- --------------------------------
TCP/IP ALREADY VERIFIED (TCPALVER)...........................NO GROUP NAME (GRPNAME)........................................N/P
EXTRA BLOCKS REQ (EXTRAREQ).................................100 MEMBER NAME (MEMBNAME).....................................DC51
EXTRA BLOCKS SRV (EXTRASRV).................................100 MAX NUMBER OF MEMBERS.......................................248
TCP/IP KEEPALIVE (TCPKPALV).................................120 RANDOM ATTACH (RANDOMATT)...................................YES
CONNECTION QUEUE MAX DEPTH (MAXCONQN).........................0 DEL CF STRUCTS (DEL_CFSTRUCTS_ON_RESTART)....................NO
CONNECTION QUEUE MAX WAIT (MAXCONQW)..........................0
POOL THREAD TIMEOUT (POOLINAC)..............................120 DISTRIBUTED DATA FACILITY PANEL 1 (DSNTIPR)
-------------------------------------------
PROTECTION INSTALLATION PARAMETERS (DSNTIPP) FACILITY NAME...............................................DDF
-------------------------------------------- DDF STARTUP OPTION (DDF)...................................AUTO
ARCHIVE LOG RACF PROTECTION (PROTECT)........................NO RESYNCHRONIZATION INTERVAL IN MINUTES (RESYNC)................2
DB2 AUTHORIZATION ENABLED (AUTH)............................YES DBAT STATUS (CMTSTAT)..................................INACTIVE
PLAN AUTHORIZATION CACHE SIZE (AUTHCACH)..................3,072 MAX TYPE 1 INACTIVE THREADS (MAXTYPE1)........................0
PACKAGE AUTHORIZATION CACHE SIZE (CACHEPAC)...........5,242,880 IDLE THREAD TIMEOUT INTERVAL (IDTHTOIN).....................120
ROUTINE AUTHORIZATION CACHE SIZE (CACHERAC)...........5,242,880 EXTENDED SECURITY (EXTSEC)..................................YES
AUTH EXIT CHECK (AUTHEXIT_CHECK)........................PRIMARY USER ID AND PASSWORD REQUIRED................................NO
AUTH EXIT CACHE REFRESH (AUTHEXIT_CACHEREFRESH)............NONE SQL INTERRUPT PROCESSING DISABLED (SQLINTRP).................NO
SYSTEM ADMINISTRATOR 1 AUTHORIZATION ID (SYSADM)...........LOGO PRIVATE PROTOCOL (PRIVATE_PROTOCOL)..........................NO
SYSTEM ADMINISTRATOR 2 AUTHORIZATION ID (SYSADM2)........SYSADM
SYSTEM OPERATOR 1 AUTHORIZATION ID (SYSOPR1)...............LOGO LOCK ESCALATION PARAMETERS (DSNTIPJ)
SYSTEM OPERATOR 2 AUTHORIZATION ID (SYSOPR2)...............KIVO ------------------------------------
DEFAULT (UNKNOWN) USER AUTHORIZATION ID (DEFLTID).......IBMUSER MAX PAGE OR ROW LOCKS PER TABLE SPACE (NUMLKTS)...........2,000
RESOURCE LIMIT TABLE CREATOR AUTH ID (RLFAUTH)...........SYSIBM MAX PAGE OR ROW LOCKS PER USER (NUMLKUS).................10,000
BIND NEW PACKAGE (BINDNV)...............................BINDADD
DBA CREATE VIEW (DBACRVW)....................................NO LOG INSTALLATION PARAMETERS (DSNTIPL,DSNTIPH)
---------------------------------------------
DATA DEFINITION CONTROL SUPPORT (DSNTIPZ) OUTPUT BUFFER SIZE IN K BYTES (OUTBUFF)...................4,000
----------------------------------------- CHECKPOINT TYPE (CHKTYPE)................................SINGLE
INSTALL DD CONTROL (RGFINSTL)................................NO RECORDS/CHECKPOINT (CHKLOGR)................................N/P
CONTROL ALL APPLICATIONS (RGFDEDPL)..........................NO MINUTES/CHECKPOINT (CHKMINS)................................N/P
REQUIRE FULL NAMES (RGFFULLQ)...............................YES CHECKPOINT FREQUENCY (CHKFREQ)..........................500,000
UNREGISTERED DDL DEFAULT (RGFDEFLT)......................ACCEPT UR CHECK FREQUENCY (URCHKTH)..................................0
REGISTER TABLE OWNER (RGFCOLID)........................DSNRGCOL UR LOG RECORD WRITTEN THRESHOLD IN KB (URLGWTH)...............0
DDL REGISTRATION DATABASE NAME (RGFDBNAM)..............DSNRGFDB LIMIT BACKOUT (LBACKOUT)...................................AUTO
APPL REGISTRATION TABLE NAME (RGFNMPRT).......DSN_REGISTER_APPL BACKOUT DURATION (BACKODUR)...................................5
OBJECT REGISTRATION TABLE NAME (RGFNMORT).....DSN_REGISTER_OBJT PSEUDO-CLOSE FREQUENCY (PCLOSEN).............................10
ESCAPE CHARACTER (RGFESCP)................................X'40' PSEUDO-CLOSE TIMER (PCLOSET).................................10
CHECKPOINTS BETWEEN LEVEL ID UPDATES (DLDFREQ)................5
DB2 VERSION INSTALL (DSNTIPA1) NUMBER OF ACTIVE LOG COPIES (TWOACTV).........................1
------------------------------ NUMBER OF ARCHIVE LOG COPIES (TWOARCH)........................1
DATA SHARING ENABLED (DSHARE)................................NO COPY 1 PREFIX (ARCPFX1).........................DSNC51.ARCHLOG1
CURRENT DB2 RELEASE (NEWFUN)................................N/A COPY 2 PREFIX (ARCPFX2).........................DSNC51.ARCHLOG2
CURRENT DB2 RELEASE - 1.....................................N/A TIMESTAMP ARCHIVE LOG DATA SETS (TSTAMP)....................YES
CURRENT DB2 RELEASE - 2.....................................N/A
COMPRESS LOB TS FOR DIRECTORY (COMPRESS_DIRLOB)..............NO
LOCATION: OMPDC51 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 10-3
GROUP: N/P SYSTEM PARAMETERS REPORT
MEMBER: N/P
SUBSYSTEM: DC51 ACTUAL FROM: 08/24/16 07:01:00.00
B2 VERSION: V12
APPLICATION PROGRAMMING DEFAULTS PANEL 1 (DSNTIPF) APPLICATION PROGRAMMING DEFAULTS PANEL 2 (DSNTIP4,DSNTIP41)
-------------------------------------------------- ---------------------------------------------------------------
DEFAULT HOST LANGUAGE (DEFLANG)..........................IBMCOB MINIMUM DIVIDE SCALE (DECDIV3)...............................NO
DECIMAL POINT OPTION (DECIMAL)...........................PERIOD DECIMAL ARITHMETIC (DECARTH)..............................DEC15
DEFAULT DELIMITER (DELIM)...............................DEFAULT USE FOR DYNAMIC RULES (DYNRULS).............................YES
DEFAULT SQL DELIMITER (SQLDELI).........................DEFAULT STATIC DESCRIBE (DESCSTAT)..................................YES
DIST SQL STRING DELIMITER (DSQLDELI)......................APOST DATE FORMAT (DATE)..........................................ISO
DEFAULT MIXED GRAPHIC (MIXED)................................NO TIME FORMAT (TIME)..........................................ISO
EBCDIC SBCS CCSID (SCCSID)................................1,148 LOCAL DATE LENGTH (DATELEN).................................N/A
EBCDIC MBCS CCSID (MCCSID)..................................N/P LOCAL TIME LENGTH (TIMELEN).................................N/A
EBCDIC GBCS CCSID (GCCSID)..................................N/P IMPLICIT TIMEZONE.......................................CURRENT
ASCII SBCS CCSID (ASCCSID)..................................819 STD SQL LANGUAGE (STDSQL)....................................NO
ASCII MBCS CCSID (AMCCSID)..................................N/P PAD NULL-TERMINATED (PADNTSTR)...............................NO
ASCII GBCS CCSID (AGCCSID)..................................N/P APPL COMPAT LEVEL (APPLCOMPAT)........................V12R1M500
UNICODE SBCS CCSID (USCCSID)................................367 LIKE BLANK INSIGNIFICANT (LIKE_BLANK_INSIGNIFICANT)..........NO
UNICODE MBCS CCSID (UMCCSID)..............................1,208 FULLY QUALIFIED NAME OF DSNHDECP LOAD MODULE...................
UNICODE GBCS CCSID (UGCCSID)..............................1,200 SYS1.DSN.DC51.SDSNEXIT(DSNHDECP)
DEFAULT ENCODING SCHEME (ENSCHEME).......................EBCDIC
APPLICATION ENCODING (APPENSCH)..........................EBCDIC OPERATOR FUNCTIONS INSTALLATION PARAMETERS (DSNTIPO)
LOCALE LC_TYPE (LC_CTYPE)...............................'BLANK' ----------------------------------------------------
DECFLOAT ROUND MODE (DEF_DECFLOAT_ROUND_MODE)...ROUND_HALF_EVEN WTO ROUTE CODES (ROUTCDE).....................................1
AUTO BIND (ABIND)...........................................YES
SQL OBJECT DEFAULTS PANEL (DSNTIP7,DSNTIP71,DSNTIP72) ALLOW EXPLAIN AT AUTOBIND (ABEXP)...........................YES
----------------------------------------------------- DPROP SUPPORT (EDPROP).......................................NO
REORDERED ROW FORMAT (RRF)..................................N/A SITE TYPE (SITETYP)...................................LOCALSITE
OBJECT CREATE FORMAT (OBJECT_CREATE_FORMAT)............EXTENDED TRACKER SITE (TRKRSITE)......................................NO
UTILITY OBJECT CONVERSION (UTILITY_OBJECT_CONVERSION)......NONE READ COPY2 ARCHIVE (ARC2FRST)................................NO
VARY DS CONTROL INTERVAL (DSVCI)............................YES REAL TIME STATS (STATSINT)...................................30
TABLE SPACE ALLOCATION IN KB (TSQTY)..........................0 STATISTICS FEEDBACK (STATFDBK_SCOPE)........................ALL
INDEX SPACE ALLOCATION IN KB (IXQTY)..........................0 PROFILE AUTOSTART (PROFILE_AUTOSTART)........................NO
OPTIMIZE EXTENT SIZING (MGEXTSZ).............................NO
PAD INDEX BY DEFAULT (PADIX).................................NO ROUTINE PARAMETERS (DSNTIPX)
DEFAULT PARTITION SEGSIZE (DPSEGSZ)..........................32 ----------------------------
PERCENT FREE FOR UPDATE (PCTFREE_UPD).........................0 MAX ABEND COUNT (STORMXAB)....................................0
DEFINE DATA SETS (IMPDSDEF).................................YES TIMEOUT VALUE (STORTIME)....................................180
USE DATA COMPRESSION (IMPTSCMP)..............................NO WLM ENVIRONMENT (WLMENV)......................DSNWLMV12_GENERAL
LIMIT KEY CONV PART TAB (IX_TB_PART_CONV_EXCLUDE)...........YES MAX OPEN CURSORS (MAX_NUM_CUR)..............................500
PAGE SET PAGE NUMBERING (PAGESET_PAGENUM).....................A MAX STORED PROCS (MAX_ST_PROC)............................2,000
RETRY STOPPED OBJECTS (RETRY_STOPPED_OBJECTS)................NO MAXIMUM NUMBER OF LE TOKENS (LEMAX).........................N/A
RENAME TABLE (RENAMETABLE)...................................NO BIF COMPATIBILITY (BIF_COMPATIBILITY)...................CURRENT
PREVENT ALTER LIMITKEY (PREVENT_ALTERTB_LIMITKEY)............NO
PREVENT INDEX PART CREATE (PREVENT_NEW_IXCTRL_PART).........YES BUFFER POOL PARAMETERS (DSNTIP1)
DDL MATERIALIZATION (DDL_MATERIALIZATION)......ALWAYS_IMMEDIATE --------------------------------
DEFAULT INSERT ALGORITHM (DEFAULT_INSERT_ALGORITHM)...........2 DEFAULT 4-KB BUFFER POOL FOR USER DATA (TBSBPOOL)..........BP2
DEFAULT 8-KB BUFFER POOL FOR USER DATA (TBSBP8K).........BP8K0
PERFORMANCE AND OPTIMIZATION (DSNTIP8,DSNTIP81) DEFAULT 16-KB BUFFER POOL FOR USER DATA (TBSBP16K).......BP16K0
----------------------------------------------- DEFAULT 32-KB BUFFER POOL FOR USER DATA (TBSBP32K)........BP32K
CACHE DYNAMIC SQL (CACHEDYN)................................YES DEFAULT BUFFER POOL FOR USER LOB DATA (TBSBPLOB)............BP9
CACHE DYN STABILITY (CACHEDYN_STABILIZATION)...............BOTH DEFAULT BUFFER POOL FOR USER XML DATA (TBSBPXML).........BP16K0
OPTIMIZATION HINTS ALLOWED (OPTHINTS)........................NO DEFAULT BUFFER POOL FOR USER INDEXES (IDXBPOOL).............BP1
EVALUATE UNCOMMITTED (EVALUNC)...............................NO
SKIP UNCOMM INSERTS (SKIPUNCI)...............................NO QUERY ACCELERATOR PREFERENCES (DSNTIP82)
LOCATION: OMPDC51 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 10-4
GROUP: N/P SYSTEM PARAMETERS REPORT
MEMBER: N/P
SUBSYSTEM: DC51 ACTUAL FROM: 08/24/16 07:01:00.00
B2 VERSION: V12
IMMEDWRITE OVERRIDE FLAG (IMMEDWRI)..........................NO ----------------------------------------
REBIND PLANMGMT DEFAULT (PLANMGMT).....................EXTENDED ACCELERATOR STARTUP OPTION (ACCEL).........................AUTO
PLANMGMTSCOPE DEFAULT (PLANMGMTSCOPE)....................STATIC GET ACCEL ARCHIVE (GET_ACCEL_ARCHIVE)........................NO
PACKAGE RELEASE COMMIT (PKGREL_COMMIT)......................YES ACCELERATION OPTIONS (QUERY_ACCEL_OPTIONS)..............(1,2,3)
RANDOMIZE XML DOCID (XML_RANDOMIZE_DOCID)....................NO CURRENT QUERY ACCEL (QUERY_ACCELERATION)...................NONE
DISABLE EDM RTS (DISABLE_EDMRTS).............................NO ACCELERATION MODELING (ACCELMODEL)...........................NO
CURRENT DEGREE (CDSSRDEF).....................................1 REMOTE COPY SW ACCEL (REMOTE_COPY_SW_ACCEL)..................NO
MAX DEGREE OF PARALLELISM (PARAMDEG)..........................0
MAX DEGREE FOR DPSI (PARAMDEG_DPSI)...........................0 WORKFILE DATABASE PANEL (DSNTIP91)
PARALLELISM EFFICIENCY (PARA_EFF)............................50 ----------------------------------
STAR JOIN ENABLING (STARJOIN) ..........................DISABLE MAX TEMP STORAGE PER AGENT IN MB (MAXTEMPS)...................0
MAX DATA CACHING IN MB (MXDTCACH)............................20 SEPARATE WORK FILES (WFDBSEP)................................NO
CURRENT REFRESH AGE (REFSHAGE)................................0 MAX TEMP RID (MAXTEMPS_RID).............................NOLIMIT
CURRENT MAINT TYPE (MAINTYPE)............................SYSTEM AGENT LEVEL THRESHOLD (WFSTGUSE_AGENT_THRESHOLD)..............0
STATS PROFILE FEEDBACK (STATFDBK_PROFILE)...................YES SYSTEM LEVEL THRESHOLD (WFSTGUSE_SYSTEM_THRESHOLD)...........90
LOCATION: OMPDC51 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 10-5
GROUP: N/P SYSTEM PARAMETERS REPORT
MEMBER: N/P
SUBSYSTEM: DC51 ACTUAL FROM: 08/24/16 07:01:00.00
B2 VERSION: V12
OTHER SYSTEM PARAMETERS DB2 UTILITIES PARAMETERS (DSNTIP6,DSNTIP61,DSNTIP62)
----------------------- ----------------------------------------------------
DUAL BSDS MODE (TWOBSDS)....................................YES TEMPORARY UNIT NAME (VOLTDEVT)............................SYSDA
ROLL UP PARALLEL TASK ACCOUNTING (PTASKROL).................YES UTIL TEMP STORCLAS (UTIL_TEMP_STORCLAS).....................N/P
NO. PAGES SMALL TABLE THRESHOLD (NPGTHRSH)....................0 STATISTICS HISTORY (STATHIST)..............................NONE
OFFLOAD OPTION (OFFLOAD)....................................YES STATISTICS ROLLUP (STATROLL)................................YES
SU CONVERSION FACTOR........................................247 UTILITY TIMEOUT FACTOR (UTIMOUT)..............................6
MINIMUM DIVIDE SCALE (MINDVSCL)............................NONE UT SORT DATA SET ALLOCATION (UTSORTAL)......................N/A
STAR JOIN THRESHOLD (SJTABLES)...............................10 IGNORE SORTNUM STMT (IGNSORTN)...............................NO
ONLINE SYSTEM PARM USER ID MONITOR..........................N/P SET CHECK PENDING (CHECK_SETCHKP)...........................N/A
ONLINE SYSTEM PARM CORREL ID MONITOR........................N/P UT DB2 SORT USE (DB2SORT)...................................N/A
ONLINE SYSTEM PARM TIME CHANGED.............................N/P TEMPLATE TIME (TEMPLATE_TIME)...............................UTC
ONLINE SYSTEM PARM TYPE.....................................N/P MAXIMUM DEGREE OF UTILITY PARALLELISM (PARAMDEG_UTIL)........99
DB2-SUPPLIED DECP INDICATOR...............................X'D5' FAST REPLICATION (CHECK_FASTREPLICATION)...............REQUIRED
MAX CONCURRENT PKG OPS (MAX_CONCURRENT_PKG_OPS)..............10 FAST RESTORE (REC_FASTREPLICATION)....................PREFERRED
ADMIN SCHEDULER JCL PROC NAME (ADMTPROC)....................N/P COPY FAST REPLICATION (COPY_FASTREPLICATION)..........PREFERRED
FREE LOCAL CACHED STATEMENTS (CACHEDYN_FREELOCAL)...........N/A FLASHCOPY PPRC (FLASHCOPY_PPRC)........................REQUIRED
INDEX I/O PARALLELISM (INDEX_IO_PARALLELISM)................N/A DEFAULT TEMPLATE (FCCOPYDDN)...................................
ZOSMETRICS..................................................YES DSNC51.<DB..<SN..N<DSNUM..<UQ.
USE TRACKMOD FOR IMPLICIT TS (IMPTKMOD).....................YES FLASHCOPY COPY (FLASHCOPY_COPY)..............................NO
DSSIZE FOR IMPLICIT TS (IMPDSSIZE)............................4 FLASHCOPY LOAD (FLASHCOPY_LOAD)..............................NO
ENABLE MULTIPLE INDEX ACCESS (SUBQ_MIDX)....................YES FLASHCOPY REORG TABLESPACE (FLASHCOPY_REORG_TS)..............NO
SP_PARMS_JV (DDF_COMPATIBILITY)..............................NO FLASHCOPY REBUILD INDEX (FLASHCOPY_REBUILD_INDEX)............NO
SP_PARMS_NJV (DDF_COMPATIBILITY).............................NO FLASHCOPY REORG INDEX (FLASHCOPY_REORG_INDEX)................NO
DISABLE_IMPCAST_JV (DDF_COMPATIBILITY).......................NO SYSTEM-LEVEL BACKUPS (SYSTEM_LEVEL_BACKUPS)..................NO
DISABLE_IMPCAST_NJV (DDF_COMPATIBILITY)......................NO RESTORE/RECOVER (RESTORE_RECOVER_FROMDUMP)...................NO
IGNORE_TZ (DDF_COMPATIBILITY)................................NO DUMP CLASS NAME (UTILS_DUMP_CLASS_NAME).................'BLANK'
DDF COMP PRIOR VERSION (DDF_COMPATIBILITY)..................N/P MAXIMUM TAPE UNITS (RESTORE_TAPEUNITS)........................0
DYN STMT CACHE STOR (CACHE_DEP_TRACK_STOR_LIM)..............N/A REORG PART SORT NPSI (REORG_PART_SORT_NPSI)................AUTO
ACTIVATE I/O SCHEDULING.....................................YES REORG LIST PROCESSING (REORG_LIST_PROCESSING)..........PARALLEL
VALUE FOR TRIGGER DRAIN.......................................1 REORG MAPPING DATABASE (REORG_MAPPING_DATABASE).............N/P
MAX NUMBER OF DDS WITH HOLD...................................3 REORG DROP PBG PARTS (REORG_DROP_PBG_PARTS)..................NO
FIELD PROCS FOR DESCRIBE TABLE BLOCK..........................5 REORG IGNORE FREESPACE (REORG_IGNORE_FREESPACE).............N/A
RESTRICT ALTER COLUMN FOR DCC (RESTRICT_ALT_COL_FOR_DCC).....NO ALTERNATE COPYPOOL (ALTERNATE_CP)...........................N/P
SPACE RESERVED FOR Z/OS FUNCTIONS........................40,960 DB BACKUP STG GROUP (UTIL_DBBSG)............................N/P
SPACE RESERVED FOR CRITICAL WORK.....................39,387,136 LOG BACKUP STG GROUP (UTIL_LGBSG)...........................N/P
SPACE RESERVED ON TOP OF Z/OS AND CRITICAL SPACE.....39,387,136 HSM MESSAGE DS HLQ (UTILS_HSM_MSGDS_HLQ)....................N/P
DETAILED MEASURED UNIT PRICE TRACKING........................NO
OTC LICENSE TERMS ACCEPTED...................................NO DATABASES AND SPACES STARTED AUTOMATICALLY (DSNTIPS)
SIMULATED CPUS................................................0 ----------------------------------------------------
EXECUTION TIME OF TASK/SRB IN MICROSECONDS....................0 ALL
MAX 'NOT FOUND' HASH RECORDS................................100
MAX EXTEND SERVICE TASKS.....................................20 ICF CATALOG QUALIFIERS
PROJECT Z INSERTION THRESHOLD.................................2 ----------------------
MAX ZIVLEMPEL DICTIONARY ENTRIES..........................4,096 DSNC51
REORG KEEPDICTIONARY IN BRF TO RRF CONVERSION................NO
DRDA RESOLVE ALIAS (DRDA_RESOLVE_ALIAS).....................YES SIZES PANEL 1 (DSNTIPD)
PC YES SPECIFIED............................................YES -----------------------
BLOCK OPT 1 ROW SORT (OPT1ROWBLOCKSORT)......................NO LOB INLINE LENGTH (LOB_INLINE_LENGTH).........................0
EMPTY XML ELEMENT (XML_RESTRICT_EMPTY_TAG)...................NO USER LOB VALUE STORAGE IN KB (LOBVALA)......................N/A
SUPPRESS_HINT_SQLCODE_DYN (SUPPRESS_HINT_SQLCODE_DYN) .......NO SYSTEM LOB VALUE STORAGE IN MB (LOBVALS).................51,200
INDEX MEMORY CONTROL (INDEX_MEMORY_CONTROL)................AUTO USER XML VALUE STG IN KB (XMLVALA)..........................N/A
LOCATION: OMPDC51 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 10-6
GROUP: N/P SYSTEM PARAMETERS REPORT
MEMBER: N/P
SUBSYSTEM: DC51 ACTUAL FROM: 08/24/16 07:01:00.00
B2 VERSION: V12
SELECT FOR UNLOAD (AUTH_COMPATIBILITY).......................NO SYSTEM XML VAL STG IN MB (XMLVALS).......................51,200
MATERIALIZE NODET SQLTUDF (MATERIALIZE_NODET_SQLTUDF)........NO
PROTECTION PANEL (DSNTIPP1)
DEFAULT STARTUP MODULES (DSNTIPO3) ---------------------------
---------------------------------- SECURITY ADMINISTRATOR 1 AUTHORIZATION ID (SECADM1)........LOGO
PARAMETER MODULE.......................................DSNZPARM SECURITY ADMINISTRATOR 1 TYPE (SECADM1_TYPE).............AUTHID
ACCESS CONTROL (ACCESS_CNTL_MODULE)....................DSNX§XAC SECURITY ADMINISTRATOR 2 AUTHORIZATION ID (SECADM2)........KIVO
IDENTIFY/AUTH (IDAUTH_MODULE)..........................DSN3§ATH SECURITY ADMINISTRATOR 2 TYPE (SECADM2_TYPE).............AUTHID
SIGNON (SIGNON_MODULE).................................DSN3§SGN SEPARATE SECURITY DUTIES (SEPARATE_SECURITY).................NO
INCLUDE DEPENDENT PRIVILEGES (REVOKE_DEP_PRIVILEGES)....SQLSTMT
INSTALL DB2 - RESOURCE LIMIT FACILITY (DSNTIPO4)
------------------------------------------------
RESOURCE LIMIT FACILITY AUTOMATIC START (RLF)................NO
RESOURCE LIMIT SPECIFICATION TABLE SUFFIX (RLFTBL)...........01
RESOURCE LIMIT DYNAMIC ERROR ACTION (RLFERR)............NOLIMIT
RESOURCE LIMIT STATIC ERROR ACTION (RLFERRSTC)..........NOLIMIT
RLF REMOTE DYNAMIC ERROR ACTION (RLFERRD)...............NOLIMIT
RLF REMOTE STATIC ERROR ACTION (RLFERRDSTC).............NOLIMIT
RLF SCOPE (RLFENABLE)...................................DYNAMIC
LOCATION: OMPDC51 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 10-7
GROUP: N/P SYSTEM PARAMETERS REPORT
MEMBER: N/P
SUBSYSTEM: DC51 ACTUAL FROM: 08/24/16 07:01:00.00
B2 VERSION: V12
DB2 CATALOG AND DIRECTORY PANEL (DSNTIPA2)
------------------------------------------
SMS DATA CLASS FOR CATALOG DATA (CATDDACL)................XVSAM
SMS MANAGEMENT CLASS FOR CATALOG DATA (CATDMGCL)............DB2
SMS STORAGE CLASS FOR CATALOG DATA (CATDSTCL)...............DB2
SMS DATA CLASS FOR CATALOG INDEX DATA (CATXDACL)..........XVSAM
SMS MANAGEMENT CLASS FOR CATALOG INDEX DATA (CATXMGCL)......DB2
SMS STORAGE CLASS FOR CATALOG INDEX DATA (CATXSTCL).........DB2
COMPRESS SPT01 (COMPRESS_SPT01)..............................NO
SPT01 INLINE LENGTH (SPT01_INLINE_LENGTH)................32,138
LOCATION: OMPDC51 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 10-8
GROUP: N/P SYSTEM PARAMETERS REPORT
MEMBER: N/P
SUBSYSTEM: DC51 ACTUAL FROM: 08/24/16 07:01:00.00
B2 VERSION: V12
BUFFER POOL PARAMETERS
--------------------------------------------------------------------------------------------------------------
TIMESTAMP 08/24/16 07:01:00.00 VPOOL SIZE (PAGES) 5000
BUFFER POOL ID BP0 VPOOL SEQ THRESH 80
HORIZ DEFER WRITE THRESH 30
VERT DEFER WRITE THRESH (%) 5
VERT DEFER WRITE THRESH (BUF) 0
VPOOL PARALLEL SEQ THRESH 50
ASSISTING PARALLEL SEQ THRESH 0
PGFIX ATTRIBUTE NO
PAGE STEAL METHOD LRU
AUTOSIZE NO
FRAMESIZE 4K
VPOOL SIZE MIN 0
VPOOL SIZE MAX 0
SIM POOL SIZE 0
SIM POOL SEQ THRESH 0
TIMESTAMP 08/24/16 07:01:00.00 VPOOL SIZE (PAGES) 10000
BUFFER POOL ID BP1 VPOOL SEQ THRESH 80
HORIZ DEFER WRITE THRESH 30
VERT DEFER WRITE THRESH (%) 5
VERT DEFER WRITE THRESH (BUF) 0
VPOOL PARALLEL SEQ THRESH 50
ASSISTING PARALLEL SEQ THRESH 0
PGFIX ATTRIBUTE NO
PAGE STEAL METHOD LRU
AUTOSIZE NO
FRAMESIZE 4K
VPOOL SIZE MIN 0
VPOOL SIZE MAX 0
SIM POOL SIZE 0
SIM POOL SEQ THRESH 0
TIMESTAMP 08/24/16 07:01:00.00 VPOOL SIZE (PAGES) 20000
BUFFER POOL ID BP2 VPOOL SEQ THRESH 80
HORIZ DEFER WRITE THRESH 30
VERT DEFER WRITE THRESH (%) 5
VERT DEFER WRITE THRESH (BUF) 0
VPOOL PARALLEL SEQ THRESH 50
ASSISTING PARALLEL SEQ THRESH 0
PGFIX ATTRIBUTE NO
PAGE STEAL METHOD LRU
AUTOSIZE NO
FRAMESIZE 4K
VPOOL SIZE MIN 0
VPOOL SIZE MAX 0
SIM POOL SIZE 0
SIM POOL SEQ THRESH 0
LOCATION: OMPDC51 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 10-9
GROUP: N/P SYSTEM PARAMETERS REPORT
MEMBER: N/P
SUBSYSTEM: DC51 ACTUAL FROM: 08/24/16 07:01:00.00
B2 VERSION: V12
BUFFER POOL PARAMETERS
--------------------------------------------------------------------------------------------------------------
TIMESTAMP 08/24/16 07:01:00.00 VPOOL SIZE (PAGES) 5000
BUFFER POOL ID BP3 VPOOL SEQ THRESH 80
HORIZ DEFER WRITE THRESH 30
VERT DEFER WRITE THRESH (%) 5
VERT DEFER WRITE THRESH (BUF) 0
VPOOL PARALLEL SEQ THRESH 50
ASSISTING PARALLEL SEQ THRESH 0
PGFIX ATTRIBUTE NO
PAGE STEAL METHOD LRU
AUTOSIZE NO
FRAMESIZE 4K
VPOOL SIZE MIN 0
VPOOL SIZE MAX 0
SIM POOL SIZE 0
SIM POOL SEQ THRESH 0
TIMESTAMP 08/24/16 07:01:00.00 VPOOL SIZE (PAGES) 10000
BUFFER POOL ID BP7 VPOOL SEQ THRESH 80
HORIZ DEFER WRITE THRESH 30
VERT DEFER WRITE THRESH (%) 5
VERT DEFER WRITE THRESH (BUF) 0
VPOOL PARALLEL SEQ THRESH 50
ASSISTING PARALLEL SEQ THRESH 0
PGFIX ATTRIBUTE NO
PAGE STEAL METHOD LRU
AUTOSIZE NO
FRAMESIZE 4K
VPOOL SIZE MIN 0
VPOOL SIZE MAX 0
SIM POOL SIZE 0
SIM POOL SEQ THRESH 0
TIMESTAMP 08/24/16 07:01:00.00 VPOOL SIZE (PAGES) 2000
BUFFER POOL ID BP9 VPOOL SEQ THRESH 80
HORIZ DEFER WRITE THRESH 30
VERT DEFER WRITE THRESH (%) 5
VERT DEFER WRITE THRESH (BUF) 0
VPOOL PARALLEL SEQ THRESH 50
ASSISTING PARALLEL SEQ THRESH 0
PGFIX ATTRIBUTE NO
PAGE STEAL METHOD LRU
AUTOSIZE NO
FRAMESIZE 4K
VPOOL SIZE MIN 0
VPOOL SIZE MAX 0
SIM POOL SIZE 0
SIM POOL SEQ THRESH 0
LOCATION: OMPDC51 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 10-10
GROUP: N/P SYSTEM PARAMETERS REPORT
MEMBER: N/P
SUBSYSTEM: DC51 ACTUAL FROM: 08/24/16 07:01:00.00
B2 VERSION: V12
BUFFER POOL PARAMETERS
--------------------------------------------------------------------------------------------------------------
TIMESTAMP 08/24/16 07:01:00.00 VPOOL SIZE (PAGES) 1000
BUFFER POOL ID BP32K VPOOL SEQ THRESH 80
HORIZ DEFER WRITE THRESH 30
VERT DEFER WRITE THRESH (%) 5
VERT DEFER WRITE THRESH (BUF) 0
VPOOL PARALLEL SEQ THRESH 50
ASSISTING PARALLEL SEQ THRESH 0
PGFIX ATTRIBUTE NO
PAGE STEAL METHOD LRU
AUTOSIZE NO
FRAMESIZE 4K
VPOOL SIZE MIN 0
VPOOL SIZE MAX 0
SIM POOL SIZE 0
SIM POOL SEQ THRESH 0
TIMESTAMP 08/24/16 07:01:00.00 VPOOL SIZE (PAGES) 5000
BUFFER POOL ID BP32K1 VPOOL SEQ THRESH 80
HORIZ DEFER WRITE THRESH 30
VERT DEFER WRITE THRESH (%) 5
VERT DEFER WRITE THRESH (BUF) 0
VPOOL PARALLEL SEQ THRESH 50
ASSISTING PARALLEL SEQ THRESH 0
PGFIX ATTRIBUTE NO
PAGE STEAL METHOD LRU
AUTOSIZE NO
FRAMESIZE 4K
VPOOL SIZE MIN 0
VPOOL SIZE MAX 0
SIM POOL SIZE 0
SIM POOL SEQ THRESH 0
TIMESTAMP 08/24/16 07:01:00.00 VPOOL SIZE (PAGES) 2000
BUFFER POOL ID BP8K0 VPOOL SEQ THRESH 80
HORIZ DEFER WRITE THRESH 30
VERT DEFER WRITE THRESH (%) 5
VERT DEFER WRITE THRESH (BUF) 0
VPOOL PARALLEL SEQ THRESH 50
ASSISTING PARALLEL SEQ THRESH 0
PGFIX ATTRIBUTE NO
PAGE STEAL METHOD LRU
AUTOSIZE NO
FRAMESIZE 4K
VPOOL SIZE MIN 0
VPOOL SIZE MAX 0
SIM POOL SIZE 0
SIM POOL SEQ THRESH 0
LOCATION: OMPDC51 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 10-11
GROUP: N/P SYSTEM PARAMETERS REPORT
MEMBER: N/P
SUBSYSTEM: DC51 ACTUAL FROM: 08/24/16 07:01:00.00
B2 VERSION: V12
BUFFER POOL PARAMETERS
--------------------------------------------------------------------------------------------------------------
TIMESTAMP 08/24/16 07:01:00.00 VPOOL SIZE (PAGES) 2000
BUFFER POOL ID BP8K1 VPOOL SEQ THRESH 80
HORIZ DEFER WRITE THRESH 30
VERT DEFER WRITE THRESH (%) 5
VERT DEFER WRITE THRESH (BUF) 0
VPOOL PARALLEL SEQ THRESH 50
ASSISTING PARALLEL SEQ THRESH 0
PGFIX ATTRIBUTE NO
PAGE STEAL METHOD LRU
AUTOSIZE NO
FRAMESIZE 4K
VPOOL SIZE MIN 0
VPOOL SIZE MAX 0
SIM POOL SIZE 0
SIM POOL SEQ THRESH 0
TIMESTAMP 08/24/16 07:01:00.00 VPOOL SIZE (PAGES) 2000
BUFFER POOL ID BP16K0 VPOOL SEQ THRESH 80
HORIZ DEFER WRITE THRESH 30
VERT DEFER WRITE THRESH (%) 5
VERT DEFER WRITE THRESH (BUF) 0
VPOOL PARALLEL SEQ THRESH 50
ASSISTING PARALLEL SEQ THRESH 0
PGFIX ATTRIBUTE NO
PAGE STEAL METHOD LRU
AUTOSIZE NO
FRAMESIZE 4K
VPOOL SIZE MIN 0
VPOOL SIZE MAX 0
SIM POOL SIZE 0
SIM POOL SEQ THRESH 0
TIMESTAMP 08/24/16 07:01:00.00 VPOOL SIZE (PAGES) 2000
BUFFER POOL ID BP16K1 VPOOL SEQ THRESH 80
HORIZ DEFER WRITE THRESH 30
VERT DEFER WRITE THRESH (%) 5
VERT DEFER WRITE THRESH (BUF) 0
VPOOL PARALLEL SEQ THRESH 50
ASSISTING PARALLEL SEQ THRESH 0
PGFIX ATTRIBUTE NO
PAGE STEAL METHOD LRU
AUTOSIZE NO
FRAMESIZE 4K
VPOOL SIZE MIN 0
VPOOL SIZE MAX 0
SIM POOL SIZE 0
SIM POOL SEQ THRESH 0