Re: members in a file

[Bryan Dietz <bdietz400@xxxxxxxxx>]

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