It is my understanding that the show commands are for IBM support to
diagnose problems.
"show" means show raw data in the server memory or in the database.  I
am not
surprised that they aren't documented, or that they don't perform well.
I know of
a number of others because level 2 has asked me to use them -- to good
effect, they
saved my database! -- but I won't publish them because I think they were
given to me
in confidence.

Functions like 'show volumeusage' have been requested at user group
meetings.  I think
this function will be in version 3.  This is the right way to get new
function
instead of asking IBM to document the show commands.

--
Bill Colwell
Bill Colwell
The Charles Stark Draper Laboratory
Cambridge Ma.

Morris.Marshael wrote:
>
>      I did a help show and also looked up the command and did not find
>      anything on this command.
>
> ______________________________ Reply Separator 
> _________________________________
> Subject: Re: show commands
> Author:  "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU> at Internet
> Date:    6/18/97 4:06 PM
>
> Jane,
>
> See the other emails on the potential problems with issuing this command on
> MVS from the console.  It does display information for each version of each
> backup file in the filespace, so the output can be lengthy and cause you to
> run out of WTO buffers.  On AIX, it's no big deal, plus I did it on a
> filespace that only had a few files (I did a q occ nodename * first to see
> how many I'd be dealing with).  The original email where I first saw this
> command said the output should be directed to a file, but at some point it
> was dropped in all the replies.
>
> Why are these commands undocumented?  When people find out about them, it's
> natural to try them to see what information you can get.  If you could look
> them up in a manual or do a 'help' on them, you could see warnings about
>  problems the command could cause.
>
> Tina Hilton
>  ----------
> From: Jane Walker
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: Re: show commands
> Date: Wednesday, June 18, 1997 1:53PM
>
> Hilton Tina wrote:
> >
> > Someone else mentioned this command the other day.  It's:
> >      SHOW VERSION nodename filespace
> > Issued from the admin client, it shows the backups and when they were
> done
> > and when old versions were deactivated, as well as what management class
> was
> > used.
> >
> > Sample output is this:
> > adsm> show version isp0210e /df10_DSST
> > /df10_DSST : / oracle (MC: ARCH4VERS)
> > Active, Inserted 06/12/1997 05:11:21
> >
> > /df10_DSST : /oracle/ DATA01201.dbf (MC: DEFAULT)
> > Active, Inserted 06/17/1997 05:10:42
> >
> > /df10_DSST : /oracle/ DATA01201.dbf (MC: DEFAULT)
> > Inactive, Inserted 06/14/1997 05:17:40, Deactivated 00/00/1900 00:00:00
> >
> > /df10_DSST : /oracle/ DATA01201.dbf (MC: DEFAULT)
> > Inactive, Inserted 06/16/1997 06:20:20, Deactivated 06/17/1997 05:10:42
> >
> > Tina Hilton
> >  ----------
> > From: Jane Walker
> > To: ADSM-L AT VM.MARIST DOT EDU
> > Subject: Re: show commands
> > Date: Tuesday, June 17, 1997 8:07AM
> >
> > Hilton Tina wrote:
> > >
> > > So now I know about these two show commands:
> > >      show volumeusage
> > >      show version
> > >
> > > Anyone know if there are any more of these?  They do come in handy.
> > >
> > > Tina Hilton
> > > Thomson Consumer Electronics
> > Tina,
> >   What does the 'show version' command give you.  Also what are the
> > correct sub-parameters you use with it?
> >
> > Thanks,
> >  --
> > Jane Walker                 Phone: (801) 237-5532  GO JAZZ!  //
> >    205 E. 2nd S. Rm 203     Fax  : (801) 237-3099        ___//
> >    Salt Lake City, UT 84111 Pager: (801) 480-0175       (_o_/
> >    MailTo: jawalke AT netmail2.mnet.uswest DOT com        \\/\//\T//\///
> Tina,
>
>   Is this command platform specific?  I can't seem to make it work on an
> MVS ADSM server.
>
> Thanks,
> Jane
>  --
> Jane Walker                 Phone: (801) 237-5532  GO JAZZ!  //
>    205 E. 2nd S. Rm 203     Fax  : (801) 237-3099        ___//
>    Salt Lake City, UT 84111 Pager: (801) 480-0175       (_o_/
>    MailTo: jawalke AT netmail2.mnet.uswest DOT com        \\/\//\T//\///