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

Products

• Database Analyzer (IMS Tools)
• Mainframe Configuration Manager for IMS for z/OS
• IMS TOOLS - MISC
• Compress Data Compression (IMS Tools)
• Database Analyzer for IMS for z/OS
• Database Copier for IMS for z/OS
• Database Organizer for IMS for z/OS
• Mainframe Extended Terminal Manager (IMS Tools)
• High Performance Recovery for IMS for z/OS
• Database Organizer (IMS Tools)
• Mainframe Program Restart Manager for IMS for z/OS
• Secondary Index Builder for IMS for z/OS
• Secondary Index for IMS for z/OS

Issue/Introduction

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

 

Environment

Release:
Component: DBO

Resolution

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