Use your ISPF editor to create a JCL job that creates a
System Parameters report.
The following JCL is an example. Remember to change the setup
information (starting with // in your JCL) as appropriate
for your installation.Figure 1. System parameters job stream using ISPF/PDF editor
EDIT ---- ANDREW.OMPE.JOBS.SYPTRC--------------------- Columns 001 072
Command ===> ________________________________________________ Scroll ===> CSR_
****** ***************************** TOP OF DATA ******************************
0001 /* JCL to produce a System Parameters report */
0002 //AWOMPEA JOB (TTS1,YUS7),'ANDREW',
0003 // MSGCLASS=V,CLASS=D,NOTIFY=ANDREW
0004 // EXEC PGM=FPECMAIN
0005 //STEPLIB DD DSN=OMPE.RKANMOD,DISP=SHR
0006 //INPUTDD DD DSN=ANDREW.OMPE.TRACES.SYSP,DISP=SHR
0007 //DPMOUTDD DD DSN=ANDREW.OMPE.OUT.SYSPT1,DISP=OVR
0008 //JOBSUMDD DD SYSOUT=A
0009 //SYSIN DD *
0010 SYSPARMS
0011 EXEC
0012 ****** **************************** BOTTOM OF DATA ****************************
F1=Help F2=Split F3=Exit F5=Rfind F6=Rchange F7=Up
F8=Down F9=Swap F10=Left F11=Right F12=Cancel
To submit the job, type SUBMIT on the command
line and press Enter.
Example of the System Parameters report
1 LOCATION: RS22ODS5 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 1-1
GROUP: ODS5 SYSTEM PARAMETERS REPORT
MEMBER: OCA5
SUBSYSTEM: OCA5 ACTUAL FROM: 02/06/19 09:53:14.72
DB2 VERSION: V12
-
MVS PARMLIB UPDATE PARAMETERS (DSNTIPM) IRLM INSTALLATION PARAMETERS (DSNTIPI)
--------------------------------------- --------------------------------------
SUBSYSTEM DEFAULT (SSID)...................................ODS5 IRLM SUBSYSTEM NAME (IRLMSID)..............................IRP7
SUPPRESS SOFT ERRORS (SUPERRS)..............................YES IRLM RESOURCE TIMEOUT IN SECONDS (IRLMRWT)...................30
IRLM AUTOMATIC START (IRLMAUT)..............................YES
STORAGE SIZES INSTALLATION PARMS (DSNTIPC,DSNTIPE,DSNTIPE1) IRLM START PROCEDURE NAME (IRLMPRC)....................OCA5IRLM
--------------------------------------------------------------- SECONDS DB2 WILL WAIT FOR IRLM START (IRLMSWT)..............300
MAX NO OF DATA SETS CONCURRENTLY IN USE (DSMAX)...........3,000 U LOCK FOR REPEATABLE READ OR READ STABILITY (RRULOCK)......YES
EDM STATEMENT CACHE SIZE IN KB (EDMSTMTC)................56,693 X LOCK FOR SEARCHED UPDATE/DELETE (XLKUPDLT).................NO
EDM DBD CACHE SIZE IN KB (EDMDBDC).......................11,700 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).................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)..................8,000
MAX NO OF USERS CONCURRENTLY RUNNING IN DB2 (CTHREAD).......200 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..............................1,000
MAX NO OF TSO CONNECTIONS (IDFORE)...........................50 NUMBER OF LOCAL CYCLES PER GLOBAL CYCLE.......................1
MAX NO OF BATCH CONNECTIONS (IDBACK).........................50 TIMEOUT INTERVAL.............................................30
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.........................16,777,216
MANAGE REAL STORAGE (REALSTORAGE_MANAGEMENT)...............AUTO PENDING NUMBER OF HASH ENTRIES................................0
MAXIMUM REAL STORAGE (REALSTORAGE_MAX)........................0 Z/OS LOCK TABLE LIST ENTRIES.............................36,346
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).......................3390
------------------------------------------------------- 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)............................25
TRACE TABLE SIZE IN 4K BYTES (TRACTBL).......................16 SECONDARY SPACE ALLOCATION (SECQTY)..........................25
LOCAL TRACE TABLE SIZE IN 4K BYTES (TRACLOC).................16 ARCHIVE LOG BLOCK SIZE IN BYTES (BLKSIZE)................24,576
START SMF ACCOUNTING (SMFACCT)........................1,2,3,7,8 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)................30 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)....................................NO DAYS TO RETAIN ARCHIVE LOG DATA SETS (ARCRETN)................0
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).....................................YES
COMPRESS SMF RECS (SMFCOMP).................................OFF
1 LOCATION: RS22ODS5 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 1-2
GROUP: ODS5 SYSTEM PARAMETERS REPORT
MEMBER: OCA5
SUBSYSTEM: OCA5 ACTUAL FROM: 02/06/19 09:53:14.72
DB2 VERSION: V12
-
DISTRIBUTED DATA FACILITY PANEL 2 (DSNTIP5) DEFINE GROUP OR MEMBER (DSNTIPK)
------------------------------------------- --------------------------------
TCP/IP ALREADY VERIFIED (TCPALVER)..........................YES GROUP NAME (GRPNAME).......................................ODS5
EXTRA BLOCKS REQ (EXTRAREQ).................................100 MEMBER NAME (MEMBNAME).....................................OCA5
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).....................180
ROUTINE AUTHORIZATION CACHE SIZE (CACHERAC)...........5,242,880 EXTENDED SECURITY (EXTSEC)..................................YES
AUTH EXIT CHECK (AUTHEXIT_CHECK)........................PRIMARY USER ID AND PASSWORD REQUIRED...............................N/A
AUTH EXIT CACHE REFRESH (AUTHEXIT_CACHEREFRESH)............NONE SQL INTERRUPT PROCESSING DISABLED (SQLINTRP).................NO
SYSTEM ADMINISTRATOR 1 AUTHORIZATION ID (SYSADM)........DB2SYSP PRIVATE PROTOCOL (PRIVATE_PROTOCOL)..........................NO
SYSTEM ADMINISTRATOR 2 AUTHORIZATION ID (SYSADM2)........CSMARK
SYSTEM OPERATOR 1 AUTHORIZATION ID (SYSOPR1).............PDKURT LOCK ESCALATION PARAMETERS (DSNTIPJ)
SYSTEM OPERATOR 2 AUTHORIZATION ID (SYSOPR2)..............TSSAL ------------------------------------
DEFAULT (UNKNOWN) USER AUTHORIZATION ID (DEFLTID).......IBMUSER MAX PAGE OR ROW LOCKS PER TABLE SPACE (NUMLKTS)...........1,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)...................................YES LOG INSTALLATION PARAMETERS (DSNTIPL,DSNTIPH)
---------------------------------------------
DATA DEFINITION CONTROL SUPPORT (DSNTIPZ) OUTPUT BUFFER SIZE IN K BYTES (OUTBUFF).....................400
----------------------------------------- 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)........................1,000,000
UNREGISTERED DDL DEFAULT (RGFDEFLT)......................ACCEPT UR CHECK FREQUENCY (URCHKTH)..................................5
REGISTER TABLE OWNER (RGFCOLID)........................DSNRGCOL UR LOG RECORD WRITTEN THRESHOLD IN KB (URLGWTH)...............5
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)..............................5
ESCAPE CHARACTER (RGFESCP)................................X'40' PSEUDO-CLOSE TIMER (PCLOSET).................................60
CHECKPOINTS BETWEEN LEVEL ID UPDATES (DLDFREQ)................5
DB2 VERSION INSTALL (DSNTIPA1) NUMBER OF ACTIVE LOG COPIES (TWOACTV).........................2
------------------------------ NUMBER OF ARCHIVE LOG COPIES (TWOARCH)........................1
DATA SHARING ENABLED (DSHARE)...............................YES COPY 1 PREFIX (ARCPFX1)...........................OCA5.ARCHLOG1
CURRENT DB2 RELEASE (NEWFUN)................................N/A COPY 2 PREFIX (ARCPFX2).................................DSNARC2
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
1 LOCATION: RS22ODS5 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 1-3
GROUP: ODS5 SYSTEM PARAMETERS REPORT
MEMBER: OCA5
SUBSYSTEM: OCA5 ACTUAL FROM: 02/06/19 09:53:14.72
DB2 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)..........................................USA
DEFAULT MIXED GRAPHIC (MIXED)................................NO TIME FORMAT (TIME)..........................................ISO
EBCDIC SBCS CCSID (SCCSID)...................................37 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)..................................437 STD SQL LANGUAGE (STDSQL)....................................NO
ASCII MBCS CCSID (AMCCSID)..................................N/P PAD NULL-TERMINATED (PADNTSTR)..............................YES
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 ODS5.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)...............BASIC 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)...................................15
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)............................YES
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)..................................255
DEFINE DATA SETS (IMPDSDEF).................................YES TIMEOUT VALUE (STORTIME)......................................5
USE DATA COMPRESSION (IMPTSCMP)..............................NO WLM ENVIRONMENT (WLMENV)...............................ODS5WLM1
LIMIT KEY CONV PART TAB (IX_TB_PART_CONV_EXCLUDE)............NO 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)..........NO
DDL MATERIALIZATION (DDL_MATERIALIZATION)......ALWAYS_IMMEDIATE
DEFAULT INSERT ALGORITHM (DEFAULT_INSERT_ALGORITHM)...........2
1 LOCATION: RS22ODS5 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 1-4
GROUP: ODS5 SYSTEM PARAMETERS REPORT
MEMBER: OCA5
SUBSYSTEM: OCA5 ACTUAL FROM: 02/06/19 09:53:14.72
DB2 VERSION: V12
PERFORMANCE AND OPTIMIZATION (DSNTIP8,DSNTIP81) BUFFER POOL PARAMETERS (DSNTIP1)
----------------------------------------------- --------------------------------
CACHE DYNAMIC SQL (CACHEDYN)................................YES DEFAULT 4-KB BUFFER POOL FOR USER DATA (TBSBPOOL)..........BP0
CACHE DYN STABILITY (CACHEDYN_STABILIZATION)...............BOTH DEFAULT 8-KB BUFFER POOL FOR USER DATA (TBSBP8K).........BP8K0
OPTIMIZATION HINTS ALLOWED (OPTHINTS)........................NO DEFAULT 16-KB BUFFER POOL FOR USER DATA (TBSBP16K).......BP16K0
EVALUATE UNCOMMITTED (EVALUNC)...............................NO DEFAULT 32-KB BUFFER POOL FOR USER DATA (TBSBP32K)........BP32K
SKIP UNCOMM INSERTS (SKIPUNCI)...............................NO DEFAULT BUFFER POOL FOR USER LOB DATA (TBSBPLOB)............BP0
IMMEDWRITE OVERRIDE FLAG (IMMEDWRI)..........................NO DEFAULT BUFFER POOL FOR USER XML DATA (TBSBPXML).........BP16K0
REBIND PLANMGMT DEFAULT (PLANMGMT)..........................OFF DEFAULT BUFFER POOL FOR USER INDEXES (IDXBPOOL).............BP0
PLANMGMTSCOPE DEFAULT (PLANMGMTSCOPE)....................STATIC
PACKAGE RELEASE COMMIT (PKGREL_COMMIT)......................YES QUERY ACCELERATOR PREFERENCES (DSNTIP82)
RANDOMIZE XML DOCID (XML_RANDOMIZE_DOCID)....................NO ----------------------------------------
DISABLE EDM RTS (DISABLE_EDMRTS).............................NO ACCELERATOR STARTUP OPTION (ACCEL)......................COMMAND
CURRENT DEGREE (CDSSRDEF)...................................ANY GET ACCEL ARCHIVE (GET_ACCEL_ARCHIVE)........................NO
MAX DEGREE OF PARALLELISM (PARAMDEG)..........................0 ACCELERATION OPTIONS (QUERY_ACCEL_OPTIONS)..........(1,2,3,5,6)
MAX DEGREE FOR DPSI (PARAMDEG_DPSI)...........................0 CURRENT QUERY ACCEL (QUERY_ACCELERATION).................ENABLE
PARALLELISM EFFICIENCY (PARA_EFF)............................50 ACCELERATION MODELING (ACCELMODEL)...........................NO
STAR JOIN ENABLING (STARJOIN) ..........................DISABLE REMOTE COPY SW ACCEL (REMOTE_COPY_SW_ACCEL)..................NO
MAX DATA CACHING IN MB (MXDTCACH)............................20 HTAP WAIT INTERVAL (QUERY_ACCEL_WAITFORDATA)................0.0
CURRENT REFRESH AGE (REFSHAGE)................................0
CURRENT MAINT TYPE (MAINTYPE)............................SYSTEM WORKFILE DATABASE PANEL (DSNTIP91)
STATS PROFILE FEEDBACK (STATFDBK_PROFILE)...................YES ----------------------------------
MAX TEMP STORAGE PER AGENT IN MB (MAXTEMPS)...................0
OTHER SYSTEM PARAMETERS SEPARATE WORK FILES (WFDBSEP)................................NO
----------------------- MAX TEMP RID (MAXTEMPS_RID).............................NOLIMIT
DUAL BSDS MODE (TWOBSDS)....................................YES AGENT LEVEL THRESHOLD (WFSTGUSE_AGENT_THRESHOLD)..............0
ROLL UP PARALLEL TASK ACCOUNTING (PTASKROL).................YES SYSTEM LEVEL THRESHOLD (WFSTGUSE_SYSTEM_THRESHOLD)...........90
NO. PAGES SMALL TABLE THRESHOLD (NPGTHRSH)....................0
OFFLOAD OPTION (OFFLOAD)....................................YES DB2 UTILITIES PARAMETERS (DSNTIP6,DSNTIP61,DSNTIP62)
SU CONVERSION FACTOR........................................200 ----------------------------------------------------
MINIMUM DIVIDE SCALE (MINDVSCL)............................NONE TEMPORARY UNIT NAME (VOLTDEVT)............................SYSDA
STAR JOIN THRESHOLD (SJTABLES)...............................10 UTIL TEMP STORCLAS (UTIL_TEMP_STORCLAS).....................N/P
ONLINE SYSTEM PARM USER ID MONITOR..........................N/P STATISTICS HISTORY (STATHIST)...............................ALL
ONLINE SYSTEM PARM CORREL ID MONITOR........................N/P STATISTICS ROLLUP (STATROLL)................................YES
ONLINE SYSTEM PARM TIME CHANGED.............................N/P UTILITY TIMEOUT FACTOR (UTIMOUT)..............................6
ONLINE SYSTEM PARM TYPE.....................................N/P UT SORT DATA SET ALLOCATION (UTSORTAL)......................N/A
DB2-SUPPLIED DECP INDICATOR...............................X'D5' IGNORE SORTNUM STMT (IGNSORTN)...............................NO
MAX CONCURRENT PKG OPS (MAX_CONCURRENT_PKG_OPS)..............10 SET CHECK PENDING (CHECK_SETCHKP)...........................N/A
ADMIN SCHEDULER JCL PROC NAME (ADMTPROC)....................N/P UT DB2 SORT USE (DB2SORT)...................................N/A
FREE LOCAL CACHED STATEMENTS (CACHEDYN_FREELOCAL)...........N/A TEMPLATE TIME (TEMPLATE_TIME)...............................UTC
INDEX I/O PARALLELISM (INDEX_IO_PARALLELISM)................N/A MAXIMUM DEGREE OF UTILITY PARALLELISM (PARAMDEG_UTIL)........99
ZOSMETRICS...................................................NO FAST REPLICATION (CHECK_FASTREPLICATION)..............PREFERRED
USE TRACKMOD FOR IMPLICIT TS (IMPTKMOD).....................YES FAST RESTORE (REC_FASTREPLICATION)....................PREFERRED
DSSIZE FOR IMPLICIT TS (IMPDSSIZE)............................4 COPY FAST REPLICATION (COPY_FASTREPLICATION)..........PREFERRED
ENABLE MULTIPLE INDEX ACCESS (SUBQ_MIDX)....................YES FLASHCOPY PPRC (FLASHCOPY_PPRC)........................REQUIRED
SP_PARMS_JV (DDF_COMPATIBILITY)..............................NO DEFAULT TEMPLATE (FCCOPYDDN)...................................
SP_PARMS_NJV (DDF_COMPATIBILITY).............................NO ODS5.&DB..&SN..N&DS..D&JU..T&TI.
DISABLE_IMPCAST_JV (DDF_COMPATIBILITY).......................NO FLASHCOPY COPY (FLASHCOPY_COPY)..............................NO
DISABLE_IMPCAST_NJV (DDF_COMPATIBILITY)......................NO FLASHCOPY LOAD (FLASHCOPY_LOAD)..............................NO
IGNORE_TZ (DDF_COMPATIBILITY)................................NO FLASHCOPY REORG TABLESPACE (FLASHCOPY_REORG_TS)..............NO
DDF COMP PRIOR VERSION (DDF_COMPATIBILITY)..................N/P FLASHCOPY REBUILD INDEX (FLASHCOPY_REBUILD_INDEX)............NO
1 LOCATION: RS22ODS5 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 1-5
GROUP: ODS5 SYSTEM PARAMETERS REPORT
MEMBER: OCA5
SUBSYSTEM: OCA5 ACTUAL FROM: 02/06/19 09:53:14.72
DB2 VERSION: V12
DYN STMT CACHE STOR (CACHE_DEP_TRACK_STOR_LIM)..............N/A FLASHCOPY REORG INDEX (FLASHCOPY_REORG_INDEX)................NO
ACTIVATE I/O SCHEDULING.....................................YES SYSTEM-LEVEL BACKUPS (SYSTEM_LEVEL_BACKUPS)..................NO
VALUE FOR TRIGGER DRAIN.......................................1 RESTORE/RECOVER (RESTORE_RECOVER_FROMDUMP)...................NO
MAX NUMBER OF DDS WITH HOLD...................................3 DUMP CLASS NAME (UTILS_DUMP_CLASS_NAME).................'BLANK'
FIELD PROCS FOR DESCRIBE TABLE BLOCK..........................5 MAXIMUM TAPE UNITS (RESTORE_TAPEUNITS)........................0
RESTRICT ALTER COLUMN FOR DCC (RESTRICT_ALT_COL_FOR_DCC).....NO REORG PART SORT NPSI (REORG_PART_SORT_NPSI)................AUTO
SPACE RESERVED FOR Z/OS FUNCTIONS........................40,960 REORG LIST PROCESSING (REORG_LIST_PROCESSING)..........PARALLEL
SPACE RESERVED FOR CRITICAL WORK.....................26,279,936 REORG MAPPING DATABASE (REORG_MAPPING_DATABASE).............N/P
SPACE RESERVED ON TOP OF Z/OS AND CRITICAL SPACE.....26,279,936 REORG DROP PBG PARTS (REORG_DROP_PBG_PARTS)..................NO
DETAILED MEASURED UNIT PRICE TRACKING........................NO REORG IGNORE FREESPACE (REORG_IGNORE_FREESPACE).............N/A
OTC LICENSE TERMS ACCEPTED...................................NO ALTERNATE COPYPOOL (ALTERNATE_CP)...........................N/P
SIMULATED CPUS................................................0 DB BACKUP STG GROUP (UTIL_DBBSG)............................N/P
CPU FOR EXPLAIN STATEMENTS (CPU_FOR_EXPLAIN)..................1 LOG BACKUP STG GROUP (UTIL_LGBSG)...........................N/P
MAX 'NOT FOUND' HASH RECORDS................................100 HSM MESSAGE DS HLQ (UTILS_HSM_MSGDS_HLQ)....................N/P
MAX EXTEND SERVICE TASKS.....................................20
PROJECT Z INSERTION THRESHOLD.................................2 DATABASES AND SPACES STARTED AUTOMATICALLY (DSNTIPS)
MAX ZIVLEMPEL DICTIONARY ENTRIES..........................4,096 ----------------------------------------------------
REORG KEEPDICTIONARY IN BRF TO RRF CONVERSION...............YES ALL
DRDA RESOLVE ALIAS (DRDA_RESOLVE_ALIAS).....................YES
PC YES SPECIFIED............................................YES ICF CATALOG QUALIFIERS
BLOCK OPT 1 ROW SORT (OPT1ROWBLOCKSORT)......................NO ----------------------
EMPTY XML ELEMENT (XML_RESTRICT_EMPTY_TAG)...................NO ODS5
SUPPRESS_HINT_SQLCODE_DYN (SUPPRESS_HINT_SQLCODE_DYN) .......NO
INDEX MEMORY CONTROL (INDEX_MEMORY_CONTROL)................AUTO SIZES PANEL 1 (DSNTIPD)
SELECT FOR UNLOAD (AUTH_COMPATIBILITY).......................NO -----------------------
MATERIALIZE NODET SQLTUDF (MATERIALIZE_NODET_SQLTUDF)........NO LOB INLINE LENGTH (LOB_INLINE_LENGTH)........................25
ENCRYPTION_KEYLABEL (ENCRYPTION_KEYLBL).....................N/P USER LOB VALUE STORAGE IN KB (LOBVALA)......................N/A
SYSTEM LOB VALUE STORAGE IN MB (LOBVALS).................51,200
DEFAULT STARTUP MODULES (DSNTIPO3) USER XML VALUE STG IN KB (XMLVALA)..........................N/A
---------------------------------- SYSTEM XML VAL STG IN MB (XMLVALS).......................51,200
PARAMETER MODULE.......................................OCA5PARM
ACCESS CONTROL (ACCESS_CNTL_MODULE)....................DSNX@XAC PROTECTION PANEL (DSNTIPP1)
IDENTIFY/AUTH (IDAUTH_MODULE)..........................DSN3@ATH ---------------------------
SIGNON (SIGNON_MODULE).................................DSN3@SGN SECURITY ADMINISTRATOR 1 AUTHORIZATION ID (SECADM1)......SECADM
SECURITY ADMINISTRATOR 1 TYPE (SECADM1_TYPE).............AUTHID
INSTALL DB2 - RESOURCE LIMIT FACILITY (DSNTIPO4) SECURITY ADMINISTRATOR 2 AUTHORIZATION ID (SECADM2)......SECADM
------------------------------------------------ SECURITY ADMINISTRATOR 2 TYPE (SECADM2_TYPE).............AUTHID
RESOURCE LIMIT FACILITY AUTOMATIC START (RLF)................NO SEPARATE SECURITY DUTIES (SEPARATE_SECURITY).................NO
RESOURCE LIMIT SPECIFICATION TABLE SUFFIX (RLFTBL)...........01 INCLUDE DEPENDENT PRIVILEGES (REVOKE_DEP_PRIVILEGES).........NO
RESOURCE LIMIT DYNAMIC ERROR ACTION (RLFERR)............NOLIMIT
RESOURCE LIMIT STATIC ERROR ACTION (RLFERRSTC)..........NOLIMIT DB2 CATALOG AND DIRECTORY PANEL (DSNTIPA2)
RLF REMOTE DYNAMIC ERROR ACTION (RLFERRD)...............NOLIMIT ------------------------------------------
RLF REMOTE STATIC ERROR ACTION (RLFERRDSTC).............NOLIMIT SMS DATA CLASS FOR CATALOG DATA (CATDDACL)..................N/P
RLF SCOPE (RLFENABLE)...................................DYNAMIC SMS MANAGEMENT CLASS FOR CATALOG DATA (CATDMGCL)............N/P
SMS STORAGE CLASS FOR CATALOG DATA (CATDSTCL)...............N/P
DATA PARAMETERS PANEL (DSNTIPA3) SMS DATA CLASS FOR CATALOG INDEX DATA (CATXDACL)............N/P
-------------------------------- SMS MANAGEMENT CLASS FOR CATALOG INDEX DATA (CATXMGCL)......N/P
ZHYPERLINKS SCOPE (ZHYPERLINK).........................DATABASE SMS STORAGE CLASS FOR CATALOG INDEX DATA (CATXSTCL).........N/P
COMPRESS SPT01 (COMPRESS_SPT01)..............................NO
SPT01 INLINE LENGTH (SPT01_INLINE_LENGTH)....................-1
1 LOCATION: RS25OC1A OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 2-1
GROUP: N/P SYSTEM PARAMETERS REPORT
MEMBER: N/P
SUBSYSTEM: OC1A ACTUAL FROM: 02/27/19 13:50:03.58
DB2 VERSION: V12
-
MVS PARMLIB UPDATE PARAMETERS (DSNTIPM) IRLM INSTALLATION PARAMETERS (DSNTIPI)
--------------------------------------- --------------------------------------
SUBSYSTEM DEFAULT (SSID)...................................OC1A IRLM SUBSYSTEM NAME (IRLMSID)..............................IR1C
SUPPRESS SOFT ERRORS (SUPERRS)..............................YES IRLM RESOURCE TIMEOUT IN SECONDS (IRLMRWT)...................30
IRLM AUTOMATIC START (IRLMAUT)..............................YES
STORAGE SIZES INSTALLATION PARMS (DSNTIPC,DSNTIPE,DSNTIPE1) IRLM START PROCEDURE NAME (IRLMPRC)....................OC1AIRLM
--------------------------------------------------------------- SECONDS DB2 WILL WAIT FOR IRLM START (IRLMSWT)..............300
MAX NO OF DATA SETS CONCURRENTLY IN USE (DSMAX)...........3,000 U LOCK FOR REPEATABLE READ OR READ STABILITY (RRULOCK)......YES
EDM STATEMENT CACHE SIZE IN KB (EDMSTMTC)................56,693 X LOCK FOR SEARCHED UPDATE/DELETE (XLKUPDLT).................NO
EDM DBD CACHE SIZE IN KB (EDMDBDC).......................11,700 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).................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)..................8,000
MAX NO OF USERS CONCURRENTLY RUNNING IN DB2 (CTHREAD).......200 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..............................1,000
MAX NO OF TSO CONNECTIONS (IDFORE)...........................50 NUMBER OF LOCAL CYCLES PER GLOBAL CYCLE.......................1
MAX NO OF BATCH CONNECTIONS (IDBACK).........................50 TIMEOUT INTERVAL.............................................30
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).......................3390
------------------------------------------------------- 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)............................25
TRACE TABLE SIZE IN 4K BYTES (TRACTBL).......................16 SECONDARY SPACE ALLOCATION (SECQTY)..........................25
LOCAL TRACE TABLE SIZE IN 4K BYTES (TRACLOC).................16 ARCHIVE LOG BLOCK SIZE IN BYTES (BLKSIZE)................24,576
START SMF ACCOUNTING (SMFACCT)............................1,2,3 MAXIMUM READ TAPE UNITS (MAXRTU)..............................2
START SMF STATISTICS (SMFSTAT)............................1,3,4 TAPE UNIT DEALLOCATION PERIOD (DEALLCT).................0000:00
STATISTICS TIME INTERVAL IN MINUTES (STATIME)................30 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)....................................NO DAYS TO RETAIN ARCHIVE LOG DATA SETS (ARCRETN)................0
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).....................................YES
COMPRESS SMF RECS (SMFCOMP).................................OFF
1 LOCATION: RS25OC1A OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 2-2
GROUP: N/P SYSTEM PARAMETERS REPORT
MEMBER: N/P
SUBSYSTEM: OC1A ACTUAL FROM: 02/27/19 13:50:03.58
DB2 VERSION: V12
-
DISTRIBUTED DATA FACILITY PANEL 2 (DSNTIP5) DEFINE GROUP OR MEMBER (DSNTIPK)
------------------------------------------- --------------------------------
TCP/IP ALREADY VERIFIED (TCPALVER)..........................YES GROUP NAME (GRPNAME)........................................N/P
EXTRA BLOCKS REQ (EXTRAREQ).................................100 MEMBER NAME (MEMBNAME)......................................N/P
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).....................180
ROUTINE AUTHORIZATION CACHE SIZE (CACHERAC)...........5,242,880 EXTENDED SECURITY (EXTSEC)..................................YES
AUTH EXIT CHECK (AUTHEXIT_CHECK)........................PRIMARY USER ID AND PASSWORD REQUIRED...............................N/A
AUTH EXIT CACHE REFRESH (AUTHEXIT_CACHEREFRESH)............NONE SQL INTERRUPT PROCESSING DISABLED (SQLINTRP).................NO
SYSTEM ADMINISTRATOR 1 AUTHORIZATION ID (SYSADM)........DB2SYSP PRIVATE PROTOCOL (PRIVATE_PROTOCOL)..........................NO
SYSTEM ADMINISTRATOR 2 AUTHORIZATION ID (SYSADM2)........CSMARK
SYSTEM OPERATOR 1 AUTHORIZATION ID (SYSOPR1).............CSMARK LOCK ESCALATION PARAMETERS (DSNTIPJ)
SYSTEM OPERATOR 2 AUTHORIZATION ID (SYSOPR2)..............TSSAL ------------------------------------
DEFAULT (UNKNOWN) USER AUTHORIZATION ID (DEFLTID).......IBMUSER MAX PAGE OR ROW LOCKS PER TABLE SPACE (NUMLKTS)...........1,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)...................................YES LOG INSTALLATION PARAMETERS (DSNTIPL,DSNTIPH)
---------------------------------------------
DATA DEFINITION CONTROL SUPPORT (DSNTIPZ) OUTPUT BUFFER SIZE IN K BYTES (OUTBUFF).....................400
----------------------------------------- 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)........................1,000,000
UNREGISTERED DDL DEFAULT (RGFDEFLT)......................ACCEPT UR CHECK FREQUENCY (URCHKTH)..................................5
REGISTER TABLE OWNER (RGFCOLID)........................DSNRGCOL UR LOG RECORD WRITTEN THRESHOLD IN KB (URLGWTH)...............5
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)..............................5
ESCAPE CHARACTER (RGFESCP)................................X'40' PSEUDO-CLOSE TIMER (PCLOSET).................................60
CHECKPOINTS BETWEEN LEVEL ID UPDATES (DLDFREQ)................5
DB2 VERSION INSTALL (DSNTIPA1) NUMBER OF ACTIVE LOG COPIES (TWOACTV).........................2
------------------------------ NUMBER OF ARCHIVE LOG COPIES (TWOARCH)........................1
DATA SHARING ENABLED (DSHARE)................................NO COPY 1 PREFIX (ARCPFX1)...........................OC1A.ARCHLOG1
CURRENT DB2 RELEASE (NEWFUN)................................N/A COPY 2 PREFIX (ARCPFX2).................................DSNARC2
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
1 LOCATION: RS25OC1A OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 2-3
GROUP: N/P SYSTEM PARAMETERS REPORT
MEMBER: N/P
SUBSYSTEM: OC1A ACTUAL FROM: 02/27/19 13:50:03.58
DB2 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)..........................................USA
DEFAULT MIXED GRAPHIC (MIXED)................................NO TIME FORMAT (TIME)..........................................ISO
EBCDIC SBCS CCSID (SCCSID)...................................37 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)..................................437 STD SQL LANGUAGE (STDSQL)....................................NO
ASCII MBCS CCSID (AMCCSID)..................................N/P PAD NULL-TERMINATED (PADNTSTR)..............................YES
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 OC1A.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)...............BASIC 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)...................................15
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)............................YES
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)..................................255
DEFINE DATA SETS (IMPDSDEF).................................YES TIMEOUT VALUE (STORTIME)......................................5
USE DATA COMPRESSION (IMPTSCMP)..............................NO WLM ENVIRONMENT (WLMENV)...............................OC1AWLM1
LIMIT KEY CONV PART TAB (IX_TB_PART_CONV_EXCLUDE)............NO 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)..........NO
DDL MATERIALIZATION (DDL_MATERIALIZATION)......ALWAYS_IMMEDIATE
DEFAULT INSERT ALGORITHM (DEFAULT_INSERT_ALGORITHM)...........2
1 LOCATION: RS25OC1A OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 2-4
GROUP: N/P SYSTEM PARAMETERS REPORT
MEMBER: N/P
SUBSYSTEM: OC1A ACTUAL FROM: 02/27/19 13:50:03.58
DB2 VERSION: V12
PERFORMANCE AND OPTIMIZATION (DSNTIP8,DSNTIP81) BUFFER POOL PARAMETERS (DSNTIP1)
----------------------------------------------- --------------------------------
CACHE DYNAMIC SQL (CACHEDYN)................................YES DEFAULT 4-KB BUFFER POOL FOR USER DATA (TBSBPOOL)..........BP0
CACHE DYN STABILITY (CACHEDYN_STABILIZATION)...............BOTH DEFAULT 8-KB BUFFER POOL FOR USER DATA (TBSBP8K).........BP8K0
OPTIMIZATION HINTS ALLOWED (OPTHINTS)........................NO DEFAULT 16-KB BUFFER POOL FOR USER DATA (TBSBP16K).......BP16K0
EVALUATE UNCOMMITTED (EVALUNC)...............................NO DEFAULT 32-KB BUFFER POOL FOR USER DATA (TBSBP32K)........BP32K
SKIP UNCOMM INSERTS (SKIPUNCI)...............................NO DEFAULT BUFFER POOL FOR USER LOB DATA (TBSBPLOB)............BP0
IMMEDWRITE OVERRIDE FLAG (IMMEDWRI)..........................NO DEFAULT BUFFER POOL FOR USER XML DATA (TBSBPXML).........BP16K0
REBIND PLANMGMT DEFAULT (PLANMGMT)..........................OFF DEFAULT BUFFER POOL FOR USER INDEXES (IDXBPOOL).............BP0
PLANMGMTSCOPE DEFAULT (PLANMGMTSCOPE)....................STATIC
PACKAGE RELEASE COMMIT (PKGREL_COMMIT)......................YES QUERY ACCELERATOR PREFERENCES (DSNTIP82)
RANDOMIZE XML DOCID (XML_RANDOMIZE_DOCID)....................NO ----------------------------------------
DISABLE EDM RTS (DISABLE_EDMRTS).............................NO ACCELERATOR STARTUP OPTION (ACCEL)......................COMMAND
CURRENT DEGREE (CDSSRDEF)...................................ANY GET ACCEL ARCHIVE (GET_ACCEL_ARCHIVE)........................NO
MAX DEGREE OF PARALLELISM (PARAMDEG)..........................0 ACCELERATION OPTIONS (QUERY_ACCEL_OPTIONS)..........(1,2,3,5,6)
MAX DEGREE FOR DPSI (PARAMDEG_DPSI)...........................0 CURRENT QUERY ACCEL (QUERY_ACCELERATION).................ENABLE
PARALLELISM EFFICIENCY (PARA_EFF)............................50 ACCELERATION MODELING (ACCELMODEL)...........................NO
STAR JOIN ENABLING (STARJOIN) ..........................DISABLE REMOTE COPY SW ACCEL (REMOTE_COPY_SW_ACCEL)..................NO
MAX DATA CACHING IN MB (MXDTCACH)............................20 HTAP WAIT INTERVAL (QUERY_ACCEL_WAITFORDATA)................0.0
CURRENT REFRESH AGE (REFSHAGE)................................0
CURRENT MAINT TYPE (MAINTYPE)............................SYSTEM WORKFILE DATABASE PANEL (DSNTIP91)
STATS PROFILE FEEDBACK (STATFDBK_PROFILE)...................YES ----------------------------------
MAX TEMP STORAGE PER AGENT IN MB (MAXTEMPS)...................0
OTHER SYSTEM PARAMETERS SEPARATE WORK FILES (WFDBSEP)................................NO
----------------------- MAX TEMP RID (MAXTEMPS_RID).............................NOLIMIT
DUAL BSDS MODE (TWOBSDS)....................................YES AGENT LEVEL THRESHOLD (WFSTGUSE_AGENT_THRESHOLD)..............0
ROLL UP PARALLEL TASK ACCOUNTING (PTASKROL).................YES SYSTEM LEVEL THRESHOLD (WFSTGUSE_SYSTEM_THRESHOLD)...........90
NO. PAGES SMALL TABLE THRESHOLD (NPGTHRSH)....................0
OFFLOAD OPTION (OFFLOAD)....................................YES DB2 UTILITIES PARAMETERS (DSNTIP6,DSNTIP61,DSNTIP62)
SU CONVERSION FACTOR........................................200 ----------------------------------------------------
MINIMUM DIVIDE SCALE (MINDVSCL)............................NONE TEMPORARY UNIT NAME (VOLTDEVT)............................SYSDA
STAR JOIN THRESHOLD (SJTABLES)...............................10 UTIL TEMP STORCLAS (UTIL_TEMP_STORCLAS).....................N/P
ONLINE SYSTEM PARM USER ID MONITOR..........................N/P STATISTICS HISTORY (STATHIST)...............................ALL
ONLINE SYSTEM PARM CORREL ID MONITOR........................N/P STATISTICS ROLLUP (STATROLL)................................YES
ONLINE SYSTEM PARM TIME CHANGED.............................N/P UTILITY TIMEOUT FACTOR (UTIMOUT)..............................6
ONLINE SYSTEM PARM TYPE.....................................N/P UT SORT DATA SET ALLOCATION (UTSORTAL)......................N/A
DB2-SUPPLIED DECP INDICATOR...............................X'D5' IGNORE SORTNUM STMT (IGNSORTN)...............................NO
MAX CONCURRENT PKG OPS (MAX_CONCURRENT_PKG_OPS)..............10 SET CHECK PENDING (CHECK_SETCHKP)...........................N/A
ADMIN SCHEDULER JCL PROC NAME (ADMTPROC)....................N/P UT DB2 SORT USE (DB2SORT)...................................N/A
FREE LOCAL CACHED STATEMENTS (CACHEDYN_FREELOCAL)...........N/A TEMPLATE TIME (TEMPLATE_TIME)...............................UTC
INDEX I/O PARALLELISM (INDEX_IO_PARALLELISM)................N/A MAXIMUM DEGREE OF UTILITY PARALLELISM (PARAMDEG_UTIL)........99
ZOSMETRICS...................................................NO FAST REPLICATION (CHECK_FASTREPLICATION)..............PREFERRED
USE TRACKMOD FOR IMPLICIT TS (IMPTKMOD).....................YES FAST RESTORE (REC_FASTREPLICATION)....................PREFERRED
DSSIZE FOR IMPLICIT TS (IMPDSSIZE)............................4 COPY FAST REPLICATION (COPY_FASTREPLICATION)..........PREFERRED
ENABLE MULTIPLE INDEX ACCESS (SUBQ_MIDX)....................YES FLASHCOPY PPRC (FLASHCOPY_PPRC)........................REQUIRED
SP_PARMS_JV (DDF_COMPATIBILITY)..............................NO DEFAULT TEMPLATE (FCCOPYDDN)...................................
SP_PARMS_NJV (DDF_COMPATIBILITY).............................NO OC1A.&DB..&SN..N&DS..D&JU..T&TI.
DISABLE_IMPCAST_JV (DDF_COMPATIBILITY).......................NO FLASHCOPY COPY (FLASHCOPY_COPY)..............................NO
DISABLE_IMPCAST_NJV (DDF_COMPATIBILITY)......................NO FLASHCOPY LOAD (FLASHCOPY_LOAD)..............................NO
IGNORE_TZ (DDF_COMPATIBILITY)................................NO FLASHCOPY REORG TABLESPACE (FLASHCOPY_REORG_TS)..............NO
DDF COMP PRIOR VERSION (DDF_COMPATIBILITY)..................N/P FLASHCOPY REBUILD INDEX (FLASHCOPY_REBUILD_INDEX)............NO
1 LOCATION: RS25OC1A OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 2-5
GROUP: N/P SYSTEM PARAMETERS REPORT
MEMBER: N/P
SUBSYSTEM: OC1A ACTUAL FROM: 02/27/19 13:50:03.58
DB2 VERSION: V12
DYN STMT CACHE STOR (CACHE_DEP_TRACK_STOR_LIM)..............N/A FLASHCOPY REORG INDEX (FLASHCOPY_REORG_INDEX)................NO
ACTIVATE I/O SCHEDULING.....................................YES SYSTEM-LEVEL BACKUPS (SYSTEM_LEVEL_BACKUPS)..................NO
VALUE FOR TRIGGER DRAIN.......................................1 RESTORE/RECOVER (RESTORE_RECOVER_FROMDUMP)...................NO
MAX NUMBER OF DDS WITH HOLD...................................3 DUMP CLASS NAME (UTILS_DUMP_CLASS_NAME).................'BLANK'
FIELD PROCS FOR DESCRIBE TABLE BLOCK..........................5 MAXIMUM TAPE UNITS (RESTORE_TAPEUNITS)........................0
RESTRICT ALTER COLUMN FOR DCC (RESTRICT_ALT_COL_FOR_DCC).....NO REORG PART SORT NPSI (REORG_PART_SORT_NPSI)................AUTO
SPACE RESERVED FOR Z/OS FUNCTIONS........................40,960 REORG LIST PROCESSING (REORG_LIST_PROCESSING)..........PARALLEL
SPACE RESERVED FOR CRITICAL WORK.....................26,279,936 REORG MAPPING DATABASE (REORG_MAPPING_DATABASE).............N/P
SPACE RESERVED ON TOP OF Z/OS AND CRITICAL SPACE.....26,279,936 REORG DROP PBG PARTS (REORG_DROP_PBG_PARTS)..................NO
DETAILED MEASURED UNIT PRICE TRACKING........................NO REORG IGNORE FREESPACE (REORG_IGNORE_FREESPACE).............N/A
OTC LICENSE TERMS ACCEPTED...................................NO ALTERNATE COPYPOOL (ALTERNATE_CP)...........................N/P
SIMULATED CPUS................................................0 DB BACKUP STG GROUP (UTIL_DBBSG)............................N/P
CPU FOR EXPLAIN STATEMENTS (CPU_FOR_EXPLAIN)..................2 LOG BACKUP STG GROUP (UTIL_LGBSG)...........................N/P
MAX 'NOT FOUND' HASH RECORDS................................100 HSM MESSAGE DS HLQ (UTILS_HSM_MSGDS_HLQ)....................N/P
MAX EXTEND SERVICE TASKS.....................................20
PROJECT Z INSERTION THRESHOLD.................................2 DATABASES AND SPACES STARTED AUTOMATICALLY (DSNTIPS)
MAX ZIVLEMPEL DICTIONARY ENTRIES..........................4,096 ----------------------------------------------------
REORG KEEPDICTIONARY IN BRF TO RRF CONVERSION...............YES ALL
DRDA RESOLVE ALIAS (DRDA_RESOLVE_ALIAS).....................YES
PC YES SPECIFIED............................................YES ICF CATALOG QUALIFIERS
BLOCK OPT 1 ROW SORT (OPT1ROWBLOCKSORT)......................NO ----------------------
EMPTY XML ELEMENT (XML_RESTRICT_EMPTY_TAG)...................NO OC1A
SUPPRESS_HINT_SQLCODE_DYN (SUPPRESS_HINT_SQLCODE_DYN) .......NO
INDEX MEMORY CONTROL (INDEX_MEMORY_CONTROL)................AUTO SIZES PANEL 1 (DSNTIPD)
SELECT FOR UNLOAD (AUTH_COMPATIBILITY).......................NO -----------------------
MATERIALIZE NODET SQLTUDF (MATERIALIZE_NODET_SQLTUDF)........NO LOB INLINE LENGTH (LOB_INLINE_LENGTH)........................25
ENCRYPTION_KEYLABEL (ENCRYPTION_KEYLBL)........................ USER LOB VALUE STORAGE IN KB (LOBVALA)......................N/A
DB2SYS.KEY01 SYSTEM LOB VALUE STORAGE IN MB (LOBVALS).................51,200
USER XML VALUE STG IN KB (XMLVALA)..........................N/A
DEFAULT STARTUP MODULES (DSNTIPO3) SYSTEM XML VAL STG IN MB (XMLVALS).......................51,200
----------------------------------
PARAMETER MODULE.......................................OC1APARM PROTECTION PANEL (DSNTIPP1)
ACCESS CONTROL (ACCESS_CNTL_MODULE)....................DSNX@XAC ---------------------------
IDENTIFY/AUTH (IDAUTH_MODULE)..........................DSN3@ATH SECURITY ADMINISTRATOR 1 AUTHORIZATION ID (SECADM1)......SECADM
SIGNON (SIGNON_MODULE).................................DSN3@SGN SECURITY ADMINISTRATOR 1 TYPE (SECADM1_TYPE).............AUTHID
SECURITY ADMINISTRATOR 2 AUTHORIZATION ID (SECADM2)......SECADM
INSTALL DB2 - RESOURCE LIMIT FACILITY (DSNTIPO4) SECURITY ADMINISTRATOR 2 TYPE (SECADM2_TYPE).............AUTHID
------------------------------------------------ SEPARATE SECURITY DUTIES (SEPARATE_SECURITY).................NO
RESOURCE LIMIT FACILITY AUTOMATIC START (RLF)................NO INCLUDE DEPENDENT PRIVILEGES (REVOKE_DEP_PRIVILEGES).........NO
RESOURCE LIMIT SPECIFICATION TABLE SUFFIX (RLFTBL)...........01
RESOURCE LIMIT DYNAMIC ERROR ACTION (RLFERR)............NOLIMIT DB2 CATALOG AND DIRECTORY PANEL (DSNTIPA2)
RESOURCE LIMIT STATIC ERROR ACTION (RLFERRSTC)..........NOLIMIT ------------------------------------------
RLF REMOTE DYNAMIC ERROR ACTION (RLFERRD)...............NOLIMIT SMS DATA CLASS FOR CATALOG DATA (CATDDACL)..................N/P
RLF REMOTE STATIC ERROR ACTION (RLFERRDSTC).............NOLIMIT SMS MANAGEMENT CLASS FOR CATALOG DATA (CATDMGCL)............N/P
RLF SCOPE (RLFENABLE)...................................DYNAMIC SMS STORAGE CLASS FOR CATALOG DATA (CATDSTCL)...............N/P
SMS DATA CLASS FOR CATALOG INDEX DATA (CATXDACL)............N/P
DATA PARAMETERS PANEL (DSNTIPA3) SMS MANAGEMENT CLASS FOR CATALOG INDEX DATA (CATXMGCL)......N/P
-------------------------------- SMS STORAGE CLASS FOR CATALOG INDEX DATA (CATXSTCL).........N/P
ZHYPERLINKS SCOPE (ZHYPERLINK)..........................DISABLE COMPRESS SPT01 (COMPRESS_SPT01)..............................NO
SPT01 INLINE LENGTH (SPT01_INLINE_LENGTH)....................-1
1 LOCATION: RS25OC1A OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 2-6
GROUP: N/P SYSTEM PARAMETERS REPORT
MEMBER: N/P
SUBSYSTEM: OC1A ACTUAL FROM: 02/27/19 13:50:03.58
DB2 VERSION: V12
BUFFER POOL PARAMETERS
--------------------------------------------------------------------------------------------------------------
TIMESTAMP 02/27/19 13:50:03.58 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 4K
VPOOL SIZE MIN 0
VPOOL SIZE MAX 0
SIM POOL SIZE 0
SIM POOL SEQ THRESH 0
TIMESTAMP 02/27/19 13:50:03.58 VPOOL SIZE (PAGES) 200
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 02/27/19 13:50:03.58 VPOOL SIZE (PAGES) 100
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
1 LOCATION: RS25OC1A OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 2-7
GROUP: N/P SYSTEM PARAMETERS REPORT
MEMBER: N/P
SUBSYSTEM: OC1A ACTUAL FROM: 02/27/19 13:50:03.58
DB2 VERSION: V12
BUFFER POOL PARAMETERS
--------------------------------------------------------------------------------------------------------------
TIMESTAMP 02/27/19 13:50:03.58 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 02/27/19 13:50:03.58 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 02/27/19 13:50:03.58 VPOOL SIZE (PAGES) 100
BUFFER POOL ID BP5 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
1 LOCATION: RS25OC1A OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 2-8
GROUP: N/P SYSTEM PARAMETERS REPORT
MEMBER: N/P
SUBSYSTEM: OC1A ACTUAL FROM: 02/27/19 13:50:03.58
DB2 VERSION: V12
BUFFER POOL PARAMETERS
--------------------------------------------------------------------------------------------------------------
TIMESTAMP 02/27/19 13:50:03.58 VPOOL SIZE (PAGES) 100
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 0
VPOOL SIZE MAX 0
SIM POOL SIZE 0
SIM POOL SEQ THRESH 0
TIMESTAMP 02/27/19 13:50:03.58 VPOOL SIZE (PAGES) 100
BUFFER POOL ID BP12 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 02/27/19 13:50:03.58 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 4K
VPOOL SIZE MIN 0
VPOOL SIZE MAX 0
SIM POOL SIZE 0
SIM POOL SEQ THRESH 0
1 LOCATION: RS25OC1A OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 2-9
GROUP: N/P SYSTEM PARAMETERS REPORT
MEMBER: N/P
SUBSYSTEM: OC1A ACTUAL FROM: 02/27/19 13:50:03.58
DB2 VERSION: V12
BUFFER POOL PARAMETERS
--------------------------------------------------------------------------------------------------------------
TIMESTAMP 02/27/19 13:50:03.58 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 4K
VPOOL SIZE MIN 0
VPOOL SIZE MAX 0
SIM POOL SIZE 0
SIM POOL SEQ THRESH 0
TIMESTAMP 02/27/19 13:50:03.58 VPOOL SIZE (PAGES) 200
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 02/27/19 13:50:03.58 VPOOL SIZE (PAGES) 1000
BUFFER POOL ID BP31 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
1 LOCATION: RS25OC1A OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 2-10
GROUP: N/P SYSTEM PARAMETERS REPORT
MEMBER: N/P
SUBSYSTEM: OC1A ACTUAL FROM: 02/27/19 13:50:03.58
DB2 VERSION: V12
BUFFER POOL PARAMETERS
--------------------------------------------------------------------------------------------------------------
TIMESTAMP 02/27/19 13:50:03.58 VPOOL SIZE (PAGES) 1000
BUFFER POOL ID BP32 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 02/27/19 13:50:03.58 VPOOL SIZE (PAGES) 1000
BUFFER POOL ID BP33 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 02/27/19 13:50:03.58 VPOOL SIZE (PAGES) 1000
BUFFER POOL ID BP34 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
1 LOCATION: RS25OC1A OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 2-11
GROUP: N/P SYSTEM PARAMETERS REPORT
MEMBER: N/P
SUBSYSTEM: OC1A ACTUAL FROM: 02/27/19 13:50:03.58
DB2 VERSION: V12
BUFFER POOL PARAMETERS
--------------------------------------------------------------------------------------------------------------
TIMESTAMP 02/27/19 13:50:03.58 VPOOL SIZE (PAGES) 1000
BUFFER POOL ID BP35 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 02/27/19 13:50:03.58 VPOOL SIZE (PAGES) 1000
BUFFER POOL ID BP36 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 02/27/19 13:50:03.58 VPOOL SIZE (PAGES) 1000
BUFFER POOL ID BP37 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
1 LOCATION: RS25OC1A OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 2-12
GROUP: N/P SYSTEM PARAMETERS REPORT
MEMBER: N/P
SUBSYSTEM: OC1A ACTUAL FROM: 02/27/19 13:50:03.58
DB2 VERSION: V12
BUFFER POOL PARAMETERS
--------------------------------------------------------------------------------------------------------------
TIMESTAMP 02/27/19 13:50:03.58 VPOOL SIZE (PAGES) 1000
BUFFER POOL ID BP38 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 02/27/19 13:50:03.58 VPOOL SIZE (PAGES) 1000
BUFFER POOL ID BP39 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 02/27/19 13:50:03.58 VPOOL SIZE (PAGES) 250
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
1 LOCATION: RS25OC1A OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 2-13
GROUP: N/P SYSTEM PARAMETERS REPORT
MEMBER: N/P
SUBSYSTEM: OC1A ACTUAL FROM: 02/27/19 13:50:03.58
DB2 VERSION: V12
BUFFER POOL PARAMETERS
--------------------------------------------------------------------------------------------------------------
TIMESTAMP 02/27/19 13:50:03.58 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 4K
VPOOL SIZE MIN 0
VPOOL SIZE MAX 0
SIM POOL SIZE 0
SIM POOL SEQ THRESH 0
TIMESTAMP 02/27/19 13:50:03.58 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 4K
VPOOL SIZE MIN 0
VPOOL SIZE MAX 0
SIM POOL SIZE 0
SIM POOL SEQ THRESH 0
TIMESTAMP 02/27/19 13:50:03.58 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 4K
VPOOL SIZE MIN 0
VPOOL SIZE MAX 0
SIM POOL SIZE 0
SIM POOL SEQ THRESH 0
1 LOCATION: RS25OC1A OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 2-14
GROUP: N/P SYSTEM PARAMETERS REPORT
MEMBER: N/P
SUBSYSTEM: OC1A ACTUAL FROM: 02/27/19 13:50:03.58
DB2 VERSION: V12
BUFFER POOL PARAMETERS
--------------------------------------------------------------------------------------------------------------
TIMESTAMP 02/27/19 13:50:03.58 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 4K
VPOOL SIZE MIN 0
VPOOL SIZE MAX 0
SIM POOL SIZE 0
SIM POOL SEQ THRESH 0
TIMESTAMP 02/27/19 13:50:03.58 VPOOL SIZE (PAGES) 500
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
1 LOCATION: RS25OC1A OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 2-15
GROUP: N/P SYSTEM PARAMETERS REPORT
MEMBER: N/P
SUBSYSTEM: OC1A ACTUAL FROM: 02/27/19 14:00:00.36
DB2 VERSION: V12
-
MVS PARMLIB UPDATE PARAMETERS (DSNTIPM) IRLM INSTALLATION PARAMETERS (DSNTIPI)
--------------------------------------- --------------------------------------
SUBSYSTEM DEFAULT (SSID)...................................OC1A IRLM SUBSYSTEM NAME (IRLMSID)..............................IR1C
SUPPRESS SOFT ERRORS (SUPERRS)..............................YES IRLM RESOURCE TIMEOUT IN SECONDS (IRLMRWT)...................30
IRLM AUTOMATIC START (IRLMAUT)..............................YES
STORAGE SIZES INSTALLATION PARMS (DSNTIPC,DSNTIPE,DSNTIPE1) IRLM START PROCEDURE NAME (IRLMPRC)....................OC1AIRLM
--------------------------------------------------------------- SECONDS DB2 WILL WAIT FOR IRLM START (IRLMSWT)..............300
MAX NO OF DATA SETS CONCURRENTLY IN USE (DSMAX)...........3,000 U LOCK FOR REPEATABLE READ OR READ STABILITY (RRULOCK)......YES
EDM STATEMENT CACHE SIZE IN KB (EDMSTMTC)................56,693 X LOCK FOR SEARCHED UPDATE/DELETE (XLKUPDLT).................NO
EDM DBD CACHE SIZE IN KB (EDMDBDC).......................11,700 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).................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)..................8,000
MAX NO OF USERS CONCURRENTLY RUNNING IN DB2 (CTHREAD).......200 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..............................1,000
MAX NO OF TSO CONNECTIONS (IDFORE)...........................50 NUMBER OF LOCAL CYCLES PER GLOBAL CYCLE.......................1
MAX NO OF BATCH CONNECTIONS (IDBACK).........................50 TIMEOUT INTERVAL.............................................30
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).......................3390
------------------------------------------------------- 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)............................25
TRACE TABLE SIZE IN 4K BYTES (TRACTBL).......................16 SECONDARY SPACE ALLOCATION (SECQTY)..........................25
LOCAL TRACE TABLE SIZE IN 4K BYTES (TRACLOC).................16 ARCHIVE LOG BLOCK SIZE IN BYTES (BLKSIZE)................24,576
START SMF ACCOUNTING (SMFACCT)............................1,2,3 MAXIMUM READ TAPE UNITS (MAXRTU)..............................2
START SMF STATISTICS (SMFSTAT)............................1,3,4 TAPE UNIT DEALLOCATION PERIOD (DEALLCT).................0000:00
STATISTICS TIME INTERVAL IN MINUTES (STATIME)................30 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)....................................NO DAYS TO RETAIN ARCHIVE LOG DATA SETS (ARCRETN)................0
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).....................................YES
COMPRESS SMF RECS (SMFCOMP).................................OFF
1 LOCATION: RS25OC1A OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 2-16
GROUP: N/P SYSTEM PARAMETERS REPORT
MEMBER: N/P
SUBSYSTEM: OC1A ACTUAL FROM: 02/27/19 14:00:00.36
DB2 VERSION: V12
-
DISTRIBUTED DATA FACILITY PANEL 2 (DSNTIP5) DEFINE GROUP OR MEMBER (DSNTIPK)
------------------------------------------- --------------------------------
TCP/IP ALREADY VERIFIED (TCPALVER)..........................YES GROUP NAME (GRPNAME)........................................N/P
EXTRA BLOCKS REQ (EXTRAREQ).................................100 MEMBER NAME (MEMBNAME)......................................N/P
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).....................180
ROUTINE AUTHORIZATION CACHE SIZE (CACHERAC)...........5,242,880 EXTENDED SECURITY (EXTSEC)..................................YES
AUTH EXIT CHECK (AUTHEXIT_CHECK)........................PRIMARY USER ID AND PASSWORD REQUIRED...............................N/A
AUTH EXIT CACHE REFRESH (AUTHEXIT_CACHEREFRESH)............NONE SQL INTERRUPT PROCESSING DISABLED (SQLINTRP).................NO
SYSTEM ADMINISTRATOR 1 AUTHORIZATION ID (SYSADM)........DB2SYSP PRIVATE PROTOCOL (PRIVATE_PROTOCOL)..........................NO
SYSTEM ADMINISTRATOR 2 AUTHORIZATION ID (SYSADM2)........CSMARK
SYSTEM OPERATOR 1 AUTHORIZATION ID (SYSOPR1).............CSMARK LOCK ESCALATION PARAMETERS (DSNTIPJ)
SYSTEM OPERATOR 2 AUTHORIZATION ID (SYSOPR2)..............TSSAL ------------------------------------
DEFAULT (UNKNOWN) USER AUTHORIZATION ID (DEFLTID).......IBMUSER MAX PAGE OR ROW LOCKS PER TABLE SPACE (NUMLKTS)...........1,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)...................................YES LOG INSTALLATION PARAMETERS (DSNTIPL,DSNTIPH)
---------------------------------------------
DATA DEFINITION CONTROL SUPPORT (DSNTIPZ) OUTPUT BUFFER SIZE IN K BYTES (OUTBUFF).....................400
----------------------------------------- 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)........................1,000,000
UNREGISTERED DDL DEFAULT (RGFDEFLT)......................ACCEPT UR CHECK FREQUENCY (URCHKTH)..................................5
REGISTER TABLE OWNER (RGFCOLID)........................DSNRGCOL UR LOG RECORD WRITTEN THRESHOLD IN KB (URLGWTH)...............5
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)..............................5
ESCAPE CHARACTER (RGFESCP)................................X'40' PSEUDO-CLOSE TIMER (PCLOSET).................................60
CHECKPOINTS BETWEEN LEVEL ID UPDATES (DLDFREQ)................5
DB2 VERSION INSTALL (DSNTIPA1) NUMBER OF ACTIVE LOG COPIES (TWOACTV).........................2
------------------------------ NUMBER OF ARCHIVE LOG COPIES (TWOARCH)........................1
DATA SHARING ENABLED (DSHARE)................................NO COPY 1 PREFIX (ARCPFX1)...........................OC1A.ARCHLOG1
CURRENT DB2 RELEASE (NEWFUN)................................N/A COPY 2 PREFIX (ARCPFX2).................................DSNARC2
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
1 LOCATION: RS25OC1A OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 2-17
GROUP: N/P SYSTEM PARAMETERS REPORT
MEMBER: N/P
SUBSYSTEM: OC1A ACTUAL FROM: 02/27/19 14:00:00.36
DB2 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)..........................................USA
DEFAULT MIXED GRAPHIC (MIXED)................................NO TIME FORMAT (TIME)..........................................ISO
EBCDIC SBCS CCSID (SCCSID)...................................37 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)..................................437 STD SQL LANGUAGE (STDSQL)....................................NO
ASCII MBCS CCSID (AMCCSID)..................................N/P PAD NULL-TERMINATED (PADNTSTR)..............................YES
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 OC1A.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)...............BASIC 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)...................................15
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)............................YES
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)..................................255
DEFINE DATA SETS (IMPDSDEF).................................YES TIMEOUT VALUE (STORTIME)......................................5
USE DATA COMPRESSION (IMPTSCMP)..............................NO WLM ENVIRONMENT (WLMENV)...............................OC1AWLM1
LIMIT KEY CONV PART TAB (IX_TB_PART_CONV_EXCLUDE)............NO 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)..........NO
DDL MATERIALIZATION (DDL_MATERIALIZATION)......ALWAYS_IMMEDIATE
DEFAULT INSERT ALGORITHM (DEFAULT_INSERT_ALGORITHM)...........2
1 LOCATION: RS25OC1A OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 2-18
GROUP: N/P SYSTEM PARAMETERS REPORT
MEMBER: N/P
SUBSYSTEM: OC1A ACTUAL FROM: 02/27/19 14:00:00.36
DB2 VERSION: V12
PERFORMANCE AND OPTIMIZATION (DSNTIP8,DSNTIP81) BUFFER POOL PARAMETERS (DSNTIP1)
----------------------------------------------- --------------------------------
CACHE DYNAMIC SQL (CACHEDYN)................................YES DEFAULT 4-KB BUFFER POOL FOR USER DATA (TBSBPOOL)..........BP0
CACHE DYN STABILITY (CACHEDYN_STABILIZATION)...............BOTH DEFAULT 8-KB BUFFER POOL FOR USER DATA (TBSBP8K).........BP8K0
OPTIMIZATION HINTS ALLOWED (OPTHINTS)........................NO DEFAULT 16-KB BUFFER POOL FOR USER DATA (TBSBP16K).......BP16K0
EVALUATE UNCOMMITTED (EVALUNC)...............................NO DEFAULT 32-KB BUFFER POOL FOR USER DATA (TBSBP32K)........BP32K
SKIP UNCOMM INSERTS (SKIPUNCI)...............................NO DEFAULT BUFFER POOL FOR USER LOB DATA (TBSBPLOB)............BP0
IMMEDWRITE OVERRIDE FLAG (IMMEDWRI)..........................NO DEFAULT BUFFER POOL FOR USER XML DATA (TBSBPXML).........BP16K0
REBIND PLANMGMT DEFAULT (PLANMGMT)..........................OFF DEFAULT BUFFER POOL FOR USER INDEXES (IDXBPOOL).............BP0
PLANMGMTSCOPE DEFAULT (PLANMGMTSCOPE)....................STATIC
PACKAGE RELEASE COMMIT (PKGREL_COMMIT)......................YES QUERY ACCELERATOR PREFERENCES (DSNTIP82)
RANDOMIZE XML DOCID (XML_RANDOMIZE_DOCID)....................NO ----------------------------------------
DISABLE EDM RTS (DISABLE_EDMRTS).............................NO ACCELERATOR STARTUP OPTION (ACCEL)......................COMMAND
CURRENT DEGREE (CDSSRDEF)...................................ANY GET ACCEL ARCHIVE (GET_ACCEL_ARCHIVE)........................NO
MAX DEGREE OF PARALLELISM (PARAMDEG)..........................0 ACCELERATION OPTIONS (QUERY_ACCEL_OPTIONS)..........(1,2,3,5,6)
MAX DEGREE FOR DPSI (PARAMDEG_DPSI)...........................0 CURRENT QUERY ACCEL (QUERY_ACCELERATION).................ENABLE
PARALLELISM EFFICIENCY (PARA_EFF)............................50 ACCELERATION MODELING (ACCELMODEL)...........................NO
STAR JOIN ENABLING (STARJOIN) ..........................DISABLE REMOTE COPY SW ACCEL (REMOTE_COPY_SW_ACCEL)..................NO
MAX DATA CACHING IN MB (MXDTCACH)............................20 HTAP WAIT INTERVAL (QUERY_ACCEL_WAITFORDATA)................0.0
CURRENT REFRESH AGE (REFSHAGE)................................0
CURRENT MAINT TYPE (MAINTYPE)............................SYSTEM WORKFILE DATABASE PANEL (DSNTIP91)
STATS PROFILE FEEDBACK (STATFDBK_PROFILE)...................YES ----------------------------------
MAX TEMP STORAGE PER AGENT IN MB (MAXTEMPS)...................0
OTHER SYSTEM PARAMETERS SEPARATE WORK FILES (WFDBSEP)................................NO
----------------------- MAX TEMP RID (MAXTEMPS_RID).............................NOLIMIT
DUAL BSDS MODE (TWOBSDS)....................................YES AGENT LEVEL THRESHOLD (WFSTGUSE_AGENT_THRESHOLD)..............0
ROLL UP PARALLEL TASK ACCOUNTING (PTASKROL).................YES SYSTEM LEVEL THRESHOLD (WFSTGUSE_SYSTEM_THRESHOLD)...........90
NO. PAGES SMALL TABLE THRESHOLD (NPGTHRSH)....................0
OFFLOAD OPTION (OFFLOAD)....................................YES DB2 UTILITIES PARAMETERS (DSNTIP6,DSNTIP61,DSNTIP62)
SU CONVERSION FACTOR........................................200 ----------------------------------------------------
MINIMUM DIVIDE SCALE (MINDVSCL)............................NONE TEMPORARY UNIT NAME (VOLTDEVT)............................SYSDA
STAR JOIN THRESHOLD (SJTABLES)...............................10 UTIL TEMP STORCLAS (UTIL_TEMP_STORCLAS).....................N/P
ONLINE SYSTEM PARM USER ID MONITOR..........................N/P STATISTICS HISTORY (STATHIST)...............................ALL
ONLINE SYSTEM PARM CORREL ID MONITOR........................N/P STATISTICS ROLLUP (STATROLL)................................YES
ONLINE SYSTEM PARM TIME CHANGED.............................N/P UTILITY TIMEOUT FACTOR (UTIMOUT)..............................6
ONLINE SYSTEM PARM TYPE.....................................N/P UT SORT DATA SET ALLOCATION (UTSORTAL)......................N/A
DB2-SUPPLIED DECP INDICATOR...............................X'D5' IGNORE SORTNUM STMT (IGNSORTN)...............................NO
MAX CONCURRENT PKG OPS (MAX_CONCURRENT_PKG_OPS)..............10 SET CHECK PENDING (CHECK_SETCHKP)...........................N/A
ADMIN SCHEDULER JCL PROC NAME (ADMTPROC)....................N/P UT DB2 SORT USE (DB2SORT)...................................N/A
FREE LOCAL CACHED STATEMENTS (CACHEDYN_FREELOCAL)...........N/A TEMPLATE TIME (TEMPLATE_TIME)...............................UTC
INDEX I/O PARALLELISM (INDEX_IO_PARALLELISM)................N/A MAXIMUM DEGREE OF UTILITY PARALLELISM (PARAMDEG_UTIL)........99
ZOSMETRICS...................................................NO FAST REPLICATION (CHECK_FASTREPLICATION)..............PREFERRED
USE TRACKMOD FOR IMPLICIT TS (IMPTKMOD).....................YES FAST RESTORE (REC_FASTREPLICATION)....................PREFERRED
DSSIZE FOR IMPLICIT TS (IMPDSSIZE)............................4 COPY FAST REPLICATION (COPY_FASTREPLICATION)..........PREFERRED
ENABLE MULTIPLE INDEX ACCESS (SUBQ_MIDX)....................YES FLASHCOPY PPRC (FLASHCOPY_PPRC)........................REQUIRED
SP_PARMS_JV (DDF_COMPATIBILITY)..............................NO DEFAULT TEMPLATE (FCCOPYDDN)...................................
SP_PARMS_NJV (DDF_COMPATIBILITY).............................NO OC1A.&DB..&SN..N&DS..D&JU..T&TI.
DISABLE_IMPCAST_JV (DDF_COMPATIBILITY).......................NO FLASHCOPY COPY (FLASHCOPY_COPY)..............................NO
DISABLE_IMPCAST_NJV (DDF_COMPATIBILITY)......................NO FLASHCOPY LOAD (FLASHCOPY_LOAD)..............................NO
IGNORE_TZ (DDF_COMPATIBILITY)................................NO FLASHCOPY REORG TABLESPACE (FLASHCOPY_REORG_TS)..............NO
DDF COMP PRIOR VERSION (DDF_COMPATIBILITY)..................N/P FLASHCOPY REBUILD INDEX (FLASHCOPY_REBUILD_INDEX)............NO
1 LOCATION: RS25OC1A OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 2-19
GROUP: N/P SYSTEM PARAMETERS REPORT
MEMBER: N/P
SUBSYSTEM: OC1A ACTUAL FROM: 02/27/19 14:00:00.36
DB2 VERSION: V12
DYN STMT CACHE STOR (CACHE_DEP_TRACK_STOR_LIM)..............N/A FLASHCOPY REORG INDEX (FLASHCOPY_REORG_INDEX)................NO
ACTIVATE I/O SCHEDULING.....................................YES SYSTEM-LEVEL BACKUPS (SYSTEM_LEVEL_BACKUPS)..................NO
VALUE FOR TRIGGER DRAIN.......................................1 RESTORE/RECOVER (RESTORE_RECOVER_FROMDUMP)...................NO
MAX NUMBER OF DDS WITH HOLD...................................3 DUMP CLASS NAME (UTILS_DUMP_CLASS_NAME).................'BLANK'
FIELD PROCS FOR DESCRIBE TABLE BLOCK..........................5 MAXIMUM TAPE UNITS (RESTORE_TAPEUNITS)........................0
RESTRICT ALTER COLUMN FOR DCC (RESTRICT_ALT_COL_FOR_DCC).....NO REORG PART SORT NPSI (REORG_PART_SORT_NPSI)................AUTO
SPACE RESERVED FOR Z/OS FUNCTIONS........................40,960 REORG LIST PROCESSING (REORG_LIST_PROCESSING)..........PARALLEL
SPACE RESERVED FOR CRITICAL WORK.....................26,279,936 REORG MAPPING DATABASE (REORG_MAPPING_DATABASE).............N/P
SPACE RESERVED ON TOP OF Z/OS AND CRITICAL SPACE.....26,279,936 REORG DROP PBG PARTS (REORG_DROP_PBG_PARTS)..................NO
DETAILED MEASURED UNIT PRICE TRACKING........................NO REORG IGNORE FREESPACE (REORG_IGNORE_FREESPACE).............N/A
OTC LICENSE TERMS ACCEPTED...................................NO ALTERNATE COPYPOOL (ALTERNATE_CP)...........................N/P
SIMULATED CPUS................................................0 DB BACKUP STG GROUP (UTIL_DBBSG)............................N/P
CPU FOR EXPLAIN STATEMENTS (CPU_FOR_EXPLAIN)..................3 LOG BACKUP STG GROUP (UTIL_LGBSG)...........................N/P
MAX 'NOT FOUND' HASH RECORDS................................100 HSM MESSAGE DS HLQ (UTILS_HSM_MSGDS_HLQ)....................N/P
MAX EXTEND SERVICE TASKS.....................................20
PROJECT Z INSERTION THRESHOLD.................................2 DATABASES AND SPACES STARTED AUTOMATICALLY (DSNTIPS)
MAX ZIVLEMPEL DICTIONARY ENTRIES..........................4,096 ----------------------------------------------------
REORG KEEPDICTIONARY IN BRF TO RRF CONVERSION...............YES ALL
DRDA RESOLVE ALIAS (DRDA_RESOLVE_ALIAS).....................YES
PC YES SPECIFIED............................................YES ICF CATALOG QUALIFIERS
BLOCK OPT 1 ROW SORT (OPT1ROWBLOCKSORT)......................NO ----------------------
EMPTY XML ELEMENT (XML_RESTRICT_EMPTY_TAG)...................NO OC1A
SUPPRESS_HINT_SQLCODE_DYN (SUPPRESS_HINT_SQLCODE_DYN) .......NO
INDEX MEMORY CONTROL (INDEX_MEMORY_CONTROL)................AUTO SIZES PANEL 1 (DSNTIPD)
SELECT FOR UNLOAD (AUTH_COMPATIBILITY).......................NO -----------------------
MATERIALIZE NODET SQLTUDF (MATERIALIZE_NODET_SQLTUDF)........NO LOB INLINE LENGTH (LOB_INLINE_LENGTH)........................25
ENCRYPTION_KEYLABEL (ENCRYPTION_KEYLBL)........................ USER LOB VALUE STORAGE IN KB (LOBVALA)......................N/A
DB2SYS.KEY01 SYSTEM LOB VALUE STORAGE IN MB (LOBVALS).................51,200
USER XML VALUE STG IN KB (XMLVALA)..........................N/A
DEFAULT STARTUP MODULES (DSNTIPO3) SYSTEM XML VAL STG IN MB (XMLVALS).......................51,200
----------------------------------
PARAMETER MODULE.......................................OC1APARM PROTECTION PANEL (DSNTIPP1)
ACCESS CONTROL (ACCESS_CNTL_MODULE)....................DSNX@XAC ---------------------------
IDENTIFY/AUTH (IDAUTH_MODULE)..........................DSN3@ATH SECURITY ADMINISTRATOR 1 AUTHORIZATION ID (SECADM1)......SECADM
SIGNON (SIGNON_MODULE).................................DSN3@SGN SECURITY ADMINISTRATOR 1 TYPE (SECADM1_TYPE).............AUTHID
SECURITY ADMINISTRATOR 2 AUTHORIZATION ID (SECADM2)......SECADM
INSTALL DB2 - RESOURCE LIMIT FACILITY (DSNTIPO4) SECURITY ADMINISTRATOR 2 TYPE (SECADM2_TYPE).............AUTHID
------------------------------------------------ SEPARATE SECURITY DUTIES (SEPARATE_SECURITY).................NO
RESOURCE LIMIT FACILITY AUTOMATIC START (RLF)................NO INCLUDE DEPENDENT PRIVILEGES (REVOKE_DEP_PRIVILEGES).........NO
RESOURCE LIMIT SPECIFICATION TABLE SUFFIX (RLFTBL)...........01
RESOURCE LIMIT DYNAMIC ERROR ACTION (RLFERR)............NOLIMIT DB2 CATALOG AND DIRECTORY PANEL (DSNTIPA2)
RESOURCE LIMIT STATIC ERROR ACTION (RLFERRSTC)..........NOLIMIT ------------------------------------------
RLF REMOTE DYNAMIC ERROR ACTION (RLFERRD)...............NOLIMIT SMS DATA CLASS FOR CATALOG DATA (CATDDACL)..................N/P
RLF REMOTE STATIC ERROR ACTION (RLFERRDSTC).............NOLIMIT SMS MANAGEMENT CLASS FOR CATALOG DATA (CATDMGCL)............N/P
RLF SCOPE (RLFENABLE)...................................DYNAMIC SMS STORAGE CLASS FOR CATALOG DATA (CATDSTCL)...............N/P
SMS DATA CLASS FOR CATALOG INDEX DATA (CATXDACL)............N/P
DATA PARAMETERS PANEL (DSNTIPA3) SMS MANAGEMENT CLASS FOR CATALOG INDEX DATA (CATXMGCL)......N/P
-------------------------------- SMS STORAGE CLASS FOR CATALOG INDEX DATA (CATXSTCL).........N/P
ZHYPERLINKS SCOPE (ZHYPERLINK)..........................DISABLE COMPRESS SPT01 (COMPRESS_SPT01)..............................NO
SPT01 INLINE LENGTH (SPT01_INLINE_LENGTH)....................-1