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 Database backup info

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

New User


Joined: 20 Oct 2015
Posts: 6
Location: USA

PostPosted: Wed Nov 16, 2016 5:29 am    Post subject: IMS Database backup info
Reply with quote

Dear All

We have a requirement where-in we need to get info/report on successful and failed backups of IMS databases on daily basis. Kindly let me know how to go about this. Thanks in advance.

Regards
Abhishek
Back to top
View user's profile Send private message

Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 7913
Location: Bellevue, IA

PostPosted: Wed Nov 16, 2016 6:00 am    Post subject:
Reply with quote

Most scheduling software allows for notification of job completions (both successes and failures). Contact your site support group and work with them to get the appropriate notifications set up in your scheduling software.
Back to top
View user's profile Send private message
ashek15

New User


Joined: 20 Oct 2015
Posts: 6
Location: USA

PostPosted: Wed Nov 16, 2016 6:18 am    Post subject: Reply to: IMS Database backup info
Reply with quote

Hi Robert - Are you referring to notification when a backup jcl completes/fails? We already have that mechanism in place. I am actually looking for options similar to querying a DB2 catalog table SYSIBM.SYSCOPY for backup info for DB2. Can similar info be gathered from DBRC etc?
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 7913
Location: Bellevue, IA

PostPosted: Wed Nov 16, 2016 6:49 am    Post subject:
Reply with quote

Perhaps you should make up your mind what you want to know BEFORE you post a query? Your title talks about IMS; your last post talks about DB2. You can do things in DB2 you cannot do in IMS and vice versa. Comparing their capabilities is rarely a worthwhile exercise.
Back to top
View user's profile Send private message
ashek15

New User


Joined: 20 Oct 2015
Posts: 6
Location: USA

PostPosted: Wed Nov 16, 2016 10:02 am    Post subject: Reply to: IMS Database backup info
Reply with quote

I just gave reference of DB2 to explain what I am looking for. I am aware that IMS and DB2 are completely different. But my query is purely related to IMS.
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10202
Location: italy

PostPosted: Wed Nov 16, 2016 12:12 pm    Post subject: Reply to: IMS Database backup info
Reply with quote

most probably the info You look for is available in the RECON datasets
Back to top
View user's profile Send private message
PeterHolland

Global Moderator


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

PostPosted: Wed Nov 16, 2016 12:17 pm    Post subject:
Reply with quote

If you have some kind of automation that traps messages you could look for the following messages (probably not complete list) :

DFS3144A
DFS3726A
DFS3145A
DFS0300I
IMS abend 0225
Back to top
View user's profile Send private message
ashek15

New User


Joined: 20 Oct 2015
Posts: 6
Location: USA

PostPosted: Wed Nov 16, 2016 11:37 pm    Post subject:
Reply with quote

Hi Enrico, Peter

Thanks for suggestions! Is there a way to query RECON datasets to gather backup info? Thanks
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10202
Location: italy

PostPosted: Thu Nov 17, 2016 2:00 am    Post subject: Reply to: IMS Database backup info
Reply with quote

Quote:
Is there a way to query RECON datasets to gather backup info? Thanks


why not take a look at the manual Yourself ?
Back to top
View user's profile Send private message
ashek15

New User


Joined: 20 Oct 2015
Posts: 6
Location: USA

PostPosted: Thu Nov 17, 2016 2:46 am    Post subject: Reply to: IMS Database backup info
Reply with quote

Enrico - Thanks for your reply. I already searched manuals before putting this post, but could not find anything. That's why posted the query.
Back to top
View user's profile Send private message
PeterHolland

Global Moderator


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

PostPosted: Thu Nov 17, 2016 10:27 am    Post subject:
Reply with quote

There are LIST RECON commands. Documented in the manuals.

The RECON contains info about image copy datasets, but no info about failed image copy runs. This is also described in the manuals.
Back to top
View user's profile Send private message
ashek15

New User


Joined: 20 Oct 2015
Posts: 6
Location: USA

PostPosted: Fri Nov 18, 2016 7:50 am    Post subject: Reply to: IMS Database backup info
Reply with quote

Thanks Peter. I will explore more on LIST.RECON.
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 Nov 19, 2016 2:45 am    Post subject:
Reply with quote

There is also a DBRC API available. I would recommend this approach.

LIST.RECON report output may change in new releases.
If you use a program to parse the LIST.RECON report, said new releases may break your extract program.
Back to top
View user's profile Send private message
PeterHolland

Global Moderator


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

PostPosted: Sat Nov 19, 2016 12:57 pm    Post subject:
Reply with quote

Quote:
There is also a DBRC API available. I would recommend this approach.


That API doesn't accept LIST commands.

Beside that, the RECON contains no information about failed/succeeded IC's.
Only timestamps.

I don't understand why the TS/OP is looking for something that is different from the working scheduler solution.
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: Sun Nov 20, 2016 11:26 am    Post subject:
Reply with quote

Correct, the DBRC API does not support LIST.

However it does support for example, QUERY TYPE=DB as well as other query types.

That said, I would still expect my job scheduling subsystem (ESP, Control-M...) to tag failed Image Copy jobs for attention.
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 Getting list of tables defined under ... kishpra DB2 2 Wed Aug 24, 2016 10:36 am
No new posts Need help on FDRABR incremental backu... sanpedro All Other Mainframe Topics 6 Wed Apr 06, 2016 3:24 am
No new posts Database access from COBOL amitmahalkar DB2 1 Wed Jan 27, 2016 11:33 am
No new posts Utility to extract dsn info from conc... Lynne Schuler PL/I & Assembler 11 Tue Jan 26, 2016 6:36 am
No new posts Backup directory in USS (OMVS) autobox IBM Tools 3 Tue Jan 12, 2016 8:51 am


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