PK20472: ON THE SQL PA EASY EXPLAIN ( EEE ) MAIN MENU ( PANELID EEE ) HIT PF1 HELP GET ISPP100 PANEL "DSN6SP1 " ERROR. PANEL NOT FOUND.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• SQLPA V220. When on the EEE main menu (panelid EEE) hit the
  PF1 key for help receive instead the following message:
  ISPP100  Panel "DSN6SP1 " error.  Panel not found. 05007
  ***
  PTF2206
  

Local fix

• ADDITIONAL SYMPTOMS:
  1) High level qualifier (QUALIFY parm) is NOT inserted where
  table name is unqualified, for example on the first outer
  join, but is inserted for other unqualified tables,
  resulting in -204 errors. SQLCODE204 204 ( 71114 )
  2) Host Variable substitution with parameter marker overlays
  right parentheses if no intervening space is found after :H,
  when SQL source is file input (not DBRM). This includes
  SQL passed from DB2 Admin Tool, etc. ( 34921 92020 ).
  
  3) High level qualifier (QUALIFY parm) is inserted where table
  name already fully qualified, but ignored on subsequent table
  name, results in erroneous SQLCODE -512 or -204. ( 92025 )
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  4) When using EXPLAIN OLD, some plan steps containing sorts
      method = 3) or multi index combinations (MU, MI) don't
      have corresponding Statistics records to match up with, so
      Explain Old is failing with error code ANL3000E.
      MSGANL3000E ( 58795 )
  5) When using EXPLAIN OLD, some plan steps containing multiple
     index access do not have proper estimate of the number of
     rows returned, resulting in division by zero error 320,
     ANL3030E. ( 58480 )
  6) HLQ inserts fail for synonyms resulting in:
     DSNT408I SQLCODE = -204
     DSNT418I SQLSTATE = 42704 SQLSTATE RETURN CODE ( 74080 )
     ( 62929 )
  7) Using SQLPA R220 interactively under TSO / ISPF
     receive MSGANL3003W ANL3003W repeatedly if the
     user did not define the ANLREP file for the report
     output. USER TSO session loops loop on ANL3003W. ( 87723 )
  8) If a SELECT to be explained contains more than one
     LEFT OUTER JOIN and the tables in the select are not
     qualified,then SQLPA only adds the default qualifier
     to the FIRST left outer join and leaves it off all
     the others. ( 07857 )
     High level qualifier (QUALIFY parm) is NOT inserted where
  table name is unqualified, for example on the first outer
  join, but is later inserted for other unqualified tables,
  resulting in SQLCODE -204 errors. ( 07857 )
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 SQL Performance Analyzer.       *
  ****************************************************************
  * PROBLEM DESCRIPTION: 1. When on the EEE main menu (panelid   *
  *                      EEE) if user presses the PF1 key for    *
  *                      help they may receive instead the       *
  *                      following message:                      *
  *                      ISPP100  Panel "DSN6SP1 " error. Panel  *
  *                      not found. New help panels have been    *
  *                      added for Easy Explain. (PMR05007)      *
  *                      2. High level qualifier (QUALIFY parm)  *
  *                      is NOT inserted where table name is     *
  *                      unqualified following SELECT INTO       *
  *                      :Host variables. For example, if the    *
  *                      first outer join follows Select Into    *
  *                      it does not Get qualified, but the HLQ  *
  *                      inserted for other unqualified tables,  *
  *                      resulting in SQLCODE -204 ( PMR71114 )  *
  *                      3. Host Variable substitution with      *
  *                      parameter marker overlays right         *
  *                      parenthesis if no intervening space     *
  *                      was found after :H, when SQL            *
  *                      source is file input (not from DBRM).   *
  *                      This includes SQL passed from DB2       *
  *                      Admin, etc. ( PMR34921, PMR92020 )      *
  *                      4. High level qualifier (QUALIFY parm)  *
  *                      is inserted where first table name is   *
  *                      already fully qualified, but ignored    *
  *                      on subsequent table names, resulting    *
  *                      in erroneous SQLCODE -512 or -204.      *
  *                      ( PMR92025 )                            *
  *                      5. When using EXPLAIN OLD, some plan    *
  *                      steps containing sorts (method = 3) or  *
  *                      multiple index combinations (MU, MI)    *
  *                      do not have corresponding Statistics    *
  *                      records to match up with, and the       *
  *                      Explain Old is failing with error       *
  *                      Message ANL3000E.                       *
  *                      ( PMR58795 )                            *
  *                      6. When using EXPLAIN OLD, some plan    *
  *                      steps containing multiple index access  *
  *                      do not have proper estimate of the      *
  *                      number or rows returned, resulting in   *
  *                      division by zero error 320, and error   *
  *                      Message ANL3030E. ( PMR58480 )          *
  *                      7. HLQ inserts fail for synonyms        *
  *                      resulting in:                           *
  *                       DSNT408I SQLCODE = -204                *
  *                       DSNT418I SQLSTATE = 42704 SQLSTATE     *
  *                       RETURN CODE                            *
  *                       ( PMR74080, PMR62929 )                 *
  *                      8. Using SQLPA interactively under      *
  *                      TSO / ISPF and ignoring   report        *
  *                      definitions users may receive Message   *
  *                      ANL3003W repeatedly if the user did     *
  *                      not define the ANLREP file for the      *
  *                      output. USER TSO session loops on       *
  *                      ANL3003W. ( PMR87723 )                  *
  *                      9. If a SELECT to be explained          *
  *                      contains more than one LEFT OUTER JOIN  *
  *                      and the tables in the Select are not    *
  *                      qualified, then SQLPA only adds the     *
  *                      default qualifier to the FIRST left     *
  *                      outer join and may not qualify the      *
  *                      other the joined tables. ( PMR07857 )   *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  Code has been changed to correct this condition.
  

Problem conclusion

• APPLY the PTF.
  

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:

  UK13425

Modules/Macros

• ANL@DSN  ANLALL   ANLEH01  ANLEH01A ANLEH01B
  ANLEH011 ANLEH012 ANLEH013 ANLEH014 ANLEH015 ANLEH016 ANLEH017
  ANLEH018 ANLEH019 ANLLOGO  ANLPGME7 ANLPGME8 EEE      EEEB
  EEEE
  

Fix information

• Fixed component name

  DB2 SQL PERF AN

• Fixed component ID

  5697F5701

Applicable component levels

• R220 PSY UK13425

     UP06/04/13 P F604

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.