MQSeries.net :: View topic

stubie · Posted: Mon Apr 18, 2005 6:29 am Post subject:

What is this table used for? It is my understanding that this table is read during process instance creation to make sure that the user doing the create is authorized. Is it used any other times, like during template listing?

The reason I ask is that on Friday we had a system slowdown, and during the investigation it was discovered that there had been more than 3 billion rows read from that table in the previous 24 hours. It may have nothing to do with the slowdown, but it was concerning. Our table has about 55 thousand rows in it, which means there would have needed to have been 42 thousand full table scans to hit that number.