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

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.