IBM Support

PM75811: DB2 BIND NOT PERFORMED AT THE END OF THE EQQICNVH JOB.

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • The EQQICNVH step does not perform a BIND at the end.
    
    Doing this would simplify the user instructions as follows:
    
    If this is a new use of the history database, then EQQINIDB is
    run; otherwise, run EQQICNVH.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All TWS for z/OS users running DB2 History.  *
    *                 FUNCTION = HIST                              *
    ****************************************************************
    * PROBLEM DESCRIPTION: The EQQICNVH step does not perform a    *
    *                      BIND at the end.                        *
    ****************************************************************
    * RECOMMENDATION: APPLY THE PTF FIXING THIS APAR               *
    ****************************************************************
    The EQQICNVH sample migrates OPC Operations History DB2 data
    tables.
    At the end of the conversion process, as suggested in the
    publications, a BIND plan  action (as in EQQINIDB sample)
    needs to be performed.
    EQQICNVH is currently missing the BIND step.
    

Problem conclusion

  • The EQQICNVH sample has been enhanced to perform a BIND at the
    end, by adding an additional last step like the one in EQQINIDB.
    This would simplify the user instructions:
    - For a new use of the history database run EQQINIDB
    - For a conversion run EQQICNVH (which now includes BIND action)
    
    THE FOLLOWING TWS FOR ZOS PUBLICATION WILL BE UPDATED:
                             - - -
    +-------------------------------------------------------------+
    |TITLE: Tivoli Workload Scheduler for zOS                     |
    |       Installation and Customization          SC32-1264-03  |
    |-------------------------------------------------------------|
    |Chapter 4. Installing                                        |
    |Paragraph: "Step 11. Creating the DB2 database"              |
    |Section:   "Sample to migrate the history database"          |
    |                                                             |
    |Add a new step item after "6 RESET" description              |
    | "7. BIND                                                    |
    |  BINDs the DB2 plans, after the conversion, as EQQINIDB.    |
    |                                                             |
    |CHANGE FROM:                                                 |
    | "At the end of the process, you must make a BIND of the new |
    |  version."                                                  |
    |                                                             |
    |TO:                                                          |
    | "At the end of the process, a BIND of the new version is    |
    |  needed. You can use the BIND step provided in the          |
    |  EQQICNVH sample (like the Bind step provided with the      |
    |  EQQINIDB sample)."                                         |
    |-------------------------------------------------------------|
                             - - -
    +-------------------------------------------------------------+
    |TITLE: Tivoli Workload Scheduler for zOS                     |
    |       Installation and Customization          SC32-1264-04  |
    |                                               SC32-1264-05  |
    |-------------------------------------------------------------|
    |Chapter 4. Installing                                        |
    |Paragraph: "Step 12. Creating the DB2 database"              |
    |Section:   "Sample to migrate the history database"          |
    |                                                             |
    |Add a new step item after "6 RESET" description              |
    | "7. BIND                                                    |
    |  BINDs the DB2 plans, after the conversion, as EQQINIDB.    |
    |                                                             |
    |CHANGE FROM:                                                 |
    | "At the end of the process, you must make a BIND of the new |
    |  version."                                                  |
    |                                                             |
    |TO:                                                          |
    | "At the end of the process, a BIND of the new version is    |
    |  needed. You can use the BIND step provided in the          |
    |  EQQICNVH sample (like the Bind step provided with the      |
    |  EQQINIDB sample)."                                         |
    |-------------------------------------------------------------|
                             - - -
    +-------------------------------------------------------------+
    |TITLE: Tivoli Workload Scheduler for zOS                     |
    |       Planning and Intallation                SC32-1266-07  |
    |-------------------------------------------------------------|
    |Chapter 4. Installing                                        |
    |Paragraph: "Step 12. Creating the DB2 database"              |
    |Section:   "Sample to migrate the history database"          |
    |                                                             |
    |Add a new step item after "6 RESET" description              |
    | "7. BIND                                                    |
    |  BINDs the DB2 plans, after the conversion, as EQQINIDB.    |
    |                                                             |
    |CHANGE FROM:                                                 |
    | "At the end of the process, you must make a BIND of the new |
    |  version. You can use the BIND step provided with the       |
    |  EQQINIDB sample."                                          |
    |TO:                                                          |
    | "At the end of the process, a BIND of the new version is    |
    |  needed. You can use the BIND step provided in the          |
    |  EQQICNVH sample (like the Bind step provided with the      |
    |  EQQINIDB sample)."                                          |
    |-------------------------------------------------------------|
    300Y
    500Y
    510Y
    600Y
    EQQICNVH
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM75811

  • Reported component name

    TIV WRKLD SCHD

  • Reported component ID

    5697WSZ01

  • Reported release

    602

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2012-10-24

  • Closed date

    2012-12-06

  • Last modified date

    2013-03-04

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

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

    UK90067 UK90068 UK90069 UK90070

Modules/Macros

  • EQQICNVH
    

Publications Referenced
SC32126403SC32126404SC32126405SC32126406 

Fix information

  • Fixed component name

    TIV WRKLD SCHD

  • Fixed component ID

    5697WSZ01

Applicable component levels

  • R300 PSY UK90067

       UP13/02/09 P F302

  • R500 PSY UK90068

       UP13/02/09 P F302

  • R510 PSY UK90069

       UP13/02/09 P F302

  • R600 PSY UK90070

       UP13/02/09 P F302

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":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSRULV","label":"IBM Workload Scheduler for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"602","Edition":"","Line of Business":{"code":"LOB35","label":"Mainframe SW"}},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"602","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
04 March 2013