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