Database Administration on Mainframe

#### Search Results

Search

# Database Administration on Mainframe

This document descibes how to use Adabas Manager to perform the administration tasks necessary for Adabas Mainframe operations.

- System Requirements

- Accessing Adabas Mainframe

- Running Adabas Utilities on z/OS

## System Requirements

Please refer to the documentation of Adabas for Mainframe > Installation > System Requirements for information about what is required to access Adabas databases on the mainframe. The Adabas databases should be found on the Software AG Directory Server (ADI). The Adabas Manager Communicator (AMC) version 2.4 or above is required by Adabas Manager to administer these Adabas mainframe databases.

There are two ways to connect the Adabas database in Mainframe from Adabas Manager (AMN).

One way is through the TCPX driver in Entire Net-Work (WCP) on Mainframe. For more details, please refer to the documentation of Entire Net-Work Mainframe 6.5.2 > Entire Net-Work TCP/IP Option > Entire Net-Work TCP/IP Option Administration > Simple Connection Line Driver Overview.

In the DRIVER statement of the TCPX driver, set up the directory server host and port by specifying the parameters `ADIHOST` and `ADIPORT`, which AMC is also referring to.

For example:

    DRIVER TCPX,
    	ACCEPTUI=Y,
    	API=OES,
    	ADI=Y,
    	ADIHOST=<adi-host>,
    	ADIPORT=4952,
    	SERVERID=5678

The second way is through ADATCP in the Adabas database nucleus. For more details, please refer to the documentation of Entire Net-Work Mainframe 6.5.2 > Entire Net-Work TCP/IP Option > Entire Net-Work TCP/IP Option Administration > TCPX DRIVER Statement. In the TCPIN DD statement, provide the ADI information (`ADIHOST`, `ADIPORT`), which AMC also refers to.

For example:

    //TCPIN DD *
    ADI=Y
    ADIHOST=<adi-host>
    ADIPORT=4952

Additionally, in the Adabas Manager Host Configuration setup under the AMC tab, ensure the ADI Hostname and ADI Port contain the same values as specified in the parameters for TCPX or ADATCP (on the mainframe).

## Accessing Adabas Mainframe

Click on the icon Administer Adabas on z/OS on the Adabas Manager home page. A list of Adabas mainframe databases is displayed.

Click on a specific database ID to view the details of the database. Stopping the database and forcing the end of PLOG and CLOG are possible. Queues (Command Queues, User Queues and Hold Queues) and Session parameters are shown on the right pane.

Users can reset all or specific interval statistics, such as Commands, General Statistics, Time Elapsed, High Water Marks, etc from the Interval Stats tab.

Checkpoints and User queues elements can be listed and deleted.

For better efficiency, there are filters such as Max Elements, Skip Elements, Checkpoint Name, and From Date to fetch only a subset of checkpoints. Click the Load next <n> from Checkpoint File button to fetch the next set of records to the web client.

To view the list of Adabas files on this database, click on the File menu on the left Navigation bar. In addition to displaying the details and FDT of each Adabas file, on the File List page, users can lock or unlock a file, by clicking the overflow menu (3 vertical dots) on the right of each file.

To see the Extents or Containers of this database, click on the Container menu below the File menu.

If the selected database is a clustered database, a list of nuclei is shown. Click on a specific nucleus to see the details.

To perform Adabas Utlities, click the Utility link on the navigation area and log on to AOZ server to submit mainframe JCL. The logon session is valid until the user logs out from Adabas Manager or closes the Browser.

## Running Adabas Utilities on z/OS

On the page where a list of databases is listed, click the Utility menu on the left navigation menu and a login modal will pop up. Enter the mainframe user-id and password to connect to the Adabas Online Services for z/OSMF Utility Server (AOZ server).

Information on how to set up the AOZ server can be found on the Adabas for Mainframe documentation > Release Notes > Enhancements titled Adabas Online Services for z/OSMF Utility Server.

After logging into the AOZ server, there are 3 tabs, namely Configuration, List Members, and Job Outputs.

Preparing a Template with Variables and Replacements on the AOZ server is a way to customize a reusable JCL to be run with different parameters, settings, steplibs, utilities, etc.

A guide called How to run Adabas Utility via AOZ server can be found by clicking the light bulb icon on the top right corner. There are steps to explain the usage of Variables, Replacement, and Templates on the AOZ server.

To create or edit Variables, Replacement, and Templates of the AOZ server, the user can select them from the drop-down list on the Configurations tab.

Also, to simply run any existing JCL on the mainframe, you can click the List Members tab, enter the name of the PDS in the Dataset field, and click the Get List button.

From the list of JCLs, you can click the Open JCL icon on the right of each listed JCL member.

After opening the JCL, the user can edit and overwrite it, save it as a new JCL, or simply submit it for execution.

To view the job outputs, the user can click the Job Outputs tab and then click the Log icon on the right of each job.

On the Job Output pop-up, users can click the Dump button at the bottom right corner to view the Job Details or click the JCL button to edit the JCL or submit the same JCL again.

### On this page

- System Requirements
- Accessing Adabas Mainframe
- Running Adabas Utilities on z/OS