How to use CA Fast Load to load discarded rows from a Reorg utility?

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

Description:

How should table data rows be loaded back to DB2 after they have been removed by a Reorg utility as discards?

CA Rapid Reorg® for DB2 for z/OS and IBM Reorg both have the facility to write discarded records to a dataset to effectively remove them from the table during the Reorg.

This can be done with ROW-PROCESSING SELECT or DELETE in the CA Rapid Reorg® for DB2 for z/OS utility.

CA Rapid Reorg writes discarded records to either a DISCARDDN DD of your choice or to the SYSDISC DD if specified.

This process may be used as a means of archiving old data by conveniently removing rows at reorg time. These rows could then be loaded to an archive database for alternate access or used in some other way for testing or loaded to a data warehouse.

Solution:

CA Rapid Reorg Row Processing writes deleted or not-selected rows to the SYSDISC DD in a DB2 UNLOAD format.

Reloading data discarded by CA Rapid Reorg

If the discard records were written by CA Rapid Reorg, a CA Fast Load utility would use INPUT-FORMAT UNLOAD to load these rows from the discard dataset.

Reloading data discarded by IBM Reorg

If the discard records were written by IBM Reorg a CA Fast Load utility would use INPUT-FORMAT SEQ to load these rows from the discard dataset specifying definitions of all the columns accordingly.

Generate the correct load cards

CA Fast Unload has the facility to produce load cards with a LOAD-CONTROL FASTLOAD ONLY with OUTPUT-FORMAT LOAD and a SYSCTL01 DD allocated to provide the correct load control cards.

LOAD-CONTROL ONLY does not unload any data. It just writes the load cards into the CTLDDN DD. These can then be copied into the Load JCL.

Specific information can be found in the product User Guides for CA Rapid Reorg® for DB2 for z/OS , CA Fast Load® for DB2 for z/OS and IBM REORG.