Mqt Sql!!

rajinbits · #1 (**permalink**) 11-06-07, 02:09

Hello Guys,
In our DB, we are having a MQT defined on 2 tables. Now from where can I get the SQL used for creating the MQT ?

Thanks
Rajesh

guyprzytula · #2 (**permalink**) 11-06-07, 02:23

have you checked db2look output

rajinbits · #3 (**permalink**) 11-06-07, 02:32

No...could you please tell me how to use it??? thanks

stolze · #4 (**permalink**) 11-06-07, 03:47

Code:

$ db2look -d <dbname>

Also check "db2look -h" for further options.

guyprzytula · #5 (**permalink**) 11-06-07, 08:31

at least db2look -d dbname -e -l -o outfile

ARWinner · #6 (**permalink**) 11-06-07, 10:41

Try:

select text from syscat.views where viewschema = 'MySchema' and viewname = 'MyMQT'

Andy