Retrieve all documents from AG

Previous topic - Next topic

Michel de Kraker

Goodday all,

Is it possible with the arsdoc get command to retrieve all archived documents from the AG?

I have tried some arsdoc get parameters, but not luck
Any help will be appreciated.

I am using this command:

arsdoc get -a -d /tmp/cmod -f "MSM Consignment Notes" -h archive -i "where CONSIGN_NO='*'" -G D150 -o TEST

Tried also with: CONSIGN_NO='%'

Thankyou

Kind regards ,

Michel

Justin Derrick

There's a few reasons not to do this...

- The file it generates may be *enormous*, especially if the loaded files were compressed.
- Older versions of CMOD had issues generating generic index files over 2GB in size, rolling over the byte offset back to 0.
- Loading a single large file with data that spans years may break expiration processing, especially if the expiration type is 'Load'.
- Any error retrieving data from CMOD will result in the entire extract failing.
- If there's more than a couple thousand documents, you'll quickly reach a point where your filesystem will be overwhelmed, and simple commands (ls / cp / mv / rm) will take several minutes.

Most folks extract by Load ID or date or by a mostly-unique ID like customer number, etc.

If this is a particularly large job, reach out to me via eMail -- I have a fast & automated extraction utility I use for migrations.

-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