[Catalyst] DB2 Connection string problem

Cosimo Streppone cosimo at streppone.it
Tue Mar 27 19:17:50 GMT 2012

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:


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 ... :)


More information about the Catalyst mailing list