PH62666: TCZ FAILED FOR SQL PA LIBRARIES WITH LONG NAMES

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• While generating the jobs, getting Template Error - CCQC024S
  ISPF file tailoring failed for "ANLICRE8" template in the
  "'DB2SYSD.DB2TOOLS.DSYS.SQLANL.SANLDENU'" metadata library.
  

Local fix

• Change HLQ length to have less than 23 characters.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 SQL Performance Analyzer        *
  ****************************************************************
  * RECOMMENDATION: Apply the PTF                                *
  ****************************************************************
  1) Problem encountered while customer used the long name of HLQ
  library during Tcz installation.
  2) Problem encountered after entering an incorrect value of
  secondary user ID for the 'New DB2 SQL authorization ID',
  available user ID could not be set up.
  

Problem conclusion

• 1) Allowed use of long names for HLQ library.
  2) Fixed the problem with processing entering an incorrect value
  of secondary user ID for the 'New DB2 SQL authorization ID'.
  The available generic user ID can now be set up.
  

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:

  UI99071

Modules/Macros

• ANLCSQLI ANLICRE8
  

Fix information

• Fixed component name

  DB2 SQL PERF AN

• Fixed component ID

  5697F5701

Applicable component levels

• R510 PSY UI99071

     UP24/11/22 P F411

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.