Database Retrieval

Retrieval functions applying to database objects are called from the Database Retrieval menu that is called with the command RETRIEVE DATABASE or with function code R and object type code DA in a Predict main menu.

This document covers the following topics:

• Database-Specific Retrieval Parameters

• Database-Specific Retrieval Functions

• Layout of Database Lists

• Output Options for Database Retrieval

Database-Specific Retrieval Parameters

Database-Specific Retrieval Functions

Explode IMS Database - Code I

Shows the hierarchical structure of an IMS/DL/I database. The level number before the file ID shows the level of the IMS/DL/I segment in the hierarchy. This function is only applicable to databases of type I. Command: EXPLODE DATABASE.

Databases with children - with Association Type Contains FI and Output Option Adabas size=Y

The following output is produced with function Display databases with children if you specify association type "Contains FI" and output option Adabas size=Y for databases and files of type Adabas.

   13:13:02             *****  P R E D I C T  *****         2007-05-31
                        - Display Database with Children -
   
   Database ID ........ DA-WITH-FILE
   Type ............... Adabas, Isolated      Added 2007-05-31 at 10:25 by ARH
   Physical DBnr ...... 57                 Modified 2007-05-31 at 10:42 by ARH
  
---------------------------------------------------------------------------   
   Adabas attributes                     Natural file numbers
     Maximal files ........                System file (FNAT) ...
     Checkpoint file ......                NAT-Security (FSEC) ..
     Adabas security ......                Predict (FDIC) .......
     Size of RABN ......... 0
     Distr. transaction ... N No
     Vista access only .... N
   
                --------------- Database primary sizes ---------------
                             Number of               Alternate RABN
             Device    Cylinder     RABN             Start     End
   ASSO R1    3390       15           4032             1200      3200
   ASSO R2    3390       14           3780             2000      3760
   DATA R1    3380       12           1611
   DATA R2    3380       13           1755
   
   
   Cnt  File ID                            Type   Fnr    DDM Impl Other
   
      1 FI-A-001                            A     123
      2 FI-A-002                            A     124
   
   ------------------------------- Summary of sizes---------------------------
   
   Type  Device   No. of RABN    Min. RABN  Undoc. RABN
   ASSO   3390           7812         1942         5870
   DATA   3380           3366         1205         2161
   
    *** End of report ***
  

The total ASSO and DATA sizes defined for the database are calculated and displayed in column Summary of sizes/No. of RABN.

The sum of the sizes of ASSO and DATA for the individual related files is calculated and displayed in column Min. RABN.

The number of available RABNs is displayed in the column Undoc. RABN, or a message is given indicating that the sizes of the files exceed the size available in the parent database.

The system also checks whether the devices specified for the files are also specified for the parent database.

Layout of Database Lists

The following list format applies when retrieving information on databases with output mode List.

 13:37:03             *****  P R E D I C T  *****                2007-05-31
                              - List Database -   
 -----------------------------------------------------------------------------------
 Cnt  Database ID                           Type                P-DBnr Run Mode
   
   15 ARH-X                                 Informix Handler        24 Local
   16 ARH-Y1                                Sybase Handler          22 Local
   17 * ARTICLE                             IMS                     
   18 AZ-PREDICT                            Adabas                  66 Isolated
   19 AZ-SAGPRD                             DB2                      
   
 *** End of report ***
  

Output Options for Database Retrieval

Notes:

1. Unless output mode is S, the option Cover page is always valid.
2. Page size is only applicable when printing or if general default parameter Use SAG Editor for output is set to Y. Page size is not applicable in batch mode.