Skip to main content

Support & downloads  >  

Key prerequisites for using Optimization Service Center for DB2 for z/OS

 Preventive Service Planning
 
Abstract
Key prerequisites for using Optimization Service Center for DB2® for z/OS® with DB2 for z/OS Version 8 and DB2 Version 9.1 for z/OS
 
Content
The following are the key prerequisites for using Optimization Service Center for DB2 for z/OS Version 1.1 Fixpack 7 with DB2 Version 9.1 for z/OS and DB2 for z/OS Version 8:
  • PUT level 0907
  • Additional required PTFs
    The following table contains the prerequisite PTFs for using Optimization Service Center for DB2 for z/OS Version 1.1 Fixpack 7 with DB2 Version 9.1 for z/OS® and DB2 for z/OS® Version 8 subsystems:

    APARVersion 9.1 PTFVersion 8 PTFDescription
    PK88859UK49846 n/aUNDER V8 NFM AND V9 CM USING OPTHINT(' ') DIFFERENCE IS V8 OPTHINT IS NOT FOUND BUT V9 IS FULLY APPLIED
    PK88058UK50401 n/aABEND0C4 RC38 DSNXOGP +F294 WHEN A READ ONLY CURSOR IS DEFINED WITH THE FOR UPDATE CLAUSE 09/07/10 PTF PECHANGE
    PK88228UK50414n/aSYSPACKSTMT EXPLAINABLE ='N' AND PLAN_TABLE NOT POPULATED WHEN EXPLAINING TRIGGER WHICH CONTAINS SET CLAUSE
    PK76750n/aUK49928SYSIBM.SYSPACKSTMT EXPLAINABLE ='N' AND NOT POPULATED PLAN_TABLEWHEN EXPLAIN A TRIGGER WHICH CONTAINS SET CLAUSE
    PK89202UK48714UK48715ORDER BY MAY NOT PRODUCE THE CORRECT ORDER WHEN THE QUERY CONTAINS THE RANK FUNCTION
    PK86418UK48564n/aSQL -20248 CAN OCCUR ON EXPLAIN STMTCACHE WHEN TRUSTED CONTEXT IS NOT CONSIDERED

    Additional PTFs required for server-side enablement
    The following table contains PTFs that update DBRMs, JCL jobs and stored procedures that are required for server-side enablement of DB2 Version 9.1 for z/OS® and DB2 for z/OS® Version 8 subsystems:
    APARVersion 9.1 PTFVersion 8 PTFDescription
    PK95645UK50977UK50977VARIOUS OPTIMIZATION SERVICE CENTER FIXES AND ENHANCEMENTS.
    PK96728 UK50979UK50978VARIOUS OPTIMIZATION SERVICE CENTER FIXES AND ENHANCEMENTS
    (PART 2)
    PK96729 UK50980VARIOUS OPTIMIZATION SERVICE CENTER FIXES AND ENHANCEMENTS
    (PART 3)
 
 
Cross Reference information
Segment Product Component Platform Version Edition
Data & Information ManagementDB2 for z/OS z/OS9.0All Editions
 
 

Copyright and trademark information
IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.
Rate this page
Please take a moment to complete this form to help us better serve you.
This material provides me with the information I need.




This material is clear and easy to understand.




Did the information help you to achieve your goal?
What updates, improvements, or related information would you like to see in this document?
Your response will be used to improve our document content. Requests for assistance, if applicable, should be submitted through your normal support channel as we cannot respond from this site.
Input the verification number to submit feedback:
Document information
 Product categories:
 Software
 Data Management
 Data Servers (Database Management Systems)
 DB2 for z/OS
 Operating system(s):
  z/OS
 Software version:
  8.0, 9.1
 Reference #:
  1264809
 IBM Group:
 Software Group
 Modified date:
 2009-10-29

Translate My Page
 
 

Rate this page

Help us improve this page. Your response will be used to improve our document content. Requests for assistance, if applicable, should be submitted through your normal support channel as we cannot respond from this site.