PI19754: ENFORCE QMF TABLE SPACE DSQTSGLV ENCODING UNICODE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DSQTSGLV tablespace, created in QMF Version 11 must be
  encoded in UNICODE for mixed systems. This APAR will enhance
  the QMF Version 11 install process to enforce this requirement.
  Otherwise, EBCDIC MIXED=YES customers will see error below;
  DSNX200I  - BIND SQL ERROR
             USING SYSADM AUTHORITY
             PLAN=(NOT APPLICABLE)
             DBRM=DSQHGLVT
             STATEMENT=1953
             SQLCODE=-130
             SQLSTATE=22019
             TOKENS=
             CSECT NAME=DSNXOW2D
             RDS CODE=-101
  
  SQLCODE130 on LIKE pred having ESCAPE clause
  

Local fix

• If running a mixed system, DSQTSGLV must be encoded in unicode.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All QMF for TSO/CICS V11.1 users who have    *
  *                 completed installation into a DB2 for z/OS   *
  *                 database with DSNHDECP MIXED=YES.            *
  ****************************************************************
  * PROBLEM DESCRIPTION: QMF 11 bind job, DSQ1BPKG can fail with *
  *                      an SQL code -130 SQLCODE130 when        *
  *                      binding package DSQHGLVT at PTF level   *
  *                      UK96033 or higher. This would only      *
  *                      happen in DB2 for z/OS databases        *
  *                      defined with MIXED=YES and the new QMF  *
  *                      11 tablespace DSQTSGLV defined with     *
  *                      EBCDIC encoding.                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  QMF 11 requires that new QMF 11 tablespace DSQTSGLV be encoded
  in UNICODE for DB2 for z/OS databases defined with DSNHDECP
  MIXED=YES.  This requirement was not enforced in the QMF 11
  installation and migration jobs. This APAR updates QMF
  installation job DSQ1BLNI and migration job DSQ1BGLV to enforce
  UNICODE encoding on tablespace DSQTSGLV.
  

Problem conclusion

• Users who have installed or migrated to QMF 11 in a DB2 for z/OS
  database *defined with MIXED=YES* prior to this APAR, should
  verify encoding of the DSQTSGLV tablespace. The following query
  can be run to make the verification:
  SELECT "NAME",   ENCODING_SCHEME
  FROM "SYSIBM".SYSTABLESPACE
  WHERE NAME='DSQTSGLV'
  If the ENCODING_SCHEME returned from the above query is not a
  value of 'U', the tablespace needs to be converted to UNICODE.
  After the data in the tablespace is unloaded, the tablespace,
  table and index may be recreated using job DSQ1BGLV
  (after the fix for PI19754 is applied). Following the
  conversion, the jobs DSQ1BVW and DSQ1BPKG will
  need to be rerun to rebuild the views and bind the QMF 11
  packages.
  

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:

  UI19262

Modules/Macros

• DSQ1BLNV
  

Fix information

• Fixed component name

  QMF-QUERY MGMT

• Fixed component ID

  566872101

Applicable component levels

• RB10 PSY UI19262

     UP14/07/02 P F407

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.