SLOOK(1)

NAME

     slook - looks up info on the  disk  storage  assigned  by  a
     database

SYNOPSIS

     slook  database_name

DESCRIPTION

     slook is a stand alone program that is called on occasion to
     get a report on dsds storage.

OPTIONS

     none

EXAMPLES

     csh> slook mdi_2
     slook run for mdi_2

      Accessing Database in DS_ConnectDB call

     Connected to ORACLE
     DS_PavailRequest
     DS_OpenPeRequest
     DS_PallocRequest

     PARTN_NAME
        TOTAL_BYTES  AVAIL_BYTES     df_avail_bytes  DP_BYTES        AP_BYTES
     /PDS1
        3.620723e+10 1.876838e+09    1.922626e+09    2.353574e+10    6.713549e+08
                               Total df+DP+AP = 2.612972e+10
     /PDS2
        3.620723e+10 1.588059e+06    1.956803e+09    3.207876e+10    1.001456e+09
                               Total df+DP+AP = 3.503702e+10
     /PDS3
        3.620723e+10 3.458458e+08    3.458662e+08    3.361337e+10    0.000000e+00
                               Total df+DP+AP = 3.395923e+10
     /PDS8
        3.620723e+10 1.407450e+09    1.391043e+09    2.894777e+10    0.000000e+00
                               Total df+DP+AP = 3.033882e+10
     /PDS5
        3.620723e+10 5.868087e+08    2.886152e+09    3.058363e+10    1.702974e+09
                               Total df+DP+AP = 3.517276e+10
     /PDS6
        3.620723e+10 1.927297e+09    2.322760e+09    2.630171e+10    5.679776e+09
                               Total df+DP+AP = 3.430424e+10
     /PDS7
        3.620723e+10 2.021555e+09    2.107859e+09    2.788521e+10    2.538537e+09
                               Total df+DP+AP = 3.253160e+10
     /PDS4
        3.620723e+10 1.455682e+10    1.458379e+10    2.216636e+10    3.857203e+08
                               Total df+DP+AP = 3.713587e+10

      Accessing Database in DS_DisConnectDB call

     Disconnected from ORACLE
     slook Normal Completion

     The PARTN_NAME, TOTAL_BYTES and AVAIL_BYTES are entries from the
     Oracle partn_avail table. The DP_BYTES and AP_BYTES are the sum of
     all the delete pending or archive pending storage for this partition
     from the Oracle partn_alloc table. The df_avail_bytes is the remaining
     bytes on the disk partition for a non superuser. It is gotten from a
     statvfs() call.

FILES

     none

BUGS

       Can only run on sgi machines due to statvfs() use and >4Gb
     partitions.

AUTHOR

     Jim Aloise

HISTORY

     1996-06-14     SOI Version 1.3.0
     1995-01-27     SOI Version 0.9