RE: members in a file

I found one on a 5.4 machine. It's a logical (aka SQL view) created over
QADBXREF

Paul Nelson
Cell 708-670-6978
Office 512-392-2577
nelsonp@xxxxxxxxxxxxx


-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Tom Liotta
Sent: Friday, December 28, 2007 1:43 PM
To: midrange-l@xxxxxxxxxxxx
Subject: Re: members in a file

Paul Nelson wrote:

I haven't really been following this thread, but where does SYSPSTAT come
from? It's not on my V5R2 machine.

Paul:

Nor is it on any of our systems ranging from V5R1 through V5R4.
However, I do see it on one of our systems that's running a kind of
"unsupported" release. In comparing the installed LPPs and options,
I can't see why it would be on that one system and not any others.

I was thinking that it might be part of DB2 Multisystem or SMP, but
neither of those options are on the one box that has it.

Perhaps those that have it could list their installed LPPs and
options to see where it comes from. A quick google for [syspstat
site:ibm.com] came up effectively empty.

Tom Liotta

-----Original Message-----

select sys_dname, sys_tna

from qsys2.syspstat
where sys_dname='ROB'
and sys_tname like 'Q%'

....+....1....+....2....+....3...
LIBRARY FILE SYS_MNAME
NAME NAME
ROB QAQQINI QAQQINI
ROB QAYPERLS QAYPERLS
ROB QAYPERLS YETZERTRC
ROB QAYPERLS PMR76481
ROB QBDIETZ DIR002PG
ROB QBDIETZ DIR002RG
ROB QBDIETZ DSPDIR
ROB QBDIETZ DSPDIRC
ROB QBDIETZ LS
ROB QBDIETZ NTS002PF
ROB QBDIETZ README
ROB QCLSRC VRYOBJ
ROB QCLSRC FIXSECLEI
ROB QCLSRC MXPRINTER
ROB QCLSRC USERLIST
ROB QCLSRC TEST
ROB QCLSRC MARCO
...