PK43853: SQLCODE -104 SQLCODE104 ILLEGAL SYMBOL IN SQLPA WHEN KOREAN CCSID 933 IS IN USE.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• SQLCODE104 when SQLPA encounters Korean characters in CCSID
  933.
  DSNT408I SQLCODE = -104, ERROR:  ILLEGAL SYMBOL " ". SOME
  SYMBOLS THAT
  MIGHT BE LEGAL ARE: VALID GRAPHIC STRING
  DSNT418I SQLSTATE   = 42601 SQLSTATE RETURN CODE
  DSNT415I SQLERRP    = DSNHTOKR SQL PROCEDURE DETECTING ERROR
  DSNT416I SQLERRD    = 502  0  0  -1  306  0 SQL DIAGNOSTIC
  INFORMATION
  DSNT416I SQLERRD    = X'000001F6'  X'00000000'  X'00000000'
  X'FFFFFFFF'
  X'00000132'  X'00000000' SQL DIAGNOSTIC INFORMATION
  ADDITIONAL SYMPTOMS
  1. ANLCAT does not function the same as ANLSTAT when
     specifying multiple COLLECT statements. The following
     messages are issued:
     ANL8013I NO INDEX FOUND FOR TABLE
     ANL8014I NO COLUMN STATS FOR TABLE
     ANL8016I NO COLUMN DIST STATS
  2) Loop in SQLPA online ( under ISPF interface )
     when specify "Define output files.... YES"
     and the CLIST ANLLOOP from member hiqual.SANLVCLS
     is executed.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of SQL Performance Analyzer.           *
  ****************************************************************
  * PROBLEM DESCRIPTION: SQLCODE104 when SQLPA encounters Korean *
  *                      characters in CCSID 933.                *
  *                      DSNT408I SQLCODE = -104, ERROR:         *
  *                      ILLEGAL SYMBOL " ". SOME SYMBOLS THAT   *
  *                      MIGHT BE LEGAL ARE: VALID GRAPHIC       *
  *                      STRING                                  *
  *                      DSNT418I SQLSTATE   = 42601 SQLSTATE    *
  *                      RETURN CODE                             *
  *                      DSNT415I SQLERRP    = DSNHTOKR SQL      *
  *                      PROCEDURE DETECTING ERROR               *
  *                      DSNT416I SQLERRD    = 502  0  0  -1     *
  *                      306  0 SQL DIAGNOSTIC INFORMATION       *
  *                      DSNT416I SQLERRD    = X'000001F6'       *
  *                      X'00000000'  X'00000000' X'FFFFFFFF'    *
  *                      X'00000132'  X'00000000' SQL            *
  *                      DIAGNOSTIC INFORMATION                  *
  *                      ADDITIONAL SYMPTOMS                     *
  *                      1. ANLCAT does not function the same    *
  *                      as ANLSTAT when specifying multiple     *
  *                      COLLECT statements. The following       *
  *                      messages are issued:                    *
  *                      ANL8013I NO INDEX FOUND FOR TABLE       *
  *                      ANL8014I NO COLUMN STATS FOR TABLE      *
  *                      ANL8016I NO COLUMN DIST STATS           *
  *                      2. Loop in SQLPA online ( under ISPF    *
  *                      interface ) when specify                *
  *                      "Define output files.... YES" and the   *
  *                      CLIST ANLLOOP from member               *
  *                      hiqual.SANLVCLS is executed.            *
  ****************************************************************
  * 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:

  UK25547 UK25548

Modules/Macros

•    ANLCAT22 ANLLOOP  ANLPGME7 ANLPGME8 ANLPGM31
  ANLPRC3C ANLPRC3R ANLPRE3C ANLPRE3R ANLQMF31
  

Fix information

• Fixed component name

  DB2 SQL PERF AN

• Fixed component ID

  5697F5701

Applicable component levels

• R220 PSY UK25547

     UP07/06/01 P F705

• R310 PSY UK25548

     UP07/05/31 P F705

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.