Welcome to the IBM Websphere Commerce Hub


Welcome to the IBM Websphere Commerce Hub

Come join me in my journey to explore the various features and capabilities of IBM Websphere Commerce and understand how retailers can benefit from its really cool out-of-box functionality.

Thursday, August 9, 2012

SQL1032N - Issues with DB2START - DB2 9.5 ESE & DB2 9.7 ESE

If db2start command fails giving the error code SQL1042C SQL1032N

SQL8000N DB2START processing failed; a valid product license was not found.
SQL1032N No start database manager command was issued. SQLSTATE=57019

Cause

These error typically indicate that the DB2 UDB product license has not been activated.

Answer

To activate the DB2 UDB product license, run this command:

db2licm -a license_filename

Where license_filename is the name of the license file.

Example:

The file db2ese.lic is the DB2 Enterprise Server Edition license file. The license file should be copied to a local directory (e.g. /tmp) and updated with the following command (resulting output shown):

=> db2licm -a /tmp/db2ese.lic
DBI1402I License added successfully.

DBI1426I This product is now licensed for use as specified in
the License Acceptance and License Information
documents pertaining to the licensed copy of this
product. USE OF THE PRODUCT CONSTITUTES ACCEPTANCE OF
THE TERMS OF THE IBM LICENSE ACCEPTANCE AND LICENSE
INFORMATION DOCUMENTS, LOCATED IN THE FOLLOWING
DIRECTORY: /usr/opt/db2_08_01/license/en_US.iso88591

The license information can be queried with this command (resulting output shown):

=> db2licm -l
Product Name = "DB2 Enterprise Server Edition"
Product Password = "DB2ESE"
Version Information = "8.1"
Expiry Date = "Permanent"
Registered Connect User Policy = "Disabled"
Number Of Entitled Users = "5"
Enforcement Policy = "Soft Stop"
Number of processors = "1"
Number of licensed processors = "1"
Annotation = ""
Other information = ""

No comments:

Post a Comment