On Tue, 27 Mar 2012 20:49:41 +0200, Gianni Ceccarelli <[email protected]> wrote:

On 2012-03-27 Kenneth S Mclane <[email protected]> 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

_______________________________________________
List: [email protected]
Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst
Searchable archive: http://www.mail-archive.com/[email protected]/
Dev site: http://dev.catalyst.perl.org/

Reply via email to