OCM mapping

We purged some our larger tables (F0911/f4111/F4211 etc.) to an archive library on the iSeries. Our users now want to be able to access the archived data in JDE in a read only mode. We want the archived JDE environment to use the archived tables from archived library but other tables (customer master/UDCs etc from the Production environment). Is it possible to create this archived JDE environment using OCM mapping where it pulls certain tables from a different library?

Thanks,
Matt
One World XE,SP23.1, iSeries V6r1

Hi Matt,

Yes absolutely. This is how most archiving solutions for JDE configure their "Archive" Environment.

Basically create a copy of your existing Prod environment's mappings for the new archive environment and then just add mappings for the specific tables that you want to point to the archive datasource.

Now there are some considerations to take when you have business views that go over master and detail tables and they are all not in the same datasource.

JDE has a limitation that the number of tables in a cross datasource join cannot be more than two. A very common business view used is F0901 , F0006 and F0911. In this case you might have the two masters F0901 and F0006 in your Production Data Datasource and F0911 in your Archive datasource. JDE will not be able to fetch from this business view in this case.

For master tables that are in such joins , what you can do is one of the two

- copy these masters also to the archive datasource and add OCM mappings ( and periodically refresh them)
- create a view (logical file) in the archive library pointing to the physical table in the Production Data library and add OCM mappings.

There are some other ways too to handle cross datasource join limitations , but the above should give you a general idea on how to proceed.

Thanks for your help!!