OK... actually the SELECT statement I was looking for:

select node_name, '"' || filespace_name || '"'
   from filespaces
   where node_name='CERIUM'

was intended to provide the node name in one output column and the
filespace name, in double quotes, in the second output column, so we could
clearly see the empty name. Also, would be helpful to see the detailed
output of Q FI.

Do you have any idea what these blank-named file spaces might represent
(i.e. what might have been stored from the original client machines)? In
the output you show here, the capacity and utilization are awful close to
those of the root (/) file system.

I think that at this point, you should open a call with support. I can't
explain the blank file space names, and obviously they are causing the
export to fail.

Regards,

Andy

Andy Raibeck
IBM Software Group
Tivoli Storage Manager Client Development
Internal Notes e-mail: Andrew Raibeck/Tucson/IBM@IBMUS
Internet e-mail: storman AT us.ibm DOT com

The only dumb question is the one that goes unasked.
The command line is your friend.
"Good enough" is the enemy of excellence.

"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU> wrote on 01/31/2005
15:22:00:

> Andy,
>
> Here's the first one I tried.
>
> Q OCC only shows FSID 1 and 2.
>
>
>
>
> >Unnamed[1]
> >------------------
> >CERIUM
> >CERIUM/
> >CERIUM/nfs/cerium-
> >  /c1
> >
> >tsm: ADSM>q fi cerium
> >
> >Node Name        Filespace    FSID  Platform  Filespace  Is
> >Files-  Capacity    Pct
> >                  Name                         Type         pace
> > (MB)   Util
> >                                                          Unicode?
> >
> >---------------  -----------  ----  --------  ---------  ---------
> >--------  -----
> >CERIUM           /               1  IRIX      XFS           No
> >4,153.8   59.9
> >CERIUM           /nfs/ceriu-     2  IRIX      XFS           No
> >17,360.5   32.2
> >                   m/c1
> >
> >CERIUM                           3  IRIX      XFS           No
> >4,153.8   61.3
>
> Fred Johanson
> ITSM Administrator
> University of Chicago
> 773-702-8464