This document covers the following topics:
The Database Maintenance menu is called with
function code M and object code DA in a Predict main menu or the command
MAINTAIN DATABASE.
17:26:42 ***** P R E D I C T ***** 2007-05-31
Plan 0 - (DA) Database Maintenance - Profile SYSTEM
Function Function
A Add a database D Display database
C Copy database L Link children
M Modify database S Select database from a list
N Rename/renumber/retype database K Modify Vista elements
P Purge database J Physical Attributes
Function .........
Database ID ...... Attributes .......*
Copy ID .......... Database of type .*
Belongs to VM .... Database number ...
Restrictions ....* Profile Default ,used Association ......*
Command ===>
Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
Help Next Stop Last LnkEl Flip Print Impl AdmFi SelFi Prof Main |
| Parameters | |
|---|---|
| Parameters not listed here are described under Global Attributes. | |
| Function | All standard maintenance functions are described in the section Maintenance in the Predict Reference documentation. The functions Rename/renumber/retype database and Purge are described in the section Database-Specific Maintenance. |
| Database of type |
With the Select function, a database type can be specified as selection criterion. The Add and Copy functions pass the type to the Add/Copy database screen. Note that type I (IMS) is not valid for the Add and Copy functions. Enter an asterisk to display a selection window with the valid database types for a particular function in your environment. For a list of all valid database types, see Database Types. |
| Database number |
For the Add and Copy functions: the database number can be
specified here. This number will be passed to the Add a
database or Copy database screen. See the
description of the parameter For the Select function: a database number can be specified as an additional selection criterion. |
| Association |
For function Link children: objects are to be linked to the database via the selected association. Valid values: "Contains DC", "Contains FI" and user-defined. |
The table below contains a list of all valid database types.
| Code | Database Type |
|---|---|
| A | Adabas |
| B | Adabas D handler |
| C | Conceptual |
| D | DB2 |
| E | Gen. SQL handler |
| H | Other handler |
| I | IMS |
| J | Ingres handler |
| M | RMS handler |
| O | Oracle handler |
| P | Entire System Server |
| Q | Adabas SQL handler |
| R | rdb handler |
| S | SQL Server |
| T | Target node |
| V | VSAM handler |
| X | Informix handler |
| Y | Sybase handler |
The Add a database screen is used by the functions Add and Copy. Depending on the database type, one or several type-specific screens follow. Subsequent screens and their input fields are described in the sections below. Parameters applying to all types of databases are described below.
10:29:21 ***** P R E D I C T ***** 2007-05-31
- Add a database -
Database ID ..... HNO-DA +All-----Database types--------+
! _ A Adabas !
! _ B Adabas D Handler !
! _ C Conceptual !
! _ D DB2 !
Database type .............* * ! _ E Gen. SQL Handler !
Belongs to VM .............* HOME ! _ H Other Handler !
Run mode ..................* ! _ J Ingres Handler !
Physical database number ..* ! _ M RMS Handler !
! _ O Oracle Handler !
! _ P Entire Sys. Server !
! _ Q Adabas SQL Handler !
! _ R rdb Handler !
! _ S SQL Server !
! _ T Target Node !
! _ V VSAM Handler !
! _ X Informix Handler !
! _ Y Sybase Handler !
! !
! !
! !
!Command ==>_______ !
+------------------------------+
|
| Attributes | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| Database type | See Database Types for a list of possible types. | ||||||||||
| Belongs to VM |
Predict virtual machine object documenting the hardware and operating system environment of the database. See also Defining the Distribution of Data in Predict in the section Vista in the Predict and Other Systems documentation. |
||||||||||
| Run mode |
|
||||||||||
| Physical database number |
|
||||||||||