×
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.
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 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.
midrange.com
