DB2 Version 9.7 for Linux, UNIX, and Windows

db2licm - License management tool command

Performs basic license functions in the absence of the Control Center. Adds, removes, lists, and modifies 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.

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. On Windows 2008, Windows Vista, and Windows 7 operating systems with User Access Control (UAC) feature on, db2licm must be run from the DB2® Command Window - Administrator.
  • 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

Read syntax diagramSkip visual syntax diagram
>>-db2licm--+-----------------------------------------+--------><
            +- -a--filename---------------------------+   
            +- -e--product-identifier--+-HARD-+-------+   
            |                          '-SOFT-'       |   
            +- -p--product-identifier--+-CONCURRENT-+-+   
            |                          '-OFF--------' |   
            +- -r--product-identifier-----------------+   
            +- -u--product-identifier--num-users------+   
            +- -c--product-identifier--num-connectors-+   
            +- -g--filename---------------------------+   
            +- -x-------------------------------------+   
            +- -l--+-------------+--------------------+   
            |      '-SHOW DETAIL-'                    |   
            +- -v-------------------------------------+   
            '-+- -h-+---------------------------------'   
              '- -?-'                                     

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.
-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.
-e product-identifier
Updates the enforcement policy on the system. By default, DB2 feature usage out of compliance will be logged in the compliance report. Valid values are:
HARD
Specifies that the following operations will 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.
SOFT
Specifies that unlicensed requests will be logged in the compliance report but not restricted.
-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.
-h | -?
Displays help information. When this option is specified, all other options are ignored, and only the help information is displayed.
-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).
-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.
-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.
-v
Displays version information.
-x
Resets license compliance information for the purposes of license compliance report.

Examples

   db2licm -a db2ese.lic
   db2licm -p db2consv concurrent
   db2licm -r db2ese
   db2licm -u db2wse 10
   db2licm -e db2ese SOFT
Note: In the example above, the number of user licenses entered is only intended for record keeping and does not enforce compliance.
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:              "9.7"
Note: In Linux (RHEL 4.7 or higher) the db2licm -l command writes the following informational message to /var/log/messages:
   kernel: Program db2licm tried to access /dev/mem between 1f0000000f0000->10100000000.