REXX procedure to call ADMIN_INFO_SYSPARM
REXX to call the IBM DB2-supplied stored procedure ADMIN_INFO_SYSPARM to access DB2 DSNZPARM parameters and writes them an output dataset. This make it easy to archive DB2 subsystem parameters or compare parameter sets of different DB2 subsystems.
See example output at end of page.
/*REXX****************************************************************/ /* DIS2INST ...: Display DB2 for z/OS installation parameters using */ /* IBM-supplied stored procedure ADMIN_INFO_SYSPARM */ /*-------------------------------------------------------------------*/ /* CALLED BY..: IKJEFT01 - TSO Batch oder Online */ /* ARGUMENTS..: SSID - Local/Home Subsystem */ /* CALLS......: DSNREXX M - DB2/REXX Interface */ /* XMPABND M - Abend U0001 (Non-ISPF) */ /*-------------------------------------------------------------------*/ /* COMMENTS...: Verify that SDSNLOAD ist part of LINKLIST or already */ /* allocated to TSO session. If not, you need to */ /* dynamically allocate. (See STEPLIBX in code below!) */ /*-------------------------------------------------------------------*/ /* FUNCTION...: Calls ADMIN_INFO_SYSPARM stored procedure to obtain */ /* DB2 system installation values. */ /*-------------------------------------------------------------------*/ /* HISTORY....: 06.04.11/G.Ruban - V1R0 */ /*********************************************************************/ x = MSG("OFF") /*********************************************************************/ /* process arguments passed to procedure */ /*********************************************************************/ parse upper arg arglist ver = "1.0" Numeric Digits 12 if pos("DEBUG",arglist)>0 then do debug = "DEBUG" TRACE ?I SQLTRACE = "TRACE" end /*********************************************************************/ /* Some environment information and initialzations */ /*********************************************************************/ PARSE SOURCE, source_host_env, source_call_type, source_uc_exec_name, source_hostdd, source_hostdsn, source_nf_exec_name, source_initial_cmd_env, source_asid_name jobnamestep = Get_Jobname() sysvar_sysuid = SYSVAR("SYSUID") sysvar_sysenv = SYSVAR("SYSENV") /*********************************************************************/ /* Header */ /*********************************************************************/ "CLRSCRN" say copies("#",79) say "# DIS2INST V"ver" - DSNHDECP DB2 for z/OS installation values", date("O")" "time()" #"; say copies("#",79) say "" /*********************************************************************/ /* Cechk required environment */ /*********************************************************************/ if (source_host_env ^= "TSO") then do Say "Wrong host environment" source_host_env signal error end parse var arglist ssid if debug = "DEBUG" then do i = pos("DEBUG",ssid) if i>0 then ssid = delstr(ssid,i,5) i = wordpos("DEBUG",CIRTERIA) if i>9 then CRITERIA = delword(CRITERIA,i,1) end if ssid = "" ! ssid = "DEBUG" then do say "Executing without arguments,", "setting default DB2 subsystem id and criteria." ssid = "DB2T" CRITERIA = "DBNAME LIKE 'DSN%'", /* WHERE CLAUSE 4096 */ "AND NAME LIKE '%'" end CRITERIA_IND = 0 /*********************************************************************/ /* If DB2 Load Library is not part of z/OS LINKLIST: */ /* Allocate SDSNLOAD using CA TSOPLUS (or any other which adds the */ /* DB2 load libray dynamically to the STEPLIB). */ /*********************************************************************/ address TSO "FREE FI(STEPLIBX) DA('SAMPLE."ssid".SDSNLOAD')" "ALLOC FI(STEPLIBX) DA('SAMPLE."ssid".SDSNLOAD') SHR REUSE" if rc <> 0 then do say "DB2 SDSNLOAD library for SSID="ssid" is not available!" say "Check z/OS LINKLIST or allocate to STEPLIB in advance!" signal error end ADDRESS TSO "SUBCOM DSNREXX" if rc <> 0 then do cc = RXSUBCOM("ADD","DSNREXX","DSNREXX") if cc then do say "DB2 SDSNLOAD library not available!" say "Check z/OS LINKLIST or allocate to STEPLIB in advance!" signal error end end /*********************************************************************/ /* StoProc in/out fields and corresponding stuff */ /*********************************************************************/ DB2_MEMBER = ""; DB2_MEMBER_IND = -1; RETURN_CODE = 0; RETURN_CODE_IND = -1; MSG = ""; MSG_IND = -1; /*********************************************************************/ /* call DB2 stored procedure */ /*********************************************************************/ sqlstmt = "CALL SYSPROC.ADMIN_INFO_SYSPARM ", "(:DB2_MEMBER :DB2_MEMBER_IND, " , " :RETURN_CODE :RETURN_CODE_IND, " , " :MSG :MSG_IND)"; ADDRESS DSNREXX "CONNECT" ssid call Code 0 address DSNREXX "EXECSQL" sqlstmt call Code 0 466 /* +466 = more rows to fetch */ if returncode = 0 then do say "DB2 for z/OS DSNHDECP values ..." say copies("-",79) end /*********************************************************************/ /* Associate locator with stored procedure */ /*********************************************************************/ LOC1 = d2x(0) sqlstmt = "ASSOCIATE LOCATORS (:LOC1)", "WITH PROCEDURE SYSPROC.ADMIN_INFO_SYSPARM" address DSNREXX "EXECSQL" sqlstmt; call code 0 /*********************************************************************/ /* Allocate and process cursor-driven */ /*********************************************************************/ sqlstmt = "ALLOCATE C101 CURSOR FOR RESULT SET :LOC1" address DSNREXX "EXECSQL" sqlstmt; call Code 0 /*********************************************************************/ /* Fetch all messages via the cursor */ /* ROWNUM Sequence number of the table row, from 1 to n. */ /* MACRO Macro that contains the system parameter, the DSNHDECP */ /* parameter, or the name of the IRLM procedure that z/OS */ /* invokes if IRLM is started automatically by DB2. */ /* PARAMETER Name of the system parameter, DSNHDECP parameter, or */ /* IRLM parameter. */ /* INSTALL_PANEL Name of the installation panel where the parameter */ /* value can be changed when installing or */ /* migrating DB2. */ /* INSTALL_FIELD Name of the parameter on the installation panel. */ /* INSTALL_LOCATION Location of the parameter on the installation */ /* panel. */ /* VALUE The value of the parameter. */ /* ADDITIONAL_INFO Reserved for future use. */ /*********************************************************************/ sqlstmt = "FETCH C101 INTO ", ":ROWNUM, :MACRO, :PARAMETER, ", ":INSTALL_PANEL :IND_INSTALL_PANEL, ", ":INSTALL_FIELD :IND_INSTALL_FIELD, ", ":INSTALL_LOCATION :IND_INSTALL_LOCATION, ", ":VALUE, ", ":ADDITIONAL_INFO :IND_ADDITIONAL_INFO "; do while sqlcode = 0 if IND_INSTALL_PANEL <> -1 then IPNL = INSTALL_PANEL else IPNL = "n/a" if IND_INSTALL_FIELD <> -1 then IFLD = INSTALL_FIELD else IFLD = "n/a" if IND_INSTALL_LOCATION<> -1 then ILOC = INSTALL_LOCATION else ILOC = "n/a" if IND_ADDITIONAL_INFO <> -1 then IADI = ADDITIONAL_INFO else IADI = "n/a" say left(macro,8)"!"left(parameter,24)"!" !!, left(IFLD,24)"!"left(value,20) if ROWNUM < 1 then say copies("-",8)"!"copies("-",24)"!" !!, copies("-",24)"!"copies("-",20) Address DSNREXX "EXECSQL" SQLSTMT end call code 0 100 sqlstmt = "CLOSE C101" address DSNREXX "EXECSQL "sqlstmt; call code 0 100 say "*** end ***" /*********************************************************************/ /* Disconnect vom Subsystem */ /*********************************************************************/ Disconnect: ADDRESS DSNREXX "DISCONNECT" cc = RXSUBCOM("DELETE","DSNREXX","DSNREXX") return /*********************************************************************/ /* Error processing and termination */ /*********************************************************************/ SYNTAX: say "DIS2INST: Syntax error." say " [TSO] DIS2INST ssid options" say " ssid .......: DB2 Subsystem ID" say " criteria ...: criteria for DSNACCOX" ERROR: say "" say "Current enviroment:" jobnamestep source_host_env, source_call_type source_uc_exec_name source_hostdd, source_hostdsn source_nf_exec_name source_initial_cmd_env If Sysvar(SYSISPF) = "NOT ACTIVE" then do say "REXX procedure DIS2INST ends with U0001." address ATTACH "XMPABND" exit 0 end say "REXX procedure DIS2INST ends with RC=20." exit 20 /*********************************************************************/ /* Check SQLCODE's allowed */ /*********************************************************************/ Code: arg codes allowed = "NO" do ci=1 to words(codes) if sqlcode = word(codes,ci) then allowed = "YES" end if allowed = "NO" then do say "CONNECT: SQL Error with SQLCODE="sqlcode call TIAR sqlcode say " "sqlstmt call Disconnect signal error end return /*********************************************************************/ /* process line output, hide if value contains no information */ /*********************************************************************/ Line: arg lval ltext lval = trunc(lval) if lval > 0 then say right(lval,20)" "ltext return /*********************************************************************/ /* Retrieve some internal information from z/OS control blocks */ /*********************************************************************/ GET_JOBNAME: Procedure /* all fields are part of general use prog'ing interface */ PSATOLD = '21C'X TCB = C2D(STORAGE(C2X(PSATOLD),4)) TIOT = C2D(STORAGE(D2X(TCB+12),4)) TIOCNJOB = STRIP(STORAGE(D2X(TIOT),8)) TIOCSTEP = STRIP(STORAGE(D2X(TIOT+8),8)) Return TIOCNJOB TIOCSTEP /*********************************************************************/ /* Display SQL Commmunication area using DSNTIAR */ /*********************************************************************/ TIAR: arg sqlcode sqlc = d2x(sqlcode,8) sqlc = x2c(sqlc) sqlca = 'sqlca ' sqlca = sqlca !! x2c(00000088) sqlca = sqlca !! sqlc sqlca = sqlca !! x2c(0000) sqlca = sqlca !! copies(' ',78) sqlca = sqlca !! copies(x2c(00),24) sqlca = sqlca !! copies(' ',16) tiar_msg = x2c(0190)copies(' ',400) text_len = x2c(00000050) ; /***************************************************************/ /* Extract Message from Return Area */ /***************************************************************/ ADDRESS ATTCHPGM 'DSNTIAR SQLCA TIAR_MSG TEXT_LEN' say substr(tiar_msg,4,400); /***************************************************************/ /* Extract Message from Return Area */ /***************************************************************/ len = c2d(substr(rtrnarea,5,2)) /***************************************************************/ /* Extract Message from Return Area */ /***************************************************************/ say " SQLCODE="sqlcode say " SQLERRMC="sqlerrmc say " SQLWARN5="sqlwarn.5 say " SQLERRP ="sqlerrp say " SQLSTATE="sqlstate return
Look here for the XMPABND module.
 ###############################################################################  # DIS2INST V1.0 - DSNHDECP DB2 for z/OS installation values 11/05/21 11:02:56 #  ###############################################################################  Executing without arguments, setting default DB2 subsystem id and criteria.  MACRO  !PARAMETER              !INSTALL_FIELD          !VALUE               --------!------------------------!------------------------!--------------------  DSN6SYSP!AUDITST                !AUDIT TRACE            !11110000000000000000  DSN6SYSP!CONDBAT                !MAX REMOTE CONNECTED   !0000001000           DSN6SYSP!CTHREAD                !MAX USERS              !00100               DSN6SYSP!DLDFREQ                !LEVELID UPDATE FREQUENCY!00005               DSN6SYSP!PCLOSEN                !RO SWITCH CHKPTS       !00005               DSN6SYSP!IDBACK                 !MAX BATCH CONNECT      !00100               DSN6SYSP!IDFORE                 !MAX TSO CONNECT        !00100               DSN6SYSP!CHKFREQ                !CHECKPOINT FREQ        !0000500000           DSN6SYSP!MON                    !MONITOR TRACE          !00000000             DSN6SYSP!MONSIZE                !MONITOR SIZE           !0000262144           DSN6SYSP!SYNCVAL                !STATISTICS SYNC        !NO                   DSN6SYSP!RLFAUTH                !RESOURCE AUTHID        !SYSIBM               DSN6SYSP!RLF                    !RLF AUTO START         !YES                 DSN6SYSP!RLFERR                 !RLST ACCESS ERROR      !NOLIMIT             DSN6SYSP!RLFTBL                 !RLST NAME SUFFIX       !01                   DSN6SYSP!MAXDBAT                !MAX REMOTE ACTIVE      !00050               DSN6SYSP!DSSTIME                !DATASET STATS TIME     !00015               DSN6SYSP!EXTSEC                 !EXTENDED SECURITY      !YES                 DSN6SYSP!SMFACCT                !SMF ACCOUNTING         !11100000000000000000  DSN6SYSP!SMFSTAT                !SMF STATISTICS         !11101100000000000000  DSN6SYSP!ROUTCDE                !WTO ROUTE CODES        !1000000000000000     DSN6SYSP!STORMXAB               !MAX ABEND COUNT        !00000               DSN6SYSP!STORTIME               !TIMEOUT VALUE          !00180               DSN6SYSP!STATIME                !STATISTICS TIME        !00005               DSN6SYSP!TRACLOC                !                       !00016               DSN6SYSP!PCLOSET                !RO SWITCH TIME         !00010               DSN6SYSP!TRACSTR                !TRACE AUTO START       !00000000000000000000  DSN6SYSP!TRACTBL                !TRACE SIZE             !00016               DSN6SYSP!URCHKTH                !UR CHECK FREQ          !000                 DSN6SYSP!WLMENV                 !WLM ENVIRONMENT        !DB2TWLM1             DSN6SYSP!LOBVALA                !USER LOB VALUE STG     !0000010240           DSN6SYSP!LOBVALS                !SYSTEM LOB VAL STG     !0000002048           DSN6SYSP!XMLVALA                !USER XML VALUE STG     !0002097152           DSN6SYSP!XMLVALS                !SYSTEM XML VAL STG     !0000002048           DSN6SYSP!LOGAPSTG               !LOG APPLY STORAGE      !100                 DSN6SYSP!PTASKROL               !                       !YES                 DSN6SYSP!EXTRAREQ               !EXTRA BLOCKS REQ       !00100               DSN6SYSP!EXTRASRV               !EXTRA BLOCKS SRV       !00100               DSN6SYSP!TBSBPOOL               !DEFAULT BUFFER POOL FOR !BP10                 DSN6SYSP!IDXBPOOL               !DEFAULT BUFFER POOL FOR !BP11                 DSN6SYSP!LBACKOUT               !LIMIT BACKOUT          !AUTO                 DSN6SYSP!BACKODUR               !BACKOUT DURATION       !005                 DSN6SYSP!URLGWTH                !UR LOG WRITE CHECK     !0000000000           DSN6SYSP!UIFCIDS                !UNICODE IFCIDS         !NO                   DSN6SYSP!ACCUMACC               !DDF-RRSAF ACCUM        !00010               DSN6SYSP!ACCUMUID               !AGGREGATION FIELDS     !00000               DSN6SYSP!TSQTY                  !TABLE SPACE ALLOCATION !0000000048          DSN6SYSP!IXQTY                  !INDEX SPACE ALLOCATION !0000000048           DSN6SYSP!DSVCI                  !VARY DS CONTROL INTERVAL!YES                 DSN6SYSP!MGEXTSZ                !OPTIMIZE EXTENT SIZING !YES                 DSN6SYSP!SMF89                  !                       !NO                   DSN6SYSP!OTC_LICENSE            !                       !NOT_USED             DSN6SYSP!MAXOFILR               !MAX OPEN FILE REFS     !0000000100           DSN6SYSP!TBSBP8K                !DEFAULT 8-KB BUFFER POO!BP8K0               DSN6SYSP!TBSBP16K               !DEFAULT 16-KB BUFFER POO!BP16K0               DSN6SYSP!TBSBP32K               !DEFAULT 32-KB BUFFER POO!BP32K               DSN6SYSP!TBSBPLOB               !DEFAULT BUFFER POOL FOR !BP1                 DSN6SYSP!TBSBPXML               !DEFAULT BUFFER POOL FOR !BP16K0               DSN6SYSP!IMPDSDEF               !DEFINE DATA SETS       !YES                 DSN6SYSP!IMPTSCMP               !USE DATA COMPRESSION   !YES                 DSN6LOGP!TWOACTV                !NUMBER OF COPIES       !2                   DSN6LOGP!OFFLOAD                !                       !YES                 DSN6LOGP!TWOBSDS                !                       !2                   DSN6LOGP!TWOARCH                !NUMBER OF COPIES       !1                   DSN6LOGP!MAXARCH                !RECORDING MAX          !0000010000           DSN6LOGP!DEALLCT                !DEALLOC PERIOD         !00000:00000         DSN6LOGP!MAXRTU                 !READ TAPE UNITS        !00002               DSN6LOGP!OUTBUFF                !OUTPUT BUFFER          !0000004000           DSN6LOGP!ARC2FRST               !READ COPY2 ARCHIVE     !NO                   DSN6ARVP!BLKSIZE                !BLOCK SIZE             !0000028672           DSN6ARVP!CATALOG                !CATALOG DATA           !YES                 DSN6ARVP!ALCUNIT                !ALLOCATION UNITS       !CYL                 DSN6ARVP!PROTECT                !ARCHIVE LOG RACF       !NO                   DSN6ARVP!ARCWTOR                !WRITE TO OPER          !NO                   DSN6ARVP!COMPACT                !COMPACT DATA           !NO                   DSN6ARVP!TSTAMP                 !TIMESTAMP ARCHIVES     !YES                 DSN6ARVP!QUIESCE                !QUIESCE PERIOD         !00060               DSN6ARVP!ARCRETN                !RETENTION PERIOD       !00015               DSN6ARVP!ARCPFX1                !ARCH LOG 1 PREFIX      !DSNDB2T.DB2T.ARC1   DSN6ARVP!ARCPFX2                !ARCH LOG 2 PREFIX      !DSNDB2T.DB2T.ARC2   DSN6ARVP!PRIQTY                 !PRIMARY QUANTITY       !0000001000           DSN6ARVP!SECQTY                 !SECONDARY QTY          !0000000010           DSN6ARVP!UNIT                   !DEVICE TYPE 1          !TAPE               DSN6ARVP!UNIT2                  !DEVICE TYPE 2          !TAPE               DSN6ARVP!SVOLARC                !SINGLE VOLUME          !NO                   DSN6ARVP!ARCWRTC                !WTOR ROUTE CODE        !1011000000000000     DSN6ARVP!MSVGP                  !                       !                     DSN6ARVP!MSVGP2                 !                       !                     DSN6SPRM!ABIND                  !AUTO BIND              !YES                 DSN6SPRM!SYSADM2                !SYSTEM ADMIN 2         !DB2IUSR               DSN6SPRM!AUTHCACH               !PLAN AUTH CACHE        !03072               DSN6SPRM!AUTH                   !USE PROTECTION         !YES                 DSN6SPRM!BMPTOUT                !IMS BMP TIMEOUT        !00004               DSN6SPRM!LEMAX                  !MAXIMUM LE TOKENS      !00020               DSN6SPRM!BINDNV                 !BIND NEW PACKAGE       !BINDADD             DSN6SPRM!CDSSRDEF               !CURRENT DEGREE         !1                   DSN6SPRM!DBCHK                  !                       !NO                   DSN6SPRM!DEFLTID                !UNKNOWN AUTHID         !IBMUSER             DSN6SPRM!CHGDC AND EDPROP       !DPROP SUPPORT          !1                   DSN6SPRM!DECDIV3                !MINIMUM DIVIDE SCALE   !NO                   DSN6SPRM!DLITOUT                !DLI BATCH TIMEOUT      !00006               DSN6SPRM!DSMAX                  !MAXIMUM OPEN DATA SETS !0000020000           DSN6SPRM!EDMPOOL                !EDMPOOL STORAGE SIZE   !0000005000          DSN6SPRM!RECALLD                !RECALL DELAY           !00120               DSN6SPRM!RECALL                 !RECALL DATA BASE       !YES                 DSN6SPRM!IRLMAUT                !AUTO START             !YES                 DSN6SPRM!ABEXP                  !EXPLAIN PROCESSING     !YES                 DSN6SPRM!IRLMPRC                !PROC NAME              !DB2TIRLM             DSN6SPRM!IRLMSID                !SUBSYSTEM NAME         !IIBA                 DSN6SPRM!IRLMSWT                !TIME TO AUTO START     !0000000300           DSN6SPRM!NUMLKTS                !LOCKS PER TABLE(SPACE) !0000001000           DSN6SPRM!NUMLKUS                !LOCKS PER USER         !0000020000           DSN6SPRM!HOPAUTH                !AUTH AT HOP SITE       !BOTH                 DSN6SPRM!SEQCACH                !SEQUENTIAL CACHE       !BYPASS               DSN6SPRM!RRULOCK                !U LOCK FOR RR OR RS    !NO                   DSN6SPRM!DESCSTAT               !DESCRIBE FOR STATIC    !YES                 DSN6SPRM!SEQPRES                !UTILITY CACHE OPTION   !NO                   DSN6SPRM!CACHEDYN               !CACHE DYNAMIC SQL      !YES                 DSN6SPRM!RETLWAIT               !RETAINED LOCK TIMEOUT  !00000               DSN6SPRM!CACHERAC               !ROUTINE AUTH CACHE     !0000102400           DSN6SPRM!CONTSTOR               !CONTRACT THREAD STG    !NO                   DSN6SPRM!MAXKEEPD               !MAX KEPT DYN STMTS     !0000000100           DSN6SPRM!PROTOFF                !                       !NO                   DSN6SPRM!AEXITLIM               !AUTH EXIT LIMIT        !00010               DSN6SPRM!RETVLCFK               !VARCHAR FROM INDEX     !NO                   DSN6SPRM!OJPERFEH               !                       !YES                 DSN6SPRM!SYSOPR1                !SYSTEM OPERATOR 1      !SYSOPR               DSN6SPRM!SYSOPR2                !SYSTEM OPERATOR 2      !DB2IUSR               DSN6SPRM!CACHEPAC               !PACKAGE AUTH CACHE     !0000102400           DSN6SPRM!PARA_EFF               !                       !00050               DSN6SPRM!PARAMDEG               !MAX DEGREE             !0000000001           DSN6SPRM!PARTKEYU               !UPDATE PART KEY COLS   !YES                 DSN6SPRM!STATHIST               !STATISTICS HISTORY     !NONE                 DSN6SPRM!RGFNMPRT               !APPL REGISTRATION TABLE !DSN_REGISTER_APPL   DSN6SPRM!RGFCOLID               !REGISTRATION OWNER     !DSNRGCOL             DSN6SPRM!RGFESCP                !ART-ORT ESCAPE CHAR    !                     DSN6SPRM!RGFINSTL               !INSTALL DDCTRL SUPT    !NO                   DSN6SPRM!RGFDEDPL               !CONTROL ALL APPLICATIONS!NO                   DSN6SPRM!RGFFULLQ               !REQUIRE FULL NAMES     !YES                 DSN6SPRM!RGFDEFLT               !UNREGISTERED DDL DEFAULT!ACCEPT               DSN6SPRM!RGFDBNAM               !REGISTRATION DATABASE  !DSNRGFDB             DSN6SPRM!RGFNMORT               !OBJT REGISTRATION TABLE !DSN_REGISTER_OBJT   DSN6SPRM!MAXRBLK                !RID POOL SIZE          !0000008000           DSN6SPRM!MINRBLK                !                       !0000000001           DSN6SPRM!SYSADM                 !SYSTEM ADMIN 1         !DB2IUSR               DSN6SPRM!SRTPOOL                !SORT POOL SIZE         !0000002000           DSN6SPRM!IRLMRWT                !RESOURCE TIMEOUT       !0000000060           DSN6SPRM!SITETYP                !SITE TYPE              !LOCALSITE           DSN6SPRM!UTIMOUT                !UTILITY TIMEOUT        !00006               DSN6SPRM!XLKUPDLT               !X LOCK FOR SEARCHED U OR!NO                   DSN6SPRM!OPTHINTS               !OPTIMIZATION HINTS     !NO                   DSN6SPRM!TRKRSITE               !TRACKER SITE           !NO                   DSN6SPRM!EDMBFIT                !LARGE EDM BETTER FIT   !YES                 DSN6SPRM!NPGTHRSH               !                       !0000000000           DSN6SPRM!SJTABLES               !                       !00010               DSN6SPRM!STARJOIN               !STAR JOIN QUERIES      !DISABLE             DSN6SPRM!SMSDCFL                !                       !                     DSN6SPRM!SMSDCIX                !                       !                     DSN6SPRM!DBACRVW                !DBADM CREATE AUTH      !YES                DSN6SPRM!SUPERRS                !SUPPRESS SOFT ERRORS   !YES                 DSN6SPRM!STATROLL               !STATISTICS ROLLUP      !NO                   DSN6SPRM!MINSTOR                !MANAGE THREAD STORAGE  !YES                 DSN6SPRM!EVALUNC                !EVALUATE UNCOMMITTED   !NO                   DSN6SPRM!STATSINT               !REAL TIME STATS        !00030               DSN6SPRM!MINDVSCL               !                       !NONE                 DSN6SPRM!MXTBJOIN               !                       !00225               DSN6SPRM!EDMDBDC                !EDM DBD CACHE          !0000005000           DSN6SPRM!EDMSTMTC               !EDM STATEMENT CACHE    !0000005000           DSN6SPRM!EDM_SKELETON_POOL      !EDM SKELETON POOL SIZE !0000025000           DSN6SPRM!REFSHAGE               !CURRENT REFRESH AGE    !0                   DSN6SPRM!MAINTYPE               !CURRENT MAINT TYPES    !SYSTEM               DSN6SPRM!MAX_OPT_STOR           !                       !00040               DSN6SPRM!MAX_OPT_CPU            !                       !00100               DSN6SPRM!LRDRTHLD               !LONG-RUNNING READER    !00000               DSN6SPRM!VOLTDEVT               !TEMP DS UNIT NAME      !SYSDA               DSN6SPRM!DISABSCL               !                       !NO                   DSN6SPRM!SKIPUNCI               !SKIP UNCOMM INSERTS    !NO                   DSN6SPRM!MXQBCE                 !                       !0000001023           DSN6SPRM!PADIX                  !PAD INDEXES BY DEFAULT !NO                   DSN6SPRM!SMGE                   !                       !NO                   DSN6SPRM!SECLCACH               !                       !00255               DSN6SPRM!MXDTCACH               !MAX DATA CACHING       !00020               DSN6SPRM!MAX_NUM_CUR            !MAX OPEN CURSORS       !0000000500           DSN6SPRM!MAX_ST_PROC            !MAX STORED PROCS       !0000002000           DSN6SPRM!INLISTP                !                       !0000000050           DSN6SPRM!MAXTEMPS               !MAX TEMP STGÖAGENT     !0000000000           DSN6SPRM!WFDBSEP                !                       !NO                   DSN6SPRM!XMLTABJPD              !                       !NO                   DSN6SPRM!SYSTEM_LEVEL_BACKUPS   !SYSTEM-LEVEL BACKUPS   !NO                   DSN6SPRM!RESTORE_RECOVER_FROMDUMP!RESTOREÖRECOVER        !NO                   DSN6SPRM!UTILS_DUMP_CLASS_NAME  !DUMP CLASS NAME        !                     DSN6SPRM!RESTORE_TAPEUNITS      !MAXIMUM TAPE UNITS     !NOLIMIT             DSN6SPRM!UTIL_TEMP_STORCLAS     !                       !                     DSN6SPRM!OPTXQB                 !                       !ON                   DSN6SPRM!RPITWC                 !                       !YES                 DSN6SPRM!UNION_COLNAME_7        !                       !NO                   DSN6SPRM!SJMISSKY               !                       !OFF                 DSN6SPRM!COMCRIT                !                       !NO                   DSN6SPRM!PTCDIO                 !                       !OFF                 DSN6SPRM!OPTIXIO                !                       !ON                   DSN6SPRM!STATCLUS               !STATISTICS CLUSTERING  !ENHANCED             DSN6SPRM!CACHEDYN_FREELOCAL     !                       !00001               DSN6SPRM!UTSORTAL               !UT SORT DATA ALLOCATION !YES                 DSN6SPRM!IGNSORTN               !IGNORE SORTNUM STMT    !NO                   DSN6SPRM!DB2SORT                !                       !DISABLE             DSN6SPRM!PLANMGMT               !                       !OFF                 DSN6SPRM!MORE_UNION_DISTRIBUTION !                       !OFF                 DSN6SPRM!MAX_CONCURRENT_PKG_OPS !                       !00010               DSN6SPRM!ADMTPROC               !                       !                     DSN6SPRM!HONOR_KEEPDICTIONARY   !                       !NO                   DSN6SPRM!MAX_UTIL_PARTS         !                       !00254               DSN6SPRM!OPTIXOPREF             !                       !ON                   DSN6SPRM!OPTJBPR                !                       !ON                   DSN6SPRM!ZOSMETRICS             !                       !YES                 DSN6SPRM!OPTJBPL                !                       !ON                  DSN6SPRM!OPTIOWGT               !                       !ENABLE               DSN6SPRM!RRF                    !                       !DISABLE             DSN6SPRM!OPTOFNRE               !                       !ENABLE               DSN6SPRM!EN_PJSJ                !                       !OFF                 DSN6SPRM!ACCEL                  !                       !NO                   DSN6SPRM!PREDPRUNE              !                       !NO                   DSN6SPRM!COMPRESS_SPT01         !                       !YES                 DSN6SPRM!REORG_IGNORE_FREESPACE !                       !NO                   DSN6SPRM!OPTOIRCPF              !                       !DISABLE             DSN6SPRM!OPTHYBCST              !                       !OFF                 DSN6SPRM!DRDA_RESOLVE_ALIAS     !                       !NO                   DSN6SPRM!PREVALKEEP             !                       !NO                   DSN6SPRM!CHECK_FASTREPLICATION  !                       !PREFERRED           DSN6SPRM!FLASHCOPY_PPRC         !                       !                     DSN6SPRM!SIMULATED_CPU_COUNT    !                       !OFF                 DSN6SPRM!SIMULATED_CPU_SPEED    !                       !OFF                 DSN6SPRM!CATALOG                !CATALOG ALIAS          !DSNDB2T             DSN6SPRM!RESTART DEF            !RESTART OR DEFER       !RESTART             DSN6SPRM!ALL-DBNAME             !DBSTARTX               !ALL                 DSN6FAC !CMTSTAT                !DDF THREADS            !INACTIVE             DSN6FAC !TCPALVER               !TCP IP ALREADY VERIFIED !NO                   DSN6FAC !PRGSTRIN               !                       !ENABLE               DSN6FAC !RESYNC                 !RESYNC INTERVAL        !00002               DSN6FAC !RLFERRD                !RLST ACCESS ERROR      !NOLIMIT             DSN6FAC !DDF                    !DDF STARTUP OPTION     !AUTO                 DSN6FAC !IDTHTOIN               !IDLE THREAD TIMEOUT    !03600               DSN6FAC !MAXTYPE1               !MAX TYPE1 INACTIVE THREA!0000000000           DSN6FAC !TCPKPALV               !TCPIP KEEPALIVE        !00120               DSN6FAC !POOLINAC               !POOL THREAD TIMEOUT    !00180               DSN6FAC !SQLINTRP               !                       !ENABLE               DSN6FAC !PRIVATE_PROTOCOL       !                       !YES                 DSN6GRP !ASSIST                 !ASSISTANT              !NO                   DSN6GRP !COORDNTR               !COORDINATOR            !NO                   DSN6GRP !IMMEDWRI               !IMMEDIATE WRITE        !NO                   DSN6GRP !DSHARE                 !DATA SHARING FUNCTION  !NO                   DSN6GRP !MEMBNAME               !MEMBER NAME            !DSN1                 DSN6GRP !GRPNAME                !GROUP NAME             !DSNCAT               DSN6GRP !RANDOMATT              !                       !YES                 DSNHDECP!DB2SUPLD               !                       !NO                   DSNHDECP!DEFLANG                !LANGUAGE DEFAULT       !IBMCOB               DSNHDECP!DECIMAL                !DECIMAL POINT IS       !PERIOD               DSNHDECP!DELIM                  !STRING DELIMITER       !DEFAULT             DSNHDECP!SQLDELI                !SQL STRING DELIMITER   !DEFAULT             DSNHDECP!DSQLDELI               !DIST SQL STR DELIMITER !APOST               DSNHDECP!MIXED                  !MIXED DATA             !NO                   DSNHDECP!SCCSID                 !EBCDIC CCSID           !00273               DSNHDECP!MCCSID                 !EBCDIC CCSID           !65534               DSNHDECP!GCCSID                 !EBCDIC CCSID           !65534               DSNHDECP!ASCCSID                !ASCII CCSID            !05348               DSNHDECP!AMCCSID                !ASCII CCSID            !65534               DSNHDECP!AGCCSID                !ASCII CCSID            !65534               DSNHDECP!USCCSID                !UNICODE CCSID          !00367               DSNHDECP!UMCCSID                !UNICODE CCSID          !01208               DSNHDECP!UGCCSID                !UNICODE CCSID          !01200               DSNHDECP!ENSCHEME               !DEF ENCODING SCHEME    !EBCDIC               DSNHDECP!APPENSCH               !APPLICATION ENCODING   !EBCDIC              1DSNHDECP!NEWFUN                 !                       !YES                 DSNHDECP!DATE                   !DATE FORMAT            !ISO                 DSNHDECP!TIME                   !TIME FORMAT            !ISO                 DSNHDECP!DATELEN                !LOCAL DATE LENGTH      !000                 DSNHDECP!TIMELEN                !LOCAL TIME LENGTH      !000                 DSNHDECP!STDSQL                 !STD SQL LANGUAGE       !NO                   DSNHDECP!CHARSET                !                       !ALPHANUM             DSNHDECP!SSID                   !SUBSYSTEM NAME         !DB2T                 DSNHDECP!DECARTH                !DECIMAL ARITHMETIC     !DEC15               DSNHDECP!DYNRULS                !USE FOR DYNAMICRULES   !YES                 DSNHDECP!LC_CTYPE               !LOCALE LC_CTYPE        !                     DSNHDECP!PADNTSTR               !PAD NUL-TERMINATED     !NO                   DSNHDECP!DEF_DECFLOAT_ROUND_MODE !DECFLOAT ROUNDING MODE !ROUND_HALF_EVEN     DB2TIRLM!PC SPECIFIED           !                       !YES                 DB2TIRLM!WAIT TIME FOR LOCAL DEAD!DEADLOCK TIME          !00001               DB2TIRLM!LOCAL CYCLES PER GLOBAL !DEADLOCK CYCLE         !00001               DB2TIRLM!TIMEOUT INTERVAL       !                       !0000000060           DB2TIRLM!IRLM MAXIMUM CSA USAGE A!                       !0000000000           DB2TIRLM!SYSTEM LOCK TABLE HASH E!                       !0000000000           DB2TIRLM!PENDING NUMBER OF HASH E!                       !0000000000           DB2TIRLM!SYSTEM LOCK TABLE LIST E!                       !0000000000           *** end ***
Comments
Comments are closed.