-1
votes
0answers
16 views

IBM DB2 9.7 determining default tablespace

I have a DB2 9.7 database. I have defined any specific tablespace, so all tables go to USERSPACE1. Now I have created two new tablespaces and assign two tables to each of the two new tablespaces with ...
2
votes
2answers
260 views

db2 (LUW) equivalent for oracle drop user cascade

This question is related to creating and initialising test and development databases for an application that has the database running on LUW (linux-unix-windows) On oracle, we have an os user (on ...
2
votes
1answer
503 views

copy schema across different physical databases in db2

Is there any way to programatically copy across schema (i.e. tables,functions,views) etc from one database over to another one. Assuming both are running same versions of DB2. I found a few utilities ...