Doesn’t the METADATA already contain the message ID? I think there may even be one that is assigned when the message first enters the Engine that stays with the message until it leaves the engine.
However, I think the METADATA only exists as long as the message is actually in the engine.
There is a SRCMID key in the SMAT .idx file but I don’t ever recall seeing it populated.
I think the Recovery DB does exactly what you want — unless you have a complete system crash such that the Recover DB gets completely corrupted but I am not sure what could be done to protect against that. It probably should not be occurring in the first place.
Jim Kosloskey
email: jim.kosloskey@jim-kosloskey.com 29+ years Cloverleaf, 59 years IT - old fart.