A fix is available
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
SC32126403 | SC32126404 | SC32126405 | SC32126406 |
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