A fix is available
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 number
PI19754
Reported component name
QMF-QUERY MGMT
Reported component ID
566872101
Reported release
B10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2014-06-10
Closed date
2014-06-30
Last modified date
2017-03-02
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.
[{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SSCWRCK","label":"QMF for TSO\/CICS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1","Edition":"","Line of Business":{"code":"LOB35","label":"Mainframe SW"}}]
Document Information
Modified date:
02 March 2017