Author Topic: CMOD Extraction of data  (Read 4128 times)

Glenn

  • Jr. Member
  • **
  • Posts: 21
    • View Profile
CMOD Extraction of data
« on: June 23, 2018, 08:12:26 AM »
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

  • Full Member
  • ***
  • Posts: 152
    • View Profile
Re: CMOD Extraction of data
« Reply #1 on: June 26, 2018, 09:26:19 AM »
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

  • Hero Member
  • *****
  • Posts: 1199
    • View Profile
Re: CMOD Extraction of data
« Reply #2 on: June 27, 2018, 11:01:37 AM »
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

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 573
    • View Profile
Re: CMOD Extraction of data
« Reply #3 on: July 02, 2018, 07:14:40 AM »
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

  • IBM Content Manager OnDemand Consultant
  • Administrator
  • Hero Member
  • *****
  • Posts: 2228
  • CMOD Guru for hire...
    • View Profile
    • Tenacious Consulting
Re: CMOD Extraction of data
« Reply #4 on: July 02, 2018, 08:22:58 AM »
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.
IBM CMOD Professional Services: http://TenaciousConsulting.com
Call:  +1-866-533-7742  or  eMail:  jd@justinderrick.com
IBM CMOD Wiki:  https://CMOD.wiki/
FREE IBM CMOD Education & Webinars:  https://CMOD.Training/

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

jsquizz

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 573
    • View Profile
Re: CMOD Extraction of data
« Reply #5 on: July 02, 2018, 03:08:51 PM »
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

  • Full Member
  • ***
  • Posts: 240
    • View Profile
Re: CMOD Extraction of data
« Reply #6 on: July 03, 2018, 05:00:29 AM »
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

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 573
    • View Profile
Re: CMOD Extraction of data
« Reply #7 on: July 03, 2018, 06:38:11 AM »
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

  • Full Member
  • ***
  • Posts: 240
    • View Profile
Re: CMOD Extraction of data
« Reply #8 on: July 03, 2018, 07:29:50 AM »
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

  • Hero Member
  • *****
  • Posts: 1199
    • View Profile
Re: CMOD Extraction of data
« Reply #9 on: July 03, 2018, 09:48:10 AM »
...we tend to bend the rules a bit to get things done quicker and easier.

Shriek!!!   

;D

Ed
#zOS #ODF

jsquizz

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 573
    • View Profile
Re: CMOD Extraction of data
« Reply #10 on: July 03, 2018, 06:56:59 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

  • IBM Content Manager OnDemand Consultant
  • Administrator
  • Hero Member
  • *****
  • Posts: 2228
  • CMOD Guru for hire...
    • View Profile
    • Tenacious Consulting
Re: CMOD Extraction of data
« Reply #11 on: July 18, 2018, 08:53:51 AM »
This is proprietary, and took about a year to write the code for.  :)

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

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