There seems to be 3 new tables: backupsets, events and summary, when you upgrade
to TSM 3.7.
(compared table listings, pre and post TSM 3.7 upgrade)
My specific upgrade was on the AIX server platform and I went from ADSM 3.1.2.42
to TSM 3.7.0 (then
onto TSM 3.7.2).
I did want to share that answer....and, of course, once YOU have TSM 3.7 on...
you can do the
select * from syscat.columns where tabname='EVENTS' (for example) to further
understand
what's kept in those tables.....etc...
FYI Thanks Tim Williams Frito-Lay/Pepsico
supporting data........:
'OLD days' of adsm:
adsm> select * from events
ANR2939E The reference 'EVENTS' is an unknown SQL table name.
|
..............V.....
select * from events
ANS8001I Return code 3.
adsm> select * from summary
ANR2939E The reference 'SUMMARY' is an unknown SQL table name.
|
..............V......
select * from summary
ANS8001I Return code 3.
adsm> select * from backupsets
ANR2939E The reference 'BACKUPSETS' is an unknown SQL table name.
|
..............V.........
select * from backupsets
ANS8001I Return code 3.
adsm>
NEW days with TSM
adsm> select * from events
SCHEDULED_START: 2000-02-29 01:00:00.000000
ACTUAL_START:
DOMAIN_NAME: SRVR_PD
SCHEDULE_NAME: INTRANET_SRVR
NODE_NAME: INTRAPRO
STATUS: Missed
RESULT:
REASON:
SCHEDULED_START: 2000-02-29 01:00:00.000000
ACTUAL_START:
DOMAIN_NAME: SRVR_PD
SCHEDULE_NAME: INTRANET_SRVR
NODE_NAME: US504I01
STATUS: Missed
RESULT:
REASON:
SCHEDULED_START: 2000-02-29 01:30:00.000000
ACTUAL_START:
DOMAIN_NAME: ORCL_PD
more... (<ENTER> to continue, 'C' to cancel) c
Output to screen cancelled. Please wait for the 'adsm>' prompt.
adsm> select * from summary
ANR2034E SELECT: No match found using this criteria.
ANS8001I Return code 11.
adsm> select * from backupsets
ANR2034E SELECT: No match found using this criteria.
ANS8001I Return code 11.
adsm>
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
more... (<ENTER> to continue, 'C' to cancel)
NULLS: TRUE
REMARKS: End Time
TABSCHEMA: ADSM
TABNAME: SUMMARY
COLNAME: ACTIVITY
COLNO: 3
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
more... (<ENTER> to continue, 'C' to cancel)
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
NULLS: TRUE
REMARKS: Associated user or storage pool(s) associated with the activity
TABSCHEMA: ADSM
TABNAME: SUMMARY
COLNAME: COMMMETH
COLNO: 6
INDEX_KEYSEQ:
more... (<ENTER> to continue, 'C' to cancel)
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
COLNAME: SCHEDULE_NAME
more... (<ENTER> to continue, 'C' to cancel)
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
more... (<ENTER> to continue, 'C' to cancel)
TABSCHEMA: ADSM
TABNAME: SUMMARY
COLNAME: AFFECTED
COLNO: 10
INDEX_KEYSEQ:
INDEX_ORDER:
TYPENAME: DECIMAL
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
more... (<ENTER> to continue, 'C' to cancel)
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
TABSCHEMA: ADSM
TABNAME: SUMMARY
COLNAME: IDLE
COLNO: 13
INDEX_KEYSEQ:
INDEX_ORDER:
TYPENAME: INTEGER
more... (<ENTER> to continue, 'C' to cancel)
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
more... (<ENTER> to continue, 'C' to cancel)
INDEX_KEYSEQ:
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 ?
|