PH69990: ROLL UP PTF OF MISCELLANEOUS INTERNAL FIXES

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• This PTF fixes the following internal issues:
  1) Eliminates the possibility of a REORG TS utility being
  generated via a Job Build for a Db2 object created with HASH
  access when copy options are set to NO.
  Hash Access objects require SHRLEVEL REFERENCE or SHRLEVEL
  CHANGE. These options require a Copy DD or template. If no Copy
  DD exists at run time,
  REORG will be turned off for these objects. This fix adds a new
  BUILD message:
  	DAJB565W TS dbname spacename partition REORG TS turned off for
  this Hash Access object. Hash Access objects require a COPY DD
  or template.
  2) Miscellaneous TCz HELP text issues as defined below:
  	CCQPDB2 - HELP text for field "*Utility region size field"
  contains typo ("vlaue")...should be "value".
  	CCQPDB2 - HELP text for field "*Enable administrative task
  scheduler support" contains typo ("vlaue")...should be "value".
  	CCQPPRD - HELP text for field "* Execute repository changes"
  contains text about "preview file" - which is invalid, since DAJ
  TCz does not generate a preview job for DDL execution. The DDL
  job that is generated is an "execute" job only.
  3)  TCz CCQPPRD: Change Default Creator for "Sample profile
  creator name" field to "DAJSAMPL"
  
  4) Eliminate DEBUG messaging displayed during REORG Avoidance
  processing
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: ALL Users                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: This PTF fixes the following internal   *
  *                      issues:                                 *
  *                                                              *
  *                      1) Eliminates the possibility of a      *
  *                      REORG TS utility being generated via a  *
  *                      Job Build for a Db2 object created with *
  *                      HASH access when copy options are set   *
  *                      to NO. Hash Access objects require      *
  *                      SHRLEVEL REFERENCE or SHRLEVEL CHANGE.  *
  *                      These options require a Copy DD or      *
  *                      template. If no Copy DD exists at run   *
  *                      time, REORG will be turned off for      *
  *                      these objects. This fix adds a new      *
  *                      BUILD message:                          *
  *                                                              *
  *                      DAJB565W TS dbname spacename partition  *
  *                      REORG TS turned off for this Hash       *
  *                      Access object. Hash Access objects      *
  *                      require a COPY DD or template.          *
  *                                                              *
  *                      2) Miscellaneous TCz HELP text issues   *
  *                      as defined below:                       *
  *                                                              *
  *                      CCQPDB2 - HELP text for field "*Utility *
  *                      region size field" contains typo        *
  *                      ("vlaue")...should be "value".          *
  *                                                              *
  *                      CCQPDB2 - HELP text for field "*Enable  *
  *                      administrative task scheduler support"  *
  *                      contains typo ("vlaue")...should be     *
  *                      "value".                                *
  *                                                              *
  *                      CCQPPRD - HELP text for field "*Execute *
  *                      repository changes" contains text about *
  *                      "preview file" - which is invalid,      *
  *                      since DAJ TCz does not generate a       *
  *                      preview job for DDL execution. The DDL  *
  *                      job that is generated is an "execute"   *
  *                      job only.                               *
  *                                                              *
  *                      3)  TCz CCQPPRD: Change Default Creator *
  *                      for "Sample profile creator name" field *
  *                      to "DAJSAMPL"                           *
  *                                                              *
  *                      4) Eliminate DEBUG messaging displayed  *
  *                      during REORG Avoidance processing       *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF                                *
  ****************************************************************
  .
  

Problem conclusion

Temporary fix

Comments

APAR Information

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

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

  UO06798

Modules/Macros

• DAJ#EPRI DAJ#UTED DAJ$$PRM DAJ$$SEQ DAJ$BMSG
  

Fix information

• Fixed component name

  AUTOMATION EXPE

• Fixed component ID

  5698DAE00

Applicable component levels

• R110 PSY UO06798

     UP26/02/18 P F602

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.