David E Ehresman wrote:
The "q content" command has a copied=no option. Is there a way to do a
sql query against the "copied" attirbute?
David
tsm: MYSERVER>select * from columns where tabname='CONTENTS'
TABSCHEMA TABNAME COLNAME COLNO
INDEX_KEYSEQ INDEX_ORDER TYPENAME LENGTH
SCALE NULLS REMARKS
--------- ------------------ ------------------ ------
------------ ----------- ------------------ -----------
------ ----- ------------------
ADSM CONTENTS VOLUME_NAME 1
1 A VARCHAR 1025
0 FALSE Volume Name
ADSM CONTENTS NODE_NAME 2
VARCHAR 64
0 FALSE Node Name
ADSM CONTENTS TYPE 3
VARCHAR 20
0 FALSE Type
ADSM CONTENTS FILESPACE_NAME 4
VARCHAR 64
0 FALSE Filespace Name
ADSM CONTENTS FILE_NAME 5
VARCHAR 1538
0 FALSE Client's Name for
File
ADSM CONTENTS AGGREGATED 6
VARCHAR 20
0 FALSE Aggregated?
ADSM CONTENTS FILE_SIZE 7
DECIMAL 18
0 FALSE Stored Size
ADSM CONTENTS SEGMENT 8
VARCHAR 20
0 TRUE Segment Number
ADSM CONTENTS CACHED 9
VARCHAR 20
0 FALSE Cached Copy?
ADSM CONTENTS FILESPACE_ID 10
INTEGER 0
0 FALSE FSID
ADSM CONTENTS FILESPACE_HEXNAME 11
VARCHAR 64
0 TRUE Hexadecimal
Filespace Name
ADSM CONTENTS FILE_HEXNAME 12
VARCHAR 1538
0 TRUE Hexadecimal
Client's Name for
File
I guess not, or at least not from the contents table.
--
Met vriendelijke groeten,
Remco Post
SARA - Reken- en Netwerkdiensten http://www.sara.nl
High Performance Computing Tel. +31 20 592 3000 Fax. +31 20 668 3167
"I really didn't foresee the Internet. But then, neither did the
computer industry. Not that that tells us very much of course - the
computer industry didn't even foresee that the century was going to
end." -- Douglas Adams
