|
View previous topic :: View next topic
|
| Author |
Message |
ashek15
New User
Joined: 20 Oct 2015
Posts: 48
Location: USA
|
|
|
|
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 |
|
 |
Robert Sample
Global Moderator
Joined: 06 Jun 2008
Posts: 8696
Location: Dubuque, Iowa, USA
|
|
|
|
| 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 |
|
|
ashek15
New User
Joined: 20 Oct 2015
Posts: 48
Location: USA
|
|
|
|
| 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 |
|
|
Robert Sample
Global Moderator
Joined: 06 Jun 2008
Posts: 8696
Location: Dubuque, Iowa, USA
|
|
|
|
| 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 |
|
|
ashek15
New User
Joined: 20 Oct 2015
Posts: 48
Location: USA
|
|
|
|
| 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 |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007
Posts: 10873
Location: italy
|
|
|
|
| most probably the info You look for is available in the RECON datasets |
|
| Back to top |
|
|
PeterHolland
Global Moderator
Joined: 27 Oct 2009
Posts: 2481
Location: Netherlands, Amstelveen
|
|
|
|
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 |
|
|
ashek15
New User
Joined: 20 Oct 2015
Posts: 48
Location: USA
|
|
|
|
Hi Enrico, Peter
Thanks for suggestions! Is there a way to query RECON datasets to gather backup info? Thanks |
|
| Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007
Posts: 10873
Location: italy
|
|
|
|
| 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 |
|
|
ashek15
New User
Joined: 20 Oct 2015
Posts: 48
Location: USA
|
|
|
|
| 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 |
|
|
PeterHolland
Global Moderator
Joined: 27 Oct 2009
Posts: 2481
Location: Netherlands, Amstelveen
|
|
|
|
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 |
|
|
ashek15
New User
Joined: 20 Oct 2015
Posts: 48
Location: USA
|
|
|
|
| Thanks Peter. I will explore more on LIST.RECON. |
|
| Back to top |
|
|
Gary Jacek
New User
Joined: 17 Dec 2007
Posts: 64
Location: Victoria, BC, Canada
|
|
|
|
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 |
|
|
PeterHolland
Global Moderator
Joined: 27 Oct 2009
Posts: 2481
Location: Netherlands, Amstelveen
|
|
|
|
| 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 |
|
|
Gary Jacek
New User
Joined: 17 Dec 2007
Posts: 64
Location: Victoria, BC, Canada
|
|
|
|
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 |
|
|
|
|
