Can you use the CA Datacom Dataquery DRAW command in DQRY against the AUTOSCOPE DBID'S 1018, 1019 or 1020?

Products

• Datacom
• DATACOM - AD
• Ideal
• CIS
• COMMON SERVICES FOR Z/OS
• 90S SERVICES
• DATABASE MANAGEMENT SOLUTIONS FOR DB2 FOR Z/OS
• COMMON PRODUCT SERVICES COMPONENT
• Common Services
• CA ECOMETER SERVER COMPONENT FOC
• Easytrieve Report Generator for Common Services
• INFOCAI MAINTENANCE
• IPC
• UNICENTER JCLCHECK COMMON COMPONENT
• Mainframe VM Product Manager
• CHORUS SOFTWARE MANAGER
• CA ON DEMAND PORTAL
• CA Service Desk Manager - Unified Self Service
• PAM CLIENT FOR LINUX ON MAINFRAME
• MAINFRAME CONNECTOR FOR LINUX ON MAINFRAME
• GRAPHICAL MANAGEMENT INTERFACE
• WEB ADMINISTRATOR FOR TOP SECRET
• Xpertware

Issue/Introduction

Description:

When doing a Dataquery DRAW command against a AUTOCOLLECT table I am getting the following error:

DQ299E - TABLE CAN'T BE DISPLAYED - IT IS NOT A TABLE THAT YOU MAY ACCESS S_MUF_RETURN_CODES

Solution:

The SQL AUTHID for the AUTOSCOPE tables is "AUTOCOLLECT". So, to inquire against any AUTOSCOPE tables such as S_MUF_RETURN_CODES, you need to update your CA Dataquery PROFILE in DQRY to add AUTOCOLLECT into SQL AUTHORIZATION ID.

Environment

Release: DATABB00200-14-Datacom/AD
Component: