General Information › What Does CA IDMS/DB Analyzer Do? › Statistic Collection

Statistic Collection

CA IDMS/DB Analyzer produces statistics that provide a firm foundation for decision making. These statistics show raw counts, percentages, means, minimum and maximum values, and the distribution of values across page ranges and other types of ranges. Statistics are collected at four different levels of physical organization—AREA, RECORD, SET, and INDEX. These statistics permit:

An analysis by AREA and RECORD TYPE of such characteristics as:

• Total record occurrences
• Relocated record occurrences
• Fragmented record occurrences
• Logically deleted record occurrences
• Savings due to record compression
• Space used

An analysis by AREA of characteristics such as:

• Space allocated for pointers, data, line indexes, and headers/footers
• Free space
• Physically and logically full pages
• Space management pages
• Empty pages

An analysis by SET TYPE of such characteristics as:

• Owner record occurrences
• Owner occurrences with one or more members
• Page distribution of set occurrences
• Member record occurrences on target page
• Member record occurrences on overflow
• Page changes when set walking

An analysis by INDEX SET of such characteristics as:

• Upper level blocks, page spread, and table entries
• Upper level blocks stored inside and outside bottom level offset
• Bottom level blocks, page spread, and table entries
• Number of index levels.