LIST


1 LIST=
2.1! ALL
2.1 ACTIVE
2.1?  (
2.2.1+ ,
2.2.1 GROUP? (
2.2.2.1+ ,
2.2.2.1 Active
2.2.2.1 Inactive
2.2.2.1 Unavail
2.2.1 )
2.2.1 SUBSYS? (
2.2.2.1+ ,
2.2.2.1 Active
2.2.2.1 Inactive
2.2.2.1 Unavail
2.2.1 )
2.1 )
LIST
Controls which items appear in the subsystem selection list. FM/Db2 scans the sub-system vector table of the operating system when preparing the subsystem selection list. All Db2® systems found are considered eligible for inclusion on the subsystem selection list. If a Db2® system is not defined to z/OS® it will not appear in the sub-system vector table and will therefore not appear in the FM/Db2 sub-system selection list, even if there is an FMN2SSDM macro entry for it.
ALL
All eligible (see above) subsystems and group identifiers defined in the FMN2SSDM macro appear in the subsystem selection list, with the exception of any entries specified DISPLAY=HIDDEN in the FMN2SSDM macro. The default is LIST=ALL.
ACTIVE
Restricts the subsystem selection list to active Db2® subsystems and data sharing groups (on the local z/OS® system).
GROUP
Lists Db2® group entries. If no parameters are specified on the GROUP option, all Active, Inactive, and Unavailable group entries are listed. To select groups in a specific status, provide one or more parameters for the GROUP option. You can specify any combination of Active, Inactive and Unavailable. If more than one parameter is specified, separate them with a comma. The parameters may be abbreviated to A, I, or U respectively.

If SUBSYS is specified, but GROUP is not, no Db2® data sharing group items will appear on the subsystem selection list.

SUBSYS
Lists Db2® subsystem entries. If no parameters are specified on the SUBSYS option, all Active, Inactive, and Unavailable subsystem entries are listed. To select subsystems in a specific status, provide one or more parameters for the SUBSYS option. You can specify any combination of Active, Inactive and Unavailable. If more than one parameter is specified, separate them with a comma. The parameters may be abbreviated to A, I, and U respectively.

If GROUP is specified, but SUBSYS is not, no Db2® subsystems will appear on the subsystem selection list.

Some explanatory information

The following information is provided to assist you in understanding why items appear on the FM/Db2 subsystem selection list. It is not necessary to change the entries in member IEFSSNxx.

Db2® systems are defined to z/OS® using entries in member IEFSSNxx in SYS1.PARMLIB. Here are three examples:
SUBSYS SUBNAME(DFB2) INITRTN(DSN3INI) INITPARM('DSN3EPX,-DFB2,S')      ◄1
SUBSYS SUBNAME(DFA2) INITRTN(DSN3INI) INITPARM('DSN3EPX,-DFA2,S,DFA2') ◄2
SUBSYS SUBNAME(DFS2) INITRTN(DSN3INI) INITPARM('DSN3EPX,-DFS2,S,DFG2') ◄3

1 defines a Db2® subsystem DFB2 that is not part of a Db2® data sharing group.

2 defines a Db2® subsystem DFA2 that is also part of a Db2® data sharing group. The data sharing group is also called DFA2.

3 defines a Db2® subsystem DFS2 that is also part of a Db2® data sharing group. The data sharing group name is DFG2.

1 generates a single item on the FM/Db2 subsystem selection list. The corresponding FMN2SSDM macro entry should specify:
FMN2SSDM  SSID=DFB2,TYPE=SUBSYS, ...
2 and 3 generate two items each on the FM/Db2 subsystem selection list. For 2, the corresponding FMN2SSDM macro entries are:
FMN2SSDM  SSID=DFA2,TYPE=SUBSYS, ...
FMN2SSDM  SSID=DFA2,TYPE=GROUP, ...
For 3, the required FMN2SSDM macro entries are:
FMN2SSDM  SSID=DFS2,TYPE=SUBSYS, ...
FMN2SSDM  SSID=DFG2,TYPE=GROUP, ...

Note that when Db2® system DFA2 is active, Db2® group DFA2 is also active. Similarly when Db2® system DFS2 is active, Db2® group DFG2 is also active. This occurs regardless of whether Db2® data sharing groups DFA2 and DFG2 has been completed implemented or not. From the perspective of z/Os, definitions 2 and 3 in IEFSSNxx are all that is required to define the Db2® data sharing groups DFA2 and DFG2.

In the situation where a Db2® subsystem and Db2® group have the same name (for example, 2), you can hide one of the entries using DISPLAY=HIDDEN on the corresponding FMN2SSDM macro definition. You can also use the SUBSYS or GROUP options to show only subsystems or groups, respectively, although the latter method applies to every subsystem or group.

For example, to show the group DFA2 but not the subsystem DFA2, the FMN2SSDM macro entries are:
FMN2SSDM SSID=DFS2,TYPE=SUBSYS,DISPLAY=HIDDEN
FMN2SSDM SSID=DFG2,TYPE=GROUP, ...