Troubles with Start database manager

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Ivan Delic
    #1

    Troubles with Start database manager

    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
    Tags: None
    • Saurabh.Nr@gmail.com
      #2
      Re: Troubles with Start database manager



      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

        Comment

        • Ivan Delic
          #3
          Re: Troubles with Start database manager

          On 30 ÏËÔ, 07:23, Saurabh...@gmai l.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

            Comment

            • Lennart
              #4
              Re: Troubles with Start database manager

              On 30 Okt, 19:00, Ivan Delic <ivce...@gmail. comwrote:
              On 30 ÏËÔ, 07:23, Saurabh...@gmai l.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

                Comment

                Previous template Next
                Working...