Enable transactions on Informix DB

We need to have the following variables set:

INFORMIXDIR=/opt/IBM/informix
INFORMIXSQLHOSTS=/opt/IBM/Informix/etc/sqlhosts.ol_informix1170
INFORMIXSERVER=ol_informix1170

1. Now, we can enable the transactions, in first we need to put the database in “quiescent mode” (???):

   >/opt/IBM/informix/bin/onmode –uy
   

   Note: doing this disable access to the database.

2. enable transactions:

   >/opt/IBM/informix/bin/ontape –s –L 0 –B d9exp
   

3. Re-enable the connections:

   >/opt/IBM/informix/bin/onmode -m
   

Helpful information: Jdbc configuration

jdbc:oracle:thin:@server:port:db

More information here