I agree, I just tried it, and the last 3 fields, seem to be what I need. And it was quick...
Thanks.
Tim
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of rob@xxxxxxxxx
Sent: Friday, December 28, 2007 6:15 AM
To: Midrange Systems Technical Discussion
Subject: Re: members in a file
To the OP:
This seems to be the file you want!
If performance on it isn't what you want (for all libraries) then I'd open
up a pmr with IBM, as Elvis suggested.
Rob Berendt
--
Group Dekko Services, LLC
Dept 01.073
PO Box 2000
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com
rob@xxxxxxxxx
Sent by: midrange-l-bounces@xxxxxxxxxxxx
12/28/2007 09:13 AM
Please respond to
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
To
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
cc
Subject
Re: members in a file
That made a big difference! Still said "making a copy of the file" like
it does without the where but ran lickety split.
Rob Berendt
--
Group Dekko Services, LLC
Dept 01.073
PO Box 2000
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com
Bryan Dietz <bdietz400@xxxxxxxxx>
Sent by: midrange-l-bounces@xxxxxxxxxxxx
12/27/2007 07:29 PM
Please respond to
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
To
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
cc
Subject
Re: members in a file
Good catch Rob,
Looking at the fields in the file you see:
Field Name FMT Start Lngth Dec Key Field Description
TABSCHEMA A 1 130 Library name
TABNAME A 131 130 Long file name
TABPART A 261 130
PARTTYPE A 391 1
PARTNBR B 392 9 00
DSTPARTS B 396 9 00
CARD B 400 18 00
NPAGES B 408 18 00
FPAGES B 416 18 00
OVERFLOW B 424 18 00
CLUSTERED A 432 1
ACTBLOCKS B 433 18 00
ACROWSIZE B 441 18 00
ACROWRATIO F 449 4 08
AVGROWSIZE B 453 18 00
PCTCROWS F 461 4 08
PCTPGSAVED B 465 4 00
DELETED B 467 18 00
SIZE B 475 18 00
VLSIZE B 483 18 00
FLEXTENTS B 491 18 00
VLEXTENTS B 499 18 00
CSTATSSIZE B 507 18 00
MTISIZE B 515 18 00
DISTINCTIX B 523 9 00
OPENS B 527 18 00
CLOSES B 535 18 00
INSERTS B 543 18 00
UPDATES B 551 18 00
DELETES B 559 18 00
DSCLEARS B 567 18 00
DSCOPIES B 575 18 00
DSREORGS B 583 18 00
DSINXBLDS B 591 18 00
LGLREADS B 599 18 00
PHYREADS B 607 18 00
LASTCHG Z 615 26
LASTSAVE Z 641 26
LASTRST Z 667 26
LASTUSED Z 693 26
DAYSUSED B 719 9 00
LASTRESET Z 723 26
SYS_DNAME A 749 10 Library name
SYS_TNAME A 759 10 File name
SYS_MNAME A 769 10
I too tried to just RUNQRY *N QSYS2/SYSPSTAT
and it ran and ran. But if you select a library name it runs fast.
Bryan
rob@xxxxxxxxx said the following on 12/27/2007 3:24 PM:
I looked hard at this Tim to find you a nice SYS* type of table. I know
that in the SQL world IBM refers to members as partitions. So I tried
looking at SYSPSTAT.
select * from qsys2.syspstat
Query running. Creating copy of file SYSPSTAT in QSYS2.
... and running and running and running...
Rob Berendt
--
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.
--
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.
--
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.
------------------------------------------------------------------------------
This e-mail message, including any attachments, is for the
sole use of the intended recipient(s) and may contain
confidential or privileged information. Any unauthorized
review, use, disclosure or distribution is prohibited. If
you are not the intended recipient, please contact the
sender by reply e-mail and destroy the message.
==============================================================================
midrange.com
