Document Actions

The number of processors exceeds the defined for the product

SQL8017W The number of processors on this machine exceeds the defined for the product

1 Message Errors

“SQL8017W The number of processors on this machine exceeds the defined 
entitlement of "4" for the product "DB2 Enterprise Server Edition". 
The number of processors on this machine is 8.”

2 Causes

The machine was upgraded with more processors, but the db2 license was not updated.

3 Investigating

db2licm -l

Output:

Product Name                            = "DB2 Enterprise Server Edition"
Product Identifier                      = "DB2ESE"
Version Information                     = "8.2"
Expiry Date                             = "Permanent"
Registered Connect User Policy          = "Disabled"
Number Of Entitled Connect Users        = "5"
Enforcement Policy                      = "Soft Stop"
Number of processors                    = "8"
Number of licensed processors           = "4"
Database partitioning feature           = "Not entitled"
Annotation                              = ""
Other information                       = ""


Product Name                            = "DB2 Advanced Security Option"
Product Identifier                      = "DB2ASO"
Version Information                     = "8.2"
Expiry Date                             = "Permanent"
Annotation                              = ""
Other information                       = ""

Then, now you validated you have 8 processors on machine but the licensed processor is just 4.

4 Resolving

To fix this error, issue the command below:

db2licm -n db2se 8

DBI1418I The number of licensed processors on this system has
          been updated successfully.

DBA to DBA

Personal tools