Onsite vs Offsite Report

[chad_small]

OK I have an issue. Where I currently work the previous admins setup TSM so all storage pools use the same copypool. My problem is that they have checks that look to see when each storage pool last had a successful copy complete. If the last successful is not within the last 7 days a problem ticket is issued. The problem is the large SAP DB tape pool and how can I see what the amount that is onsite vs what is offsite? Is there some way I could query for that when all the pools use the same copypool? I could I extract what the difference is from what the total storage is in the SAP Pool and what is has copied to the offsite pool? If I can't do it easily through TSM could I more easily due it directly from DB2? Any examples out their?

 

[Harry_Redl]

Hi,

what about querying the occupancy on filespace level? You should get a number for primary and copy storage pool ...

Harry

 

[chad_small]

Yeah but the work of pulling by every file space for every SAP DB is tedious. Was hoping there was some way to extract from the copypool that certain data is from a specific storage pool.

 

[Harry_Redl]

Hi,

well - depends on the amount of files and the volumes - what about searching the content of the primary SAP stgpool volumes checking whether or not the file has a copy (hope you only have one copy stgpool for these data) - this can give you a difference based on FILE_SIZE column ...

Harry

 

[smajl]

09/09/2014 07:09:07    ANR2753I (COPY_DR_TSM01):ANR0984I Process 6317 for BACKUP STORAGE POOL (PREVIEW) started in the FOREGROUND at 07:09:07.  (SESSION: 439084)
09/09/2014 07:09:07    ANR2753I (COPY_DR_TSM01):ANR2110I BACKUP STGPOOL started as process 6317.  (SESSION: 439084)
09/09/2014 07:09:07    ANR2753I (COPY_DR_TSM01):ANR1211I Backup preview of primary storage pool SPD_FS_DR to copy storage pool SPC_DR started as process 6317.  (SESSION: 439084)
09/09/2014 07:09:07    ANR2753I (COPY_DR_TSM01):ANR1212I Backup process 6317 ended for storage pool SPD_FS_DR.  (SESSION: 439084)
09/09/2014 07:09:07    ANR2753I (COPY_DR_TSM01):ANR0986I Process 6317 for BACKUP STORAGE POOL (PREVIEW) running in the FOREGROUND [B]processed 6,920 items for a total of 11,187,007,488[/B] (SESSION: 439084)
09/09/2014 07:09:07    ANR2753I (COPY_DR_TSM01):bytes with a completion state of SUCCESS at 07:09:07.  (SESSION: 439084)

Aren't you looking for backup stg PRIMARY COPY preview=yes wait=yes ? It gives you amount of data to be copied, even if COPY pool is shared with multiple PRIMARY pools

 

[chad_small]

Yeah it gives me how much will be copied. That would work, but many times I am looking for the difference WHILE the backup storage pool is running. In that instance I can't use the preview and so I don't know how much longer I should expect the job to run.

 

[smajl]

Then just modify your admin script to run "backup stg ... preview=yes" before each "backup stg ... preview=no" and you will see in actlog how much data will have to be copied, using "q pr" you get amount that is already copied and then just subtract those 2 numbers to get desired amount of "not yet copied"