Maintaining Objects of Type Database

#### Search Results

Search

# Maintaining Objects of Type Database

This document covers the following topics:

- Database Maintenance Menu

- Database Types

- Defining Basic Attributes of Databases

## Database Maintenance Menu

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 `Physical database number` in Defining Basic Attributes of Databases. 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.

## Database Types

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

## Defining Basic Attributes of Databases

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 | Use of the database with respect to the distribution of data with Adabas Vista.
I | Isolated. Adabas Vista is not used. The database is isolated.
L | Local. The database cannot be accessed using Entire Net-Work.
V | Vista. Adabas Vista is used. Only valid for Adabas databases.
See Defining the Distribution of Data in Predict in the section Vista in the Predict and Other Systems documentation for a detailed description of the meaning of the Vista parameter.
Physical database number | Valid values depend on database type:
Database Type | Range of Database Numbers
B, E, J, O, Q, R, X, Y | 1 - 255
A, H, M, P, T, V | 1 - 65535
Others | not applicable

### On this page

- Database Maintenance Menu
- Database Types
- Defining Basic Attributes of Databases