compress record using Unload-Reload

Document ID : KB000013584
Last Modified Date : 14/02/2018
Show Technical Document Details
Question:

I did a search and the doc says to use restructure to add database compression.

It also says that unload reload is an option.

Is unload/reload an option? We may want to change the area's characteristics depending on how much space we save.

Answer:

Yes, Unload-Reload can be used to compress the record. The new subschema specified in the unload and reload jobs would specify the new subschema with the compression defined.

If using the IDMSCOMP/IDMSDCOM compression calls remember:

If any record in the area uses IDMSCOMP and IDMSDCOM for compression and decompression, the area should have the following database procedure specifications:

call idmscomp before finish

call idmsdcom before finish

 

This ensures that the work areas used by the compression and decompression routines are freed when a rununit terminates.