LOAD Question

Mohammed Nayeem

LOAD Question
Hi

Is LOAD DATA INTO TABLE1 PART integer RESUME yes REPLACE ...........
replaces data from that particular partition or it replaces entire data from the
Tablepsace????
I need to replace data only in one partition and data exist in other
partitions too which
I wanted it to be remain as it is. Any Idea???

I appreciate your sugestion.

Thanks
Nayeem



Mohammed Nayeem

Re: LOAD Question
(in response to Mohammed Nayeem)




Thanks Philip


I am using following Syntax for Load command :

LOAD DATA LOG NO INDDN SYSREC00 SORTKEYS
SORTDEVT SYSDA SORTNUM 4 INTO TABLE TTTTTTTT
PART 27 RESUME YES REPLACE

Will this syntax replaces part 27 or entire TS???


Regards
Nayeem
---------------------- Forwarded by Mohammed Nayeem/MoMedicaid/US on 01/03/2001
09:17 AM ---------------------------


Philip Gunning <[login to unmask email]> on 01/03/2001 09:15:10 AM

To: Mohammed [login to unmask email]
cc:

Subject: RE: LOAD Question



Mohammed, You can just replace a partition. Make sure you have the part in
the right place (syntax) else you can wipe out the entire tablespace. --
Phil

-----Original Message-----
From: Mohammed Nayeem
To: [login to unmask email]
Sent: 1/3/01 7:08 AM
Subject: LOAD Question

Hi

Is LOAD DATA INTO TABLE1 PART integer RESUME yes REPLACE
...........
replaces data from that particular partition or it replaces entire data
from the
Tablepsace????
I need to replace data only in one partition and data exist in other
partitions too which
I wanted it to be remain as it is. Any Idea???

I appreciate your sugestion.

Thanks
Nayeem



the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list
can

Olle Nyman

Re: LOAD Question
(in response to Mohammed Nayeem)
Hi Mohammed!

It only replaces data in that particular partition! However, you can ignore the RESUME yes parameter, since it takes a lock on the entire tablespace and not only on the partition you want to replace.

Hope this helps!

/Olle





Mohammed Nayeem <[login to unmask email]>@RYCI.COM> on 2001-01-03 16:08:07

Please respond to DB2 Data Base Discussion List <[login to unmask email]>

Sent by: DB2 Data Base Discussion List <[login to unmask email]>


To: [login to unmask email]
cc:

Subject: LOAD Question


Hi

Is LOAD DATA INTO TABLE1 PART integer RESUME yes REPLACE ...........
replaces data from that particular partition or it replaces entire data from the
Tablepsace????
I need to replace data only in one partition and data exist in other
partitions too which
I wanted it to be remain as it is. Any Idea???

I appreciate your sugestion.

Thanks
Nayeem






Chris Blaicher

Re: LOAD Question
(in response to Olle Nyman)
A slight change to the syntax to make it clearer.

LOAD DATA RESUME YES INTO TABLE1 PART nnn REPLACE ........

As with anything you do, test it first in a test environment. Destroying a
production table because you did not test it first is no way to get ahead in
a company.

Chris Blaicher
BMC Software, Inc.
Austin Research Labs
[login to unmask email]

-----Original Message-----
From: Mohammed Nayeem [mailto:[login to unmask email]
Sent: Wednesday, January 03, 2001 9:08 AM
To: [login to unmask email]
Subject: LOAD Question


Hi

Is LOAD DATA INTO TABLE1 PART integer RESUME yes REPLACE ...........
replaces data from that particular partition or it replaces entire data from
the
Tablepsace????
I need to replace data only in one partition and data exist in other
partitions too which
I wanted it to be remain as it is. Any Idea???

I appreciate your sugestion.

Thanks
Nayeem








John Arbogast

Re: LOAD Question
(in response to Chris Blaicher)
Aren't Resume and Replace opposites? Code one or the other, not both. A
load replace of a partition deletes the data from that partition only.


-----Original Message-----
From: [login to unmask email] [mailto:[login to unmask email]
Sent: Wednesday, January 03, 2001 9:43 AM
To: [login to unmask email]
Subject: Re: LOAD Question


A slight change to the syntax to make it clearer.

LOAD DATA RESUME YES INTO TABLE1 PART nnn REPLACE ........

As with anything you do, test it first in a test environment. Destroying a
production table because you did not test it first is no way to get ahead in
a company.

Chris Blaicher
BMC Software, Inc.
Austin Research Labs
[login to unmask email]

-----Original Message-----
From: Mohammed Nayeem [mailto:[login to unmask email]
Sent: Wednesday, January 03, 2001 9:08 AM
To: [login to unmask email]
Subject: LOAD Question


Hi

Is LOAD DATA INTO TABLE1 PART integer RESUME yes REPLACE ...........
replaces data from that particular partition or it replaces entire data from
the
Tablepsace????
I need to replace data only in one partition and data exist in other
partitions too which
I wanted it to be remain as it is. Any Idea???

I appreciate your sugestion.

Thanks
Nayeem










Harold Lee

Re: LOAD Question
(in response to John Arbogast)
Here is the syntax I use and have used with no problems:

LOAD DATA
LOG NO
ENFORCE NO
INDDN SYSREC00
INTO TABLE tablename
PART 1 REPLACE

This will load partition 1 only and not effect the others.

Duane

> -----Original Message-----
> From: Blaicher, Chris [SMTP:[login to unmask email]
> Sent: Wednesday, January 03, 2001 8:43 AM
> To: [login to unmask email]
> Subject: Re: LOAD Question
>
> A slight change to the syntax to make it clearer.
>
> LOAD DATA RESUME YES INTO TABLE1 PART nnn REPLACE ........
>
> As with anything you do, test it first in a test environment. Destroying
> a
> production table because you did not test it first is no way to get ahead
> in
> a company.
>
> Chris Blaicher
> BMC Software, Inc.
> Austin Research Labs
> [login to unmask email]
>
> -----Original Message-----
> From: Mohammed Nayeem [mailto:[login to unmask email]
> Sent: Wednesday, January 03, 2001 9:08 AM
> To: [login to unmask email]
> Subject: LOAD Question
>
>
> Hi
>
> Is LOAD DATA INTO TABLE1 PART integer RESUME yes REPLACE ...........
> replaces data from that particular partition or it replaces entire data
> from
> the
> Tablepsace????
> I need to replace data only in one partition and data exist in other
> partitions too which
> I wanted it to be remain as it is. Any Idea???
>
> I appreciate your sugestion.
>
> Thanks
> Nayeem
>
>
>
> the
>
>
>
>
>
>
> .



Andrew Laredo

Re: LOAD Question
(in response to Harold Lee)
Should we assume you're not speaking from experience...

-----Original Message-----
From: Blaicher, Chris [mailto:[login to unmask email]
Sent: Wednesday, January 03, 2001 10:43 AM
To: [login to unmask email]
Subject: Re: LOAD Question


A slight change to the syntax to make it clearer.

LOAD DATA RESUME YES INTO TABLE1 PART nnn REPLACE ........

As with anything you do, test it first in a test environment. Destroying a
production table because you did not test it first is no way to get ahead in
a company.

Chris Blaicher
BMC Software, Inc.
Austin Research Labs
[login to unmask email]

-----Original Message-----
From: Mohammed Nayeem [mailto:[login to unmask email]
Sent: Wednesday, January 03, 2001 9:08 AM
To: [login to unmask email]
Subject: LOAD Question


Hi

Is LOAD DATA INTO TABLE1 PART integer RESUME yes REPLACE ...........
replaces data from that particular partition or it replaces entire data from
the
Tablepsace????
I need to replace data only in one partition and data exist in other
partitions too which
I wanted it to be remain as it is. Any Idea???

I appreciate your sugestion.

Thanks
Nayeem