Re: Calculating the size of a backupset

Steve Harris wrote:

Hi Mark,

One approach is to use the export command with preview to calculate how much 
active data you have.

e.g. EXPORT NODE foobar FILEDATA=BACKUPACTIVE PREVIEW=YES

This gives some useful output that you can pick out of the actlog

08/26/2002 08:43:28  ANR0616I EXPORT NODE: Preview processing completed
                     successfully.
08/26/2002 08:43:28  ANR0891I EXPORT NODE: Copied 1 optionset definitions.
08/26/2002 08:43:28  ANR0626I EXPORT NODE: Copied 1 node definitions.
08/26/2002 08:43:28  ANR0627I EXPORT NODE: Copied 7 file space 0 archive files,
                     fsId268504381, 94906 backup files, and 0 space managed
                     files.
08/26/2002 08:43:28  ANR0630I EXPORT NODE: Copied 12954304 kilobytes of data.
08/26/2002 08:43:28  ANR0611I EXPORT NODE started by FREDNURK as process 1833
                     has ended.
08/26/2002 08:43:28  ANR0986I Process 1833 for EXPORT NODE running in the
                     BACKGROUND processed 94915 items for a total of
                     13,265,207,444 bytes with a completion state of SUCCESS
                     at 08:43:28.


HTH

Steve Harris
AIX and TSM Admin
Queensland Health, Brisbane Australia

Steve,

Thank You, I think this gets me close.  I will have to do a little
scripting work to parse out the numbers, but that's not a major hurdle.
I was really hoping to extract it straight from the DB.

I do have one other interesting observation.  The output of the export
like above and the values from an estimate as described in my original
note are very close.  Therefore, I deduce that what export refers to as
"items" are dirs, files, and filespaces.  What is confusing however is
that when the "generate backupset" completed it refers to items as well
but they are obviously different.

ANR0986I Process 59 for EXPORT NODE running in the
                         BACKGROUND processed 76131 items for a total of
                         2,327,069,552 bytes with a completion state of
SUCCESS at
                         19:20:12.

ANR0987I Process 46 for GENERATE BACKUPSET running in the
                         BACKGROUND processed 22877 items with a
completion state
                         of SUCCESS at 18:30:53.

Any thoughts on the difference between these 2 numbers?


--
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
===============================================================================