resending / rerouting recovery db messages

[Stewart]

Is it possible to reroute or resend recovery db messages?

Topic

[James Cobane]

You can’t do it dynamically.  You would need to dump them from the recovery database to a file in sequence (and delete them from the recovery DB), then resend from the file to wherever you wanted them to go.

You would need to be cognizant of the db state they are in and insure that you aren’t dumping something pre-xlate, when you actually wanted it post-xlate.  But, if you are simply wanting to take the messages off the outbound data queue (state 11) of one thread, and put them onto the outbound data queue of another, then that is pretty straight forward.

Hope this helps.

Jim Cobane – Henry Ford Health

[Stewart]

The thread has been deleted and they are in the recovery database.  I need to put them in the outbound que of another.  Can you provide the steps to do this?

[Robert Kersemakers]

Use

hcidbdump -e -b /tmp/error_messages.le

to dump the messages length encoded in a file. You may need additional parameters to filter out only the messages you need to resend.

Then open the Network Monitor, right-click on the thread where you want the messages to be resent and choose ‘Control/Full…’. In the next menu choose ‘resend…’. The next window you will need to choose ‘Outbound post-TPS’ (most probably, unless there are procs that need to be done); in ‘File’ put the created file in full path (here: ‘/tmp/error_messages.le’); in ‘Format’ use ‘Length Encoded’. Click ‘OK’ to resend the messages.

Zuyderland Medisch Centrum; Heerlen/Sittard; The Netherlands

[Stewart]

Thanks everyone.

[Author]

Replies