db2connectactivate - Server license activation utility

The db2connectactivate utility activates the Db2 Connect Unlimited Edition license on the Db2® for z/OS® or Db2 for i server to avoid applying the Db2 Connect license on each database client that directly connects to the server.

The db2connectactivate utility creates the SYSIBM.DB2CON_LIC procedure on the Db2 for z/OS or Db2 for IBM® i database. During activation, if the SYSIBM.DB2CON_LIC procedure does not exist, the procedure along with the key is created and stored. Then, the static package DB2LIC.SYSLIC is created to invoke the stored procedure and execute access for the static package is granted to all users.

The db2connectactivate utility with the -checkexisting option checks for a Db2 Connect license on the Db2 for z/OS or Db2 for IBM i database.

Syntax for the db2connectactivate utility

Read syntax diagramSkip visual syntax diagram-db2connectactivate[.sh]-host-host_name-port-port-database-database-user-user_ID-password-password-bindnoyes-collection-collection_name-activatorsqlidsqlid-uninstallnoyes-tracenoyes-checkexisting-clientApplcompat-help

Parameters

-host
Specifies the domain name or IP address of the Db2 for z/OS subsystem or Db2 for IBM i server where you want to activate the license.
-port
Specifies the TCP/IP server port number of the Db2 for z/OS subsystem or the Db2 for IBM i server where you want to activate the license.
-database
Specifies the location name of the Db2 for z/OS subsystem or the Db2 for IBM i server.
-user
Specifies the user ID with the SYSADM or SYSCTRL privilege.
-password
Specifies the password of the database user with the SYSADM or SYSCTRL privilege.
-bind
Indicates whether you want to bind dynamic SQL packages for the IBM Data Server Driver for JDBC and SQLJ or a CLI client on the host database. Specify this option only if packages are not bound on the host database.
-collection
Specifies the collection ID for the dynamic SQL packages. Specify this option only if you want to use a collection name that is not the default collection name, which is NULLID.
-activatorsqlid
Specifies what authorization id that is used to create the procedure and package. The authorization ID used must have all the privileges that are necessary to create the SYSIBM.DB2CON_LIC procedure and the DB2LIC.SYSLIC package.
The -activatorsqlid parameter can be used if the user id that is running the db2connectactivate utility does not have the privileges to create the objects or if it is wanted that the objects be owned by a different user id.
-uninstall
Indicates whether you want to uninstall any activation files and static SQL packages that already exist on the Db2 for z/OS subsystem or the Db2 for IBM i database. This option does not affect dynamic SQL packages.
-trace
Indicates whether you want to turn on the trace for the activation utility. If you run the trace, output is sent to standard output.
-checkexisting
Specifies that the db2connectactivate utility checks whether a Db2 Connect license is installed on the server. If a license is installed, the db2connectactivate utility displays the license version. If a license is not installed, the db2connectactivate utility displays a message that indicates that the Db2 Connect license was not found on the server.
When -checkexisting is specified, install or uninstall operations do not occur.
-clientApplcompat
Specifies the function level of V12R1M501 or later for connections to Db2 for z/OS 12.0 data servers. It sets the capabilities of a particular instance of the IBM Data Server Driver for JDBC and SQLJ to a function level that is less than or equal to the function level of the data server.

Remarks

You can install only one Db2 Connect license. If you are using multiple versions, you must install the license for the highest version of Db2 Connect.

When the Db2 Connect Unlimited Edition for zSeries license certificate file is activated with the db2connectactivate utility on the Db2 for z/OS, Version 9.7 fix pack 3 and later clients can access the database.

When the Db2 Connect Unlimited Edition for iSeries license certificate file is activated with the db2connectactivate utility on the Db2 for i database, Version 10.5 and later clients can access the database.

You can activate the Db2 Connect Unlimited Edition for iSeries license certificate file on the Db2 for i V7R1 or later.

The Db2 Connect Unlimited Edition license certificate file and the db2connectactivate utility are contained in the activation CD image. You can download the activation CD image for Db2 Connect Unlimited Edition for zSeries or Db2 Connect Unlimited Edition for iSeries that you purchased from the Passport Advantage® website: http://www.ibm.com/software/lotus/passportadvantage/.

The license certificate file name for the Db2 Connect Unlimited Edition for zSeries software is db2consv_zs.lic.

The license certificate file name for the Db2 Connect Unlimited Edition for iSeries software is db2consv_is.lic.

For more details about -clientApplcompat, please refer the link https://www.ibm.com/support/knowledgecenter/en/SSEPEK_12.0.0/java/src/tpc/imjcc_r0052040.html

The option -bindoptions is used to bind the regular packages (SYSSTAT, etc) with APPLCOMPAT only when -bind yes is specified. This behavior continues for regular packages. Now the same has been modified to bind the APPLCOMPAT with the package created for license. It does not depend on the -bind option value to be true to bind APPLCOMPAT .This is applied to the License Package only.

Any of the properties supported through Global properties can be added in the DB2JccConfiguration.properties file. The DB2JccConfiguration.properties file should be in the same folder as db2connectactivate.jar. These properties will be used during connection establishment. This only applies to Db2 for z/OS servers and for T4 connectivity only.

For Db2 11.5.6 and later versions, any of the properties supported through Global properties can be added in the DB2JCCConfiguration.properties file. The DB2JCCConfiguration.properties file should be in the same folder as the db2connectactivate.jar file. These properties are used during connection establishment.

Examples

The following db2connectactivate utility invocation activates the license for Db2 Connect Unlimited Edition for System z® on a Db2 for z/OS subsystem:

db2connectactivate.sh -host myzos.ibm.com -port 446 -database payroll -user db2admin -password adminpassword 

If no license currently exists on the server, and activation is successful, the following message is displayed:

Activation completed successfully.

Suppose that a license currently exists on the server for Db2 Connect Version 9.7, and you run the db2connectactivate utility for Version 10.5. If activation is successful, the following message is displayed:

The Db2 Connect license was upgraded successfully from version 0907 to version 1005.

The following db2connectactivate utility invocation displays the version of the currently installed license for Db2 Connect Unlimited Edition for System z on a Db2 for z/OS subsystem:

db2connectactivate.sh -host myzos.ibm.com -port 446 -database payroll -user db2admin -password adminpassword -checkexisting

Suppose that a license for Db2 Connect Version 10.5 is installed on the server. The following message is displayed:

The version of the installed Db2 Connect license on the server is 1005.

If the license is not already installed on the server, the following message is displayed:

The Db2 Connect license was not found on the target server.

The following db2connectactivate utility invocation shows how to specify the -clientApplcompat option:

db2connectactivate.sh  -host myzos.ibm.com  -port 446  -database payroll  -user db2admin  -password adminpassword   -clientApplcompat V12R1M501

The following db2connectactivate utility invocation shows how to specify the -bindoptions option for binding APPLCOMPAT:

db2connectactivate.sh -host myzos.ibm.com -port 446 -database payroll -user db2admin -password adminpassword
-clientApplcompat V12R1M501  -bindoptions "APPLCOMPAT V12R1M501"