Detailed explanation of the offline installation method of python module ibm_db of db2

Linux is centos6.5-64 bits, suse 11-64 bits can be successful

1. Why do you need to install it offline

No Internet, working in a bank, server environment Configuration, completely offline (what was supposed to be done in five minutes, had to be done in a day. I’m convinced!!)

2. Required accessories and operation steps

1. Download the ibm_db module , download address https://pypi.python.org/pypi/ibm_db.

2. Download two db2 driver modules. One can find the download link in setup.py in the ibm_db module. , download the specified driver according to the system version. For example https://public.dhe.ibm.com/ibmdl/export/pub/software/data/db2/drivers/odbc_cli/linuxx64_odbc_cli.tar.gz

Depending on the situation.

3. A client package for downloading db2. Download it from the official website http://www-01.ibm.com/support/docview.wss?rs=4020&uid=swg21385217. The English is relatively good. You can understand it at a glance. It is the first relatively complete driver file. . Just download it. The driver is ibm_data_server_driver_package_linuxx64_v11.1.tar.gz. The decompressed directory is dsdriver. Then execute the executable file installDSDriver inside,

./installDSDriver

will be installed successfully soon, and then some files will be generated in the directory, such as db2profile, and then add the following content to /etc/profile. Remember to source it.

. /安装目录/dsdriver/db2profile

Sometimes in a production environment, you cannot use root privileges to call ibm_db, so you need to re-execute the above installation command in the user's home directory and modify the ./bashrc or .bash_profile file (different systems, that is Different, only effective for the current user), add

. /安装目录/dsdriver/db2profile

final source /etc/profile or .bashrc or .bash_profile

3. Install the ibm_db module

1. Unzip ibm_db Module, if the unzipped directory is ibm_db2.

2. Then unzip the db2 driver module. The unzipped file will be a clidriver directory, and copy it to the ibm_db2 directory.

3. Enter the ibm_db2 directory and execute python setup.py install to install successfully. If a gcc error is prompted, please yum or apt-get gcc and other Linux system library files.

4. Enter the python compiler and import: import ibm_db. No error is reported, which means it is successful. If it cannot be imported, the client driver of db2 is not selected correctly.

******Online installation is so easy, just pip install ibm_db*********

The above is the detailed content of Detailed explanation of the offline installation method of python module ibm_db of db2. For more information, please follow other related articles on the PHP Chinese website!