Forums | Admin

Discussion Forums: help

Start New Thread Start New Thread
Message: 60775
BY: Alex Pitigoi (alexp)
DATE: 2008-09-25 13:02
SUBJECT: RE: Connection fails with no Error Msg

 

Steven,

The only time you may encounter a license related SQL8002N error code is while attempting to connect to DB2 on z/OS, and that is only signaling you are missing the DB2 Connect component that can in fact connect to such subsystems. Is that your use case? ... 'cause if it is, and you do have a valid DB2 Connect to use, you'd just need to install in on your client and copy the license file in $HOME/lib/db2_clidriver/license/

As for the Solaris/Sparc 64-bit Ruby builds, you are on a good path using 'gem install' options, but I would not recommend modifying make files manually _if_ you can avoid. We had to resort to that for Mac OS X at some point, but in general you might be able to "train" the mighty "automagic" with a few other install options and environment variables... or maybe not ;-) ... but it's worth trying!

First check for Ruby 64-bit runtime, otherwise you need to build it on your platform (ruby1.8-dev is required to build Ruby64 runtime, besides few other dependencies: readline, zlib, etc.):
$ export ARCHFLAGS="-arch sparc"
$ export CFLAGS=-m64
$ tar -xzvf ruby-1.8.6-p111.tar.gz
$ cd ruby-1.8.6-p111
$ ./configure --prefix=/Users/alexp/ruby64 --with-readline-dir=/usr/local
$ make clean
$ make
$ make install
$ export PATH=/Users/alexp/ruby64/bin:$PATH
$ ruby -v
$ which ruby

Note: one manual tweak used on Mac OS X was: modify config.status and add "-m64" to every instance of gcc or cc, but that may have been fixed since, and CFLAGS=-m64 might do a thorough job now.

Yes, I know, building Ruby 64 runtime can become a complicated matter if not already available, but it's required for a successful 64-bit driver build.

The when building the IBM_DB gem something similar to this worked on Mac OS X (with a few additional manual tweaks):
$ export LD_LIBRARY_PATH=/Users/alexp/clidriver/lib
$ ~/clidriver/bin/db2level
$ export IBM_DB_DIR=/Users/alexp/clidriver
$ export IBM_DB_LIB=/Users/alexp/clidriver/lib
$ export RUBYOPT=-rubygems
$ sudo bash -c "ARCHFLAGS='-arch sparc' gem install ibm_db"

I hope this sheds a little more light into how manual builds of Ruby 64-bit gems might work.

As always, please let us know about your progress.
Thanks,
Alex


Thread View

Thread Author Date
Connection fails with no Error MsgSteven Hansen2008-09-24 00:08
      RE: Connection fails with no Error MsgSteven Hansen2008-09-24 00:10
            RE: Connection fails with no Error MsgPraveen Devarao2008-09-24 12:02
                  RE: Connection fails with no Error MsgSteven Hansen2008-09-24 14:22
                        RE: Connection fails with no Error MsgSteven Hansen2008-09-24 14:37
                              RE: Connection fails with no Error MsgAlex Pitigoi2008-09-24 14:58
                              RE: Connection fails with no Error MsgPraveen Devarao2008-09-24 15:00
                                    RE: Connection fails with no Error MsgAlex Pitigoi2008-09-24 15:31
                                          RE: Connection fails with no Error MsgSteven Hansen2008-09-24 19:16
                                                RE: Connection fails with no Error MsgSteven Hansen2008-09-24 19:19
                                                RE: Connection fails with no Error MsgAlex Pitigoi2008-09-24 19:35
                                                      RE: Connection fails with no Error MsgSteven Hansen2008-09-24 19:52
                                                            RE: Connection fails with no Error MsgAlex Pitigoi2008-09-24 20:33
                                                                  RE: Connection fails with no Error MsgSteven Hansen2008-09-25 06:13
                                                                        RE: Connection fails with no Error MsgAlex Pitigoi2008-09-25 13:02
                                                                              RE: Connection fails with no Error MsgPraveen Devarao2008-09-25 17:03
                                                                                    RE: Connection fails with no Error MsgSteven Hansen2008-10-07 20:38
                                                                                          RE: Connection fails with no Error MsgPraveen Devarao2008-10-08 05:21

Post a followup to this message