Hi *SMers, I would like to be able to calculate the size of a backupset prior to running the "generate backupset" command. If I could do this the size could be included in desciption area when I generate the backupset. I have played around with some select commands, but I can't seem to link all the necessary information. I looked at the "backups" table and from there I can deermine the list of the "active_version", but there is no size attribute only an "object_id" which I assumed linked me to another table but I can't what that table name is. I looked at the "contents" table and found a file size, but that is the size of the aggregate file which could possibly have inactive versions in it. I know TSM keeps this info someplace because when you do a "dsm -> restore" with inactives listed it shows you the files sizes for all the different versions. I can only assume (I know that's dangerous) that TSM must have some either undocumented or inaccessable tables to track this info.
I had been trying an approach where I would bring up "dsm" select "file level" (therefore including all my filespaces), and then use the estimate button. There is 2 problems with this 1 it certainly isn't an automatic thing ( I would like to do this from a scheduled event ) and 2 the numbers I get from estimate in no way reflect what I got when I actually did the "generate backupset". Well, anybody have any ideas? -- Regards, Mark D. Rodriguez President MDR Consulting, Inc. =============================================================================== MDR Consulting The very best in Technical Training and Consulting. IBM Advanced Business Partner SAIR Linux and GNU Authorized Center for Education IBM Certified Advanced Technical Expert, CATE AIX Support and Performance Tuning, RS6000 SP, TSM/ADSM and Linux Red Hat Certified Engineer, RHCE ===============================================================================
