DB2

libaio1
ksh
libstdc++6-4.4-dev
libstdc++6-4.4-pic

tar xvfz db2exc_970_LNX_x86.tar.gz

sudo expc/db2setup

tar xvfz db2exc_nlpack_970_LNX_x86.tar.gz

sudo nlpack/db2setup

export PATH=$PATH:/opt/ibm/db2/V9.7/bin:/opt/ibm/db2/V9.7/adm:/opt/ibm/db2/V9.7/misc

db2start

DB21085I  Instance "scott" uses "32" bits and DB2 code release "SQL09070" with 
level identifier "08010107".
Informational tokens are "DB2 v9.7.0.0", "s090521", "LINUXIA3297", and Fix Pack 
"0".
Product is installed at "/opt/ibm/db2/V9.7".

DB21085I  インスタンス "scott" は、"32" ビットおよび DB2
コード・リリース "SQL09070" をレベル ID "08010107"
で使用します。
情報トークンは、"DB2
v9.7.0.0"、"s090521"、"LINUXIA3297"、およびフィックスパック "0"
です。
製品は "/opt/ibm/db2/V9.7" にインストールされています。

. /home/scott/sqllib/db2profile

db2level

db2

db2 => grant all on cities to public

	
	PyDB2_1.1.1-1.tar.gz

	cd PyDB2_1.1.1

	setup.py を編集

		DB2_ROOT = "/home/uchida/sqllib"
		
	sudo python setup.py install

>>> import DB2
>>> conn = DB2.connect(dsn='SAMPLE' , uid='sim' , pwd='xxxx')
Traceback (most recent call last):
  File "", line 1, in 
  File "/usr/local/lib/python2.6/dist-packages/DB2.py", line 276, in __init__
    self._db = _db2.connect(*args, **kwargs)
_db2.DatabaseError: ('08001', -30082, '[IBM][CLI Driver] SQL30082N  Security processing failed with reason "42" ("ROOT CAPABILITY REQUIRED").  SQLSTATE=08001\n')
>>> 

Traceback (most recent call last):
  File "./db2_read.py", line 9, in 
    import DB2
  File "/usr/local/lib/python2.6/dist-packages/DB2.py", line 12, in 
    import _db2
ImportError: libdb2.so.1: cannot open shared object file: No such file or directory

#wget http://peak.telecommunity.com/dist/ez_setup.py
#python ez_setup.py
#easy_install ibm_db

java.lang.ClassNotFoundException: OM.ibm.db2.jdbc.app.DB2Driver

May/09/2023 AM 08:15