How does one reorg an HDAM IMS database when cha

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

How does one reorg an HDAM IMS database when changing RAPS ( ROOT ANCHOR POINTS )?

1. Unload data using current DBD
2. Delete/define the underlying VSAM dataset(s).
3. Re-load data using newly-defined DBD with new RAPs
4. Re-build any secondary indexes.

(Continued on next question...)

Other Job Interview Questions

• What is a database record?
• What is secondary indexing
• What are common status codes that you come across?
• What is a database record?
• Is it neccessary that all the segments in a DI/i database have key fields?
• What is secondary indexing
• How many segment types can you have in a DL/I database?
• What is the physical nature of a database called?
• What do you know about DBDGEN?
• What is multi positioning
• More...