Materlized query table(DB2)

moulipx · Post by **moulipx** » Tue Oct 26, 2010 8:13 am

Hi All,

Iam having one requirement to load data into Materlized Query table(DB2) same as Materlized view( Oracle. )

My source is Dataset.And i'm using Datastage 7.5 version.

Please let me know whether it is possible to load the data into Materlized query table through datastage parallel job.

Thanks,
chandra

moulipx · Post by **moulipx** » Tue Oct 26, 2010 11:20 am

Could you please someone provide reply for my requirement

kwwilliams · Post by **kwwilliams** » Tue Oct 26, 2010 11:37 am

The answer is yes. For DataStage it would just be another table, your DBA needs to set it up as a user manintained MQT.

http://publib.boulder.ibm.com/infocente ... 009318.htm

chulett · Post by **chulett** » Tue Oct 26, 2010 12:21 pm

Or you would need to insert into the base tables and it would refresh immediately or if set up deferred you would have to trigger the refresh.