Dataquery job using OPTION DIAGNOSTICS=CBS receives DQ011E - EITHER THE COMMAND IS UNKNOWN, OR AUTHORIZATION IS DENIED

Products

• Datacom
• Datacom/DB

Issue/Introduction

A Datacom Dataquery DQBATCH job that is using OPTION DIAGNOSTICS=CBS is getting error DQ011E - EITHER THE COMMAND IS UNKNOWN, OR AUTHORIZATION IS DENIED. Why?

Cause

This error is the result of a diagnostics authorization failure for the user.

Resolution

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, review a batch DQUSERMT utility report that was run 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

For more information on using the DQUSERMT utility, please refer to the documentation topic Maintaining User Table (DQUSERMT).