CA Datacom/AD Environment › CA Datacom/DB Components and System Areas › Sample Databases
Sample Databases
Sample databases are provided for several reasons:
- Utilized by our IVPs to ensure the DBMS is completely installed and working
- Provided as educational tools for learning
- Provides a non product database that can be used to test procedures
- Provides a common database structure and data to be used in recreating problems
The following are the sample databases:
- Human Resource database (DBID 0001)
- Order Entry database (DBID 0010)
- SQLDemoDB (DBID 1001)
Databases for CA Using Products
For more information, see Products that Use CA Datacom/AD.
CA Datacom DBUTLTY
DBUTLTY is the main CA Datacom/DB utility that you use to perform most of the CA Datacom/AD data and index maintenance functions. For more information and syntax formats for the functions, see the CA Datacom/DB DBUTLTY Reference Guide.
Commonly Used CA Datacom Utilities
The following are the CA Datacom utilities that are used by product:
- DBUTLTY and DRREPORT used by CA Datacom/DB
- DDUTILTY, DDUPDATE, DDRMFLM, and DDBTGLM used by CA Datacom Datadictionary
- DDRTVCAT used by CA Datacom/AD (only)
- DBXMMPR and DBSQLPR used by SQL Option
- DQBATCH used by CA Dataquery
- VLSUTIL used by CA IPC
More Information:
- For more information about DBUTLTY, see the CA Datacom/DB DBUTLTY Reference Guide for z/OS
- For more information about DRREPORT, see the CA Datacom/DB Reporting Facility User Guide
- For more information about DDUTILTY and DDUPDATE, see the CA Datacom Datadictionary Batch Guide
- For more information about DDRTVCAT, see DDRTVCAT.
- For more information about DBXMMPR and DBSQLPR, see the CA Datacom/DB SQL User Guide
- For more information about DQBATCH, see the CA Dataquery for CA Datacom Administration Guide
- For more information about VLSUTIL, see the CA IPC for z/OS Implementation Guide
