Page 1 of 1

Problem in loading data using DSNUTILB

PostPosted: Fri Aug 17, 2012 12:39 pm
by pichi1234
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?

Re: Problem in loading data using DSNUTILB

PostPosted: Fri Aug 17, 2012 4:23 pm
by jaggz
Hi,

Check about "Parallelism with the LOAD utility".

Jaggz

Re: Problem in loading data using DSNUTILB

PostPosted: Fri Aug 17, 2012 9:02 pm
by NicC
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.