PH64375: POSSIBLE ISPF ERROR WHEN OPENING "SPECIFY SQL OUTPUT" PANEL

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When user specifies "Specify SQL Output" = Y, the next panel
  halts due with a message ISPP290 incorrect EXPAND designation.
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Log Analysis Tool for z/OS      *
  ****************************************************************
  * PROBLEM DESCRIPTION: 1.Fixed possible allocation LOADFILE DD *
  *                        with 65535 TRACKS in ALACLDEL.        *
  *                      2.Fixed possible S0C4 in                *
  *                        ALASUBGC.ALAALOG.                     *
  *                      3.Possible ISPF error when opening      *
  *                        "Specify SQL Output" panel.           *
  *                      4.Fixed possible incorrect FRMTFILE     *
  *                        sorting in 1PH-64 mode with UOW       *
  *                         commit scope.                        *
  *                      5. Fixed output of the ALAA576E error   *
  *                         message.                             *
  *                      6. Fixed possible error on binary       *
  *                         conversion of NULL value for         *
  *                         BINARY/VARBINARY.                    *
  *                      7. Fixed possible S0C4 in ALADTL2.      *
  *                      8. Fixed possible S0C4 in               *
  *                       ALASUBC.ALAGLF2 on building index for  *
  *                         filters.                             *
  *                      9. Fixed possible skip of the full IC   *
  *                        after processing incremental IC.      *
  ****************************************************************
  * RECOMMENDATION: Apply PTF                                    *
  ****************************************************************
  PE fixer for PH64115
  

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:

  UI99294

Modules/Macros

• ALA0PCNF ALA0PNL  ALA@FSP  ALAAA11  ALAAA18  ALAAA3C  ALAAA9
  ALAADSLP ALAADSNP ALAALOG  ALAARCH  ALAARCPN ALAARDCU ALAARDDO
  ALAARDRT ALAARDUW ALAASQCM ALAATVI  ALAAUDPN ALABSQL  ALACADMN
  ALACCFG  ALACCORD ALACLDEL ALACQT   ALACUOW6 ALADATA  ALADDM
  ALADIN   ALADLMPN ALAERR   ALAFCFG  ALAFLADV ALAFLOBI ALAFLOBN
  ALAFMAIN ALAFR1CX ALAFRC8  ALAFRCA  ALAFRCCM ALAFRCOL ALAFRCQS
  ALAFRCRV ALAFRDTL ALAFRETV ALAFRFLA ALAFRFLO ALAFRGNR ALAFRJSN
  ALAFRLAP ALAFRLCV ALAFRMFC ALAFRMTR ALAFRPGS ALAFRPIE ALAFRPMA
  ALAFRPMC ALAFRSL  ALAFRSP  ALAFRTCV ALAFRTP1 ALAFRTSC ALAFRTVB
  ALAFRTVI ALAFRTVS ALAFRUT  ALAGEN1  ALAGFLT  ALAGIC   ALAGNJCL
  ALAHDR   ALAHDRPN ALAHLP1  ALAJSDEF ALAJSON  ALAJSONO ALAJSONW
  ALALCOPN ALALDCR  ALALDDSN ALALDPN  ALALDST  ALALEOPN ALALF1
  ALALFCPN ALALIN   ALALOG   ALALOPT  ALAMAIN  ALAMFLTR ALAMFOPN
  ALAMNTRP ALAMODEF ALAMPNL  ALAMSGPN ALAPOPUP ALAQGLPN ALAQGRPN
  ALAQGSPN ALAQMAIN ALAQSPN  ALAQTRP  ALASETWN ALASFREX ALASQLER
  ALASRCTB ALATICS  ALATIME  ALAVLXPN ALAXUTIL ALAZHSWN
  

Fix information

• Fixed component name

  DB2 LOG ANALYSI

• Fixed component ID

  5655E6601

Applicable component levels

• R350 PSY UI99294

     UP24/12/07 P F412 {

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.