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
 

 

RAPSORT - to speed up HDAM load

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

New User


Joined: 08 Feb 2008
Posts: 46
Location: Dublin

PostPosted: Tue Feb 10, 2009 9:06 pm    Post subject: RAPSORT - to speed up HDAM load
Reply with quote

Anybody used this before:

If processing large HDAM or DEDB databases
then sorting the driving input into the same
physical sequence as the DB will significantly
improve performance. This process is often
referred to as a RAPSORT and is simply an inhouse
utility that reads the input file, gets the
DB key and invokes the appropriate IMS
randomiser to get the physical offset in the
DB, and then creates an output file with each
record prefixed by the physical offset value.

This file is then sorted in the order of the
physical offset, striping the offset. The new
input file is now in the same order physically
as the DB.
Back to top
View user's profile Send private message

Sandy Zimmer

Active Member


Joined: 13 Jun 2007
Posts: 826
Location: Wilmington, DE

PostPosted: Wed Feb 11, 2009 5:55 pm    Post subject:
Reply with quote

Quote:
RAPSORT and is simply an inhouse utility


We would not have experience with this unless we were there. If you try to LOAD a keyed database out of sequence, the LOAD will not work. HDAM does not have a separate index, but it is keyed. I always just used syncsort - any external sort will work - sorted the input file in key sequence and then ran the load.
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 Can DFSPARM override SORTKEYS paramet... ashek15 DB2 2 Tue Jan 31, 2017 11:36 pm
No new posts Need Rexx Program to Load in to DB2 T... Hareesh Verma CLIST & REXX 22 Tue Sep 20, 2016 2:59 pm
No new posts Copybook structure in Load module Vai123 COBOL Programming 7 Fri Sep 16, 2016 8:29 pm
This topic is locked: you cannot edit posts or make replies. ERROR WHILE SUBMITTING LOAD JOB ANURADHA NEELAKANTAN JCL & VSAM 12 Thu Aug 25, 2016 11:50 am
No new posts Execute multiple DB2 Load commands in... faizm DB2 4 Wed Aug 03, 2016 12:53 pm


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