DB2 graphic  QMF Version 8

Activating the enhanced object list

The enhanced object list allows users to list DB2 tables that belong to group IDs, tables that are owned by the user, and tables available for public viewing. In this case, table privileges are granted to group, rather than user, IDs. Any user who can access these group IDs or secondary authorization IDs have the privileges.

You must install and activate a User Defined Function (UDF) supplied by QMF to use the enhanced object list. The UDF must be installed into a DB2 UDB for OS/390 V6 or later database. To install and activate the enhanced object list, do the following steps:

  1. Set up the environment for UDFs. This involves setting up and maintaining the environment for DB2 stored procedures and UDFs in WLM-established address spaces. A system administrator usually performs this step. Read the DB2 UDB for z/OS documentation for more information on setting up the WLM-established address space for DB2 stored procedures and UDFs.
  2. Add the QMF program DSQABA1E to the WLM-established address space that will execute the QMF-supplied UDF. DSQABA1E resides in the QMF load library QMF810.SDSQLOAD. Copy the DSQABA1E member from SDSQLOAD into a load library in the STEPLIB concantenation for the WLM-established stored procedure address. This is the STEPLIB concantenation defined in the JCL PROC used to start the address space.
  3. Get the name of the WLM environment where the QMF-supplied UDF will run. This is specified by the APPLENV= parm of the JCL PROC used to start the WLM environment; it is required to complete the next step. When the DB2 installer specifies Option 6, WLM Environment, on the DB2 install panel DSNITIPX, DB2 assumes a default. This is recorded as ZPARM "WLMENV" in macro DSN6SYSP and is listed prominently in the DB2 Install Job Stream DSNTIJUZ.
  4. Define the QMF UDF to DB2. This is a registration activity which is performed by running the QMF-supplied job DSQ1BUDF located in the QMF810.SDSQSAPE library. This job issues an SQL CREATE FUNCTION statement and grants execution privileges. You may need to tailor job DSQ1BUDF prior to running it.
  5. Test the registration. Verify that all the previous steps were successful before changing the QMF List view in the next step. To test the registration, start QMF or SPUFI and run the following SQL:
    SELECT U.AUTHNAME FROM TABLE( Q.APPL_AUTHNAMES( 'PUBLIC "PUBLIC*"' )) U

    The result should be a list of valid authorization names for the user who is executing the SQL statement above. Here is an example of how it might look:

    AUTHNAME
    --------
    W397754
    #DQZA
    #J49A
    DB2FUNC
    QMFDEV
    PUBLIC
    PUBLIC*
  6. Change the QMF list view to execute the QMF UDF. Run QMF-supplied job DSQ1BUDV located in the QMF810.SDSQSAPE to change the view.
  7. (Optional) If you tailored the IBM-supplied tables view, read the following SELECT statement which has been modified to use the QMF-supplied UDF. This example will help you in modifying your customized view:
    SELECT T.CREATOR, T.NAME,...
       FROM SYSIBM.SYSTABLES T
       ,( SELECT DISTINCT TA.TCREATOR. TA.TTNAME
            FROM SYSIBM.SYSTABAUTH TA
          WHERE TA.GRANTEETYPE=' '
            AND TA.GRANTEE IN
              ( SELECT U.AUTHNAME
                       FROM TABLE( Q.APPL_AUTHNAMES( 'PUBLIC 
                         "PUBLIC*"' )) U
                ) AS UAT ("CREATOR", "NAME")
                  WHERE T.CREATOR=UAT.CREATOR AND
                   T.NAME=UAT.NAME AND T.TYPE 
                   IN ('T', 'V')

Follow the job sequence in the table below to install an Enhanced List view into a QMF V8.1 Compatibility or New Function mode for DB2 UDB for z/OS server V8.1

Table 30. Job sequence to install Enhanced List View
Job name Purpose
DSQ1BSQL Binds the install programs to the current server
DSQ1BUDF Creates the Enhanced QMF List View Function
DSQ1BUDV Creates Enhanced QMF List Views

If the Enhanced List View does not function like you want it to, run job DSQ1BVW to restore the QMF default List Views.

QMF users periodically need to list objects they have saved in the database or to view comments that show them what purpose a table serves or what type of data a column in the table contains. The QMF LIST and DESCRIBE commands perform these functions.

When a user issues a LIST or DESCRIBE command for a table, QMF uses a view defined on a set of DB2 catalog tables to obtain information about the table. The name of this view is stored in the global variables DSQEC__TABS__LDB2, DSQEC__TABS__RDB2, or DSQEC_TABS_SQL. When users issue these commands for a column within a table, QMF uses the global variables DSQEC__COLS__LDB2, DSQEC__COLS__RDB2, or DSQEC_COLS_SQL to obtain the name of the view.

QMF provides a set of default views, loaded during installation, that return only the tables and column information the user is authorized to see. Because processing for authorization takes extra time and resources, QMF also allows you to customize the table lists and column information by creating your own views.


Go to the previous page Go to the next page

Downloads | Library | Support | Support Policy | Terms of use | Feedback
Copyright IBM Corporation 1982,2004 Copyright IBM Corporation 1982, 2004
timestamp Last updated: March, 2004