How does one reorg an HDAM IMS database when changing RAPS
(Root Anchor Points)?
Answers were Sorted based on User's Feedback
Answer / david
image that baby FIRST to keep what you have! then follow the
steps listed in the first answer.
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / s
1.Unload the DB
2.Delete/Define Database Datasets (if space allocation
needs to be changed make necessary changes)
3.Change the DBD to calculate how many RAPS is needed.
RAPS is the number of DB records that can be stored in a
Block, say 8KB Blocksize. Say you have 1000 byte records
and 16,000 records 8*1024/1000= 8. Relative Block Number
(RBN) is the number of blocks in the Root addressable area
= 16000/8 = 2000. Add some % to these blocks as free space,
say 2500.
Make changes to DBD. RMNAME(DFSHDC40,8,2500)
4.Reload DB with new DBD.
5.Use other utilities to rebuild logical relationships and
secondary indices.
6.Image Copy the DB.
| Is This Answer Correct ? | 1 Yes | 2 No |
What is the difference between SIBLINGS and TWINS in IMS-DB database
Explain the two ways in which dl/i interface can be invoked?
Which command code can be used for backing up IMS database?
Can a variable length segment be declared in IMS? If yes, what is the structure; If no, why?
What is the maximum number of segment types allowed for a single database?
What are the two types of fields available in ims db?
Explain the maximum of key fields and search fields allowed in a segment?
What is Hierarchy Chart?
Which DB access method (OSAM or VSAM) is better and why?
What is the limitation on the no. of levels in a DL/I database?
Define psb?
What is dbd?