SYSPARTITIONSTAT AVGROWSIZE -1 -- MIDRANGE-L

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

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> /

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.