Brian,
Can you possibly create partitions of data?
For instance, take your primary key and run it thru IDMSCALC with a page range of, say 1 to 10.
Take the resulting “page” and translate that into, for instance, a DBName with the single digit on the end representing a partition. (IE, ABC0, ABC1, ABC2, … ABC9).
Then take your data and split it up, yes, you’ll need a onetime program for this, into the 10 partitions.
Then, once stored with a specific key, it will always be addressable in a specific partition.
There would be more to it than this, but this is just a high level.
Your partition/area relationship could be by area name or page group or both.
Chuck
Charles (Chuck) Hardee<mailto:Chuck.Hardee@ThermoFisher.com>
Senior Systems Engineer/Database Administration
EAS Information Technology<mailto:DBA%20Engineering%20-%20DB2_IDMS>
Thermo Fisher Scientific
300 Industry Drive | Pittsburgh, PA 15275
Phone +1 (724) 517-2633 | Mobile +1 (412) 877-2809 | FAX: +1 (412) 490-9230
Chuck.Hardee@ThermoFisher.com<mailto:Chuck.Hardee@ThermoFisher.com> | www.thermofisher.com
WORLDWIDE CONFIDENTIALITY NOTE: Dissemination, distribution or copying of this e-mail or the information herein by anyone other than the intended recipient, or an employee or agent of a system responsible for delivering the message to the intended recipient, is prohibited. If you are not the intended recipient, please inform the sender and delete all copies.