Depending on the version you are on. EDTRBDAP shows Edit Rebuild of Access paths.

Don't know if this helps or not.

On 5/7/2021 4:06 PM, Mark Waterbury wrote:
Darryl,
If you create an SQL TABLE, you are creating a physical file.
If you create an SQL VIEW, you are creating a logical file.
If you create an SQL INDEX, you are creating a logical file.
Just saying ...
Mark S. Waterbury

On Friday, May 7, 2021, 4:55:16 PM EDT, a4g atl <a4ginatl2@xxxxxxxxx> wrote:
The 1 PF has 2 million records. There are 5 indexes on it. I do not use
physical or logical files. This is new development and am using tables,
indexes and views only.
The tables being updated have less than 5,000 records each.

I IPL'd the machine today and will work on the issue again over the
weekend. I need to do a RCLSTG to see if that is needed. I am at 50% disk
utilization.

Darryl.

On Thu, May 6, 2021 at 8:51 AM Patrik Schindler <poc@xxxxxxxxxx> wrote:




As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2021 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.