Question:
CA Datacom Dataquery DQBATCH with OPTION DIAGNOSTICS=CBS is getting error DQ011E - EITHER THE COMMAND IS UNKNOWN, OR AUTHORIZATION IS DENIED. Why?
Answer:
The OPTION DIAGNOSTICS=CBS requires the Dataquery user submitting the DQBATCH request to have authorization to run diagnostics.
To determine if a user has this authorization, have your Dataquery administrator run batch DQUSERMT utility report with
REPORT USER=user
Below is an example of the report output for user TESTUSER. Notice that "DIAGNOSTICS:" is set to "N" for this user. DQUSERMNT utility can also be used by an Administrator to update the user's setting from "N" to "Y".
USER NAME: TESTUSER ACCOUNTING CODE: QUERY LANGUAGE: SQL SQL AUTHORIZATION ID: SYSADM GROUP1: GROUP2: GROUP3: DATA AUTHORIZED: Y ASSOCIATE USER: N PERSONAL DATABASE: Y SUBMIT ALLOWED: Y EXPORT ALLOWED: Y EMAIL ALLOWED: Y SQL AND DQL ALLOWED: Y SQL DATA DEF ALLOWED: Y SQL DATA MAINT ALLOWED: Y REPORT FACILITY ALLOWED: Y CONDITIONS: Y RESTRICTIONS: Y PRINTER CONTROL: Y JCL MAINTENANCE: Y DIAGNOSTICS: N LANGUAGE: Y USER MAINTENANCE: Y FOUND SET MAINT: Y QUERY LIBRARY MAINT: Y SECURITY: Y ACTIVE USER CONTROL: Y MXREQ: 00000 SORTPAG: 0000 ESTIMATED MAX I/O: 0000 MXTLR: 00000 SORTCTG: 00 FNDBLKS: 00000 NETPRT ID: PRIMARY: AE SECONDARY: AE AREA FOR PERSONAL DATABASE TABLES: LIST AND DISPLAY ALIASES: Y GROUP DISPLAY: N SUPPRESS DUPLICATE FIELDS: N SUPPRESS PF KEYS ON PRINT: N SUPPRESS EXECUTE PANEL: N DECIMAL POINT CHARACTER: . PRINT QUERY TEXT: Y PRINT STATISTICS: Y PRINT BANNER PAGE: Y PRINT PAGES TOGETHER: Y PRINT NUMBER OF COLUMNS: 000 PRINT NUMBER OF ROWS: 000 PRINT USING WINDOWS: N LAST TERMINAL USED: DATE ADDED: 06/06/11 DATE LAST SIGNED ON: 08/03/11 EMAIL SIGNON:
Additional Information:
Refer to CA DatacomĀ® Core - 15.1Ā for information on DQUSERMT utility.