RELOAD with PARTITION result in PARTITION KEYWORD INVALID? Why?
search cancel

RELOAD with PARTITION result in PARTITION KEYWORD INVALID? Why?

book

Article ID: 16910

calendar_today

Updated On:

Products

Database Analyzer (IMS Tools) Mainframe Configuration Manager for IMS for z/OS IMS TOOLS - MISC Compress Data Compression (IMS Tools) Database Analyzer for IMS for z/OS Database Copier for IMS for z/OS Database Organizer for IMS for z/OS Mainframe Extended Terminal Manager (IMS Tools) High Performance Recovery for IMS for z/OS Database Organizer (IMS Tools) Mainframe Program Restart Manager for IMS for z/OS Secondary Index Builder for IMS for z/OS Secondary Index for IMS for z/OS

Issue/Introduction



When you UNLOAD an entire HALDB database and the ran an RELOAD with PARTITION specified it result in a warning message "PARTITION KEYWORD INVALID"

Why does CA Database Organizer job fail? 

Environment

Release:
Component: DBO

Resolution

The CA Database Organizer reload of a HALDB was designed to be driven by what is in the unload file. If it finds records for all the partitions, those partitions are cleared to empty and the records are reloaded in them. If it finds records for a subset of partitions, those partitions are cleared to empty and the records are reloaded into them.

The reload process is driven by the records found in the unload file. The PARTITION keyword has no effect on the reload process. The assumption is that one or more partitions were unloaded and those are the ones to be reloaded. If the entire database was unloaded, reload will use unload file and all the partitions will be reloaded.

RELOAD is combined with the keywords PARTITION and/or NUMBEROFPARTS, it will give a warning message “PARTITION KEYWORD INVALID” but did not change the Return Code.