PM61267: TEMPLATES ANL3@ATH AND ANL3@SGN CONTAIN INCORRECT NAMES FOR DSN3SATH AND DSN3SSGN

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Specifying Generic Tables during customization, JCL generated by
  Templates ANL3@ATH and ANL3@SGN specify incorrect member names
  of DSN3@ATH and DSN3@SGN.  Correct names are DSN3SATH & DSN3SSGN
  Additional Issues Addressed:
  2. hqlq.SANLSQL(ANLSTEST) contains DBname ANLDBASE & TSname
     ANLSPACE rather than our suggested default names of SYSTOOLS
     and ANLSPC08.
  3. Panel ANLPPRM1 incorrectly shows:  NLSCODE +OF  and ISPF
     error when changing to +OFF+
  4. Entering C for Cost Report on Panel ANLPLIM1 generates Edit
     Panel ISREFR01 - hlq.ANLCOST.LOG, however, the data cannot
     be edited.
  5. Generate error msg on Panel ANLPFILE if more than one
     Qualifier is specified on the Table qualifier field and
     update the PF1 message to clarify this restriction.
  6. Some parms, including the REPORTS Parm on panel ANLPPRM2
     are not being saved from session to session.
  7. Explaining Select statements from ANLPFILE generates msg:
       ANL2009I Optimizer has transformed query: 100000002.
       Was a Subquery ... now a Join, for your information.
     Although the SQL was transformed, there was no improvement
     made by the transformation to a join.
  

Local fix

• change DSN3@ATH and DSN3@SGN to DSN3SATH and DSN3SSGN.
  &TEMP can be left as is JCL will run successfully.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  *                 All users of SQL Performance Analyzer v4.1.  *
  *                                                              *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  *                      1-Incorrect member names of DSN3@ATH    *
  *                        and DSN3@SGN in each customization    *
  *                        generated templates:                  *
  *                        ANL3@ATH and ANL3@SGN                 *
  *                                                              *
  *                      2-Incorrect DB name ANLDBASE &          *
  *                        TS name ANLSPACE in SANLSQL(ANLSTEST) *
  *                                                              *
  *                      3-Incorrect display value "+OF" for     *
  *                        NLSCODE option.                       *
  *                                                              *
  *                      4-Incorrect panel title "EDIT" is       *
  *                        shown when Cost report is reviewed    *
  *                        under "VIEW" mode.                    *
  *                                                              *
  *                      5-Incorrect message is posted due to    *
  *                        missing validation for Table          *
  *                        Qualifier on panels:                  *
  *                        ANLPFILE and ANLPDBRM                 *
  *                                                              *
  *                      6-REPORTS option is not saved.          *
  *                                                              *
  *                      7-Incorrect ANL2009I message            *
  *                        in Cost report.                       *
  *                                                              *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  Code has been changed to correct this condition.
  

Problem conclusion

• Apply the PTF for problem resolution.
  

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:

  UK82983

Modules/Macros

• ANLCLIMT ANLDPRM  ANLEEE   ANLGPRM  ANLMAIN
  ANLPDBRM ANLPFILE ANLPHU17 ANLPH411 ANLPPRM1 ANLPRCC  ANLPRCR
  ANLPREC  ANLPRER  ANLPVIEW ANLQMF   ANLSQLPA ANLSTEST ANLTSO
  ANL03    ANL3@ATH ANL3@SGN
  

Fix information

• Fixed component name

  DB2 SQL PERF AN

• Fixed component ID

  5697F5701

Applicable component levels

• R410 PSY UK82983

     UP12/10/31 P F210

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.