In the AIX environment, how is the DB2 license problem?

The following articles mainly describe how to correctly crack the DB2 license problem in the AIX environment and the actual operation steps. During the installation and use of the DB2 UD product, sometimes users may encounter problems related to the DB2 license. For example, SQL8008N.

Errors related to the absence of a valid license file or expiration date of the DB2 product are reported, resulting in the failure of the specified function .) To solve this problem, we use the AIX system as an example to provide you with a step-by-step process to solve the DB2 license problem in the AIX operating system environment.

Body: The following describes how to solve the problem of DB2 license under AIX:

(1) check whether the license file is installed:

Log on as a root user (the commands described below are executed as root users if not described ).

DB2 version 5:

Open the/usr/lib/netls/conf/nodelock local node with vi) file and check the detailed format of the DB2 license information as described in step 3) product expiration time. If you find that the current date has exceeded this date, or you do not have DB2 license information, you need to install the DB2 license file.

DB2 version 6, 7:

In/usr/lpp/db2_06_01 or/usr/lpp/db2_07_01, or execute "su-Instance name" to transfer to the specified

You can see the following output information:

 
 

  
  
Product Name = DB2 Enterprise - Extended Edition  
  
  
Product Password = DB2UDBEEE 
  
  
Version Information = 7.2  
  
  
Expiry Date = Permanent 
  
  
Concurrent Connect User Policy = Disabled 
  
  
Registered Connect User Policy = Disabled 
  
  
Enforcement Policy = Soft Stop  
  
  
Number of processors = 1 
  
  
Number of licensed processors = 1 
  
  
Annotation =  
  
  
Other information =  
 
 

The Expiry Date is "never expire". If there is no such information, it indicates that the DB2 license file has not been successfully installed. Generally, if you use the Installation tool provided by DB2, after the installation is complete, the DB2 license will be automatically registered. However, on Unix-based operating systems, you can also install DB2 using the Installation tool provided by the system. At this time, the DB2 license file will not be automatically installed, you must manually execute the command after the DB2 installation is complete.

(2) the method for installing the license file is as follows:

Run the following command to install/update the license:

DB2 version 5:

/Usr/lpp/db2_05_00/cfg/db2licinst filename

DB2 version 6, 7:

/Usr/lpp/db2_07_01/adm/db2licm-a filename

Filename indicates the full path name of the license file on the product installation media. This license information will be added to the/var/ifor/nodelock file of the system. In this case, you can go to step 9 in the process and continue to complete the process.

(3) If you have installed the license file, you still cannot obtain the correct information about the DB2 license.

First, the nodelock file located under/var/ifor/should be created with/usr/lib/netls/conf/nodelock

Ln-s/var/infor/nodelock/usr/lib/netls/conf/nodelock

Create the link and check the correctness of the nodelock file:

Open the file with vi, which should have information similar to the following:

 
 

  
  
5fbcdefg6feb.02.09.15.0f.48.00.00.00 6qx2v39a6sb5ipvmaxpaa 7.1  
  
  
#[admin_comment] IBM Toronto Lab DB2 Enterprise Edition 2145844800 0  
 
 

Where the first behavior license information, the behavior that starts with "#" Comments information. The string "2145844800" in the second line indicates the expiration time of the product on January 1, 2145 ...). If the user finds that the current date has exceeded this date, or if there is no information similar to the above two lines, the license is not installed successfully. In this case, you can add "#" to comment out the wrong DB2 license information as described in Step 8, and then execute the license installation command described in step 2 ).

Note: If you are using DB2 version 6 or 7, perform steps 4)-9 for the AIX operating system LUM license use management described below) optional steps, but recommended for DB2 version 5

(4) check whether the LUM of the AIX operating system has been started. When the user inputs:

Lssrc-g iforls

Command, the system will output the following information:

If at least one of them is in the active state, it indicates that LUM has been started. Follow the steps described in Step 8) to reinstall the DB2 license file and continue the subsequent steps. Otherwise, perform the following operations on LUM.

(5) check whether the LUM version of the AIX system is 4.3.2.0 or later.

Run the following command:

Lslpp-l | grep ifor_ls.base.cli

The output of the LUM version is as follows:

Ifor_ls.base.cli 4.3.3.25 License Use Management Runtime has been implemented

6) If the output shows that the LUM version is earlier than 4.3.2, You need to upgrade the version. For example, you can register and download the latest LUM installation image file on the Web site provided by the following IBM companies:

Http://www6.software.ibm.com/dl/lum/lum-p

In addition, you can contact the AIX system support engineer at IBM Service Hotline: 8008101818 to obtain the latest version.

(7) If the LUM version meets the requirements, you can start to configure LUM. This is an essential step for the correct installation of product licenses in the AIX system. The command is:

/Var/ifor/i4cfg-scr limit pt

(9) If the LUM has been configured successfully or the license file has been re-installed as shown in the process, you can use LUM

/Var/ifor/i4blt-lp-I | more

(10) Finally, the user needs to use the following in/usr/lpp/db2_07_01/instance to use DB2 version 7 ):

Db2iupdt Instance name

(11) at this point, the problem about the DB2 license under AIX should be basically solved. If the problem persists, go back to step (1) and check again, to confirm the correct execution of each step.

The above summarizes the basic steps for solving the DB2 license problem under AIX. You can use this as a reference and use it flexibly according to your actual situation to solve the problem of DB2 license.