In the site that am currently working, we have lot of IMS DB. I am working as part of the SIT Environments team where we would like to get notified whenever the DBA's change the structure of the IMS DB.
How can I automatically build a system which I will notify me the changes. Any pointers will help me develop such automation.
Joined: 17 Dec 2007 Posts: 55 Location: Victoria, BC, Canada
If you use traditional IMS MPP or BMP programs, then the DBAs who manage IMS databases must perform DBDGEN, possibly PSBGEN and ACBGEN whenever they make structural changes to IMS databases. These same DBAs will generally be updating the COPYBOOK members that map the database segments, whenever they make a change.
BMP and MPP applications are somewhat insulated from these very infrequent changes. You may have to recompile if a COPYBOOK member is changed. If a segment your program uses is dropped, well you have bigger problems.
If on the other hand, you are using other tools to look at IMS data, then I have four suggestions:
1. If you are not already there, upgrade to IMS V12 or V13. (V11 goes out of support at the end of October this year)
2. On V12 or V13, enable and use DFS3PU00 to populate the IMS Catalog. Then have your DBAs update their ACBGEN processes to use DFS3UACB to keep the IMS Catalog updated.
3. IMS Catalog contains all the metadata about the databases and segments in IMS. You should use the IMS Catalog tooling to import field level information into the IMS Catalog from PLI structures or COBOL COPYBOOKS. In this way, data about the data, is kept right on IMS where it can be kept in sync.
4. Go out to your vendors and ask them when they will support the IMS Catalog, rather than making you re-key metadata about IMS databases. And start using IMS Enterprise Suite to see how you can get at IMS data and IMS metadata via the JDBC interface.
IMS Catalog is the next big thing. It has huge potential.