Re: Converting large amount of data [PRIVATE REPLY]

DSPFD {file} TYPE(*ACCPTH) shows the index maintenance property. CHGPF
really simplifies the process *if you can use it*. ALTER TABLE offers the
same benefits, with one exception: there's no support for edit codes. I
define my dollar fields with the O edit code, thanks to DDS. Getting your
column headings right is a PITA but it can be done.

When I changed from packed(7) to DATE in large tables with 100 logicals, I
did this:
1. An ALTER TABLE to add a new dummy DATE field at the end of the file.
2. SQL and stored procedure (or RPG program) to convert the CYYMMDD data to
YYYY-MM-DD.
3. ALTER TABLE to drop the original field.
4. ALTER TABLE to create a new DATE-type field using the original field
name.
5. SQL update to copy data from dummy field into original field-name field
(now a DATE field)
6. ALTER TABLE to drop dummy date field.

It's a lot of work for one field but it can be scripted. I wrote a program
to convert CYYMMDD, HHMMSS, and HHMM dates/times to ISO. The biggest issue
is revising all the display files and reports.

If you have to change multiple columns, you can do multiple columns in each
of the six steps.

On Tue, Mar 9, 2021 at 4:06 PM <smith5646midrange@xxxxxxxxx> wrote:

After submitting some additional tests and closely watching the system,
what I found is that the OS hands the logicals off to the DBSERVxx jobs and
they rebuild the indexes.

I don’t know what this means to our conversion duration since they are not
rebuilt real time. Just because all of our data is converted doesn't mean
the system is done building indexes.



-----Original Message-----
From: smith5646midrange@xxxxxxxxx <smith5646midrange@xxxxxxxxx>
Sent: Tuesday, March 9, 2021 4:55 PM
To: 'Midrange Systems Technical Discussion' <midrange-l@xxxxxxxxxxxxxxxxxx

Subject: RE: Converting large amount of data [PRIVATE REPLY]

*immed

-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of
Charles Wilt
Sent: Tuesday, March 9, 2021 3:31 PM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: Converting large amount of data [PRIVATE REPLY]

Is the LF defined MAINT(*DLY) or MAINT(*REBLD)?

That would explain it..

Charles

On Tue, Mar 9, 2021 at 1:10 PM <smith5646midrange@xxxxxxxxx> wrote:

I’m resurrecting this old post because I have a problem.



We have rewritten our conversion to use CHGPF where we can. Today
someone tried to DBU a logical file built over a huge physical (182M
records) and it took 15 minutes (this is a severely restricted
machine) and it said something about rebuilding the index.



I thought CHGPF updated the indexes while it was running (excluding
the mismatched ones that we discussed earlier). We can’t use the
CHGPF if that is going to delay the normal processing the first time
that it tries to use the index.



Is there something I missed in all of this?

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


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