Results 1 to 8 of 8
  1. #1
    Join Date
    Oct 2012
    Posts
    3

    Unanswered: Cannot start DB2 after installation

    Hi,

    During the install of DB2 9.7 to Windows Server 2008 R2 Standard, Service Pack 1, this error pops up during the last step of the installation process:

    An error occurred while trying to start the "DB2" instance". The return code is "4" and the SQL message is: "Process_Error".

    When I check the application logs in the event viewer, I see this error:

    ADM12008C The product "DB2 Enterprise Server Edition" does not have a valid
    license key installed and the evaluation period has expired. Functions specific
    to this product are not enabled. If you have licensed this product, please
    ensure the license key is properly installed. You can install the license via
    using License Center or db2licm command line utility. The license file can be
    obtained from your licensed product CD.



    I re-installed the license using this command db2licm -a C:\db2wse_o.lic

    This was the output of the command:

    LIC1402I License added successfully.

    LIC1426I This product is now licensed for use as outlined in your License Agree ment. USE OF THE PRODUCT CONSTITUTES ACCEPTANCE OF THE TERMS OF THE IBM LICENSE AGREEMENT, LOCATED IN THE FOLLOWING DIRECTORY: "C:\PROGRA~1\IBM\SQLLIB\license\en"



    However, when I try to start the DB2 using db2start command, I get the license error again:


    10/22/2012 11:35:39 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 Cent er 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


    Also, I ran the db2val command, I got this output:

    DBI1379I The db2val command is running. This can take several minutes.

    DBI1333I Installation file validation for the DB2 copy DB2COPY1
    was successful.

    DBI1338E The validation of instance DB2 failed. Reason
    code=3.

    Explanation:

    1. The default instance is not set.
    2. Some files in the instance directory are damaged. The symbolic links
    of the files are not pointing to the current DB2 copy installation
    path, and the file permission and ownership might have been changed.
    3. The DB2 Extended Security setup does not allow the current user to
    start an instance. If Extended Security is enabled, the user needs to
    be in the DB2ADMNS group.
    4. To start the instance, read permission is required to the
    /etc/services file.
    5. SYSADM authority is required to validate this instance.
    6. The partitioned database environment setting is not correct.
    7. The instance failed to start because of system errors.
    8. An unexpected internal error occurred.

    User response:

    1. Set the DB2INSTDEF profile registry variable to an instance in the
    DB2 copy.
    2. Run the db2iupdt or db2nrupdt command with the -k option for the
    instance.
    3. Add the current user to the DB2ADMNS group and rerun the command.
    4. Ensure you have read permission to the /etc/services file.
    5. Log on as a user with the SYSADM authority and retry the command.
    6. Check the partitioned database environment validation log file for
    details.
    7. Check the log file for details.
    8. Rerun the db2val command. If this error persists, contact your IBM
    service representative.

    DBI1344E The validation tasks of the db2val command failed.


    This makes no sense. First it told me that the license install was successful. However, when I re-installed the license successfully, and tried to start DB2 again, I got the license error again.

    Please help me asap. I really don't know why this happens.

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    I am not totally certain on this, but you have DB2 ESE installed and used a WSE license.

    Andy

  3. #3
    Join Date
    Oct 2012
    Posts
    3
    The product is installed. However, when I try to start DB2 - DB2COPY1 - DB2-0 windows service, or just try to create a database, I keep on getting this error:


    ADM12008C The product "DB2 Enterprise Server Edition" does not have a valid
    license key installed and the evaluation period has expired. Functions specific
    to this product are not enabled. If you have licensed this product, please
    ensure the license key is properly installed. You can install the license via
    using License Center or db2licm command line utility. The license file can be
    obtained from your licensed product CD.


    When I try to import this license: IBM DB2 Restricted Workgroup Server Edition, V9.7 (The license end date is 12/31/2037), I get a success. However, when I try to start DB2 or create a database, I get the above error.

    Does this help you answer my questions?

  4. #4
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    You installed DB2 "Enterprise Edition" and tried installing a "Workgroup Edition" license. I am sure that the license installs OK, but you license does not match what you installed. Try installing the Workgroup edition instead.

    Andy

  5. #5
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    try db2licm -l to list the licences
    db2level to see the level
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  6. #6
    Join Date
    Aug 2009
    Posts
    8
    I have also faced problem with 9.7
    Please check your windows 2008 R2 whether it is 32 bit or 64 bit.
    Then match with DB2 as DB2 has both version.

    -- Humayun

  7. #7
    Join Date
    Oct 2012
    Posts
    3
    Thanks for all your help. I uninstalled DB2 and reinstalled with proper license. Now, when I do db2licm -l, I get this:

    Product name: "DB2 Workgroup Server Edition"
    License type: "Restricted"
    Expiry date: "Permanent"
    Product identifier: "db2wse"
    Version information: "9.7"
    Max number of Value Units: "480"
    Max amount of memory (GB): "4"


    However, when I try to run db2start, I get the license problem again. It's so weird. Here is the message:

    DB2-0 : The service has returned a service-specific error code.

    10/23/2012 16:18:26 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


    The DB2 installation that I used for 64-bit Server, and mine server is Windows Server 2008 R2 Standard, Service Pack 1 64-bit.

    This is so weird. I have never seen anything like this. Any help is really appreciated. I am really stuck at this point.

  8. #8
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    I suggest you contact IBM support on this.

    Andy

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •