By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,225 Members | 1,051 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,225 IT Pros & Developers. It's quick & easy.

Cannot create database

P: n/a
Hi,

I'm new at DB2, and have just installed a DB2 Version 9 Enterprise trial.

Had no visible problems installing the database, but I cannot create the
sample Database, or any other database.

When I try to create a database, I get

SQL1032N No DB2START-command issued translated from danish ;-)
SQLSTATE=57019

When I - from then commandeditor - calls DB2START, I am told that the
database-system is already active?

Any ideas?

Thank you
Bjorn
bj*********@ssv.dk
Feb 19 '07 #1
Share this Question
Share on Google+
2 Replies


P: n/a
prm
Reboot - there's a process that has a lock on a resource.

It may also be that there's a DB2 agent still left in the task list.

You've probably done it by now, but rebooting will quickly solve the
problem.

Paul

"Bjørn Johansen" <bj@ssv.dkwrote in message
news:45*********************@dreader1.cybercity.dk ...
Hi,

I'm new at DB2, and have just installed a DB2 Version 9 Enterprise trial.

Had no visible problems installing the database, but I cannot create the
sample Database, or any other database.

When I try to create a database, I get

SQL1032N No DB2START-command issued translated from danish ;-)
SQLSTATE=57019

When I - from then commandeditor - calls DB2START, I am told that the
database-system is already active?

Any ideas?

Thank you
Bjorn
bj*********@ssv.dk


Feb 20 '07 #2

P: n/a
Thank you, but I had already
Rebooted - no change
Uninstalled and reinstalled - no change
Reformatted and reinstalled - no change

The computer is running XP Pro SP2

Finally I reformatted, installed VMWare + a virtual 2003 Server on which I
installed DB2, then it worked!!?

I have no idea what it is all about. According to IBM's documentation, XP or
2003 is preferred.

If anybody has an idea, it would very much appreciated, from searches in
newsgroups, I can see that others have been stuck in the same problem.

Thank you - at least I am up and running :-)

Best regards
Bjorn
"prm" <pr*******@swbell2.netskrev i en meddelelse
news:Ma******************@newssvr21.news.prodigy.n et...
Reboot - there's a process that has a lock on a resource.

It may also be that there's a DB2 agent still left in the task list.

You've probably done it by now, but rebooting will quickly solve the
problem.

Paul

"Bjørn Johansen" <bj@ssv.dkwrote in message
news:45*********************@dreader1.cybercity.dk ...
>Hi,

I'm new at DB2, and have just installed a DB2 Version 9 Enterprise trial.

Had no visible problems installing the database, but I cannot create the
sample Database, or any other database.

When I try to create a database, I get

SQL1032N No DB2START-command issued translated from danish ;-)
SQLSTATE=57019

When I - from then commandeditor - calls DB2START, I am told that the
database-system is already active?

Any ideas?

Thank you
Bjorn
bj*********@ssv.dk



Feb 21 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.