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

Troubles with Start database manager

P: n/a
Hi all!

This is my first email message about DB2 Universal database so don't
mind if it looks like confusion. Recently I have installed DB2 UDB
(Try and by Version) on my OS. It is, as follows

Windows XP SP2 512MB RAM 80GB HDD, x64.

At the very end of installation I got following message:
SQL1032N
No start database manager command was issued.
Explanation:

The start database manager command has not been processed. It must be
processed before a stop database manager, any SQL statement, or
utility can be issued.

The command cannot be processed.
User Response:

Issue a start database manager command and resubmit the current
command.

If using multiple logical nodes, ensure the DB2NODE environment
variable is set correctly. The DB2NODE environment variable indicates
the node the application will attempt to connect to. DB2NODE must be
set to the node number of one of the nodes defined on the same host as
the application.

sqlcode: -1032

sqlstate: 57019
After installation I could not create any database at all.

Please help me out to resolve this problem.

Sincerely yours,

Ivan Delic
Serbia
Oct 29 '08 #1
Share this Question
Share on Google+
3 Replies


P: n/a


Ivan Delic wrote:
Hi all!

This is my first email message about DB2 Universal database so don't
mind if it looks like confusion. Recently I have installed DB2 UDB
(Try and by Version) on my OS. It is, as follows

Windows XP SP2 512MB RAM 80GB HDD, x64.

At the very end of installation I got following message:
SQL1032N
No start database manager command was issued.
Explanation:

The start database manager command has not been processed. It must be
processed before a stop database manager, any SQL statement, or
utility can be issued.

The command cannot be processed.
User Response:

Issue a start database manager command and resubmit the current
command.

If using multiple logical nodes, ensure the DB2NODE environment
variable is set correctly. The DB2NODE environment variable indicates
the node the application will attempt to connect to. DB2NODE must be
set to the node number of one of the nodes defined on the same host as
the application.

sqlcode: -1032

sqlstate: 57019
After installation I could not create any database at all.

Please help me out to resolve this problem.

Sincerely yours,

Ivan Delic
Serbia

its self explanatory ..go to db2cmd and issue a db2start command
Oct 30 '08 #2

P: n/a
On 30 ΟΛΤ, 07:23, Saurabh...@gmail.com wrote:
Ivan Delic wrote:
Hi all!
This is my first email message about DB2 Universal database so don't
mind if it looks like confusion. Recently I have installed DB2 UDB
(Try and by Version) on my OS. It is, as follows
Windows XP SP2 512MB RAM 80GB HDD, x64.
At the very end of installation I got following message:
SQL1032N
No start database manager command was issued.
Explanation:
The start database manager command has not been processed. It must be
processed before a stop database manager, any SQL statement, or
utility can be issued.
The command cannot be processed.
User Response:
Issue a start database manager command and resubmit the current
command.
If using multiple logical nodes, ensure the DB2NODE environment
variable is set correctly. The DB2NODE environment variable indicates
the node the application will attempt to connect to. DB2NODE must be
set to the node number of one of the nodes defined on the same host as
the application.
sqlcode: -1032
sqlstate: 57019
After installation I could not create any database at all.
Please help me out to resolve this problem.
Sincerely yours,
Ivan Delic
Serbia

its self explanatory ..go to db2cmd and issue a db2start command
I did so. I openede db2cmd window and typed db2start.

I got following message

SQL1042C An unexptected system error occured.
SQL1032N No start database manager command was issued SQLSTATE=57019

Help me out please
Oct 30 '08 #3

P: n/a
On 30 Okt, 19:00, Ivan Delic <ivce...@gmail.comwrote:
On 30 ΟΛΤ, 07:23, Saurabh...@gmail.com wrote:
Ivan Delic wrote:
Hi all!
This is my first email message about DB2 Universal database so don't
mind if it looks like confusion. Recently I have installed DB2 UDB
(Try and by Version) on my OS. It is, as follows
Windows XP SP2 512MB RAM 80GB HDD, x64.
At the very end of installation I got following message:
SQL1032N
No start database manager command was issued.
Explanation:
The start database manager command has not been processed. It must be
processed before a stop database manager, any SQL statement, or
utility can be issued.
The command cannot be processed.
User Response:
Issue a start database manager command and resubmit the current
command.
If using multiple logical nodes, ensure the DB2NODE environment
variable is set correctly. The DB2NODE environment variable indicates
the node the application will attempt to connect to. DB2NODE must be
set to the node number of one of the nodes defined on the same host as
the application.
sqlcode: -1032
sqlstate: 57019
After installation I could not create any database at all.
Please help me out to resolve this problem.
Sincerely yours,
Ivan Delic
Serbia
its self explanatory ..go to db2cmd and issue a db2start command

I did so. I openede db2cmd window and typed db2start.

I got following message

SQL1042C An unexptected system error occured.
SQL1032N No start database manager command was issued SQLSTATE=57019

Help me out please
I'm not familiar with Windows but I assume that there is a file called
db2diag.log. If you look at the end of this file you might find some
info on what is wrong.

HTH
/Lennart

Oct 30 '08 #4

This discussion thread is closed

Replies have been disabled for this discussion.