Hi,
here i have given my requirement details please give me some
idea..........

i have created a new user(user2) in db2 database.now In that database
i have 2 users(user1,user2). in user1 we have more than 700 tables. i
want to move data with structure from user1 to user2.

how to move data with sructure from user1 to user2?
if i want to move data from one database to another what is the
solution for that?
what is MQT(materialized view)?
i want to create MQT based on base table. and i want to refresh it in
particar time every day. is it possible in DB2? then explain me with
example(emp table)
is it possible to create MQT based on another one MQT(like nested MQT)
in DB2?


these are my queries please let me know

Thanks&Regards
karthic M

On 3/5/10 2:50 AM, karthic wrote:
These are nearly all questions you can answer by reading the
documentation. Here is a link:

http://publib.boulder.ibm.com/infoce...v9r7/index.jsp

I've given you hints below.

See ADMIN_COPY_SCHEMA, or, if you won't want to duplicate all of the
data consider using aliases.

See db2move

Read the documentation.

If you're on 9.7, read the documentation on the administrative task
scheduler. On previous versions look at Task Center.

Alternatively, use an external scheduling tool like cron.

Not for system-maintained MQTs. User-maintained MQTs will allow this,
though.