Richard, thanks for the performance note re select vs. query.

IMHO, a larger concern, if you're writing programs to analyze TSM's data, is
that the layout of the queries may change when you upgrade TSM, but the
field names
in the database won't.  So your programs won't break when you upgrade TSM.

-----------------------------
Mr. Lindsay Morris
Lead Architect
www.servergraph.com
512-482-6138 ext 105

> -----Original Message-----
> From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU]On Behalf Of
> Richard Sims
> Sent: Monday, June 23, 2003 2:37 PM
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: Re: SELECT equivalent for QUERY EVENT
>
>
> >as our VM mainframe is soon going to die I'm rewriting all my CMS REXX
> >programs using REGINA and REXXSQL on Windows XP.
> >As I have to rewrite the code I would like to brush it up and replace
> >those QUERYs with SELECTs.
>
> Thomas - A couple of observations...
>
> - I would caution avoiding going to Selects, which seem the "chic" thing
>   to do these days.  Query commands are more optimized for directly going
>   into the TSM database to rapidly return results: Selects go through an
>   artificial SQL construct on top of the actual B-tree database and
>   entail considerable overhead - including database workspace.
>   For example, contrast a Query CONTent with Select ... From Contents.
>   Query commands are not passe: they are simply pre-programmed and that
>   much less flexible.
>
> - Your VM mainframe went away because of obsolescence.  REXX is in the
>   same category.  (And I say this having been a VM guy and huge fan of
>   REXX.)  I would encourage you to get into Perl, which is available on
>   every platform, and is now intrinsically supplied with more open
>   operating systems these days.
>
>     Richard Sims, BU
>