Skip to Content
Information
Limited support BMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see UNLOAD PLUS for DB2 13.1.

FILESZPCT

Use FILESZPCT to specify the amount by which you want UNLOAD PLUS to adjust the total calculated space for the data sets that this OUTPUT statement describes when automatically sizing data sets.

FILESZPCT.png

The value can range from 1 through 999. Values from 1 to 99 indicate a reduction in file size. Values from 101 to 999 indicate an increase in file size. A value of 100 indicates no change in the file size.

UNLOAD PLUS uses the following formula to calculate the resulting total file size:

 resultantFileSize = ROUND (calculatedFileSize * FILESZPCT/100)

Additional considerations

The following considerations apply to the FILESZPCT option:

  • UNLOAD PLUS ignores this option for referenced files.
  • If you specify a value for the primary and secondary allocations for the SPACE command option, UNLOAD PLUS uses the SPACE value and ignores the value you specify for FILESZPCT.
  • UNLOAD PLUS uses the value calculated by FILESZPCT as the total size (in kilobytes) of the data set before it calculates the primary and secondary space values specified by the PCTPRIM, NBRSECD, and MAXSECD options.

Specifying the default

You can specify the default for the FILESZPCT command option in your installation options module by using the FILESZPCT installation option. UNLOAD PLUS was shipped with a default value of 100 for this option. The command option overrides the default that is in the installation options module.

Related topic

Disk-options-for-the-OUTPUT-command

 

 

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

UNLOAD PLUS for DB2 11.2