Re: DBD::DB2: SQL1031N The database directory cannot be found onthe indicated file system.

Patrick Wever, XPOS Internet Solutions wrote:
> Hello,
> 
> I've managed to install a DB2 runtime client on Linux.
> Successfully installed DBD::DB2 (passed all tests after installing via
> CPAN.)
> Created a user db2inst1.
> Set the following env vars:
> 
> DB2INSTANCE=db2inst1
> SQLLIB=/home/db2inst1/sqllib
> DB2_PATH=/opt/IBM/db2/V9.5
> DB2_HOME=/home/db2inst1/sqllib
> 
> Try to connect to the database I get the following error:
> 
> SQL1031N  The database directory cannot be found on the indicated file 
> system. 
> SQLSTATE=58031
> 
> I get the same error in db2:
> db2 => LIST DATABASE DIRECTORY
> SQL1031N  The database directory cannot be found on the indicated file
> system.
> SQLSTATE=58031
> 
> What am I missing and/or doing wrong?

You need to either catalog the DB2 catabase (using the "db2 catalog 
tcpip node" and "db2 catalog database" commands), or connect to the 
database using a hostname and port as shown in the DBD::DB2 documentation.

• DBD::DB2: SQL1031N The database directory cannot be found on the indicated file system. by Patrick Wever, XPOS Internet Solutions
• Re: DBD::DB2: SQL1031N The database directory cannot be found onthe indicated file system. by Hildo Biersma