Did you know that segment types easily can be removed from an IMS database using CA Database Organizer?

Document ID : KB000013107
Last Modified Date : 14/02/2018
Show Technical Document Details
Question:

How can segment types be removed from IMS databases using CA Database Organizer?

 

Answer:

These steps can be used to easily delete one or more segment types from an IMS database:

 

-  Run DBO Unload for the database using option DROPSEGMENT=(segname-1,...,segname-n)

              =>  all segment types being used in option DROPSEGMENT will not be written to the unload dataset

 

-  Change the DBD removing all segment types which are not needed anymore and re-gen DBD, PSB and ACB modules

 

-  Run DBO Reload using the new DBD and option DBDCHANGE=YES

              =>  DBO Reload checks the unload file header record and recognizes that one or more segments types are

                     missing on the new DBD; using option DBDCHANGE=YES allows DBO Reload to continue loading the

                     data to the changed database