Topic
17 replies Latest Post - ‏2013-12-24T07:10:15Z by finnthehuman
SystemAdmin
SystemAdmin
5837 Posts
ACCEPTED ANSWER

Pinned topic SQL1032N No start database manager command was issued.

‏2008-08-01T12:03:38Z |
Hi. I have installed express C db2 data server but i cannot create a database at control center.

The error, that occurs, is the following:

SQL1032N No start database manager command was issued.
SQLSTATE=57019

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
The same error occurs, when i press db2start. Could you help me, please?

If a fixpack is needed, could you tell me which is proper?
Updated on 2013-03-05T06:03:40Z at 2013-03-05T06:03:40Z by SystemAdmin
  • SystemAdmin
    SystemAdmin
    5837 Posts
    ACCEPTED ANSWER

    Re: SQL1032N No start database manager command was issued.

    ‏2008-08-01T13:44:52Z  in response to SystemAdmin
    spiros, I have to make a few assumptions as you didn't supply the info.

    The Default Instance of DB2 was created when DB2 was installed.
    The Operating System is Windows (not Linux/Unix).
    You are trying to create the database in the default DB2 instance.

    If any of this is incorrect, then this may not make sense.

    I am not sure what you mean when you say you 'press db2start' as I don't know of a db2start button.

    Open a DB2 Command window and type: db2start
    (The best place to run DB2START is on the Server where the database is located.)

    You should get the message: SQL1063N DB2START processing was successful.

    If you can not start the database with DB2START on the server and assuming DB2 is installed correctly with the default DB2 instance, then it is probably a security issue. This is from the Command Reference manual:

    "Since db2start launches a Windows service, you must meet Windows requirements for starting a service. If Extended Security is disabled, you must be a member of the Administrators, Server Operators or Power Users group. If Extended Security is enabled, you must be a member of either the Administrators group or the DB2ADMNS group to start the database."

    You can also check the Windows Services and see if DB2-DB2COPY1-DB2 (the default name) is listed and whether is is set to Disabled, Manual or Automatic.

    PS Fixpacks are not available for DB2 Express-C.
    • SystemAdmin
      SystemAdmin
      5837 Posts
      ACCEPTED ANSWER

      Re: SQL1032N No start database manager command was issued.

      ‏2008-08-01T14:55:00Z  in response to SystemAdmin
      Sorry for not explaining. I have already run the "db2start" command on both the command line processor and command window and the same error occurs.

      Also, on your previous reply you said that db2 must be installed correctly with the default db2 instance. Is this default instance a part of db2's installation? Maybe, i didn't install db2 correctly. In this case could you explain me how to reinstall db2?
      • SystemAdmin
        SystemAdmin
        5837 Posts
        ACCEPTED ANSWER

        Re: SQL1032N No start database manager command was issued.

        ‏2008-08-01T15:11:32Z  in response to SystemAdmin
        The install panels are fairly strightforward and easy to use. Explaining how to install DB2 Express-C is a little beyond what I can do in this forum. Let's take another approach.

        Have you checked Windows Services to see if DB2-DB2COPY1-DB2 is listed? If it is what is the status?

        On the server type the command DB2ILIST. This will list any instances on the server. At the least you should have have something like DB2.

        If db2ilist doesn't show anything, you don't have an instance created and this may be the problem.
        If DB2 is listed, I am not sure why DB2START isn't working.

        You can use db2icrt to create an Instance: db2icrt instance-name -p location

        instance-name is a name you want the instance to be called.
        location is the path where you want the instance created (d: for example)
        • SystemAdmin
          SystemAdmin
          5837 Posts
          ACCEPTED ANSWER

          Re: SQL1032N No start database manager command was issued.

          ‏2008-08-01T15:33:57Z  in response to SystemAdmin
          I typed the command "db2ilist" on the server as you told me. This showed DB2. As for the status of db2 on the list of windows services i don't know how to see it. Anyway is there something i can do to fix the problem. Thanks for helping me!
          • SystemAdmin
            SystemAdmin
            5837 Posts
            ACCEPTED ANSWER

            Re: SQL1032N No start database manager command was issued.

            ‏2008-08-01T16:31:59Z  in response to SystemAdmin
            Sorry, I should have mention to display the Services, you would look under Administrative Tools. This might be in different places on different systems. Mine is under Start->All Programs->Administrative Tools->Services.

            If the display is not sort by Name, click on the column name to sort it that way. Then look for DB2* items. There should be several but the one you are looking for should be DB2-DB2COPY1-DB2 (Others are DB2 Governor, DB2 License Server, DB2 Management Service, DB2 Remote Command Server and/or DB2DAS-DB2DA00).

            Find DB2-DB2COPY1-DB2 (default name) and look under the status column. The possible statuses are automatic (what you normally want so DB2 Starts when the computer is turned on), Manual (you have to type the DB2START command (if it worked)), or Disabled (you can't start DB2).
            • SystemAdmin
              SystemAdmin
              5837 Posts
              ACCEPTED ANSWER

              Re: SQL1032N No start database manager command was issued.

              ‏2008-08-02T10:39:26Z  in response to SystemAdmin
              Hello again, i checked windows services and there are these info:

              name : DB2 - DB2COPY1 - DB2-0
              status : (blank: thre isn't something written)
              start type : automatic
              connection as : .\db2admin

              Also, today i opened a command window and typed db2start and a message appeared which says the following:

              "02/08/2008 13:32:12 0 0 SQL8000N DB2START processing failed; a valid product license was not found. If you have licensed this product, ensure the license key is properly registered. You can register the license via the License Center or db2licm command line utility. The license key can be obtained from your licensed product CD.

              SQL1032N No start database manager command was issued. SQLSTATE=57019"

              Is there something i should do for the license key or the authorities?
              • SystemAdmin
                SystemAdmin
                5837 Posts
                ACCEPTED ANSWER

                Re: SQL1032N No start database manager command was issued.

                ‏2008-08-02T11:36:23Z  in response to SystemAdmin
                Sorry but it is wrong word the "authotities". I mean if there is a problem with security issue. I forgot to tell you that on services when i start the db2 nothing happens and a message comes out saying that i must contact with the product manufacturer with error code of the service - 8000
                • SystemAdmin
                  SystemAdmin
                  5837 Posts
                  ACCEPTED ANSWER

                  Re: SQL1032N No start database manager command was issued.

                  ‏2008-08-04T12:39:22Z  in response to SystemAdmin
                  spiros, that makes more sense. If you do a search of the forum for "Expired Liscense", you will find a couple of posts on the subject. There seems to be two possibilities.

                  1) A previous install of DB2 (even a trial version) has left 'stuff' on the system that is interferring with the Liscense check.

                  2) The Country code of Windows is not one that the installer recognizes.

                  Hopefully one of these will fix your problem.
                  • SystemAdmin
                    SystemAdmin
                    5837 Posts
                    ACCEPTED ANSWER

                    Re: SQL1032N No start database manager command was issued.

                    ‏2008-08-26T11:20:51Z  in response to SystemAdmin
                    Hi, my friend, SDas. I was on holiday, so i let the problem be till i return. I read the post you sent me and i have to tell you that i didn't install previous version of db2 express C. In this case can you help me about the country code of windows? There are many messages on the forum about "Expired license" but i didn't find what i wanted. I would like your help, please. :D
                    • SystemAdmin
                      SystemAdmin
                      5837 Posts
                      ACCEPTED ANSWER

                      Re: SQL1032N No start database manager command was issued.

                      ‏2008-08-26T12:03:35Z  in response to SystemAdmin
                      Spiros, Unfortunately, no, I don't have any specific information on dealing with country codes. All I know about them is what I have read in this forum.
                      • SystemAdmin
                        SystemAdmin
                        5837 Posts
                        ACCEPTED ANSWER

                        Re: SQL1032N No start database manager command was issued.

                        ‏2008-09-01T08:36:38Z  in response to SystemAdmin
                        This post you gave me has realy helped me out. Thanks very much for your help and the help of everyone in this forum.

                        Now that i installed db2, could you help in an other issue?

                        Well, i want to connect java with db2 server. I have boreland Jbuilder X Enterprise edition as java editor and jdk1.6.0_05 for java compiler. Could you help me make a connection of these 2?

                        Thank you again for helping me.
                        • rfchong
                          rfchong
                          484 Posts
                          ACCEPTED ANSWER

                          Re: SQL1032N No start database manager command was issued.

                          ‏2008-09-01T15:48:00Z  in response to SystemAdmin
                          Hello,

                          Please start a new forum thread for this new topic. This way more people will know about the new question/problem and will be able to help.

                          Cheers,

                          Raul F. Chong
                          DB2 on Campus Program Manager
                          Email: db2x@ca.ibm.com
    • vidyasagarpatro
      vidyasagarpatro
      1 Post
      ACCEPTED ANSWER

      Re: SQL1032N No start database manager command was issued.

      ‏2011-11-16T06:07:40Z  in response to SystemAdmin
      Hi SDas, I am sagar

      I am using Windows 7 as my operating system.
      I am getting the error as:

      SQL1032N No start database manager command was issued.
      SQLSTATE=57019

      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

      when I type the command to start the database manager then it prompts me : Database manager already active.

      what should i do now ?
      • SystemAdmin
        SystemAdmin
        5837 Posts
        ACCEPTED ANSWER

        Re: SQL1032N No start database manager command was issued.

        ‏2013-03-05T06:03:40Z  in response to vidyasagarpatro
        If you are working on On Local Machine(db2cmd) then getting message as
        "SQL1032N No start database manager command was issued. SQLSTATE=57019"
        Then Please do below steps On Wondow 7 ,
        Go to Control panel -> Administrative tools -> Services -> Select DB2-DB2COPY-DB2 and double Click -> Then click start button -> Ok.
        Then connect to database. it will work.
      • talaa123
        talaa123
        2 Posts
        ACCEPTED ANSWER

        Re: SQL1032N No start database manager command was issued.

        ‏2013-09-18T14:49:31Z  in response to vidyasagarpatro
        Hi,
        Try these one by one
        1. Open "default db2 database client..." in db2 folder and make sure that db2copy1 is selected.
        2. open administrator command prompt and write the command [I]db2start[/I] and hit enter
        3. open run and type [I]services.msc[/I] which will will open windows services and there check for the service named db2-db2copy1-db2 and open it. Try to start it if that doesn't work go to the logon tab and check the credentials. May be you can try logging with windows account but make sure that your windows account have same user and password as you set in db2.
  • talaa123
    talaa123
    2 Posts
    ACCEPTED ANSWER

    Re: SQL1032N No start database manager command was issued.

    ‏2013-09-18T14:49:53Z  in response to SystemAdmin
    Hi,
    Try these one by one
    1. Open "default db2 database client..." in db2 folder and make sure that db2copy1 is selected.
    2. open administrator command prompt and write the command [I]db2start[/I] and hit enter
    3. open run and type [I]services.msc[/I] which will will open windows services and there check for the service named db2-db2copy1-db2 and open it. Try to start it if that doesn't work go to the logon tab and check the credentials. May be you can try logging with windows account but make sure that your windows account have same user and password as you set in db2.