A fix is available
APAR status
Closed as program error.
Error description
The German NLF job DSQ1DRTS fails issuing the following message: QMFV12R1.0 was started in subsystem dddd(DSN11010).. Currently connected location: lllllldddd (DSN11010).. BENUTZER-ID:iiiiiii. BERECHTIGUNGS-ID: iiiiiii. NACHRICHT-NR. :DSQ22902. NACHRICHT-TEXT:. Zeile 5 der Tabelle zum Definieren von Befehlen enthdlt einen ung|ltigen. Eintrag f|r SYNONYM_DEFINITION.. &C1: 5. &C2: Q.COMMAND_SYNONYM_D. &C3: RU. &C5: RUN. -------------------------------- QMFV12R1.0 was started in subsystem dddd(DSN11010).. Currently connected location: lllllldddd (DSN11010).. BENUTZER-ID:iiiiiii. BERECHTIGUNGS-ID: iiiiiii. NACHRICHT-NR. :DSQ22902. NACHRICHT-TEXT:. Zeile 6 der Tabelle zum Definieren von Befehlen enthdlt einen ung|ltigen. Eintrag f|r SYNONYM_DEFINITION.. &C1: 6. &C2: Q.COMMAND_SYNONYM_D. &C3: RUNTSO. &C5: RUN. DSQ22902 msgDSQ22902
Local fix
Until the PTF is applied, customers can run the following SQL to remove the synonyms that were added in error: DELETE FROM Q.COMMAND_SYNONYM_D WHERE VERB = 'RU' OR VERB = 'RUNTSO'
Problem summary
**************************************************************** * USERS AFFECTED: All QMF for TSO/CICS V12.1 German users. * **************************************************************** * PROBLEM DESCRIPTION: When invoking QMF German, users may * * receive DSQ22902 saying that command * * synonyms RU and RUNTSO are invalid. * **************************************************************** * RECOMMENDATION: * **************************************************************** Command synonyms RU and RUNTSO were inadvertantly added tothe default QMF German command synonym table. This would have been to table Q.COMMAND_SYNONYM_D if running in aDB2 for z/OS server or table Q.COMMAND_SYN_TSO_D if runningin a DB2 iSeries or DB2 LUW server. The erroneous commandsynonyms would have been added when either migrating orinstalling during any of the following jobs: DSQ1DDJ2, DSQ1DRTS, DSQ1DCCS or DSQ1DAS2. This APAR removes the addition of thecommand synonyms from those jobs. For users who have run thejobs already and have the erroneous command synonyms alreadyinstalled, the following SQL should be run to all affected servers:DELETE FROM Q.COMMAND_SYNONYM_DWHERE VERB = 'RU' OR VERB = 'RUNTSO' or DELETE FROM Q.COMMAND_SYN_TSO_D WHERE VERB = 'RU' OR VERB = 'RUNTSO'
Problem conclusion
Temporary fix
Comments
APAR Information
APAR number
PI88845
Reported component name
QMF-QUERY MGMT
Reported component ID
566872101
Reported release
C57
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2017-10-13
Closed date
2017-10-16
Last modified date
2017-11-01
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI51132
Modules/Macros
DSQ0DACT DSQ1DDJ2 DSQ1DLNW DSQ1DSYN
Fix information
Fixed component name
QMF-QUERY MGMT
Fixed component ID
566872101
Applicable component levels
RC57 PSY UI51132
UP17/10/19 P F710
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":"C57","Edition":"","Line of Business":{"code":"LOB35","label":"Mainframe SW"}}]
Document Information
Modified date:
01 November 2017