Im connecting to a database on a remote machine. The node and catalog
command were successfully run. I can connect to the database from the
db2 command line.
db2 => connect to dkt_old user xxx using yyy
Database Connection Information
Database server = DB2/LINUX 7.1.0
SQL authorization ID = DOCKET
Local database alias = DKT_OLD
I can view and select tables from the remote db.
When I try to connect via DBI it fails
$dbh = DBI->connect("DBI:DB2:dkt_old", <username>, <password>,
{ PrintError => 0,
RaiseError => 1,
AutoCommit => 0 } )};
DBI connect('dkt_old','docket',...) failed: [IBM][CLI Driver] SQL1031N
The database directory cannot be found on the indicated file system.
SQLSTATE=58031
I would greatly appreciate any suggestions to the cause of this
problem.
thanks
Knut Stolze - 25 Nov 2005 18:53 GMT
> Im connecting to a database on a remote machine. The node and catalog
> command were successfully run. I can connect to the database from the
[quoted text clipped - 23 lines]
> I would greatly appreciate any suggestions to the cause of this
> problem.
This looks as if you did not start your application, which uses DBI, in a
properly configured and initialized environment.

Signature
Knut Stolze
DB2 Information Integration Development
IBM Germany
juliane26 - 01 Dec 2005 11:29 GMT
Check out the Perl DBI documentation for DB2: there is a description on
how to use perl.
http://publib.boulder.ibm.com/infocenter/db2help/topic/com.ibm.db2.udb.doc/ad/c0
006690.htm
http://www-306.ibm.com/software/data/db2/perl/