V7.1 - Creating Sample Database 
Author Message
 V7.1 - Creating Sample Database
I am a newbie to DB2.  I installed DB2 and when I get to First Steps, I
click on the tab to create the sample database.  It then tells me that
the database has already been created, so my creation fails. However,
the database is not there.  Is there some command lines I need to enter
before creating the sample database through First Steps. Any help will
be greatly appreciated.

Thanks,
Kristie Harris

Sent via Deja.com
http://www.***.com/



Mon, 14 Jul 2003 06:51:07 GMT
 V7.1 - Creating Sample Database

You could drop a SAMPLE database first using
db2 drop database sample

and then you can create SAMPLE db using executable

INSTALL_PATH/bin/db2sampl


Quote:

> I am a newbie to DB2.  I installed DB2 and when I get to First Steps,
I
> click on the tab to create the sample database.  It then tells me that
> the database has already been created, so my creation fails. However,
> the database is not there.  Is there some command lines I need to
enter
> before creating the sample database through First Steps. Any help will
> be greatly appreciated.

> Thanks,
> Kristie Harris

> Sent via Deja.com
> http://www.deja.com/

Sent via Deja.com
http://www.deja.com/


Mon, 14 Jul 2003 07:05:54 GMT
 V7.1 - Creating Sample Database
Did you by chance install DB2 UDB, then create the sample database, and
then uninstall/reinstall? If you do this, the databases are physically
retained on the machine, but the catalog entries are lost. Hence the "new"
db2 attempts to create a database that is already there and fails. If this
is the case, issue the CATALOG command (DB2 CATALOG DATABASE SAMPLE AS
SAMPLE). You should now be able to access it, or drop it and recreate it if
you wish.
Quote:

> I am a newbie to DB2.  I installed DB2 and when I get to First Steps, I
> click on the tab to create the sample database.  It then tells me that
> the database has already been created, so my creation fails. However,
> the database is not there.  Is there some command lines I need to enter
> before creating the sample database through First Steps. Any help will
> be greatly appreciated.

> Thanks,
> Kristie Harris

> Sent via Deja.com
> http://www.deja.com/



Mon, 14 Jul 2003 09:06:25 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. after upgrade v7->v8, CREATE FUNCTION fails on 2 of 3 databases, same server

2. How to create a sample database?

3. Sample Database for Creating an Invoice Application

4. Create a sample database for test

5. Problem with creating Sample Database

6. i cannot create the sample database

7. Problem creating DB2 UDB 6 text extender sample database

8. Sample Database for Creating an Invoice Application

9. BAD sig (was: Re: v7.3.1 psql against a v7.2.x database

10. Export from v7.3 to a v7.2 database

11. Need c++ sample or syntac for CREATE CUBE to creates .Cub file

12. V7.1 Extenders Sample Programs Problem


 
Powered by phpBB® Forum Software