Helo,
i'm an perl programmer working with dbi and try to get an connection to db2 db server. I don't know nothing about db2, i only try to get a connection to a db2 server via dbi drivers in perl.
My test environment looks like this:
- one machine: db2 v9 database on Windows 2003 Enterprise Server
- another machine: db2 runtime client v9.7
In my perl i already do some connections to oracle, mysql and sybase. All connections are working (after installing the client software and the appropriate drivers in perl).
But i don't know how to connect to the db2 database or how to check if the connection is available (over db2 tools). I know there is db2 command but i don't know the syntax to get a connection.
Perl delivers this error messsage:
Code:
DBI connect('customer','administrator',...) failed: [IBM][CLI Driver] SQL1031N The database directory cannot be found on the indicated file system. SQLSTATE=58031
Do i have to set environment variables? Maybe there is someone who can tell me a command and the syntax to try to connect with db2 tools.
Thanks in advance
André