Author Topic: How to find out data loss in TSM ???  (Read 4191 times)

swat

  • Guest
How to find out data loss in TSM ???
« on: January 12, 2009, 04:56:04 AM »
Once data is migrated from Ondemand cache to TSM....
If there is something went wrong at TSM side....
How we can identify the data loss ?

One method that I am thinking is..
1. Store the LOADID of the loads in flat file.
2. once data is moved to TSM. Query TSM using the LOAD ID.
3. If the data is present on the TSM then OK
4. If not present then NOT OK

Will the above  work ??

Any other good approach..

Thanks in advance...

Thanks,
SWAT



Justin Derrick

  • IBM Content Manager OnDemand Consultant
  • Administrator
  • Hero Member
  • *****
  • Posts: 2231
  • CMOD Guru for hire...
    • View Profile
    • Tenacious Consulting
Re: How to find out data loss in TSM ???
« Reply #1 on: January 12, 2009, 01:20:50 PM »
Hi there.

The first priority in dealing with a data-loss situation is to understand exactly how and why data was misplaced -- then resolve that issue.  Hopefully you're past that stage.  If you're not, help reduce the impact of the situation by preventing cache expiration by NOT running arsmaint with the -c and -m options.

Unfortunately, there's no direct analogy to 'Load ID' in TSM.  Inside the TSM database, Application Groups are represented by 'Application Group ID Names', which aren't available in the Load ID.  Additionally, while you're given the 'base' of the object name in the Load ID, you can't be sure how many objects CMOD split the load into, nor their names.

It is possible to get a list of contents from the TSM volumes by using the 'query content' command, but then you're up against the unenviable task of trying to reconcile that information against the contents of your DB2 database.

For folks in situations similar to yours, I recommend a CMOD Data Audit.  I have some utilities that completely automate the detection (and in some cases, repair) of inconsistent archives, both for historical data loss, and as a preventative measure to ensure that inconsistencies don't re-occur.

IBM CMOD Professional Services: http://TenaciousConsulting.com
Call:  +1-866-533-7742  or  eMail:  jd@justinderrick.com
IBM CMOD Wiki:  https://CMOD.wiki/
FREE IBM CMOD Education & Webinars:  https://CMOD.Training/

Interests: #AIX #Linux #Multiplatforms #DB2 #TSM #SP #Performance #Security #Audits #Customizing #Availability #HA #DR