Is there a way to retrieve information directly from the MQ*P_MSG column in the MQ tables? For example, if a problem occurs and traces are needed to read the information a shown in the article here: https://knowledge.broadcom.com/external/article?articleId=198905, that information is in the MQ1OWP_MSG table in the MQ1OWP_MSG table. Attempting to use a statement like:
returns something like:
Is there a way to decrypt this so instead of activating trace and reading it, a query can be run, pull the values and use this data for next steps?
Release : 12.3
There is no way to get this information as it is compressed by the Automation Engine when the information is put into the MQ*_MSG column and uncompressed when it is removed. Trying to get the hex information also doesn't get any useful information when selecting directly from the database.