CMOD Extraction of data

[Glenn]

If I want to extract data from an older mainframe CMOD environment and ingest it onto a newer CMOD linux system, how can I do it and does the retention from the old system have to be followed when loading the data onto the new CMOD environment?

[Nolan]

That is a pretty tall order there Glenn.

Extracting data from CMOD on Z/OS is a standard arsdoc query and then arsdoc get...for every single report.
Transfer it using your internal mechanisms for file transfers between Z/OS and your Linux server. (be careful of EBCIDIC data moving to Linux)
Loading it in to Linux would be an arsload or using a daemon depending on your setup.

Retention does not follow the data, you would need to define it in the new Linux CMOD database. 

To complete this, I would recommend REXX scripts on Z/OS to automate the extraction, JCLs to control and transfer the files and the shell scripts to load.  (all run in the same JCLs)

[Ed_Arnold]

Or maybe instead of worrying about file transfers and such you could load directly from z/OS -> any other platform.

You would have to install the same level of arsload as you're running on Linux, i.e. V10 -> V10, but no configuration would be needed.  Just lay down the code, point arsload to the other box and let 'er rip.

Yes, I know there may be a cost for the software involved on z if you needed a newer level, but I'd think it would make things much simpler.

Ed

[jsquizz]

Is there a sample arsdoc get command that we can use for this? or is it a bunch of single ones too. I have often wondered this myself.

[Justin Derrick]

You need to run a series of arsdoc commands -- extracting data in batches.  Some of us have written such utilities to the point where it automates the extraction of all the data in a CMOD server with one command.   ;)

-JD.

[jsquizz]

I am assuming something by date ranges and apps/appgroups into large chunks..

[Greg Ira]

One question I would ask is how is the data currently stored?  OAM?  Cache?  If Cache we've shortcutted the process by using ARSADMIN STORES.

[jsquizz]

ive always been curious about the proper supported way of doing this, gathering all information from app groups..once we get them downloaded we can easily load them. I am in a similar boat myself.

[Greg Ira]

Truthfully JD's method is the proper supported way.  ARSDOC gets and stores is the most straightforward and less prone to errors. In my shop we are the CMOD Admins, System Programmers, and DBAs all in one so we tend to bend the rules a bit to get things done quicker and easier.

[Ed_Arnold]

...we tend to bend the rules a bit to get things done quicker and easier.

Shriek!!!   

;D

Ed

[jsquizz]

You need to run a series of arsdoc commands -- extracting data in batches.  Some of us have written such utilities to the point where it automates the extraction of all the data in a CMOD server with one command.   ;)

-JD.

Do you have a sample syntax or am I over thinking this.. is it proprietary to your company?

[Justin Derrick]

This is proprietary, and took about a year to write the code for.  :)

-JD.