Examples of FMN2SSDM macros

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


         FMN2SSDM SSID=DF52,PLAN=FMN2PLNE,                             +  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'                     
*                                                                       
         FMN2SSDM SSID=DF61,PLAN=FMN2PLNE,                             +  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'                    
*                                                                       
         FMN2SSDM SSID=DF13,PLAN=FMN2PLNE,                             +  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'                       
*                                                                        
         FMN2SSDM SSID=DG03,PLAN=FMN2PLNE,                             +  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'                       
*                                                                        
         FMN2SSDM 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 File Manager 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 FM/Db2 editor.
  6. TABLE_LOCKING is set to NO. This prevents any user specifying the Lock table option when using the FM/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) FMN2SSDM macro invocation must specify DEFAULT.