PI77671: 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.2 and V12.1 users   *
  *                 who have completed installation or migration *
  *                 into a DB2 for z/OS database with DSNHDECP   *
  *                 MIXED=YES.                                   *
  ****************************************************************
  * PROBLEM DESCRIPTION: QMF bind job, DSQ1BPKG can fail with an *
  *                      SQL code -130 SQLCODE130 when           *
  *                      binding package DSQIGLVT (QMF 11.2) or  *
  *                      DSQJGLVT (QMF 12.1).This would only     *
  *                      happen in DB2 for z/OS databases        *
  *                      defined with MIXED=YES and the new QMF  *
  *                      tablespace DSQTSGLV defined with        *
  *                      EBCDIC encoding.                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  QMF requires that new QMF 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 V11.2
  and QMF V12.1
  installation and migration jobs. This APAR updates QMF
  installation job DSQ1BLNI and migration job DSQ1BGLV to enforce
  UNICODE encoding on tablespace DSQTSGLV.
  Users who have installed or migrated to QMF V11.2 or V12.1 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 PI77671 is applied). Following the
  conversion, the jobs DSQ1BVW and DSQ1BPKG will
  need to be rerun to rebuild the views and bind the QMF
  packages.
  

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:

  UI45400 UI45401

Modules/Macros

•    DSQ1BLNV
  

Fix information

• Fixed component name

  QMF-QUERY MGMT

• Fixed component ID

  566872101

Applicable component levels

• RB20 PSY UI45400

     UP17/03/10 P F703

• RC10 PSY UI45401

     UP17/03/10 P F703

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.