I am a Oracle/Unix developer and 99% of our mappings are AS400 to Oracle. I have no problem setting up the proper notification in this source/target environment. But we now have maps that are AS400 to AS400 and I am not getting the failure notifications I need. I have read the documentation about message queues but it is all a little fuzzy. Any information, snapshots or better documentation on how I can get emails of failures from iSeries would be appreciated. Thanks.
Pinned topic re: Help with Notifications from iSeries
2012-12-10T16:57:52Z | idr-cdc
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2016-08-14T15:43:43Z at 2016-08-14T15:43:43Z by Ken Motilall
Rphilo 2700013TF4558 Posts
Re: re: Help with Notifications from iSeries2012-12-11T06:31:53ZThis is the accepted answer. This is the accepted answer.HiYou will need to get the assistance of you AS/400 colleagues with this one. CDC on the iSeries does not generate email alerts directly (unlike the Java-based engines). The options you have in CDC are to send the messages either to a message queue (an object type for storing messages generated by applications, the system or users) or to a program.Your AS/400 colleagues will be able to tell you what monitoring they have in place on the iSeries, and it may be that what they have uses the message queue to determine that an error has occurred: the application sends an error message to a defined message queue and the monitoring product reads the message queue and forwards the message to some external destination,If the AS/400 is configured to send emails, and there is not already a mechanism on the system that you can use to end emails on error, then you can get your AS/400 colleagues to create a program that you can define in the notifications. There is a sample program source in the product library for receiving alerts, and this sample source can be easily extended to use the SNDDST CL command to generate emails,Note that for your AS/400 to Oracle replication, you are probably only monitoring the target side and so you are not getting full coverage of errors, as there are cases where a failure on the source side does not generate an error on the target side, e.g. if a source table cannot be replicated.Hope this helpsRobertHowever, the AS/400 needs to be set up to send emails through a configuration process, this does not occur by default and if your AS/400 colleagues
Rphilo 2700013TF4558 Posts
Re: re: Help with Notifications from iSeries2012-12-11T06:41:38ZThis is the accepted answer. This is the accepted answer.
Hi allSorry my previous post included a fragment of a sentence from a draft reply which I did not see at the bottom of the box when I saved the reply, so please ignore thisThanksRobert
- Rphilo 2700013TF4