Listing Version FULL backup

[girreis]

Dear Friends,

How to listing the existing versions of FULL backup stored on tape? Using command SELECT.

Thanks,

Ramon

 

[kfavry]

http://thobias.org/tsm/sql/#toc81



- TSM version 5 tsm: SERVER1> SELECT activity, SUBSTR(CHAR(start_time),1,16) AS START_TIME, SUBSTR(CHAR(end_time),1,16) AS END_TIME, - substr(char(end_time - start_time),1,10) AS "ELAPTIME (D HHMMSS)", - bytes, successful FROM summary WHERE activity='FULL_DBBACKUP' ORDER BY start_time - TSM version 6 tsm: SERVER1> SELECT activity, - TO_CHAR(CHAR(start_time),'YYYY-MM-DD HH24:MI:SS') as START_TIME, - TO_CHAR(CHAR(end_time),'YYYY-MM-DD HH24:MI:SS') as END_TIME, - TRANSLATE('a bc:de:fg', DIGITS(end_time-start_time), '_______abcdefgh_____',' ') as "ELAPTIME (D HHMMSS)", - bytes, successful - FROM summary WHERE activity='FULL_DBBACKUP' ORDER BY start_time ACTIVITY START_TIME END_TIME ELAPTIME (D HHMMSS) BYTES SUCCESSFUL ------------------ ------------------ ------------------ ------------------- -------------------- ------------------ FULL_DBBACKUP 2012-07-28 11:08 2012-07-28 13:50 0 02:42:43 167917010944 YES FULL_DBBACKUP 2012-07-29 11:06 2012-07-29 13:02 0 01:55:19 167767158784 YES FULL_DBBACKUP 2012-07-30 11:06 2012-07-30 13:27 0 02:20:08 167612657664 YES FULL_DBBACKUP 2012-07-31 11:08 2012-07-31 14:16 0 03:08:11 167868518400 YES FULL_DBBACKUP 2012-08-01 11:06 2012-08-01 14:02 0 02:55:30 168396201984 YES FULL_DBBACKUP 2012-08-02 11:12 2012-08-02 14:54 0 03:42:29 168380559360 YES FULL_DBBACKUP 2012-08-03 11:14 2012-08-03 14:29 0 03:14:09 168176906240 YES FULL_DBBACKUP 2012-08-04 11:08 2012-08-04 13:33 0 02:24:47 168380076032 YES FULL_DBBACKUP 2012-08-05 11:06 2012-08-05 13:22 0 02:15:35 168464244736 YES FULL_DBBACKUP 2012-08-06 11:08 2012-08-06 13:42 0 02:34:02 168471093248 YES ...