How to connect and configure DB2 with web2py

  db = DAL('db2://Driver={DB2drv};Database=dbname;Hostname=127.0.0.1;Port=12345;Protocol=TCPIP;Uid=userid;Pwd=passwd;')  

    download from ibm website the last odbc driver
    * IBM Data Server Driver Package (DS Driver)
Driver for ODBC and CLI (64-bit) or (32-bit)
      IBM download

    configure those following files

   

 #odbc configuration on /etc/odbcinst.ini  
   [DB2drv]  
   Description = IBM DB2 ODBC DRIVER  
   Driver = /home/gustavo/Downloads/odbc_cli/clidriver/lib/libdb2o.so  
   FileUsage = 1  
   DontDLClose = 1  
   ####easy_install ibm_db####  
   #on /etc/odbc.ini  
   [BE_DB2]  
   Description = DB2 back-end database @ myhost  
   Driver = DB2drv