Database display: How full is your database?

Procedure

From the Primary Selection Menu, choose option D - DATABASE, then 2 ‑ DICTIONARY, then 4 - DATABASE to display the System Database Display table. This panel displays the following information for each database:

  • Dataset name
  • Status (OPeN, EMPty, FULl, MODel, readONLy, FORmat, ERRor, Format EXtend error)
  • File ID
  • Defined buffer size
  • Percentage of used space
  • Type (CAche, DAta, GLobal, IndeX, LOg, KEy, SPool, SYnc, NOt defined in Adabas Audit Data Retrieval database definition file)
  • High water mark

System Database Display table

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

 Display System Databases ( LEFT/RIGHT )

 Data Set Name X Stat FileID Buffer % Type HWM
 BETA97.DB.ARC OPN 01013 00000050 001 DA 90
 BETA97.DB.ARC.KEY OPN 01015 00000050 000 KE 90
 BETA97.DB.CACHE1 OPN 01011 00000000 075 CA --
 BETA97.DB.CACHE2 MOD 01030 00000000 000 CA --
 BETA97.DB.DEF OPN 00001 00000000 017 NO --
 BETA97.DB.GLOBL1 OPN 01023 00000000 009 GL --
 BETA97.DB.INDEX1 OPN 01005 00010000 075 IX --
 BETA97.DB.INDEX2 MOD 01007 00010000 000 IX --
 BETA97.DB.LIST OPN 01008 00000100 009 DA 90
 BETA97.DB.LIST.KEY OPN 01006 00000100 005 KE 90
 BETA97.DB.LOG OPN 01001 00000000 034 LO --
 BETA97.DB.MAIN OPN 01002 00000010 034 DA 90
 BETA97.DB.MAIN.KEY OPN 01004 00000010 035 KE 90
 BETA97.DB.MSG OPN 01017 00000100 004 DA 90
 BETA97.DB.MSG.KEY OPN 01018 00000100 004 KE 90
 BETA97.DB.NOTES OPN 01020 00000010 001 DA 90
 BETA97.DB.NOTES.KEY OPN 01019 00000010 000 KE 90
 BETA97.DB.SFR OPN 01026 00000100 000 DA 90

System Database Display table (detailed view PF10/PF11)

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

 Display System Databases ( LEFT/RIGHT )

 Dataset Name X Sta FileID Buffer % Type HWM
 BETA97.DB.ARC OPN 01013 00000050 001 DA 90
 VolSer: SBSA01 Unit: 3390 Space: 000060 Cyl CIsize: 04096 ShortName: ARCDATA
 -------------------------------------------------------------------------------
 BETA97.DB.ARC.KEY OPN 01015 00000050 000 KE 90
 VolSer: SBSA01 Unit: 3390 Space: 000025 Cyl CIsize: 04096 ShortName: ARCKEY
 -------------------------------------------------------------------------------
 BETA97.DB.CACHE1 OPN 01011 00000000 075 CA --
 VolSer: SBSA01 Unit: 3390 Space: 000100 Cyl CIsize: 04096 ShortName: CACHE1
 -------------------------------------------------------------------------------
 BETA97.DB.CACHE2 MOD 01030 00000000 000 CA --
 VolSer: SBSA01 Unit: Space: 000100 Cyl CIsize: 04096 ShortName: CA001030
 -------------------------------------------------------------------------------
 BETA97.DB.DEF OPN 00001 00000000 017 NO --
 VolSer: Unit: Space: Cyl CIsize: 04096 ShortName: B97DEF
 -------------------------------------------------------------------------------
 BETA97.DB.GLOBL1 OPN 01023 00000000 009 GL --
 VolSer: SMS Unit: Space: 000200 Cyl CIsize: 04096 ShortName: SP001023
 -------------------------------------------------------------------------------

Enlarging databases

If one of the Adabas Audit Data Retrieval databases is getting full, you may have to enlarge it. You can generate JCL for this online under option D.4 or use the tailored JCL in BETA97.CNTL(B97DBENL). This utility backs up the existing database and creates a larger database using IDCAMS. For more information, see the Adabas Audit Data Retrieval Installation and System Guide.