Re: Select Column Descriptions
2002-09-13 11:07:07
This is as good as it gets:
tsm: ADSM>select * from syscat.columns where tabname='SUMMARY'
TABSCHEMA: ADSM
TABNAME: SUMMARY
COLNAME: START_TIME
COLNO: 1
INDEX_KEYSEQ: 1
INDEX_ORDER: A
TYPENAME: TIMESTAMP
LENGTH: 0
SCALE: 0
NULLS: FALSE
REMARKS: Start time
TABSCHEMA: ADSM
TABNAME: SUMMARY
COLNAME: END_TIME
COLNO: 2
INDEX_KEYSEQ:
INDEX_ORDER:
TYPENAME: TIMESTAMP
LENGTH: 0
SCALE: 0
NULLS: TRUE
REMARKS: End Time
TABSCHEMA: ADSM
TABNAME: SUMMARY
COLNAME: ACTIVITY
COLNO: 3
more... (<ENTER> to continue, 'C' to cancel)
INDEX_KEYSEQ:
INDEX_ORDER:
TYPENAME: VARCHAR
LENGTH: 64
SCALE: 0
NULLS: FALSE
REMARKS: Process or Session Activity Name
TABSCHEMA: ADSM
TABNAME: SUMMARY
COLNAME: NUMBER
COLNO: 4
INDEX_KEYSEQ:
INDEX_ORDER:
TYPENAME: INTEGER
LENGTH: 0
SCALE: 0
NULLS: TRUE
REMARKS: Process or Session Number
TABSCHEMA: ADSM
TABNAME: SUMMARY
COLNAME: ENTITY
COLNO: 5
INDEX_KEYSEQ:
INDEX_ORDER:
TYPENAME: VARCHAR
LENGTH: 64
SCALE: 0
more... (<ENTER> to continue, 'C' to cancel)
NULLS: TRUE
REMARKS: Associated user or storage pool(s) associated with the
activity
TABSCHEMA: ADSM
TABNAME: SUMMARY
COLNAME: COMMMETH
COLNO: 6
INDEX_KEYSEQ:
INDEX_ORDER:
TYPENAME: VARCHAR
LENGTH: 8
SCALE: 0
NULLS: TRUE
REMARKS: Communications Method Used
TABSCHEMA: ADSM
TABNAME: SUMMARY
COLNAME: ADDRESS
COLNO: 7
INDEX_KEYSEQ:
INDEX_ORDER:
TYPENAME: VARCHAR
LENGTH: 64
SCALE: 0
NULLS: TRUE
REMARKS: Communications Address
TABSCHEMA: ADSM
TABNAME: SUMMARY
more... (<ENTER> to continue, 'C' to cancel)
COLNAME: SCHEDULE_NAME
COLNO: 8
INDEX_KEYSEQ:
INDEX_ORDER:
TYPENAME: VARCHAR
LENGTH: 30
SCALE: 0
NULLS: TRUE
REMARKS: Schedule Name
TABSCHEMA: ADSM
TABNAME: SUMMARY
COLNAME: EXAMINED
COLNO: 9
INDEX_KEYSEQ:
INDEX_ORDER:
TYPENAME: DECIMAL
LENGTH: 18
SCALE: 0
NULLS: TRUE
REMARKS: Number of objects (files and/or directories) examined by the
process/session
TABSCHEMA: ADSM
TABNAME: SUMMARY
COLNAME: AFFECTED
COLNO: 10
INDEX_KEYSEQ:
INDEX_ORDER:
TYPENAME: DECIMAL
more... (<ENTER> to continue, 'C' to cancel)
LENGTH: 18
SCALE: 0
NULLS: TRUE
REMARKS: Number of objects affected (moved, copied or deleted) by the
process/session
TABSCHEMA: ADSM
TABNAME: SUMMARY
COLNAME: FAILED
COLNO: 11
INDEX_KEYSEQ:
INDEX_ORDER:
TYPENAME: DECIMAL
LENGTH: 18
SCALE: 0
NULLS: TRUE
REMARKS: Number of objects that failed in the process/session
TABSCHEMA: ADSM
TABNAME: SUMMARY
COLNAME: BYTES
COLNO: 12
INDEX_KEYSEQ:
INDEX_ORDER:
TYPENAME: DECIMAL
LENGTH: 18
SCALE: 0
NULLS: TRUE
REMARKS: Bytes processed
more... (<ENTER> to continue, 'C' to cancel)
TABSCHEMA: ADSM
TABNAME: SUMMARY
COLNAME: IDLE
COLNO: 13
INDEX_KEYSEQ:
INDEX_ORDER:
TYPENAME: INTEGER
LENGTH: 0
SCALE: 0
NULLS: TRUE
REMARKS: Seconds that the session/process was idle
TABSCHEMA: ADSM
TABNAME: SUMMARY
COLNAME: MEDIAW
COLNO: 14
INDEX_KEYSEQ:
INDEX_ORDER:
TYPENAME: INTEGER
LENGTH: 0
SCALE: 0
NULLS: TRUE
REMARKS: Seconds that the session/process was waiting for access to
media (volume mounts)
TABSCHEMA: ADSM
TABNAME: SUMMARY
COLNAME: PROCESSES
COLNO: 15
INDEX_KEYSEQ:
more... (<ENTER> to continue, 'C' to cancel)
INDEX_ORDER:
TYPENAME: INTEGER
LENGTH: 0
SCALE: 0
NULLS: TRUE
REMARKS: Number of processes used for process
TABSCHEMA: ADSM
TABNAME: SUMMARY
COLNAME: SUCCESSFUL
COLNO: 16
INDEX_KEYSEQ:
INDEX_ORDER:
TYPENAME: ENUMERATED(YESNO_TYPE)
LENGTH: 3
SCALE: 0
NULLS: TRUE
REMARKS: Successful ?
TABSCHEMA: ADSM
TABNAME: SUMMARY
COLNAME: VOLUME_NAME
COLNO: 17
INDEX_KEYSEQ:
INDEX_ORDER:
TYPENAME: VARCHAR
LENGTH: 64
SCALE: 0
NULLS: TRUE
more... (<ENTER> to continue, 'C' to cancel)
REMARKS: Volume Name
TABSCHEMA: ADSM
TABNAME: SUMMARY
COLNAME: DRIVE_NAME
COLNO: 18
INDEX_KEYSEQ:
INDEX_ORDER:
TYPENAME: VARCHAR
LENGTH: 64
SCALE: 0
NULLS: TRUE
REMARKS: Drive Name
TABSCHEMA: ADSM
TABNAME: SUMMARY
COLNAME: LIBRARY_NAME
COLNO: 19
INDEX_KEYSEQ:
INDEX_ORDER:
TYPENAME: VARCHAR
LENGTH: 64
SCALE: 0
NULLS: TRUE
REMARKS: Library Name
TABSCHEMA: ADSM
TABNAME: SUMMARY
COLNAME: LAST_USE
more... (<ENTER> to continue, 'C' to cancel)
COLNO: 20
INDEX_KEYSEQ:
INDEX_ORDER:
TYPENAME: VARCHAR
LENGTH: 64
SCALE: 0
NULLS: TRUE
REMARKS: Last Use
tsm: ADSM>
-----Original Message-----
From: Michael Moore [mailto:Michael_Moore AT VFC DOT COM]
Sent: Friday, September 13, 2002 9:57 AM
To: ADSM-L AT VM.MARIST DOT EDU
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
|
|
|