Connecting Tech Pros Worldwide Help | Site Map

Troubles with Start database manager

  #1  
Old October 29th, 2008, 06:35 PM
Ivan Delic
Guest
 
Posts: 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
  #2  
Old October 30th, 2008, 07:25 AM
Saurabh.Nr@gmail.com
Guest
 
Posts: n/a

re: Troubles with Start database manager




Ivan Delic wrote:
Quote:
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
  #3  
Old October 30th, 2008, 07:05 PM
Ivan Delic
Guest
 
Posts: n/a

re: Troubles with Start database manager


On 30 ΟΛΤ, 07:23, Saurabh...@gmail.com wrote:
Quote:
Ivan Delic wrote:
Quote:
Hi all!
>
Quote:
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
>
Quote:
Windows XP SP2 512MB RAM 80GB HDD, x64.
>
Quote:
At the very end of installation I got following message:
>
Quote:
SQL1032N
No start database manager command was issued.
Explanation:
>
Quote:
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.
>
Quote:
The command cannot be processed.
User Response:
>
Quote:
Issue a start database manager command and resubmit the current
command.
>
Quote:
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.
>
Quote:
sqlcode: -1032
>
Quote:
sqlstate: 57019
>
Quote:
After installation I could not create any database at all.
>
Quote:
Please help me out to resolve this problem.
>
Quote:
Sincerely yours,
>
Quote:
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
  #4  
Old October 30th, 2008, 07:55 PM
Lennart
Guest
 
Posts: n/a

re: Troubles with Start database manager


On 30 Okt, 19:00, Ivan Delic <ivce...@gmail.comwrote:
Quote:
On 30 ΟΛΤ, 07:23, Saurabh...@gmail.com wrote:
>
>
>
Quote:
Ivan Delic wrote:
Quote:
Hi all!
>
Quote:
Quote:
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
>
Quote:
Quote:
Windows XP SP2 512MB RAM 80GB HDD, x64.
>
Quote:
Quote:
At the very end of installation I got following message:
>
Quote:
Quote:
SQL1032N
No start database manager command was issued.
Explanation:
>
Quote:
Quote:
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.
>
Quote:
Quote:
The command cannot be processed.
User Response:
>
Quote:
Quote:
Issue a start database manager command and resubmit the current
command.
>
Quote:
Quote:
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.
>
Quote:
Quote:
sqlcode: -1032
>
Quote:
Quote:
sqlstate: 57019
>
Quote:
Quote:
After installation I could not create any database at all.
>
Quote:
Quote:
Please help me out to resolve this problem.
>
Quote:
Quote:
Sincerely yours,
>
Quote:
Quote:
Ivan Delic
Serbia
>
Quote:
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

Closed Thread


Similar Threads
Thread Thread Starter Forum Replies Last Post
Need help on oracle 8i db Oeleboele answers 2 June 27th, 2008 07:28 PM
Is C99 the final C? Michael B. answers 193 November 14th, 2005 04:46 PM
Need help on oracle 8i db Oeleboele answers 2 July 19th, 2005 10:55 PM