Topic
  • No replies
RamkiV
RamkiV
1 Post

Pinned topic wmq-monitoring tool connect to MSSQL

‏2017-04-27T22:17:45Z |

Hi,

Has any one successfully used MSSQL server 2012 with wmq-monitoring tool(https://www.ibm.com/developerworks/websphere/library/techarticles/1311_jin/1311_jin.html).

When the application tried to start, it created 3 tables in MSSQL database but failed to create the table "HEALTH_MESSAGE" because of column name "RULE" which is a reserved word in MSSQL.

As per documentation, I did not see MSSQL supported but in jdbc.properties its mentioned that MSSQL is supported.

# Supported DB: DB2, MYSQL, SQL_SERVER, DERBY

Please let me know if any one figured out to resolve the issue.

Thanks.

Regards,

Ramakrishna.