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:

Note
Standard retrieval functions are described in the section Retrieval in the Predict Reference documentation.

Database-Specific Retrieval Parameters

Parameters
Database of type Limits the scope of the function to databases of a certain type. Enter an asterisk to display possible values at your site or see complete list of database types in the section Database Maintenance Menu.
Database number Limits the scope of the function to databases with the number specified.

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 ***
Meaning of Columns
Database ID

ID of the database object.

If the output option Mark implementation is set to Y, implemented objects are marked with an asterisk. For databases, "implemented" means that it is one of the following:

  • of type A and connected to a physical Adabas database,

  • of type D and connected to a physical DB2 database

  • of type P and its database number is defined in the NTDB macro as an Entire System Server database,

  • or of type I.
Type The database type. See Database Maintenance Menu.
P-DBnr The physical number of the database.
Vista Parm Accessibility of Adabas databases using Adabas Vista. Possible values are listed in the section Defining Basic Attributes of Databases.

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.
Retrieval type D B O T
dummies=Y|N dummies=D|P
Output Mode D L D L D L D L D L
Current/Related c c c r c r c c c r c r c r c r
Adabas sizes x   x       x   x       x      
Association attributes     x x x x     x x x x        
Attributes x   x       x   x       x      
Connecting character       x             x          
Description x   x x     x   x x     x      
Display modifier x   x       x   x       x      
Dummy/Placeholder                   x   x   x   x
Extract x   x x     x   x x     x x    
Keywords x   x x     x   x x     x      
Mark implementation x x x x x x x x x x x x x   x  
No. abstract lines x x x x x x x x x x x x x   x  
Owner x   x x     x   x x     x      
With users x   x x     x   x x     x      
Show implementation x   x       x   x       x      
Use Con-form x   x x     x   x x     x      
User exit x   x       x   x       x      
Retrieval Type U E C I
Output Mode D L T X L D T
Current/Related c c c r c r c r c r c r
Adabas sizes x                      
Association attributes     x x                
Attributes x     x   x            
Connecting character       x   x       x    
Description x         x       x    
Display modifier x                      
Dummy/Placeholder       x   x x   x      
Extract x     x   x     x x    
Keywords x     x   x       x    
Mark implementation x x x x x x   x   x x x
No. abstract lines x x   x   x   x   x   x
Owner x     x   x       x    
With users x                 x    
Show implementation x                      
Use Con-form x         x       x    
User exit x                      

On this page