SYSPARTITIONSTAT AVGROWSIZE -1

Here's an interesting item for a Tuesday morning.

I have a file for which DSPFD shows

Record Format List
                       Record  Format Level
 Format       Fields   Length  Identifier
 JLCDTL           28    15844  305551D3FEB23
   Text . . . . . . . . . . . . . . . . . . . :
 Total number of formats  . . . . . . . . . . :           1
 Total number of fields . . . . . . . . . . . :          28
 Total record length  . . . . . . . . . . . . :       15844

Member List
                             Source Creation    Last Change                  Deleted
 Member           Size        Type  Date       Date     Time Records    Records
 JLCDTL               204800        03/08/21 03/09/21 13:03:51          9          0


And the interesting thing is what SYSPARTITIONSTAT shows:

SELECT SYSTEM_TABLE_SCHEMA
     , SYSTEM_TABLE_NAME
     , SYSTEM_TABLE_MEMBER
     , AVGROWSIZE
  FROM QSYS2.SYSPARTITIONSTAT
 WHERE SYSTEM_TABLE_NAME = 'JLCDTL'

System      System      System                     Avgrowsize
Table       Table       Table
Schema      Name        Member
QGPL        JLCDTL      JLCDTL                              1-
********  End of data  ********

Bad news for disk manufacturers :)

--
*Peter Dow* /
Dow Software Services, Inc.
909 793-9050
petercdow@xxxxxxxxx <mailto:petercdow@xxxxxxxxx>
pdow@xxxxxxxxxxxxxx <mailto:pdow@xxxxxxxxxxxxxx> /