Prev: What's throttling?
Next: Working with Ruby on DB2 ESE
From: karthic on 5 Mar 2010 04:50
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
From: Ian on 5 Mar 2010 12:10
On 3/5/10 2:50 AM, karthic wrote:
> Hi,
> here i have given my requirement details please give me some
> idea..........

These are nearly all questions you can answer by reading the
documentation. Here is a link:

http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/index.jsp

I've given you hints below.

> 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?

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

> if i want to move data from one database to another what is the
> solution for that?

See db2move

> what is MQT(materialized view)?

Read the documentation.

> 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)

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.

> is it possible to create MQT based on another one MQT(like nested MQT)
> in DB2?

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



 | 
Pages: 1
Prev: What's throttling?
Next: Working with Ruby on DB2 ESE