|
|
|
The Database Estimator is used to estimate the size of a
database. The estimation is based on files in the temporary
database created with the DBSIZE job and from information in
prefix.MICS.PARMS(DBMODEL). Space is reported in tracks.
The following reports are produced:
o The Libname Summary Report provides overview information
for each timespan in the database.
o The Information Area Summary Report shows space
utilization for each Information Area within a timespan.
o The File Summary Report shows space utilization for each
file in a timespan. Note that all cycles for a file are
comprised in a single line entry.
For further information regarding space utilization reporting
and the Database Estimator, refer to section 4.4.4.6 of this
guide.
A sample report listing for the Database Estimator follows:
The Libname Summary Report lists space utilizations for each physical data set timespan of the database.
CA MICS Space Utilization and Reporting 07:21 Monday, February 12, 2007 Database Space Estimator Libname Summary Space Reporting Unit is Tracks Est. Max Used Allocated Projected Allocated Libname Dataset Name Block Size Space Space Space Space -------- -------------------------------------------- ---------- ---------- ---------- ---------- ---------- DETAIL SYS07043.T071526.RA000.JOBNAMED.DETAIL.H01 27,648 271.50 500.00 1,100.00 0.00 (1)(2) DAYS SYS07043.T071526.RA000.JOBNAMED.DAYS.H01 27,648 122.50 500.00 1,780.50 0.00 (1)(2) WEEKS SYS07043.T071526.RA000.JOBNAMED.WEEKS.H01 27,648 116.50 500.00 723.50 0.00 (1)(2) MONTHS SYS07043.T071526.RA000.JOBNAMED.MONTHS.H01 27,648 107.50 500.00 546.00 0.00 (1)(2) YEARS SYS07043.T071526.RA000.JOBNAMED.YEARS.H01 27,648 2.00 500.00 0.50 0.00 (2) ---------- ---------- ---------- ---------- 620.00 2,500.00 4,150.50 0.00 (1) Projected Space Exceeds Allocated; (2) Projected Space Exceeds Estimated Max.
Column Descriptions ------------------- Libname: The SAS libname of the timespan. Dataset name: The z/OS data set name of the timespan. Block size: The DCB block size of the data set. Used Space: Space currently used in the timespan. Allocated Space: Total space currently allocated to the timespan. This is computed as Used + Free space. Projected Space: Estimate of used space within a timespan when all files are at maximum cycles. Estimated Max Allocated Space: Estimate of the maximum size of the timespan if the maximum size of each remaining secondary extent is used.
The Information Area Summary Report shows space utilization for each Information Area within the timespan.
CA MICS Space Utilization and Reporting 07:21 Monday, February 12, 2007 Database Space Estimator Information Area Summary Space Reporting Units is Tracks Timespan: DETAIL; Libname: DETAIL; Dataset Name: SYS07043.T071526.RA000.JOBNAMED.DETAIL.H01 Device Type: 3390; Volume Count: 1; Block Size: 27,648 Allocated Tracks: 500; Used Tracks: 272; % Free: 45.70% Estimated Max Tracks: 0 Used Avg. Space Projected Projected Information Area Files Space %Used per Cycle Space %Used ---------------------------------------------- ------ ---------- ---------- ---------- ---------- ---------- (???) Unknown 1 0.50 0.10% 0.50 0.50 0.00% (ACT) Accounting Component 1 0.50 0.10% 0.50 1.00 0.00% (ADM) Administrative Activity Information Area 2 1.00 0.20% 0.50 1.00 0.00% (BAT) Batch Activity Information Area 21 128.00 25.60% 6.10 879.50 0.00% (HAR) Hardware Utilization 23 75.00 15.00% 3.26 76.00 0.00% (OPS) Operations Information Area 3 3.00 0.60% 1.00 3.00 0.00% (SCP) MVS System Control Program 20 34.00 6.80% 1.70 82.00 0.00% (TSO) TSO Information Area 6 9.00 1.80% 1.50 38.00 0.00% (WLM) MVS Workload Management 13 19.00 3.80% 1.46 19.00 0.00% ------ ---------- ---------- ---------- ---------- ---------- 90 270.00 54.00% 1.46 1,100.00 0.00% (1)(2) (1) Projected Space Exceeds Allocated; (2) Projected Space Exceeds Estimated Max.
Heading Descriptions ------- ------------- Timespan: The database timespan. Libname: The DDname used to reference the timespan data set. Dataset Name: The fully qualified data set name of the timespan. Device Type: The device type of the data set. Note that the device type is the same for all volumes of a multi-volume data set. Volume Count: Number of volumes of the timespan data set. Block Size: The z/OS block size of the data set. % Free: Percent of free space in the timespan data set. Allocated units: The amount of space currently allocated to timespan data set. Used units: The amount of space currently used in the timespan data set. Estimated Max units: The estimated maximum space of the timespan data set. This is computed by adding the requested size of the remaining secondary extents on the last volume of the timespan data set to the allocated space. Column Descriptions ------------------- Information Area: Name the Information Area within the timespan. Files: Total members in this Information Area. This includes valid and invalid (as listed in the Invalid Files report) file entries. Used Space: Space currently used in the Information Area. Note that the space used at the Libname summarization level may not equal the allocated space in the timespan. This difference is attributed to internal SAS usage. %Used: Percentage of allocated space used by the Information Area within the timespan. Avg Space/Cycle: Average space used by each cycle of the file within the timespan. Projected Space: Space used by this information area when all cycles of all files are created. Projected %Used: Percentage of the Estimated Maximum used.
The File Summary Report shows space utilization for each file within the timespan.
CA MICS Space Utilization and Reporting 07:21 Monday, February 12, 2007 Database Space Estimator File Summary Space Reporting Units is Tracks Timespan: DETAIL; Libname: DETAIL; Dataset Name: SYS07043.T071526.RA000.JOBNAMED.DETAIL.H01 Device Type: 3390; Volume Count: 1; Block Size: 27,648 Allocated Tracks: 500; Used Tracks: 272; % Free: 45.70% Estimated Max Tracks: 0 Information Area Used Avg. Space Def'd Estimated Estimated File Name Cycles Space %Used per Cycle Cycles Space %Used ------------------------------------------------- ------ ---------- -------- ---------- ------ ---------- ---------- ... (BAT) Batch Activity Information Area (_OE) OPEN EDITION/MVS PROGRAM FILE 1 2.00 0.40% 2.00 0 2.00 0.00% (_SA) SYSTEM ADDRESS SPACE ACTIVITY FILE 1 2.00 0.40% 2.00 0 2.00 0.00% (_ST) SYSTEM TASK PROGRAM ACTIVITY FILE 1 3.00 0.60% 3.00 0 3.00 0.00% (_TP) APPC/MVS TP ACTIVITY FILE 1 2.00 0.40% 2.00 0 2.00 0.00% (_TS) SMF USER TSO ACTIVITY FILE 1 2.00 0.40% 2.00 0 2.00 0.00% (ATP) APPC/MVS TRANSACTION FILE 1 1.00 0.20% 1.00 0 1.00 0.00% (JOB) BATCH USER JOB ACTIVITY FILE 1 2.00 0.40% 2.00 0 2.00 0.00% (MUA) MEASURED USAGE ADDRESS SPACE FILE 1 1.00 0.20% 1.00 0 1.00 0.00% (MUG) MEASURED USAGE GLOBAL FILE 1 1.00 0.20% 1.00 30 30.00 0.00% (OEP) OPEN EDITION PROCESS ACTIVITY FILE 1 1.50 0.30% 1.50 0 1.50 0.00% (PGM) BATCH USER PROGRAM ACTIVITY FILE 1 3.00 0.60% 3.00 0 3.00 0.00% (REN) MULTISYSTEM ENCLAVE ACTIVITY FILE 1 1.00 0.20% 1.00 0 1.00 0.00% (SPL) BATCH USER SPOOL ACTIVITY FILE 1 1.00 0.20% 1.00 0 1.00 0.00% (WDA) BATCH WORKLOAD DEVICE ACTIVITY FILE 1 2.00 0.40% 2.00 1 2.00 0.00% ---------------------------------------------- ---------- -------- ---------- ---------- (BAT) Batch Activity Information Area 24.50 4.90% 53.50 0.00% ... ============================================== ========== ======== ========== ========== 121.00 24.20% 1,780.50 0.00% (1) (1) Projected Space Exceeds Allocated; (2) Projected Space Exceeds Estimated Max.
Heading Descriptions ------- ------------- Timespan: The database timespan. Libname: The DDname used to reference the timespan data set. Dataset Name: The fully qualified data set name of the timespan. Device Type: The device type of the data set. Note that the device type is the same for all volumes of a multi-volume data set. Volume Count: Number of volumes of the timespan data set. Block Size: The z/OS block size of the data set. % Free: Percent of free space in the timespan data set. Allocated units: The amount of space currently allocated to timespan data set. Used units: The amount of space currently used in the timespan data set. Estimated Max units: The estimated maximum space of the timespan data set. This is computed by adding the requested size of the remaining secondary extents on the last volume of the timespan data set to the allocated space. Column Descriptions ------------------- Information Area: Name the information area within the timespan. File Name: Name the file area within the timespan. Cycles: Total iterations (cycles) of this file within the timespan. Used Space: Space currently used by the file. Note that the space used at the Libname summarization level may not equal the allocated space in the timespan. This difference is attributed to internal SAS usage. %Used: Percentage of allocated space used by the File within the timespan. Avg Space/Cycle: Average space used by each cycle within the timespan. Def'D Cycles: Number of cycles as defined in prefix.MICS.PARMS(DBMODEL). Estimated Space: Space used by this file area when all cycles are created. Estimated %Used: Percent of the Estimated Maximum used.
| Copyright © 2012 CA. All rights reserved. | Tell Technical Publications how we can improve this information |