Database

#### Search Results

Search

# Database

This document covers the following topics:

- Database Maintenance

- Database Retrieval

- Administration Implemented Database

## 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.

### On this page

- Database Maintenance
- Database Retrieval
- Administration Implemented Database