ADABAS Files

The ADABAS DB File attributes provide summary information on ADABAS Database files.

Managed System: The SMS name of this system.

Collection Time: Time when data was collected.

Host: Host name.

SVC Number: SVC Number.

Database Identification Number: Database ID number.

File Number: Database file number.

File Name: Database file name.

Data Allocated Bytes: Storage allocated for data component for current file, in bytes.

Data Used Bytes: The used storage of the data component for the current file, in bytes.

Address Converter Allocated Bytes: Storage allocated for the Address Converter component for the current file, in bytes.

Address Converter Used Bytes: Storage used for the Address Converter component for the current file, in bytes.

Upper Index Allocated Bytes: Storage allocated for Upper Index for the current file, in bytes.

Upper Index Used Bytes: Storage used for Upper Index for the current file, in bytes.

Normal Index Allocated Bytes: Storage allocated for Normal Index for the current file, in bytes.

Normal Index Used Bytes: Storage used for Normal Index for the current file, in bytes.

Total Allocated Bytes: Total storage allocated for data, Address Converter, Upper Index and Normal Index components for current file, in bytes.

Total Used Bytes: Total storage used for data, Address Converter, Upper Index and Normal Index components for current file, in bytes.

Database Name: Name assigned to database.

Locked Update File is locked update.

Replicated: File is replicated.

Refresh Permitted: File can be refreshed using the E1 command.

User ISN: File was loaded with the USERISN option.

File Updated: File was updated.

No AC Extension: File permits increasing MAXISN setting.

Privileged Use: File is in privileged usage mode.

Reuse allowed: ISN reuse is allowed.

First Unused ISN: Highest ISN currently used in the file + 1.

Top Expect ISN: Highest ISN that can be assigned to a record in the file.

Highest Index Level: Highest Index Level.

Load Time: Date and Time when the file was loaded.

Last Update: Date and Time of the last file update.

Start ISN Number: Minimum ISN number.

ISN Size: Whether the file contains 3-byte or 4-byte ISNs.

Max Compressed Record Length: Maximum compressed record length permitted for the file.

Number Of Updates: Number of file updates.

Number Of Records: Number of records loaded to file.

Max DS Extentions In Blocks: Maximum number of blocks which may be allocated for each Data Storage secondary extent.

Max UI Extentions In Blocks: Maximum number of blocks which may be allocated for each Upper Index secondary extent.

Max NI Extentions In Blocks: Maximum number of blocks which may be allocated for each Normal Index secondary extent.

DATA Percent Used: Padding factor for DATA component.

ASSO Percent Used: Padding factor for ASSO component.

Sysplex Name: Sysplex name.

DATA Unused Bytes: The unused storage of DATA component for current file, in bytes.

Address Converter Unused Bytes: The unused storage of Address Converter for current file, in bytes.

Upper Index Unused Bytes: The unused storage of Upper Index for current file, in bytes.

Normal Index Unused Bytes: The unused storage of Normal Index for current file, in bytes.

Total Unused Bytes: The unused storage for DATA, Address Converter, Upper Index and Normal Index components for current file, in bytes.

Data Allocated Cyl: Storage allocated for DATA component for current file, in cylinders.

Data Used Cyl: The used storage of DATA component for current file, in cylinders.

Data Unused Cyl: The unused storage of DATA component for current file, in cylinders.

Address Converter Allocated Cyl: Storage allocated for Address Converter component for current file, in cylinders.

Address Converter Used Cyl: The used storage of Address Converter for current file, in cylinders.

Address Converter Unused Cyl: The unused storage of Address Converter for current file, in cylinders.

Upper Index Allocated Cyl: Storage allocated for Upper Index for current file, in cylinders.

Upper Index Used Cyl: The used storage of Upper Index for current file, in cylinders.

Upper Index Unused Cyl: The unused storage of Upper Index for current file, in cylinders.

Normal Index Allocated Cyl: Storage allocated for Normal Index for current file, in cylinders.

Normal Index Used Cyl: The used storage of Normal Index for current file, in cylinders.

Normal Index Unused Cyl: The unused storage of Normal Index for current file, in cylinders.

Total Allocated Cyl: Total storage allocated for DATA, Address Converter, Upper Index and Normal Index components for current file, in cylinders.

Total Used Cyl: The used storage for DATA, Address Converter, Upper Index and Normal Index components for current file, in cylinders.

Total Unused Cyl: The unused storage for DATA, Address Converter, Upper Index and Normal Index components for current file, in cylinders.

Data Storage Extents: Number of logical extents currently assigned to Data Storage.

Address Converter Extents: Number of logical extents currently assigned to Address Converter.

Upper Index Extents: Number of logical extents currently assigned to Upper Index.

Normal Index Extents: Number of logical extents currently assigned to Normal Index.

File UQ DE: File has options "DE,UQ".