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
 

 

why DFSHDC40 Randomizer module is so much slow?

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> IMS DB/DC
View previous topic :: :: View next topic  
Author Message
Pepero2k3

New User


Joined: 07 Sep 2008
Posts: 7
Location: Iran

PostPosted: Mon Sep 08, 2008 5:00 pm    Post subject: why DFSHDC40 Randomizer module is so much slow?
Reply with quote

On an online environment I've a HDAM DBD in which 80% of all my operations on it is the insertion.
In the 20% remainder i read it qualify(qualify GU).
Also the Key is a character string with the total length of 33 bytes.
The total number of the database records would be 5,000,000 records in a day.
I've considered the Os access method as OSAM and the database block size of 4k. The HDAM related parameters in the DBD definition is as follows :
DBD NAME=RETDTLRI,ACCESS=(HDAM,OSAM),
RMNAME=(DFSHDC40,20,100000,),PASSWD=NO
DATASET DD1=RETDTLRI,DEVICE=3390,SIZE=4096,SCAN=3
SEGM NAME=TLRINFO,BYTES=60
FIELD NAME=(TLRKEY,SEQ,U),BYTES=33,START=1,TYPE=C
DBDGEN
FINISH
END
The problem is that the insertion operation is so much slow.
what shall i do?
Back to top
View user's profile Send private message

Bitneuker

CICS Moderator


Joined: 07 Nov 2005
Posts: 1105
Location: The Netherlands at Hole 19

PostPosted: Tue Sep 09, 2008 12:19 am    Post subject:
Reply with quote

Are the keys to be inserted in sorted order?
Back to top
View user's profile Send private message
Pepero2k3

New User


Joined: 07 Sep 2008
Posts: 7
Location: Iran

PostPosted: Tue Sep 09, 2008 8:48 am    Post subject: why DFSHDC40 Randomizer module is so much slow?
Reply with quote

Hi
The insertions take place in a high rated online transaction based environment. But the interesting subject is that in an empty databse with a single insertion transaction the response time is undesirable.
I've an experience with the following parameters
RMNAME=(DFSHDC40,5,400000,),PASSWD=NO
DATASET DD1=RETDTLRI,DEVICE=3390,SIZE=1024,SCAN=3
but the problem was still alive.
But when i use the DFSHDC10 instead the insertion response time would be desirable. But due to the key length i cannot use the DFSHDC10.
Back to top
View user's profile Send private message
Mistermind
Warnings : 2

New User


Joined: 08 Feb 2008
Posts: 46
Location: Dublin

PostPosted: Wed Feb 04, 2009 8:23 pm    Post subject:
Reply with quote

What was the keylength limit on DFSHDC10?
Have you speede up now?
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 -> IMS DB/DC All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Copybook structure in Load module Vai123 COBOL Programming 7 Fri Sep 16, 2016 8:29 pm
No new posts How to get the program name of callin... pkmurali COBOL Programming 8 Mon Aug 01, 2016 3:36 am
No new posts Search a Load Module sreekanth1984 TSO/ISPF 8 Tue Jun 07, 2016 8:45 pm
No new posts user abend 4038 occurred in module CE... Musab Ahmed PL/I & Assembler 1 Wed Mar 30, 2016 10:49 am
No new posts CEE3501S The module DSNHADDR was not ... Sayan Bhattacharyya ABENDS & Debugging 11 Tue Oct 20, 2015 3:53 pm


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