[Catalyst] DB2 Connection string problem
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.
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