In addition to Joel's suggestion, if you have a Version 3 server,
you can use the SELECT command to determine this information.

     select filespace_name, hl_name,
            ll_name, class_name,
            state, backup_date
        from backups
        where node_name='<NODENAME>' and
              filespace_name='<filesystem>'

will give you similar information as SHOW VERSION. You execute this
command from the command line admin.

Note that information you enter in the single quotes is case-
sensitive. Node names are always upper-case. Filespace names are
mixed case. Example:

     select filespace_name, hl_name,
            ll_name, class_name,
            state, backup_date
        from backups
        where node_name='STORMAN' and
              filespace_name='\\storman\f$'

If you are in doubt as to the casing (i.e. is it '\\storman\f$',
'\\STORMAN\F$', or '\\StorMan\F$'), you can do something like
this:

     select filespace_name, hl_name,
            ll_name, class_name,
            state, backup_date
        from backups
        where node_name='STORMAN' and
              lower(filespace_name)='\\storman\f$'

Regards,

Andy

Andy Raibeck
IBM Storage Systems Division
ADSM Client Development
e-mail: storman AT us.ibm DOT com
"The only dumb question is the one that goes unasked."

The 'show version <node_name> <filesystem_name>' command is referenced in
the "Using ADSM to Back Up Databases" SG24-4335-02 Red Book.  I believe
that, in the past, IBM has effectively said the the 'show' commands are for
debugging, they are not documented, and use at your own risk.  However they
can be very useful. You can get similar information by doing something
like:
   dsmc query backup -inactive -subdir=yes "/<filesystem>/*"
from the client.

I don't know the tables and fields, so someone else my answer that
question.

On Fri, 22 Jan 1999, Roger N Dick wrote:

> Can anyone tell me what the 'show ver' command does. Where does the
> information it produces come from and is it accurate. What are the
> parameters for the command and where is it documented.
>
> Thanks
>
> Roger D