Problem in loading data using DSNUTILB



IBM's flagship relational database management system

Problem in loading data using DSNUTILB

Postby pichi1234 » Fri Aug 17, 2012 12:39 pm

In our table, an index partitioning is done such that it supports the country number value range from (0-500 in PART 1) (501-999 IN PART 2)

Definition is given below

CREATE TYPE 2 UNIQUE INDEX RCBX075A
ON RCBT0075_SE_PO ( COUNTRY_NUMBER,
SERVICE_NUMBER)
CLUSTER
(PART 1 VALUES ('500','9'),
PART 2 VALUES ('999','9'))
USING STOGROUP RCBG01
PRIQTY 1
SECQTY 1
CLOSE NO;
COMMIT;

We are able to load a single partition at a time (without affecting the records in other partitions), but not multiple partitions in a single execution
OUTPUT START FOR UTILITY, UTILID = $USERID
PROCESSING SYSIN AS EBCDIC
LOAD
DATA
INDDN RCBLOAD
LOG YES
INTO TABLE
IN49160.RCBT0725_PICOS_HW
REPLACE PART 1:2
INVALID OPERAND '2' FOR KEYWORD 'INTO'
(COUNTRY_NUMBER POSITION (1) CHAR(3),
PRODUCT_TYPE POSITION (4) CHAR(4),
ORIGIN POSITION (8) CHAR(2),
SEQUENCE_NUMBER POSITION (10) CHAR(28))
UTILITY EXECUTION TERMINATED, HIGHEST RETURN CODE=8

We are able to specify PART1, PART2 separately in different job’s, but any idea how it can be achieved using a single job?
pichi1234
 
Posts: 1
Joined: Fri Aug 17, 2012 12:05 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Problem in loading data using DSNUTILB

Postby jaggz » Fri Aug 17, 2012 4:23 pm

Hi,

Check about "Parallelism with the LOAD utility".

Jaggz
User avatar
jaggz
 
Posts: 356
Joined: Fri Jul 23, 2010 8:51 pm
Has thanked: 8 times
Been thanked: 5 times

Re: Problem in loading data using DSNUTILB

Postby NicC » Fri Aug 17, 2012 9:02 pm

Welcome to the forum. One of the rules of the forum is that you post in the relevant section. Your post has not mentioned any JCL at all but does refer to DB2 table loads so it has been moved to the DB2 section of the forum.
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
NicC
Global moderator
 
Posts: 3025
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisies (almost)
Has thanked: 4 times
Been thanked: 136 times


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post