DQ027E REQUEST FAILED DUE TO SYSTEM ERROR - DB RETURN 14 048 RDUKYDQFDQFK1

Products

• Datacom

Issue/Introduction

Dataquery DQL queries in CICS fail with 

DQ027E REQUEST FAILED DUE TO SYSTEM ERROR - DB RETURN 14 048 RDUKYDQFDQFK1.

Environment

Dataquery 15.1 ( and prior versions) 

Cause

This error points to a corruption of work files which can occur if all DQ work files are not initialized at the same time.  

Resolution

1. Ensure that all users are logged off the DQ product. This can be verified by issuing the DQ command USERS and then pressing PF5 to see all active users. If they cannot log off, place an 'X' beside each user and then press PF3 to force the users off.
2. Close the DQ database (DB 3) in the related CICS region(s).
3. Issue a COMM Status console command to ensure that nothing is using DB 3 (optional).
4. Run the CA Datacom/DB DBUTLTY program with the command
   ACCESS STATUS=OFF,DBID=003,USERS=FAIL
   This command will work if no users are using the DQ database, or it will fail if the job cannot get exclusive control the database.
5. Run the DBUTLTY program to perform an INIT and LOAD (Format=NONE) for the DQF and DQS tables. Add the DQR and DQE tables if using the SQL option. In the same step or a subsequent one, issue the DBUTLTY command
   ACCESS STATUS=WRITE,DBID=003
   to restore access to the database.
6. Run the DQWFINIT program to format the DQF table (and DQE if using the SQL option).
7. Open the DQ database in the related CICS region(s).

Additional Information

Refer to the online documentation : Preparing and Maintaining the Dataquery System Tables  and DQWFI Initializing the DQE, DQF, and DQW (DQWFINIT)