ibm_db-3.1.0-new.tar.gz

# Installing ibm_db and ibm_db_dbi module We are assuming that you have Python already installed. In Linux you may need the python-dev package (you can install python-dev package through "$yum install python-devel" if yum doesn't work then you can also install it through "$apt-get install python-dev") Note:The minimum python version supported by driver is python 2.7 and the latest version supported is python 3.9 except version 3.3 as it has reached end-of-life. ## Installation ``` pip install ibm_db or easy_install ibm_db ``` This will install *ibm_db* and *ibm_db_dbi* module. If you face problems due to missing python header files, you would need to install python developer package before installing python ibm_db driver. e.g: ``` zypper install python-devel or yum install python-devel ``` ### Environment Variables `IBM_DB_HOME :` Set this environment variable to avoid automatic downloading of the clidriver during installation. You could set this to the installation path of ODBC and CLI driver in your environment. The list of supported platforms and installation file names are listed in the table under License requirements. ### IBM_DB and DB-API wrapper (ibm_db_dbi) sanity test ```python $ python Python 3.6.5 (default, May 10 2018, 00:54:55) [GCC 4.3.4 [gcc-4_3-branch revision 152973]] on linux Type "help", "copyright", "credits" or "license" for more information. >>> import ibm_db >>> #For connecting to local database named pydev for user db2inst1 and password secret, use below example >>> #ibm_db_conn = ibm_db.connect('pydev', 'db2inst1', 'secret') >>> #For connecting to remote database named pydev for uid db2inst and pwd secret on host host.test.com, use below example >>> conn_str='database=pydev;hostname=host.test.com;port=portno;protocol=tcpip;uid=db2inst1;pwd=secret' >>> ibm_db_conn = ibm_db.connect(conn_str,'','') >>> import ibm_db_dbi >>> conn = ibm_db_dbi.Connection(ibm_db_conn) >>> conn.tables('SYSCAT', '%') ``` More examples can be found under 'ibm_db_tests' folder. ### License requirements for connecting to databases Python ibm_db driver can connect to DB2 on Linux Unix and Windows without any additional license/s, however, connecting to databases on DB2 for z/OS or DB2 for i(AS400) Servers require either client side or server side license/s. The client side license would need to be copied under `license` folder of your `cidriver` installation directory and for activating server side license, you would need to purchase DB2 Connect Unlimited for System z® and DB2 Connect Unlimited Edition for System i®. To know more about license and purchasing cost, please contact [IBM Customer Support](http://www-05.ibm.com/support/operations/zz/en/selectcountrylang.html). To know more about server based licensing viz db2connectactivate, follow below links: * [Activating the license certificate file for DB2 Connect Unlimited Edition](https://www.ibm.com/developerworks/community/blogs/96960515-2ea1-4391-8170-b0515d08e4da/entry/unlimited_licensing_in_non_java_drivers_using_db2connectactivate_utlility1?lang=en). * [Unlimited licensing using db2connectactivate utility](https://www.ibm.com/developerworks/community/blogs/96960515-2ea1-4391-8170-b0515d08e4da/entry/unlimited_licensing_in_non_java_drivers_using_db2connectactivate_utlility1?lang=en.) Following are the details of the client license versions that you need to be able to connect to databases on non-LUW servers: #### <a name="LicenseDetails"></a> Client license for Specific Platform and Architecture |Platform |Architecture |Cli Driver |Supported |Version | | :---: | :---: | :---: | :---: | :--: |AIX | ppc |aix32_odbc_cli.tar.gz | Yes | V11.1 | | | others |aix64_odbc_cli.tar.gz | Yes | V11.1 | |Darwin | x64 |macos64_odbc_cli.tar.gz | Yes | V11.1 | |Linux | x64 |linuxx64_odbc_cli.tar.gz | Yes | V11.1 | | | s390x |s390x64_odbc_cli.tar.gz | Yes | V11.1 | | | s390 |s390_odbc_cli.tar.gz | Yes | V11.1 | | | ppc64 (LE) |ppc64le_odbc_cli.tar.gz | Yes | V11.1 | | | ppc64 |ppc64_odbc_cli.tar.gz | Yes | V10.5 | | | ppc32 |ppc32_odbc_cli.tar.gz | Yes | V10.5 | | | others |linuxia32_odbc_cli.tar.gz| Yes | V11.1 | |Windows | x64 |ntx64_odbc_cli.zip | Yes | V11.1 | | | x32 |nt32_odbc_cli.zip | Yes | V11.1 | |Sun | i86pc |sunamd64_odbc_cli.tar.gz | Yes | V10.5 | | | |sunamd32_odbc_cli.tar.gz | Yes | V10.5 | | | sparc |sun64_odbc_cli.tar.gz | Yes | V11.1 | | | sparc |sun32_odbc_cli.tar.gz | Yes | V11.1 | ### Issues with MAC OS X * If you run into errors for libdb2.dylib as below: ```python >>> import ibm_db Traceback (most recent call last): File "<stdin>", line 1, in <module> ImportError: dlopen(/usr/local/lib/python3.5/site-packages/ibm_db.cpython-35m-darwin.so, 2): Library not loaded: libdb2.dylib Referenced from: /usr/local/lib/python3.5/site-packages/ibm_db.cpython-35m-darwin.so Reason: image not found ``` You would need to set DYLD_LIBRARY_PATH to point to lib folder as per the installation location of clidriver in your environment. Assuming the driver is installed at /usr/local/lib/python3.5/site-packages/clidriver, you can set the path as: ``` export DYLD_LIBRARY_PATH=/usr/local/lib/python3.5/site-packages/clidriver/lib:$DYLD_LIBRARY_PATH ``` If the issue is not resolved even after setting DYLD_LIBRARY_PATH, you could refer: [MAC OS Hints and Tips](https://www.ibm.com/developerworks/community/blogs/96960515-2ea1-4391-8170-b0515d08e4da/entry/ibm_db_on_MAC_OS_Hints_and_Tips?lang=en) * Resolving SQL1042C error If you hit following error while attempting to connect to a database: ```python >>> import ibm_db >>> ibm_db.connect("my_connection_string", "", "") Traceback (most recent call last): File "<stdin>", line 1, in <module> Exception: [IBM][CLI Driver] SQL1042C An unexpected system error occurred. SQLSTATE=58004 SQLCODE=-1042 ``` Set DYLD_LIBRARY_PATH to point to icc folder as per the installation location of clidriver in your environment. ``` export DYLD_LIBRARY_PATH=/usr/local/lib/python3.5/site-packages/clidriver/lib/icc:$DYLD_LIBRARY_PATH ``` ### Supported databases * **Minimum Supported version of IBM DB2 is V9fp2 for Linux, UNIX, and Windows** * Informix 11.10 **(Cheetah)** * Remote connections to i5/OS (iSeries) * Remote connections to z/OS (DB2 for z/OS) # Feedback **Your feedback is very much appreciated and expected through project ibm-db:** * ibm-db issues reports: **https://github.com/ibmdb/python-ibmdb/issues** * ibm_db discuss: **http://groups.google.com/group/ibm_db** # Testing Tests displaying Python ibm_db driver code examples are located in the ibm_db_tests directory. A valid config.py will need to be created to configure your DB2 settings. A config.py.sample exists that can be copied and modified for your environment. The config.py should look like this: ```python test_dir = 'ibm_db_tests' # Location of testsuite file (relative to current directory) database = 'test' # Database to connect to user = 'db2inst1' # User ID to connect with password = 'password' # Password for given User ID hostname = 'localhost' # Hostname port