Overview of the Database option

Introduction

Option D ‑ DATABASE provides access to a series of panels that let you:

• Display the Adabas Audit Data Retrieval database and its current usage
• Define new spool files
• Explore the structure of the Adabas Audit Data Retrieval database (tables, fields, and keys)
• Query, update, or delete records
• Generate JCL for database utilities
• Call the BSA Service Manager

Service and Database Selection Menu

The "Service and Database Selection Menu" displays databases or updates spool datasets.

PEB5DA00 ----------------------------------------------------------------------
 Option ===> __________________________________________________________________

 Service and Database Selection Menu System - B97PROD
 Location - BERLIN
 Subsys-ID - B97P
 User ID - B97ADM
 1 DATABASE - Display or Update System Database

 2 DICTIONARY - Display Dictionary Information

 3 STATISTICS - Statistics of Database Usage

 4 UTILITIES - Generate Batch Jobs for Database Maintenance

 Q QUERY - Database Query

 S SERVICE - Service Manager

 Parameter for Option 1 and 2 :
 Display numeric values with leading zeros ===> YES (Y)es, (N)o

 Select one of the above options. Press END to return to the previous menu.

Option 1 ‑ DATABASE

Use this option to display information on the Adabas Audit Data Retrieval datasets and their current usage. For more information, see "Database display: How full is your database?" and the Adabas Audit Data Retrieval Installation and System Guide.

Numeric values with/ without leading zeros

Use Display numeric values with leading zeros at the bottom of the panel to control whether numeric values are displayed with leading zeros under this and the next option.

Option 2 ‑ DICTIONARY

Use this option to explore the database dictionary of the Adabas Audit Data Retrieval database. You can use this information on tables and fields when you want to:

• Analyze data using _beta report
• Upload data into the database using the batch utility B97BUTLT or download data from the database using the batch utility B97DLOAD

Option 3 - STATISTICS

This option is not used under Adabas Audit Data Retrieval.

Option 4 - UTILITIES

This option enables you to generate JCL for database maintenance tasks (enlarging, reducing, renaming, etc.).

Option Q ‑ QUERY

You can use the Database Query to view, update, or delete selected records in an Adabas Audit Data Retrieval table.

Warning: It is possible to corrupt the database by updating or deleting records. Do not update or delete records unless instructed to do so by support.

Option S ‑ SERVICE

You can use this option to call the BSA Service Manager.

Adabas Audit Data Retrieval tables

Following is a list of database tables used by Adabas Audit Data Retrieval together with the corresponding online options. The database also contains other tables for internal use.