I just installed TSM 5.1.6.3 today on Redhat 7.2 (2.4.9-31) and for some
reason storage pool stats do not show on a select statement from the
stgpools table, but they do show on a q stgpool statement and the stats are
there. Example output is below.
Does anyone know why this might be happening?

tsm: ADSM2>select * from stgpools where stgpool_name='ARCHIVEPOOL'

   STGPOOL_NAME: ARCHIVEPOOL
       POOLTYPE: PRIMARY
       DEVCLASS: DISK
EST_CAPACITY_MB:
   PCT_UTILIZED:
       PCT_MIGR:
    PCT_LOGICAL:
        HIGHMIG: 90
         LOWMIG: 70
     MIGPROCESS: 1
    NEXTSTGPOOL: SPECTRA_POOL
        MAXSIZE:
         ACCESS: READWRITE
    DESCRIPTION:
    OVFLOCATION:
          CACHE: NO
      COLLOCATE:
        RECLAIM:
     MAXSCRATCH:
     REUSEDELAY:
   MIGR_RUNNING: No
        MIGR_MB:
   MIGR_SECONDS: 0
   RECL_RUNNING:
    RECL_VOLUME:
       CHG_TIME: 2003-04-07 13:48:41.000000
      CHG_ADMIN: DLEVINSO
 RECLAIMSTGPOOL:
       MIGDELAY: 0
    MIGCONTINUE: YES
     DATAFORMAT: Native
   COPYSTGPOOLS:
   COPYCONTINUE:
        CRCDATA: NO


tsm: ADSM2>
tsm: ADSM2>q stg archivepool f=d

               Storage Pool Name: ARCHIVEPOOL
               Storage Pool Type: Primary
               Device Class Name: DISK
         Estimated Capacity (MB): 256.0
                        Pct Util: 24.3
                        Pct Migr: 24.3
                     Pct Logical: 100.0
                    High Mig Pct: 90
                     Low Mig Pct: 70
                 Migration Delay: 0
              Migration Continue: Yes
             Migration Processes: 1
               Next Storage Pool: SPECTRA_POOL
            Reclaim Storage Pool:
          Maximum Size Threshold: No Limit
                          Access: Read/Write
                     Description:
               Overflow Location:
           Cache Migrated Files?: No
                      Collocate?:
           Reclamation Threshold:
 Maximum Scratch Volumes Allowed:
   Delay Period for Volume Reuse:
          Migration in Progress?: No
            Amount Migrated (MB): 0.00
Elapsed Migration Time (seconds): 0
        Reclamation in Progress?:
 Volume Being Migrated/Reclaimed:
  Last Update by (administrator): DLEVINSO
           Last Update Date/Time: 04/07/2003 13:48:41
        Storage Pool Data Format: Native
            Copy Storage Pool(s):
         Continue Copy on Error?:
                        CRC Data: No




This transmittal may contain confidential information intended solely for
the addressee. If you are not the intended recipient, you are hereby
notified that you have received this transmittal in error; any review,
dissemination, distribution or copying of this transmittal is strictly
prohibited. If you have received this communication in error, please notify
us immediately by reply or by telephone (collect at 907-564-1000) and ask to
speak with the message sender. In addition, please immediately delete this
message and all attachments. Thank you.