[Catalyst] DB2 Connection string problem

[Cosimo Streppone]

On Tue, 27 Mar 2012 20:49:41 +0200, Gianni Ceccarelli  
<dakkar at thenautilus.net> wrote:

> On 2012-03-27 Kenneth S Mclane <ksmclane at us.ibm.com> wrote:
>> [IBM][CLI Driver] SQL1031N  The database directory cannot be found on
>> the indicated file system.  SQLSTATE=58031
>>
>> This is the result I get from that change.
>
> I can't really help you more than this, I was just reading the
> documentation… I've never worked with DB2, and those error messages
> (in perfect IBM style) are quite hard to understand.
>
> Hope someone else has some experience in DB2. Or you may try asking to
> some different crowds, though (no, I don't know where to find people
> that know DB2).

Let's see. Last time I managed to connect to DB2 from perl
was around 2002, with ancient versions of DBD::DB2... :)

IBM messages might be cryptic, but the guys are smart
enough to include error number and SQLSTATE, so you need
to look those up.

Try this:

https://encrypted.google.com/search?client=opera&rls=nb&q=%22%5BIBM%5D%5BCLI+Driver%5D+SQL1031N+The+database+directory+cannot+be+found+on+the+indicated+file+system.+SQLSTATE=58031%22&sourceid=opera&ie=utf-8&oe=utf-8&channel=suggest#client=opera&rls=nb&q=%22%5BIBM%5D%5BCLI+Driver%5D+SQL1031N+The+database+directory+cannot+be+found+on+the+indicated+file+system.+SQLSTATE%3D58031%22&sourceid=opera&ie=utf-8&oe=utf-8&channel=suggest&fp=1&bav=on.2,or.r_gc.r_pw.,cf.osb&cad=b

or search term:

"[IBM][CLI Driver] SQL1031N  The database directory cannot be
found on the indicated file system.  SQLSTATE=58031"

in your preferred search engine.

IBM documentation usually gives you a hint about any type of error.
AFAIK, most DB2 connectivity problems come from:

* misconfigured DB2 client (see web search above)
* DB2 database on the server host (mine was running on OS/400, YMMV)
   needs to be "exported" for clients to connect via TCP/IP directly.

(Oh, /me just realized now I'm writing to a IBM email address)

Sorry... you clearly know better than me ... :)

-- 
Cosimo