IBM Tivoli Storage Manager
Command Line Administrative Interface - Version 5, Release 2, Level 3.0
(c) Copyright by IBM Corporation and other(s) 1990, 2004. All Rights Reserved.

ANS8000I Server command: 'select * from tables'

     TABSCHEMA: ADSM
       TABNAME: ACTLOG
   CREATE_TIME: 1998-11-20 11:31:46.000035
      COLCOUNT: 11
INDEX_COLCOUNT: 1
  UNIQUE_INDEX: FALSE
       REMARKS: Server activity log

     TABSCHEMA: ADSM
       TABNAME: ADMINS
   CREATE_TIME: 1998-11-20 11:31:46.000035
      COLCOUNT: 17
INDEX_COLCOUNT: 1
  UNIQUE_INDEX: TRUE
       REMARKS: Server administrators

     TABSCHEMA: ADSM
       TABNAME: ADMIN_SCHEDULES
   CREATE_TIME: 1998-11-20 11:31:46.000035
      COLCOUNT: 16
INDEX_COLCOUNT: 1
  UNIQUE_INDEX: TRUE
       REMARKS: Administrative command schedules

     TABSCHEMA: ADSM
       TABNAME: ARCHIVES
   CREATE_TIME: 1998-11-20 11:31:46.000035
      COLCOUNT: 11
INDEX_COLCOUNT: 4
  UNIQUE_INDEX: TRUE
       REMARKS: Client archive files

     TABSCHEMA: ADSM
       TABNAME: AR_COPYGROUPS
   CREATE_TIME: 1998-11-20 11:31:46.000035
      COLCOUNT: 10
INDEX_COLCOUNT: 4
  UNIQUE_INDEX: TRUE
       REMARKS: Management class archive copy groups

     TABSCHEMA: ADSM
       TABNAME: ASSOCIATIONS
   CREATE_TIME: 1998-11-20 11:31:46.000035
      COLCOUNT: 5
INDEX_COLCOUNT: 2
  UNIQUE_INDEX: FALSE
       REMARKS: Client schedule associations

     TABSCHEMA: ADSM
       TABNAME: AUDITOCC
   CREATE_TIME: 1998-11-20 11:31:46.000035
      COLCOUNT: 8
INDEX_COLCOUNT: 1
  UNIQUE_INDEX: TRUE
       REMARKS: Server audit occupancy results

     TABSCHEMA: ADSM
       TABNAME: BACKUPS
   CREATE_TIME: 1998-11-20 11:31:46.000035
      COLCOUNT: 12
INDEX_COLCOUNT: 5
  UNIQUE_INDEX: TRUE
       REMARKS: Client backup files

     TABSCHEMA: ADSM
       TABNAME: BACKUPSETS
   CREATE_TIME: 1998-11-20 11:31:46.000035
      COLCOUNT: 7
INDEX_COLCOUNT: 2
  UNIQUE_INDEX: FALSE
       REMARKS: Backup Set

     TABSCHEMA: ADSM
       TABNAME: BU_COPYGROUPS
   CREATE_TIME: 1998-11-20 11:31:46.000035
      COLCOUNT: 15
INDEX_COLCOUNT: 4
  UNIQUE_INDEX: TRUE
       REMARKS: Management class backup copy groups

     TABSCHEMA: ADSM
       TABNAME: CLIENTOPTS
   CREATE_TIME: 1998-11-20 11:31:46.000035
      COLCOUNT: 5
INDEX_COLCOUNT: 3
  UNIQUE_INDEX: TRUE
       REMARKS: Client Options

     TABSCHEMA: ADSM
       TABNAME: CLIENT_SCHEDULES
   CREATE_TIME: 1998-11-20 11:31:46.000035
      COLCOUNT: 18
INDEX_COLCOUNT: 2
  UNIQUE_INDEX: TRUE
       REMARKS: Client schedules

     TABSCHEMA: ADSM
       TABNAME: CLOPTSETS
   CREATE_TIME: 1998-11-20 11:31:46.000035
      COLCOUNT: 4
INDEX_COLCOUNT: 1
  UNIQUE_INDEX: TRUE
       REMARKS: Client Option Sets

     TABSCHEMA: ADSM
       TABNAME: CONTENTS
   CREATE_TIME: 1998-11-20 11:31:46.000035
      COLCOUNT: 12
INDEX_COLCOUNT: 1
  UNIQUE_INDEX: FALSE
       REMARKS: Storage pool volume contents

     TABSCHEMA: ADSM
       TABNAME: DATAMOVERS
   CREATE_TIME: 1998-11-20 11:31:46.025065
      COLCOUNT: 12
INDEX_COLCOUNT: 1
  UNIQUE_INDEX: TRUE
       REMARKS: Data Movers

     TABSCHEMA: ADSM
       TABNAME: DB
   CREATE_TIME: 1998-11-20 11:31:46.000035
      COLCOUNT: 20
INDEX_COLCOUNT: 0
  UNIQUE_INDEX: FALSE
       REMARKS: Server database information

     TABSCHEMA: ADSM
       TABNAME: DBBACKUPTRIGGER
   CREATE_TIME: 1998-11-20 11:31:46.000035
      COLCOUNT: 8
INDEX_COLCOUNT: 0
  UNIQUE_INDEX: FALSE
       REMARKS: Database backup trigger information

     TABSCHEMA: ADSM
       TABNAME: DBSPACETRIGGER
   CREATE_TIME: 1998-11-20 11:31:46.000035
      COLCOUNT: 6
INDEX_COLCOUNT: 0
  UNIQUE_INDEX: FALSE
       REMARKS: Database space trigger information

     TABSCHEMA: ADSM
       TABNAME: DBVOLUMES
   CREATE_TIME: 1998-11-20 11:31:46.000035
      COLCOUNT: 9
INDEX_COLCOUNT: 0
  UNIQUE_INDEX: FALSE
       REMARKS: Database volumes

     TABSCHEMA: ADSM
       TABNAME: DEVCLASSES
   CREATE_TIME: 1998-11-20 11:31:46.999999
      COLCOUNT: 18
INDEX_COLCOUNT: 1
  UNIQUE_INDEX: TRUE
       REMARKS: Device Classes

     TABSCHEMA: ADSM
       TABNAME: DISKS
   CREATE_TIME: 1998-11-20 11:31:46.025065
      COLCOUNT: 7
INDEX_COLCOUNT: 2
  UNIQUE_INDEX: TRUE
       REMARKS: Disks

     TABSCHEMA: ADSM
       TABNAME: DOMAINS
   CREATE_TIME: 1998-11-20 11:31:46.000035
      COLCOUNT: 11
INDEX_COLCOUNT: 1
  UNIQUE_INDEX: TRUE
       REMARKS: Policy domains

     TABSCHEMA: ADSM
       TABNAME: DRIVES
   CREATE_TIME: 1998-11-20 11:31:46.999999
      COLCOUNT: 11
INDEX_COLCOUNT: 2
  UNIQUE_INDEX: TRUE
       REMARKS: Drives

     TABSCHEMA: ADSM
       TABNAME: DRMCSTGPOOLS
   CREATE_TIME: 1998-11-20 11:31:46.025065
      COLCOUNT: 1
INDEX_COLCOUNT: 0
  UNIQUE_INDEX: FALSE
       REMARKS: Copy storage pools managed by the disaster recovery manager

     TABSCHEMA: ADSM
       TABNAME: DRMEDIA
   CREATE_TIME: 1998-11-20 11:31:46.025065
      COLCOUNT: 7
INDEX_COLCOUNT: 0
  UNIQUE_INDEX: FALSE
       REMARKS: Physical volumes managed by move drmedia

     TABSCHEMA: ADSM
       TABNAME: DRMMACHINE
   CREATE_TIME: 1998-11-20 11:31:46.025065
      COLCOUNT: 9
INDEX_COLCOUNT: 5
  UNIQUE_INDEX: TRUE
       REMARKS: Disaster recovery manager machine information

     TABSCHEMA: ADSM
       TABNAME: DRMMACHINECHARS
   CREATE_TIME: 1998-11-20 11:31:46.025065
      COLCOUNT: 2
INDEX_COLCOUNT: 0
  UNIQUE_INDEX: FALSE
       REMARKS: Disaster recovery manager machine characteristics

     TABSCHEMA: ADSM
       TABNAME: DRMMACHINENODE
   CREATE_TIME: 1998-11-20 11:31:46.025065
      COLCOUNT: 2
INDEX_COLCOUNT: 0
  UNIQUE_INDEX: FALSE
       REMARKS: Disaster recovery manager machine node associations

     TABSCHEMA: ADSM
       TABNAME: DRMMACHINERECINST
   CREATE_TIME: 1998-11-20 11:31:46.025065
      COLCOUNT: 2
INDEX_COLCOUNT: 0
  UNIQUE_INDEX: FALSE
       REMARKS: Disaster recovery manager machine recovery instructions

     TABSCHEMA: ADSM
       TABNAME: DRMMACHINERECMEDIA
   CREATE_TIME: 1998-11-20 11:31:46.025065
      COLCOUNT: 2
INDEX_COLCOUNT: 0
  UNIQUE_INDEX: FALSE
       REMARKS: Disaster recovery manager machine recovery media associations

     TABSCHEMA: ADSM
       TABNAME: DRMPSTGPOOLS
   CREATE_TIME: 1998-11-20 11:31:46.025065
      COLCOUNT: 1
INDEX_COLCOUNT: 0
  UNIQUE_INDEX: FALSE
       REMARKS: Primary storage pools managed by the disaster recovery manager

     TABSCHEMA: ADSM
       TABNAME: DRMRECOVERYMEDIA
   CREATE_TIME: 1998-11-20 11:31:46.025065
      COLCOUNT: 7
INDEX_COLCOUNT: 1
  UNIQUE_INDEX: TRUE
       REMARKS: Disaster recovery manager recovery media

     TABSCHEMA: ADSM
       TABNAME: DRMSRPF
   CREATE_TIME: 1998-11-20 11:31:46.025065
      COLCOUNT: 8
INDEX_COLCOUNT: 0
  UNIQUE_INDEX: FALSE
       REMARKS: Recovery plan files in source server

     TABSCHEMA: ADSM
       TABNAME: DRMSTANZA
   CREATE_TIME: 1998-11-20 11:31:46.025065
      COLCOUNT: 1
INDEX_COLCOUNT: 0
  UNIQUE_INDEX: FALSE
       REMARKS: Recovery plan file stanza names

     TABSCHEMA: ADSM
       TABNAME: DRMSTATUS
   CREATE_TIME: 1998-11-20 11:31:46.025065
      COLCOUNT: 11
INDEX_COLCOUNT: 0
  UNIQUE_INDEX: FALSE
       REMARKS: Disaster recovery manager status information

     TABSCHEMA: ADSM
       TABNAME: DRMTRPF
   CREATE_TIME: 1998-11-20 11:31:46.025065
      COLCOUNT: 8
INDEX_COLCOUNT: 0
  UNIQUE_INDEX: FALSE
       REMARKS: Recovery plan files in target server

     TABSCHEMA: ADSM
       TABNAME: EVENTS
   CREATE_TIME: 1998-11-20 11:31:46.000035
      COLCOUNT: 8
INDEX_COLCOUNT: 1
  UNIQUE_INDEX: FALSE
       REMARKS: Scheduled Event Results

     TABSCHEMA: ADSM
       TABNAME: FILESPACES
   CREATE_TIME: 1998-11-20 11:31:46.000035
      COLCOUNT: 11
INDEX_COLCOUNT: 3
  UNIQUE_INDEX: FALSE
       REMARKS: Client file spaces

     TABSCHEMA: ADSM
       TABNAME: GROUP_MEMBER
   CREATE_TIME: 1998-11-20 11:31:46.000035
      COLCOUNT: 4
INDEX_COLCOUNT: 2
  UNIQUE_INDEX: TRUE
       REMARKS: Group Members

     TABSCHEMA: ADSM
       TABNAME: LIBRARIES
   CREATE_TIME: 1998-11-20 11:31:46.999999
      COLCOUNT: 13
INDEX_COLCOUNT: 1
  UNIQUE_INDEX: TRUE
       REMARKS: Libraries

     TABSCHEMA: ADSM
       TABNAME: LIBVOLUMES
   CREATE_TIME: 1998-11-20 11:31:46.999999
      COLCOUNT: 7
INDEX_COLCOUNT: 2
  UNIQUE_INDEX: TRUE
       REMARKS: Library volumes

     TABSCHEMA: ADSM
       TABNAME: LICENSES
   CREATE_TIME: 1998-11-20 11:31:46.000035
      COLCOUNT: 49
INDEX_COLCOUNT: 0
  UNIQUE_INDEX: FALSE
       REMARKS: Server feature licenses

     TABSCHEMA: ADSM
       TABNAME: LICENSE_DETAILS
   CREATE_TIME: 1998-11-20 11:31:46.000035
      COLCOUNT: 4
INDEX_COLCOUNT: 2
  UNIQUE_INDEX: FALSE
       REMARKS: License usage details

     TABSCHEMA: ADSM
       TABNAME: LOG
   CREATE_TIME: 1998-11-20 11:31:46.000035
      COLCOUNT: 15
INDEX_COLCOUNT: 0
  UNIQUE_INDEX: FALSE
       REMARKS: Server recovery log information

     TABSCHEMA: ADSM
       TABNAME: LOGSPACETRIGGER
   CREATE_TIME: 1998-11-20 11:31:46.000035
      COLCOUNT: 6
INDEX_COLCOUNT: 0
  UNIQUE_INDEX: FALSE
       REMARKS: Recovery Log space trigger information

     TABSCHEMA: ADSM
       TABNAME: LOGVOLUMES
   CREATE_TIME: 1998-11-20 11:31:46.000035
      COLCOUNT: 9
INDEX_COLCOUNT: 0
  UNIQUE_INDEX: FALSE
       REMARKS: Recovery log volumes

     TABSCHEMA: ADSM
       TABNAME: MEDIA
   CREATE_TIME: 1998-11-20 11:31:46.999999
      COLCOUNT: 9
INDEX_COLCOUNT: 0
  UNIQUE_INDEX: FALSE
       REMARKS: Physical volumes managed by move media

     TABSCHEMA: ADSM
       TABNAME: MGMTCLASSES
   CREATE_TIME: 1998-11-20 11:31:46.000035
      COLCOUNT: 12
INDEX_COLCOUNT: 3
  UNIQUE_INDEX: TRUE
       REMARKS: Management classes

     TABSCHEMA: ADSM
       TABNAME: NODES
   CREATE_TIME: 1998-11-20 11:31:46.000035
      COLCOUNT: 37
INDEX_COLCOUNT: 1
  UNIQUE_INDEX: TRUE
       REMARKS: Client nodes

     TABSCHEMA: ADSM
       TABNAME: OCCUPANCY
   CREATE_TIME: 1998-11-20 11:31:46.000035
      COLCOUNT: 8
INDEX_COLCOUNT: 1
  UNIQUE_INDEX: FALSE
       REMARKS: Client storage occupancy

     TABSCHEMA: ADSM
       TABNAME: OPTIONS
   CREATE_TIME: 1998-11-20 11:31:46.000035
      COLCOUNT: 2
INDEX_COLCOUNT: 0
  UNIQUE_INDEX: FALSE
       REMARKS: Server Options

     TABSCHEMA: ADSM
       TABNAME: PATHS
   CREATE_TIME: 1998-11-20 11:31:46.025065
      COLCOUNT: 14
INDEX_COLCOUNT: 4
  UNIQUE_INDEX: TRUE
       REMARKS: Paths

     TABSCHEMA: ADSM
       TABNAME: POLICYSETS
   CREATE_TIME: 1998-11-20 11:31:46.000035
      COLCOUNT: 7
INDEX_COLCOUNT: 2
  UNIQUE_INDEX: TRUE
       REMARKS: Policy sets

     TABSCHEMA: ADSM
       TABNAME: PROCESSES
   CREATE_TIME: 1998-11-20 11:31:46.000035
      COLCOUNT: 6
INDEX_COLCOUNT: 1
  UNIQUE_INDEX: FALSE
       REMARKS: Client schedule associations

     TABSCHEMA: ADSM
       TABNAME: PROFILES
   CREATE_TIME: 1998-11-20 11:31:46.000035
      COLCOUNT: 4
INDEX_COLCOUNT: 2
  UNIQUE_INDEX: FALSE
       REMARKS: Profiles

     TABSCHEMA: ADSM
       TABNAME: PROF_ASSOCIATIONS
   CREATE_TIME: 1998-11-20 11:31:46.000035
      COLCOUNT: 4
INDEX_COLCOUNT: 4
  UNIQUE_INDEX: FALSE
       REMARKS: Profile associations

     TABSCHEMA: ADSM
       TABNAME: RECLAIM_ANALYSIS
   CREATE_TIME: 1998-11-20 11:31:46.000035
      COLCOUNT: 9
INDEX_COLCOUNT: 3
  UNIQUE_INDEX: FALSE
       REMARKS: Server reclamation analysis table

     TABSCHEMA: ADSM
       TABNAME: RESTORES
   CREATE_TIME: 1998-11-20 11:31:46.000035
      COLCOUNT: 7
INDEX_COLCOUNT: 0
  UNIQUE_INDEX: FALSE
       REMARKS: Client restore operations

     TABSCHEMA: ADSM
       TABNAME: SAN
   CREATE_TIME: 1998-11-20 11:31:46.025065
      COLCOUNT: 12
INDEX_COLCOUNT: 0
  UNIQUE_INDEX: FALSE
       REMARKS: SAN attached devices

     TABSCHEMA: ADSM
       TABNAME: SCRIPTS
   CREATE_TIME: 1998-11-20 11:31:46.000035
      COLCOUNT: 5
INDEX_COLCOUNT: 2
  UNIQUE_INDEX: TRUE
       REMARKS: Server Command Scripts

     TABSCHEMA: ADSM
       TABNAME: SCRIPT_NAMES
   CREATE_TIME: 1998-11-20 11:31:46.000035
      COLCOUNT: 5
INDEX_COLCOUNT: 1
  UNIQUE_INDEX: TRUE
       REMARKS: Server Command Script Names

     TABSCHEMA: ADSM
       TABNAME: SERVERS
   CREATE_TIME: 1998-11-20 11:31:46.000035
      COLCOUNT: 29
INDEX_COLCOUNT: 1
  UNIQUE_INDEX: TRUE
       REMARKS: Remote server nodes

     TABSCHEMA: ADSM
       TABNAME: SERVER_GROUP
   CREATE_TIME: 1998-11-20 11:31:46.000035
      COLCOUNT: 5
INDEX_COLCOUNT: 1
  UNIQUE_INDEX: TRUE
       REMARKS: Server Groups

     TABSCHEMA: ADSM
       TABNAME: SESSIONS
   CREATE_TIME: 1998-11-20 11:31:46.000035
      COLCOUNT: 20
INDEX_COLCOUNT: 1
  UNIQUE_INDEX: FALSE
       REMARKS: Active client sessions

     TABSCHEMA: ADSM
       TABNAME: SPACEMGFILES
   CREATE_TIME: 1998-11-20 11:31:46.000035
      COLCOUNT: 9
INDEX_COLCOUNT: 4
  UNIQUE_INDEX: TRUE
       REMARKS: Client space-managed files

     TABSCHEMA: ADSM
       TABNAME: STATUS
   CREATE_TIME: 1998-11-20 11:31:46.000035
      COLCOUNT: 41
INDEX_COLCOUNT: 0
  UNIQUE_INDEX: FALSE
       REMARKS: Server status

     TABSCHEMA: ADSM
       TABNAME: STGPOOLS
   CREATE_TIME: 1998-11-20 11:31:46.000035
      COLCOUNT: 34
INDEX_COLCOUNT: 1
  UNIQUE_INDEX: TRUE
       REMARKS: Storage pools

     TABSCHEMA: ADSM
       TABNAME: SUBSCRIPTIONS
   CREATE_TIME: 1998-11-20 11:31:46.000035
      COLCOUNT: 5
INDEX_COLCOUNT: 3
  UNIQUE_INDEX: FALSE
       REMARKS: Subscriptions

     TABSCHEMA: ADSM
       TABNAME: SUMMARY
   CREATE_TIME: 1998-11-20 11:31:46.000035
      COLCOUNT: 21
INDEX_COLCOUNT: 1
  UNIQUE_INDEX: FALSE
       REMARKS: Server Activity Summary Table

     TABSCHEMA: ADSM
       TABNAME: VOLHISTORY
   CREATE_TIME: 1998-11-20 11:31:46.000035
      COLCOUNT: 10
INDEX_COLCOUNT: 2
  UNIQUE_INDEX: TRUE
       REMARKS: Volume history information

     TABSCHEMA: ADSM
       TABNAME: VOLUMES
   CREATE_TIME: 1998-11-20 11:31:46.000035
      COLCOUNT: 21
INDEX_COLCOUNT: 1
  UNIQUE_INDEX: TRUE
       REMARKS: Storage pool volumes

     TABSCHEMA: ADSM
       TABNAME: VOLUMEUSAGE
   CREATE_TIME: 1998-11-20 11:31:46.000035
      COLCOUNT: 6
INDEX_COLCOUNT: 4
  UNIQUE_INDEX: FALSE
       REMARKS: SEQUENTIAL volume usage by client node

     TABSCHEMA: SYSCAT
       TABNAME: COLUMNS
   CREATE_TIME: 1998-11-20 11:31:46.000035
      COLCOUNT: 11
INDEX_COLCOUNT: 3
  UNIQUE_INDEX: TRUE
       REMARKS: SQL Table Column Catalog

     TABSCHEMA: SYSCAT
       TABNAME: ENUMTYPES
   CREATE_TIME: 1998-11-20 11:31:46.000035
      COLCOUNT: 5
INDEX_COLCOUNT: 1
  UNIQUE_INDEX: TRUE
       REMARKS: SQL Enumerated Types Catalog

     TABSCHEMA: SYSCAT
       TABNAME: TABLES
   CREATE_TIME: 1998-11-20 11:31:46.000035
      COLCOUNT: 7
INDEX_COLCOUNT: 2
  UNIQUE_INDEX: TRUE
       REMARKS: SQL Table Catalog


ANS8002I Highest return code was 0.