PH63437: FORMAT THE SQL STATEMENT UNDER TSO/ISPF

Obtain the fix for this APAR.

APAR status

• Closed as unreproducible in next release.

Error description

• Format the SQL statement under TSO/ISPF using ADB2FMP stored
  procedure
  

Local fix

• BYPASS/CIRCUMVENTION:
  NA
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of IBM Db2 Query Monitor               *
  ****************************************************************
  * RECOMMENDATION: Apply the PTF                                *
  ****************************************************************
  View formatted SQL statements under TSO/ISPF using the new SF
  and VF commands.
  These line commands invoke the Db2 Administration Tool stored
  procedure ADB2FMP.
  

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:

Modules/Macros

• CQM      CQM#DRVX CQM#QAPI CQM#QAPX CQM#QSQL CQM$$PRM CQM$ACTV
  CQM$ADM1 CQM$ADMN CQM$CALL CQM$FLTU CQM$LC01 CQM$LC02 CQM$LC05
  CQM$LC21 CQM$LINK CQM$LNCD CQM$MAIN CQM$OPTN CQM$SLIP CQM$SM01
  CQM$SQC6 CQM$SQC7 CQM$SQC8 CQM$SQC9 CQM$SQCE CQM$SQCL CQM$SQLT
  CQM$TEXT CQM$XQVE CQM07    CQM077E  CQM079E  CQM10    CQM14
  CQM17    CQM172E  CQM26    CQM27    CQM29    CQM292E  CQM86
  CQM862E  CQM863E  CQM@FTXT CQMBIND  CQMBLOB  CQMC2LST CQMCFPAX
  CQMCLIST CQMCLST1 CQMCPXPT CQMHACTA CQMHCALL CQMHEXCA CQMHLCXX
  CQMHOPTN CQMHSUCT CQMHSUMB CQMHSUMC CQMHSUMJ CQMHSUMK CQMHSUML
  CQMHSUMP CQMHSUMT CQMHSUSP CQMJAR   CQMPIKEY CQMPRKEY
  

Fix information

• Fixed component name

  DB2 QUERY MONIT

• Fixed component ID

  5655E6701

Applicable component levels

• R340 PSY UI98883

     UP24/10/31 P F410

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.