Adding commands to start FM/Db2 functions from the Db2® Administration Tool

You can add one or more line commands to start the FM/Db2 editor and other FM/Db2 functions to the list of line commands that may be issued against a list of Db2® objects in Db2® Admin Tool. See the DB2 Administration Tool for z/OS User's Guide and Reference, Chapter 2 for a detailed description of how to do this. One reason to do this is to allow the FM/Db2 editor to be invoked for a Db2® object (table, view or alias) that appears in an Admin Tool object list.

You need to complete the following tasks:

  1. Locate the sample exec FMN2ADLC (distributed in FMN.SFMNSAM1).
  2. Review the codes and descriptions in the sample exec. You can change the line command code or description if required. Be careful to avoid conflicts with any existing line command codes in the Admin Tool table.
  3. Follow the directions in the DB2 Administration Tool for z/OS User's Guide and Reference to add the commands to the list of available commands for the Admin Tool "Tables, Views and Aliases" display. Be sure to check that the appropriate Admin Tool tables are updated for the various types of tables that may be displayed by Db2® Admin Tool. See the DB2 Administration Tool for z/OS User's Guide and Reference.
  4. Copy FMN2ADIE to a library that is allocated to SYSEXEC DD NAME when the Db2® Admin Launchpad is active. This could be the SADBEXEC library.
  5. In your copy of FMN2ADIE, change the names for the File Manager libraries in the following statements to the appropriate values, if you are not using the default values.
    sfmnexec = "'FMN.SFMNEXEC'"
sfmnllib = "'FMN.SFMNMOD1'"
sfmnmlib = "'FMN.SFMNMENU'"
sfmnplib = "'FMN.SFMNPENU'"
sfmnslib = "'FMN.SFMNSLIB'"
sfmntlib = "'FMN.SFMNTENU'"
Note:
  1. These instructions assume you will run FM/Db2 using LIBDEF/ALTLIB statements to allocate the File Manager application libraries.
  2. If all the File Manager application libraries are available when the Db2® Admin Tool is active, for example, when the libraries have been allocated in the user's TSO logon procedure, you can remove all the statements to assign the File Manager libraries and to initiate and terminate the LIBDEFs and ALTLIB libraries. In this situation you should copy the sample exec to the File Manager exec (SFMNEXEC) library.
When a File Manager/Db2 function is started via a Db2® Admin Tool line command, the following restrictions apply:
  • You cannot issue a command to change the currently connected Db2® system.
  • You cannot issue Db2® commands.
  • The SQLID used when FM/Db2 is started is the same as the users TSO logon ID, unless modified by a Db2® authorization exit.
  • Exiting the first panel displayed after the Db2® Admin Tool line command is issued returns to the Db2® Admin Tool Object List display. It is not possible to navigate to other parts of File Manager. You can, however, use the pull-down options to perform FM/Db2 functions.