search cancel

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

book

Article ID: 18724

calendar_today

Updated On:

Products

Datacom Datacom/DB

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:

  1. WIth Datadictionary Online: ENABLE command
  2. With Datadictionary Batch: 1000 ENABLE transaction

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.

  1. 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).
  2. The DATACOM/DB Structure Select panel appears. Select option 1 (DATABASE).
  3. The DATACOM/DB Structure Maintenance Panel listing functions for the selected structure appears. Select option 9 (ENABLE).
  4. 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.