SPACEUSAGE: Database File Space Usage

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.


SPACEUSAGE File Group Processing

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:

SAMPLING Parameter Consolidation

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".

INCRUSAGE Parameter Consolidation

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".

INCRNUMREC/INCRRECLEN Parameter Consolidation

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".

FROMRABN/TORABN Parameter Consolidation

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.

DETAIL/SUMMARY Parameter Consolidation

If SUMMARY and DETAIL values are specified differently for the same file in different file groups, both parameters are used for the report.

LOBGROUP/EXPGROUP Parameter Consolidation

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.

Consolidation Example

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

Syntax

graphics/adadru_spaceusage.png

This section describes the syntax and parameters of the SPACEUSAGE function.

Essential Parameters

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.

Optional Parameters and Subparameters

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-5 

When 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,18

Overlapping or repeated file numbers are allowed. The following example is a valid specification:

FILE=2-8,1-4,5,6-11

In 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.

Examples

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.

Sample Reports

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.

Sample 1: Parameter Consolidation for Files

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                                          
                                                                                                                         
  

Sample 2: Large Object (LOB) File Processing

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

Sample 3: SAMPLING Parameter Use

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

Sample 4: FILE Parameter Processing

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

Sample 5: EXPGROUP Parameter Processing

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

Sample 6: XML Output for Detail and Summary Report

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>