|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
 |
|
DB2 issue/prob |
« View previous topic :: View next topic » |
Author |
Message
|
james2005 |
Posted: Thu Dec 22, 2005 2:04 am Post subject: DB2 issue/prob |
|
|
Apprentice
Joined: 18 Sep 2005 Posts: 31
|
Hi,
Created one databse EXDB, removed it from DB2 for some reason.
Now the problem is DB2 is not accepting the same name EXDB for the new database. I tried to find it in regedit but it is not there.
Can anyone tell me a simple way to create a new database(EXDB).
Regards,
Enda. |
|
Back to top |
|
 |
james2005 |
Posted: Thu Dec 22, 2005 3:41 am Post subject: Solved |
|
|
Apprentice
Joined: 18 Sep 2005 Posts: 31
|
Hi,
I used catalog and drop commands.
using this i cataloged the DB with alias name and dropped it.
Now i created it again with the same name.
Thanks, |
|
Back to top |
|
 |
wschutz |
Posted: Thu Dec 22, 2005 3:45 am Post subject: |
|
|
 Jedi Knight
Joined: 02 Jun 2005 Posts: 3316 Location: IBM (retired)
|
How did you delete it?
What do you see if you do this:
Code: |
db2 list database directory |
Try:
db2 catalog database EXDB
db2 drop database EXDB _________________ -wayne |
|
Back to top |
|
 |
dgolding |
Posted: Thu Dec 22, 2005 3:49 am Post subject: |
|
|
 Yatiri
Joined: 16 May 2001 Posts: 668 Location: Switzerland
|
|
Back to top |
|
 |
james2005 |
Posted: Wed Dec 28, 2005 3:23 am Post subject: |
|
|
Apprentice
Joined: 18 Sep 2005 Posts: 31
|
Thanks all,
I got the solution.
Thanks for ur quick response.
regards,
Enda. |
|
Back to top |
|
 |
|
|
 |
|
Page 1 of 1 |
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
|
|
|