IBM Support

PI86482: ADD IN DATABASE CLAUSE TO CREATE TABLE FOR AN AOT THROUGH SAVE DATA, RUN QUERY WITH THE TABLE KEYWORD OR IMPORT TABLE.

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as new function.

Error description

  • Add IN DATABASE clause to CREATE TABLE for an AOT through SAVE
    DATA, RUN QUERY with the TABLE keyword or IMPORT TABLE.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All QMF for TSO/CICS V11.2 and V12.1 users   *
    *                 creating accelerator-only tables.            *
    ****************************************************************
    * PROBLEM DESCRIPTION: When creating accelerator-only tables   *
    *                      (AOTs) through the SAVE DATA, IMPORT    *
    *                      TABLE or RUN QUERY commands, users are  *
    *                      unable to specify a database. QMF is    *
    *                      creating all accelerator-only tables in *
    *                      the default DB2 database. When creating *
    *                      AOTs, QMF does not reference the SPACE  *
    *                      profile parameter and is not using the  *
    *                      IN DATABASE clause to create AOTs.      *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    This APAR adds a new global variable called DSQEC_SAV_ACCELDB.
    When set,DSQEC_SAV_ACCELDB will specify a database name in which
    QMF will create AOTs when processing the SAVE DATA, IMPORT TABLE
    or RUN QUERY commands.DSQEC_SAV_ACCELDB may be set to a database
    name up to 8 bytes in length.When a non blank value is detected,
    QMF will create AOTs using the IN DATABASE clause and specify
    the name of the database specified in the DSQEC_SAV_ACCELDB
    global variable. When DSQEC_SAV_ACCELDB is blank, QMF will not
    append the IN DATABASE clause when creating AOTs and the AOT
    will be defined in the default DB2 database. The default is
    blank.
      Example:
      SET GLOBAL (DSQEC_SAV_ACCELDB=DBFORACC)
    Note that when creating accelerator-only tables, QMF does not
    reference the Q.PROFILES.SPACE parameter. Applying this fix
    will not change the behavior of existing procedures creating
    AOTs. Leaving global variable DSQEC_SAV_ACCELDB blank will
    retain the behavior prior to this fix.
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    PI86482

  • Reported component name

    QMF-QUERY MGMT

  • Reported component ID

    566872101

  • Reported release

    B20

  • Status

    CLOSED UR1

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2017-08-28

  • Closed date

    2017-09-01

  • Last modified date

    2017-10-02

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

    UI50027 UI50028

Modules/Macros

  •    DSQCGVSI DSQCRSNC DSQCSETS DSQDGVVI DSQDSET
    DSQIISQL
    

Fix information

  • Fixed component name

    QMF-QUERY MGMT

  • Fixed component ID

    566872101

Applicable component levels

  • RB20 PSY UI50027

       UP17/09/06 P F709

  • RC10 PSY UI50028

       UP17/09/06 P F709

Fix is available

  • Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.

[{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SSCWRCK","label":"QMF for TSO\/CICS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.2","Edition":"","Line of Business":{"code":"LOB35","label":"Mainframe SW"}}]

Document Information

Modified date:
02 October 2017