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

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



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