RE: Question about syspartitionstat table

Am I doing something wrong or does QSYS2.PARTITION_STATISTICS not exist in
6.1?

-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of
CRPence
Sent: Thursday, July 21, 2016 11:42 AM
To: midrange-l@xxxxxxxxxxxx
Subject: Re: Question about syspartitionstat table

On 21-Jul-2016 10:30 -0500, John R. Smith, Jr. wrote:

I have three files in a library that I am testing with.

TESTSQL - Created via a CREATE TABLE.

TESTDDS - Created via DDS.

TESTPF - Created via CRTPF specifying a record length instead of DDS.

When I query syspartitionstat, I only see TESTSQL and TESTDDS. Why am
I not seeing TESTPF?

We are running 6.1 if that makes a difference.

The fact that SYSPSTAT aka SystemPartitionStat is a VIEW, rather than a
TABLE, is telling. In review of the SYSPSTAT View Definition, will be found
the answer; most likely, there is selection in a WHERE-clause that precludes
non-relational files, per the predicate DBXREL='Y'.
Similarly, any files in QTEMP are also not included, but because they are
not in the Database Cross Reference (DBXREF) [effective catalog] file being
referenced in the query of that VIEW, rather than by omission of data that
could potentially be generated. The UDTF [QSYS2.PARTITION_STATISTICS] that
performs the dynamic retrieval of the list of /members/ in the files
[irrespective that relational test], can be invoked in less restrictive
ways, for which the QTEMP and non-relational attributes would not be an
issue.

--
Regards, Chuck

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe,
or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at http://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related questions.