ADSM-L

ADSM_SQL_V3

1998-02-04 09:49:40
Subject: ADSM_SQL_V3
From: "J. Glauer" <glauer AT PIK-POTSDAM DOT DE>
Date: Wed, 4 Feb 1998 14:49:40 +0000
Hello,

  commands: q occu
  and       select * from occupancy

  The results should be the same.
  select shows no type=Bkup

  ???????????????????????????????????

Thanks

A.Glauer




adsm> select * from occupancy

NODE_NAME           TYPE                FILESPACE_NAME      STGPOOL_NAME
         NUM_FILES   PHYSICAL_MB    LOGICAL_MB
------------------  ------------------  ------------------  ------------------
 -----------  ------------  ------------
 -----------  ------------  ------------
AIX_V2              Arch                /tmp_mnt/home/gla-  ARCHIVEPOOL
                  9          0.10          0.10
                                         uer
CLIENT              Arch                /tmp_mnt/home/gla-  ARCHIVEPOOL
                  6          0.08          0.08
                                         uer
CLIENT              Arch                /home.local         ARCHIVEPOOL
                  6          0.08          0.08
WIN31               Arch                SHARE_F:            ARCHIVEPOOL
                  6          0.01          0.01

adsm> q occu



Node Name            Type     Filespace      Storage        Number of
     Physical       Logical
                              Name           Pool Name          Files
        Space         Space
                                                                           
Occupied
     Occupied
                                                                               
(MB)
         (MB)
----------------     ----     ----------     ----------     ---------
    ---------     ---------
    ---------     ---------
AIX_V2               Arch     /tmp_mnt/-     ARCHIVEPO-             9
         0.11          0.11
                               home/gla-      OL
                               uer
CLIENT               Bkup     /home.loc-     BACKUPPOOL             2
         0.14          0.14
                               al
CLIENT               Arch     /tmp_mnt/-     ARCHIVEPO-             6
         0.09          0.09
                               home/gla-      OL
                               uer
CLIENT               Arch     /home.loc-     ARCHIVEPO-             1
         1.00          1.00
                               al             OL
WIN31                Arch     SHARE_F:       ARCHIVEPO-             6
         0.02          0.02
                                              OL
<Prev in Thread] Current Thread [Next in Thread>