A fix is available
APAR status
Closed as program error.
Error description
User is running a QMF batch job in a DB2 for z/OS Version 10 database and unexpectedly receives messages like: -------------------------------------- -USERID: $XOL AUTHORIZATION-ID: $XOL MESSAGE NUMBER: DSQ10490 MESSAGE TEXT: THE STATEMENT WAS SUCCESSFULLY PREPARED, BUT IT CANNOT BE EXECUTED BECAUSE $XOL DOES NOT HAVE DELETE PRIVILEGE ON OBJECT Q.PROFILES BUT HAS EXPLAIN PRIVILEGE. &O3: DELETE &O4: Q.PROFILES &O9: +4726 (0168Z) SQLCA: SQLCODE: +4726 SQLERRP: DSNXODML SQLERRD1/SQLERRD2/SQLERRD3: 00000000 00000000 00000001 SQLERRD4/SQLERRD5/SQLERRD6: 4120CF62 00000000 00000000 SQLWARN: SQLSTATE: 0168Z SQLERRM: $XOL.DELETE.Q.PROFILES ---------------------------------------------------------------- **** A similar message may be received involving INSERT privilege. The QMF batch job ends successfully. The userid running the job ($XOL in this case) has been granted EXPLAIN system authority in the DB2 database.
Local fix
Ignore the messages as they are not intended to be externalized.
Problem summary
**************************************************************** * USERS AFFECTED: All QMF for TSO/CICS V10.1 users running in * * DB2 for z/OS V10.1 databases receiving * * DSQ10490 (MSGDSQ10490) involving EXPLAIN * * privilege on table Q.PROFILES. * **************************************************************** * PROBLEM DESCRIPTION: Users running batch QMF may receive * * messages DSQ10490 (MSGDSQ10490) 'THE * * STATEMENT WAS SUCCESSFULLY PREPARED, * * BUT IT CANNOT BE EXECUTED BECAUSE * * userid DOES NOT HAVE INSERT PRIVILEGE * * ON OBJECT Q.PROFILES BUT HAS EXPLAIN * * PRIVILEGE.' One message is received for * * INSERT and one for DELETE on a * * succesful batch run. The job runs * * successfully to completion. * **************************************************************** * RECOMMENDATION: * **************************************************************** Users running in DB2 for z/OS V10.1 databases that use the new system EXPLAIN privilege may unexpectedly receive messages in their QMF batch job output like: ---------------------------------------------------------- MESSAGE NUMBER: DSQ10490 MESSAGE TEXT: THE STATEMENT WAS SUCCESSFULLY PREPARED, BUT IT CANNOT BE EXECUTED BECAUSE userid DOES NOT HAVE INSERT PRIVILEGE ON OBJECT Q.PROFILES BUT HAS EXPLAIN PRIVILEGE. ---------------------------------------------------------- The user can possibly see this message or messages and have a successful batch run. One message indicates INSERT and one can indicate DELETE. * These messages can be ignored as they are part of QMF internal checking for QMF Administrator authority. * Internal processing for QMF Administrator authority checking was not anticipating a positive SQL code and inadvertently issued internal processing error messages.
Problem conclusion
Internal processing for QMF Administrator checking has been updated to properly handle positive SQL codes. In this case, SQL code +4726 was received on internal SQL processing which indicates that the userid has EXPLAIN privileges on a table but not INSERT or DELETE privilege. QMF Administrator processing will internally flag this id as not having the privileges required for QMF Administrator authority. This checking will not be externalized as is currently done with QMF Administrator authority checking.
Temporary fix
Comments
APAR Information
APAR number
PM59739
Reported component name
QMF-QUERY MGMT
Reported component ID
566872101
Reported release
A10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2012-03-05
Closed date
2012-03-13
Last modified date
2012-04-03
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UK77037
Modules/Macros
DSQIAUTH
Fix information
Fixed component name
QMF-QUERY MGMT
Fixed component ID
566872101
Applicable component levels
RA10 PSY UK77037
UP12/03/15 P F203
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":"10.1.0","Edition":"","Line of Business":{"code":"LOB35","label":"Mainframe SW"}}]
Document Information
Modified date:
03 April 2012