IBM Mainframe Forum

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?

Hi,

Check about "Parallelism with the LOAD utility".

Jaggz

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.