Database display: Displaying definitions

Procedure

To display all Adabas Audit Data Retrieval databases:

  • From the "Primary Selection Menu", choose option D.1

    The "Data Set Definition Selection" table is displayed.

Dataset Definition Selection table

PEB5DD10 ----------------------------------------------------- Row 1 of 25
 Command ===> ________________________________________________ Scroll ===> PAGE

 Dataset Definition Selection Page 1 of 3
 ( LEFT/RIGHT )
 Databases for Subsystem SSID B92P SYSVAR Support : INACTIVE

 I - Insert Model F - Format Model
 S - Select Dataset Definition or D - Delete Model or Empty
 Update Model or Status R - Reset Model (ERR)
 X - Database Extension RX - Reset Database Extension (FEX)

 Sel Dataset Name X Total Free % Sta
 BETA97.DB.ARC 00010800 00010649 001 OPN
 BETA97.DB.ARC.KEY 00004500 00004482 000 OPN
 BETA97.DB.CACHE1 00018000 00004500 075 OPN
 BETA97.DB.CACHE2 000 MOD
 BETA97.DB.DEF 00000900 00000739 017 OPN
 BETA97.DB.GLOBL1 00036000 00032701 009 OPN
 BETA97.DB.INDEX1 00018000 00004500 075 OPN
 BETA97.DB.INDEX2 000 MOD
 BETA97.DB.LIST 00003600 00003271 009 OPN
 BETA97.DB.LIST.KEY 00003600 00003385 005 OPN
 BETA97.DB.LOG 00000600 00000392 034 OPN

Table columns

Each entry displays the size and usage:

  • Number of allocated 4K blocks (Total)
  • Number of 4K blocks that are currently unused (Free)
  • Percentage of 4K blocks that are currently used (%)
  • Status (OPeN, EMPty, FULl, MODel, readONLy, FORmat, ERRor, Format EXtend error)

You can display these columns by scrolling to the right (PF11):

  • Type (CAche, DAta, GLobal, IndeX, LOg, KEy, SPool, SYnc, NOt defined in Adabas Audit Data Retrieval database definition file)
  • High water mark

Primary commands

SORT columnname[,A|D]

Sorts the displayed table in ascending (A) or descending (D) order according to the specified column (For a list of column names, refer to the help panel.)

SORT

Displays a help panel on the SORT command for this table