IBM DB2 UDB: Visual Explain does not display the different Table Queues
With AD Studio v17, the visual explain plan does not display the different Table Queue parameters
Below items like ATQ, BTQ, CTQ, DTQ etc.. are not displayed.
ATQ : Asynchronous table queues - they read rows in advance of any fetch requests from an application.
BTQ : Broadcast table queues - is a table queue in which rows are sent to all of the receiving database partitions, but are not hashed.
CTQ : Column-Organized table queues
DTQ : Directed table queues - is a table queue in which rows are hashed to one of the receiving database partitions.
LTQ : Local table queues
TQ* : Listener table queues - These table queues are used with correlated subqueries.
MTQ : Merging table queues - These table queues preserve order.
STQ : Synchronous table queues - These table queues are known as synchronous, because they read one row for each FETCH statement that is issued by an application.
XTQ : XML aggregation TQ Operator
The query we use to extract Explain info uses the EXPLAIN_OPERATOR table. That table returns a column called OPERATOR_TYPE.
The only value returned for table queue in that column is TQ. See this link
As a result, Table Queue will always be displayed in our Explain whenever there is a table queue of any kind.
We need to research and figure out how to display the possible table queue parameters in AD Studio Visual Explain
svn #51588