How can I check document location from tables directly?

[teeraw]

How can I check document location (Cache/TSM) from tables directly?
I have plan to disconnect TSM from my CMOD system at one customer site.
But we need to known that have any data is on TSM Storage pool but has no on Cache (Migrated data) to ensure all document still can be retrieved when disconnect TSM.

For more information, we was configure Store Management option to "Migrate Data from Cache >> When Data is Loadded", and still has not run expire from cache.

[Justin Derrick]

The location of a document isn't kept in the database tables.  The process is:

• Use the AGID_NAME for the Application Group, combined with the DOC_NAME in the database table to search for the object in the cache.
• If the object does not exist in the retr subdirectory of the first cache filesystem, then the document is presumed to be in TSM.

You assemble the path to an object as follows:

<first-cache-filesystem-path>/retr/<AGID_Name>/DOC/<DOC_Name>

So the path might be:

/arscache/cache1/retr/MJA/DOC/1234FAAA

If a link exists at that location, it points to the location of the object in one of the defined cache filesystems.  If that file name doesn't exist, CMOD will search TSM for it.

Sadly, there's no quick and easy way to audit this.

-JD.

[teeraw]

Many Thanks, Justin.

There is field "MASK" in ARSSEG table that has describe as "Location", I'm not sure that is related to Document Location? (Cache, TSM)

[Justin Derrick]

I can't say I'm familiar with that field in that table.  It may mean that the table has been migrated to TSM.  It's extraordinarily uncommon as the price of database storage has fallen to the point that there's negligible savings from migrating database tables to TSM.

-JD.

[Alessandro Perucchi]

Hello teeraw,

what Justin said is 100% true.

Don't try to search somewhere else you will loose only time for nothing.
The only thing you will find is new things that has nothing to do with your need.
That's good to find new things which are not related :-D

So the thing you have found is an old thing that tells if the table (segment) is the the database, or is TSM.
Because in the old times, you could migrate whole segments from the database (mainly DB2) into TSM in order to save some disk space on the database.
Yes, 15-20 years ago, disk space was really expensive... and that's the reason that you have the "System Migration" folder/application group, in order to track such actions.
To be honest I have never seen or setup such environment...

So back to your question, you need to do as Justin said, look into the cache "retr" directory for every "select distinc doc_name from SEGMENT_TABLE" if it is in the cache, if it is not, then it should be in TSM.
You have NO other way to do it... But you can keep looking at the database, you will learn (again) lots of nice unrelated things :-D
sorry.

Regards,
Alessandro