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>