SQL1031N connecting to remote database

[terryintransit]

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:D B2:dkt_old", <username>, <password>,
{ PrintError => 0,
RaiseError => 1,
AutoCommit => 0 } )};

DBI connect('dkt_ol d','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]

te************@ yahoo.com wrote:

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:D B2:dkt_old", <username>, <password>,
{ PrintError => 0,
RaiseError => 1,
AutoCommit => 0 } )};

DBI connect('dkt_ol d','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.

This looks as if you did not start your application, which uses DBI, in a
properly configured and initialized environment.

--
Knut Stolze
DB2 Information Integration Development
IBM Germany

[juliane26]

Check out the Perl DBI documentation for DB2: there is a description on
how to use perl.

http://publib.boulder.ibm.com/infoce...d/c0006690.htm
http://www-306.ibm.com/software/data/db2/perl/