Troubles with Start database manager 
October 29th, 2008, 06:35 PM
| | | |
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 | 
October 30th, 2008, 07:25 AM
| | | | 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 | 
October 30th, 2008, 07:05 PM
| | | | re: Troubles with Start database manager
On 30 ΟΛΤ, 07:23, Saurabh...@gmail.com wrote: Quote:
Ivan Delic wrote:> 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: |
After installation I could not create any database at all.
| > Quote: |
Please help me out to resolve this problem.
| >>>
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 | 
October 30th, 2008, 07:55 PM
| | | | 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: 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: |
After installation I could not create any database at all.
| | > Quote: Quote: |
Please help me out to resolve this problem.
| | >>> 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 |  | | | | /bytes/about
We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights.
Get the best answers to your questions from over 225,662 network members.
|