MVSFORUMS.com

haseen_mohammed · Beginner Joined: 20 Feb 2006 Posts: 27 Topics: 14

Hi,

I have a table with two partitions. The data for these two partitions come in two seperate files and i have to load them seperately using two jobs which use BMCLOAD (load-replace).

When we load the first file to partition no 1 . it loads properly clearing the data . After that when I run the second job to load data to partition no 2 the entire data is gettin cleared out(which is loaded by first job) and only the data of partition no 2 will be present.

I know that this issue can be solved using load-resume for the second load job.But heard its less efficient since BMC will scan through the full table and IBM utility is better.

Is there anyway I can do a load-replace on a particular partition alone.

Any inputs on this will be of great help ...

TIA,
Haseen

kolusu · Posted: Fri Feb 16, 2007 7:23 am Post subject:

haseen_mohammed,

Did you specify the partition number in the load card?

ex:

haseen_mohammed · Beginner Joined: 20 Feb 2006 Posts: 27 Topics: 14

Hi,

Thanks for the response ...

One of my fren came up with a solution
LOAD DATA INDDN SYSREC RESUME YES LOG NO
COPY YES DISCARDS 1
INTO TABLE XXXXXX.TABLE_NAME PART 2

its workin now...

but just wanted to know the details.. wat each thing stands for..even he is not sure..

Is this using Load - Resume ?
It seems so..

If you can jus briefly tel me wat s t for ..it ll b of great help ..
Can you tel me if there is any efficiency difference..
Just curious...

Thanks a lot
Haseen

kolusu · Posted: Fri Feb 16, 2007 10:58 am Post subject:

haseen_mohammed,

check this link which explains all the options of LOAD

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/DSNUGH13/2.12.1.2?SHELF=&DT=20020826194002&CASE=

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

haseen_mohammed · Beginner Joined: 20 Feb 2006 Posts: 27 Topics: 14

Thanks a lot Kolusu