CODEWITHSUNDEEP
databasedb2
Index Hacker
Index Hacker

Reputation: 2024

DB2 Sample Database unable to create

Creating database "SAMPLE" on path "C:"... Existing "SAMPLE" database found... The "-force" option was not specified... Attempt to create the database "SAMPLE" failed 'db2sampl' processing complete.

Creating database "SAMPLE"... Existing "SAMPLE" database found... The "-force" option was not specified... Attempt to create the database "SAMPLE" failed.

'db2sampl' processing complete.

SQL1026N The database manager is already active

which indicates that the instance is indeed started.

SQL1057W The system database directory is empty. SQLSTATE=01606

which shows that no databases have been created and discredits the possibility of the DB2 sample database creation failing because an existing one is present.

What is causing the sample database to fail?

Upvotes: 2

Views: 12379

Answers (1)

AngocA
AngocA

Reputation: 7693

Probably the database was created but uncataloged, that is the reason you do not see the database in the database directory, but the database files and tablespaces still exist.

You can try to recatalog the database and then, drop it if you want to recreate the sample database.

db2 catalog database sample

db2 drop database sample

db2sampl

Upvotes: 13

Related Questions