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
 

 

Crash IMS database

 
Post new topic   This topic is locked: you cannot edit posts or make replies.    IBMMAINFRAMES.com Support Forums -> IMS DB/DC
View previous topic :: :: View next topic  
Author Message
aprocon

New User


Joined: 26 Oct 2010
Posts: 41
Location: chennai

PostPosted: Fri Aug 17, 2012 10:08 am    Post subject: Crash IMS database
Reply with quote

Hi all

I would like to crash my own IMS - HIDAM test database and recover using recvovery procedures. The intent is to learn rthe process of recovery. Could you provide some suggestions please?


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

PeterHolland

Global Moderator


Joined: 27 Oct 2009
Posts: 2422
Location: Netherlands, Amstelveen

PostPosted: Fri Aug 17, 2012 12:59 pm    Post subject:
Reply with quote

http://ibmmainframes.com/about50065.html
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Fri Aug 17, 2012 4:30 pm    Post subject:
Reply with quote

If you search the word "crash" in IMS related IBM documentation, you'll hardly find anything. Since this morning I'd been trying to find it...

I'm not sure if there is some ready-made utility to do this. Possibly, write a COBOL program (if COBOL is your choice), which updates the DB in question, put in a delebrate abend - try to casue AI and or AO status code and now recover it.


PS.: This sounds intresting, I'll check if I can find out something later...
Back to top
View user's profile Send private message
aprocon

New User


Joined: 26 Oct 2010
Posts: 41
Location: chennai

PostPosted: Fri Aug 17, 2012 6:09 pm    Post subject: Reply to: Crash IMS database
Reply with quote

Thanks Anuj..

Please let me know if you find anything.

Thanks Peter!! It looks like cancelling an update job will do the work for me.. I will try that.
Back to top
View user's profile Send private message
don.leahy

Active Member


Joined: 06 Jul 2010
Posts: 641
Location: Whitby, ON, Canada

PostPosted: Fri Aug 17, 2012 6:51 pm    Post subject: Re: Reply to: Crash IMS database
Reply with quote

aprocon wrote:
Thanks Anuj..

Please let me know if you find anything.

Thanks Peter!! It looks like cancelling an update job will do the work for me.. I will try that.
Whoa! Be careful how you "cancel" the job (I am presuming it is a BMP). If you initiate the cancel via SDSF, and you are unlucky, you may crash your IMS control region. This will not go unnoticed, and you will receive an angry phone call from your DBA and/or IMS systems programmer. Do it more than once and your boss will receive an angry phone call from their boss.

Talk to your IMS support staff and ask them what the proper procedure is to cancel an active BMP.
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Fri Aug 17, 2012 6:58 pm    Post subject:
Reply with quote

Don has brought in a valid point, however, I was under the impression that the OP is IMS-DBA/IMS-System Programmer. S/he talked about "recovery procedures", as in the case of "disaster recovery". Scope for an Application programmer is usually check-point-restart... icon_neutral.gif
Back to top
View user's profile Send private message
Akatsukami

Global Moderator


Joined: 03 Oct 2009
Posts: 1738
Location: Bloomington, IL

PostPosted: Fri Aug 17, 2012 7:08 pm    Post subject:
Reply with quote

Anuj Dhawan wrote:
Don has brought in a valid point, however, I was under the impression that the OP is IMS-DBA/IMS-System Programmer. S/he talked about "recovery procedures", as in the case of "disaster recovery". Scope for an Application programmer is usually check-point-restart... icon_neutral.gif

I don't see how that follows; as an application programmer/analyst, I have been asked to do (low-level, to be sure) DBA-type activities, as creating and data bases, table spaces, etc., in the course of DR/BC exercises. If the person leading such an exercise told me, "We're going to corrupt a data base, and we want you to restore it", I wouldn't think of saying, "That's beyond my pay grade; get a DBA".
Back to top
View user's profile Send private message
aprocon

New User


Joined: 26 Oct 2010
Posts: 41
Location: chennai

PostPosted: Fri Aug 17, 2012 7:33 pm    Post subject: Reply to: Crash IMS database
Reply with quote

No Worries, I am a DBA.

Fortunately I know how to cancel a BMP job:)
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: Sat Aug 18, 2012 1:52 am    Post subject: Re: Crash IMS database
Reply with quote

The IVP that ships with the IMS product has a series of jobs that do exactly what you want to do.

Talk to the Systems Programmer who installed your most recent version of IMS to find out how you can start the IVP dialogue which generates the JCL and other control records that you need.

It is generally found under the IMSAPPL menu that is supplied by IBM.

aprocon wrote:
Hi all

I would like to crash my own IMS - HIDAM test database and recover using recvovery procedures. The intent is to learn rthe process of recovery. Could you provide some suggestions please?


Thanks in advance!!
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Sat Aug 18, 2012 10:44 am    Post subject:
Reply with quote

Akatsukami wrote:
I don't see how that follows; as an application programmer/analyst, I have been asked to do (low-level, to be sure) DBA-type activities, as creating and data bases, table spaces, etc.
Now that's the difference between the work-duties of an "application analyst" and a "software engineer"...icon_biggrin.gif
Back to top
View user's profile Send private message
antzel itay

New User


Joined: 16 Jul 2012
Posts: 1
Location: israel

PostPosted: Wed Feb 06, 2013 2:50 pm    Post subject: Reply to: Crash IMS database
Reply with quote

It's obvious that the IMS is a testing environment.
So I don't get what is the problem with performing cancel to the IMS region while on line transaction on the DB is running?
Is there another way to crash the IMS?
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   This topic is locked: you cannot edit posts or make replies.    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 IMS Database backup info ashek15 IMS DB/DC 14 Wed Nov 16, 2016 5:29 am
No new posts Getting list of tables defined under ... kishpra DB2 2 Wed Aug 24, 2016 10:36 am
No new posts Database access from COBOL amitmahalkar DB2 1 Wed Jan 27, 2016 11:33 am
No new posts Database backup on IMS DB HABBIE IMS DB/DC 1 Wed Aug 12, 2015 9:02 pm
No new posts Database name in Z/OS HABBIE DB2 6 Fri Aug 07, 2015 5:52 pm


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