Re: What is this file used for: QABXLFN?

On May 7, 2021, at 4:18 PM, Troy Foster <tfoster@xxxxxxxxxx> wrote:

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:

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related questions.

Help support midrange.com by shopping at amazon.com with our affiliate link: https://amazon.midrange.com