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