how many item master files is too many?

["Stone, Joel" <StoneJ@xxxxxxxxxxxxxxxx>]

I would like to find out if my company's database is a bit too complex (as
I'm sure many are).

One simple test I thought of comparing is: How many physical files of one
type are a company's server.

For a simple sampling of other companies, I would like to know how many item
master (product) files your company has on its AS/400.

If you would be able to provide this info (I will keep this anonomous of
course), I would be grateful.

Please do the following steps if you could:

1)      Identify the name of your item master file (to yourself), lets call
it ITEMMAST

2)    Find out the number of fields in the file ITEMMAST, call it #fields

3)    Find out the record length of ITEMMAST, call it reclen

4)      Run the following SQL statement

        runsql 'select * from qsys/qadbxref where dbxnfl=<#fields> and
dbxrdl=<reclen> and dbxatr=''PF'''


5)      jump to the bottom of the list

6)      make sure that the files appear to be actual item-master type files

6)      Email the number of records to me.


Thank you so much for your assistance!