ykishor Currently Banned New User
Joined: 11 Aug 2007 Posts: 24 Location: my pc
|
|
|
|
Hi
I have defined a partitioned tablespace with 6 partitions. I have used table partitioning instead of index partitioning. The table does not have any referential constraints,only a few NOT NULL constraints. Part of table DDL is given below.
-------table DDL-------------------------
PARTITION BY (BR)
(PARTITION 1 ENDING AT (8),
PARTITION 2 ENDING AT (16),
PARTITION 3 ENDING AT (24),
PARTITION 4 ENDING AT (32),
PARTITION 5 ENDING AT (40),
PARTITION 6 ENDING AT (999))
--------------------------------------------
BR can have any value between 1-999
INDEX DDL is given below
---------------------------------------------
SET CURRENT SQLID ='xxxxx';
CREATE UNIQUE INDEX "yyyyyy"."zzzzz"
ON "xxxxx"."ANMST"
("BK" ASC<possible values 700,704,720,800>
,"BR" ASC
,"CUS" ASC
,"LN" ASC
)
USING STOGROUP "STOISST2" PRIQTY 48000 SECQTY 4000
FREEPAGE 0 PCTFREE 10
CLUSTER
BUFFERPOOL BP2
CLOSE YES COPY NO;
-------------------------------------------------------------
While using LOAD replace I am getting the following error message
----
DSNU255I DSNURSIX - KEY COUNT INCONSISTENT FOR SORT-RD PHASE, NUMBER OF KEYS EXPECTED =4063100, NUMBER OF KEYS PROCESSED=2669406
SNU016I DSNUGBAC - UTILITY BATCH MEMORY EXECUTION ABENDED, REASON=X'00E4030A'
-----
--------------LOAD--used--------
LOAD DATA
LOG(NO)
KEEPDICTIONARY
REPLACE
SORTDEVT SYSDA
SORTNUM 4
STATISTICS TABLE(ALL) INDEX(ALL KEYCARD) REPORT YES UPDATE ALL
-------------------------------
Please help.
Thanks
yugal |
|