I looking to match info from backups tables with contents (file backup date with volume name).
In newer tivoli db (ver 5.5 +) contents table has field CONTENTS OBJECT_ID which could be match with
BACKUPS.OBJECT_ID in older (ver 5.4 -) didn't has this field (or is hide). Do anyone know how to connect those info form both tables CONTENTS and BACKUPS for old tivoli db. My goal is to provide volume_name for each file instants (selected file) from the contents table.
Columns for Contents table (ver. 5.5 +)
CONTENTS VOLUME_NAME
CONTENTS NODE_NAME
CONTENTS TYPE
CONTENTS FILESPACE_NAME
CONTENTS FILE_NAME
CONTENTS AGGREGATED
CONTENTS FILE_SIZE
CONTENTS SEGMENT
CONTENTS CACHED
CONTENTS FILESPACE_ID
CONTENTS FILESPACE_HEXNAME
CONTENTS FILE_HEXNAME
CONTENTS BITFILE_ID
CONTENTS OBJECT_ID
CONTENTS COPIED
CONTENTS DAMAGED
Columns for Contents table (ver. 5.4 -)
CONTENTS VOLUME_NAME
CONTENTS NODE_NAME
CONTENTS TYPE
CONTENTS FILESPACE_NAME
CONTENTS FILE_NAME
CONTENTS AGGREGATED
CONTENTS FILE_SIZE
CONTENTS SEGMENT
CONTENTS CACHED
CONTENTS FILESPACE_ID
CONTENTS FILESPACE_HEXNAME
CONTENTS FILE_HEXNAME
In newer tivoli db (ver 5.5 +) contents table has field CONTENTS OBJECT_ID which could be match with
BACKUPS.OBJECT_ID in older (ver 5.4 -) didn't has this field (or is hide). Do anyone know how to connect those info form both tables CONTENTS and BACKUPS for old tivoli db. My goal is to provide volume_name for each file instants (selected file) from the contents table.
Columns for Contents table (ver. 5.5 +)
CONTENTS VOLUME_NAME
CONTENTS NODE_NAME
CONTENTS TYPE
CONTENTS FILESPACE_NAME
CONTENTS FILE_NAME
CONTENTS AGGREGATED
CONTENTS FILE_SIZE
CONTENTS SEGMENT
CONTENTS CACHED
CONTENTS FILESPACE_ID
CONTENTS FILESPACE_HEXNAME
CONTENTS FILE_HEXNAME
CONTENTS BITFILE_ID
CONTENTS OBJECT_ID
CONTENTS COPIED
CONTENTS DAMAGED
Columns for Contents table (ver. 5.4 -)
CONTENTS VOLUME_NAME
CONTENTS NODE_NAME
CONTENTS TYPE
CONTENTS FILESPACE_NAME
CONTENTS FILE_NAME
CONTENTS AGGREGATED
CONTENTS FILE_SIZE
CONTENTS SEGMENT
CONTENTS CACHED
CONTENTS FILESPACE_ID
CONTENTS FILESPACE_HEXNAME
CONTENTS FILE_HEXNAME
