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.

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.