OnDemand Users Group

Support Forums => CMOD for Multiplatforms => Topic started by: Maciej Mieczakowski on December 09, 2015, 11:50:11 AM

Title: Restore indexes from FAA1
Post by: Maciej Mieczakowski on December 09, 2015, 11:50:11 AM
I know when data is stored in Ondemand, it's split to two data files located in TSM/cache: compressed object file FAAA and index values FAA1.
Both files are compressed or these are blobs. For sure it's not readable format.

Now I'd like to know how to get access to FAA1 data and recover it back to DB. What is best procedure to do this.

Many Thanks for your guidance.
Title: Re: Restore indexes from FAA1
Post by: Justin Derrick on December 09, 2015, 12:48:50 PM
Hi Maciej.

The FAA1 object is indeed compressed.  You can decompress it with arsadmin decompress, which will result in a text file.  It's been a very long time since I looked at one, but I believe it's a 'columnar' format (not CSV).  I'm not sure how to actually load this data back into CMOD though I'm guessing it might be through one of the arsadmin commands, or maybe you have to write your own utility.

A few things:


Good luck, and report back with any details!

-JD.
Title: Re: Restore indexes from FAA1
Post by: Alessandro Perucchi on December 09, 2015, 11:01:33 PM
I have not many things to say from what Justin said.
Except, since CMOD V9.5 the options in arsadmin were "cleanup" so cannot use it anymore to insert one of this index file.
So it means you must starting from CMOD V9.5 create your own script. The format is basically a tab separated index. The column names are written in the first line (at least for the user indexes).