Database

This document covers the following topics:

Database Maintenance

The Database Maintenance Menu is invoked with MAINTAIN DATABASE.

Overview of Database Maintenance Functions and Commands

Function Code Command
Add a database A ADD DATABASE
Copy database C COPY DATABASE
Modify database M MODIFY DATABASE
Rename database N RENAME DATABASE
Purge database P PURGE DATABASE
Display database D DISPLAY DATABASE
Link children L LINK DATABASE <active-association-type>
Edit owner of a database O EDIT OWNER DATABASE
Select database from a list S SELECT DATABASE
Edit description of a database W EDIT DATABASE DESCRIPTION
Modify Vista elements K MODIFY VISTA-DA

Database Maintenance Command Parameters

Keyword Field Position
ID Database ID 1
<> Copy ID 2

Database-Specific Maintenance Commands

See also Standard Maintenance Commands.

RENAME DATABASE<database-ID>

The following database attributes can be modified in one transaction:

  • Database ID

  • Database type

  • Belongs to VM

  • Run mode

  • Physical database number

  • Vista access only.

Note:
These values cannot be changed with the function Modify Database.

Database Retrieval

The Database Retrieval Menu is called with RETRIEVE DATABASE.

Overview of Database Retrieval Functions and Commands

Retrieval Type Code Default
Output
Mode 		Command
Databases D D DISPLAY DATABASE
" D L LIST DATABASE
" D S SELECT DATABASE
" D D SHOW DATABASE
Execute retrieval models E T EXECMODEL DATABASE
Explode IMS database I X EXPLODE DATABASE
Dummy/Placeholder databases C L DUMMY DATABASE <passive-association-type>
Databases with parents B D PARENTS DATABASE <passive-association-type>
Databases with no parent O L FREE DATABASE ANY | ALL | <passive-association-type>
Databases with children T D CHILDREN DATABASE <active-association-type>
Databases with no child U L EMPTY DATABASE ANY | ALL | <active-association-type>

Database Retrieval Command Parameters

Keyword Field Position
ID Database ID 1
PARENT Belongs to VM 2
RES Restrictions 3
OUT Output options 4
TYPE Database of type 5
DBNR Database number 6
MODEL Model 7
MODE Output mode 8

Database-Specific Retrieval Commands

See also Standard Retrieval Commands.

EXPLODE DATABASE Shows the hierarchical structure of an IMS/DL/I database. Additional search criteria are ignored if a unique database ID is entered. The level number before the file ID shows the level of the IMS/DL/I segment in the hierarchy. This command is only available for databases of type I.

Administration Implemented Database

The Administration Implemented Database Menu is called with ADMINISTRATE DATABASE.

Overview of Database Administration Functions and Commands

Function Code Command
Disconnect implementation C DISCONNECT DATABASE
Display implementation D DISPLAY ADABAS-DATABASE
"   DISPLAY DB2-DATABASE
"   DISPLAY NDB
Purge implementation P PURGE DB2-DATABASE
Select implementation D SELECT ADABAS-DATABASE
    SELECT DB2-DATABASE
    SELECT NDB

Database Administration Command Parameters

Keyword Field Position
ID Database ID 1
PARENT Belongs to VM 2
DBNR Database number 3
TYPE Database of type 4
MODIFIED Only modified 5
RES Restrictions 6

Database-Specific Administration Commands

Objects of this type are processed using Standard Administration Commands.