While running the CA Dataquery IVP job in my installation process, I received an error: DQ899E - THE TABLE, OR ONE OF ITS ENTITIES, IS DISABLED & CAN'T BE ACCESSED

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

Description:

I am installing CA Datacom/DB version 12.0, and in the IVP job BDIVP04 (or IVPUPG04 in CA Datacom/DB version 14.0), I received an error


DQ899E - THE TABLE, OR ONE OF ITS ENTITIES, IS DISABLED & CAN'T BE ACCESSED 

How do I correct this?

Solution:

In order to access a database with CA Dataquery (and other products or applications), that database must be made available for processing. This is done with the ENABLE command in the Datadictionary environment. Here is description of the 1000 ENABLE transaction from the CA Datacom Datadictionary Batch Reference Guide:

Use this transaction to indicate that the data described by a structure or substructure is now in synchronization with the Directory (CXX) definition. The transaction marks the CA Datacom/DB Model and CA FILE Model structure or substructure available for use by other CA products.

You cannot enable a structure or substructure if it does not successfully pass a verify. See the 1000 VERIFY transaction for more information.

When you enable a primary structure (database) or substructure (area, table, element), CA Datacom Datadictionary also enables the associated substructures. When you enable a secondary structure (dataview), CA Datacom Datadictionary does not enable the associated substructures.

There are two ways to accomplish this:

  1. WIth Datadictionary Online: ENABLE command

  2. With Datadictionary Batch: 1000 ENABLE transaction

In the case of the IVP jobs, you will need to enable the Datadictionary database, which is called DATA-DICT. This document addresses the enable process in general; to use this to correct the IVP jobs, you will need to specify the entity type DATABASE (or BAS), and the name of DATA-DICT. You will typically also enable the PROD status, and will need the password of DD.

DATADICTIONARY ONLINE

You can enable the entities using the command line or the menus and panels.

To use the command line for database, area or table entities, you should be in DBMAINT mode. The command is


ENABLE {DATABASE | BAS} name {STATUS | STA} xxxx {PASSWORD | PASS} xxxx {OVERRIDE | OVRD} xxxx 
ENABLE {AREA | ARA} name {STATUS | STA} xxxx {PASSWORD | PASS} xxxx {OVERRIDE | OVRD} xxxx 
ENABLE {TABLE | TBL} name {STATUS | STA} xxxx {PASSWORD | PASS} xxxx {OVERRIDE | OVRD} xxxx  

Once the command is complete, press PF9 (APPLY) to process the ENABLE command. CA Datacom Datadictionary responds with a message confirming successful completion of the function on the CA Datacom/DB Structure Maintenance Panel.

To enable the DATA-DICT database, use the command:


ENABLE BAS DATA-DICT STA PROD PASS DD 

To perform this through the panels, you will need to follow the menu options:

First, select the DBMAINT mode from the DATADICTIONARY Mode Select Menu:

  1. DBMAINT (SET MODE DBM) DATACOM/DB Structure Maintenance 


Then, select the entity type to process from the DATACOM/DB Structure Maintenance Menu:


  1. DATABASE (BAS) Database structure maintenance 		
  2. AREA (ARA) Area structure maintenance 		
  3. TABLE (TBL) Table structure maintenance 	 

Next, if choosing option 1 (Database), you will choose ENABLE from the DB Structure Functions Menu:


  9. ENABLE (ENAB BAS) Enable a database structure 

Fill in the panel, and then press PF9 (APPLY) to process your command. CA Datacom Datadictionary responds with a message confirming successful completion of the function on the CA Datacom/DB Structure Maintenance Panel.

DATADICTIONARY BATCH

To enable an entity in batch mode, you will run the DDUPDATE program with this input:


//SYSIN DD *     
-USR DATACOM-INSTALL,NEWUSER     
-UPD entity,name(status,password)     
1000 ENABLE     
-END     
/*      

For the DATA-DICT database, here is the input:


//SYSIN DD * 		
-USR DATACOM-INSTALL,NEWUSER 		
-UPD DATABASE,DATA-DICT(PROD,DD) 		
1000 ENABLE 		
-END 		
/*

Once you do this, your entities should be enabled and ready for use, and you should be able to run the IVP job again.

For more information about the enable command please refer to the CA Datacom Datadictionary Online Reference Guide in the section "DBMAINT Mode - DATACOM/DB Structure Maintenance › Disable and Enable Structures," or the CA Datacom Datadictionary Batch Reference Guide in the section "DDUPDATE - Updating Datadictionary › 1000 ENABLE Transaction."

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