× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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
...


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.