PQ96619: EXECTUTING SQLPA BATCH PROGRAM RECEIVED ABEND04E RSC=00C89012 REASON CODE 00C89012

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• RUNNING SQLPA BINDANL INSTALLATION VERIFICATION PROGRAM ( IVP )
  RECEIVED ABEND04E REASON CODE 00C89012.
  ABENDS04E S04E RSC00C89012 RSN00C89012 RC00C89012.
  ABEND OCCURS WHILE SQLPA ATTEMPTS TO PROCESS CCSID UNICODE
  CONVERSION.
  ADDITIONAL SYMPTOMS:
  1) While running program code receive SQLCODE-104
  RSC42704REASON CODE 42704
  DSNXA07 SQLERRD-180
   SQL ERROR DURING EXECUTE IMMEDIATE
  DSNT408I SQLCODE = -204, ERROR:  ANLCAT22 IS AN UNDEFINED NAME
  DSNT418I SQLSTATE   = 42704 SQLSTATE RETURN CODE
  DSNT415I SQLERRP    = DSNXA07 SQL PROCEDURE DETECTING ERROR
  DSNT416I SQLERRD    = -180  0  0  -1  0  0 SQL DIAGNOSTIC
  INFORMATION
  DSNT416I SQLERRD    = X'FFFFFF4C'  X'00000000'  X'00000000'
  X'FFFFFFFF'
  .
  2) SQLPA errors during CCSID UNICODE conversion:
  DSNT408I SQLCODE = -104, ERROR:  ILLEGAL SYMBOL "¬". SOME
  SYMBOLS
        THAT MIGHT BE LEGAL ARE: < > = <> <= &#220;< &#220;> &#220;= >= ^< ^> ^=
  IN NOT
  DSNT418I SQLSTATE   = 42601 SQLSTATE RETURN CODE
  DSNT415I SQLERRP    = DSNHPARS SQL PROCEDURE DETECTING ERROR
  DSNT416I SQLERRD    = 0  0  0  -1  611  0 SQL DIAGNOSTIC
  INFORMATION
  DSNT416I SQLERRD    = X'00000000'  X'00000000'  X'00000000'
                        X'FFFFFFFF'  X'00000263'  X'00000000'
                        SQL DIAGNOSTIC INFORMATION
  3) MSGISPS100
     .
     Invalid Service name
     'VGET(ESAVE)' exceeds the allowable lengh of 8.
     Error is received when using the SPA CLIST from
     SANLCLST. There should be a space between 'VGET'
     and '(ESAVE)'.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: DB2 SQL Performance Analyzer.                *
  ****************************************************************
  * PROBLEM DESCRIPTION: RUNNING SQLPA BINDANL INSTALLATION      *
  *                      VERIFICATION PROGRAM ( IVP )            *
  *                      RECEIVED ABEND04E REASON CODE 00C89012. *
  *                      ABENDS04E S04E RSC00C89012 RSN00C89012  *
  *                      RC00C89012. ABEND OCCURS WHILE SQLPA    *
  *                      ATTEMPTS TO PROCESS CCSID UNICODE       *
  *                      CONVERSION.                             *
  *                                                              *
  *                      1. While running program code receive   *
  *                      SQLCODE-104                             *
  *                      RSC42704REASON CODE 42704               *
  *                      DSNXA07 SQLERRD-180                     *
  *                       SQL ERROR DURING EXECUTE IMMEDIATE     *
  *                      DSNT408I SQLCODE = -204,                *
  *                      ERROR:  ANLCAT22 IS AN UNDEFINED NAME   *
  *                      DSNT418I SQLSTATE   = 42704             *
  *                      SQLSTATE RETURN CODE                    *
  *                      DSNT415I SQLERRP    = DSNXA07           *
  *                      SQL PROCEDURE DETECTING ERROR           *
  *                      DSNT416I SQLERRD    = -180  0  0        *
  *                      -1  0  0 SQL DIAGNOSTIC                 *
  *                      INFORMATION                             *
  *                      DSNT416I SQLERRD    = X'FFFFFF4C'       *
  *                      X'00000000'  X'00000000'                *
  *                      X'FFFFFFFF'                             *
  *                                                              *
  *                      2. SQLPA errors during CCSID UNICODE    *
  *                      conversion:                             *
  *                      DSNT408I SQLCODE = -104,                *
  *                      ERROR:  ILLEGAL SYMBOL "¬". SOME        *
  *                      SYMBOLS THAT MIGHT BE LEGAL ARE:        *
  *                      < > = <> <=  <  >  = >=  <  >  =        *
  *                      IN NOT                                  *
  *                      DSNT418I SQLSTATE   = 42601             *
  *                      SQLSTATE RETURN CODE                    *
  *                      DSNT415I SQLERRP    = DSNHPARS          *
  *                      SQL PROCEDURE DETECTING ERROR           *
  *                      DSNT416I SQLERRD    = 0  0  0           *
  *                      -1  611  0 SQL DIAGNOSTIC               *
  *                      INFORMATION                             *
  *                      DSNT416I SQLERRD    = X'00000000'       *
  *                      X'00000000'  X'00000000'                *
  *                                            X'FFFFFFFF'       *
  *                      X'00000263'  X'00000000'                *
  *                        SQL DIAGNOSTIC INFORMATION            *
  *                                                              *
  *                      3. MSGISPS100                           *
  *                         .                                    *
  *                         Invalid Service name                 *
  *                         'VGET(ESAVE)' exceeds the allowable  *
  *                         length of 8. Error is received when  *
  *                         using the SPA CLIST from SANLCLST.   *
  *                         There should be a space between      *
  *                         'VGET' and '(ESAVE)'.                *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Code has been changed to correct these conditions.
  

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:

  UQ96908

Modules/Macros

• ANLBIND  ANLCAT22 ANLGOV1  ANLPGME7 ANLPGME8
  ANLPROCC ANLPROCR ANLQMF   ANLQMF22 ANLSCAN  ANLSPA   ANLSTAT
  

Fix information

• Fixed component name

  DB2 SQL PER AN

• Fixed component ID

  5697F5701

Applicable component levels

• R210 PSY UQ96908

     UP05/01/24 P F501

• R220 PSY UQ96909

     UP05/01/26 P F501

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.