DROP DATABASE



IBM's flagship relational database management system

DROP DATABASE

Postby db2sysdba » Thu Dec 22, 2011 8:23 pm

Hi,

In our environment we have arequirement to drop a database(Test Region).

If we drop a database what are all the other objects or any other (like plan, package, etc...) has to be dropped explicitly?

Our Findings(Correct me If I am wrong)...

We came to know that
Tablespace, Indexspace, Synonyms, Views, Sequence Objects are dropped implicitly.
db2sysdba
 
Posts: 18
Joined: Wed Sep 28, 2011 4:14 pm
Has thanked: 0 time
Been thanked: 0 time

Re: DROP DATABASE

Postby db2sysdba » Thu Jan 05, 2012 5:43 pm

My findings:

Needs to be explicitly taken care after DROP DATABASE

Triggers,
Plan/Package,
Stored Procedures/Function
Alias.

Correct me, If I am wrong in above list.

Happy Learning,
Dinesh Kanna.
db2sysdba
 
Posts: 18
Joined: Wed Sep 28, 2011 4:14 pm
Has thanked: 0 time
Been thanked: 0 time


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post