Following is a list of the tables which must be present in CA Datacom/DB to run CA Dataquery with the SQL option installed.
Note: See important information in Logging, Recovery, and URI and Recovery.
Serves as an SQL Found Table containing the rows of data returned by a SQL query.
CA Dataquery Found Table - Stores the results of a query or found set. The found set that results from a query remains active until another query is executed or the user signs off. This table also contains saved sets which are pointer information to the original data in the queried database table when the KEEP command is used for DQL Language queries. When the EXTRACT command is used, the actual data values for the columns specified in the query are saved in a special Extract Set on the CA Dataquery Found Table (DQF). The Found Table is also used by the Deferred Batch and Print Offline functions of CA Dataquery.
CA Dataquery Literals Table - Stores literal values that are output by the CA Dataquery system. These literal values are keywords and phrases that are commonly used by the CA Dataquery system. Storing them on this table facilitates their translation to other languages by the CA Dataquery Language Maintenance Facility.
CA Dataquery Panel Table - Stores the image of the panels that collectively comprise the CA Dataquery External Online Interface. Storing panel images on this table facilitates their translation into other languages by the CA Dataquery Language Maintenance Facility. Any translated versions are also stored on this table.
CA Dataquery Query Library - Primarily stores query text members, JCL members, PROCs, terms, condition, and restriction definitions.
Functions as a Recovery Table containing one row for each Found Set in the DQE. It also contains some record keeping data, such as who created the Found Set, when it was created, and so on.
CA Dataquery Spool Table - Stores and controls the hardcopy report output of a query that has been routed to an online network printer.
CA Dataquery User Table - Stores the definitions of valid CA Dataquery users. This table contains user attributes such as name, password, language, system options and function authorizations. This information is used to validate a user attempting to sign on to the CA Dataquery system.
CA Dataquery Vocabulary Table - Stores Language and Command keywords that a CA Dataquery user would enter into the system. Storing these keywords on this table facilitates their translation into other languages by the CA Dataquery Language Maintenance Facility.
CA Dataquery Work Table - Performs as the batch equivalent of the DQF table. The Work Table stores and manages found sets that result from batch queries. This table is segmented into partitions to allow the concurrent execution of several batch queries. (The KEEP and EXTRACT commands are not available in batch CA Dataquery, so no saved or Extracted sets are present on the CA Dataquery Work Table.)
If SQL is not installed, the DQE and DQR tables are not needed.
Table Sizes
The size of each of these tables is site-specific. The ten tables are provided with the installation of CA Dataquery. Each table is in its own CA Datacom/DB area except DQM, DQP, and DQV which share the DQM area. You must determine if the tables are large enough as provided and if not, you must regenerate the tables to meet the needs of your environment.
Logging, Recovery, and URI
Do not specify logging for any of the CA Dataquery system tables except the DQQ (Query Library Table) and DQU (User Table). Installing or upgrading specifies logging on for these tables.
Recovery
The recovery attribute (RECOVERY) is set to yes (Y) for all CA Dataquery system tables to allow URI support to be implemented. Do not change this specification.
|
Copyright © 2014 CA.
All rights reserved.
|
|