DB2系统命名规范.docVIP

DB2系统命名规范 Background z Education cloud expects support each class a separate DB2 subsystem. To ease of maintenance, this is DB2 naming convention which will be used for Non-DS DB2 subsystem General design ItemNameDescriptionGroupGxxxG001DB2/IRLM Members and subsystem namesDxxx/Ixxx D001/I001 DB2/IRLM proc name (in a common proclib dataset)DxxxMSTR DxxxIRLM DxxxDBM1 DxxxDIST DxxxXXXXD001MSTR D001IRLM D001DBM1 D001DISTGroup AttachGxxxGxxxCatalog/DirectoryDxxxSYSD001SYS.DSNDBD.DSNDB0*.* User dataDxxxUSR D001USR.DSNDBD.*Command recognition-Dxxx -D001Work File DatabaseDxxxSYS. **. DxxxWORKD001SYS.DSNDBD.D001WORKTemp databaseDxxxSYS.**.DxxxTEMPDSN01SYS.DSNDBD.D001TEMP *Deprecated in V9BSDSDxxxSYS.Dxxx.BSDS01 DxxxSYS.Dxxx.BSDS02 D001SYS.D001.BSDS01 D0001SYS.D001.BSDS02Active LogsDxxxSYS.Dxxx.LOGCOPY1.DS## DxxxSYS.Dxxx.LOGCOPY2.DS## ## is a number starting at 01 and up to the number of desired active logsArchive logsDxxxSYS.Dxxx.ARC**Don’t need Archive logs in z Education cloudDB2 image copiesDxxxSYS.dbname.tsname.Cz.aAlways do image copy for cat/dir after clone. z is copy number (typically 1 or 2 if dual images are done). C stands for copy and a is Dmmddyy.Thhmmss for time stamped images. ‘a’ can also be another qualifier if desired.DB2 Code (non link listed)DxxxSYS.SDSNEXIT Dxxx.SDSNLOAD (alias, point to **.SDSNLOAD) Dxxx.SDSNLOD2 (alias, point to **.SDSNLOD2) SDSNEXIT is group level dataset which saves zparm, decp modules. SDSNLOAD/LOD2 are ALIAS’s that point to actual code library .DB2 Code (link listed)**.SDSNLINK SDSNLINK is shared for all DB2’s regardless of release (so it will need to be at the highest version). Other DB2 Libraries - one per groupDxxxSYS.SRCLIB.DATA DxxxSYS.RUNLIB.LOAD DxxxSYS.DBRMLIB.DATA Dxxx.SDSNSPFP(optional) Dxxx.SDSNSPFM (optional) Dxxx.SDSNSPFE(optional) Dxxx.SDSNCLST(optional) One dataset per each group to save source module, load module and dbrmOther DB2 Libraries - on