db2licm - License management tool command
Performs basic license functions such as adding, removing, listing, or modifying licenses and policies installed on the local system.
Note: Under the processor Value Unit (PVU) licensing structure,
each processor core will be assigned a specific number of Value Units.
You must acquire the total number of processor Value Units for each
processor core on which the software programs are deployed. IBM continues to
define a processor to be each processor core on a chip. For example,
a dual-core chip contains two processor cores.
Each software program has a unique price per Value Unit. To determine the total cost of deploying an individual software program, you multiply the program price per Value Unit by the total number of processor Value Units required.
Attention: Because Db2® cannot limit
itself to a specified number of CPU cores, you must limit your Db2 environment to
match your Db2 license. In some instances, Db2 returns an
ADM12017E message or similar message, stating that you are exceeding your defined processor
entitlement.
Authorization
On Windows operating systems:
- You must belong to the local Administrators or Power Users group to use the -a, -r, or -x command parameters.
- SYSADM authority is required to use the -c, -e, -p, -r, or -u command parameters.
On UNIX and Linux® operating systems, no authority is required.
Required connection
None
Command syntax
Command parameters
- -a filename
- Adds a license for a product. Specify a file name containing valid license information. This can be obtained from your licensed product CD or by contacting your IBM representative or authorized dealer.
- -e product-identifier
- Updates
the enforcement policy on the system. By default, out of compliance
usage is logged in the compliance report. Valid values are: HARD or
SOFT.
- HARD
- Specifies
that unlicensed requests are restricted in these cases:
- Row
compression: Specifies that the following operations return an error
message without a valid license entitlement for row compression:
- CREATE or ALTER TABLE statement with the COMPRESS YES clause.
- CREATE or ALTER INDEX statement with the COMPRESS YES clause.
- Native
encryption: Specifies that the following commands return an error message without a valid license
entitlement for the IBM®
Db2 Encryption Offering:
- CREATE or BACKUP DATABASE command with the ENCRYPT parameter.
Note: Changing Db2 product editions does not change the entitlement policy to SOFT.
- Row
compression: Specifies that the following operations return an error
message without a valid license entitlement for row compression:
- SOFT
- Specifies that unlicensed requests are logged in the compliance report, but not restricted.
- -p product-identifier
- Updates the license policy type to use on the system.
- CONCURRENT
- Specify for concurrent user policy.
- OFF
- Specify to turn off all policies.
- -t database-name username password
- Displays the user data that is stored in all the user tables of the specified database. Provides data consumption for Terabyte license usage scenarios. Specify the database name, user name, and password. Run the command with this option as an instance user.
- -r product-identifier
- Removes the license for a product. To get the product identifier for a specific product, invoke the command with the -l option.
- -u product-identifier num-users
- Updates the number of user licenses that the customer has purchased for record keeping. Specify the product identifier and the number of users. Note that there is no enforcement on the actual number of users.
- -c product-identifier num-connectors
- Updates the number of connector entitlements that the customer has purchased for record keeping. Specify the product identifier and the number of connectors. Note that there is no enforcement on the actual number of users.
- -g filename
- Generates compliance report. Specify file name where output is
to be stored.Note: You must restart the database to get the most up to date license compliance report. Processor, socket, core, memory and other system restrictions are not included in the compliance report.
- -x
- Resets license compliance information for the purposes of license compliance report.
- -l
- Lists all the products with available license information, including
the product identifier.
- SHOW DETAIL
- Specify to view detailed information about licensed features (if any).
- -v
- Displays version information.
- -h | -?
- Displays help information. When this option is specified, all other options are ignored, and only the help information is displayed.
Examples
Example 1:
Basic
examples:
db2licm -a db2ese_u.lic
db2licm -p db2consv concurrent
db2licm -r db2ese
db2licm -u db2wse 10
db2licm -e db2ese SOFT
db2licm -t testdb jmathew temp4now
Note: In the example above, the number of user licenses entered
is only intended for record keeping and does not enforce compliance.
Example 2:
Output example listing all the products with available license information, including the product
identifier:
C:\Program Files\IBM\SQLLIB\BIN>db2licm -l
Product name: "Db2 Enterprise Server Edition"
License type: "Trial"
Expiry date: "08/31/2009"
Product identifier: "db2ese"
Version information: "10.5"
Note: In Linux the db2licm
-l command writes the following informational message to
/var/log/messages:
kernel: Program db2licm tried to access /dev/mem between 1f0000000f0000->10100000000.
Example 3: A CREATE DATABASE command with the ENCRYPT parameter fails when enforcement policy is set to HARD
Set
the enforcement policy to hard:
db2licm -e db2aese HARD
When
the enforcement policy is set to HARD, a CREATE DATABASE command
with the ENCRYPT parameter fails. For example,
db2licm -l
Product name: "Db2 Advanced Enterprise Server Edition"
License type: "CPU Option"
Expiry date: "Permanent"
Product identifier: "db2aese"
Version information: "10.5"
Enforcement policy: "Hard Stop"
db2 create database samptab1 ENCRYPT
SQL8029N A valid license key was not found for the requested functionality.
Reference numbers: "8".