Re: Replacing records in a large file (1M+ records)

[Jeff Young <jyoung0950@xxxxxxxxx>]

A further clarification of this issue.
I have a file with well over 1M records that has a trigger assigned to it.
For some unknown reason (most likely an internal IBM glitch), the Trigger
Name and Trigger Library values are missing when viewing the DSPFD
option(*TRG).  The Trigger Program and library are still there and the
trigger program is properly called when a record is changed.
The problem is that the HA software that my client uses does not see the
trigger attached to the file and as a result has removed the trigger from
the backup server.
The client wants to recreate the file from a copy in their TEST environment
which has all the proper information.
Once the file is recreated in their Production environment, they need to
copy all the data from the "old" file.
I am attempting to determine what the fastest method would be.

Thanks,



On Mon, Sep 9, 2013 at 3:43 PM, <rob@xxxxxxxxx> wrote:

> IDK if, since it is an identical file, if it would perform faster to do a
> CREATE TABLE NEWTABLE AS (SELECT * FROM OLDTABLE) WITH DATA
> vs
> INSERT INTO NEWTABLE VALUES (SELECT * FROM OLDTABLE)
>
>
> Rob Berendt
> --
> IBM Certified System Administrator - IBM i 6.1
> Group Dekko
> Dept 1600
> Mail to:  2505 Dekko Drive
>           Garrett, IN 46738
> Ship to:  Dock 108
>           6928N 400E
>           Kendallville, IN 46755
> http://www.dekko.com
>
>
>
>
>
> From:   "Needles,Stephen J" <SNEEDLES@xxxxxxxxxxxxxxxx>
> To:     Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>,
> Date:   09/09/2013 03:28 PM
> Subject:        RE: Replacing records in a large file (1M+ records)
> Sent by:        midrange-l-bounces@xxxxxxxxxxxx
>
>
>
> If no format changes between the files...I'd probably use CRTDUPOBJ with
> DATA(*YES) or SAV/RST operations.
>
> If you are mapping, then I think it would be a toss-up for me between CPYF
> using the MAP options and SQL INSERT.
>
> Steve Needles
>
>
> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx [
> mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Jeff Young
> Sent: Monday, September 09, 2013 1:32 PM
> To: Midrange Systems Technical Discussion
> Subject: Replacing records in a large file (1M+ records)
>
> All,
> I have a file that contains more that 1M records that I need to copy to an
> identical file that will be empty to start..
> Will it be faster using SQL INSERT or CPYF Fromrcd(1) ?
>
> Thanks,
> --
> Jeff Young
> Sr. Programmer Analyst
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
> unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
> moment to review the archives at http://archive.midrange.com/midrange-l.
>
> ________________________________
> This communication, including attachments, is confidential, may be subject
> to legal privileges, and is intended for the sole use of the addressee.
> Any use, duplication, disclosure or dissemination of this communication,
> other than by the addressee, is prohibited. If you have received this
> communication in error, please notify the sender immediately and delete or
> destroy this communication and all copies.
>
> TRVDiscDefault::1201
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
>
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.