After initializing my CA Dataquery for CA Datacom DQF table, why did I start receiving error message DQ027E REQUEST FAILED DUE TO SYSTEM ERROR - DB RETURN 14 048 RDUKYDQFDQFK1 in all my online queries?

Document ID : KB000024042
Last Modified Date : 14/02/2018
Show Technical Document Details

Symptoms:

I initialized the CA Dataquery for CA Datacom (called DQ here) DQF (Found Results) table to resolve an earlier user problem, and then started to receive errors in all my online queries:
DQ027E REQUEST FAILED DUE TO SYSTEM ERROR - DB RETURN 14 048 RDUKYDQFDQFK1.

How can I fix this?

Cause:

This error points to a corruption of work files, which can occur if all the DQ work files are not initialized at the same time, with no users logged on.

According to the CA Dataquery for CA Datacom Administration Guide, in the section “Preparing and Maintaining the CA Dataquery System Tables › DQF: Found Table”:

When you null load and initialize the DQF, you must also null load and initialize the DQE, DQR, and DQS [tables] to maintain synchronization. (Omit the DQR and DQE tables if the SQL option is not installed.) Failure to synchronize these tables can result in failure to reclaim DQF space.

Resolution:

We recommend the following steps to properly resolve this problem:

  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:

For more information about the DQWFINIT utility, please refer to the following guides:

CA Dataquery for CA Datacom Version 14.02 Administration Guide, in the section “Preparing and Maintaining the CA Dataquery System TablesDQWFI Initializing the DQE, DQF, and DQW (DQWFINIT)” 

CA Dataquery for CA Datacom Version 15.0 Administration Guide, in the section “Preparing and Maintaining the CA Dataquery System TablesDQWFI Initializing the DQE, DQF, and DQW (DQWFINIT)” 

As always, please contact CA Technologies support for CA Datacom if you have further questions.