Author Topic: How do i re-archive AFP data (ardoc get,unload and load)  (Read 4979 times)

leodejong

  • Jr. Member
  • **
  • Posts: 24
    • View Profile
How do i re-archive AFP data (ardoc get,unload and load)
« on: October 28, 2008, 08:16:11 AM »
We are busy converting from OnDemand V2 to V7.
One of the thing we hit is the following: In V2 we occasionally wanted to re-archive data, because of various reasons: (correction of wrong definitions or taking a copy of data for development).
This was done by running three steps
1) IODBPRINT to print the data to an OS dataset
2) IODBSTOR to store the data with the new definitions or at an other system
and optionally:
3) IODBDLET to delete the original SRT entry.

If have tried to do the same thing in V7. I managed to do this with line-data but AFP is given my trouble.
When i do an "ARSDOC GET -X nnnnn -a" i get the data in a unix file.
But to my knowledge it is impossible to run ARSLOAD directly from an USS file.
And when i view the output there is no CR/LF to indicate an end of file. How do copy this output to an OS RECFM=VBS file.
Or is there a more clever way of doing this.

Thanks in advance,
Leo de Jong
Rabobank Netherlands
Leo de Jong, Rabobank,The Netherlands

Bill Dennis

  • Guest
Re: How do i re-archive AFP data (ardoc get,unload and load)
« Reply #1 on: October 29, 2008, 07:50:00 AM »
You certainly can archive from a USS file. The the last parameter of the ARSLOAD PARM is the path/filename of the index file (minus the last .ind level). I believe the .ind file calls out the AFP resource filename from the "get" for inclusion.

LWagner

  • Guest
Re: How do i re-archive AFP data (ardoc get,unload and load)
« Reply #2 on: November 04, 2008, 10:19:50 AM »
From the IBM consultants working with me, and I have tested this during migration, you need the raw data that went into the AFP processing.  The Stored object already has AFP changes applied.

Frederick Tybalt

  • Full Member
  • ***
  • Posts: 124
    • View Profile
    • Personal Website
Re: How do i re-archive AFP data (ardoc get,unload and load)
« Reply #3 on: November 17, 2008, 07:22:40 AM »
I have tried this and it worked.

Step 1:
Quote
arsdoc get -h 127.0.0.1 -u username -p password -d directory_name -g -a -N -c -v -G AG_Name -i "where applid ='Application_id'" -o output_file_name -x Load-id

Step 2:
Quote
arsadmin load -h 127.0.0.1-u username -p password -d directory_name -g New_AG_Name -a New_App_name -i index_file_name -s data_file_name -r resource_file_name

Step 3:
Quote
arsadmin unload -h 127.0.0.1-u username -p password -g old_AG_name -N -L Load_id


This had loaded the AFP data fine to new server retriving from old server.

Rick
www.rick.co.in
rIcK
======------------------======
www.rick.co.in | www.tekbytz.com