Using DB2 materialized query tables
27 March, 2013
I am using DB2 9.7 and would like to create a view selecting from a MQT. The MQT exists in the database but Yellowfin does not display the MQT.
I used a DB2 monitor to have a look at the code running in Yellowfin to bring back the list of tables etc. The function being call is: CALL SYSIBM.SQLTABLES (?,?,?,?,?). One of the options in this call is the type of table which can be one of the following: ALIAS, HIERARCHY TABLE, INOPERATIVE VIEW, NICKNAME, MATERIALIZED QUERY TABLE, SYSTEM TABLE, TABLE, TYPED TABLE, TYPED VIEW, or VIEW.
If "MATERIALIZED QUERY TABLE" is not listed then that is why I it is not being listed.
Can you please confirm that this is the issue.
I used a DB2 monitor to have a look at the code running in Yellowfin to bring back the list of tables etc. The function being call is: CALL SYSIBM.SQLTABLES (?,?,?,?,?). One of the options in this call is the type of table which can be one of the following: ALIAS, HIERARCHY TABLE, INOPERATIVE VIEW, NICKNAME, MATERIALIZED QUERY TABLE, SYSTEM TABLE, TABLE, TYPED TABLE, TYPED VIEW, or VIEW.
If "MATERIALIZED QUERY TABLE" is not listed then that is why I it is not being listed.
Can you please confirm that this is the issue.
Hi Mark,
Sorry we were unable to get to your query today, and unfortunately due to the Easter holiday, a response cannot be sent until early next week.
We do apologise for the delay (it�s not very often we get a 4-day weekend here), and hope you enjoy your Easter.
Regards,
David
Sorry we were unable to get to your query today, and unfortunately due to the Easter holiday, a response cannot be sent until early next week.
We do apologise for the delay (it�s not very often we get a 4-day weekend here), and hope you enjoy your Easter.
Regards,
David
Hi Mark,
you are correct, at the moment only the default TABLE option is being used, so I have raised an enhancement request (support task ID = 128200) for the option of also having the MATERIALIZED QUERY TABLE, it shouldn't take much doing so we hope to have it in next month's patch.
Regards,
Dave
you are correct, at the moment only the default TABLE option is being used, so I have raised an enhancement request (support task ID = 128200) for the option of also having the MATERIALIZED QUERY TABLE, it shouldn't take much doing so we hope to have it in next month's patch.
Regards,
Dave