1 2 3 Previous Next 44 Replies Latest reply: Aug 8, 2012 12:51 PM by Dharma_ Go to original post RSS
      • 15. Re: Create DB-Link for Oracle Database 11g to IBM DB2
        Kgronau-Oracle
        Did you set the environment variable ODBCINI prior calling isql?

        export ODBCINI=/etc/odbc.ini
        • 16. Re: Create DB-Link for Oracle Database 11g to IBM DB2
          Mkirtley-Oracle
          Hi,
          The error is happening because either isql can't find the odbc.ini file or dblink4db2 isn't specified in the file.
          Try creating the env variables ODBCINI and ODBCINSTINI which point to the location of the relevant files and try again.
          If you still have problems then post the odbc.ini and odbcinst.ini files being used.

          You could also try contacting IBM or the driver supplier to get help on setting up the driver correctly.

          Regards,
          Mike
          • 17. Re: Create DB-Link for Oracle Database 11g to IBM DB2
            user652330
            Hai Mike,

            ****/etc/odbc.ini****
            [ODBC Data Sources]
            db2 = connection to db2

            [dblink4db2]
            Description = DB2 for ODBC Driver
            Driver = /opt/IBMDB2_Driver/clidriver/lib/libdb2.so
            Server = 192.168.2.245

            Port = 5000
            UserID = db2admin
            Password = nilgiris
            naming = 0
            DefaultLibraries = QGPL
            Database = NILGSERV
            ConnectionType = 0
            CommitMode = 2

            ExtendedDynamic = 1
            DefaultPkgLibrary = QGPL
            DefaultPackage = A/DEFAULT(IBM),2,0,1,0,512
            AllowDataCompression = 1
            MaxFieldLength = 32
            BlockFetch = 1

            BlockSizeKB = 128
            ExtendedColInfo = 0

            ***/etc/odbcinst.ini***

            [PostgreSQL]
            Description = ODBC for PostgreSQL
            Driver = /usr/lib/psqlodbc.so

            Setup = /usr/lib/libodbcpsqlS.so
            Driver64 = /usr/lib64/psqlodbc.so
            Setup64 = /usr/lib64/libodbcpsqlS.so
            FileUsage = 1

            [MySQL]
            Description = ODBC for MySQL

            Driver = /usr/lib/libmyodbc3_r.so
            Setup = /usr/lib/libodbcmyS.so
            Driver64 = /usr/lib64/libmyodbc3_r.so
            Setup64 = /usr/lib64/libodbcmyS.so
            FileUsage = 1

            [PostgreSQL64]
            Description = ODBC for PostgreSQL (64 bit)
            Driver = /usr/lib/psqlodbcw.so
            Setup = /usr/lib/libodbcpsqlS64.so
            Driver64 = /usr/lib64/psqlodbcw.so

            Setup64 = /usr/lib64/libodbcpsqlS64.so
            FileUsage = 1
            [MySQL64]
            Description = ODBC for MySQL (64 bit)
            Driver = /usr/lib/libmyodbc5.so
            Setup = /usr/lib/libodbcmyS64.so

            Driver64 = /usr/lib64/libmyodbc5.so
            Setup64 = /usr/lib64/libodbcmyS64.so
            FileUsage = 1

            [iSeries Access ODBC Driver]
            Description = iSeries Access for Linux ODBC Driver

            Driver = /opt/ibm/iSeriesAccess/lib64/libcwbodbc.so
            Driver64 = /opt/ibm/iSeriesAccess/lib64/libcwbodbc.so
            Setup = /opt/ibm/iSeriesAccess/lib64/libcwbodbcs.so
            Setup64 = /opt/ibm/iSeriesAccess/lib64/libcwbodbcs.so

            UsageCount = 1
            CPTimeout =
            CPReuse =
            NOTE1 = If using unixODBC 2.2.11 or later and you want the 32 and 64-bit ODBC drivers to share DSN's,
            NOTE2 = the following Driver64/Setup64 keywords will provide that support.

            Threading = 2
            DontDLClose = 1

            [iSeries Access ODBC Driver 64-bit]
            Description = iSeries Access for Linux 64-bit ODBC Driver
            Driver = /opt/ibm/iSeriesAccess/lib64/libcwbodbc.so

            Driver64 =
            Setup = /opt/ibm/iSeriesAccess/lib64/libcwbodbcs.so
            Setup64 =
            UsageCount = 1
            CPTimeout =
            CPReuse =
            Threading = 2

            DontDLClose = 1

            [DB2 UDB ODBC Driver]
            Description = DB2 Linux ODBC Driver (64 bit)
            Driver = /opt/IBMDB2_Driver/clidriver/lib/libdb2.so
            Driver64 = /opt/IBMDB2_Driver/clidriver/lib/libdb2.so

            UsageCount = 1
            CPTimeout =
            CPReuse =
            DontDLClose = 1
            Database = NILGDB2

            This is my odbc.ini,odbcinst.ini configuration.

            I have set env ODBCINI,ODBCINSTINI,still i have same error,pls do needful help for me

            Regards
            Dharma Lingam
            • 18. Re: Create DB-Link for Oracle Database 11g to IBM DB2
              Kgronau-Oracle
              Dharma,
              the odbc.ini is still not correct. Please have a look at the IBM link I provided earlier as it explains in detail which settings you have to do to connect to a UDB database using IBM's ODBC driver.

              When you still have problems once you modified it, please get a strace file:
              strace -fae -o isql.log isql -v dblink4db2 db2admin nilgiris

              strace is tracing all calls from isql and where it tries to find some dedicated info. This will help us to check your env.

              - Klaus
              • 19. Re: Create DB-Link for Oracle Database 11g to IBM DB2
                Dharma_
                Hai klaus,

                Thanks for ur support,

                I have changed odbc.ini and odbcinst.ini below

                ******odbc.ini********
                [dblink4db2]
                Driver64 = /Oracle/DBlink_RPM/odbc_cli/clidriver/lib/libdb2o.so
                Description = DB2 for ODBC Driver
                Server = 192.168.2.245
                Port = 50000
                UID = db2admin
                PWD = nilgiris
                Database = NILGDB2
                Trace = OFF

                ******odbcinst.ini******

                [dblink4db2]
                Driver64 = /Oracle/DBlink_RPM/odbc_cli/clidriver/lib/libdb2o.so
                Description = DB2 for ODBC Driver
                UsageCount = 1
                FileUsage = 1
                DontDLClose = 1

                and i have checked as you said from previous post "strace -fae -o isql.log isql -v dblink4db2 db2admin nilgiris".still i have same problem,

                [oradev@testebs bin]$ strace -fae -o isql.log isql -v dblink4db2 db2admin nilgiris
                [IM002][unixODBC][Driver Manager]Data source name not found, and no default driver specified
                [ISQL]ERROR: Could not SQLConnect

                *******isql.log*********

                18352 execve("/usr/local/bin/isql", ["isql", "-v", "dblink4db2", "db2admin", "nilgiris"], [* 43 vars */]) = 0
                18352 brk(0) = 0xe8a000
                18352 mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f6d54663000
                18352 mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f6d54662000
                18352 access("/etc/ld.so.preload", R_OK) = -1 ENOENT (No such file or directory)
                18352 open("/usr/local/lib/tls/x86_64/libodbc.so.2", O_RDONLY) = -1 ENOENT (No such file or directory)
                18352 stat("/usr/local/lib/tls/x86_64", 0x7fffc95b3d60) = -1 ENOENT (No such file or directory)
                18352 open("/usr/local/lib/tls/libodbc.so.2", O_RDONLY) = -1 ENOENT (No such file or directory)
                18352 stat("/usr/local/lib/tls", 0x7fffc95b3d60) = -1 ENOENT (No such file or directory)
                18352 open("/usr/local/lib/x86_64/libodbc.so.2", O_RDONLY) = -1 ENOENT (No such file or directory)
                18352 stat("/usr/local/lib/x86_64", 0x7fffc95b3d60) = -1 ENOENT (No such file or directory)
                18352 open("/usr/local/lib/libodbc.so.2", O_RDONLY) = 3
                18352 read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\360m\0\0\0\0\0\0"..., 832) = 832
                18352 fstat(3, {st_mode=S_IFREG|0775, st_size=1833714, ...}) = 0
                18352 mmap(NULL, 2523024, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7f6d543fa000
                18352 mprotect(0x7f6d5445a000, 2093056, PROT_NONE) = 0
                18352 mmap(0x7f6d54659000, 36864, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x5f000) = 0x7f6d54659000
                18352 close(3) = 0
                18352 open("/usr/local/lib/libreadline.so.5", O_RDONLY) = -1 ENOENT (No such file or directory)
                18352 open("tls/x86_64/libreadline.so.5", O_RDONLY) = -1 ENOENT (No such file or directory)
                18352 open("tls/libreadline.so.5", O_RDONLY) = -1 ENOENT (No such file or directory)
                18352 open("x86_64/libreadline.so.5", O_RDONLY) = -1 ENOENT (No such file or directory)
                18352 open("libreadline.so.5", O_RDONLY) = -1 ENOENT (No such file or directory)
                18352 open("/home/oradev/usr/local/lib/tls/x86_64/libreadline.so.5", O_RDONLY) = -1 ENOENT (No such file or directory)
                18352 stat("/home/oradev/usr/local/lib/tls/x86_64", 0x7fffc95b3d30) = -1 ENOENT (No such file or directory)
                18352 open("/home/oradev/usr/local/lib/tls/libreadline.so.5", O_RDONLY) = -1 ENOENT (No such file or directory)
                18352 stat("/home/oradev/usr/local/lib/tls", 0x7fffc95b3d30) = -1 ENOENT (No such file or directory)
                18352 open("/home/oradev/usr/local/lib/x86_64/libreadline.so.5", O_RDONLY) = -1 ENOENT (No such file or directory)
                18352 stat("/home/oradev/usr/local/lib/x86_64", 0x7fffc95b3d30) = -1 ENOENT (No such file or directory)
                18352 open("/home/oradev/usr/local/lib/libreadline.so.5", O_RDONLY) = -1 ENOENT (No such file or directory)
                18352 stat("/home/oradev/usr/local/lib", {st_mode=S_IFDIR|0775, st_size=4096, ...}) = 0
                18352 open("/etc/ld.so.cache", O_RDONLY) = 3
                18352 fstat(3, {st_mode=S_IFREG|0644, st_size=193721, ...}) = 0
                18352 mmap(NULL, 193721, PROT_READ, MAP_PRIVATE, 3, 0) = 0x7f6d543ca000
                18352 close(3) = 0
                18352 open("/usr/lib64/libreadline.so.5", O_RDONLY) = 3
                18352 read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\2209\341p7\0\0\0"..., 832) = 832
                18352 fstat(3, {st_mode=S_IFREG|0755, st_size=247544, ...}) = 0
                18352 mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f6d543c9000
                18352 mmap(0x3770e00000, 2345400, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x3770e00000
                18352 mprotect(0x3770e35000, 2093056, PROT_NONE) = 0
                18352 mmap(0x3771034000, 32768, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x34000) = 0x3771034000
                18352 mmap(0x377103c000, 2488, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x377103c000
                18352 close(3) = 0
                18352 open("/usr/local/lib/libncurses.so.5", O_RDONLY) = -1 ENOENT (No such file or directory)
                18352 open("tls/x86_64/libncurses.so.5", O_RDONLY) = -1 ENOENT (No such file or directory)
                18352 open("tls/libncurses.so.5", O_RDONLY) = -1 ENOENT (No such file or directory)
                18352 open("x86_64/libncurses.so.5", O_RDONLY) = -1 ENOENT (No such file or directory)
                18352 open("libncurses.so.5", O_RDONLY) = -1 ENOENT (No such file or directory)
                18352 open("/home/oradev/usr/local/lib/libncurses.so.5", O_RDONLY) = -1 ENOENT (No such file or directory)
                18352 open("/usr/lib64/libncurses.so.5", O_RDONLY) = 3
                18352 read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\20\375\1\2027\0\0\0"..., 832) = 832
                18352 fstat(3, {st_mode=S_IFREG|0755, st_size=380336, ...}) = 0
                18352 mmap(0x3782000000, 2476872, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x3782000000
                18352 mprotect(0x378204e000, 2097152, PROT_NONE) = 0
                18352 mmap(0x378224e000, 57344, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x4e000) = 0x378224e000
                18352 mmap(0x378225c000, 2888, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x378225c000
                18352 close(3) = 0
                18352 open("/usr/local/lib/libdl.so.2", O_RDONLY) = -1 ENOENT (No such file or directory)
                18352 open("tls/x86_64/libdl.so.2", O_RDONLY) = -1 ENOENT (No such file or directory)
                18352 open("tls/libdl.so.2", O_RDONLY) = -1 ENOENT (No such file or directory)
                18352 open("x86_64/libdl.so.2", O_RDONLY) = -1 ENOENT (No such file or directory)
                18352 open("libdl.so.2", O_RDONLY) = -1 ENOENT (No such file or directory)
                18352 open("/home/oradev/usr/local/lib/libdl.so.2", O_RDONLY) = -1 ENOENT (No such file or directory)
                18352 open("/lib64/libdl.so.2", O_RDONLY) = 3
                18352 read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\20\16`o7\0\0\0"..., 832) = 832
                18352 fstat(3, {st_mode=S_IFREG|0755, st_size=23360, ...}) = 0
                18352 mmap(0x376f600000, 2109696, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x376f600000
                18352 mprotect(0x376f602000, 2097152, PROT_NONE) = 0
                18352 mmap(0x376f802000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x2000) = 0x376f802000
                18352 close(3) = 0
                18352 open("/usr/local/lib/libpthread.so.0", O_RDONLY) = -1 ENOENT (No such file or directory)
                18352 open("tls/x86_64/libpthread.so.0", O_RDONLY) = -1 ENOENT (No such file or directory)
                18352 open("tls/libpthread.so.0", O_RDONLY) = -1 ENOENT (No such file or directory)
                18352 open("x86_64/libpthread.so.0", O_RDONLY) = -1 ENOENT (No such file or directory)
                18352 open("libpthread.so.0", O_RDONLY) = -1 ENOENT (No such file or directory)
                18352 open("/home/oradev/usr/local/lib/libpthread.so.0", O_RDONLY) = -1 ENOENT (No such file or directory)
                18352 open("/lib64/libpthread.so.0", O_RDONLY) = 3
                18352 read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\340W\340o7\0\0\0"..., 832) = 832
                18352 fstat(3, {st_mode=S_IFREG|0755, st_size=145872, ...}) = 0
                18352 mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f6d543c8000
                18352 mmap(0x376fe00000, 2204528, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x376fe00000
                18352 mprotect(0x376fe16000, 2093056, PROT_NONE) = 0
                18352 mmap(0x3770015000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x15000) = 0x3770015000
                18352 mmap(0x3770017000, 13168, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x3770017000
                18352 close(3) = 0
                18352 open("/usr/local/lib/libc.so.6", O_RDONLY) = -1 ENOENT (No such file or directory)
                18352 open("tls/x86_64/libc.so.6", O_RDONLY) = -1 ENOENT (No such file or directory)
                18352 open("tls/libc.so.6", O_RDONLY) = -1 ENOENT (No such file or directory)
                18352 open("x86_64/libc.so.6", O_RDONLY) = -1 ENOENT (No such file or directory)
                18352 open("libc.so.6", O_RDONLY) = -1 ENOENT (No such file or directory)
                18352 open("/home/oradev/usr/local/lib/libc.so.6", O_RDONLY) = -1 ENOENT (No such file or directory)
                18352 open("/lib64/libc.so.6", O_RDONLY) = 3
                18352 read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\220\332!o7\0\0\0"..., 832) = 832
                18352 fstat(3, {st_mode=S_IFREG|0755, st_size=1722328, ...}) = 0
                18352 mmap(0x376f200000, 3502424, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x376f200000
                18352 mprotect(0x376f34f000, 2093056, PROT_NONE) = 0
                18352 mmap(0x376f54e000, 20480, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x14e000) = 0x376f54e000
                18352 mmap(0x376f553000, 16728, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x376f553000
                18352 close(3) = 0
                18352 mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f6d543c7000
                18352 mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f6d543c6000
                18352 arch_prctl(ARCH_SET_FS, 0x7f6d543c66e0) = 0
                18352 mprotect(0x376f54e000, 16384, PROT_READ) = 0
                18352 mprotect(0x3770015000, 4096, PROT_READ) = 0
                18352 mprotect(0x376f802000, 4096, PROT_READ) = 0
                18352 mprotect(0x376ec1c000, 4096, PROT_READ) = 0
                18352 munmap(0x7f6d543ca000, 193721) = 0
                18352 set_tid_address(0x7f6d543c6770) = 18352
                18352 set_robust_list(0x7f6d543c6780, 0x18) = 0
                18352 futex(0x7fffc95b48bc, FUTEX_WAKE_PRIVATE, 1) = 0
                18352 rt_sigaction(SIGRTMIN, {0x376fe053c0, [], SA_RESTORER|SA_SIGINFO, 0x376fe0ebe0}, NULL, 8) = 0
                18352 rt_sigaction(SIGRT_1, {0x376fe052f0, [], SA_RESTORER|SA_RESTART|SA_SIGINFO, 0x376fe0ebe0}, NULL, 8) = 0
                18352 rt_sigprocmask(SIG_UNBLOCK, [RTMIN RT_1], NULL, 8) = 0
                18352 getrlimit(RLIMIT_STACK, {rlim_cur=8192*1024, rlim_max=RLIM_INFINITY}) = 0
                18352 brk(0) = 0xe8a000
                18352 brk(0xeab000) = 0xeab000
                18352 open("/usr/lib/locale/locale-archive", O_RDONLY) = 3
                18352 fstat(3, {st_mode=S_IFREG|0644, st_size=56434368, ...}) = 0
                18352 mmap(NULL, 56434368, PROT_READ, MAP_PRIVATE, 3, 0) = 0x7f6d50df4000
                18352 close(3) = 0
                18352 open("/etc/odbcinst.ini", O_RDONLY) = 3
                18352 fstat(3, {st_mode=S_IFREG|0644, st_size=173, ...}) = 0
                18352 mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f6d543f9000
                18352 read(3, "[dblink4db2]\nDriver64\t\t= /Oracle"..., 4096) = 173
                18352 read(3, "", 4096) = 0
                18352 close(3) = 0
                18352 munmap(0x7f6d543f9000, 4096) = 0
                18352 open("/home/oradev/.odbcinst.ini", O_RDONLY) = -1 ENOENT (No such file or directory)
                18352 open("/etc/odbcinst.ini", O_RDONLY) = 3
                18352 fstat(3, {st_mode=S_IFREG|0644, st_size=173, ...}) = 0
                18352 mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f6d543f9000
                18352 read(3, "[dblink4db2]\nDriver64\t\t= /Oracle"..., 4096) = 173
                18352 read(3, "", 4096) = 0
                18352 close(3) = 0
                18352 munmap(0x7f6d543f9000, 4096) = 0
                18352 open("/home/oradev/.odbcinst.ini", O_RDONLY) = -1 ENOENT (No such file or directory)
                18352 getuid() = 501
                18352 socket(PF_FILE, SOCK_STREAM, 0) = 3
                18352 fcntl(3, F_SETFL, O_RDWR|O_NONBLOCK) = 0
                18352 connect(3, {sa_family=AF_FILE, path="/var/run/nscd/socket"...}, 110) = -1 ENOENT (No such file or directory)
                18352 close(3) = 0
                18352 socket(PF_FILE, SOCK_STREAM, 0) = 3
                18352 fcntl(3, F_SETFL, O_RDWR|O_NONBLOCK) = 0
                18352 connect(3, {sa_family=AF_FILE, path="/var/run/nscd/socket"...}, 110) = -1 ENOENT (No such file or directory)
                18352 close(3) = 0
                18352 open("/etc/nsswitch.conf", O_RDONLY) = 3
                18352 fstat(3, {st_mode=S_IFREG|0644, st_size=1716, ...}) = 0
                18352 mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f6d543f9000
                18352 read(3, "#\n# /etc/nsswitch.conf\n#\n# An ex"..., 4096) = 1716
                18352 read(3, "", 4096) = 0
                18352 close(3) = 0
                18352 munmap(0x7f6d543f9000, 4096) = 0
                18352 open("/usr/local/lib/libnss_files.so.2", O_RDONLY) = -1 ENOENT (No such file or directory)
                18352 open("tls/x86_64/libnss_files.so.2", O_RDONLY) = -1 ENOENT (No such file or directory)
                18352 open("tls/libnss_files.so.2", O_RDONLY) = -1 ENOENT (No such file or directory)
                18352 open("x86_64/libnss_files.so.2", O_RDONLY) = -1 ENOENT (No such file or directory)
                18352 open("libnss_files.so.2", O_RDONLY) = -1 ENOENT (No such file or directory)
                18352 open("/home/oradev/usr/local/lib/libnss_files.so.2", O_RDONLY) = -1 ENOENT (No such file or directory)
                18352 open("/etc/ld.so.cache", O_RDONLY) = 3
                18352 fstat(3, {st_mode=S_IFREG|0644, st_size=193721, ...}) = 0
                18352 mmap(NULL, 193721, PROT_READ, MAP_PRIVATE, 3, 0) = 0x7f6d543ca000
                18352 close(3) = 0
                18352 open("/lib64/libnss_files.so.2", O_RDONLY) = 3
                18352 read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\340\37\0\0\0\0\0\0"..., 832) = 832
                18352 fstat(3, {st_mode=S_IFREG|0755, st_size=53880, ...}) = 0
                18352 mmap(NULL, 2139432, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7f6d50be9000
                18352 mprotect(0x7f6d50bf3000, 2093056, PROT_NONE) = 0
                18352 mmap(0x7f6d50df2000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x9000) = 0x7f6d50df2000
                18352 close(3) = 0
                18352 mprotect(0x7f6d50df2000, 4096, PROT_READ) = 0
                18352 munmap(0x7f6d543ca000, 193721) = 0
                18352 open("/etc/passwd", O_RDONLY) = 3
                18352 fcntl(3, F_GETFD) = 0
                18352 fcntl(3, F_SETFD, FD_CLOEXEC) = 0
                18352 fstat(3, {st_mode=S_IFREG|0644, st_size=2974, ...}) = 0
                18352 mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f6d543f9000
                18352 read(3, "root:x:0:0:root:/root:/bin/bash\n"..., 4096) = 2974
                18352 close(3) = 0
                18352 munmap(0x7f6d543f9000, 4096) = 0
                18352 open("/etc/odbc.ini", O_WRONLY|O_CREAT|O_APPEND, 0666) = -1 EACCES (Permission denied)
                18352 open("/etc/odbc.ini", O_RDONLY) = 3
                18352 fstat(3, {st_mode=S_IFREG|0644, st_size=266, ...}) = 0
                18352 mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f6d543f9000
                18352 read(3, "[dblink4db2]\nDriver64 \t"..., 4096) = 266
                18352 read(3, "", 4096) = 0
                18352 close(3) = 0
                18352 munmap(0x7f6d543f9000, 4096) = 0
                18352 open("/etc/odbc.ini", O_RDONLY) = 3
                18352 close(3) = 0
                18352 open("/etc/odbc.ini", O_RDONLY) = 3
                18352 fstat(3, {st_mode=S_IFREG|0644, st_size=266, ...}) = 0
                18352 mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f6d543f9000
                18352 read(3, "[dblink4db2]\nDriver64 \t"..., 4096) = 266
                18352 read(3, "", 4096) = 0
                18352 close(3) = 0
                18352 munmap(0x7f6d543f9000, 4096) = 0
                18352 getuid() = 501
                18352 open("/etc/passwd", O_RDONLY) = 3
                18352 fcntl(3, F_GETFD) = 0
                18352 fcntl(3, F_SETFD, FD_CLOEXEC) = 0
                18352 fstat(3, {st_mode=S_IFREG|0644, st_size=2974, ...}) = 0
                18352 mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f6d543f9000
                18352 read(3, "root:x:0:0:root:/root:/bin/bash\n"..., 4096) = 2974
                18352 close(3) = 0
                18352 munmap(0x7f6d543f9000, 4096) = 0
                18352 open("/etc/odbc.ini", O_WRONLY|O_CREAT|O_APPEND, 0666) = -1 EACCES (Permission denied)
                18352 open("/etc/odbc.ini", O_RDONLY) = 3
                18352 fstat(3, {st_mode=S_IFREG|0644, st_size=266, ...}) = 0
                18352 mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f6d543f9000
                18352 read(3, "[dblink4db2]\nDriver64 \t"..., 4096) = 266
                18352 read(3, "", 4096) = 0
                18352 close(3) = 0
                18352 munmap(0x7f6d543f9000, 4096) = 0
                18352 open("/etc/odbc.ini", O_RDONLY) = 3
                18352 close(3) = 0
                18352 open("/etc/odbc.ini", O_RDONLY) = 3
                18352 fstat(3, {st_mode=S_IFREG|0644, st_size=266, ...}) = 0
                18352 mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f6d543f9000
                18352 read(3, "[dblink4db2]\nDriver64 \t"..., 4096) = 266
                18352 read(3, "", 4096) = 0
                18352 close(3) = 0
                18352 munmap(0x7f6d543f9000, 4096) = 0
                18352 fstat(1, {st_mode=S_IFCHR|0620, st_rdev=makedev(136, 2), ...}) = 0
                18352 mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f6d543f9000
                18352 write(1, "[IM002][unixODBC][Driver Manager"..., 93) = 93
                18352 write(2, "[ISQL]ERROR: Could not SQLConnec"..., 34) = 34
                18352 exit_group(1) = ?

                I have update odbc.ini,odbcinst.ini,and isql.log

                Regards
                Dharma Lingam
                • 20. Re: Create DB-Link for Oracle Database 11g to IBM DB2
                  Kgronau-Oracle
                  strace shows:
                  18352 open("/etc/odbc.ini", O_WRONLY|O_CREAT|O_APPEND, 0666) = -1 EACCES (Permission denied)
                  18352 open("/etc/odbc.ini", O_RDONLY) = 3
                  Are you sure the current user can access the odbc.ini file? Maybe as a test add all privileges to everybody for the odbc.ini file -> chmod 777 /etc/odbc.ini
                  • 21. Re: Create DB-Link for Oracle Database 11g to IBM DB2
                    Dharma_
                    Hai klaus,

                    I give all permission to odbc.ini file,but still i got same error,

                    [oradev@testebs cfg]$ isql -v dblink4db2 db2admin nilgiris
                    [IM002][unixODBC][Driver Manager]Data source name not found, and no default driver specified
                    [ISQL]ERROR: Could not SQLConnect
                    [oradev@testebs cfg]$


                    *******isql.log********

                    19874 execve("/usr/local/bin/isql", ["isql", "-v", "dblink4db2", "db2admin", "nilgiris"], [* 43 vars */]) = 0
                    19874 brk(0) = 0x1e0f000
                    19874 mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7fc3ba937000
                    19874 mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7fc3ba936000
                    19874 access("/etc/ld.so.preload", R_OK) = -1 ENOENT (No such file or directory)
                    19874 open("/usr/local/lib/tls/x86_64/libodbc.so.2", O_RDONLY) = -1 ENOENT (No such file or directory)
                    19874 stat("/usr/local/lib/tls/x86_64", 0x7fffa339f0b0) = -1 ENOENT (No such file or directory)
                    19874 open("/usr/local/lib/tls/libodbc.so.2", O_RDONLY) = -1 ENOENT (No such file or directory)
                    19874 stat("/usr/local/lib/tls", 0x7fffa339f0b0) = -1 ENOENT (No such file or directory)
                    19874 open("/usr/local/lib/x86_64/libodbc.so.2", O_RDONLY) = -1 ENOENT (No such file or directory)
                    19874 stat("/usr/local/lib/x86_64", 0x7fffa339f0b0) = -1 ENOENT (No such file or directory)
                    19874 open("/usr/local/lib/libodbc.so.2", O_RDONLY) = 3
                    19874 read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\360m\0\0\0\0\0\0"..., 832) = 832
                    19874 fstat(3, {st_mode=S_IFREG|0775, st_size=1833714, ...}) = 0
                    19874 mmap(NULL, 2523024, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7fc3ba6ce000
                    19874 mprotect(0x7fc3ba72e000, 2093056, PROT_NONE) = 0
                    19874 mmap(0x7fc3ba92d000, 36864, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x5f000) = 0x7fc3ba92d000
                    19874 close(3) = 0
                    19874 open("/usr/local/lib/libreadline.so.5", O_RDONLY) = -1 ENOENT (No such file or directory)
                    19874 open("tls/x86_64/libreadline.so.5", O_RDONLY) = -1 ENOENT (No such file or directory)
                    19874 open("tls/libreadline.so.5", O_RDONLY) = -1 ENOENT (No such file or directory)
                    19874 open("x86_64/libreadline.so.5", O_RDONLY) = -1 ENOENT (No such file or directory)
                    19874 open("libreadline.so.5", O_RDONLY) = -1 ENOENT (No such file or directory)
                    19874 open("/home/oradev/usr/local/lib/tls/x86_64/libreadline.so.5", O_RDONLY) = -1 ENOENT (No such file or directory)
                    19874 stat("/home/oradev/usr/local/lib/tls/x86_64", 0x7fffa339f080) = -1 ENOENT (No such file or directory)
                    19874 open("/home/oradev/usr/local/lib/tls/libreadline.so.5", O_RDONLY) = -1 ENOENT (No such file or directory)
                    19874 stat("/home/oradev/usr/local/lib/tls", 0x7fffa339f080) = -1 ENOENT (No such file or directory)
                    19874 open("/home/oradev/usr/local/lib/x86_64/libreadline.so.5", O_RDONLY) = -1 ENOENT (No such file or directory)
                    19874 stat("/home/oradev/usr/local/lib/x86_64", 0x7fffa339f080) = -1 ENOENT (No such file or directory)
                    19874 open("/home/oradev/usr/local/lib/libreadline.so.5", O_RDONLY) = -1 ENOENT (No such file or directory)
                    19874 stat("/home/oradev/usr/local/lib", {st_mode=S_IFDIR|0775, st_size=4096, ...}) = 0
                    19874 open("/etc/ld.so.cache", O_RDONLY) = 3
                    19874 fstat(3, {st_mode=S_IFREG|0644, st_size=193721, ...}) = 0
                    19874 mmap(NULL, 193721, PROT_READ, MAP_PRIVATE, 3, 0) = 0x7fc3ba69e000
                    19874 close(3) = 0
                    19874 open("/usr/lib64/libreadline.so.5", O_RDONLY) = 3
                    19874 read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\2209\341p7\0\0\0"..., 832) = 832
                    19874 fstat(3, {st_mode=S_IFREG|0755, st_size=247544, ...}) = 0
                    19874 mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7fc3ba69d000
                    19874 mmap(0x3770e00000, 2345400, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x3770e00000
                    19874 mprotect(0x3770e35000, 2093056, PROT_NONE) = 0
                    19874 mmap(0x3771034000, 32768, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x34000) = 0x3771034000
                    19874 mmap(0x377103c000, 2488, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x377103c000
                    19874 close(3) = 0
                    19874 open("/usr/local/lib/libncurses.so.5", O_RDONLY) = -1 ENOENT (No such file or directory)
                    19874 open("tls/x86_64/libncurses.so.5", O_RDONLY) = -1 ENOENT (No such file or directory)
                    19874 open("tls/libncurses.so.5", O_RDONLY) = -1 ENOENT (No such file or directory)
                    19874 open("x86_64/libncurses.so.5", O_RDONLY) = -1 ENOENT (No such file or directory)
                    19874 open("libncurses.so.5", O_RDONLY) = -1 ENOENT (No such file or directory)
                    19874 open("/home/oradev/usr/local/lib/libncurses.so.5", O_RDONLY) = -1 ENOENT (No such file or directory)
                    19874 open("/usr/lib64/libncurses.so.5", O_RDONLY) = 3
                    19874 read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\20\375\1\2027\0\0\0"..., 832) = 832
                    19874 fstat(3, {st_mode=S_IFREG|0755, st_size=380336, ...}) = 0
                    19874 mmap(0x3782000000, 2476872, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x3782000000
                    19874 mprotect(0x378204e000, 2097152, PROT_NONE) = 0
                    19874 mmap(0x378224e000, 57344, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x4e000) = 0x378224e000
                    19874 mmap(0x378225c000, 2888, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x378225c000
                    19874 close(3) = 0
                    19874 open("/usr/local/lib/libdl.so.2", O_RDONLY) = -1 ENOENT (No such file or directory)
                    19874 open("tls/x86_64/libdl.so.2", O_RDONLY) = -1 ENOENT (No such file or directory)
                    19874 open("tls/libdl.so.2", O_RDONLY) = -1 ENOENT (No such file or directory)
                    19874 open("x86_64/libdl.so.2", O_RDONLY) = -1 ENOENT (No such file or directory)
                    19874 open("libdl.so.2", O_RDONLY) = -1 ENOENT (No such file or directory)
                    19874 open("/home/oradev/usr/local/lib/libdl.so.2", O_RDONLY) = -1 ENOENT (No such file or directory)
                    19874 open("/lib64/libdl.so.2", O_RDONLY) = 3
                    19874 read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\20\16`o7\0\0\0"..., 832) = 832
                    19874 fstat(3, {st_mode=S_IFREG|0755, st_size=23360, ...}) = 0
                    19874 mmap(0x376f600000, 2109696, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x376f600000
                    19874 mprotect(0x376f602000, 2097152, PROT_NONE) = 0
                    19874 mmap(0x376f802000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x2000) = 0x376f802000
                    19874 close(3) = 0
                    19874 open("/usr/local/lib/libpthread.so.0", O_RDONLY) = -1 ENOENT (No such file or directory)
                    19874 open("tls/x86_64/libpthread.so.0", O_RDONLY) = -1 ENOENT (No such file or directory)
                    19874 open("tls/libpthread.so.0", O_RDONLY) = -1 ENOENT (No such file or directory)
                    19874 open("x86_64/libpthread.so.0", O_RDONLY) = -1 ENOENT (No such file or directory)
                    19874 open("libpthread.so.0", O_RDONLY) = -1 ENOENT (No such file or directory)
                    19874 open("/home/oradev/usr/local/lib/libpthread.so.0", O_RDONLY) = -1 ENOENT (No such file or directory)
                    19874 open("/lib64/libpthread.so.0", O_RDONLY) = 3
                    19874 read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\340W\340o7\0\0\0"..., 832) = 832
                    19874 fstat(3, {st_mode=S_IFREG|0755, st_size=145872, ...}) = 0
                    19874 mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7fc3ba69c000
                    19874 mmap(0x376fe00000, 2204528, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x376fe00000
                    19874 mprotect(0x376fe16000, 2093056, PROT_NONE) = 0
                    19874 mmap(0x3770015000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x15000) = 0x3770015000
                    19874 mmap(0x3770017000, 13168, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x3770017000
                    19874 close(3) = 0
                    19874 open("/usr/local/lib/libc.so.6", O_RDONLY) = -1 ENOENT (No such file or directory)
                    19874 open("tls/x86_64/libc.so.6", O_RDONLY) = -1 ENOENT (No such file or directory)
                    19874 open("tls/libc.so.6", O_RDONLY) = -1 ENOENT (No such file or directory)
                    19874 open("x86_64/libc.so.6", O_RDONLY) = -1 ENOENT (No such file or directory)
                    19874 open("libc.so.6", O_RDONLY) = -1 ENOENT (No such file or directory)
                    19874 open("/home/oradev/usr/local/lib/libc.so.6", O_RDONLY) = -1 ENOENT (No such file or directory)
                    19874 open("/lib64/libc.so.6", O_RDONLY) = 3
                    19874 read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\220\332!o7\0\0\0"..., 832) = 832
                    19874 fstat(3, {st_mode=S_IFREG|0755, st_size=1722328, ...}) = 0
                    19874 mmap(0x376f200000, 3502424, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x376f200000
                    19874 mprotect(0x376f34f000, 2093056, PROT_NONE) = 0
                    19874 mmap(0x376f54e000, 20480, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x14e000) = 0x376f54e000
                    19874 mmap(0x376f553000, 16728, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x376f553000
                    19874 close(3) = 0
                    19874 mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7fc3ba69b000
                    19874 mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7fc3ba69a000
                    19874 arch_prctl(ARCH_SET_FS, 0x7fc3ba69a6e0) = 0
                    19874 mprotect(0x376f54e000, 16384, PROT_READ) = 0
                    19874 mprotect(0x3770015000, 4096, PROT_READ) = 0
                    19874 mprotect(0x376f802000, 4096, PROT_READ) = 0
                    19874 mprotect(0x376ec1c000, 4096, PROT_READ) = 0
                    19874 munmap(0x7fc3ba69e000, 193721) = 0
                    19874 set_tid_address(0x7fc3ba69a770) = 19874
                    19874 set_robust_list(0x7fc3ba69a780, 0x18) = 0
                    19874 futex(0x7fffa339fc0c, FUTEX_WAKE_PRIVATE, 1) = 0
                    19874 rt_sigaction(SIGRTMIN, {0x376fe053c0, [], SA_RESTORER|SA_SIGINFO, 0x376fe0ebe0}, NULL, 8) = 0
                    19874 rt_sigaction(SIGRT_1, {0x376fe052f0, [], SA_RESTORER|SA_RESTART|SA_SIGINFO, 0x376fe0ebe0}, NULL, 8) = 0
                    19874 rt_sigprocmask(SIG_UNBLOCK, [RTMIN RT_1], NULL, 8) = 0
                    19874 getrlimit(RLIMIT_STACK, {rlim_cur=8192*1024, rlim_max=RLIM_INFINITY}) = 0
                    19874 brk(0) = 0x1e0f000
                    19874 brk(0x1e30000) = 0x1e30000
                    19874 open("/usr/lib/locale/locale-archive", O_RDONLY) = 3
                    19874 fstat(3, {st_mode=S_IFREG|0644, st_size=56434368, ...}) = 0
                    19874 mmap(NULL, 56434368, PROT_READ, MAP_PRIVATE, 3, 0) = 0x7fc3b70c8000
                    19874 close(3) = 0
                    19874 open("/etc/odbcinst.ini", O_RDONLY) = 3
                    19874 fstat(3, {st_mode=S_IFREG|0777, st_size=173, ...}) = 0
                    19874 mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7fc3ba6cd000
                    19874 read(3, "[dblink4db2]\nDriver64\t\t= /Oracle"..., 4096) = 173
                    19874 read(3, "", 4096) = 0
                    19874 close(3) = 0
                    19874 munmap(0x7fc3ba6cd000, 4096) = 0
                    19874 open("/home/oradev/.odbcinst.ini", O_RDONLY) = -1 ENOENT (No such file or directory)
                    19874 open("/etc/odbcinst.ini", O_RDONLY) = 3
                    19874 fstat(3, {st_mode=S_IFREG|0777, st_size=173, ...}) = 0
                    19874 mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7fc3ba6cd000
                    19874 read(3, "[dblink4db2]\nDriver64\t\t= /Oracle"..., 4096) = 173
                    19874 read(3, "", 4096) = 0
                    19874 close(3) = 0
                    19874 munmap(0x7fc3ba6cd000, 4096) = 0
                    19874 open("/home/oradev/.odbcinst.ini", O_RDONLY) = -1 ENOENT (No such file or directory)
                    19874 getuid() = 501
                    19874 socket(PF_FILE, SOCK_STREAM, 0) = 3
                    19874 fcntl(3, F_SETFL, O_RDWR|O_NONBLOCK) = 0
                    19874 connect(3, {sa_family=AF_FILE, path="/var/run/nscd/socket"...}, 110) = -1 ENOENT (No such file or directory)
                    19874 close(3) = 0
                    19874 socket(PF_FILE, SOCK_STREAM, 0) = 3
                    19874 fcntl(3, F_SETFL, O_RDWR|O_NONBLOCK) = 0
                    19874 connect(3, {sa_family=AF_FILE, path="/var/run/nscd/socket"...}, 110) = -1 ENOENT (No such file or directory)
                    19874 close(3) = 0
                    19874 open("/etc/nsswitch.conf", O_RDONLY) = 3
                    19874 fstat(3, {st_mode=S_IFREG|0644, st_size=1716, ...}) = 0
                    19874 mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7fc3ba6cd000
                    19874 read(3, "#\n# /etc/nsswitch.conf\n#\n# An ex"..., 4096) = 1716
                    19874 read(3, "", 4096) = 0
                    19874 close(3) = 0
                    19874 munmap(0x7fc3ba6cd000, 4096) = 0
                    19874 open("/usr/local/lib/libnss_files.so.2", O_RDONLY) = -1 ENOENT (No such file or directory)
                    19874 open("tls/x86_64/libnss_files.so.2", O_RDONLY) = -1 ENOENT (No such file or directory)
                    19874 open("tls/libnss_files.so.2", O_RDONLY) = -1 ENOENT (No such file or directory)
                    19874 open("x86_64/libnss_files.so.2", O_RDONLY) = -1 ENOENT (No such file or directory)
                    19874 open("libnss_files.so.2", O_RDONLY) = -1 ENOENT (No such file or directory)
                    19874 open("/home/oradev/usr/local/lib/libnss_files.so.2", O_RDONLY) = -1 ENOENT (No such file or directory)
                    19874 open("/etc/ld.so.cache", O_RDONLY) = 3
                    19874 fstat(3, {st_mode=S_IFREG|0644, st_size=193721, ...}) = 0
                    19874 mmap(NULL, 193721, PROT_READ, MAP_PRIVATE, 3, 0) = 0x7fc3ba69e000
                    19874 close(3) = 0
                    19874 open("/lib64/libnss_files.so.2", O_RDONLY) = 3
                    19874 read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\340\37\0\0\0\0\0\0"..., 832) = 832
                    19874 fstat(3, {st_mode=S_IFREG|0755, st_size=53880, ...}) = 0
                    19874 mmap(NULL, 2139432, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7fc3b6ebd000
                    19874 mprotect(0x7fc3b6ec7000, 2093056, PROT_NONE) = 0
                    19874 mmap(0x7fc3b70c6000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x9000) = 0x7fc3b70c6000
                    19874 close(3) = 0
                    19874 mprotect(0x7fc3b70c6000, 4096, PROT_READ) = 0
                    19874 munmap(0x7fc3ba69e000, 193721) = 0
                    19874 open("/etc/passwd", O_RDONLY) = 3
                    19874 fcntl(3, F_GETFD) = 0
                    19874 fcntl(3, F_SETFD, FD_CLOEXEC) = 0
                    19874 fstat(3, {st_mode=S_IFREG|0644, st_size=2974, ...}) = 0
                    19874 mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7fc3ba6cd000
                    19874 read(3, "root:x:0:0:root:/root:/bin/bash\n"..., 4096) = 2974
                    19874 close(3) = 0
                    19874 munmap(0x7fc3ba6cd000, 4096) = 0
                    19874 open("/etc/odbc.ini", O_WRONLY|O_CREAT|O_APPEND, 0666) = 3
                    19874 fstat(3, {st_mode=S_IFREG|0777, st_size=266, ...}) = 0
                    19874 mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7fc3ba6cd000
                    19874 fstat(3, {st_mode=S_IFREG|0777, st_size=266, ...}) = 0
                    19874 lseek(3, 266, SEEK_SET) = 266
                    19874 close(3) = 0
                    19874 munmap(0x7fc3ba6cd000, 4096) = 0
                    19874 open("/etc/odbc.ini", O_RDONLY) = 3
                    19874 fstat(3, {st_mode=S_IFREG|0777, st_size=266, ...}) = 0
                    19874 mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7fc3ba6cd000
                    19874 read(3, "[dblink4db2]\nDriver64 \t"..., 4096) = 266
                    19874 read(3, "", 4096) = 0
                    19874 close(3) = 0
                    19874 munmap(0x7fc3ba6cd000, 4096) = 0
                    19874 open("/etc/odbc.ini", O_RDONLY) = 3
                    19874 close(3) = 0
                    19874 open("/etc/odbc.ini", O_RDONLY) = 3
                    19874 fstat(3, {st_mode=S_IFREG|0777, st_size=266, ...}) = 0
                    19874 mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7fc3ba6cd000
                    19874 read(3, "[dblink4db2]\nDriver64 \t"..., 4096) = 266
                    19874 read(3, "", 4096) = 0
                    19874 close(3) = 0
                    19874 munmap(0x7fc3ba6cd000, 4096) = 0
                    19874 getuid() = 501
                    19874 open("/etc/passwd", O_RDONLY) = 3
                    19874 fcntl(3, F_GETFD) = 0
                    19874 fcntl(3, F_SETFD, FD_CLOEXEC) = 0
                    19874 fstat(3, {st_mode=S_IFREG|0644, st_size=2974, ...}) = 0
                    19874 mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7fc3ba6cd000
                    19874 read(3, "root:x:0:0:root:/root:/bin/bash\n"..., 4096) = 2974
                    19874 close(3) = 0
                    19874 munmap(0x7fc3ba6cd000, 4096) = 0
                    19874 open("/etc/odbc.ini", O_WRONLY|O_CREAT|O_APPEND, 0666) = 3
                    19874 fstat(3, {st_mode=S_IFREG|0777, st_size=266, ...}) = 0
                    19874 mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7fc3ba6cd000
                    19874 fstat(3, {st_mode=S_IFREG|0777, st_size=266, ...}) = 0
                    19874 lseek(3, 266, SEEK_SET) = 266
                    19874 close(3) = 0
                    19874 munmap(0x7fc3ba6cd000, 4096) = 0
                    19874 open("/etc/odbc.ini", O_RDONLY) = 3
                    19874 fstat(3, {st_mode=S_IFREG|0777, st_size=266, ...}) = 0
                    19874 mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7fc3ba6cd000
                    19874 read(3, "[dblink4db2]\nDriver64 \t"..., 4096) = 266
                    19874 read(3, "", 4096) = 0
                    19874 close(3) = 0
                    19874 munmap(0x7fc3ba6cd000, 4096) = 0
                    19874 open("/etc/odbc.ini", O_RDONLY) = 3
                    19874 close(3) = 0
                    19874 open("/etc/odbc.ini", O_RDONLY) = 3
                    19874 fstat(3, {st_mode=S_IFREG|0777, st_size=266, ...}) = 0
                    19874 mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7fc3ba6cd000
                    19874 read(3, "[dblink4db2]\nDriver64 \t"..., 4096) = 266
                    19874 read(3, "", 4096) = 0
                    19874 close(3) = 0
                    19874 munmap(0x7fc3ba6cd000, 4096) = 0
                    19874 fstat(1, {st_mode=S_IFCHR|0620, st_rdev=makedev(136, 2), ...}) = 0
                    19874 mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7fc3ba6cd000
                    19874 write(1, "[IM002][unixODBC][Driver Manager"..., 93) = 93
                    19874 write(2, "[ISQL]ERROR: Could not SQLConnec"..., 34) = 34
                    19874 exit_group(1) = ?

                    After changes, i have generated log file above,

                    Regads
                    Dharma Lingam
                    • 22. Re: Create DB-Link for Oracle Database 11g to IBM DB2
                      Kgronau-Oracle
                      Dharma,
                      I'm sorry but your odbc.ini is still not correct.

                      For example you have:
                      Driver64 = /Oracle/DBlink_RPM/odbc_cli/clidriver/lib/libdb2o.so
                      But in the odbc.ini you only have to specify DRIVER, not DRIVER64.

                      When having a look at the IBM documentation, they give you an example odbc.ini which will only contain these settings (adopted to your env):
                      [dblink4db2]
                      Driver = /opt/IBMDB2_Driver/clidriver/lib/libdb2.so
                      Description = DB2 LUW ODBC Database
                      ConvToUtf = Yes
                      ConvWToUtf = Yes
                      VarMaxAsLong = Yes


                      As we (Mike and I already suggested) if you have problems with the ODBC driver configuration it would be good to get in touch with the ODBC vendor.
                      • 23. Re: Create DB-Link for Oracle Database 11g to IBM DB2
                        Dharma_
                        Hai kalus,

                        sure,I have give 777 Permission,odbc.ini file

                        Regards
                        Dharma
                        • 24. Re: Create DB-Link for Oracle Database 11g to IBM DB2
                          Kgronau-Oracle
                          the permission is now correct, but not the content of the file. You can copy/paste my suggestion into your odbc.ini file and give it a try....

                          Edited by: kgronau on Aug 3, 2012 1:28 PM
                          Have a look at this external page, it explains the steps:
                          http://www.easysoft.com/products/data_access/odbc-db2-driver/unixodbc.html
                          • 25. Re: Create DB-Link for Oracle Database 11g to IBM DB2
                            Dharma_
                            Hai klaus,

                            Now error changed,Now is it find driver?

                            [S1009][unixODBC][IBM][CLI Driver] CLI0124E Invalid argument value. SQLSTATE=S1009
                            [ISQL]ERROR: Could not SQLConnect

                            Regards
                            Dharma
                            • 26. Re: Create DB-Link for Oracle Database 11g to IBM DB2
                              Kgronau-Oracle
                              Dharma,
                              Are you sure all parameters you have configured in db2dsdriver.cfg are correct?
                              Did you test a native DB2 CLI using "dbcli" connection as described on this page from Easysoft: http://www.easysoft.com/products/data_access/odbc-db2-driver/unixodbc.html ?
                              • 27. Re: Create DB-Link for Oracle Database 11g to IBM DB2
                                Dharma_
                                Hai klaus,

                                thnks a lot klaus,now I get connected using isql,but after that,I can't query tables,Please see the below error,

                                [oradev@testebs bin]$ strace -fae -o isql.log isql -v dblink4db2 db2admin nilgiris
                                ---------------------------------------
                                | Connected! |
                                | |
                                | sql-statement |
                                | help [tablename] |
                                | quit |
                                | |
                                ---------------------------------------
                                SQL> show tables
                                [42601][unixODBC][IBM][CLI Driver][DB2/NT] SQL0104N An unexpected token "END-OF-STATEMENT" was found following "show tables". Expected tokens may include: "JOIN <joined_table>". SQLSTATE=42601

                                [ISQL]ERROR: Could not SQLExecute
                                SQL> sql-statement
                                [42601][unixODBC][IBM][CLI Driver][DB2/NT] SQL0104N An unexpected token "-statement" was found following "sql". Expected tokens may include: "<space>". SQLSTATE=42601

                                [ISQL]ERROR: Could not SQLExecute
                                SQL> quit


                                I Will show error log below

                                14831 mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f1b6f1e9000
                                14831 write(1, "+-------------------------------"..., 42) = 42
                                14831 write(1, "| Connected! "..., 42) = 42
                                14831 write(1, "| "..., 42) = 42
                                14831 write(1, "| sql-statement "..., 42) = 42
                                14831 write(1, "| help [tablename] "..., 42) = 42
                                14831 write(1, "| quit "..., 42) = 42
                                14831 write(1, "| "..., 42) = 42
                                14831 write(1, "+-------------------------------"..., 42) = 42
                                14831 fstat(0, {st_mode=S_IFCHR|0620, st_rdev=makedev(136, 3), ...}) = 0
                                14831 mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f1b6f1e8000
                                14831 write(1, "SQL> ", 5) = 5
                                14831 read(0, "show tables\n", 1024) = 12
                                14831 semget(0xf7643174, 1, 0) = -1 ENOENT (No such file or directory)
                                14831 semget(0xf7643174, 1, 0) = -1 ENOENT (No such file or directory)
                                14831 semop(7569429, 0x7fff4955da30, 2) = 0
                                14831 semop(7569429, 0x7fff4955da30, 1) = 0
                                14831 semget(0xf7643174, 1, 0) = -1 ENOENT (No such file or directory)
                                14831 semget(0xf7643174, 1, 0) = -1 ENOENT (No such file or directory)
                                14831 sendto(3, "\0\22\320A\0\1\0\f\20A\0\10\24\4\24\314\4\270\0N\320Q\0\2\0H \24\0D!\23"..., 405, 0, NULL, 0) = 405
                                14831 recvfrom(3, "\0\22\320C\0\1\0\f\24C\0\10\24\4\24\314\4\270\0\v\320C\0\2\0\5$\10\377\0\211\320"..., 131072, 0, NULL, NULL) = 370
                                14831 semget(0xf7643174, 1, 0) = -1 ENOENT (No such file or directory)
                                14831 semget(0xf7643174, 1, 0) = -1 ENOENT (No such file or directory)
                                14831 semget(0xf7643174, 1, 0) = -1 ENOENT (No such file or directory)
                                14831 semget(0xf7643174, 1, 0) = -1 ENOENT (No such file or directory)
                                14831 semget(0xf7643174, 1, 0) = -1 ENOENT (No such file or directory)
                                14831 semget(0xf7643174, 1, 0) = -1 ENOENT (No such file or directory)
                                14831 semget(0xf7643174, 1, 0) = -1 ENOENT (No such file or directory)
                                14831 semget(0xf7643174, 1, 0) = -1 ENOENT (No such file or directory)
                                14831 semget(0xf7643174, 1, 0) = -1 ENOENT (No such file or directory)
                                14831 semget(0xf7643174, 1, 0) = -1 ENOENT (No such file or directory)
                                14831 semget(0xf7643174, 1, 0) = -1 ENOENT (No such file or directory)
                                14831 semget(0xf7643174, 1, 0) = -1 ENOENT (No such file or directory)
                                14831 open("/Oracle/DBlink_RPM/ODBC_Driver/odbc_cli/clidriver/msg/en_US.iso88591/db2sql.mo", O_RDONLY) = 4
                                14831 fstat(4, {st_mode=S_IFREG|0444, st_size=391570, ...}) = 0
                                14831 mmap(NULL, 393216, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f1b6f188000
                                14831 read(4, "\0\0", 2) = 2
                                14831 read(4, "\34\244\0\0", 4) = 4
                                14831 read(4, "\0\0\0\0\0\0\0\0T\0\0\0\1\0\0\0/\0\0\0T\0\0\0\2\0\0\0r\0\0\0"..., 391564) = 391564
                                14831 close(4) = 0
                                14831 semget(0xf7643174, 1, 0) = -1 ENOENT (No such file or directory)
                                14831 semget(0xf7643174, 1, 0) = -1 ENOENT (No such file or directory)
                                14831 semget(0xf7643174, 1, 0) = -1 ENOENT (No such file or directory)
                                14831 write(1, "[42601][unixODBC][IBM][CLI Drive"..., 197) = 197
                                14831 write(1, "\n", 1) = 1
                                14831 write(2, "[ISQL]ERROR: Could not SQLExecut"..., 34) = 34
                                14831 semget(0xf7643174, 1, 0) = -1 ENOENT (No such file or directory)
                                14831 semop(7569429, 0x7fff4955d9d0, 2) = 0
                                14831 semop(7569429, 0x7fff4955d9d0, 1) = 0
                                14831 write(1, "SQL> ", 5) = 5
                                14831 read(0, "sql-statement\n", 1024) = 14
                                14831 semget(0xf7643174, 1, 0) = -1 ENOENT (No such file or directory)
                                14831 semget(0xf7643174, 1, 0) = -1 ENOENT (No such file or directory)
                                14831 semop(7569429, 0x7fff4955da30, 2) = 0
                                14831 semop(7569429, 0x7fff4955da30, 1) = 0
                                14831 semget(0xf7643174, 1, 0) = -1 ENOENT (No such file or directory)
                                14831 semget(0xf7643174, 1, 0) = -1 ENOENT (No such file or directory)
                                14831 sendto(3, "\0N\320Q\0\1\0H \r\0D!\23NILGDB2 "..., 200, 0, NULL, 0) = 200
                                14831 recvfrom(3, "\0o\320C\0\1\0i$\10\0\230\377\377\37742601SQLNP012\0m\0\32"..., 131072, 0, NULL, NULL) = 289
                                14831 semget(0xf7643174, 1, 0) = -1 ENOENT (No such file or directory)
                                14831 semget(0xf7643174, 1, 0) = -1 ENOENT (No such file or directory)
                                14831 semget(0xf7643174, 1, 0) = -1 ENOENT (No such file or directory)
                                14831 semget(0xf7643174, 1, 0) = -1 ENOENT (No such file or directory)
                                14831 semget(0xf7643174, 1, 0) = -1 ENOENT (No such file or directory)
                                14831 semget(0xf7643174, 1, 0) = -1 ENOENT (No such file or directory)
                                14831 semget(0xf7643174, 1, 0) = -1 ENOENT (No such file or directory)
                                14831 semget(0xf7643174, 1, 0) = -1 ENOENT (No such file or directory)
                                14831 semget(0xf7643174, 1, 0) = -1 ENOENT (No such file or directory)
                                14831 semget(0xf7643174, 1, 0) = -1 ENOENT (No such file or directory)
                                14831 semget(0xf7643174, 1, 0) = -1 ENOENT (No such file or directory)
                                14831 semget(0xf7643174, 1, 0) = -1 ENOENT (No such file or directory)
                                14831 semget(0xf7643174, 1, 0) = -1 ENOENT (No such file or directory)
                                14831 semget(0xf7643174, 1, 0) = -1 ENOENT (No such file or directory)
                                14831 semget(0xf7643174, 1, 0) = -1 ENOENT (No such file or directory)
                                14831 write(1, "[42601][unixODBC][IBM][CLI Drive"..., 171) = 171
                                14831 write(1, "\n", 1) = 1
                                14831 write(2, "[ISQL]ERROR: Could not SQLExecut"..., 34) = 34
                                14831 semget(0xf7643174, 1, 0) = -1 ENOENT (No such file or directory)
                                14831 semop(7569429, 0x7fff4955d9d0, 2) = 0
                                14831 semop(7569429, 0x7fff4955d9d0, 1) = 0
                                14831 write(1, "SQL> ", 5) = 5
                                14831 read(0, "quit\n", 1024) = 5
                                14831 semget(0xf7643174, 1, 0) = -1 ENOENT (No such file or directory)
                                14831 sendto(3, "\0\n\320A\0\1\0\4 \17\0\n\320\5\0\2\0\4\300\4", 20, 0, NULL, 0) = 20
                                14831 recvfrom(3, "\0+\320R\0\1\0%\"\f\0\6\21I\0\4\0\5!\25\2\0\26!\20NILGDB2"..., 131072, 0, NULL, NULL) = 54
                                14831 recvfrom(3, "", 131072, 0, NULL, NULL) = 0
                                14831 close(3) = 0
                                14831 semget(0xf7643174, 1, 0) = -1 ENOENT (No such file or directory)
                                14831 semget(0xf7643174, 1, 0) = -1 ENOENT (No such file or directory)
                                14831 semget(0xf7643174, 1, 0) = -1 ENOENT (No such file or directory)
                                14831 semget(0xf7643174, 1, 0) = -1 ENOENT (No such file or directory)
                                14831 semop(7569429, 0x7fff4955db10, 2) = 0
                                14831 semop(7569429, 0x7fff4955db10, 1) = 0
                                14831 shmdt(0x7f1b755eb000) = 0
                                14831 munmap(0x7f1b6f526000, 1301960) = 0
                                14831 munmap(0x7f1b6f2aa000, 2604024) = 0
                                14831 munmap(0x7f1b6f664000, 1301992) = 0
                                14831 munmap(0x7f1b6f1ea000, 262144) = 0
                                14831 munmap(0x7f1b6f22a000, 262144) = 0
                                14831 munmap(0x7f1b6f26a000, 262144) = 0
                                14831 munmap(0x7f1b6f902000, 262144) = 0
                                14831 munmap(0x7f1b6f942000, 262144) = 0
                                14831 munmap(0x7f1b6f982000, 262144) = 0
                                14831 munmap(0x7f1b755c4000, 131072) = 0
                                14831 exit_group(0) = ?


                                Regards
                                Dharma
                                • 28. Re: Create DB-Link for Oracle Database 11g to IBM DB2
                                  Kgronau-Oracle
                                  show table is no DB2 command...
                                  Try selecting from your table or SYSIBM.SYSDUMMY1.

                                  Btw, you don't need to post a strace file when you're connected.
                                  • 29. Re: Create DB-Link for Oracle Database 11g to IBM DB2
                                    Dharma_
                                    Hai klaus,

                                    I connected to sqlplus,I query db2 table using dblink,but its shows TNS-12537 error through.Please see my configuration is correct or not.

                                    [oradev@testebs bin]$ sqlplus apps/apps

                                    SQL*Plus: Release 11.1.0.7.0 - Production on Sat Aug 4 15:59:14 2012

                                    Copyright (c) 1982, 2008, Oracle. All rights reserved.


                                    Connected to:
                                    Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
                                    With the Partitioning, OLAP, Data Mining and Real Application Testing options

                                    SQL> select *from billsc@ORACLE_DB2;
                                    select *from billsc@ORACLE_DB2
                                    *
                                    ERROR at line 1:
                                    ORA-28545: error diagnosed by Net8 when connecting to an agent
                                    Unable to retrieve text of NETWORK/NCR message 65535
                                    ORA-02063: preceding 2 lines from ORACLE_DB2



                                    ****Lisener.ora****

                                    SID_LIST_DEV =
                                    (SID_LIST =
                                    (SID_DESC =
                                    (ORACLE_HOME= /VIS/DEV/db/tech_st/11.1.0)
                                    (SID_NAME = DEV)
                                    )
                                    (SID_DESC=
                                    (SID_NAME = NILGDB2)
                                    (ORACLE_HOME= /VIS/DEV/db/tech_st/11.1.0/)
                                    (PROGRAM = dg4odbc)
                                    (ENVS=LD_LIBRARY_PATH = /home/oradev/usr/local/lib:/VIS/DEV/db/tech_st/11.1.0/lib)
                                    )
                                    )

                                    ***tnsnames.ora***

                                    NILGDB2=
                                    (DESCRIPTION =
                                    (ADDRESS=(PROTOCOL=TCP)(HOST=192.168.2.245)(port=50000))
                                    (CONNECT_DATA =
                                    (SID = NILGDB2)
                                    )
                                    (HS=OK)
                                    )

                                    I restarted lisener,it have no issue,but i tested tnsping NILGDB2,It through below error,

                                    [oradev@testebs DEV_testebs]$ tnsping NILGDB2

                                    TNS Ping Utility for Linux: Version 11.1.0.7.0 - Production on 04-AUG-2012 16:57:08

                                    Copyright (c) 1997, 2008, Oracle. All rights reserved.

                                    Used parameter files:
                                    /VIS/DEV/db/tech_st/11.1.0/network/admin/DEV_testebs/sqlnet_ifile.ora


                                    Used TNSNAMES adapter to resolve the alias
                                    Attempting to contact (DESCRIPTION = (ADDRESS=(PROTOCOL=TCP)(HOST=192.168.2.245)(port=50000)) (CONNECT_DATA = (SID = NILGDB2)) (HS=OK))
                                    TNS-12537: TNS:connection closed


                                    Regards
                                    Dharma