SELECT COLNAME, REMARKS FROM COLUMNS WHERE TABNAME='SUMMARY'

Regards,

Andy

Andy Raibeck
IBM Software Group
Tivoli Storage Manager Client Development
Internal Notes e-mail: Andrew Raibeck/Tucson/IBM@IBMUS
Internet e-mail: storman AT us.eyebm DOT com (change eye to i to reply)

The only dumb question is the one that goes unasked.
The command line is your friend.
"Good enough" is the enemy of excellence.




Michael Moore <Michael_Moore AT VFC DOT COM>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
09/13/2002 07:57
Please respond to "ADSM: Dist Stor Manager"


        To:     ADSM-L AT VM.MARIST DOT EDU
        cc:
        Subject:        Select Column Descriptions



Is there anywhere that describes what a column in a select command result
is telling you?  For example:

I issue the following select command:
select * from summary where date(start_time) = current date - 1 day and
entity='ITGCURS6'

I get the following:

   START_TIME: 2002-09-12 00:01:59.000000
     END_TIME: 2002-09-12 00:03:47.000000
     ACTIVITY: BACKUP
       NUMBER: 787
       ENTITY: ITGCURS6
     COMMMETH: Tcp/Ip
      ADDRESS: 167.64.22.242:33443
SCHEDULE_NAME:
     EXAMINED: 1
     AFFECTED: 1
       FAILED: 0
        BYTES: 2826251
         IDLE: 0
       MEDIAW: 62
    PROCESSES: 1
   SUCCESSFUL: YES
  VOLUME_NAME:
   DRIVE_NAME:
 LIBRARY_NAME:
     LAST_USE:


What are the following telling me

AFFECTED - Is this backed up? or expired?
MEDIAW - is this in seconds (I HOPE!!)  is this total time, or just the
max?

Is there somewhere in the documentation that describes each column?  If
there is, I can't find it!

I have been asked to start tracking the amount of data being backed up on
a
daily basis, and I am looking for the most straight forward way.  I really
don't want to run several queries, just to get this information.
Management wants it in one neat spreadsheet.

Thanks!

Michael Moore
VF Services Inc.
121 Smith Street
Greensboro,  NC  27420-1488

Voice: 336-332-4423
Fax: 336-332-4544