I suspect you know the error code reported in the log when DNS fails for the SQL object goes down?
So, in your logging target (I'm not sure what UI you are using, but in the OLD pre-10.5 UI) locate the "Event Triggers" tab.
Add a new event trigger.
In the message ID field, put in the error code of interest, say, the error when DNS fails.
If multiple error messages result from the same code you provide, fill in a regular expression to isolate the DNS failure.
In both of these cases, you want to leave the "Only Once" radio turned "on"
In both of these cases, you want to leave the "Only this trigger" radio turned "on", but, make sure one doesn't shadow the other.
Then, in the CLI command, enter something like:
packet-capture-advanced all temporary:///DNSFailed.pcap 60 10000 9000
Follow the documentation here:
https://www.ibm.com/docs/en/datapower-gateway/2018.4?topic=commands-packet-capture-advanced
Repeat for the SQL going down, just be sure to give a unique value for the capture file name so if both go down, you don't have the SQL one overwriting the DNS one.
------------------------------
Joseph Morgan
------------------------------
Original Message:
Sent: Thu October 12, 2023 05:40 AM
From: Sunil Chaurasia
Subject: Error Report Creation
Hi Jospeh,
Can you help on this usecase.
I am bit sure this can be done using the event triggers in Log targets.
1) Can we trigger a pcap and error report once we have issue with DNS resolution i.e i mean where we get DNS Callback error for the backend.
Eg. Thu Sep 28 2023 19:41:33 [0x80e00048][network][error] xmlmgr(MainXMLManager): tid(----) gtid(-------): DNS Callback cannot resolve host 'xxxxxxxxxxxxxxxxx': returning error
2) Also, if our some Database is down i.e the SQL object is down and unable to reach the DB , it should generate a pcap.
Thanks
------------------------------
Sunil Chaurasia
Original Message:
Sent: Wed September 27, 2023 12:27 PM
From: Joseph Morgan
Subject: Error Report Creation
And you know what.... the moment I hit the POST button I realize there is a way.
Tell me what you want to do and I'll be able to help you.
------------------------------
Joseph Morgan
Original Message:
Sent: Wed September 27, 2023 12:16 PM
From: Paul Dango
Subject: Error Report Creation
Is there a way to create an error report based on a given date and time period?
------------------------------
Paul Dango
------------------------------