Re: ALTER TABLE performance issues

[Ken Sims <mdrg8066@xxxxxxxxxxx>]

On Tue, 16 Nov 2010 18:28:46 -0600, "sjl" <sjl_abc@xxxxxxxxxxx> wrote:

> 1) Removing all of the logical file members,
> 2) then using the CPYF to load the file, and
> 3) then submitting jobs to add back the logical file members (ADDLFM) once 
> the CPYF completed,

Rather than removing members, I've found it less invasive to change
any logical files that are MAINT(*IMMED) to MAINT(*REBLD), do the
physical file change, then change the logicals back to MAINT(*IMMED).

I used OPNDBF with OPTION(*INP) against each logical file after
changing it back to MAINT(*IMMED) to force the logical to be rebuilt
synchronously in the job.

Ken
Opinions expressed are my own and do not necessarily represent the views 
of my employer or anyone in their right mind.