Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

LOAD REPLACE-ABEND S04E

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
ykishor
Currently Banned

New User


Joined: 11 Aug 2007
Posts: 24
Location: my pc

PostPosted: Sat Feb 14, 2009 5:10 pm    Post subject: LOAD REPLACE-ABEND S04E
Reply with quote

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
Back to top
View user's profile Send private message

ykishor
Currently Banned

New User


Joined: 11 Aug 2007
Posts: 24
Location: my pc

PostPosted: Sat Feb 21, 2009 10:38 am    Post subject:
Reply with quote

Finally ,I got it.....

there was a memory overflow prblem...that is why it was not able to SORT and LOAD the entire table.....

The culprit was
STATISTICS TABLE(ALL) INDEX(ALL KEYCARD) REPORT YES UPDATE ALL

this is taking a lot of time and consumes a lot of CPU.....any ideas how to update stats differently.....

will this work better in a segmented tablespace....
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Fileaid Update Replace with null string descann Compuware & Other Tools 4 Mon May 15, 2017 3:00 pm
No new posts Replace values in the input data Vikas Maharnawar DFSORT/ICETOOL 10 Thu May 11, 2017 2:18 pm
No new posts Cobol upgrade - source code missing f... gthmrj IBM Tools 1 Wed Apr 26, 2017 6:04 pm
No new posts Copy load modules and alias vasanthz IBM Tools 5 Thu Apr 20, 2017 6:31 am
No new posts IMS region inactive - User abend code... gthmrj IMS DB/DC 5 Tue Mar 07, 2017 12:29 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us