The ADADRU SPACEUSAGE utility function can be used to produce summarized and detailed reports about database file space usage. The database files space usage reports show information such as:
RABN space usage;
RABN free space for either or both the Associator (normal index) or Data Storage, with an indication of the available padding space inside the free space;
Free blocks;
Average file record lengths; and
Average file record counts.
A summary report is always produced by the ADADRU SPACEUSAGE utility function. You can request that detail reports also be produced by specifying "DETAIL" for the PFILESPACE, PASSOSPACE, or PDATASPACE parameters; this will produce detail reports in addition to the summary report.
You can use the information in these reports when deciding if database or file level reorganization is necessary. They can be used to help you optimize block sizes, decrease file fragmentation, decrease file space usage, and increase the overall performance of the database files.
The FILE parameter of the ADADRU SPACEUSAGE utility function is an optional parameter that identifies the files that should be processed by the utility. More than one FILE parameter can be specified in an ADADRU SPACEUSAGE request. If the FILE parameter is omitted, all files in the database are processed for the report. Each FILE parameter specifies a file group. ADADRU SPACEUSAGE reports are produced for each file group; one report set (summary report only or a combination of detail and summary reports) is produced for each file group in an ADADRU SPACEUSAGE run.
For each instance of the FILE parameter (each file group), specific FROMRABN, TORABN, PFILESPACE, PASSOSPACE, PDATASPACE, SAMPLING, INCRUSAGE, INCRNUMREC, INCRRECLEN, OUTPUT, LOBGROUP, EXPGROUP and ERRLIM parameters may be specified, although none of these parameters are required. When specified, these parameter should immediately follow the FILE parameter (file group) to which they apply.
When ADADRU processes a SPACEUSAGE report request for multiple file groups, it analyzes all parameters of all file groups up to the next ADADRU SPACEUSAGE specification or to the end of the parameter list. File processing is started only after consolidation of all parameters from all file groups of the current SPACEUSAGE function. Processing is normally performed by file, in ascending order by file number. The exception is expanded files which are processed in logical sequence of their parts when the EXPGROUP parameter specified.
Every file is processed only once with one consolidated list of parameters and the resulting reports represent those consolidated parameters. Consider the following example:
ADADRU SPACEUSAGE FILE=2-5,7,9,15-20,PDATASPACE=SUMMARY,INCRUSAGE=5 ADADRU FILE=3,PDATASPACE=DETAIL,INCRUSAGE=2
The result of a run of these ADADRU SPACEUSAGE specifications are as follows:
No report is produced for Associator (ASSO) usage.
For all specified files, except repeated file 3, only the summary report for Data Storage (DATA) usage is produced, using the parameter setting of INCRUSAGE=5.
For repeated file 3, both the summary and detailed reports are produced for Data Storage (DATA) usage, using the parameter setting of INCRUSAGE=2. In this case, the summary report is produced because one is always produced when a detail report is requested.
During consolidation, the general rule is to choose the more detailed value of every parameter. A list of the consolidated parameters used in reporting is printed in front of the report.
The rest of this section describes how specific ADADRU SPACEUSAGE parameters are consolidated:
If the same file is specified in several file groups and different values of the SAMPLING parameter are included in these file groups, then the largest specified SAMPLING value is used in the consolidated parameters for the file. If SAMPLING is omitted in one group and is included in another group, then the specified value of the SAMPLING parameter is used in the consolidated parameters for the file. The default value is "100".
If the same file is specified in several file groups and different values of the INCRUSAGE parameter are included in these file groups, then the smallest specified value is used in the consolidated parameters for the file. If INCRUSAGE is omitted in one group and is included in another group, then the specified value of the INCRUSAGE parameter is used in the consolidated parameters for the file. The default value is "5".
If the same file is specified in several file groups and different values of the INCRNUMREC or INCRRECLEN parameters are included in these file groups, then the smallest specified values are used in the consolidated parameters for the file. If INCRNUMREC or INCRRECLEN is omitted in one group and is included in another group, then the specified value of the INCRNUMREC/ INCRRECLEN parameter is used in the consolidated parameters for the file. The default value is "AUTO".
The FROMRABN and TORABN parameters are designed to limit the volume of processed information and the size of the produced report. You can specify several FROMRABN/TORABN groups for ASSO and DATA in the same ADADRU SPACEUSAGE run. Where specifications overlap, they are combined into one range. Otherwise, the ranges are concatenated in parameters. The maximum number of FROMRABN/TORABN ranges that can be processed for one file is eight.
If the FROMRABN/TORABN parameters are omitted in one file group (indicating that all RABNs should be processed), but are specified in other file groups for the same file, the specified FROMRABN/TORABN ranges are used for the file. Subsequent file groups including the file will only be allowed to add specific RABNs -- requests to reset the range to all RABNs will be ignored.
ADADRU SPACEUSAGE processes only RABNs belonging to the file. If some RABNs from specified FROMRABN/TORABN ranges are outside the range for any given file extent, ADADRU will not check them. If none of the specified FROMRABN/TORABN ranges belong to given file, ADADRU issues an error message.
If SUMMARY and DETAIL values are specified differently for the same file in different file groups, both parameters are used for the report.
If the LOBGROUP or EXPGROUP parameters are specified for the file in any file group, they are used in the consolidated parameters for the file.
In the following example, file 5 is specified in five file groups in the same ADADRU run.
ADADRU SPACEUSAGE FILE=5,INCRUSAGE=15,PASSOSPACE=DETAIL ADADRU FROMRABN=100,TORABN=250 ADADRU FILE=5,INCRUSAGE=10,PDATASPACE=SUMMARY ADADRU FROMRABN=1000,TORABN=1250 ADADRU FILE=5,PASSOSPACE=SUMMARY, ADADRU FROMRABN=150,TORABN=500 ADADRU FILE=5,INCRUSAGE=2,PASSOSPACE=SUMMARY ADADRU FROMRABN=750,TORABN=1500 ADADRU FILE=5,INCRUSAGE=25,PDATASPACE=SUMMARY ADADRU INCRNUMREC=100
As a result, file 5 will be processed with the following consolidated parameters:
ASSO: Report=DETAIL + SUMMARY INCRUSAGE=2 FROMRABN=100,TORABN=500 FROMRABN=750,TORABN=1500 + other parameters with default values. DATA: Report=SUMMARY INCRUSAGE=10 INCRNUMREC=100 FROMRABN=1000,TORABN=1250 + other parameters with default values
This section describes the syntax and parameters of the SPACEUSAGE function.
There are no required parameters for the ADADRU SPACEUSAGE utility function. If no parameters are specified, summary space usage reports are produced for both the Associator and Data Storage areas of all files in the database. In this case, no XML output is produced and any LOB group chains that might be present in the database files are processed and reported in their physical file sequences. Expanded files processed are presented in the report in the same logical sequence as they are in the expanded file chain, starting with the anchor file. The defaults for all other parameters are used.
- ABEND34: Change User Abend 35 to 34
This optional parameter can be used to change a user abend 35 to user abend 34 if a utility error occurs. This ensures that a dump is produced when the utility terminates abnormally.
The NOUSERABEND, TEST, and ABEND34 parameters affect the processing of the entire ADADRU run.
- ACODE: Identify Code Page for XML UTF-8 Output
Use the ACODE parameter only if the UTF8 option is specified on the OUTPUT parameter. This parameter identifies the code page to which the database name, file names, and checkpoint names should be converted. This parameter is specified in three parts, in a specific order, and with each part separated by a comma from the others:
ACODE='database-name-codepage,file-name-codepage,checkpoint-name-codepage'
The database-name-codepage can either be the literal "GCB" or a valid code page number (dbcodepg).
The file-name-codepage can either be the literal "GCB", the literal "FCB", or a valid code page number (fncodepg).
The checkpoint-name-codepage can either be the literal "GCB" or a valid code page number (cpcodepg)
A setting of "GCB" for any part indicates that the code page for that part should be acquired from the code page in the GCB (the GCB ACODE setting). A setting of "FCB" for the file-name-codepage indicates that the code page for converting file names in the XML document to UTF-8 should be acquired from the code page setting in the FCB (the FCB ACODE setting).
If code pages for all three parts of the ACODE parameter are being specified, they must be specified in the order shown above. However, if you only need to specify the code page of the database name conversion, you only need to specify the first part. If you only need to specify the code page of the database name and file name conversions, you only need to specify the first two parts. If you do not need to specify the code page for an earlier part in the sequence, simply specify a comma for that part instead. For example, if you only need to specify the code page setting for the checkpoint name UTF-8 conversion, you might specify:
ACODE=',,37'Note the two commas specified prior to the checkpoint code page number, 37. These identify the placement of the blank database name and file name code page specifications.
If the ACODE parameter is specified but the OUTPUT parameter is omitted, a setting of
OUTPUT='XML,UTF8'is assumed.- ERRLIM: Maximum Number of Errors Accepted
This optional parameter specifies the maximum number of errors that can occur before ADADRU processing terminates. Valid values range from 1 through 255. The default is 1.
The ERRLIM parameter is defined within a file group.
- EXPGROUP: Expanded File Chain Processing
Specify this optional parameter within a file group if you want expanded files processed and presented in the report in the same logical sequence as they are in the expanded file chain, starting with the anchor file. If just one file from the expanded file chain is specified in the file group, but the EXPGROUP parameter is specified as well, ADADRU will process the every file from expanded files chain.
If this parameter is not specified, expanded files are processed without looking for expanded file associations. The EXPGROUP option is the default when all files in a database are requested for the ADADRU SPACEUSAGE report.
If no expanded files are encountered in the files specified for an ADADRU SPACEUSAGE run, the presence of the EXPGROUP parameter has no effect on the report.
The EXPGROUP parameter is defined within a file group.
- FILE: Files for the Report
When specified, the FILE parameter must be the first parameter specified after the SPACEUSAGE keyword in an ADADRU SPACEUSAGE utility job. If you omit this optional parameter, all files in the database are analyzed and included in the SPACEUSAGE report; this is the default.
Use the FILE parameter to identify files in the database that should be analyzed for the SPACEUSAGE report. You can specify a single file number, a series of file numbers, or both single files and file series in an ADADRU SPACEUSAGE run. A maximum of 32 single files or file series can be specified in the FILE parameter.
When you specify a series of file numbers, use dashes between the file numbers. The following example would select files 2, 3, 4, and 5 for the report.
FILE=2-5When you specify multiple single file numbers or a combination of single file numbers and file series, separate them with commas. The following example would select files 2, 3, 4, 5, 11, 13, 14, 15, 16, and 18 for the report.
FILE=2-5,11,13-16,18Overlapping or repeated file numbers are allowed. The following example is a valid specification:
FILE=2-8,1-4,5,6-11In this example, files 2, 3, 4, 5, 6, 7, and 8 are requested in more than one of the FILE parameter specifications. The repeated files will be presented in the SPACEUSAGE report only once, in sorted order.
The FILE parameter can be specified more than once in ADADRU SPACEUSAGE request. Each FILE parameter specifies a file group. For each instance of the FILE parameter (each file group), specific FROMRABN, TORABN, PFILESPACE, PASSOSPACE, PDATASPACE, SAMPLING, INCRUSAGE, INCRNUMREC, INCRRECLEN, OUTPUT, LOBGROUP, EXPGROUP and ERRLIM parameters may be specified, although none of these parameters are required. When specified, these parameter should immediately follow the FILE parameter (file group) to which they apply. For more information, read SPACEUSAGE File Group Processing.
- FROMRABN: Data Storage Block Number
The RABN of the Data Storage or Associator block where report processing should begin. It is often paired with the TORABN parameter to specify a range of RABN blocks.
If the FROMRABN parameter is omitted and the TORABN parameter is specified, processing is performed from the beginning of the file to the block specified by the TORABN parameter. If the FROMRABN parameter is specified and the TORABN parameter is omitted, processing is performed from the FROMRABN block to the end of the file. The FROMRABN parameter can only be specified as a subparameter of the PASSOSPACE or PDATASPACE parameters.
The FROMRABN parameter is applicable only if a file group consists of a single file. Only one FROMRABN/TORABN range can be specified for a single file group.
The maximum number of FROMRABN/TORABN ranges that can be specified for the same file in a single ADADRU SPACEUSAGE run is eight. If more than one FROMRABN/TORABN range is specified for a single file, the ranges are consolidated. For more information, read FROMRABN/TORABN Parameter Consolidation.
- INCRNUMREC: Increment for Distribution Report's Number of Elements per Block Distribution
This optional parameter specifies the increment for the number of elements per block section of the Distribution reports produced about ASSO and DATA file space usage. For more information, review the Distribution report sample in Sample Report.
Valid values range from 1 through 10000. If this parameter is omitted, ADADRU will calculate this increment automatically, with the goal of providing a report in the best reviewable form, with a total number of lines less than 100.
The INCRNUMREC parameter is defined within a file group.
- INCRRECLEN: Increment for DATA Distribution Report's Record Length Area
This optional parameter specifies the increment for record lengths used in the record length section of the Distribution reports produced about DATA file space usage. Lines with zero values (number of records with lengths of zero) are not printed in the report. For more information, review the DATA Distribution report sample in Sample Report.
This parameter is only valid for Data Storage reports; you will not find a record length section in the Distribution reports about ASSO file space usage.
Valid values range from 6 through 5000. If this parameter is omitted, ADADRU will calculate this increment automatically, with the goal of providing a report in the best reviewable form, with a total number of lines less than 100.
The INCRRECLEN parameter is defined within a file group.
- INCRUSAGE: Percent Increment for Distribution Report's Block Filling Level Area
This optional parameter specifies the percentage increment for the block filling level of the Distribution reports produced about ASSO and DATA file space usage. Valid values range from 1 through 50 percent; the default is 5. For more information, review the Distribution report sample in Sample Report.
The INCRUSAGE parameter is defined within a file group.
- LOBGROUP: Large Object Group Processing
Specify this optional parameter if you want LOB files processed. Files are handled in their physical file sequences (i.e., the file with the lowest number is processed first regardless of whether it is a LOB or base file).
If this parameter is not specified, LOB files are processed without looking for LOB file associations. The LOBGROUP option is the default when all files in a database are requested for the ADADRU SPACEUSAGE report.
If no LOB files are encountered in the files specified for an ADADRU SPACEUSAGE run, the presence of the LOBGROUP parameter has no effect on the report.
The LOBGROUP parameter is defined within a file group.
- NOUSERABEND: Termination without Abend
When a parameter error or a functional error occurs while this utility function is running, the utility ordinarily prints an error message and terminates with user abend 34 (with a dump) or user abend 35 (without a dump). If NOUSERABEND is specified, the utility will not abend after printing the error message. Instead, the message "utility TERMINATED DUE TO ERROR CONDITION" is displayed and the utility terminates with condition code 20.
Note:
When NOUSERABEND is specified, we recommend that it be specified as the first parameter of the utility function (before all other parameters). This is necessary to ensure that its parameter error processing occurs properly.The NOUSERABEND, TEST, and ABEND34 parameters affect the processing of the entire ADADRU run.
- OUTPUT: Create XML Output
This optional parameter should be used when you want to create an XML version of the database report in addition to the normal one. The format of the XML report can be either EBCDIC or converted to UTF-8:
If you specify: The XML report format will be: OUTPUT='XML'EBCDIC OUTPUT='XML,UTF8'Converted to UTF-8 (including all tags). When UTF-8 format is requested, you may also use the ACODE parameter to specify the specific code page to which the database base name, file names, and checkpoint names should be converted. When the OUTPUT parameter is specified, additional DD statements (DDXMLR1 and, optionally, DDXMLR2) must be specified in the ADAREP job.
DDXMLR1 is required and identifies the data set to which the XML version of the base database report should be written.
DDXMLR2 is used to store the XML version of any checkpoint information in the report; it is therefore only required if checkpoint information is requested for the report via the CPLIST or CPEXLIST parameters.
On z/OS, the data sets specified by these DD statements must be defined with DCB parameters RECFM=VB, LRECL=512.
The resulting XML documents exactly match the information produced in the regular report, including any filtering done for the report (for example if NOFDT or NOPPT are requested). Once the XML document is created, it can be transferred to a Windows or UNIX machine and you can use your own code or other tools to transform it.
The XML document is structured as defined by an XML schema definition file (adabas.xsd) provided in the online Community Discussion Forum for Adabas (https://tech.forums.softwareag.com/t/files-for-processing-adarep-xml-output-ada822/92450). A style sheet (adabas.xsl) is also provided for your use at the same location. You can transfer these XML files from the Adabas Forum to any system (probably Windows or UNIX) using automated tools or user-written programs in the programming language of your choice (Natural, Java, .Net, C, Perl, or Python).
- PASSOSPACE: Process Only ASSO File Areas
The PFILESPACE, PASSOSPACE, and PDATASPACE parameters are mutually exclusive. If none of these parameters are specified, PFILESPACE=SUMMARY is used as a default.
The PASSOSPACE parameter indicates that only the normal index blocks (NI blocks) of the Associator (ASSO) file area should be processed for the ADADRU SPACEUSAGE report. Using the SUMMARY and DETAIL values of the PASSOSPACE parameter, you can indicate whether a detailed report (DETAIL) should be produced; a summary report (SUMMARY) is always produced. If DETAIL is specified, both a detail report and a summary report are produced; if DETAIL is not specified, only a summary report is produced.
The PASSOSPACE parameter is defined within a file group.
In addition, if a single file is being processed, you can use the FROMRABN and TORABN parameters to specify an RABN range that should be processed.
- PDATASPACE: Process Only DATA File Areas
The PFILESPACE, PASSOSPACE, and PDATASPACE parameters are mutually exclusive. If none of these parameters are specified, PFILESPACE=SUMMARY is used as a default.
The PDATASPACE parameter indicates that only the Data Storage (DATA) file area should be processed for the ADADRU SPACEUSAGE report. Using the SUMMARY and DETAIL values of the PDATASPACE parameter, you can indicate whether a detailed report (DETAIL) should be produced; a summary report (SUMMARY) is always produced. If DETAIL is specified, both a detail report and a summary report are produced; if DETAIL is not specified, only a summary report is produced.
The PDATASPACE parameter is defined within a file group.
In addition, if a single file is being processed, you can use the FROMRABN and TORABN parameters to specify an RABN range that should be processed.
- PFILESPACE: Process Both ASSO and DATA File Areas
The PFILESPACE, PASSOSPACE, and PDATASPACE parameters are mutually exclusive. If none of these parameters are specified, PFILESPACE=SUMMARY is used as a default.
The PFILESPACE parameter indicates that both the normal index blocks (NI blocks) of the Associator (ASSO) file area and the Data Storage (DATA) file area should be processed for the ADADRU SPACEUSAGE report. Using the SUMMARY and DETAIL values of the PFILESPACE parameter, you can indicate whether a detailed report (DETAIL) should be produced; a summary report (SUMMARY) is always produced. If DETAIL is specified, both a detail report and a summary report are produced; if DETAIL is not specified, only a summary report is produced.
The PFILESPACE parameter is defined within a file group. If PFILESPACE=SUMMARY, all files are processed.
- SAMPLING: Percentage of Blocks Read for Summary Reports
This optional parameter specifies the percentage of RABN blocks that should be read to generate summary reports. Valid values range from 10 through 100 percent. The default is 100, which indicates that all file RABNs should be processed to generated summary reports.
The SAMPLING parameter is defined within a file group.
- TEST: Test Syntax
The TEST parameter tests the operation syntax without actually performing the operation. Note that the validity of values and variables cannot be tested: only the syntax of the specified parameters can be tested. See Syntax Checking with the TEST Parameter for more information about using the TEST parameter in ADADRU functions.
The NOUSERABEND, TEST, and ABEND34 parameters affect the processing of the entire ADADRU run.
- TORABN: Ending Data Storage Block Number
The RABN of the Data Storage or Associator block where report processing should end. It is often paired with the FROMRABN parameter to specify a range of RABN blocks.
If the FROMRABN parameter is omitted and the TORABN parameter is specified, processing is performed from the beginning of the file to the block specified by the TORABN parameter. If the FROMRABN parameter is specified and the TORABN parameter is omitted, processing is performed from the FROMRABN block to the end of the file. The TORABN parameter can only be specified as a subparameter of the PASSOSPACE or PDATASPACE parameters.
The TORABN parameter is applicable only if a file group consists of a single file. Only one FROMRABN/TORABN range can be specified for single file group.
The maximum number of FROMRABN/TORABN ranges that can be specified for the same file in a single ADADRU SPACEUSAGE run is eight. If more than one FROMRABN/TORABN range is specified for a single file, the ranges are consolidated. For more information, read FROMRABN/TORABN Parameter Consolidation.
In the following example, detail and summary space usage reports will be produced for both the ASSO and DATA areas for files 5 and 9. In the Distribution report, a block filling level increment of 10 percent will be used.
ADADRU SPACEUSAGE FILE=5,9,PFILESPACE=DETAIL,INCRUSAGE=10
In the following example, detail and summary space usage reports will be produced for only the DATA area of file 7, starting at RABN 10048. In the Distribution report, a block filling level increment of 8 percent will be used.
ADADRU SPACEUSAGE FILE=7,INCRUSAGE=8,FROMRABN=10048,PDATASPACE=DETAIL
In the following example, detail and summary space usage reports will be produced for only the DATA area of file 7. In addition, XML output is generated for detail and summary reports and converted to UTF-8 format:
ADADRU SPACEUSAGE FILE=7,PDATASPACE=DETAIL,OUTPUT='XML,UTF8'
To see a sample of these reports, read Sample Report.
If you request detail reports (if parameter PFILESPACE, PASSOSPACE, or PDATASPACE is set to "DETAIL"), the "File ASSO/DATA Detail Report" is produced, as appropriate. The report can be directed to a specific file using the DD statement with the name DDDETAIL. (For more information, read JCL/JCS Requirements and Examples . Detail reports may be very large because information may be printed for every RABN in a file (or a specific RABN range).
In the Data Storage Detail section of the report the column header "Spanned" is always printed, regardless of whether or not the file supports spanned records. The "Spanned" column is split into two columns called "Num" and "Flg". The "Num" column provides the number of spanned record segments in each Data Storage RABN. The "Flg" column values can be "P", "S", "L", or a blank, identifying the segment of the spanned record stored at the RABN:
"P" indicates that the current RABN contains the primary segment of the spanned record.
"S" indicates that the current RABN contains a secondary segment of the spanned record.
"L" indicates that the current RABN contains the last segment of the spanned record.
A blank indicates that the current RABN does not contain any segment of a spanned record.
This section provides some sample ADADRU sample reports. The ADADRU SPACEUSAGE parameters used in each sample report are shown at the beginning of the report.
This sample report shows parameters INCRUSAGE, INCRNUMREC, INCRECLEN and FROMRABN/TORABN for files 1 and 5 being consolidated. ADADRU builds a list of the RABNs that must be processed based on the FROMRABN/TORABN parameters. If some RABNs belong to more than one FROMRABN/TORABN range, the ranges are combined into one range. ADADRU examines all of the settings of the INCRUSAGE, INCRNUMREC, and INCRRECLEN parameters for the file group and chooses the most detailed value for every parameter. ADADRU processes the files and produces the reports only after all parameters have been consolidated as appropriate.
A D A D R U V8.2 SM8 DBID = 00821 Started 2012-05-11 12:37:52
Parameters:
-----------
ADADRU NOUSERABEND
ADADRU SPACEUSAGE FILE=5,PASSOSPACE=DETAIL,FROMRABN=2072,TORABN=2075
ADADRU INCRUSAGE=7,INCRNUMREC=11,INCRRECLEN=33
ADADRU FILE=5,PASSOSPACE=DETAIL,FROMRABN=2086,TORABN=2090
ADADRU FILE=1,PDATASPACE=DETAIL,FROMRABN=21,TORABN=23
ADADRU INCRUSAGE=6,INCRNUMREC=12,INCRRECLEN=29
ADADRU FILE=5,PDATASPACE=DETAIL,FROMRABN=351,TORABN=353
ADADRU INCRUSAGE=9,INCRNUMREC=15,INCRRECLEN=40
ADADRU FILE=5,PDATASPACE=DETAIL,FROMRABN=355,TORABN=360
ADADRU FILE=1,PASSOSPACE=DETAIL,FROMRABN=990,TORABN=995
ADADRU FILE=1,PASSOSPACE=DETAIL,FROMRABN=993,TORABN=999
ADADRU FILE=5,PDATASPACE=DETAIL,FROMRABN=359,TORABN=365
ADADRU INCRUSAGE=3,INCRNUMREC=10,INCRRECLEN=21
ADADRU FILE=5,PDATASPACE=DETAIL,FROMRABN=620,TORABN=622
ADADRU FILE=5,PDATASPACE=DETAIL,FROMRABN=624,TORABN=625
ADADRU FILE=1,PDATASPACE=DETAIL,FROMRABN=23,TORABN=27
ADADRU FILE=1,PDATASPACE=DETAIL,FROMRABN=30,TORABN=33
ADADRU INCRUSAGE=3,INCRNUMREC=22,INCRRECLEN=44
1
DRU203I, ******* SPACEUSAGE-1 started ******* 2012-05-11 12:37:52
File group number 1. FILE=5
-----------------
DRU169I, ASSO RABNs 2073 (x'00000819') - 2075 (x'0000081B')
from specified RABN range are outside
of extents for file 5, or these RABNs are not ASSO NI RABNs.
Only ASSO NI RABN(s) which belongs to the file will be processed.
Run ADAREP utility to obtain information about file extents.
File group number 2. FILE=5
-----------------
File group number 3. FILE=1
-----------------
File group number 4. FILE=5
-----------------
File group number 5. FILE=5
-----------------
File group number 6. FILE=1
-----------------
File group number 7. FILE=1
-----------------
File group number 8. FILE=5
-----------------
File group number 9. FILE=5
-----------------
File group number 10. FILE=5
-----------------
File group number 11. FILE=1
-----------------
File group number 12. FILE=1
-----------------
DRU200I, The input parameters accepted.
1
1
***********************************************************************
***********************************************************************
***********************************************************************
**** ****
**** F I L E 1 ( EMPLOYEES ) ****
**** ****
**** 2012-05-11 12:37:52 ****
***********************************************************************
***********************************************************************
***********************************************************************
Consolidated input parameters:
------------------------------
File number = 1
ERRLIMIT = 1
LOB-GROUP = No
EXP-GROUP = No
ASSO Report type = SUMMARY + DETAIL
SAMPLING = 100 (10 of every 10 records read)
INCRUSAGE = 5
INCRNUMREC = Auto
FROM/TO RABN = 990 - 999
DATA Report type = SUMMARY + DETAIL
SAMPLING = 100 (10 of every 10 records read)
INCRUSAGE = 3
INCRNUMREC = 12
INCRRECLEN = 29
FROM/TO RABN = 21 - 27
FROM/TO RABN = 30 - 33
1
File options (from FCB):
------------------------
Date / Time Loaded ..................... 2009-10-05 13:36:16.33
Date / Time of last update ............. 2011-02-12 10:09:37.80
Date / Time of last physical restructure 2009-10-05 13:36:16.33
ISN Reusage ............................ Yes
DATA Storage Reusage ................... Yes
MIXDSDEV ............................... Yes
Spanned Records Support ................ Yes
Index compressed ....................... No
2-Byte MU/PE Index ..................... No
Highest Index Level .................... 3
LOB fields ............................. No
LOB file ............................... No
Expanded ............................... No
1
I/////////////////////////////////////////////////////////////////I
II II
II ASSOCIATOR SUMMARY REPORT OF NORMAL INDEX FOR FILE 1 II
II II
I/////////////////////////////////////////////////////////////////I
Physical extents list
-------------------------------------------------------------------
I Extent I Type I From To I % unused I Device I
I I I RABN RABN I blocks I type I
I--------I------I-----------------------------I----------I--------I
I 1 I NI I 986 1255 I 77 I 3390 I
I I I I I I
-------------------------------------------------------------------
Range of RABNs being processed according
to consolidated input parameters
(unused RABNs at the end of extents excluded)
-----------------------------------------------
I Extent I Type I From To I
I I I RABN RABN I
I--------I------I-----------------------------I
I 1 I NI I 990 999 I
I I I I
-----------------------------------------------
File ......................... 1
Device Type .................. 3390
Block Size ................... 2544
ASSO Padding factor .......... 10% (254 bytes)
Number of allocated blocks ............................... 270
Number of used blocks .................................... 62
Number of blocks read (SAMPLING = 100%) .................. 10
Number of unused blocks at the end of extents ............ 208
Number of unused blocks within the used extents .......... 0
Percent of blocks with free space less than padding ...... 0
Average percent of block filling (unused blocks excluded) 79
Number of elements in blocks read ........................ 1691
Average number of elements per block ..................... 169
Average element length ................................... 11
Minimum element length ................................... 8
Maximum element length ................................... 64
Number of elements with minimum length ................... 9
Number of elements with maximum length ................... 1
1
I================================================I
II II
II DISTRIBUTION REPORTS ASSO NORMAL INDEX II
II File = 1 II
II Device type = 3390 II
I================================================I
Block filling level; Increment = 5%
--------------------------------------------------
I Range of I Number of blocks I
I percent filled I filled in this range I
I---------------------I--------------------------I
I 26 - 30 I 1 I
I 51 - 55 I 1 I
I 86 - 90 I 8 I
--------------------------------------------------
--------------------------------------------------
I Percent ranges I Number of blocks with I
I of free space I free space in this range I
I---------------------I--------------------------I
I 6 - 10 I 7 I
I 11 - 15 I 1 I
I 46 - 50 I 1 I
I 71 - 75 I 1 I
--------------------------------------------------
1
Number of elements per block; Increment = Auto
--------------------------------------------------
I Number of elements I Number I
I per block I of blocks I
I---------------------I--------------------------I
I 52 - 54 I 1 I
I 100 - 102 I 1 I
I 166 - 168 I 1 I
I 175 - 177 I 3 I
I 178 - 180 I 2 I
I 241 - 243 I 1 I
I 244 - 246 I 1 I
--------------------------------------------------
1
I/////////////////////////////////////////////////////////////////I
II II
II DATA STORAGE SUMMARY REPORT FOR FILE 1 II
II II
I/////////////////////////////////////////////////////////////////I
Physical extents list
-------------------------------------------------------------------
I Extent I Type I From To I % unused I Device I
I I I RABN RABN I blocks I type I
I--------I------I-----------------------------I----------I--------I
I 1 I DS I 6 155 I 69 I 3390 I
I I I I I I
-------------------------------------------------------------------
Range of RABNs being processed according
to consolidated input parameters
(unused RABNs at the end of extents excluded)
-----------------------------------------------
I Extent I Type I From To I
I I I RABN RABN I
I--------I------I-----------------------------I
I 1 I DS I 21 27 I
I 2 I DS I 30 33 I
I I I I
-----------------------------------------------
File ......................... 1
Device Type .................. 3390
Block Size.................... 5064
DATA Storage Padding factor .. 10% (506 bytes)
Number of allocated blocks ............................... 150
Number of used blocks .................................... 47
Number of blocks read (SAMPLING = 100%) .................. 11
Number of unused blocks at the end of extents ............ 103
Number of unused blocks within the used extents .......... 4
Percent of blocks with free space less than padding ...... 9
Average percent of block filling (unused blocks excluded) 56
Number of records in blocks read ......................... 175
Number of Normal records .............................. 175
Number of Spanned records ............................. 0
Number of blocks with Spanned records .................... 0
Average number of records per block ...................... 16
Normal records:
Average record length ................................. 179
Minimum record length ................................. 126
Maximum record length ................................. 244
Number of records with minimum length ................. 1
Number of records with maximum length ................. 1
Spanned Record:
Average record length ................................. 0
Minimum record length ................................. 0
Maximum record length ................................. 0
Number of records with minimum length ................. 0
Number of records with maximum length ................. 0
Average numbers of segments ........................... 0
Minimum numbers of segments ........................... 0
Maximum numbers of segments ........................... 0
Number of Primary Spanned Records ..................... 0
Number of Secondary Spanned Records.................... 0
Number of AC2 blocks read ............................. 0
Data Storage blocks with secondary segments read ...... 0
1
I================================================I
II II
II DISTRIBUTION REPORTS DATA STORAGE II
II File = 1 II
II Device type = 3390 II
I================================================I
Block filling level; Increment = 3%
--------------------------------------------------
I Range of I Number of blocks I
I percent filled I filled in this range I
I---------------------I--------------------------I
I 85 - 87 I 2 I
I 88 - 90 I 4 I
I 91 - 93 I 1 I
--------------------------------------------------
--------------------------------------------------
I Percent ranges I Number of blocks with I
I of free space I free space in this range I
I---------------------I--------------------------I
I 7 - 9 I 1 I
I 10 - 12 I 4 I
I 13 - 15 I 2 I
--------------------------------------------------
1
Number of records per block; Increment = 12 records
--------------------------------------------------
I Number of records I Number I
I per block I of blocks I
I---------------------I--------------------------I
I 13 - 24 I 2 I
I 25 - 36 I 5 I
--------------------------------------------------
1
Normal records length; Increment = 29 bytes
--------------------------------------------------
I Length I Number I
I of record I of records I
I---------------------I--------------------------I
I 117 - 145 I 7 I
I 146 - 174 I 83 I
I 175 - 203 I 47 I
I 204 - 232 I 33 I
I 233 - 261 I 5 I
--------------------------------------------------
DRU163W, WARNING: No data for "Spanned records length" report
1
1
***********************************************************************
***********************************************************************
***********************************************************************
**** ****
**** F I L E 5 ( FILE5 ) ****
**** ****
**** 2012-05-11 12:37:52 ****
***********************************************************************
***********************************************************************
***********************************************************************
Consolidated input parameters:
------------------------------
File number = 5
ERRLIMIT = 1
LOB-GROUP = No
EXP-GROUP = No
ASSO Report type = SUMMARY + DETAIL
SAMPLING = 100 (10 of every 10 records read)
INCRUSAGE = 7
INCRNUMREC = 11
FROM/TO RABN = 2072 - 2072
FROM/TO RABN = 2086 - 2087
DATA Report type = SUMMARY + DETAIL
SAMPLING = 100 (10 of every 10 records read)
INCRUSAGE = 3
INCRNUMREC = 10
INCRRECLEN = 21
FROM/TO RABN = 351 - 353
FROM/TO RABN = 355 - 365
FROM/TO RABN = 620 - 622
FROM/TO RABN = 624 - 625
1
File options (from FCB):
------------------------
Date / Time Loaded ..................... 2010-04-28 10:01:49.79
Date / Time of last update ............. 2010-05-04 07:07:08.47
Date / Time of last physical restructure 2010-04-28 10:01:49.79
ISN Reusage ............................ No
DATA Storage Reusage ................... Yes
MIXDSDEV ............................... No
Spanned Records Support ................ Yes
Index compressed ....................... No
2-Byte MU/PE Index ..................... No
Highest Index Level .................... 3
LOB fields ............................. No
LOB file ............................... No
Expanded ............................... No
1
I/////////////////////////////////////////////////////////////////I
II II
II ASSOCIATOR SUMMARY REPORT OF NORMAL INDEX FOR FILE 5 II
II II
I/////////////////////////////////////////////////////////////////I
Physical extents list
-------------------------------------------------------------------
I Extent I Type I From To I % unused I Device I
I I I RABN RABN I blocks I type I
I--------I------I-----------------------------I----------I--------I
I 1 I NI I 2072 2072 I 0 I 3390 I
I 2 I NI I 2086 2096 I 81 I 3390 I
I I I I I I
-------------------------------------------------------------------
Range of RABNs being processed according
to consolidated input parameters
(unused RABNs at the end of extents excluded)
-----------------------------------------------
I Extent I Type I From To I
I I I RABN RABN I
I--------I------I-----------------------------I
I 1 I NI I 2072 2072 I
I 2 I NI I 2086 2087 I
I I I I
-----------------------------------------------
File ......................... 5
Device Type .................. 3390
Block Size ................... 2544
ASSO Padding factor .......... 10% (254 bytes)
Number of allocated blocks ............................... 12
Number of used blocks .................................... 3
Number of blocks read (SAMPLING = 100%) .................. 3
Number of unused blocks at the end of extents ............ 9
Number of unused blocks within the used extents .......... 0
Percent of blocks with free space less than padding ...... 0
Average percent of block filling (unused blocks excluded) 40
Number of elements in blocks read ........................ 4
Average number of elements per block ..................... 1
Average element length ................................... 772
Minimum element length ................................... 406
Maximum element length ................................... 1056
Number of elements with minimum length ................... 1
Number of elements with maximum length ................... 1
1
I================================================I
II II
II DISTRIBUTION REPORTS ASSO NORMAL INDEX II
II File = 5 II
II Device type = 3390 II
I================================================I
Block filling level; Increment = 7%
--------------------------------------------------
I Range of I Number of blocks I
I percent filled I filled in this range I
I---------------------I--------------------------I
I 29 - 35 I 1 I
I 36 - 42 I 1 I
I 43 - 49 I 1 I
--------------------------------------------------
--------------------------------------------------
I Percent ranges I Number of blocks with I
I of free space I free space in this range I
I---------------------I--------------------------I
I 50 - 56 I 1 I
I 57 - 63 I 1 I
I 64 - 70 I 1 I
--------------------------------------------------
1
Number of elements per block; Increment = 11 elements
--------------------------------------------------
I Number of elements I Number I
I per block I of blocks I
I---------------------I--------------------------I
I 1 - 11 I 3 I
--------------------------------------------------
1
I/////////////////////////////////////////////////////////////////I
II II
II DATA STORAGE SUMMARY REPORT FOR FILE 5 II
II II
I/////////////////////////////////////////////////////////////////I
Physical extents list
-------------------------------------------------------------------
I Extent I Type I From To I % unused I Device I
I I I RABN RABN I blocks I type I
I--------I------I-----------------------------I----------I--------I
I 1 I DS I 350 466 I 0 I 3390 I
I 2 I DS I 617 2381 I 18 I 3390 I
I I I I I I
-------------------------------------------------------------------
Range of RABNs being processed according
to consolidated input parameters
(unused RABNs at the end of extents excluded)
-----------------------------------------------
I Extent I Type I From To I
I I I RABN RABN I
I--------I------I-----------------------------I
I 1 I DS I 351 353 I
I 2 I DS I 355 365 I
I 3 I DS I 620 622 I
I 4 I DS I 624 625 I
I I I I
-----------------------------------------------
File ......................... 5
Device Type .................. 3390
Block Size.................... 5064
DATA Storage Padding factor .. 0% (0 bytes)
Number of allocated blocks ............................... 1882
Number of used blocks .................................... 1571
Number of blocks read (SAMPLING = 100%) .................. 19
Number of unused blocks at the end of extents ............ 311
Number of unused blocks within the used extents .......... 1
Percent of blocks with free space less than padding ...... 0
Average percent of block filling (unused blocks excluded) 94
Number of records in blocks read ......................... 76
Number of Normal records .............................. 71
Number of Spanned records ............................. 5
Number of blocks with Spanned records .................... 16
Average number of records per block ...................... 5
Normal records:
Average record length ................................. 147
Minimum record length ................................. 21
Maximum record length ................................. 271
Number of records with minimum length ................. 35
Number of records with maximum length ................. 36
Spanned Record:
Average record length ................................. 15072
Minimum record length ................................. 15068
Maximum record length ................................. 15076
Number of records with minimum length ................. 1
Number of records with maximum length ................. 1
Average numbers of segments ........................... 3
Minimum numbers of segments ........................... 3
Maximum numbers of segments ........................... 3
Number of Primary Spanned Records ..................... 5
Number of Secondary Spanned Records.................... 10
Number of AC2 blocks read ............................. 1
Data Storage blocks with secondary segments read ...... 10
1
I================================================I
II II
II DISTRIBUTION REPORTS DATA STORAGE II
II File = 5 II
II Device type = 3390 II
I================================================I
Block filling level; Increment = 3%
--------------------------------------------------
I Range of I Number of blocks I
I percent filled I filled in this range I
I---------------------I--------------------------I
I 97 - 99 I 9 I
I 100 - 100 I 9 I
--------------------------------------------------
--------------------------------------------------
I Percent ranges I Number of blocks with I
I of free space I free space in this range I
I---------------------I--------------------------I
I 1 - 3 I 18 I
--------------------------------------------------
1
Number of records per block; Increment = 10 records
--------------------------------------------------
I Number of records I Number I
I per block I of blocks I
I---------------------I--------------------------I
I 1 - 10 I 16 I
I 21 - 30 I 2 I
--------------------------------------------------
1
Normal records length; Increment = 21 bytes
--------------------------------------------------
I Length I Number I
I of record I of records I
I---------------------I--------------------------I
I 1 - 21 I 35 I
I 253 - 273 I 36 I
--------------------------------------------------
DRU163W, WARNING: No data for "Spanned records length" report
1
***********************************************************************
***********************************************************************
***********************************************************************
**** ****
**** F i l e s s t a t i s t i c a l r e p o r t ****
**** ****
***********************************************************************
***********************************************************************
***********************************************************************
-------------------------------------------------------------------------------
I F I Duration I ASSOCIATOR (NI) I DATA STORAGE I ParmI Run I
I i IHH:MM:SS.thI------------------------I------------------------I-----I-----I
I l I I Number I E I Extents I Number I E I Extents I E W I E W I
I e I I of RABNs I r I---------I of RABNs I r I---------I r n I r n I
I I I read I r I FCB Run I read I r I FCB Run I r g I r g I
I---I-----------I----------I---I----I----I----------I---I----I----I--I--I--I--I
1 00:00:00.06 10 0 1 1 11 0 2 2 0 0 0 1
5 00:00:00.10 3 0 2 2 19 0 4 4 0 0 0 1
s1
DRU205I, ******* SPACEUSAGE-1 ended ******* CC = 04
DDDETAIL SPACEUSAGE-1
1File options (from FCB):
------------------------
Date / Time Loaded ..................... 2009-10-05 13:36:16.33
Date / Time of last update ............. 2011-02-12 10:09:37.80
Date / Time of last physical restructure 2009-10-05 13:36:16.33
ISN Reusage ............................ Yes
DATA Storage Reusage ................... Yes
MIXDSDEV ............................... Yes
Spanned Records Support ................ Yes
Index compressed ....................... No
2-Byte MU/PE Index ..................... No
Highest Index Level .................... 3
LOB fields ............................. No
LOB file ............................... No
Expanded ............................... No
I/////////////////////////////////////////////////////////////////I
II II
II ASSOCIATOR DETAIL REPORT OF NORMAL INDEX FOR FILE 1 II
II II
I/////////////////////////////////////////////////////////////////I
Device Type ........... 3390
Block Size ............. 2544
ASSO Padding Factor .... 10% (254 bytes)
1File 1 Page 1
---------------------------------------------------------------------
I RABN I % I Block I Free Space I Num I Element lengths I
I I Used I length I------------I elem I-----------------I
I I I I Gap I Pad I I Min I Max I Avg I
I----------I---------I--------I-----I------I------I-----I-----I-----I
990 90 2278 12 254 175 13 13 13
991 90 2278 12 254 175 13 13 13
992 28 705 1585 254 54 13 13 13
993 90 2277 13 254 180 8 34 12
994 90 2283 7 254 175 8 38 13
995 89 2276 14 254 178 8 34 12
996 90 2277 13 254 168 8 64 13
997 51 1287 1003 254 100 8 22 12
998 90 2286 4 254 245 9 15 9
999 90 2283 7 254 241 9 15 9
I/////////////////////////////////////////////////////////////////I
II II
II DATA STORAGE DETAIL REPORT FOR FILE 1 II
II II
I/////////////////////////////////////////////////////////////////I
Device Type ........... 3390
Block Size ............. 5064
DATA Padding Factor .... 10% (506 bytes)
1File 1 Page 1
-------------------------------------------------------------------------------
I RABN I % I Block I Free space I Num I Spanned I Record lengths I
I I Used I Length I------------I Rec I-----------I-----------------I
I I I I Gap I Pad I I Num I Flg I Min I Max I Avg I
I----------I--------I--------I-----I------I-----I-----I-----I-----I-----I-----I
21 88 4476 82 506 27 0 126 208 165
22 91 4613 0 451 28 0 136 196 164
23 88 4475 83 506 26 0 143 204 171
24 87 4382 176 506 25 0 153 205 175
25 89 4528 30 506 27 0 143 193 167
26 89 4522 36 506 22 0 170 244 205
27 86 4357 201 506 20 0 205 239 217
1File options (from FCB):
------------------------
Date / Time Loaded ..................... 2010-04-28 10:01:49.79
Date / Time of last update ............. 2010-05-04 07:07:08.47
Date / Time of last physical restructure 2010-04-28 10:01:49.79
ISN Reusage ............................ No
DATA Storage Reusage ................... Yes
MIXDSDEV ............................... No
Spanned Records Support ................ Yes
Index compressed ....................... No
2-Byte MU/PE Index ..................... No
Highest Index Level .................... 3
LOB fields ............................. No
LOB file ............................... No
Expanded ............................... No
I/////////////////////////////////////////////////////////////////I
II II
II ASSOCIATOR DETAIL REPORT OF NORMAL INDEX FOR FILE 5 II
II II
I/////////////////////////////////////////////////////////////////I
Device Type ........... 3390
Block Size ............. 2544
ASSO Padding Factor .... 10% (254 bytes)
1File 5 Page 1
---------------------------------------------------------------------
I RABN I % I Block I Free Space I Num I Element lengths I
I I Used I length I------------I elem I-----------------I
I I I I Gap I Pad I I Min I Max I Avg I
I----------I---------I--------I-----I------I------I-----I-----I-----I
2072 48 1213 1077 254 2 406 804 605
2086 42 1059 1231 254 1 1056 1056 1056
2087 32 825 1465 254 1 822 822 822
I/////////////////////////////////////////////////////////////////I
II II
II DATA STORAGE DETAIL REPORT FOR FILE 5 II
II II
I/////////////////////////////////////////////////////////////////I
Device Type ........... 3390
Block Size ............. 5064
DATA Padding Factor .... 0% (0 bytes)
1File 5 Page 1
-------------------------------------------------------------------------------
I RABN I % I Block I Free space I Num I Spanned I Record lengths I
I I Used I Length I------------I Rec I-----------I-----------------I
I I I I Gap I Pad I I Num I Flg I Min I Max I Avg I
I----------I--------I--------I-----I------I-----I-----I-----I-----I-----I-----I
351 100 5064 0 0 1 1 S 5060 5060 5060
352 99 4994 70 0 3 1 L 21 4948 1663
355 99 5038 26 0 5 1 L 21 4950 1006
356 100 5064 0 0 1 1 P 5060 5060 5060
357 100 5064 0 0 1 1 S 5060 5060 5060
358 99 5040 24 0 5 1 L 21 4952 1007
359 100 5064 0 0 1 1 P 5060 5060 5060
360 100 5064 0 0 1 1 S 5060 5060 5060
361 99 5042 22 0 5 1 L 21 4954 1007
362 100 5064 0 0 1 1 P 5060 5060 5060
363 100 5064 0 0 1 1 S 5060 5060 5060
364 99 5044 20 0 5 1 L 21 4956 1008
365 99 5050 14 0 26 0 21 271 194
620 99 5044 20 0 5 1 L 21 4956 1008
621 98 4987 77 0 23 0 21 271 216
622 100 5064 0 0 1 1 P 5060 5060 5060
624 98 4952 112 0 1 1 L 4948 4948 4948
625 100 5064 0 0 1 1 P 5060 5060 5060
This sample shows ADADRU SPACEUSAGE processing of LOB files. Both file 6 and file 8 are LOB files. In the FILE parameter for file 6, the LOBGROUP parameter is omitted, so its base file is not processed. However, a LOBGROUP parameter is specified for file 8, so its base file is processed. ADADRU processes files only after all parameters are consolidated.
A D A D R U V8.2 SM8 DBID = 00821 Started 2012-05-11 12:37:52
Parameters:
-----------
ADADRU SPACEUSAGE FILE=6,PFILESPACE=DETAIL
ADADRU FILE=8,PFILESPACE=DETAIL,LOBGROUP
1
DRU203I, ******* SPACEUSAGE-3 started ******* 2012-05-11 12:37:52
File group number 1. FILE=6
-----------------
File group number 2. FILE=8
-----------------
DRU200I, The input parameters accepted.
LOB GROUPS:
---------------------------
I File with I Associated I
I LOB fields I LOB file I
I------------I------------I
I 9 I 8 I
I I I
---------------------------
1
1
***********************************************************************
***********************************************************************
***********************************************************************
**** ****
**** F I L E 6 ( BASE-FILE ) ****
**** ****
**** 2012-05-11 12:37:52 ****
***********************************************************************
***********************************************************************
***********************************************************************
Consolidated input parameters:
------------------------------
File number = 6
ERRLIMIT = 1
LOB-GROUP = No
EXP-GROUP = No
ASSO Report type = SUMMARY + DETAIL
SAMPLING = 100 (10 of every 10 records read)
INCRUSAGE = 5
INCRNUMREC = Auto
FROM/TO RABN = 2100 - 2100
FROM/TO RABN = 2113 - 2118
FROM/TO RABN = 2125 - 2128
DATA Report type = SUMMARY + DETAIL
SAMPLING = 100 (10 of every 10 records read)
INCRUSAGE = 5
INCRNUMREC = Auto
INCRRECLEN = Auto
FROM/TO RABN = 2382 - 2383
1
File options (from FCB):
------------------------
Date / Time Loaded ..................... 2010-07-01 11:13:43.11
Date / Time of last update ............. 2010-07-06 07:05:02.60
Date / Time of last physical restructure 2010-07-01 11:13:43.11
ISN Reusage ............................ No
DATA Storage Reusage ................... No
MIXDSDEV ............................... No
Spanned Records Support ................ Yes
Index compressed ....................... Yes
2-Byte MU/PE Index ..................... No
Highest Index Level .................... 3
LOB fields ............................. Yes. Base file. LOB file = 7
LOB file ............................... No
Expanded ............................... No
1
I/////////////////////////////////////////////////////////////////I
II II
II ASSOCIATOR SUMMARY REPORT OF NORMAL INDEX FOR FILE 6 II
II II
I/////////////////////////////////////////////////////////////////I
Physical extents list
-------------------------------------------------------------------
I Extent I Type I From To I % unused I Device I
I I I RABN RABN I blocks I type I
I--------I------I-----------------------------I----------I--------I
I 1 I NI I 2100 2100 I 0 I 3390 I
I 2 I NI I 2113 2118 I 0 I 3390 I
I 3 I NI I 2125 2130 I 33 I 3390 I
I I I I I I
-------------------------------------------------------------------
Range of RABNs being processed according
to consolidated input parameters
(unused RABNs at the end of extents excluded)
-----------------------------------------------
I Extent I Type I From To I
I I I RABN RABN I
I--------I------I-----------------------------I
I 1 I NI I 2100 2100 I
I 2 I NI I 2113 2118 I
I 3 I NI I 2125 2128 I
I I I I
-----------------------------------------------
File ......................... 6
Device Type .................. 3390
Block Size ................... 2544
ASSO Padding factor .......... 50% (1272 bytes)
Number of allocated blocks ............................... 13
Number of used blocks .................................... 11
Number of blocks read (SAMPLING = 100%) .................. 11
Number of unused blocks at the end of extents ............ 2
Number of unused blocks within the used extents .......... 0
Percent of blocks with free space less than padding ...... 18
Average percent of block filling (unused blocks excluded) 17
Number of elements in blocks read ........................ 409
Average number of elements per block ..................... 37
Average element length ................................... 11
Minimum element length ................................... 7
Maximum element length ................................... 256
Number of elements with minimum length ................... 398
Number of elements with maximum length ................... 8
1
I================================================I
II II
II DISTRIBUTION REPORTS ASSO NORMAL INDEX II
II File = 6 II
II Device type = 3390 II
I================================================I
Block filling level; Increment = 5%
--------------------------------------------------
I Range of I Number of blocks I
I percent filled I filled in this range I
I---------------------I--------------------------I
I 1 - 5 I 1 I
I 6 - 10 I 8 I
I 51 - 55 I 2 I
--------------------------------------------------
--------------------------------------------------
I Percent ranges I Number of blocks with I
I of free space I free space in this range I
I---------------------I--------------------------I
I 41 - 45 I 2 I
I 86 - 90 I 8 I
I 96 - 100 I 1 I
--------------------------------------------------
1
Number of elements per block; Increment = Auto
--------------------------------------------------
I Number of elements I Number I
I per block I of blocks I
I---------------------I--------------------------I
I 1 - 3 I 9 I
I 199 - 201 I 2 I
--------------------------------------------------
1
I/////////////////////////////////////////////////////////////////I
II II
II DATA STORAGE SUMMARY REPORT FOR FILE 6 II
II II
I/////////////////////////////////////////////////////////////////I
Physical extents list
-------------------------------------------------------------------
I Extent I Type I From To I % unused I Device I
I I I RABN RABN I blocks I type I
I--------I------I-----------------------------I----------I--------I
I 1 I DS I 2382 3881 I 99 I 3390 I
I I I I I I
-------------------------------------------------------------------
Range of RABNs being processed according
to consolidated input parameters
(unused RABNs at the end of extents excluded)
-----------------------------------------------
I Extent I Type I From To I
I I I RABN RABN I
I--------I------I-----------------------------I
I 1 I DS I 2382 2383 I
I I I I
-----------------------------------------------
File ......................... 6
Device Type .................. 3390
Block Size.................... 5064
DATA Storage Padding factor .. 0% (0 bytes)
Number of allocated blocks ............................... 1500
Number of used blocks .................................... 2
Number of blocks read (SAMPLING = 100%) .................. 2
Number of unused blocks at the end of extents ............ 1498
Number of unused blocks within the used extents .......... 0
Percent of blocks with free space less than padding ...... 0
Average percent of block filling (unused blocks excluded) 78
Number of records in blocks read ......................... 3
Number of Normal records .............................. 2
Number of Spanned records ............................. 1
Number of blocks with Spanned records .................... 2
Average number of records per block ...................... 2
Normal records:
Average record length ................................. 19
Minimum record length ................................. 15
Maximum record length ................................. 23
Number of records with minimum length ................. 1
Number of records with maximum length ................. 1
Spanned Record:
Average record length ................................. 7850
Minimum record length ................................. 7850
Maximum record length ................................. 7850
Number of records with minimum length ................. 1
Number of records with maximum length ................. 1
Average numbers of segments ........................... 2
Minimum numbers of segments ........................... 2
Maximum numbers of segments ........................... 2
Number of Primary Spanned Records ..................... 1
Number of Secondary Spanned Records.................... 1
Number of AC2 blocks read ............................. 1
Data Storage blocks with secondary segments read ...... 1
1
I================================================I
II II
II DISTRIBUTION REPORTS DATA STORAGE II
II File = 6 II
II Device type = 3390 II
I================================================I
Block filling level; Increment = 5%
--------------------------------------------------
I Range of I Number of blocks I
I percent filled I filled in this range I
I---------------------I--------------------------I
I 71 - 75 I 1 I
I 81 - 85 I 1 I
--------------------------------------------------
--------------------------------------------------
I Percent ranges I Number of blocks with I
I of free space I free space in this range I
I---------------------I--------------------------I
I 16 - 20 I 1 I
I 26 - 30 I 1 I
--------------------------------------------------
1
Number of records per block; Increment = Auto
--------------------------------------------------
I Number of records I Number I
I per block I of blocks I
I---------------------I--------------------------I
I 1 - 6 I 2 I
--------------------------------------------------
1
Normal records length; Increment = Auto
--------------------------------------------------
I Length I Number I
I of record I of records I
I---------------------I--------------------------I
I 13 - 18 I 1 I
I 19 - 24 I 1 I
--------------------------------------------------
1
Spanned records length; Increment = Auto
--------------------------------------------------
I Length I Number I
I of record I of records I
I---------------------I--------------------------I
I 7827 - 7852 I 1 I
--------------------------------------------------
1
1
***********************************************************************
***********************************************************************
***********************************************************************
**** ****
**** F I L E 8 ( LOB-FILE1 ) ****
**** ****
**** 2012-05-11 12:37:52 ****
***********************************************************************
***********************************************************************
***********************************************************************
Consolidated input parameters:
------------------------------
File number = 8
ERRLIMIT = 1
LOB-GROUP = Yes
EXP-GROUP = No
ASSO Report type = SUMMARY + DETAIL
SAMPLING = 100 (10 of every 10 records read)
INCRUSAGE = 5
INCRNUMREC = Auto
FROM/TO RABN = 2441 - 2441
DATA Report type = SUMMARY + DETAIL
SAMPLING = 100 (10 of every 10 records read)
INCRUSAGE = 5
INCRNUMREC = Auto
INCRRECLEN = Auto
FROM/TO RABN = 7002 - 7067
1
File options (from FCB):
------------------------
Date / Time Loaded ..................... 2010-07-30 10:08:01.13
Date / Time of last update ............. 2010-08-03 07:04:22.85
Date / Time of last physical restructure 2010-07-30 10:08:01.13
ISN Reusage ............................ No
DATA Storage Reusage ................... No
MIXDSDEV ............................... No
Spanned Records Support ................ No
Index compressed ....................... Yes
2-Byte MU/PE Index ..................... No
Highest Index Level .................... 3
LOB fields ............................. No
LOB file ............................... Yes. Base file = 9
Expanded ............................... No
1
I/////////////////////////////////////////////////////////////////I
II II
II ASSOCIATOR SUMMARY REPORT OF NORMAL INDEX FOR FILE 8 II
II II
I/////////////////////////////////////////////////////////////////I
Physical extents list
-------------------------------------------------------------------
I Extent I Type I From To I % unused I Device I
I I I RABN RABN I blocks I type I
I--------I------I-----------------------------I----------I--------I
I 1 I NI I 2441 2441 I 0 I 3390 I
I I I I I I
-------------------------------------------------------------------
Range of RABNs being processed according
to consolidated input parameters
(unused RABNs at the end of extents excluded)
-----------------------------------------------
I Extent I Type I From To I
I I I RABN RABN I
I--------I------I-----------------------------I
I 1 I NI I 2441 2441 I
I I I I
-----------------------------------------------
File ......................... 8
Device Type .................. 3390
Block Size ................... 2544
ASSO Padding factor .......... 50% (1272 bytes)
Number of allocated blocks ............................... 1
Number of used blocks .................................... 1
Number of blocks read (SAMPLING = 100%) .................. 1
Number of unused blocks at the end of extents ............ 0
Number of unused blocks within the used extents .......... 0
Percent of blocks with free space less than padding ...... 0
Average percent of block filling (unused blocks excluded) 29
Number of elements in blocks read ........................ 66
Average number of elements per block ..................... 66
Average element length ................................... 11
Minimum element length ................................... 9
Maximum element length ................................... 20
Number of elements with minimum length ................... 39
Number of elements with maximum length ................... 1
1
I================================================I
II II
II DISTRIBUTION REPORTS ASSO NORMAL INDEX II
II File = 8 II
II Device type = 3390 II
I================================================I
Block filling level; Increment = 5%
--------------------------------------------------
I Range of I Number of blocks I
I percent filled I filled in this range I
I---------------------I--------------------------I
I 26 - 30 I 1 I
--------------------------------------------------
--------------------------------------------------
I Percent ranges I Number of blocks with I
I of free space I free space in this range I
I---------------------I--------------------------I
I 71 - 75 I 1 I
--------------------------------------------------
1
Number of elements per block; Increment = Auto
--------------------------------------------------
I Number of elements I Number I
I per block I of blocks I
I---------------------I--------------------------I
I 64 - 66 I 1 I
--------------------------------------------------
1
I/////////////////////////////////////////////////////////////////I
II II
II DATA STORAGE SUMMARY REPORT FOR FILE 8 II
II II
I/////////////////////////////////////////////////////////////////I
Physical extents list
-------------------------------------------------------------------
I Extent I Type I From To I % unused I Device I
I I I RABN RABN I blocks I type I
I--------I------I-----------------------------I----------I--------I
I 1 I DS I 7002 8501 I 96 I 3390 I
I I I I I I
-------------------------------------------------------------------
Range of RABNs being processed according
to consolidated input parameters
(unused RABNs at the end of extents excluded)
-----------------------------------------------
I Extent I Type I From To I
I I I RABN RABN I
I--------I------I-----------------------------I
I 1 I DS I 7002 7067 I
I I I I
-----------------------------------------------
File ......................... 8
Device Type .................. 3390
Block Size.................... 5064
DATA Storage Padding factor .. 10% (506 bytes)
Number of allocated blocks ............................... 1500
Number of used blocks .................................... 66
Number of blocks read (SAMPLING = 100%) .................. 66
Number of unused blocks at the end of extents ............ 1434
Number of unused blocks within the used extents .......... 0
Percent of blocks with free space less than padding ...... 59
Average percent of block filling (unused blocks excluded) 75
Number of records in blocks read ......................... 66
Number of Normal records .............................. 66
Number of Spanned records ............................. n/a
Number of blocks with Spanned records .................... n/a
Average number of records per block ...................... 1
Normal records:
Average record length ................................. 3798
Minimum record length ................................. 1926
Maximum record length ................................. 5046
Number of records with minimum length ................. 3
Number of records with maximum length ................. 39
1
I================================================I
II II
II DISTRIBUTION REPORTS DATA STORAGE II
II File = 8 II
II Device type = 3390 II
I================================================I
Block filling level; Increment = 5%
--------------------------------------------------
I Range of I Number of blocks I
I percent filled I filled in this range I
I---------------------I--------------------------I
I 36 - 40 I 27 I
I 96 - 100 I 39 I
--------------------------------------------------
--------------------------------------------------
I Percent ranges I Number of blocks with I
I of free space I free space in this range I
I---------------------I--------------------------I
I 1 - 5 I 39 I
I 56 - 60 I 24 I
I 61 - 65 I 3 I
--------------------------------------------------
1
Number of records per block; Increment = Auto
--------------------------------------------------
I Number of records I Number I
I per block I of blocks I
I---------------------I--------------------------I
I 1 - 6 I 66 I
--------------------------------------------------
1
Normal records length; Increment = Auto
--------------------------------------------------
I Length I Number I
I of record I of records I
I---------------------I--------------------------I
I 1921 - 1926 I 3 I
I 2005 - 2010 I 24 I
I 5041 - 5046 I 39 I
--------------------------------------------------
1
1
***********************************************************************
***********************************************************************
***********************************************************************
**** ****
**** F I L E 9 ( BASE-FILE1 ) ****
**** ****
**** 2012-05-11 12:37:52 ****
***********************************************************************
***********************************************************************
***********************************************************************
Consolidated input parameters:
------------------------------
File number = 9
ERRLIMIT = 1
LOB-GROUP = Yes
EXP-GROUP = No
ASSO Report type = SUMMARY + DETAIL
SAMPLING = 100 (10 of every 10 records read)
INCRUSAGE = 5
INCRNUMREC = Auto
FROM/TO RABN = 2436 - 2436
FROM/TO RABN = 2449 - 2454
FROM/TO RABN = 2461 - 2466
DATA Report type = SUMMARY + DETAIL
SAMPLING = 100 (10 of every 10 records read)
INCRUSAGE = 5
INCRNUMREC = Auto
INCRRECLEN = Auto
FROM/TO RABN = 5502 - 5507
1
File options (from FCB):
------------------------
Date / Time Loaded ..................... 2010-07-30 10:07:59.03
Date / Time of last update ............. 2010-08-03 07:04:22.85
Date / Time of last physical restructure 2010-07-30 10:07:59.03
ISN Reusage ............................ No
DATA Storage Reusage ................... No
MIXDSDEV ............................... No
Spanned Records Support ................ Yes
Index compressed ....................... Yes
2-Byte MU/PE Index ..................... No
Highest Index Level .................... 3
LOB fields ............................. Yes. Base file. LOB file = 8
LOB file ............................... No
Expanded ............................... No
1
I/////////////////////////////////////////////////////////////////I
II II
II ASSOCIATOR SUMMARY REPORT OF NORMAL INDEX FOR FILE 9 II
II II
I/////////////////////////////////////////////////////////////////I
Physical extents list
-------------------------------------------------------------------
I Extent I Type I From To I % unused I Device I
I I I RABN RABN I blocks I type I
I--------I------I-----------------------------I----------I--------I
I 1 I NI I 2436 2436 I 0 I 3390 I
I 2 I NI I 2449 2454 I 0 I 3390 I
I 3 I NI I 2461 2466 I 0 I 3390 I
I I I I I I
-------------------------------------------------------------------
Range of RABNs being processed according
to consolidated input parameters
(unused RABNs at the end of extents excluded)
-----------------------------------------------
I Extent I Type I From To I
I I I RABN RABN I
I--------I------I-----------------------------I
I 1 I NI I 2436 2436 I
I 2 I NI I 2449 2454 I
I 3 I NI I 2461 2466 I
I I I I
-----------------------------------------------
File ......................... 9
Device Type .................. 3390
Block Size ................... 2544
ASSO Padding factor .......... 50% (1272 bytes)
Number of allocated blocks ............................... 13
Number of used blocks .................................... 13
Number of blocks read (SAMPLING = 100%) .................. 13
Number of unused blocks at the end of extents ............ 0
Number of unused blocks within the used extents .......... 0
Percent of blocks with free space less than padding ...... 31
Average percent of block filling (unused blocks excluded) 26
Number of elements in blocks read ........................ 425
Average number of elements per block ..................... 33
Average element length ................................... 20
Minimum element length ................................... 13
Maximum element length ................................... 256
Number of elements with minimum length ................... 396
Number of elements with maximum length ................... 8
1
I================================================I
II II
II DISTRIBUTION REPORTS ASSO NORMAL INDEX II
II File = 9 II
II Device type = 3390 II
I================================================I
Block filling level; Increment = 5%
--------------------------------------------------
I Range of I Number of blocks I
I percent filled I filled in this range I
I---------------------I--------------------------I
I 1 - 5 I 1 I
I 11 - 15 I 4 I
I 16 - 20 I 4 I
I 46 - 50 I 2 I
I 51 - 55 I 2 I
--------------------------------------------------
--------------------------------------------------
I Percent ranges I Number of blocks with I
I of free space I free space in this range I
I---------------------I--------------------------I
I 46 - 50 I 4 I
I 81 - 85 I 4 I
I 86 - 90 I 4 I
I 96 - 100 I 1 I
--------------------------------------------------
1
Number of elements per block; Increment = Auto
--------------------------------------------------
I Number of elements I Number I
I per block I of blocks I
I---------------------I--------------------------I
I 1 - 3 I 9 I
I 97 - 99 I 2 I
I 100 - 102 I 2 I
--------------------------------------------------
1
I/////////////////////////////////////////////////////////////////I
II II
II DATA STORAGE SUMMARY REPORT FOR FILE 9 II
II II
I/////////////////////////////////////////////////////////////////I
Physical extents list
-------------------------------------------------------------------
I Extent I Type I From To I % unused I Device I
I I I RABN RABN I blocks I type I
I--------I------I-----------------------------I----------I--------I
I 1 I DS I 5502 7001 I 99 I 3390 I
I I I I I I
-------------------------------------------------------------------
Range of RABNs being processed according
to consolidated input parameters
(unused RABNs at the end of extents excluded)
-----------------------------------------------
I Extent I Type I From To I
I I I RABN RABN I
I--------I------I-----------------------------I
I 1 I DS I 5502 5507 I
I I I I
-----------------------------------------------
File ......................... 9
Device Type .................. 3390
Block Size.................... 5064
DATA Storage Padding factor .. 0% (0 bytes)
Number of allocated blocks ............................... 1500
Number of used blocks .................................... 6
Number of blocks read (SAMPLING = 100%) .................. 6
Number of unused blocks at the end of extents ............ 1494
Number of unused blocks within the used extents .......... 0
Percent of blocks with free space less than padding ...... 0
Average percent of block filling (unused blocks excluded) 78
Number of records in blocks read ......................... 3
Number of Normal records .............................. 0
Number of Spanned records ............................. 3
Number of blocks with Spanned records .................... 6
Average number of records per block ...................... 1
Normal records:
Average record length ................................. 0
Minimum record length ................................. 32767
Maximum record length ................................. 0
Number of records with minimum length ................. 0
Number of records with maximum length ................. 0
Spanned Record:
Average record length ................................. 7850
Minimum record length ................................. 7850
Maximum record length ................................. 7850
Number of records with minimum length ................. 3
Number of records with maximum length ................. 3
Average numbers of segments ........................... 2
Minimum numbers of segments ........................... 2
Maximum numbers of segments ........................... 2
Number of Primary Spanned Records ..................... 3
Number of Secondary Spanned Records.................... 3
Number of AC2 blocks read ............................. 1
Data Storage blocks with secondary segments read ...... 3
1
I================================================I
II II
II DISTRIBUTION REPORTS DATA STORAGE II
II File = 9 II
II Device type = 3390 II
I================================================I
Block filling level; Increment = 5%
--------------------------------------------------
I Range of I Number of blocks I
I percent filled I filled in this range I
I---------------------I--------------------------I
I 71 - 75 I 3 I
I 81 - 85 I 3 I
--------------------------------------------------
--------------------------------------------------
I Percent ranges I Number of blocks with I
I of free space I free space in this range I
I---------------------I--------------------------I
I 16 - 20 I 3 I
I 26 - 30 I 3 I
--------------------------------------------------
1
Number of records per block; Increment = Auto
--------------------------------------------------
I Number of records I Number I
I per block I of blocks I
I---------------------I--------------------------I
I 1 - 6 I 6 I
--------------------------------------------------
DRU163W, WARNING: No data for "Normal records length" report
1
Spanned records length; Increment = Auto
--------------------------------------------------
I Length I Number I
I of record I of records I
I---------------------I--------------------------I
I 7827 - 7852 I 3 I
--------------------------------------------------
1
***********************************************************************
***********************************************************************
***********************************************************************
**** ****
**** F i l e s s t a t i s t i c a l r e p o r t ****
**** ****
***********************************************************************
***********************************************************************
***********************************************************************
-------------------------------------------------------------------------------
I F I Duration I ASSOCIATOR (NI) I DATA STORAGE I ParmI Run I
I i IHH:MM:SS.thI------------------------I------------------------I-----I-----I
I l I I Number I E I Extents I Number I E I Extents I E W I E W I
I e I I of RABNs I r I---------I of RABNs I r I---------I r n I r n I
I I I read I r I FCB Run I read I r I FCB Run I r g I r g I
I---I-----------I----------I---I----I----I----------I---I----I----I--I--I--I--I
6 00:00:00.05 11 0 3 3 2 0 1 1 0 0 0 0
8 00:00:00.05 1 0 1 1 66 0 1 1 0 0 0 0
9 00:00:00.06 13 0 3 3 6 0 1 1 0 0 0 1
1
DRU205I, ******* SPACEUSAGE-3 ended ******* CC = 04
DDDETAIL SPACEUSAGE-3
1File options (from FCB):
------------------------
Date / Time Loaded ..................... 2010-07-01 11:13:43.11
Date / Time of last update ............. 2010-07-06 07:05:02.60
Date / Time of last physical restructure 2010-07-01 11:13:43.11
ISN Reusage ............................ No
DATA Storage Reusage ................... No
MIXDSDEV ............................... No
Spanned Records Support ................ Yes
Index compressed ....................... Yes
2-Byte MU/PE Index ..................... No
Highest Index Level .................... 3
LOB fields ............................. Yes. Base file. LOB file = 7
LOB file ............................... No
Expanded ............................... No
I/////////////////////////////////////////////////////////////////I
II II
II ASSOCIATOR DETAIL REPORT OF NORMAL INDEX FOR FILE 6 II
II II
I/////////////////////////////////////////////////////////////////I
Device Type ........... 3390
Block Size ............. 2544
ASSO Padding Factor .... 50% (1272 bytes)
1File 6 Page 1
---------------------------------------------------------------------
I RABN I % I Block I Free Space I Num I Element lengths I
I I Used I length I------------I elem I-----------------I
I I I I Gap I Pad I I Min I Max I Avg I
I----------I---------I--------I-----I------I------I-----I-----I-----I
2100 10 259 1013 1272 1 256 256 256
2113 10 259 1013 1272 1 256 256 256
2114 10 259 1013 1272 1 256 256 256
2115 10 259 1013 1272 1 256 256 256
2116 10 259 1013 1272 1 256 256 256
2117 10 259 1013 1272 1 256 256 256
2118 10 259 1013 1272 1 256 256 256
2125 10 259 1013 1272 1 256 256 256
2126 1 11 1261 1272 1 8 8 8
2127 55 1405 0 1139 200 7 9 7
2128 55 1405 0 1139 200 7 9 7
I/////////////////////////////////////////////////////////////////I
II II
II DATA STORAGE DETAIL REPORT FOR FILE 6 II
II II
I/////////////////////////////////////////////////////////////////I
Device Type ........... 3390
Block Size ............. 5064
DATA Padding Factor .... 0% (0 bytes)
1File 6 Page 1
-------------------------------------------------------------------------------
I RABN I % I Block I Free space I Num I Spanned I Record lengths I
I I Used I Length I------------I Rec I-----------I-----------------I
I I I I Gap I Pad I I Num I Flg I Min I Max I Avg I
I----------I--------I--------I-----I------I-----I-----I-----I-----I-----I-----I
2382 82 4129 935 0 1 1 P 4125 4125 4125
2383 74 3767 1297 0 3 1 L 15 3725 1254
1File options (from FCB):
------------------------
Date / Time Loaded ..................... 2010-07-30 10:08:01.13
Date / Time of last update ............. 2010-08-03 07:04:22.85
Date / Time of last physical restructure 2010-07-30 10:08:01.13
ISN Reusage ............................ No
DATA Storage Reusage ................... No
MIXDSDEV ............................... No
Spanned Records Support ................ No
Index compressed ....................... Yes
2-Byte MU/PE Index ..................... No
Highest Index Level .................... 3
LOB fields ............................. No
LOB file ............................... Yes. Base file = 9
Expanded ............................... No
I/////////////////////////////////////////////////////////////////I
II II
II ASSOCIATOR DETAIL REPORT OF NORMAL INDEX FOR FILE 8 II
II II
I/////////////////////////////////////////////////////////////////I
Device Type ........... 3390
Block Size ............. 2544
ASSO Padding Factor .... 50% (1272 bytes)
1File 8 Page 1
---------------------------------------------------------------------
I RABN I % I Block I Free Space I Num I Element lengths I
I I Used I length I------------I elem I-----------------I
I I I I Gap I Pad I I Min I Max I Avg I
I----------I---------I--------I-----I------I------I-----I-----I-----I
2441 29 749 523 1272 66 9 20 11
I/////////////////////////////////////////////////////////////////I
II II
II DATA STORAGE DETAIL REPORT FOR FILE 8 II
II II
I/////////////////////////////////////////////////////////////////I
Device Type ........... 3390
Block Size ............. 5064
DATA Padding Factor .... 10% (506 bytes)
1File 8 Page 1
-------------------------------------------------------------------------------
I RABN I % I Block I Free space I Num I Spanned I Record lengths I
I I Used I Length I------------I Rec I-----------I-----------------I
I I I I Gap I Pad I I Num I Flg I Min I Max I Avg I
I----------I--------I--------I-----I------I-----I-----I-----I-----I-----I-----I
7002 99 5050 0 14 1 0 5046 5046 5046
7003 40 2010 2548 506 1 0 2006 2006 2006
7004 99 5050 0 14 1 0 5046 5046 5046
7005 40 2010 2548 506 1 0 2006 2006 2006
7006 99 5050 0 14 1 0 5046 5046 5046
7007 99 5050 0 14 1 0 5046 5046 5046
7008 99 5050 0 14 1 0 5046 5046 5046
7009 99 5050 0 14 1 0 5046 5046 5046
7010 99 5050 0 14 1 0 5046 5046 5046
7011 38 1930 2628 506 1 0 1926 1926 1926
7012 99 5050 0 14 1 0 5046 5046 5046
7013 40 2010 2548 506 1 0 2006 2006 2006
7014 99 5050 0 14 1 0 5046 5046 5046
7015 40 2010 2548 506 1 0 2006 2006 2006
7016 99 5050 0 14 1 0 5046 5046 5046
7017 40 2010 2548 506 1 0 2006 2006 2006
7018 99 5050 0 14 1 0 5046 5046 5046
7019 40 2010 2548 506 1 0 2006 2006 2006
7020 99 5050 0 14 1 0 5046 5046 5046
7021 40 2010 2548 506 1 0 2006 2006 2006
7022 99 5050 0 14 1 0 5046 5046 5046
7023 40 2010 2548 506 1 0 2006 2006 2006
7024 99 5050 0 14 1 0 5046 5046 5046
7025 40 2010 2548 506 1 0 2006 2006 2006
7026 99 5050 0 14 1 0 5046 5046 5046
7027 40 2010 2548 506 1 0 2006 2006 2006
7028 99 5050 0 14 1 0 5046 5046 5046
7029 99 5050 0 14 1 0 5046 5046 5046
7030 99 5050 0 14 1 0 5046 5046 5046
7031 99 5050 0 14 1 0 5046 5046 5046
7032 99 5050 0 14 1 0 5046 5046 5046
7033 38 1930 2628 506 1 0 1926 1926 1926
7034 99 5050 0 14 1 0 5046 5046 5046
7035 40 2010 2548 506 1 0 2006 2006 2006
7036 99 5050 0 14 1 0 5046 5046 5046
7037 40 2010 2548 506 1 0 2006 2006 2006
7038 99 5050 0 14 1 0 5046 5046 5046
7039 40 2010 2548 506 1 0 2006 2006 2006
7040 99 5050 0 14 1 0 5046 5046 5046
7041 40 2010 2548 506 1 0 2006 2006 2006
7042 99 5050 0 14 1 0 5046 5046 5046
7043 40 2010 2548 506 1 0 2006 2006 2006
7044 99 5050 0 14 1 0 5046 5046 5046
7045 40 2010 2548 506 1 0 2006 2006 2006
7046 99 5050 0 14 1 0 5046 5046 5046
7047 40 2010 2548 506 1 0 2006 2006 2006
7048 99 5050 0 14 1 0 5046 5046 5046
7049 40 2010 2548 506 1 0 2006 2006 2006
7050 99 5050 0 14 1 0 5046 5046 5046
7051 99 5050 0 14 1 0 5046 5046 5046
7052 99 5050 0 14 1 0 5046 5046 5046
7053 99 5050 0 14 1 0 5046 5046 5046
7054 99 5050 0 14 1 0 5046 5046 5046
7055 38 1930 2628 506 1 0 1926 1926 1926
7056 99 5050 0 14 1 0 5046 5046 5046
7057 40 2010 2548 506 1 0 2006 2006 2006
7058 99 5050 0 14 1 0 5046 5046 5046
7059 40 2010 2548 506 1 0 2006 2006 2006
7060 99 5050 0 14 1 0 5046 5046 5046
7061 40 2010 2548 506 1 0 2006 2006 2006
7062 99 5050 0 14 1 0 5046 5046 5046
7063 40 2010 2548 506 1 0 2006 2006 2006
7064 99 5050 0 14 1 0 5046 5046 5046
7065 40 2010 2548 506 1 0 2006 2006 2006
1File 8 Page 2
-------------------------------------------------------------------------------
I RABN I % I Block I Free space I Num I Spanned I Record lengths I
I I Used I Length I------------I Rec I-----------I-----------------I
I I I I Gap I Pad I I Num I Flg I Min I Max I Avg I
I----------I--------I--------I-----I------I-----I-----I-----I-----I-----I-----I
7066 99 5050 0 14 1 0 5046 5046 5046
7067 40 2010 2548 506 1 0 2006 2006 2006
1File options (from FCB):
------------------------
Date / Time Loaded ..................... 2010-07-30 10:07:59.03
Date / Time of last update ............. 2010-08-03 07:04:22.85
Date / Time of last physical restructure 2010-07-30 10:07:59.03
ISN Reusage ............................ No
DATA Storage Reusage ................... No
MIXDSDEV ............................... No
Spanned Records Support ................ Yes
Index compressed ....................... Yes
2-Byte MU/PE Index ..................... No
Highest Index Level .................... 3
LOB fields ............................. Yes. Base file. LOB file = 8
LOB file ............................... No
Expanded ............................... No
I/////////////////////////////////////////////////////////////////I
II II
II ASSOCIATOR DETAIL REPORT OF NORMAL INDEX FOR FILE 9 II
II II
I/////////////////////////////////////////////////////////////////I
Device Type ........... 3390
Block Size ............. 2544
ASSO Padding Factor .... 50% (1272 bytes)
1File 9 Page 1
---------------------------------------------------------------------
I RABN I % I Block I Free Space I Num I Element lengths I
I I Used I length I------------I elem I-----------------I
I I I I Gap I Pad I I Min I Max I Avg I
I----------I---------I--------I-----I------I------I-----I-----I-----I
2436 14 365 907 1272 3 53 256 120
2449 18 465 807 1272 3 103 256 154
2450 14 365 907 1272 3 53 256 120
2451 18 465 807 1272 3 103 256 154
2452 14 365 907 1272 3 53 256 120
2453 18 465 807 1272 3 103 256 154
2454 14 365 907 1272 3 53 256 120
2461 18 465 807 1272 3 103 256 154
2462 1 17 1255 1272 1 14 14 14
2463 50 1279 0 1265 98 13 15 13
2464 50 1279 0 1265 98 13 15 13
2465 52 1331 0 1213 102 13 15 13
2466 52 1331 0 1213 102 13 15 13
I/////////////////////////////////////////////////////////////////I
II II
II DATA STORAGE DETAIL REPORT FOR FILE 9 II
II II
I/////////////////////////////////////////////////////////////////I
Device Type ........... 3390
Block Size ............. 5064
DATA Padding Factor .... 0% (0 bytes)
1File 9 Page 1
-------------------------------------------------------------------------------
I RABN I % I Block I Free space I Num I Spanned I Record lengths I
I I Used I Length I------------I Rec I-----------I-----------------I
I I I I Gap I Pad I I Num I Flg I Min I Max I Avg I
I----------I--------I--------I-----I------I-----I-----I-----I-----I-----I-----I
5502 82 4129 935 0 1 1 P 4125 4125 4125
5503 74 3729 1335 0 1 1 L 3725 3725 3725
5504 82 4129 935 0 1 1 P 4125 4125 4125
5505 74 3729 1335 0 1 1 L 3725 3725 3725
5506 82 4129 935 0 1 1 P 4125 4125 4125
5507 74 3729 1335 0 1 1 L 3725 3725 3725
This sample shows processing of SAMPLING parameter by the ADADRU SPACEUSAGE utility function.
ADADRU SPACEUSAGE FILE=1,PFILESPACE=SUMMARY,SAMPLING=30
ADADRU FILE=1,PASSOSPACE=DETAIL,SAMPLING=40
ADADRU FILE=1,PDATASPACE=DETAIL,SAMPLING=50
1
DRU203I, ******* SPACEUSAGE-4 started ******* 2012-05-11 12:37:52
File group number 1. FILE=1
-----------------
File group number 2. FILE=1
-----------------
File group number 3. FILE=1
-----------------
DRU200I, The input parameters accepted.
1
1
***********************************************************************
***********************************************************************
***********************************************************************
**** ****
**** F I L E 1 ( EMPLOYEES ) ****
**** ****
**** 2012-05-11 12:37:52 ****
***********************************************************************
***********************************************************************
***********************************************************************
Consolidated input parameters:
------------------------------
File number = 1
ERRLIMIT = 1
LOB-GROUP = No
EXP-GROUP = No
ASSO Report type = SUMMARY + DETAIL
SAMPLING = 40 (4 of every 10 records read)
INCRUSAGE = 5
INCRNUMREC = Auto
FROM/TO RABN = 986 - 1047
DATA Report type = SUMMARY + DETAIL
SAMPLING = 50 (5 of every 10 records read)
INCRUSAGE = 5
INCRNUMREC = Auto
INCRRECLEN = Auto
FROM/TO RABN = 6 - 52
1
File options (from FCB):
------------------------
Date / Time Loaded ..................... 2009-10-05 13:36:16.33
Date / Time of last update ............. 2011-02-12 10:09:37.80
Date / Time of last physical restructure 2009-10-05 13:36:16.33
ISN Reusage ............................ Yes
DATA Storage Reusage ................... Yes
MIXDSDEV ............................... Yes
Spanned Records Support ................ Yes
Index compressed ....................... No
2-Byte MU/PE Index ..................... No
Highest Index Level .................... 3
LOB fields ............................. No
LOB file ............................... No
Expanded ............................... No
1
I/////////////////////////////////////////////////////////////////I
II II
II ASSOCIATOR SUMMARY REPORT OF NORMAL INDEX FOR FILE 1 II
II II
I/////////////////////////////////////////////////////////////////I
Physical extents list
-------------------------------------------------------------------
I Extent I Type I From To I % unused I Device I
I I I RABN RABN I blocks I type I
I--------I------I-----------------------------I----------I--------I
I 1 I NI I 986 1255 I 77 I 3390 I
I I I I I I
-------------------------------------------------------------------
Range of RABNs being processed according
to consolidated input parameters
(unused RABNs at the end of extents excluded)
-----------------------------------------------
I Extent I Type I From To I
I I I RABN RABN I
I--------I------I-----------------------------I
I 1 I NI I 986 1047 I
I I I I
-----------------------------------------------
File ......................... 1
Device Type .................. 3390
Block Size ................... 2544
ASSO Padding factor .......... 10% (254 bytes)
Number of allocated blocks ............................... 270
Number of used blocks .................................... 62
Number of blocks read (SAMPLING = 40% ) .................. 26
Number of unused blocks at the end of extents ............ 208
Number of unused blocks within the used extents .......... 0
Percent of blocks with free space less than padding ...... 0
Average percent of block filling (unused blocks excluded) 80
Number of elements in blocks read ........................ 2668
Average number of elements per block ..................... 103
Average element length ................................... 19
Minimum element length ................................... 7
Maximum element length ................................... 631
Number of elements with minimum length ................... 1
Number of elements with maximum length ................... 1
1
I================================================I
II II
II DISTRIBUTION REPORTS ASSO NORMAL INDEX II
II File = 1 II
II Device type = 3390 II
I================================================I
Block filling level; Increment = 5%
--------------------------------------------------
I Range of I Number of blocks I
I percent filled I filled in this range I
I---------------------I--------------------------I
I 1 - 5 I 2 I
I 41 - 45 I 1 I
I 66 - 70 I 1 I
I 86 - 90 I 22 I
--------------------------------------------------
--------------------------------------------------
I Percent ranges I Number of blocks with I
I of free space I free space in this range I
I---------------------I--------------------------I
I 6 - 10 I 17 I
I 11 - 15 I 5 I
I 31 - 35 I 1 I
I 56 - 60 I 1 I
I 96 - 100 I 2 I
--------------------------------------------------
1
Number of elements per block; Increment = Auto
--------------------------------------------------
I Number of elements I Number I
I per block I of blocks I
I---------------------I--------------------------I
I 1 - 3 I 1 I
I 4 - 6 I 2 I
I 7 - 9 I 1 I
I 61 - 63 I 1 I
I 70 - 72 I 2 I
I 79 - 81 I 2 I
I 85 - 87 I 1 I
I 94 - 96 I 1 I
I 97 - 99 I 1 I
I 103 - 105 I 1 I
I 106 - 108 I 1 I
I 115 - 117 I 1 I
I 118 - 120 I 1 I
I 124 - 126 I 2 I
I 127 - 129 I 2 I
I 175 - 177 I 6 I
--------------------------------------------------
1
I/////////////////////////////////////////////////////////////////I
II II
II DATA STORAGE SUMMARY REPORT FOR FILE 1 II
II II
I/////////////////////////////////////////////////////////////////I
Physical extents list
-------------------------------------------------------------------
I Extent I Type I From To I % unused I Device I
I I I RABN RABN I blocks I type I
I--------I------I-----------------------------I----------I--------I
I 1 I DS I 6 155 I 69 I 3390 I
I I I I I I
-------------------------------------------------------------------
Range of RABNs being processed according
to consolidated input parameters
(unused RABNs at the end of extents excluded)
-----------------------------------------------
I Extent I Type I From To I
I I I RABN RABN I
I--------I------I-----------------------------I
I 1 I DS I 6 52 I
I I I I
-----------------------------------------------
File ......................... 1
Device Type .................. 3390
Block Size.................... 5064
DATA Storage Padding factor .. 10% (506 bytes)
Number of allocated blocks ............................... 150
Number of used blocks .................................... 47
Number of blocks read (SAMPLING = 50% ) .................. 27
Number of unused blocks at the end of extents ............ 103
Number of unused blocks within the used extents .......... 16
Percent of blocks with free space less than padding ...... 11
Average percent of block filling (unused blocks excluded) 33
Number of records in blocks read ......................... 249
Number of Normal records .............................. 249
Number of Spanned records ............................. 0
Number of blocks with Spanned records .................... 0
Average number of records per block ...................... 9
Normal records:
Average record length ................................. 182
Minimum record length ................................. 31
Maximum record length ................................. 253
Number of records with minimum length ................. 1
Number of records with maximum length ................. 1
Spanned Record:
Average record length ................................. 0
Minimum record length ................................. 0
Maximum record length ................................. 0
Number of records with minimum length ................. 0
Number of records with maximum length ................. 0
Average numbers of segments ........................... 0
Minimum numbers of segments ........................... 0
Maximum numbers of segments ........................... 0
Number of Primary Spanned Records ..................... 0
Number of Secondary Spanned Records.................... 0
Number of AC2 blocks read ............................. 0
Data Storage blocks with secondary segments read ...... 0
1
I================================================I
II II
II DISTRIBUTION REPORTS DATA STORAGE II
II File = 1 II
II Device type = 3390 II
I================================================I
Block filling level; Increment = 5%
--------------------------------------------------
I Range of I Number of blocks I
I percent filled I filled in this range I
I---------------------I--------------------------I
I 1 - 5 I 1 I
I 86 - 90 I 7 I
I 91 - 95 I 3 I
--------------------------------------------------
--------------------------------------------------
I Percent ranges I Number of blocks with I
I of free space I free space in this range I
I---------------------I--------------------------I
I 6 - 10 I 4 I
I 11 - 15 I 6 I
I 96 - 100 I 1 I
--------------------------------------------------
1
Number of records per block; Increment = Auto
--------------------------------------------------
I Number of records I Number I
I per block I of blocks I
I---------------------I--------------------------I
I 1 - 6 I 1 I
I 19 - 24 I 6 I
I 25 - 30 I 4 I
--------------------------------------------------
1
Normal records length; Increment = Auto
--------------------------------------------------
I Length I Number I
I of record I of records I
I---------------------I--------------------------I
I 1 - 96 I 1 I
I 133 - 138 I 5 I
I 139 - 144 I 4 I
I 145 - 150 I 6 I
I 151 - 156 I 15 I
I 157 - 162 I 24 I
I 163 - 168 I 22 I
I 169 - 174 I 18 I
I 175 - 180 I 18 I
I 181 - 186 I 24 I
I 187 - 192 I 27 I
I 193 - 198 I 26 I
I 199 - 204 I 20 I
I 205 - 210 I 11 I
I 211 - 216 I 10 I
I 217 - 222 I 8 I
I 223 - 228 I 3 I
I 229 - 234 I 5 I
I 235 - 252 I 1 I
I 253 - 348 I 1 I
--------------------------------------------------
DRU163W, WARNING: No data for "Spanned records length" report
1
***********************************************************************
***********************************************************************
***********************************************************************
**** ****
**** F i l e s s t a t i s t i c a l r e p o r t ****
**** ****
***********************************************************************
***********************************************************************
***********************************************************************
-------------------------------------------------------------------------------
I F I Duration I ASSOCIATOR (NI) I DATA STORAGE I ParmI Run I
I i IHH:MM:SS.thI------------------------I------------------------I-----I-----I
I l I I Number I E I Extents I Number I E I Extents I E W I E W I
I e I I of RABNs I r I---------I of RABNs I r I---------I r n I r n I
I I I read I r I FCB Run I read I r I FCB Run I r g I r g I
I---I-----------I----------I---I----I----I----------I---I----I----I--I--I--I--I
1 00:00:00.12 26 0 1 1 27 0 1 1 0 0 0 1
1
DRU205I, ******* SPACEUSAGE-4 ended ******* CC = 04
DDDETAIL SPACEUSAGE-4
1File options (from FCB):
------------------------
Date / Time Loaded ..................... 2009-10-05 13:36:16.33
Date / Time of last update ............. 2011-02-12 10:09:37.80
Date / Time of last physical restructure 2009-10-05 13:36:16.33
ISN Reusage ............................ Yes
DATA Storage Reusage ................... Yes
MIXDSDEV ............................... Yes
Spanned Records Support ................ Yes
Index compressed ....................... No
2-Byte MU/PE Index ..................... No
Highest Index Level .................... 3
LOB fields ............................. No
LOB file ............................... No
Expanded ............................... No
I/////////////////////////////////////////////////////////////////I
II II
II ASSOCIATOR DETAIL REPORT OF NORMAL INDEX FOR FILE 1 II
II II
I/////////////////////////////////////////////////////////////////I
Device Type ........... 3390
Block Size ............. 2544
ASSO Padding Factor .... 10% (254 bytes)
1File 1 Page 1
---------------------------------------------------------------------
I RABN I % I Block I Free Space I Num I Element lengths I
I I Used I length I------------I elem I-----------------I
I I I I Gap I Pad I I Min I Max I Avg I
I----------I---------I--------I-----I------I------I-----I-----I-----I
986 90 2278 12 254 175 13 13 13
987 90 2278 12 254 175 13 13 13
988 90 2278 12 254 175 13 13 13
989 90 2278 12 254 175 13 13 13
990 90 2278 12 254 175 13 13 13
991 90 2278 12 254 175 13 13 13
1004 90 2283 7 254 115 10 85 19
1005 1 31 2259 254 2 9 19 14
1006 90 2284 6 254 62 11 176 36
1007 90 2284 6 254 98 11 305 23
1008 3 81 2209 254 6 11 23 13
1009 90 2285 5 254 81 7 93 28
1022 90 2286 4 254 8 30 631 285
1023 44 1114 1176 254 5 18 556 222
1024 90 2289 1 254 127 14 23 18
1025 89 2275 15 254 127 14 28 17
1026 90 2283 7 254 126 14 24 18
1027 90 2283 7 254 126 14 25 18
1040 90 2277 13 254 104 18 45 21
1041 89 2265 25 254 108 18 39 20
1042 89 2274 16 254 119 18 30 19
1043 90 2277 13 254 95 18 42 23
1044 89 2262 28 254 71 18 60 31
1045 89 2268 22 254 71 18 90 31
1046 90 2289 1 254 87 18 72 26
1047 69 1752 538 254 80 18 42 21
I/////////////////////////////////////////////////////////////////I
II II
II DATA STORAGE DETAIL REPORT FOR FILE 1 II
II II
I/////////////////////////////////////////////////////////////////I
Device Type ........... 3390
Block Size ............. 5064
DATA Padding Factor .... 10% (506 bytes)
1File 1 Page 1
-------------------------------------------------------------------------------
I RABN I % I Block I Free space I Num I Spanned I Record lengths I
I I Used I Length I------------I Rec I-----------I-----------------I
I I I I Gap I Pad I I Num I Flg I Min I Max I Avg I
I----------I--------I--------I-----I------I-----I-----I-----I-----I-----I-----I
6 1 35 4523 506 1 0 31 31 31
22 91 4613 0 451 28 0 136 196 164
23 88 4475 83 506 26 0 143 204 171
24 87 4382 176 506 25 0 153 205 175
25 89 4528 30 506 27 0 143 193 167
46 89 4506 52 506 24 0 154 252 187
47 92 4642 0 422 24 0 135 233 193
48 90 4537 21 506 24 0 136 223 188
49 89 4513 45 506 24 0 133 253 187
50 88 4469 89 506 23 0 166 234 194
51 93 4713 0 351 23 0 157 233 204
This sample shows FILE parameter processing by ADADRU SPACEUSAGE. All repeated files listed in the FILE parameter are processed only once. ADADRU processesfrom parameter FILE will be processed just once. ADADRU processes files only after all parameters are consolidated.
ADADRU SPACEUSAGE FILE=10-15,9-12,11,11,15
1
DRU203I, ******* SPACEUSAGE-5 started ******* 2012-05-11 12:37:53
File group number 1. FILE=10-15,9-12,11,11,15
-----------------
DRU200I, The input parameters accepted.
1
1
***********************************************************************
***********************************************************************
***********************************************************************
**** ****
**** F I L E 9 ( BASE-FILE1 ) ****
**** ****
**** 2012-05-11 12:37:53 ****
***********************************************************************
***********************************************************************
***********************************************************************
Consolidated input parameters:
------------------------------
File number = 9
ERRLIMIT = 1
LOB-GROUP = No
EXP-GROUP = No
ASSO Report type = SUMMARY
SAMPLING = 100 (10 of every 10 records read)
INCRUSAGE = 5
INCRNUMREC = Auto
FROM/TO RABN = 2436 - 2436
FROM/TO RABN = 2449 - 2454
FROM/TO RABN = 2461 - 2466
DATA Report type = SUMMARY
SAMPLING = 100 (10 of every 10 records read)
INCRUSAGE = 5
INCRNUMREC = Auto
INCRRECLEN = Auto
FROM/TO RABN = 5502 - 5507
1
File options (from FCB):
------------------------
Date / Time Loaded ..................... 2010-07-30 10:07:59.03
Date / Time of last update ............. 2010-08-03 07:04:22.85
Date / Time of last physical restructure 2010-07-30 10:07:59.03
ISN Reusage ............................ No
DATA Storage Reusage ................... No
MIXDSDEV ............................... No
Spanned Records Support ................ Yes
Index compressed ....................... Yes
2-Byte MU/PE Index ..................... No
Highest Index Level .................... 3
LOB fields ............................. Yes. Base file. LOB file = 8
LOB file ............................... No
Expanded ............................... No
1
I/////////////////////////////////////////////////////////////////I
II II
II ASSOCIATOR SUMMARY REPORT OF NORMAL INDEX FOR FILE 9 II
II II
I/////////////////////////////////////////////////////////////////I
Physical extents list
-------------------------------------------------------------------
I Extent I Type I From To I % unused I Device I
I I I RABN RABN I blocks I type I
I--------I------I-----------------------------I----------I--------I
I 1 I NI I 2436 2436 I 0 I 3390 I
I 2 I NI I 2449 2454 I 0 I 3390 I
I 3 I NI I 2461 2466 I 0 I 3390 I
I I I I I I
-------------------------------------------------------------------
Range of RABNs being processed according
to consolidated input parameters
(unused RABNs at the end of extents excluded)
-----------------------------------------------
I Extent I Type I From To I
I I I RABN RABN I
I--------I------I-----------------------------I
I 1 I NI I 2436 2436 I
I 2 I NI I 2449 2454 I
I 3 I NI I 2461 2466 I
I I I I
-----------------------------------------------
File ......................... 9
Device Type .................. 3390
Block Size ................... 2544
ASSO Padding factor .......... 50% (1272 bytes)
Number of allocated blocks ............................... 13
Number of used blocks .................................... 13
Number of blocks read (SAMPLING = 100%) .................. 13
Number of unused blocks at the end of extents ............ 0
Number of unused blocks within the used extents .......... 0
Percent of blocks with free space less than padding ...... 31
Average percent of block filling (unused blocks excluded) 26
Number of elements in blocks read ........................ 425
Average number of elements per block ..................... 33
Average element length ................................... 20
Minimum element length ................................... 13
Maximum element length ................................... 256
Number of elements with minimum length ................... 396
Number of elements with maximum length ................... 8
1
I================================================I
II II
II DISTRIBUTION REPORTS ASSO NORMAL INDEX II
II File = 9 II
II Device type = 3390 II
I================================================I
Block filling level; Increment = 5%
--------------------------------------------------
I Range of I Number of blocks I
I percent filled I filled in this range I
I---------------------I--------------------------I
I 1 - 5 I 1 I
I 11 - 15 I 4 I
I 16 - 20 I 4 I
I 46 - 50 I 2 I
I 51 - 55 I 2 I
--------------------------------------------------
--------------------------------------------------
I Percent ranges I Number of blocks with I
I of free space I free space in this range I
I---------------------I--------------------------I
I 46 - 50 I 4 I
I 81 - 85 I 4 I
I 86 - 90 I 4 I
I 96 - 100 I 1 I
--------------------------------------------------
1
Number of elements per block; Increment = Auto
--------------------------------------------------
I Number of elements I Number I
I per block I of blocks I
I---------------------I--------------------------I
I 1 - 3 I 9 I
I 97 - 99 I 2 I
I 100 - 102 I 2 I
--------------------------------------------------
1
I/////////////////////////////////////////////////////////////////I
II II
II DATA STORAGE SUMMARY REPORT FOR FILE 9 II
II II
I/////////////////////////////////////////////////////////////////I
Physical extents list
-------------------------------------------------------------------
I Extent I Type I From To I % unused I Device I
I I I RABN RABN I blocks I type I
I--------I------I-----------------------------I----------I--------I
I 1 I DS I 5502 7001 I 99 I 3390 I
I I I I I I
-------------------------------------------------------------------
Range of RABNs being processed according
to consolidated input parameters
(unused RABNs at the end of extents excluded)
-----------------------------------------------
I Extent I Type I From To I
I I I RABN RABN I
I--------I------I-----------------------------I
I 1 I DS I 5502 5507 I
I I I I
-----------------------------------------------
File ......................... 9
Device Type .................. 3390
Block Size.................... 5064
DATA Storage Padding factor .. 0% (0 bytes)
Number of allocated blocks ............................... 1500
Number of used blocks .................................... 6
Number of blocks read (SAMPLING = 100%) .................. 6
Number of unused blocks at the end of extents ............ 1494
Number of unused blocks within the used extents .......... 0
Percent of blocks with free space less than padding ...... 0
Average percent of block filling (unused blocks excluded) 78
Number of records in blocks read ......................... 3
Number of Normal records .............................. 0
Number of Spanned records ............................. 3
Number of blocks with Spanned records .................... 6
Average number of records per block ...................... 1
Normal records:
Average record length ................................. 0
Minimum record length ................................. 32767
Maximum record length ................................. 0
Number of records with minimum length ................. 0
Number of records with maximum length ................. 0
Spanned Record:
Average record length ................................. 7850
Minimum record length ................................. 7850
Maximum record length ................................. 7850
Number of records with minimum length ................. 3
Number of records with maximum length ................. 3
Average numbers of segments ........................... 2
Minimum numbers of segments ........................... 2
Maximum numbers of segments ........................... 2
Number of Primary Spanned Records ..................... 3
Number of Secondary Spanned Records.................... 3
Number of AC2 blocks read ............................. 0
Data Storage blocks with secondary segments read ...... 3
1
I================================================I
II II
II DISTRIBUTION REPORTS DATA STORAGE II
II File = 9 II
II Device type = 3390 II
I================================================I
Block filling level; Increment = 5%
--------------------------------------------------
I Range of I Number of blocks I
I percent filled I filled in this range I
I---------------------I--------------------------I
I 71 - 75 I 3 I
I 81 - 85 I 3 I
--------------------------------------------------
--------------------------------------------------
I Percent ranges I Number of blocks with I
I of free space I free space in this range I
I---------------------I--------------------------I
I 16 - 20 I 3 I
I 26 - 30 I 3 I
--------------------------------------------------
1
Number of records per block; Increment = Auto
--------------------------------------------------
I Number of records I Number I
I per block I of blocks I
I---------------------I--------------------------I
I 1 - 6 I 6 I
--------------------------------------------------
DRU163W, WARNING: No data for "Normal records length" report
1
Spanned records length; Increment = Auto
--------------------------------------------------
I Length I Number I
I of record I of records I
I---------------------I--------------------------I
I 7827 - 7852 I 3 I
--------------------------------------------------
1
1
***********************************************************************
***********************************************************************
***********************************************************************
**** ****
**** F I L E 10 ( EMPLOYEES-EXP1 ) ****
**** ****
**** 2012-05-11 12:37:53 ****
***********************************************************************
***********************************************************************
***********************************************************************
Consolidated input parameters:
------------------------------
File number = 10
ERRLIMIT = 1
LOB-GROUP = No
EXP-GROUP = No
ASSO Report type = SUMMARY
SAMPLING = 100 (10 of every 10 records read)
INCRUSAGE = 5
INCRNUMREC = Auto
FROM/TO RABN = 2164 - 2175
DATA Report type = SUMMARY
SAMPLING = 100 (10 of every 10 records read)
INCRUSAGE = 5
INCRNUMREC = Auto
INCRRECLEN = Auto
FROM/TO RABN = 5392 - 5395
1
File options (from FCB):
------------------------
Date / Time Loaded ..................... 2010-07-01 13:39:15.65
Date / Time of last update ............. n/a
Date / Time of last physical restructure 2010-07-01 13:39:15.65
ISN Reusage ............................ No
DATA Storage Reusage ................... Yes
MIXDSDEV ............................... No
Spanned Records Support ................ No
Index compressed ....................... No
2-Byte MU/PE Index ..................... No
Highest Index Level .................... 3
LOB fields ............................. No
LOB file ............................... No
Expanded ............................... Yes. Seq.number = 2. ANCHOR = 20
1
I/////////////////////////////////////////////////////////////////I
II II
II ASSOCIATOR SUMMARY REPORT OF NORMAL INDEX FOR FILE 10 II
II II
I/////////////////////////////////////////////////////////////////I
Physical extents list
-------------------------------------------------------------------
I Extent I Type I From To I % unused I Device I
I I I RABN RABN I blocks I type I
I--------I------I-----------------------------I----------I--------I
I 1 I NI I 2164 2175 I 0 I 3390 I
I I I I I I
-------------------------------------------------------------------
Range of RABNs being processed according
to consolidated input parameters
(unused RABNs at the end of extents excluded)
-----------------------------------------------
I Extent I Type I From To I
I I I RABN RABN I
I--------I------I-----------------------------I
I 1 I NI I 2164 2175 I
I I I I
-----------------------------------------------
File ......................... 10
Device Type .................. 3390
Block Size ................... 2544
ASSO Padding factor .......... 10% (254 bytes)
Number of allocated blocks ............................... 12
Number of used blocks .................................... 12
Number of blocks read (SAMPLING = 100%) .................. 12
Number of unused blocks at the end of extents ............ 0
Number of unused blocks within the used extents .......... 0
Percent of blocks with free space less than padding ...... 0
Average percent of block filling (unused blocks excluded) 37
Number of elements in blocks read ........................ 739
Average number of elements per block ..................... 62
Average element length ................................... 15
Minimum element length ................................... 8
Maximum element length ................................... 302
Number of elements with minimum length ................... 84
Number of elements with maximum length ................... 1
1
I================================================I
II II
II DISTRIBUTION REPORTS ASSO NORMAL INDEX II
II File = 10 II
II Device type = 3390 II
I================================================I
Block filling level; Increment = 5%
--------------------------------------------------
I Range of I Number of blocks I
I percent filled I filled in this range I
I---------------------I--------------------------I
I 11 - 15 I 2 I
I 16 - 20 I 1 I
I 21 - 25 I 1 I
I 26 - 30 I 1 I
I 31 - 35 I 1 I
I 36 - 40 I 1 I
I 41 - 45 I 2 I
I 51 - 55 I 1 I
I 61 - 65 I 1 I
I 66 - 70 I 1 I
--------------------------------------------------
--------------------------------------------------
I Percent ranges I Number of blocks with I
I of free space I free space in this range I
I---------------------I--------------------------I
I 26 - 30 I 1 I
I 36 - 40 I 1 I
I 46 - 50 I 1 I
I 51 - 55 I 1 I
I 56 - 60 I 1 I
I 61 - 65 I 2 I
I 66 - 70 I 1 I
I 71 - 75 I 1 I
I 81 - 85 I 1 I
I 86 - 90 I 2 I
--------------------------------------------------
1
Number of elements per block; Increment = Auto
--------------------------------------------------
I Number of elements I Number I
I per block I of blocks I
I---------------------I--------------------------I
I 1 - 3 I 1 I
I 4 - 6 I 1 I
I 7 - 9 I 1 I
I 16 - 18 I 1 I
I 55 - 57 I 1 I
I 76 - 78 I 1 I
I 85 - 87 I 1 I
I 88 - 90 I 1 I
I 94 - 96 I 1 I
I 100 - 102 I 3 I
--------------------------------------------------
1
I/////////////////////////////////////////////////////////////////I
II II
II DATA STORAGE SUMMARY REPORT FOR FILE 10 II
II II
I/////////////////////////////////////////////////////////////////I
Physical extents list
-------------------------------------------------------------------
I Extent I Type I From To I % unused I Device I
I I I RABN RABN I blocks I type I
I--------I------I-----------------------------I----------I--------I
I 1 I DS I 5392 5401 I 60 I 3390 I
I I I I I I
-------------------------------------------------------------------
Range of RABNs being processed according
to consolidated input parameters
(unused RABNs at the end of extents excluded)
-----------------------------------------------
I Extent I Type I From To I
I I I RABN RABN I
I--------I------I-----------------------------I
I 1 I DS I 5392 5395 I
I I I I
-----------------------------------------------
File ......................... 10
Device Type .................. 3390
Block Size.................... 5064
DATA Storage Padding factor .. 10% (506 bytes)
Number of allocated blocks ............................... 10
Number of used blocks .................................... 4
Number of blocks read (SAMPLING = 100%) .................. 4
Number of unused blocks at the end of extents ............ 6
Number of unused blocks within the used extents .......... 0
Percent of blocks with free space less than padding ...... 25
Average percent of block filling (unused blocks excluded) 77
Number of records in blocks read ......................... 100
Number of Normal records .............................. 100
Number of Spanned records ............................. n/a
Number of blocks with Spanned records .................... n/a
Average number of records per block ...................... 25
Normal records:
Average record length ................................. 155
Minimum record length ................................. 138
Maximum record length ................................. 191
Number of records with minimum length ................. 1
Number of records with maximum length ................. 1
1
I================================================I
II II
II DISTRIBUTION REPORTS DATA STORAGE II
II File = 10 II
II Device type = 3390 II
I================================================I
Block filling level; Increment = 5%
--------------------------------------------------
I Range of I Number of blocks I
I percent filled I filled in this range I
I---------------------I--------------------------I
I 36 - 40 I 1 I
I 86 - 90 I 2 I
I 91 - 95 I 1 I
--------------------------------------------------
--------------------------------------------------
I Percent ranges I Number of blocks with I
I of free space I free space in this range I
I---------------------I--------------------------I
I 6 - 10 I 1 I
I 11 - 15 I 2 I
I 61 - 65 I 1 I
--------------------------------------------------
1
Number of records per block; Increment = Auto
--------------------------------------------------
I Number of records I Number I
I per block I of blocks I
I---------------------I--------------------------I
I 7 - 12 I 1 I
I 25 - 30 I 3 I
--------------------------------------------------
1
Normal records length; Increment = Auto
--------------------------------------------------
I Length I Number I
I of record I of records I
I---------------------I--------------------------I
I 133 - 138 I 1 I
I 139 - 144 I 6 I
I 145 - 150 I 28 I
I 151 - 156 I 29 I
I 157 - 162 I 16 I
I 163 - 168 I 15 I
I 169 - 174 I 3 I
I 175 - 180 I 1 I
I 187 - 192 I 1 I
--------------------------------------------------
1
1
***********************************************************************
***********************************************************************
***********************************************************************
**** ****
**** F I L E 11 ( EMPTY-FILE ) ****
**** ****
**** 2012-05-11 12:37:53 ****
***********************************************************************
***********************************************************************
***********************************************************************
Consolidated input parameters:
------------------------------
File number = 11
ERRLIMIT = 1
LOB-GROUP = No
EXP-GROUP = No
ASSO Report type = SUMMARY
SAMPLING = 100 (10 of every 10 records read)
INCRUSAGE = 5
INCRNUMREC = Auto
FROM/TO RABN = Unused area of file extents
DATA Report type = SUMMARY
SAMPLING = 100 (10 of every 10 records read)
INCRUSAGE = 5
INCRNUMREC = Auto
INCRRECLEN = Auto
FROM/TO RABN = Unused area of file extents
1
File options (from FCB):
------------------------
Date / Time Loaded ..................... 2010-08-11 12:12:18.04
Date / Time of last update ............. n/a
Date / Time of last physical restructure 2010-08-11 12:12:18.04
ISN Reusage ............................ No
DATA Storage Reusage ................... Yes
MIXDSDEV ............................... No
Spanned Records Support ................ No
Index compressed ....................... No
2-Byte MU/PE Index ..................... No
Highest Index Level .................... 3
LOB fields ............................. No
LOB file ............................... No
Expanded ............................... No
1
I/////////////////////////////////////////////////////////////////I
II II
II ASSOCIATOR SUMMARY REPORT OF NORMAL INDEX FOR FILE 11 II
II II
I/////////////////////////////////////////////////////////////////I
Physical extents list
-------------------------------------------------------------------
I Extent I Type I From To I % unused I Device I
I I I RABN RABN I blocks I type I
I--------I------I-----------------------------I----------I--------I
I 1 I NI I 2474 2486 I 100 I 3390 I
I I I I I I
-------------------------------------------------------------------
Range of RABNs being processed according
to consolidated input parameters
(unused RABNs at the end of extents excluded)
-----------------------------------------------
I Extent I Type I From To I
I I I RABN RABN I
I--------I------I-----------------------------I
File ......................... 11
Device Type .................. 3390
Block Size ................... 2544
ASSO Padding factor .......... 10% (254 bytes)
Number of allocated blocks ............................... 13
Number of used blocks .................................... 0
Number of blocks read (SAMPLING = 100%) .................. 0
Number of unused blocks at the end of extents ............ 13
Number of unused blocks within the used extents .......... 0
Percent of blocks with free space less than padding ...... 0
Average percent of block filling (unused blocks excluded) 0
Number of elements in blocks read ........................ 0
Average number of elements per block ..................... 0
Average element length ................................... 0
Minimum element length ................................... 0
Maximum element length ................................... 0
Number of elements with minimum length ................... 0
Number of elements with maximum length ................... 0
1
I================================================I
II II
II DISTRIBUTION REPORTS ASSO NORMAL INDEX II
II File = 11 II
II Device type = 3390 II
I================================================I
DRU163W, WARNING: No data for "Block filling level" report (Part. 1)
DRU163W, WARNING: No data for "Block filling level" report (Part. 2)
DRU163W, WARNING: No data for "Number of elements per block" report
1
I/////////////////////////////////////////////////////////////////I
II II
II DATA STORAGE SUMMARY REPORT FOR FILE 11 II
II II
I/////////////////////////////////////////////////////////////////I
Physical extents list
-------------------------------------------------------------------
I Extent I Type I From To I % unused I Device I
I I I RABN RABN I blocks I type I
I--------I------I-----------------------------I----------I--------I
I 1 I DS I 8502 8511 I 100 I 3390 I
I I I I I I
-------------------------------------------------------------------
Range of RABNs being processed according
to consolidated input parameters
(unused RABNs at the end of extents excluded)
-----------------------------------------------
I Extent I Type I From To I
I I I RABN RABN I
I--------I------I-----------------------------I
File ......................... 11
Device Type .................. 3390
Block Size.................... 5064
DATA Storage Padding factor .. 10% (506 bytes)
Number of allocated blocks ............................... 10
Number of used blocks .................................... 0
Number of blocks read (SAMPLING = 100%) .................. 0
Number of unused blocks at the end of extents ............ 10
Number of unused blocks within the used extents .......... 0
Percent of blocks with free space less than padding ...... 0
Average percent of block filling (unused blocks excluded) 0
Number of records in blocks read ......................... 0
Number of Normal records .............................. 0
Number of Spanned records ............................. n/a
Number of blocks with Spanned records .................... n/a
Average number of records per block ...................... 0
Normal records:
Average record length ................................. 0
Minimum record length ................................. 0
Maximum record length ................................. 0
Number of records with minimum length ................. 0
Number of records with maximum length ................. 0
1
I================================================I
II II
II DISTRIBUTION REPORTS DATA STORAGE II
II File = 11 II
II Device type = 3390 II
I================================================I
DRU163W, WARNING: No data for "Block filling level" report (Part. 1)
DRU163W, WARNING: No data for "Block filling level" report (Part. 2)
DRU163W, WARNING: No data for "Number of records per block" report
DRU163W, WARNING: No data for "Normal records length" report
1
1
***********************************************************************
***********************************************************************
***********************************************************************
**** ****
**** F I L E 12 ( SECURITY ) ****
**** ****
**** 2012-05-11 12:37:53 ****
***********************************************************************
***********************************************************************
***********************************************************************
Consolidated input parameters:
------------------------------
File number = 12
ERRLIMIT = 1
LOB-GROUP = No
EXP-GROUP = No
ASSO Report type = SUMMARY
SAMPLING = 100 (10 of every 10 records read)
INCRUSAGE = 5
INCRNUMREC = Auto
FROM/TO RABN = Unused area of file extents
DATA Report type = SUMMARY
SAMPLING = 100 (10 of every 10 records read)
INCRUSAGE = 5
INCRNUMREC = Auto
INCRRECLEN = Auto
FROM/TO RABN = Unused area of file extents
1
File options (from FCB):
------------------------
Date / Time Loaded ..................... 2010-11-10 10:04:39.30
Date / Time of last update ............. n/a
Date / Time of last physical restructure 2010-11-10 10:04:39.30
ISN Reusage ............................ No
DATA Storage Reusage ................... Yes
MIXDSDEV ............................... No
Spanned Records Support ................ No
Index compressed ....................... No
2-Byte MU/PE Index ..................... No
Highest Index Level .................... 3
LOB fields ............................. No
LOB file ............................... No
Expanded ............................... No
1
I/////////////////////////////////////////////////////////////////I
II II
II ASSOCIATOR SUMMARY REPORT OF NORMAL INDEX FOR FILE 12 II
II II
I/////////////////////////////////////////////////////////////////I
Physical extents list
-------------------------------------------------------------------
I Extent I Type I From To I % unused I Device I
I I I RABN RABN I blocks I type I
I--------I------I-----------------------------I----------I--------I
I 1 I NI I 2493 2512 I 100 I 3390 I
I I I I I I
-------------------------------------------------------------------
Range of RABNs being processed according
to consolidated input parameters
(unused RABNs at the end of extents excluded)
-----------------------------------------------
I Extent I Type I From To I
I I I RABN RABN I
I--------I------I-----------------------------I
File ......................... 12
Device Type .................. 3390
Block Size ................... 2544
ASSO Padding factor .......... 10% (254 bytes)
Number of allocated blocks ............................... 20
Number of used blocks .................................... 0
Number of blocks read (SAMPLING = 100%) .................. 0
Number of unused blocks at the end of extents ............ 20
Number of unused blocks within the used extents .......... 0
Percent of blocks with free space less than padding ...... 0
Average percent of block filling (unused blocks excluded) 0
Number of elements in blocks read ........................ 0
Average number of elements per block ..................... 0
Average element length ................................... 0
Minimum element length ................................... 0
Maximum element length ................................... 0
Number of elements with minimum length ................... 0
Number of elements with maximum length ................... 0
1
I================================================I
II II
II DISTRIBUTION REPORTS ASSO NORMAL INDEX II
II File = 12 II
II Device type = 3390 II
I================================================I
DRU163W, WARNING: No data for "Block filling level" report (Part. 1)
DRU163W, WARNING: No data for "Block filling level" report (Part. 2)
DRU163W, WARNING: No data for "Number of elements per block" report
1
I/////////////////////////////////////////////////////////////////I
II II
II DATA STORAGE SUMMARY REPORT FOR FILE 12 II
II II
I/////////////////////////////////////////////////////////////////I
Physical extents list
-------------------------------------------------------------------
I Extent I Type I From To I % unused I Device I
I I I RABN RABN I blocks I type I
I--------I------I-----------------------------I----------I--------I
I 1 I DS I 8512 8531 I 100 I 3390 I
I I I I I I
-------------------------------------------------------------------
Range of RABNs being processed according
to consolidated input parameters
(unused RABNs at the end of extents excluded)
-----------------------------------------------
I Extent I Type I From To I
I I I RABN RABN I
I--------I------I-----------------------------I
File ......................... 12
Device Type .................. 3390
Block Size.................... 5064
DATA Storage Padding factor .. 10% (506 bytes)
Number of allocated blocks ............................... 20
Number of used blocks .................................... 0
Number of blocks read (SAMPLING = 100%) .................. 0
Number of unused blocks at the end of extents ............ 20
Number of unused blocks within the used extents .......... 0
Percent of blocks with free space less than padding ...... 0
Average percent of block filling (unused blocks excluded) 0
Number of records in blocks read ......................... 0
Number of Normal records .............................. 0
Number of Spanned records ............................. n/a
Number of blocks with Spanned records .................... n/a
Average number of records per block ...................... 0
Normal records:
Average record length ................................. 0
Minimum record length ................................. 0
Maximum record length ................................. 0
Number of records with minimum length ................. 0
Number of records with maximum length ................. 0
1
I================================================I
II II
II DISTRIBUTION REPORTS DATA STORAGE II
II File = 12 II
II Device type = 3390 II
I================================================I
DRU163W, WARNING: No data for "Block filling level" report (Part. 1)
DRU163W, WARNING: No data for "Block filling level" report (Part. 2)
DRU163W, WARNING: No data for "Number of records per block" report
DRU163W, WARNING: No data for "Normal records length" report
1
1
***********************************************************************
***********************************************************************
***********************************************************************
**** ****
**** F I L E 13 ( TESTFILE ) ****
**** ****
**** 2012-05-11 12:37:53 ****
***********************************************************************
***********************************************************************
***********************************************************************
Consolidated input parameters:
------------------------------
File number = 13
ERRLIMIT = 1
LOB-GROUP = No
EXP-GROUP = No
ASSO Report type = SUMMARY
SAMPLING = 100 (10 of every 10 records read)
INCRUSAGE = 5
INCRNUMREC = Auto
FROM/TO RABN = Unused area of file extents
DATA Report type = SUMMARY
SAMPLING = 100 (10 of every 10 records read)
INCRUSAGE = 5
INCRNUMREC = Auto
INCRRECLEN = Auto
FROM/TO RABN = Unused area of file extents
1
File options (from FCB):
------------------------
Date / Time Loaded ..................... 2011-02-21 17:30:26.92
Date / Time of last update ............. n/a
Date / Time of last physical restructure 2011-02-21 17:30:26.92
ISN Reusage ............................ No
DATA Storage Reusage ................... Yes
MIXDSDEV ............................... No
Spanned Records Support ................ Yes
Index compressed ....................... Yes
2-Byte MU/PE Index ..................... No
Highest Index Level .................... 3
LOB fields ............................. No
LOB file ............................... No
Expanded ............................... No
1
I/////////////////////////////////////////////////////////////////I
II II
II ASSOCIATOR SUMMARY REPORT OF NORMAL INDEX FOR FILE 13 II
II II
I/////////////////////////////////////////////////////////////////I
Physical extents list
-------------------------------------------------------------------
I Extent I Type I From To I % unused I Device I
I I I RABN RABN I blocks I type I
I--------I------I-----------------------------I----------I--------I
I 1 I NI I 3178 3197 I 100 I 3390 I
I I I I I I
-------------------------------------------------------------------
Range of RABNs being processed according
to consolidated input parameters
(unused RABNs at the end of extents excluded)
-----------------------------------------------
I Extent I Type I From To I
I I I RABN RABN I
I--------I------I-----------------------------I
File ......................... 13
Device Type .................. 3390
Block Size ................... 2544
ASSO Padding factor .......... 10% (254 bytes)
Number of allocated blocks ............................... 20
Number of used blocks .................................... 0
Number of blocks read (SAMPLING = 100%) .................. 0
Number of unused blocks at the end of extents ............ 20
Number of unused blocks within the used extents .......... 0
Percent of blocks with free space less than padding ...... 0
Average percent of block filling (unused blocks excluded) 0
Number of elements in blocks read ........................ 0
Average number of elements per block ..................... 0
Average element length ................................... 0
Minimum element length ................................... 0
Maximum element length ................................... 0
Number of elements with minimum length ................... 0
Number of elements with maximum length ................... 0
1
I================================================I
II II
II DISTRIBUTION REPORTS ASSO NORMAL INDEX II
II File = 13 II
II Device type = 3390 II
I================================================I
DRU163W, WARNING: No data for "Block filling level" report (Part. 1)
DRU163W, WARNING: No data for "Block filling level" report (Part. 2)
DRU163W, WARNING: No data for "Number of elements per block" report
1
I/////////////////////////////////////////////////////////////////I
II II
II DATA STORAGE SUMMARY REPORT FOR FILE 13 II
II II
I/////////////////////////////////////////////////////////////////I
Physical extents list
-------------------------------------------------------------------
I Extent I Type I From To I % unused I Device I
I I I RABN RABN I blocks I type I
I--------I------I-----------------------------I----------I--------I
I 1 I DS I 8592 8611 I 100 I 3390 I
I I I I I I
-------------------------------------------------------------------
Range of RABNs being processed according
to consolidated input parameters
(unused RABNs at the end of extents excluded)
-----------------------------------------------
I Extent I Type I From To I
I I I RABN RABN I
I--------I------I-----------------------------I
File ......................... 13
Device Type .................. 3390
Block Size.................... 5064
DATA Storage Padding factor .. 0% (0 bytes)
Number of allocated blocks ............................... 20
Number of used blocks .................................... 0
Number of blocks read (SAMPLING = 100%) .................. 0
Number of unused blocks at the end of extents ............ 20
Number of unused blocks within the used extents .......... 0
Percent of blocks with free space less than padding ...... 0
Average percent of block filling (unused blocks excluded) 0
Number of records in blocks read ......................... 0
Number of Normal records .............................. 0
Number of Spanned records ............................. 0
Number of blocks with Spanned records .................... 0
Average number of records per block ...................... 0
Normal records:
Average record length ................................. 0
Minimum record length ................................. 0
Maximum record length ................................. 0
Number of records with minimum length ................. 0
Number of records with maximum length ................. 0
Spanned Record:
Average record length ................................. 0
Minimum record length ................................. 0
Maximum record length ................................. 0
Number of records with minimum length ................. 0
Number of records with maximum length ................. 0
Average numbers of segments ........................... 0
Minimum numbers of segments ........................... 0
Maximum numbers of segments ........................... 0
Number of Primary Spanned Records ..................... 0
Number of Secondary Spanned Records.................... 0
Number of AC2 blocks read ............................. 0
Data Storage blocks with secondary segments read ...... 0
1
I================================================I
II II
II DISTRIBUTION REPORTS DATA STORAGE II
II File = 13 II
II Device type = 3390 II
I================================================I
DRU163W, WARNING: No data for "Block filling level" report (Part. 1)
DRU163W, WARNING: No data for "Block filling level" report (Part. 2)
DRU163W, WARNING: No data for "Number of records per block" report
DRU163W, WARNING: No data for "Normal records length" report
DRU163W, WARNING: No data for "Spanned records length" report
1
1
***********************************************************************
***********************************************************************
***********************************************************************
**** ****
**** F I L E 14 ( PEGROUP ) ****
**** ****
**** 2012-05-11 12:37:53 ****
***********************************************************************
***********************************************************************
***********************************************************************
Consolidated input parameters:
------------------------------
File number = 14
ERRLIMIT = 1
LOB-GROUP = No
EXP-GROUP = No
ASSO Report type = SUMMARY
SAMPLING = 100 (10 of every 10 records read)
INCRUSAGE = 5
INCRNUMREC = Auto
FROM/TO RABN = Unused area of file extents
DATA Report type = SUMMARY
SAMPLING = 100 (10 of every 10 records read)
INCRUSAGE = 5
INCRNUMREC = Auto
INCRRECLEN = Auto
FROM/TO RABN = Unused area of file extents
1
File options (from FCB):
------------------------
Date / Time Loaded ..................... 2011-03-10 16:19:48.75
Date / Time of last update ............. n/a
Date / Time of last physical restructure 2011-03-10 16:19:48.75
ISN Reusage ............................ No
DATA Storage Reusage ................... Yes
MIXDSDEV ............................... No
Spanned Records Support ................ No
Index compressed ....................... No
2-Byte MU/PE Index ..................... No
Highest Index Level .................... 3
LOB fields ............................. No
LOB file ............................... No
Expanded ............................... No
1
I/////////////////////////////////////////////////////////////////I
II II
II ASSOCIATOR SUMMARY REPORT OF NORMAL INDEX FOR FILE 14 II
II II
I/////////////////////////////////////////////////////////////////I
Physical extents list
-------------------------------------------------------------------
I Extent I Type I From To I % unused I Device I
I I I RABN RABN I blocks I type I
I--------I------I-----------------------------I----------I--------I
I 1 I NI I 3206 3225 I 100 I 3390 I
I I I I I I
-------------------------------------------------------------------
Range of RABNs being processed according
to consolidated input parameters
(unused RABNs at the end of extents excluded)
-----------------------------------------------
I Extent I Type I From To I
I I I RABN RABN I
I--------I------I-----------------------------I
File ......................... 14
Device Type .................. 3390
Block Size ................... 2544
ASSO Padding factor .......... 10% (254 bytes)
Number of allocated blocks ............................... 20
Number of used blocks .................................... 0
Number of blocks read (SAMPLING = 100%) .................. 0
Number of unused blocks at the end of extents ............ 20
Number of unused blocks within the used extents .......... 0
Percent of blocks with free space less than padding ...... 0
Average percent of block filling (unused blocks excluded) 0
Number of elements in blocks read ........................ 0
Average number of elements per block ..................... 0
Average element length ................................... 0
Minimum element length ................................... 0
Maximum element length ................................... 0
Number of elements with minimum length ................... 0
Number of elements with maximum length ................... 0
1
I================================================I
II II
II DISTRIBUTION REPORTS ASSO NORMAL INDEX II
II File = 14 II
II Device type = 3390 II
I================================================I
DRU163W, WARNING: No data for "Block filling level" report (Part. 1)
DRU163W, WARNING: No data for "Block filling level" report (Part. 2)
DRU163W, WARNING: No data for "Number of elements per block" report
1
I/////////////////////////////////////////////////////////////////I
II II
II DATA STORAGE SUMMARY REPORT FOR FILE 14 II
II II
I/////////////////////////////////////////////////////////////////I
Physical extents list
-------------------------------------------------------------------
I Extent I Type I From To I % unused I Device I
I I I RABN RABN I blocks I type I
I--------I------I-----------------------------I----------I--------I
I 1 I DS I 8612 8631 I 100 I 3390 I
I I I I I I
-------------------------------------------------------------------
Range of RABNs being processed according
to consolidated input parameters
(unused RABNs at the end of extents excluded)
-----------------------------------------------
I Extent I Type I From To I
I I I RABN RABN I
I--------I------I-----------------------------I
File ......................... 14
Device Type .................. 3390
Block Size.................... 5064
DATA Storage Padding factor .. 10% (506 bytes)
Number of allocated blocks ............................... 20
Number of used blocks .................................... 0
Number of blocks read (SAMPLING = 100%) .................. 0
Number of unused blocks at the end of extents ............ 20
Number of unused blocks within the used extents .......... 0
Percent of blocks with free space less than padding ...... 0
Average percent of block filling (unused blocks excluded) 0
Number of records in blocks read ......................... 0
Number of Normal records .............................. 0
Number of Spanned records ............................. n/a
Number of blocks with Spanned records .................... n/a
Average number of records per block ...................... 0
Normal records:
Average record length ................................. 0
Minimum record length ................................. 0
Maximum record length ................................. 0
Number of records with minimum length ................. 0
Number of records with maximum length ................. 0
1
I================================================I
II II
II DISTRIBUTION REPORTS DATA STORAGE II
II File = 14 II
II Device type = 3390 II
I================================================I
DRU163W, WARNING: No data for "Block filling level" report (Part. 1)
DRU163W, WARNING: No data for "Block filling level" report (Part. 2)
DRU163W, WARNING: No data for "Number of records per block" report
DRU163W, WARNING: No data for "Normal records length" report
1
1
***********************************************************************
***********************************************************************
***********************************************************************
**** ****
**** F I L E 15 ( TESTFILE ) ****
**** ****
**** 2012-05-11 12:37:53 ****
***********************************************************************
***********************************************************************
***********************************************************************
Consolidated input parameters:
------------------------------
File number = 15
ERRLIMIT = 1
LOB-GROUP = No
EXP-GROUP = No
ASSO Report type = SUMMARY
SAMPLING = 100 (10 of every 10 records read)
INCRUSAGE = 5
INCRNUMREC = Auto
FROM/TO RABN = Unused area of file extents
DATA Report type = SUMMARY
SAMPLING = 100 (10 of every 10 records read)
INCRUSAGE = 5
INCRNUMREC = Auto
INCRRECLEN = Auto
FROM/TO RABN = 8572 - 8573
1
File options (from FCB):
------------------------
Date / Time Loaded ..................... 2011-01-12 11:53:26.64
Date / Time of last update ............. n/a
Date / Time of last physical restructure 2011-01-12 11:53:26.64
ISN Reusage ............................ No
DATA Storage Reusage ................... Yes
MIXDSDEV ............................... No
Spanned Records Support ................ Yes
Index compressed ....................... No
2-Byte MU/PE Index ..................... No
Highest Index Level .................... 0
LOB fields ............................. No
LOB file ............................... No
Expanded ............................... No
1
I/////////////////////////////////////////////////////////////////I
II II
II ASSOCIATOR SUMMARY REPORT OF NORMAL INDEX FOR FILE 15 II
II II
I/////////////////////////////////////////////////////////////////I
Physical extents list
-------------------------------------------------------------------
I Extent I Type I From To I % unused I Device I
I I I RABN RABN I blocks I type I
I--------I------I-----------------------------I----------I--------I
I 1 I NI I 3150 3169 I 100 I 3390 I
I I I I I I
-------------------------------------------------------------------
Range of RABNs being processed according
to consolidated input parameters
(unused RABNs at the end of extents excluded)
-----------------------------------------------
I Extent I Type I From To I
I I I RABN RABN I
I--------I------I-----------------------------I
File ......................... 15
Device Type .................. 3390
Block Size ................... 2544
ASSO Padding factor .......... 10% (254 bytes)
Number of allocated blocks ............................... 20
Number of used blocks .................................... 0
Number of blocks read (SAMPLING = 100%) .................. 0
Number of unused blocks at the end of extents ............ 20
Number of unused blocks within the used extents .......... 0
Percent of blocks with free space less than padding ...... 0
Average percent of block filling (unused blocks excluded) 0
Number of elements in blocks read ........................ 0
Average number of elements per block ..................... 0
Average element length ................................... 0
Minimum element length ................................... 0
Maximum element length ................................... 0
Number of elements with minimum length ................... 0
Number of elements with maximum length ................... 0
1
I================================================I
II II
II DISTRIBUTION REPORTS ASSO NORMAL INDEX II
II File = 15 II
II Device type = 3390 II
I================================================I
DRU163W, WARNING: No data for "Block filling level" report (Part. 1)
DRU163W, WARNING: No data for "Block filling level" report (Part. 2)
DRU163W, WARNING: No data for "Number of elements per block" report
1
I/////////////////////////////////////////////////////////////////I
II II
II DATA STORAGE SUMMARY REPORT FOR FILE 15 II
II II
I/////////////////////////////////////////////////////////////////I
Physical extents list
-------------------------------------------------------------------
I Extent I Type I From To I % unused I Device I
I I I RABN RABN I blocks I type I
I--------I------I-----------------------------I----------I--------I
I 1 I DS I 8572 8591 I 90 I 3390 I
I I I I I I
-------------------------------------------------------------------
Range of RABNs being processed according
to consolidated input parameters
(unused RABNs at the end of extents excluded)
-----------------------------------------------
I Extent I Type I From To I
I I I RABN RABN I
I--------I------I-----------------------------I
I 1 I DS I 8572 8573 I
I I I I
-----------------------------------------------
File ......................... 15
Device Type .................. 3390
Block Size.................... 5064
DATA Storage Padding factor .. 0% (0 bytes)
Number of allocated blocks ............................... 20
Number of used blocks .................................... 2
Number of blocks read (SAMPLING = 100%) .................. 2
Number of unused blocks at the end of extents ............ 18
Number of unused blocks within the used extents .......... 0
Percent of blocks with free space less than padding ...... 0
Average percent of block filling (unused blocks excluded) 77
Number of records in blocks read ......................... 1
Number of Normal records .............................. 0
Number of Spanned records ............................. 1
Number of blocks with Spanned records .................... 2
Average number of records per block ...................... 1
Normal records:
Average record length ................................. 0
Minimum record length ................................. 32767
Maximum record length ................................. 0
Number of records with minimum length ................. 0
Number of records with maximum length ................. 0
Spanned Record:
Average record length ................................. 7818
Minimum record length ................................. 7818
Maximum record length ................................. 7818
Number of records with minimum length ................. 1
Number of records with maximum length ................. 1
Average numbers of segments ........................... 2
Minimum numbers of segments ........................... 2
Maximum numbers of segments ........................... 2
Number of Primary Spanned Records ..................... 1
Number of Secondary Spanned Records.................... 1
Number of AC2 blocks read ............................. 1
Data Storage blocks with secondary segments read ...... 1
1
I================================================I
II II
II DISTRIBUTION REPORTS DATA STORAGE II
II File = 15 II
II Device type = 3390 II
I================================================I
Block filling level; Increment = 5%
--------------------------------------------------
I Range of I Number of blocks I
I percent filled I filled in this range I
I---------------------I--------------------------I
I 51 - 55 I 1 I
I 96 - 100 I 1 I
--------------------------------------------------
--------------------------------------------------
I Percent ranges I Number of blocks with I
I of free space I free space in this range I
I---------------------I--------------------------I
I 1 - 5 I 1 I
I 41 - 45 I 1 I
--------------------------------------------------
1
Number of records per block; Increment = Auto
--------------------------------------------------
I Number of records I Number I
I per block I of blocks I
I---------------------I--------------------------I
I 1 - 6 I 2 I
--------------------------------------------------
DRU163W, WARNING: No data for "Normal records length" report
1
Spanned records length; Increment = Auto
--------------------------------------------------
I Length I Number I
I of record I of records I
I---------------------I--------------------------I
I 7801 - 7826 I 1 I
--------------------------------------------------
1
***********************************************************************
***********************************************************************
***********************************************************************
**** ****
**** F i l e s s t a t i s t i c a l r e p o r t ****
**** ****
***********************************************************************
***********************************************************************
***********************************************************************
-------------------------------------------------------------------------------
I F I Duration I ASSOCIATOR (NI) I DATA STORAGE I ParmI Run I
I i IHH:MM:SS.thI------------------------I------------------------I-----I-----I
I l I I Number I E I Extents I Number I E I Extents I E W I E W I
I e I I of RABNs I r I---------I of RABNs I r I---------I r n I r n I
I I I read I r I FCB Run I read I r I FCB Run I r g I r g I
I---I-----------I----------I---I----I----I----------I---I----I----I--I--I--I--I
9 00:00:00.13 13 0 3 3 6 0 1 1 0 0 0 1
10 00:00:00.02 12 0 1 1 4 0 1 1 0 0 0 0
11 00:00:00.00 0 0 0 0 0 0 0 0 0 0 0 7
12 00:00:00.00 0 0 0 0 0 0 0 0 0 0 0 7
13 00:00:00.00 0 0 0 0 0 0 0 0 0 0 0 8
14 00:00:00.00 0 0 0 0 0 0 0 0 0 0 0 7
15 00:00:00.02 0 0 0 0 2 0 1 1 0 0 0 4
1
DRU205I, ******* SPACEUSAGE-5 ended ******* CC = 04
This sample shows ADADRU SPACEUSAGE processing of the EXPGROUP parameter. The expanded files in this example have the following chain: file 22 (the anchor file), file 20, and file 13.
In the first FILE parameter, the EXPGROUP parameter is omitted. Consequently, the whole chain of expanded files is not processed.
In the second FILE parameter, the EXPGROUP parameter is included. Consequently, ADADRU SPACEUSAGE processes the whole chain of expanded files in logical order (file 22 first, followed by files 20 and 13). After all the file reports are produced, ADADRU produces a summary report of the expanded files.
ADADRU processes files only after all parameters are consolidated.
ADADRU SPACEUSAGE FILE=20,PFILESPACE=DETAIL
ADADRU FILE=13,PFILESPACE=DETAIL,EXPGROUP
1
DRU203I, ******* SPACEUSAGE-1 started ******* 2012-05-11 12:48:31
File group number 1. FILE=20
-----------------
File group number 2. FILE=13
-----------------
DRU200I, The input parameters accepted.
EXPANDED GROUPS:
---------------------------
I File I Sequence I
I I number I
I------------I------------I
I 22 I Anchor I
I 20 I 2 I
I 13 I 3 I
I I I
---------------------------
DRU161W, WARNING: File 13, part 3 of expanded file
will be processed in chain of all parts of expanded file.
Anchor File 22.
DRU161W, WARNING: File 20, part 2 of expanded file
will be processed in chain of all parts of expanded file.
Anchor File 22.
1
1
***********************************************************************
***********************************************************************
***********************************************************************
**** ****
**** F I L E 22 ( TESTFILE ) ****
**** ****
**** 2012-05-11 12:48:31 ****
***********************************************************************
***********************************************************************
***********************************************************************
Consolidated input parameters:
------------------------------
File number = 22
ERRLIMIT = 1
LOB-GROUP = No
EXP-GROUP = Yes
ASSO Report type = SUMMARY + DETAIL
SAMPLING = 100 (10 of every 10 records read)
INCRUSAGE = 5
INCRNUMREC = Auto
FROM/TO RABN = 2151 - 2164
DATA Report type = SUMMARY + DETAIL
SAMPLING = 100 (10 of every 10 records read)
INCRUSAGE = 5
INCRNUMREC = Auto
INCRRECLEN = Auto
FROM/TO RABN = 5382 - 5385
1
File options (from FCB):
------------------------
Date / Time Loaded ..................... 2011-09-27 11:20:10.24
Date / Time of last update ............. 2011-10-21 12:17:55.72
Date / Time of last physical restructure 2011-09-27 11:20:10.24
ISN Reusage ............................ No
DATA Storage Reusage ................... Yes
MIXDSDEV ............................... No
Spanned Records Support ................ No
Index compressed ....................... No
2-Byte MU/PE Index ..................... No
Highest Index Level .................... 3
LOB fields ............................. No
LOB file ............................... No
Expanded ............................... Yes. Seq.number = 1. ANCHOR = 22
1
I/////////////////////////////////////////////////////////////////I
II II
II ASSOCIATOR SUMMARY REPORT OF NORMAL INDEX FOR FILE 22 II
II II
I/////////////////////////////////////////////////////////////////I
Physical extents list
-------------------------------------------------------------------
I Extent I Type I From To I % unused I Device I
I I I RABN RABN I blocks I type I
I--------I------I-----------------------------I----------I--------I
I 1 I NI I 2151 2170 I 30 I 3390 I
I I I I I I
-------------------------------------------------------------------
Range of RABNs being processed according
to consolidated input parameters
(unused RABNs at the end of extents excluded)
-----------------------------------------------
I Extent I Type I From To I
I I I RABN RABN I
I--------I------I-----------------------------I
I 1 I NI I 2151 2164 I
I I I I
-----------------------------------------------
File ......................... 22
Device Type .................. 3390
Block Size ................... 2544
ASSO Padding factor .......... 10% (254 bytes)
Number of allocated blocks ............................... 20
Number of used blocks .................................... 14
Number of blocks read (SAMPLING = 100%) .................. 14
Number of unused blocks at the end of extents ............ 6
Number of unused blocks within the used extents .......... 0
Percent of blocks with free space less than padding ...... 0
Average percent of block filling (unused blocks excluded) 37
Number of elements in blocks read ........................ 767
Average number of elements per block ..................... 55
Average element length ................................... 17
Minimum element length ................................... 8
Maximum element length ................................... 293
Number of elements with minimum length ................... 29
Number of elements with maximum length ................... 1
1
I================================================I
II II
II DISTRIBUTION REPORTS ASSO NORMAL INDEX II
II File = 22 II
II Device type = 3390 II
I================================================I
Block filling level; Increment = 5%
--------------------------------------------------
I Range of I Number of blocks I
I percent filled I filled in this range I
I---------------------I--------------------------I
I 11 - 15 I 2 I
I 16 - 20 I 3 I
I 21 - 25 I 2 I
I 26 - 30 I 1 I
I 31 - 35 I 1 I
I 41 - 45 I 1 I
I 46 - 50 I 1 I
I 66 - 70 I 1 I
I 86 - 90 I 2 I
--------------------------------------------------
--------------------------------------------------
I Percent ranges I Number of blocks with I
I of free space I free space in this range I
I---------------------I--------------------------I
I 6 - 10 I 1 I
I 11 - 15 I 1 I
I 31 - 35 I 1 I
I 46 - 50 I 1 I
I 56 - 60 I 1 I
I 66 - 70 I 1 I
I 71 - 75 I 1 I
I 76 - 80 I 2 I
I 81 - 85 I 3 I
I 86 - 90 I 2 I
--------------------------------------------------
1
Number of elements per block; Increment = Auto
--------------------------------------------------
I Number of elements I Number I
I per block I of blocks I
I---------------------I--------------------------I
I 4 - 6 I 2 I
I 7 - 9 I 1 I
I 22 - 24 I 2 I
I 40 - 42 I 2 I
I 46 - 48 I 2 I
I 91 - 93 I 1 I
I 94 - 96 I 1 I
I 97 - 99 I 1 I
I 115 - 117 I 1 I
I 121 - 123 I 1 I
--------------------------------------------------
1
I/////////////////////////////////////////////////////////////////I
II II
II DATA STORAGE SUMMARY REPORT FOR FILE 22 II
II II
I/////////////////////////////////////////////////////////////////I
Physical extents list
-------------------------------------------------------------------
I Extent I Type I From To I % unused I Device I
I I I RABN RABN I blocks I type I
I--------I------I-----------------------------I----------I--------I
I 1 I DS I 5382 5401 I 80 I 3390 I
I I I I I I
-------------------------------------------------------------------
Range of RABNs being processed according
to consolidated input parameters
(unused RABNs at the end of extents excluded)
-----------------------------------------------
I Extent I Type I From To I
I I I RABN RABN I
I--------I------I-----------------------------I
I 1 I DS I 5382 5385 I
I I I I
-----------------------------------------------
File ......................... 22
Device Type .................. 3390
Block Size.................... 5064
DATA Storage Padding factor .. 10% (506 bytes)
Number of allocated blocks ............................... 20
Number of used blocks .................................... 4
Number of blocks read (SAMPLING = 100%) .................. 4
Number of unused blocks at the end of extents ............ 16
Number of unused blocks within the used extents .......... 0
Percent of blocks with free space less than padding ...... 25
Average percent of block filling (unused blocks excluded) 82
Number of records in blocks read ......................... 98
Number of Normal records .............................. 98
Number of Spanned records ............................. n/a
Number of blocks with Spanned records .................... n/a
Average number of records per block ...................... 25
Normal records:
Average record length ................................. 168
Minimum record length ................................. 126
Maximum record length ................................. 208
Number of records with minimum length ................. 1
Number of records with maximum length ................. 1
1
I================================================I
II II
II DISTRIBUTION REPORTS DATA STORAGE II
II File = 22 II
II Device type = 3390 II
I================================================I
Block filling level; Increment = 5%
--------------------------------------------------
I Range of I Number of blocks I
I percent filled I filled in this range I
I---------------------I--------------------------I
I 61 - 65 I 1 I
I 76 - 80 I 1 I
I 86 - 90 I 1 I
I 91 - 95 I 1 I
--------------------------------------------------
--------------------------------------------------
I Percent ranges I Number of blocks with I
I of free space I free space in this range I
I---------------------I--------------------------I
I 1 - 5 I 1 I
I 11 - 15 I 1 I
I 16 - 20 I 1 I
I 36 - 40 I 1 I
--------------------------------------------------
1
Number of records per block; Increment = Auto
--------------------------------------------------
I Number of records I Number I
I per block I of blocks I
I---------------------I--------------------------I
I 13 - 18 I 1 I
I 19 - 24 I 1 I
I 25 - 30 I 2 I
--------------------------------------------------
1
Normal records length; Increment = Auto
--------------------------------------------------
I Length I Number I
I of record I of records I
I---------------------I--------------------------I
I 121 - 126 I 1 I
I 133 - 138 I 2 I
I 139 - 144 I 2 I
I 145 - 150 I 6 I
I 151 - 156 I 14 I
I 157 - 162 I 16 I
I 163 - 168 I 13 I
I 169 - 174 I 10 I
I 175 - 180 I 9 I
I 181 - 186 I 11 I
I 187 - 192 I 4 I
I 193 - 198 I 4 I
I 199 - 204 I 3 I
I 205 - 210 I 3 I
--------------------------------------------------
1
1
***********************************************************************
***********************************************************************
***********************************************************************
**** ****
**** F I L E 20 ( TESTFILE ) ****
**** ****
**** 2012-05-11 12:48:31 ****
***********************************************************************
***********************************************************************
***********************************************************************
Consolidated input parameters:
------------------------------
File number = 20
ERRLIMIT = 1
LOB-GROUP = No
EXP-GROUP = Yes
ASSO Report type = SUMMARY + DETAIL
SAMPLING = 100 (10 of every 10 records read)
INCRUSAGE = 5
INCRNUMREC = Auto
FROM/TO RABN = 2188 - 2201
DATA Report type = SUMMARY + DETAIL
SAMPLING = 100 (10 of every 10 records read)
INCRUSAGE = 5
INCRNUMREC = Auto
INCRRECLEN = Auto
FROM/TO RABN = 5402 - 5405
1
File options (from FCB):
------------------------
Date / Time Loaded ..................... 2011-09-27 11:20:20.72
Date / Time of last update ............. 2011-09-27 11:39:24.72
Date / Time of last physical restructure 2011-09-27 11:20:20.72
ISN Reusage ............................ No
DATA Storage Reusage ................... Yes
MIXDSDEV ............................... No
Spanned Records Support ................ No
Index compressed ....................... No
2-Byte MU/PE Index ..................... No
Highest Index Level .................... 3
LOB fields ............................. No
LOB file ............................... No
Expanded ............................... Yes. Seq.number = 2. ANCHOR = 22
1
I/////////////////////////////////////////////////////////////////I
II II
II ASSOCIATOR SUMMARY REPORT OF NORMAL INDEX FOR FILE 20 II
II II
I/////////////////////////////////////////////////////////////////I
Physical extents list
-------------------------------------------------------------------
I Extent I Type I From To I % unused I Device I
I I I RABN RABN I blocks I type I
I--------I------I-----------------------------I----------I--------I
I 1 I NI I 2188 2207 I 30 I 3390 I
I I I I I I
-------------------------------------------------------------------
Range of RABNs being processed according
to consolidated input parameters
(unused RABNs at the end of extents excluded)
-----------------------------------------------
I Extent I Type I From To I
I I I RABN RABN I
I--------I------I-----------------------------I
I 1 I NI I 2188 2201 I
I I I I
-----------------------------------------------
File ......................... 20
Device Type .................. 3390
Block Size ................... 2544
ASSO Padding factor .......... 10% (254 bytes)
Number of allocated blocks ............................... 20
Number of used blocks .................................... 14
Number of blocks read (SAMPLING = 100%) .................. 14
Number of unused blocks at the end of extents ............ 6
Number of unused blocks within the used extents .......... 0
Percent of blocks with free space less than padding ...... 0
Average percent of block filling (unused blocks excluded) 38
Number of elements in blocks read ........................ 780
Average number of elements per block ..................... 56
Average element length ................................... 17
Minimum element length ................................... 8
Maximum element length ................................... 299
Number of elements with minimum length ................... 30
Number of elements with maximum length ................... 1
1
I================================================I
II II
II DISTRIBUTION REPORTS ASSO NORMAL INDEX II
II File = 20 II
II Device type = 3390 II
I================================================I
Block filling level; Increment = 5%
--------------------------------------------------
I Range of I Number of blocks I
I percent filled I filled in this range I
I---------------------I--------------------------I
I 11 - 15 I 2 I
I 16 - 20 I 3 I
I 21 - 25 I 2 I
I 26 - 30 I 1 I
I 31 - 35 I 1 I
I 41 - 45 I 1 I
I 51 - 55 I 1 I
I 66 - 70 I 1 I
I 86 - 90 I 2 I
--------------------------------------------------
--------------------------------------------------
I Percent ranges I Number of blocks with I
I of free space I free space in this range I
I---------------------I--------------------------I
I 6 - 10 I 2 I
I 31 - 35 I 1 I
I 46 - 50 I 1 I
I 56 - 60 I 1 I
I 61 - 65 I 1 I
I 71 - 75 I 1 I
I 76 - 80 I 3 I
I 81 - 85 I 2 I
I 86 - 90 I 2 I
--------------------------------------------------
1
Number of elements per block; Increment = Auto
--------------------------------------------------
I Number of elements I Number I
I per block I of blocks I
I---------------------I--------------------------I
I 4 - 6 I 2 I
I 7 - 9 I 1 I
I 22 - 24 I 2 I
I 40 - 42 I 2 I
I 46 - 48 I 2 I
I 94 - 96 I 1 I
I 97 - 99 I 1 I
I 100 - 102 I 1 I
I 118 - 120 I 1 I
I 121 - 123 I 1 I
--------------------------------------------------
1
I/////////////////////////////////////////////////////////////////I
II II
II DATA STORAGE SUMMARY REPORT FOR FILE 20 II
II II
I/////////////////////////////////////////////////////////////////I
Physical extents list
-------------------------------------------------------------------
I Extent I Type I From To I % unused I Device I
I I I RABN RABN I blocks I type I
I--------I------I-----------------------------I----------I--------I
I 1 I DS I 5402 5421 I 80 I 3390 I
I I I I I I
-------------------------------------------------------------------
Range of RABNs being processed according
to consolidated input parameters
(unused RABNs at the end of extents excluded)
-----------------------------------------------
I Extent I Type I From To I
I I I RABN RABN I
I--------I------I-----------------------------I
I 1 I DS I 5402 5405 I
I I I I
-----------------------------------------------
File ......................... 20
Device Type .................. 3390
Block Size.................... 5064
DATA Storage Padding factor .. 10% (506 bytes)
Number of allocated blocks ............................... 20
Number of used blocks .................................... 4
Number of blocks read (SAMPLING = 100%) .................. 4
Number of unused blocks at the end of extents ............ 16
Number of unused blocks within the used extents .......... 0
Percent of blocks with free space less than padding ...... 25
Average percent of block filling (unused blocks excluded) 83
Number of records in blocks read ......................... 100
Number of Normal records .............................. 100
Number of Spanned records ............................. n/a
Number of blocks with Spanned records .................... n/a
Average number of records per block ...................... 25
Normal records:
Average record length ................................. 168
Minimum record length ................................. 126
Maximum record length ................................. 208
Number of records with minimum length ................. 1
Number of records with maximum length ................. 1
1
I================================================I
II II
II DISTRIBUTION REPORTS DATA STORAGE II
II File = 20 II
II Device type = 3390 II
I================================================I
Block filling level; Increment = 5%
--------------------------------------------------
I Range of I Number of blocks I
I percent filled I filled in this range I
I---------------------I--------------------------I
I 61 - 65 I 1 I
I 86 - 90 I 2 I
I 91 - 95 I 1 I
--------------------------------------------------
--------------------------------------------------
I Percent ranges I Number of blocks with I
I of free space I free space in this range I
I---------------------I--------------------------I
I 1 - 5 I 1 I
I 11 - 15 I 2 I
I 36 - 40 I 1 I
--------------------------------------------------
1
Number of records per block; Increment = Auto
--------------------------------------------------
I Number of records I Number I
I per block I of blocks I
I---------------------I--------------------------I
I 13 - 18 I 1 I
I 25 - 30 I 3 I
--------------------------------------------------
1
Normal records length; Increment = Auto
--------------------------------------------------
I Length I Number I
I of record I of records I
I---------------------I--------------------------I
I 121 - 126 I 1 I
I 133 - 138 I 2 I
I 139 - 144 I 2 I
I 145 - 150 I 6 I
I 151 - 156 I 14 I
I 157 - 162 I 16 I
I 163 - 168 I 13 I
I 169 - 174 I 11 I
I 175 - 180 I 9 I
I 181 - 186 I 11 I
I 187 - 192 I 5 I
I 193 - 198 I 4 I
I 199 - 204 I 3 I
I 205 - 210 I 3 I
--------------------------------------------------
1
1
***********************************************************************
***********************************************************************
***********************************************************************
**** ****
**** F I L E 13 ( TESTFILE ) ****
**** ****
**** 2012-05-11 12:48:31 ****
***********************************************************************
***********************************************************************
***********************************************************************
Consolidated input parameters:
------------------------------
File number = 13
ERRLIMIT = 1
LOB-GROUP = No
EXP-GROUP = Yes
ASSO Report type = SUMMARY + DETAIL
SAMPLING = 100 (10 of every 10 records read)
INCRUSAGE = 5
INCRNUMREC = Auto
FROM/TO RABN = 3761 - 3768
DATA Report type = SUMMARY + DETAIL
SAMPLING = 100 (10 of every 10 records read)
INCRUSAGE = 5
INCRNUMREC = Auto
INCRRECLEN = Auto
FROM/TO RABN = 9523 - 9523
1
File options (from FCB):
------------------------
Date / Time Loaded ..................... 2011-09-27 11:20:36.45
Date / Time of last update ............. 2011-10-04 07:05:44.83
Date / Time of last physical restructure 2011-09-27 11:20:36.45
ISN Reusage ............................ No
DATA Storage Reusage ................... Yes
MIXDSDEV ............................... No
Spanned Records Support ................ No
Index compressed ....................... No
2-Byte MU/PE Index ..................... No
Highest Index Level .................... 3
LOB fields ............................. No
LOB file ............................... No
Expanded ............................... Yes. Seq.number = 3. ANCHOR = 22
1
I/////////////////////////////////////////////////////////////////I
II II
II ASSOCIATOR SUMMARY REPORT OF NORMAL INDEX FOR FILE 13 II
II II
I/////////////////////////////////////////////////////////////////I
Physical extents list
-------------------------------------------------------------------
I Extent I Type I From To I % unused I Device I
I I I RABN RABN I blocks I type I
I--------I------I-----------------------------I----------I--------I
I 1 I NI I 3761 3780 I 60 I 3390 I
I I I I I I
-------------------------------------------------------------------
Range of RABNs being processed according
to consolidated input parameters
(unused RABNs at the end of extents excluded)
-----------------------------------------------
I Extent I Type I From To I
I I I RABN RABN I
I--------I------I-----------------------------I
I 1 I NI I 3761 3768 I
I I I I
-----------------------------------------------
File ......................... 13
Device Type .................. 3390
Block Size ................... 2544
ASSO Padding factor .......... 10% (254 bytes)
Number of allocated blocks ............................... 20
Number of used blocks .................................... 8
Number of blocks read (SAMPLING = 100%) .................. 8
Number of unused blocks at the end of extents ............ 12
Number of unused blocks within the used extents .......... 0
Percent of blocks with free space less than padding ...... 0
Average percent of block filling (unused blocks excluded) 1
Number of elements in blocks read ........................ 29
Average number of elements per block ..................... 4
Average element length ................................... 10
Minimum element length ................................... 6
Maximum element length ................................... 23
Number of elements with minimum length ................... 1
Number of elements with maximum length ................... 1
1
I================================================I
II II
II DISTRIBUTION REPORTS ASSO NORMAL INDEX II
II File = 13 II
II Device type = 3390 II
I================================================I
Block filling level; Increment = 5%
--------------------------------------------------
I Range of I Number of blocks I
I percent filled I filled in this range I
I---------------------I--------------------------I
I 1 - 5 I 7 I
I 6 - 10 I 1 I
--------------------------------------------------
--------------------------------------------------
I Percent ranges I Number of blocks with I
I of free space I free space in this range I
I---------------------I--------------------------I
I 91 - 95 I 1 I
I 96 - 100 I 7 I
--------------------------------------------------
1
Number of elements per block; Increment = Auto
--------------------------------------------------
I Number of elements I Number I
I per block I of blocks I
I---------------------I--------------------------I
I 1 - 3 I 6 I
I 4 - 6 I 1 I
I 16 - 18 I 1 I
--------------------------------------------------
1
I/////////////////////////////////////////////////////////////////I
II II
II DATA STORAGE SUMMARY REPORT FOR FILE 13 II
II II
I/////////////////////////////////////////////////////////////////I
Physical extents list
-------------------------------------------------------------------
I Extent I Type I From To I % unused I Device I
I I I RABN RABN I blocks I type I
I--------I------I-----------------------------I----------I--------I
I 1 I DS I 9523 9542 I 95 I 3390 I
I I I I I I
-------------------------------------------------------------------
Range of RABNs being processed according
to consolidated input parameters
(unused RABNs at the end of extents excluded)
-----------------------------------------------
I Extent I Type I From To I
I I I RABN RABN I
I--------I------I-----------------------------I
I 1 I DS I 9523 9523 I
I I I I
-----------------------------------------------
File ......................... 13
Device Type .................. 3390
Block Size.................... 5064
DATA Storage Padding factor .. 10% (506 bytes)
Number of allocated blocks ............................... 20
Number of used blocks .................................... 1
Number of blocks read (SAMPLING = 100%) .................. 1
Number of unused blocks at the end of extents ............ 19
Number of unused blocks within the used extents .......... 0
Percent of blocks with free space less than padding ...... 0
Average percent of block filling (unused blocks excluded) 6
Number of records in blocks read ......................... 6
Number of Normal records .............................. 6
Number of Spanned records ............................. n/a
Number of blocks with Spanned records .................... n/a
Average number of records per block ...................... 6
Normal records:
Average record length ................................. 47
Minimum record length ................................. 31
Maximum record length ................................. 71
Number of records with minimum length ................. 1
Number of records with maximum length ................. 1
1
I================================================I
II II
II DISTRIBUTION REPORTS DATA STORAGE II
II File = 13 II
II Device type = 3390 II
I================================================I
Block filling level; Increment = 5%
--------------------------------------------------
I Range of I Number of blocks I
I percent filled I filled in this range I
I---------------------I--------------------------I
I 6 - 10 I 1 I
--------------------------------------------------
--------------------------------------------------
I Percent ranges I Number of blocks with I
I of free space I free space in this range I
I---------------------I--------------------------I
I 91 - 95 I 1 I
--------------------------------------------------
1
Number of records per block; Increment = Auto
--------------------------------------------------
I Number of records I Number I
I per block I of blocks I
I---------------------I--------------------------I
I 1 - 6 I 1 I
--------------------------------------------------
1
Normal records length; Increment = Auto
--------------------------------------------------
I Length I Number I
I of record I of records I
I---------------------I--------------------------I
I 31 - 36 I 2 I
I 43 - 48 I 2 I
I 55 - 60 I 1 I
I 67 - 72 I 1 I
--------------------------------------------------
*******************************************************************
*******************************************************************
*******************************************************************
**** ****
**** Summary reports about all parts of expanded file: ****
**** 22 20 13 ****
*******************************************************************
*******************************************************************
*******************************************************************
1
I/////////////////////////////////////////////////////////////////I
II II
II ASSOCIATOR SUMMARY REPORT OF NORMAL INDEX II
II (All parts of expanded file) II
I/////////////////////////////////////////////////////////////////I
Number of allocated blocks ............................... 60
Number of used blocks .................................... 36
Number of blocks read (SAMPLING = 100%) .................. 36
Number of unused blocks at the end of extents ............ 24
Number of unused blocks within the used extents .......... 0
Percent of blocks with free space less than padding ...... 0
Average percent of block filling (unused blocks excluded) 30
Number of elements in blocks read ........................ 1576
Average number of elements per block ..................... 44
Average element length ................................... 17
Minimum element length ................................... 6
Maximum element length ................................... 299
Number of elements with minimum length ................... 1
Number of elements with maximum length ................... 1
1
I================================================I
II II
II DISTRIBUTION REPORTS ASSO NORMAL INDEX II
II (All parts of expanded file) II
II Device type = 3390 II
I================================================I
Block filling level; Increment = 5%
--------------------------------------------------
I Range of I Number of blocks I
I percent filled I filled in this range I
I---------------------I--------------------------I
I 1 - 5 I 7 I
I 6 - 10 I 1 I
I 11 - 15 I 4 I
I 16 - 20 I 6 I
I 21 - 25 I 4 I
I 26 - 30 I 2 I
I 31 - 35 I 2 I
I 41 - 45 I 2 I
I 46 - 50 I 1 I
I 51 - 55 I 1 I
I 66 - 70 I 2 I
I 86 - 90 I 4 I
--------------------------------------------------
--------------------------------------------------
I Percent ranges I Number of blocks with I
I of free space I free space in this range I
I---------------------I--------------------------I
I 6 - 10 I 3 I
I 11 - 15 I 1 I
I 31 - 35 I 2 I
I 46 - 50 I 2 I
I 56 - 60 I 2 I
I 61 - 65 I 1 I
I 66 - 70 I 1 I
I 71 - 75 I 2 I
I 76 - 80 I 5 I
I 81 - 85 I 5 I
I 86 - 90 I 4 I
I 91 - 95 I 1 I
I 96 - 100 I 7 I
--------------------------------------------------
1
Number of elements per block; Increment = Auto
--------------------------------------------------
I Number of elements I Number I
I per block I of blocks I
I---------------------I--------------------------I
I 1 - 3 I 6 I
I 4 - 6 I 5 I
I 7 - 9 I 2 I
I 16 - 18 I 1 I
I 22 - 24 I 4 I
I 40 - 42 I 4 I
I 46 - 48 I 4 I
I 91 - 93 I 1 I
I 94 - 96 I 2 I
I 97 - 99 I 2 I
I 100 - 102 I 1 I
I 115 - 117 I 1 I
I 118 - 120 I 1 I
I 121 - 123 I 2 I
--------------------------------------------------
1
I/////////////////////////////////////////////////////////////////I
II II
II DATA STORAGE SUMMARY REPORT II
II (All parts of expanded file) II
I/////////////////////////////////////////////////////////////////I
Number of allocated blocks ............................... 60
Number of used blocks .................................... 9
Number of blocks read (SAMPLING = 100%) .................. 9
Number of unused blocks at the end of extents ............ 51
Number of unused blocks within the used extents .......... 0
Percent of blocks with free space less than padding ...... 22
Average percent of block filling (unused blocks excluded) 74
Number of records in blocks read ......................... 204
Number of Normal records .............................. 204
Number of Spanned records ............................. n/a
Number of blocks with Spanned records .................... n/a
Average number of records per block ...................... 23
Normal records:
Average record length ................................. 165
Minimum record length ................................. 31
Maximum record length ................................. 208
Number of records with minimum length ................. 1
Number of records with maximum length ................. 2
1
I================================================I
II II
II DISTRIBUTION REPORTS DATA STORAGE II
II (All parts of expanded file) II
II Device type = 3390 II
I================================================I
Block filling level; Increment = 5%
--------------------------------------------------
I Range of I Number of blocks I
I percent filled I filled in this range I
I---------------------I--------------------------I
I 6 - 10 I 1 I
I 61 - 65 I 2 I
I 76 - 80 I 1 I
I 86 - 90 I 3 I
I 91 - 95 I 2 I
--------------------------------------------------
--------------------------------------------------
I Percent ranges I Number of blocks with I
I of free space I free space in this range I
I---------------------I--------------------------I
I 1 - 5 I 2 I
I 11 - 15 I 3 I
I 16 - 20 I 1 I
I 36 - 40 I 2 I
I 91 - 95 I 1 I
--------------------------------------------------
1
Number of records per block; Increment = Auto
--------------------------------------------------
I Number of records I Number I
I per block I of blocks I
I---------------------I--------------------------I
I 1 - 6 I 1 I
I 13 - 18 I 2 I
I 19 - 24 I 1 I
I 25 - 30 I 5 I
--------------------------------------------------
1
Normal records length; Increment = Auto
--------------------------------------------------
I Length I Number I
I of record I of records I
I---------------------I--------------------------I
I 31 - 36 I 2 I
I 43 - 48 I 2 I
I 49 - 60 I 1 I
I 61 - 120 I 1 I
I 121 - 126 I 2 I
I 133 - 138 I 4 I
I 139 - 144 I 4 I
I 145 - 150 I 12 I
I 151 - 156 I 28 I
I 157 - 162 I 32 I
I 163 - 168 I 26 I
I 169 - 174 I 21 I
I 175 - 180 I 18 I
I 181 - 186 I 22 I
I 187 - 192 I 9 I
I 193 - 198 I 8 I
I 199 - 204 I 6 I
I 205 - 210 I 6 I
--------------------------------------------------
1
***********************************************************************
***********************************************************************
***********************************************************************
**** ****
**** F i l e s s t a t i s t i c a l r e p o r t ****
**** ****
***********************************************************************
***********************************************************************
***********************************************************************
-------------------------------------------------------------------------------
I F I Duration I ASSOCIATOR (NI) I DATA STORAGE I ParmI Run I
I i IHH:MM:SS.thI------------------------I------------------------I-----I-----I
I l I I Number I E I Extents I Number I E I Extents I E W I E W I
I e I I of RABNs I r I---------I of RABNs I r I---------I r n I r n I
I I I read I r I FCB Run I read I r I FCB Run I r g I r g I
I---I-----------I----------I---I----I----I----------I---I----I----I--I--I--I--I
13 00:00:00.05 8 0 1 1 1 0 1 1 0 0 0 1
20 00:00:00.02 14 0 1 1 4 0 1 1 0 0 0 1
22 00:00:00.05 14 0 1 1 4 0 1 1 0 0 0 0
1
DRU205I, ******* SPACEUSAGE-1 ended ******* CC = 04
DDDETAIL
1File options (from FCB):
------------------------
Date / Time Loaded ..................... 2011-09-27 11:20:10.24
Date / Time of last update ............. 2011-10-21 12:17:55.72
Date / Time of last physical restructure 2011-09-27 11:20:10.24
ISN Reusage ............................ No
DATA Storage Reusage ................... Yes
MIXDSDEV ............................... No
Spanned Records Support ................ No
Index compressed ....................... No
2-Byte MU/PE Index ..................... No
Highest Index Level .................... 3
LOB fields ............................. No
LOB file ............................... No
Expanded ............................... Yes. Seq.number = 1. ANCHOR = 22
I/////////////////////////////////////////////////////////////////I
II II
II ASSOCIATOR DETAIL REPORT OF NORMAL INDEX FOR FILE 22 II
II II
I/////////////////////////////////////////////////////////////////I
Device Type ........... 3390
Block Size ............. 2544
ASSO Padding Factor .... 10% (254 bytes)
1File 22 Page 1
---------------------------------------------------------------------
I RABN I % I Block I Free Space I Num I Element lengths I
I I Used I length I------------I elem I-----------------I
I I I I Gap I Pad I I Min I Max I Avg I
I----------I---------I--------I-----I------I------I-----I-----I-----I
2151 50 1277 1013 254 98 13 13 13
2152 28 719 1571 254 47 8 35 15
2153 34 873 1417 254 96 9 12 9
2154 14 353 1937 254 6 10 128 58
2155 19 481 1809 254 23 11 35 20
2156 42 1074 1216 254 42 11 57 25
2157 19 484 1806 254 5 11 293 96
2158 21 543 1747 254 41 9 33 13
2159 21 532 1758 254 47 8 29 11
2160 14 351 1939 254 9 9 78 38
2161 67 1703 587 254 93 14 25 18
2162 90 2277 13 254 121 18 33 18
2163 87 2205 85 254 115 18 30 19
2164 17 435 1855 254 24 18 18 18
I/////////////////////////////////////////////////////////////////I
II II
II DATA STORAGE DETAIL REPORT FOR FILE 22 II
II II
I/////////////////////////////////////////////////////////////////I
Device Type ........... 3390
Block Size ............. 5064
DATA Padding Factor .... 10% (506 bytes)
1File 22 Page 1
-------------------------------------------------------------------------------
I RABN I % I Block I Free space I Num I Spanned I Record lengths I
I I Used I Length I------------I Rec I-----------I-----------------I
I I I I Gap I Pad I I Num I Flg I Min I Max I Avg I
I----------I--------I--------I-----I------I-----I-----I-----I-----I-----I-----I
5382 80 4057 501 506 24 0 126 208 168
5383 95 4821 0 243 30 0 136 189 160
5384 88 4469 89 506 26 0 143 201 171
5385 63 3207 1351 506 18 0 153 205 177
1File options (from FCB):
------------------------
Date / Time Loaded ..................... 2011-09-27 11:20:20.72
Date / Time of last update ............. 2011-09-27 11:39:24.72
Date / Time of last physical restructure 2011-09-27 11:20:20.72
ISN Reusage ............................ No
DATA Storage Reusage ................... Yes
MIXDSDEV ............................... No
Spanned Records Support ................ No
Index compressed ....................... No
2-Byte MU/PE Index ..................... No
Highest Index Level .................... 3
LOB fields ............................. No
LOB file ............................... No
Expanded ............................... Yes. Seq.number = 2. ANCHOR = 22
I/////////////////////////////////////////////////////////////////I
II II
II ASSOCIATOR DETAIL REPORT OF NORMAL INDEX FOR FILE 20 II
II II
I/////////////////////////////////////////////////////////////////I
Device Type ........... 3390
Block Size ............. 2544
ASSO Padding Factor .... 10% (254 bytes)
1File 20 Page 1
---------------------------------------------------------------------
I RABN I % I Block I Free Space I Num I Element lengths I
I I Used I length I------------I elem I-----------------I
I I I I Gap I Pad I I Min I Max I Avg I
I----------I---------I--------I-----I------I------I-----I-----I-----I
2188 51 1303 987 254 100 13 13 13
2189 29 739 1551 254 48 8 35 15
2190 35 891 1399 254 98 9 12 9
2191 14 359 1931 254 6 10 128 59
2192 19 487 1803 254 23 11 35 21
2193 42 1080 1210 254 42 11 57 25
2194 20 505 1785 254 5 11 299 100
2195 22 555 1735 254 42 9 33 13
2196 21 543 1747 254 48 8 29 11
2197 14 357 1933 254 9 9 78 39
2198 68 1742 548 254 95 14 25 18
2199 90 2277 13 254 121 18 33 18
2200 90 2283 7 254 119 18 30 19
2201 17 435 1855 254 24 18 18 18
I/////////////////////////////////////////////////////////////////I
II II
II DATA STORAGE DETAIL REPORT FOR FILE 20 II
II II
I/////////////////////////////////////////////////////////////////I
Device Type ........... 3390
Block Size ............. 5064
DATA Padding Factor .... 10% (506 bytes)
1File 20 Page 1
-------------------------------------------------------------------------------
I RABN I % I Block I Free space I Num I Spanned I Record lengths I
I I Used I Length I------------I Rec I-----------I-----------------I
I I I I Gap I Pad I I Num I Flg I Min I Max I Avg I
I----------I--------I--------I-----I------I-----I-----I-----I-----I-----I-----I
5402 87 4415 143 506 26 0 126 208 169
5403 95 4821 0 243 30 0 136 189 160
5404 88 4469 89 506 26 0 143 201 171
5405 63 3207 1351 506 18 0 153 205 177
1File options (from FCB):
------------------------
Date / Time Loaded ..................... 2011-09-27 11:20:36.45
Date / Time of last update ............. 2011-10-04 07:05:44.83
Date / Time of last physical restructure 2011-09-27 11:20:36.45
ISN Reusage ............................ No
DATA Storage Reusage ................... Yes
MIXDSDEV ............................... No
Spanned Records Support ................ No
Index compressed ....................... No
2-Byte MU/PE Index ..................... No
Highest Index Level .................... 3
LOB fields ............................. No
LOB file ............................... No
Expanded ............................... Yes. Seq.number = 3. ANCHOR = 22
I/////////////////////////////////////////////////////////////////I
II II
II ASSOCIATOR DETAIL REPORT OF NORMAL INDEX FOR FILE 13 II
II II
I/////////////////////////////////////////////////////////////////I
Device Type ........... 3390
Block Size ............. 2544
ASSO Padding Factor .... 10% (254 bytes)
1File 13 Page 1
---------------------------------------------------------------------
I RABN I % I Block I Free Space I Num I Element lengths I
I I Used I length I------------I elem I-----------------I
I I I I Gap I Pad I I Min I Max I Avg I
I----------I---------I--------I-----I------I------I-----I-----I-----I
3761 3 74 2216 254 6 6 13 11
3762 1 24 2266 254 1 21 21 21
3763 1 26 2264 254 1 23 23 23
3764 1 18 2272 254 1 15 15 15
3765 1 18 2272 254 1 15 15 15
3766 6 142 2148 254 17 8 11 8
3767 1 12 2278 254 1 9 9 9
3768 1 18 2272 254 1 15 15 15
I/////////////////////////////////////////////////////////////////I
II II
II DATA STORAGE DETAIL REPORT FOR FILE 13 II
II II
I/////////////////////////////////////////////////////////////////I
Device Type ........... 3390
Block Size ............. 5064
DATA Padding Factor .... 10% (506 bytes)
1File 13 Page 1
-------------------------------------------------------------------------------
I RABN I % I Block I Free space I Num I Spanned I Record lengths I
I I Used I Length I------------I Rec I-----------I-----------------I
I I I I Gap I Pad I I Num I Flg I Min I Max I Avg I
I----------I--------I--------I-----I------I-----I-----I-----I-----I-----I-----I
9523 6 288 4270 506 6 0 31 71 47
This sample shows ADADRU SPACEUSAGE processing of the OUTPUT parameter. It shows summary and detail ASSO and DATA space usage on file 10 (EMPLOYEES) in XML format.
<?xml version="1.0" encoding="ISO-8859-1"?>
<?xml-stylesheet type="text/xsl" href="adadru_summary.xsl"?>
<AdadruSummary>
<RunTime>
<DBID>192</DBID>
<VER>8</VER>
<Release>3</Release>
<SM>8</SM>
<Date>2013-04-17</Date>
<Time>10:30:07</Time>
</RunTime>
<SpaceUsage>
<SpaceUsageNum>1</SpaceUsageNum>
<File>
<Number>10</Number>
<FileName>EMPL-192</FileName>
<ConsolidatedParameters>
<ErrLimit>1</ErrLimit>
<LOBGroup>No</LOBGroup>
<ExpGroup>No</ExpGroup>
<XML>XML</XML>
<ACODE>No</ACODE>
<AssoParameters>
<Report>SUMMARY + DETAIL</Report>
<SAMPLING>100 (10 of every 10 records read)</SAMPLING>
<INCRUSAGE>5</INCRUSAGE>
<INCRNUMREC>Auto</INCRNUMREC>
<RABN>
<FROMRABN>3700</FROMRABN>
<TORABN>3749</TORABN>
</RABN>
<RABN>
<FROMRABN>3780</FROMRABN>
<TORABN>3786</TORABN>
</RABN>
</AssoParameters>
<DataParameters>
<Report>SUMMARY + DETAIL</Report>
<SAMPLING>100 (10 of every 10 records read)</SAMPLING>
<INCRUSAGE>5</INCRUSAGE>
<INCRNUMREC>Auto</INCRNUMREC>
<INCRRECLEN>Auto</INCRRECLEN>
<RABN>
<FROMRABN>7079</FROMRABN>
<TORABN>7122</TORABN>
</RABN>
</DataParameters>
</ConsolidatedParameters>
<FileOptions>
<DateLoaded>2013-03-11</DateLoaded>
<TimeLoaded>12:01:05.21</TimeLoaded>
<DateUpdated>n/a</DateUpdated>
<TimeUpdated>n/a</TimeUpdated>
<DateRestructured>2013-03-11</DateRestructured>
<TimeRestructured>12:01:05.21</TimeRestructured>
<ISNReusage>Yes</ISNReusage>
<DSReusage>Yes</DSReusage>
<MixDSDev>No</MixDSDev>
<Spanned>No</Spanned>
<IndexCompressed>No</IndexCompressed>
<TwoByteIndex>No</TwoByteIndex>
<HighestIndexLevel>3</HighestIndexLevel>
<LOBFields>No</LOBFields>
<LOBFile>No</LOBFile>
<Expanded>No</Expanded>
</FileOptions>
<AssoSummaryReport>
<NILayout>
<PhysicalLayout>
<Type>NI</Type>
<FromRABN>3700</FromRABN>
<ToRABN>3749</ToRABN>
<UnusedBlocks>0</UnusedBlocks>
<Device>3390</Device>
</PhysicalLayout>
<PhysicalLayout>
<Type>NI</Type>
<FromRABN>3780</FromRABN>
<ToRABN>3879</ToRABN>
<UnusedBlocks>93</UnusedBlocks>
<Device>3390</Device>
</PhysicalLayout>
<ProcessingLayout>
<Type>NI</Type>
<FromRABN>3700</FromRABN>
<ToRABN>3749</ToRABN>
</ProcessingLayout>
<ProcessingLayout>
<Type>NI</Type>
<FromRABN>3780</FromRABN>
<ToRABN>3786</ToRABN>
</ProcessingLayout>
</NILayout>
<Device>
<DeviceType>3390</DeviceType>
<BlockSize>2544</BlockSize>
<PaddingSpace>127</PaddingSpace>
<PaddingFactor>5%</PaddingFactor>
<NumberOfAllocatedBlocks>150</NumberOfAllocatedBlocks>
<NumberOfUsedblocks>57</NumberOfUsedblocks>
<BlocksRead>
<Sampling>100%</Sampling>
<Number>57</Number>
</BlocksRead>
<NumberOfUnusedBlocksAtTheEnd>93</NumberOfUnusedBlocksAtTheEnd>
<NumberOfUnusedBlocksIntheMiddle>0</NumberOfUnusedBlocksIntheMiddle>
<FreeSpaceLessThenPadding>0</FreeSpaceLessThenPadding>
<AveragePercentOfBlockFilling>86</AveragePercentOfBlockFilling>
<NumberOfElementsRead>7071</NumberOfElementsRead>
<AverageNumberOfElementsPerBlock>124</AverageNumberOfElementsPerBlock>
<AverageElementLength>17</AverageElementLength>
<MinimumElementLength>7</MinimumElementLength>
<MaximumElementLength>2070</MaximumElementLength>
<NumberOfMinLengthElements>1</NumberOfMinLengthElements>
<NumberOfMaxLengthElements>1</NumberOfMaxLengthElements>
<DistributionReports>
<BlockFillingLevel>
<Increment>5%</Increment>
<FilledSpace>
<PercentRange>
<From>1</From>
<To>5</To>
</PercentRange>
<NumberOfBlocks>2</NumberOfBlocks>
</FilledSpace>
<FilledSpace>
<PercentRange>
<From>26</From>
<To>30</To>
</PercentRange>
<NumberOfBlocks>1</NumberOfBlocks>
</FilledSpace>
<FreeSpace>
<PercentRange>
<From>1</From>
<To>5</To>
</PercentRange>
<NumberOfBlocks>41</NumberOfBlocks>
</FreeSpace>
<FreeSpace>
<PercentRange>
<From>6</From>
<To>10</To>
</PercentRange>
<NumberOfBlocks>6</NumberOfBlocks>
</FreeSpace>
<FreeSpace>
<PercentRange>
<From>11</From>
<To>15</To>
</PercentRange>
<NumberOfBlocks>1</NumberOfBlocks>
</FreeSpace>
<FreeSpace>
<PercentRange>
<From>16</From>
<To>20</To>
</PercentRange>
<NumberOfBlocks>2</NumberOfBlocks>
</FreeSpace>
</BlockFillingLevel>
<ElementsPerBlock>
<Increment>Auto</Increment>
<Elements>
<ElementsRange>
<From>1</From>
<To>3</To>
</ElementsRange>
<NumberOfBlocks>1</NumberOfBlocks>
</Elements>
<Elements>
<ElementsRange>
<From>4</From>
<To>6</To>
</ElementsRange>
<NumberOfBlocks>3</NumberOfBlocks>
</Elements>
<Elements>
<ElementsRange>
<From>7</From>
<To>9</To>
</ElementsRange>
<NumberOfBlocks>3</NumberOfBlocks>
</Elements>
<Elements>
<ElementsRange>
<From>61</From>
<To>63</To>
</ElementsRange>
<NumberOfBlocks>1</NumberOfBlocks>
</Elements>
<Elements>
<ElementsRange>
<From>64</From>
<To>66</To>
</ElementsRange>
<NumberOfBlocks>1</NumberOfBlocks>
</Elements>
<Elements>
<ElementsRange>
<From>70</From>
<To>72</To>
</ElementsRange>
<NumberOfBlocks>2</NumberOfBlocks>
</Elements>
<Elements>
<ElementsRange>
<From>73</From>
<To>75</To>
</ElementsRange>
<NumberOfBlocks>1</NumberOfBlocks>
</Elements>
<Elements>
<ElementsRange>
<From>79</From>
<To>81</To>
</ElementsRange>
<NumberOfBlocks>1</NumberOfBlocks>
</Elements>
<Elements>
<ElementsRange>
<From>85</From>
<To>87</To>
</ElementsRange>
<NumberOfBlocks>1</NumberOfBlocks>
</Elements>
<Elements>
<ElementsRange>
<From>88</From>
<To>90</To>
</ElementsRange>
<NumberOfBlocks>1</NumberOfBlocks>
</Elements>
<Elements>
<ElementsRange>
<From>91</From>
<To>93</To>
</ElementsRange>
<NumberOfBlocks>1</NumberOfBlocks>
</Elements>
<Elements>
<ElementsRange>
<From>103</From>
<To>105</To>
</ElementsRange>
<NumberOfBlocks>1</NumberOfBlocks>
</Elements>
<Elements>
<ElementsRange>
<From>106</From>
<To>108</To>
</ElementsRange>
<NumberOfBlocks>2</NumberOfBlocks>
</Elements>
<Elements>
<ElementsRange>
<From>109</From>
<To>111</To>
</ElementsRange>
<NumberOfBlocks>2</NumberOfBlocks>
</Elements>
<Elements>
<ElementsRange>
<From>115</From>
<To>117</To>
</ElementsRange>
<NumberOfBlocks>3</NumberOfBlocks>
</Elements>
<Elements>
<ElementsRange>
<From>118</From>
<To>120</To>
</ElementsRange>
<NumberOfBlocks>2</NumberOfBlocks>
</Elements>
<Elements>
<ElementsRange>
<From>121</From>
<To>123</To>
</ElementsRange>
<NumberOfBlocks>1</NumberOfBlocks>
</Elements>
<Elements>
<ElementsRange>
<From>124</From>
<To>126</To>
</ElementsRange>
<NumberOfBlocks>2</NumberOfBlocks>
</Elements>
<Elements>
<ElementsRange>
<From>127</From>
<To>129</To>
</ElementsRange>
<NumberOfBlocks>2</NumberOfBlocks>
</Elements>
<Elements>
<ElementsRange>
<From>130</From>
<To>132</To>
</ElementsRange>
<NumberOfBlocks>2</NumberOfBlocks>
</Elements>
<Elements>
<ElementsRange>
<From>133</From>
<To>135</To>
</ElementsRange>
<NumberOfBlocks>6</NumberOfBlocks>
</Elements>
<Elements>
<ElementsRange>
<From>136</From>
<To>138</To>
</ElementsRange>
<NumberOfBlocks>1</NumberOfBlocks>
</Elements>
<Elements>
<ElementsRange>
<From>139</From>
<To>141</To>
</ElementsRange>
<NumberOfBlocks>1</NumberOfBlocks>
</Elements>
<Elements>
<ElementsRange>
<From>154</From>
<To>156</To>
</ElementsRange>
<NumberOfBlocks>1</NumberOfBlocks>
</Elements>
<Elements>
<ElementsRange>
<From>178</From>
<To>180</To>
</ElementsRange>
<NumberOfBlocks>1</NumberOfBlocks>
</Elements>
<Elements>
<ElementsRange>
<From>181</From>
<To>183</To>
</ElementsRange>
<NumberOfBlocks>1</NumberOfBlocks>
</Elements>
<Elements>
<ElementsRange>
<From>184</From>
<To>186</To>
</ElementsRange>
<NumberOfBlocks>6</NumberOfBlocks>
</Elements>
<Elements>
<ElementsRange>
<From>187</From>
<To>189</To>
</ElementsRange>
<NumberOfBlocks>1</NumberOfBlocks>
</Elements>
<Elements>
<ElementsRange>
<From>190</From>
<To>192</To>
</ElementsRange>
<NumberOfBlocks>1</NumberOfBlocks>
</Elements>
<Elements>
<ElementsRange>
<From>232</From>
<To>234</To>
</ElementsRange>
<NumberOfBlocks>2</NumberOfBlocks>
</Elements>
<Elements>
<ElementsRange>
<From>250</From>
<To>252</To>
</ElementsRange>
<NumberOfBlocks>1</NumberOfBlocks>
</Elements>
<Elements>
<ElementsRange>
<From>253</From>
<To>255</To>
</ElementsRange>
<NumberOfBlocks>1</NumberOfBlocks>
</Elements>
<Elements>
<ElementsRange>
<From>259</From>
<To>261</To>
</ElementsRange>
<NumberOfBlocks>1</NumberOfBlocks>
</Elements>
</ElementsPerBlock>
</DistributionReports>
</Device>
<DataSummaryReport>
<DataLayout>
<PhysicalLayout>
<Type>DS</Type>
<FromRABN>7079</FromRABN>
<ToRABN>7228</ToRABN>
<UnusedBlocks>71</UnusedBlocks>
<Device>3390</Device>
</PhysicalLayout>
<ProcessingLayout>
<Type>DS</Type>
<FromRABN>7079</FromRABN>
<ToRABN>7122</ToRABN>
</ProcessingLayout>
</DataLayout>
<Device>
<DeviceType>3390</DeviceType>
<BlockSize>5064</BlockSize>
<PaddingSpace>253</PaddingSpace>
<PaddingFactor>5%</PaddingFactor>
<NumberOfAllocatedBlocks>150</NumberOfAllocatedBlocks>
<NumberOfUsedblocks>44</NumberOfUsedblocks>
<BlocksRead>
<Sampling>100%</Sampling>
<Number>44</Number>
</BlocksRead>
<NumberOfUnusedBlocksAtTheEnd>106</NumberOfUnusedBlocksAtTheEnd>
<NumberOfUnusedBlocksIntheMiddle>0</NumberOfUnusedBlocksIntheMiddle>
<FreeSpaceLessThenPadding>50</FreeSpaceLessThenPadding>
<AveragePercentOfBlockFilling>93</AveragePercentOfBlockFilling>
<Records>
<TotalNumberOfRecords>1107</TotalNumberOfRecords>
<NormalRecords>1107</NormalRecords>
<SpannedRecords>n/a</SpannedRecords>
</Records>
<NumberOfBlocksWithSpanned>n/a</NumberOfBlocksWithSpanned>
<AverageNumberOfRecordsPerBlock>25</AverageNumberOfRecordsPerBlock>
<NormalRecords>
<AverageRecordLength>188</AverageRecordLength>
<MinRecordLength>126</MinRecordLength>
<MaxRecordLength>253</MaxRecordLength>
<NumberOfMinLengthRecords>1</NumberOfMinLengthRecords>
<NumberOfMaxLengthRecords>1</NumberOfMaxLengthRecords>
</NormalRecords>
<DistributionReports>
<BlockFillingLevel>
<Increment>5%</Increment>
<FilledSpace>
<PercentRange>
<From>26</From>
<To>30</To>
</PercentRange>
<NumberOfBlocks>1</NumberOfBlocks>
</FilledSpace>
<FreeSpace>
<PercentRange>
<From>1</From>
<To>5</To>
</PercentRange>
<NumberOfBlocks>27</NumberOfBlocks>
</FreeSpace>
<FreeSpace>
<PercentRange>
<From>6</From>
<To>10</To>
</PercentRange>
<NumberOfBlocks>16</NumberOfBlocks>
</FreeSpace>
</BlockFillingLevel>
<RecordsPerBlock>
<Increment>Auto</Increment>
<Records>
<RecordsRange>
<From>7</From>
<To>12</To>
</RecordsRange>
<NumberOfBlocks>1</NumberOfBlocks>
</Records>
<Records>
<RecordsRange>
<From>19</From>
<To>24</To>
</RecordsRange>
<NumberOfBlocks>17</NumberOfBlocks>
</Records>
<Records>
<RecordsRange>
<From>25</From>
<To>30</To>
</RecordsRange>
<NumberOfBlocks>22</NumberOfBlocks>
</Records>
<Records>
<RecordsRange>
<From>31</From>
<To>36</To>
</RecordsRange>
<NumberOfBlocks>4</NumberOfBlocks>
</Records>
</RecordsPerBlock>
<NormalRecordLength>
<Increment>Auto</Increment>
<Lengths>
<LengthsRange>
<From>97</From>
<To>132</To>
</LengthsRange>
<NumberOfRecords>5</NumberOfRecords>
</Lengths>
<Lengths>
<LengthsRange>
<From>133</From>
<To>138</To>
</LengthsRange>
<NumberOfRecords>8</NumberOfRecords>
</Lengths>
<Lengths>
<LengthsRange>
<From>139</From>
<To>144</To>
</LengthsRange>
<NumberOfRecords>20</NumberOfRecords>
</Lengths>
<Lengths>
<LengthsRange>
<From>145</From>
<To>150</To>
</LengthsRange>
<NumberOfRecords>60</NumberOfRecords>
</Lengths>
<Lengths>
<LengthsRange>
<From>151</From>
<To>156</To>
</LengthsRange>
<NumberOfRecords>99</NumberOfRecords>
</Lengths>
<Lengths>
<LengthsRange>
<From>157</From>
<To>162</To>
</LengthsRange>
<NumberOfRecords>86</NumberOfRecords>
</Lengths>
<Lengths>
<LengthsRange>
<From>163</From>
<To>168</To>
</LengthsRange>
<NumberOfRecords>84</NumberOfRecords>
</Lengths>
<Lengths>
<LengthsRange>
<From>169</From>
<To>174</To>
</LengthsRange>
<NumberOfRecords>60</NumberOfRecords>
</Lengths>
<Lengths>
<LengthsRange>
<From>175</From>
<To>180</To>
</LengthsRange>
<NumberOfRecords>63</NumberOfRecords>
</Lengths>
<Lengths>
<LengthsRange>
<From>181</From>
<To>186</To>
</LengthsRange>
<NumberOfRecords>70</NumberOfRecords>
</Lengths>
<Lengths>
<LengthsRange>
<From>187</From>
<To>192</To>
</LengthsRange>
<NumberOfRecords>61</NumberOfRecords>
</Lengths>
<Lengths>
<LengthsRange>
<From>193</From>
<To>198</To>
</LengthsRange>
<NumberOfRecords>59</NumberOfRecords>
</Lengths>
<Lengths>
<LengthsRange>
<From>199</From>
<To>204</To>
</LengthsRange>
<NumberOfRecords>55</NumberOfRecords>
</Lengths>
<Lengths>
<LengthsRange>
<From>205</From>
<To>210</To>
</LengthsRange>
<NumberOfRecords>63</NumberOfRecords>
</Lengths>
<Lengths>
<LengthsRange>
<From>211</From>
<To>216</To>
</LengthsRange>
<NumberOfRecords>89</NumberOfRecords>
</Lengths>
<Lengths>
<LengthsRange>
<From>217</From>
<To>222</To>
</LengthsRange>
<NumberOfRecords>79</NumberOfRecords>
</Lengths>
<Lengths>
<LengthsRange>
<From>223</From>
<To>228</To>
</LengthsRange>
<NumberOfRecords>58</NumberOfRecords>
</Lengths>
<Lengths>
<LengthsRange>
<From>229</From>
<To>234</To>
</LengthsRange>
<NumberOfRecords>41</NumberOfRecords>
</Lengths>
<Lengths>
<LengthsRange>
<From>235</From>
<To>240</To>
</LengthsRange>
<NumberOfRecords>28</NumberOfRecords>
</Lengths>
<Lengths>
<LengthsRange>
<From>241</From>
<To>246</To>
</LengthsRange>
<NumberOfRecords>16</NumberOfRecords>
</Lengths>
<Lengths>
<LengthsRange>
<From>247</From>
<To>342</To>
</LengthsRange>
<NumberOfRecords>3</NumberOfRecords>
</Lengths>
</NormalRecordLength>
</DistributionReports>
</Device>
</DataSummaryReport>
</File>
<StatisticalReport>
<File>
<FileNumber>10</FileNumber>
<Duration>00:00:00.05</Duration>
<Asso>
<NumberOfBlocksRead>57</NumberOfBlocksRead>
<ReadErrors>0</ReadErrors>
<Extents>
<FCB>2</FCB>
<Run>2</Run>
</Extents>
</Asso>
<Data>
<NumberOfBlocksRead>44</NumberOfBlocksRead>
<ReadErrors>0</ReadErrors>
<Extents>
<FCB>1</FCB>
<Run>1</Run>
</Extents>
</Data>
<Errors>
<Parm>0</Parm>
<Run>0</Run>
</Errors>
<Warnings>
<Parm>0</Parm>
<Run>0</Run>
</Warnings>
</File>
</AdadruSummary>
Detail:
<?xml version="1.0" encoding="ISO-8859-1"?>
<?xml-stylesheet type="text/xsl" href="adadru_detail.xsl"?>
<AdadruDetail>
<RunTime>
<DBID>192</DBID>
<VER>8</VER>
<Release>3</Release>
<SM>8</SM>
<Date>2013-04-17</Date>
<Time>10:30:07</Time>
</RunTime>
<SpaceUsage>
<SpaceUsageNum>1</SpaceUsageNum>
<File>
<Number>10</Number>
<FileName>EMPL-192</FileName>
<FileOptions>
<DateLoaded>2013-03-11</DateLoaded>
<TimeLoaded>12:01:05.21</TimeLoaded>
<DateUpdated>n/a</DateUpdated>
<TimeUpdated>n/a</TimeUpdated>
<DateRestructured>2013-03-11</DateRestructured>
<TimeRestructured>12:01:05.21</TimeRestructured>
<ISNReusage>Yes</ISNReusage>
<DSReusage>Yes</DSReusage>
<MixDSDev>No</MixDSDev>
<Spanned>No</Spanned>
<IndexCompressed>No</IndexCompressed>
<TwoByteIndex>No</TwoByteIndex>
<HighestIndexLevel>3</HighestIndexLevel>
<LOBFields>No</LOBFields>
<LOBFile>No</LOBFile>
<Expanded>No</Expanded>
</FileOptions>
<AssoDetailReport>
</AssoDetailReport>
<DataDetailReport>
</DataDetailReport>
</File>
</SpaceUsage>
</AdadruDetail>