PH24045: ANLPQBR1 - LINE COMMANDS DO NOT WORK WHEN DOING EXPLAIN TO A REMOTE LOCATION

APAR status

• Closed as program error.

Error description

• Line commands do not work when doing Explain to a remote
  location
  

Local fix

Problem summary

• 1.Not showing correct information about indexes for remote
  location;
  2.Not possible to use two version of SQLPA
  in one DB2 ;
  3.Is showed ANL2021W message even if
  VERSION parameter is correct.
  

Problem conclusion

• Code logic was corrected to fix the issues described.
  
  Search Keywords:
  Incorrect information about indexes for remote location.
  

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:

Modules/Macros

• ANLBATCH ANLBPAM  ANLCAT   ANLCHECK ANLCLOB  ANLCONV  ANLCSV
  ANLDB2X  ANLDPRM  ANLEEE   ANLGPRM  ANLGPST  ANLMAIN  ANLNUXD
  ANLPDBRM ANLPFILE ANLPICP  ANLPIDD  ANLPIQLR ANLPITP  ANLPLAN
  ANLPLIN  ANLPPKGE ANLPRCR  ANLPRER  ANLPTCM  ANLPTEX  ANLPTLD
  ANLPTRP  ANLPTSM  ANLQMF   ANLSERV  ANLSQ2M  ANLSQLPA ANLTABS
  ANLTOHEX ANLTSO   ANLUNIC  ANLUOPT  ANLVER8  ANLWIF   ANLWIFF
  

Fix information

• Fixed component name

  DB2 SQL PERF AN

• Fixed component ID

  5697F5701

Applicable component levels