Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

IMS DB Structural Changes Identification

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> IMS DB/DC
View previous topic :: :: View next topic  
Author Message
Bharath RajaramSridharan

New User


Joined: 10 Dec 2012
Posts: 20
Location: Australia

PostPosted: Mon Sep 15, 2014 9:09 am    Post subject: IMS DB Structural Changes Identification
Reply with quote

Hi,

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.

Thanks!
Back to top
View user's profile Send private message

enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10202
Location: italy

PostPosted: Mon Sep 15, 2014 12:28 pm    Post subject: Reply to: IMS DB Structural Changes Identification
Reply with quote

Quote:
we would like to get notified whenever the DBA's change the structure of the IMS DB.


changing the structure of an IMS DB is not something that gets done every day,
usually there are business reasons for the change and a paper trail which documents it.

ask to be put on the distribution list .
Back to top
View user's profile Send private message
Ed Goodman

Active Member


Joined: 08 Jun 2011
Posts: 556
Location: USA

PostPosted: Mon Sep 15, 2014 7:01 pm    Post subject:
Reply with quote

There are IBM and third party utilities that will "decode" the IMS DBD and PSB library entries. You could run them and compare the outputs.
Back to top
View user's profile Send private message
Rohit Umarjikar

Senior Member


Joined: 21 Sep 2010
Posts: 1610
Location: NY,USA

PostPosted: Mon Sep 15, 2014 7:46 pm    Post subject:
Reply with quote

What happens when you change the DB? If you change the programs or any other modules then set up a dependant job which sends You/DL email regarding these changes.
Back to top
View user's profile Send private message
Gary Jacek

New User


Joined: 17 Dec 2007
Posts: 44
Location: Victoria, BC, Canada

PostPosted: Tue Sep 16, 2014 4:52 am    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> IMS DB/DC All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Identification Division anandgbe COBOL Programming 2 Sat May 28, 2016 11:51 am
No new posts DD Name identification Pedro CLIST & REXX 11 Wed Aug 22, 2012 12:15 pm
No new posts Handling WildChar '*' for MEMBER id... rajatbagga CLIST & REXX 12 Wed Jun 06, 2012 12:04 pm
No new posts Zoned Decimal identification meenakshi_forum COBOL Programming 3 Tue Feb 02, 2010 2:49 am
No new posts Query Identification- nested, subquer... Sudeshna Sarkar Mainframe Interview Questions 1 Tue Aug 25, 2009 1:24 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us