Resolving Dataquery error DQ899E - THE TABLE, OR ONE OF ITS ENTITIES, IS DISABLED & CAN'T BE ACCESSED
Article ID: 18724
Updated On:
Products
Issue/Introduction
When running a batch Dataquery job, I received an error:
DQ899E - THE TABLE, OR ONE OF ITS ENTITIES, IS DISABLED & CAN'T BE ACCESSED
How do I correct this?
Environment
Component : Datacom/DB
Resolution
In order to access a Datacom database using 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.
There are two ways to accomplish this:
DATADICTIONARY ONLINE
Here is the description from the Datadictionary Online documentation:
Use the ENABLE command to indicate that data defined in a Datacom/DB Model or Broadcom FILE Model structure or substructure is in synchronization with the Datacom Datadictionary definition and available for use by other Broadcom products. This command enables the Datacom Datadictionary definition, not the Datacom/DB definition. Enabling a structure or substructure does not affect the definition in the Datacom/DB Directory (CXX). Therefore, you can enable a structure or substructure that is not synchronized with the Datacom/DB Directory, but this can cause unpredictable results in Broadcom products (such as Dataquery and Ideal for Datacom) that depend on this synchronization.
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 has this format:
►►─┬─ ENABLE ─┬─ entity1 ─ occ-name1 ─┬────────────────────────────────┬──────►
└─ ENAB ───┘ └─┬─ IN ─┬─ entity2 ─ occ-name2 ─┘
└─ OF ─┘
►─┬─ STATUS xxxx ─┬─┬─────────────────┬─┬─────────────────┬──────────────────►◄
└─ STA xxxx ────┘ ├─ PASSWORD xxxx ─┤ ├─ OVERRIDE xxxx ─┤
└─ PSWD xxxx ─────┘ └─ OVRD xxxx ─────┘
Here is the command in a short form:
ENABLE {DATABASE | BAS} name {STATUS | STA} xxxx {PASSWORD | PASS} xxxx {OVERRIDE | OVRD} xxxx
Press PF9 (APPLY) to process the ENABLE command. Datacom Datadictionary responds with a message confirming successful completion of the function on the Datacom/DB Structure Maintenance Panel.
To perform this through the panels, you will need to follow the menu options from the main menu after login to DDOL.
- The Datacom Datadictionary Mode Select panel appears. Since you are enabling a Datacom/DB DATABASE structure, select option 1 (or enter the SET MODE DBM command).
- The DATACOM/DB Structure Select panel appears. Select option 1 (DATABASE).
- The DATACOM/DB Structure Maintenance Panel listing functions for the selected structure appears. Select option 9 (ENABLE).
- The following ENABLE prompter panel appears. After you complete your entries on this panel, press PF9 (APPLY).
=>
=>
=>
1-DDOL000196A - CMPP - PLEASE COMPLETE REQUIRED INFORMATION FOR COMMAND
-------------------------------------------------------------------------------
DATACOM/DB Structure Maintenance
TXCF
ENABLE DATABASE ________________________________ in STATUS ____
ENAB BAS (name) STAT (stat)
with PASSWORD using OVERRIDE
PSWD (pswd) OVRD (ovrd)
PF1=HELP PF2=END PF3=CLARIFY PF4=PROCESS PF5=MENU PF6=STATUS
PF7=SCB PF8=SCF PF9=APPLY PF10=PATH PF11=NEXT PF12=INPUT
Note that these panels can prompt you for the required fields, and other optional fields will default. Required entries are highlighted on your screen.
After you fill in the panel and press PF9 (APPLY) to process your command, Datacom Datadictionary responds with a message confirming successful completion of the function on the Datacom/DB Structure Maintenance Panel.
DATADICTIONARY BATCH
Here is description of the 1000 ENABLE transaction from the DDUPDATE documentation:
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 Datacom/DB Model and Broadcom FILE Model structure or substructure available for use by other Broadcom 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), Datacom Datadictionary also enables the associated substructures. When you enable a secondary structure (dataview), Datacom Datadictionary does not enable the associated substructures.
To enable an entity in batch mode, you will run the DDUPDATE program with this transaction:
-UPD entity,name(status,password)
1000 ENABLE
-END
Here is an example:
-UPD DATABASE,ORDER-ENTRY(T003,OR11)
1000 ENABLE
-END
This transaction enables the TEST Version 3 of the ORDER-ENTRY database. In this example, this version of the database has a password of OR11.
Once you perform this function, your entities should be enabled and ready for use, and you should be able to run the failing job again.
Additional Information
As always, please contact Broadcom support for Datacom if you have further questions.
Feedback
