Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist 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 Db2 load job abending in SORT mistah kurtz DB2 4 Mon Jun 05, 2017 3:58 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 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

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us