Examples of HFM2SSDM macros

The following sample code shows the HFM2SSDM macro statements you would code to define Db2® subsystems to ZDT/Db2, for Db2 version 9, and data sharing groups for Db2 version 10. You would code HFM2SSDM macros similar to these, and include them in your version of HFM2POPT. (Do not change HFM2SSDM in HFM.SHFMMAC1.) For an explanation of the statements see the notes at the end of the example.

         HFM2SSDM SSID=DF52,PLAN=HFM2PLNE,                             +   DF52 
               TYPE=SUBSYS,                                            +
               AUDIT=(REQUIRED,SMF),                                   +
               EDIT_MAX_ROWS=0,                                        +
               DB2LLIB=('DB2VA10.DF52.SDSNEXIT','DB2.VA10.SDSNLOAD'),  +
               DB2RLIB=('DB2VA10.DF52.RUNLIB.LOAD'),                   +
               DB2CLIB=('DB2.VA10.SDSNCLST'),                          +
               DB2MLIB=('DB2.VA10.SDSNSPFM'),                          +
               DB2PLIB=('DB2.VA10.SDSNSPFP','DB2.VA10.SDSNPFPE'),      +
               DB2SLIB=('DB2.VA10.SDSNSPFS'),                          +
               DB2TLIB=('DB2.VA10.SDSNSPFT'),                          +
               DB2PROC=('DB2VA10.DF52.PROCLIB'),                       +
               DESC='DB2 Version 10.1 - Production'                     
*                                                                       
         HFM2SSDM SSID=DF61,PLAN=HFM2PLNE,                             +   DF61 
               DISPLAY=HIDDEN,                                         +
               AUDIT=OPTIONAL,                                         +
               DB2LLIB=('DB2VB10.DF61.SDSNEXIT','DB2.VB10.SDSNLOAD'),  +
               DB2RLIB=('DB2VB10.DF61.RUNLIB.LOAD'),                   +
               DB2CLIB=('DB2.VB10.SDSNCLST'),                          +
               DB2MLIB=('DB2.VB10.SDSNSPFM'),                          +
               DB2PLIB=('DB2.VB10.SDSNSPFP','DB2.VB10.SDSNPFPE'),      +
               DB2SLIB=('DB2.VB10.SDSNSPFS'),                          +
               DB2TLIB=('DB2.VB10.SDSNSPFT'),                          +
               DB2PROC=('DB2VB10.DF61.PROCLIB'),                       +
               DESC='DB2 Version 11.1 - Development'                    
*                                                                       
         HFM2SSDM SSID=DF13,PLAN=HFM2PLNE,                             +   DF13 
               TYPE=SUBSYS,                                            +
               AUDIT=REQUIRED,                                         +
               EDIT_MAX_ROWS=0,                                        +
               FORCE_WITH_UR=Y,                                        +
               TABLE_LOCKING=NO,                                       +
               DB2LLIB=('DB2VC10.DF13.SDSNEXIT','DB2.VC10.SDSNLOAD'),  +
               DB2RLIB=('DB2VC10.DF13.RUNLIB.LOAD'),                   +
               DB2CLIB=('DB2.VC10.SDSNCLST'),                          +
               DB2MLIB=('DB2.VC10.SDSNSPFM'),                          +
               DB2PLIB=('DB2.VC10.SDSNSPFP','DB2.VC10.SDSNPFPE'),      +
               DB2SLIB=('DB2.VC10.SDSNSPFS'),                          +
               DB2TLIB=('DB2.VC10.SDSNSPFT'),                          +
               DB2PROC=('DB2VC10.DF13.PROCLIB'),                       +
               TMPDDLN=DF13TMDD,                                       +
               DB2SLIB=('DB2.VC10.SDSNSPFS'),                          +
               DB2TLIB=('DB2.VC10.SDSNSPFT'),                          +
               DB2PROC=('DB2VC10.DF13.PROCLIB'),                       +
               TMPDDLN=DF13TMDD,                                       +
               STMJCL1='DISP=SHR,DSN=FIRST.TEMPLATE.LIBRARY,',         +
               STMJCL2='DISP=SHR,DSN=SECOND.TEMPLATE.LIBRARY',         +
               OPTEVT1='ITEMERROR,HALT',                               +
               CPYCPYN=DF13CPYC,                                       +
               LODINDN=DF13LDIN,                                       +
               DESC='DB2 Version 12.1 - Production'                       
*                                                                        
         HFM2SSDM SSID=DG03,PLAN=HFM2PLNE,                             +   DG03 
               TYPE=GROUP,                                             +
               DISPLAY=YES,                                            +
               DB2LLIB=('DB2VB10.DF61.SDSNEXIT','DB2.VB10.SDSNLOAD'),  +
               DB2RLIB=('DB2VB10.DF61.RUNLIB.LOAD'),                   +
               DB2CLIB=('DB2.VB10.SDSNCLST'),                          +
               DB2MLIB=('DB2.VB10.SDSNSPFM'),                          +
               DB2PLIB=('DB2.VB10.SDSNSPFP','DB2.VB10.SDSNPFPE'),      +
               DB2SLIB=('DB2.VB10.SDSNSPFS'),                          +
               DB2TLIB=('DB2.VB10.SDSNSPFT'),                          +
               DB2PROC=('DB2VB10.DF61.PROCLIB'),                       +
               DESC='DB2 Group Attach ID number 1'                       
*                                                                        
         HFM2SSDM SSID=DEFAULT                                       DEFAULT 
Note: In this example the + characters are in column 72.

 DF52 

  1. These statements define a Db2 10 subsystem, called DB2 Version 10.1 – Production.
  2. The SSID is DF52.
  3. Auditing is required. Audit records are written as SMF records.
  4. EDIT_MAX_ROWS is set to 0. This disables "large" editor mode for all users.
  5. The Db2 library names are specified using DB2LLIB, DB2RLIB, and so on.

 DF61 

  1. These statements define a Db2 11 subsystem, called DB2 Version 11.1 – Development.
  2. The SSID is DF61.
  3. Auditing is optional.
  4. DISPLAY=HIDDEN is specified. This Db2 subsystem will not appear on the Z Data Tools Db2 subsystem selection list.
  5. The Db2 library names are specified using DB2LLIB, DB2RLIB, and so on.

 DF13 

  1. These statements define a Db2 12 subsystem, called DB2 Version 12.1 – Production.
  2. The SSID is DF13.
  3. Auditing is required. Audit records are written to data sets.
  4. EDIT_MAX_ROWS is set to 0. This disables "large" editor mode for all users.
  5. FORCE_WITH_UR is set to Y. This adds the WITH UR clause to any SQL statements executed by the ZDT/Db2 editor.
  6. TABLE_LOCKING is set to NO. This prevents any user specifying the "Lock table" option when using the ZDT/Db2 editor.
  7. The TMPDDLN keyword specifies a ddname for the site-specific template library of DF13TMDD. The STMJCL1 and STMJCL2 keywords specify two concatenated data sets named FIRST.TEMPLATE.LIBRARY and SECOND.TEMPLATE.LIBRARY for this ddname. The JCL generated by these keywords will be:
    //DF13TMDD DD DISP=SHR,DSN=FIRST.TEMPLATE.LIBRARY 
    //                    DD DSN=SECOND.TEMPLATE.LIBRARY
  8. The OPTEVT1 keyword will generate this OPTIONS EVENT statement:
    OPTIONS EVENT(ITEMERROR,HALT)
  9. The CPYCPYN keyword specifies a template name of DF91CPYC to be used in a COPYDDN clause in a COPY utility statement.
  10. The LODINDD keyword specifies a template name of DF13LDIN to be used in an INDDN clause in the LOAD utility statement.
  11. The Db2 library names are specified using DB2LLIB, DB2RLIB, and so on.

 DG03 

  1. These statements define a Db2 11 data sharing group called DB2 group attach ID number 1.
  2. The SSID is DG03.
  3. TYPE=GROUP specifies that the entry is for a Db2 group, not a Db2 subsystem.
  4. The Db2 library names are specified using DB2LLIB, DB2RLIB, and so on.

 DEFAULT 

This statement is required. Its only parameter is DEFAULT. The last (or only if there is only one) HFM2SSDM macro invocation must specify DEFAULT.