473,320 Members | 1,719 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

SQL1031N connecting to remote database

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

Nov 25 '05 #1
2 11627
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: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.


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
Nov 25 '05 #2
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/

Dec 1 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: toddles666 | last post by:
Hi- I'm having a rather strange problem attempting to create a database. We're attempting to move a database from attached SCSI storage to SAN storage, and when I attempt to create the database...
3
by: stabbert | last post by:
We are running DB2 UDB 8.1.6 in a partitioned environment where we have 8 physical nodes. We have a process that remotely connects to each individual node and loads some data. By setting the...
1
by: Jim Bayers | last post by:
Our network nazi doesn't want us running a webserver on the server that has a connection to the campus database so we created a remote object that runs as a windows service. The windows service...
5
by: bill | last post by:
I am having difficulties connecting to a remote Sql server database in VB.net. Lets say my remote server is found at 255.255.255.255 and its name is MyServer. The database is called MyDatabase....
5
by: lxw176 via DBMonster.com | last post by:
Hi, I'm working on DB2 UDB 8.1 for AIX 5.3. I tried to do either db2 drop database mydb or connect to mydb command after I restored mydb from an online backup image using redirected restore. I...
0
by: Suresh | last post by:
Hi Guys I have Db2 server installed on remote server. i am connecting to that remote server by using VPN. I want to connect that remote DB2 server instance using my local machine DB2...
10
by: mairhtin o'feannag | last post by:
Hello, I'm having problems connecting to my new v9 db box. The pertinent information is below: DB2_db2inst1 60000/tcp DB2_db2inst1_1 60001/tcp DB2_db2inst1_2 60002/tcp DB2_db2inst1_END...
2
by: samadams_2006 | last post by:
Hello, I have a problem that I'm hoping someone will be able to help me resolve. 1) I have a C# Web Site in which I connect to the database: "Install Microsoft SQL Server 2005 Express...
0
by: jeffhan | last post by:
i am using db2 client on an AIX machine to connect to the remote database, we use LDAP to store the node and database on client machine, when i run: db2 list database directory or db2 list...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.