TSM and expired documents

[Michel de Kraker]

Hi All,

arsmaint deleted db2 segments. data is still in TSM (did a query on the filespace for the application group)

Is it possible to retrieve the TSM data en load it again in CMOD?

Thx.

Michel.


UPDATE 02-11-2010: I see the data in TSM. I can restore the filespace with the documents in it. But DB2 tables are empty. So can i load those documents which i retrieved from TSM back in ONDEMAND?

[sandeepveldi]

If you take the DB2 full backup (online or offline) on a regular basis, you should be able to restore it to "Point in time" state before the DB2 segments got deleted.

It's not possible to identify the index data from the data in TSM. Since, the data stored in TSM is compressed objects which contain multiple documents in them.

My suggestion would be restore DB2 database from one of its backup images and your data in TSM will be accessible from CMOD again.

Regards,
Sandeep Veldi

[Justin Derrick]

Hi Michael...

I'm not sure which format the archived database tables are in.  If they are in IXF format, you should be able to use DB2's 'import' command to bring the files back into the database -- but the corresponding information (arsseg records) might be missing as well, so you'll re-create them by hand.

It's an interesting problem -- please keep us posted!

-JD.

[Michel de Kraker]

Thx Justin,

I thought changing the life of data and indexes parameter would only impact newly loaded documents. Now it seems that changing this parameter will also effect allready loaded files (can you confirm this) so i do not have to reload the AFP documents.

Thx anyway.

Michel.

[Justin Derrick]

Hi Michel...

I can't really confirm anything that has to do with your server -- I don't know what software versions you're on, or precisely how it's configured.

What I *can* tell you is that the more recent versions of CMOD work more like the way you'd want them to -- expiring data based on the CURRENT expiration information, rather than the expiration information that was in effect at the time data was loaded.

Happy New Year, and good luck!

-JD.