CMOD Extraction of data

Previous topic - Next topic

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)



J.

#zOS #AIX #Windows #Multiplatforms
#DB2 #TSM #ODF #zODF #ODWEK
#CapacityPlanning #AFP #ReportDistribution
#Finance #ICN

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
#zOS #ODF

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.
#CMOD #DB2 #AFP2PDF #TSM #AIX #RHEL #AWS #AZURE #GCP #EVERYTHING

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.
Call:  +1-866-533-7742  or  eMail:  jd@justinderrick.com
IBM CMOD Wiki:  https://CMOD.wiki/
FREE IBM CMOD Webinars:  https://CMOD.Training/
IBM CMOD Professional Services: https://CMOD.cloud

Interests: #AIX #Linux #Multiplatforms #DB2 #TSM #SP #Performance #Security #Audits #Customizing #Availability #HA #DR

jsquizz

I am assuming something by date ranges and apps/appgroups into large chunks..
#CMOD #DB2 #AFP2PDF #TSM #AIX #RHEL #AWS #AZURE #GCP #EVERYTHING

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.
#CMOD #DB2 #AFP2PDF #TSM #AIX #RHEL #AWS #AZURE #GCP #EVERYTHING

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

Quote from: Greg Ira on July 03, 2018, 02:29:50 PM
...we tend to bend the rules a bit to get things done quicker and easier.

Shriek!!!   

;D

Ed
#zOS #ODF

jsquizz

Quote from: Justin Derrick on July 02, 2018, 03:22:58 PM
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?
#CMOD #DB2 #AFP2PDF #TSM #AIX #RHEL #AWS #AZURE #GCP #EVERYTHING

Justin Derrick

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

-JD.
Call:  +1-866-533-7742  or  eMail:  jd@justinderrick.com
IBM CMOD Wiki:  https://CMOD.wiki/
FREE IBM CMOD Webinars:  https://CMOD.Training/
IBM CMOD Professional Services: https://CMOD.cloud

Interests: #AIX #Linux #Multiplatforms #DB2 #TSM #SP #Performance #Security #Audits #Customizing #Availability #HA #DR