Can't connect to db - DB2 Database

Foowah Ip

Hi all,

Could you help on this? We are trying to install DB2 on a Solaris
box, to be used for IBM Content Manager OnDemand, when we try to
connect to the database, we got:

db2 => connect to archive
SQL1031N The database directory cannot be found on the indicated file system. SQLSTATE=58031db2 => list database directory
SQL1031N The database directory cannot be found on the indicated file system. SQLSTATE=58031
$ db2ilist
archive
$

Do you know why this is happening?

The following were the steps that we did following the instruction:
- Installed DB2 7.2 and created the DB2 Instance for OnDemand during
the install, using id=archive, group=sysadm1, home
directory=/export/home/archive
- Applied DB2 fixpak
- Updated the instance archive using db2iupdt
- Added root user to group sysadm1
- Created links using db2ln

Thanks in advance.

Foo-Wah

Nov 12 '05 #1

Subscribe Reply

23497

Blair Adamache

Have a look at the catalog command to catalog the database and node on
the correct machine. From the DB2 command prompt you can type:

db2 ? catalog tcpip node
and
db2 ? catalog database

for the syntax for each command. You may have to use the uncatalog
commands first.

Foowah Ip wrote:

Hi all,

Could you help on this? We are trying to install DB2 on a Solaris
box, to be used for IBM Content Manager OnDemand, when we try to
connect to the database, we got:

db2 => connect to archive
SQL1031N The database directory cannot be found on the indicated file

system. SQLSTATE=58031
db2 => list database directory
SQL1031N The database directory cannot be found on the indicated file

system. SQLSTATE=58031
$ db2ilist
archive
$

Do you know why this is happening?

The following were the steps that we did following the instruction:
- Installed DB2 7.2 and created the DB2 Instance for OnDemand during
the install, using id=archive, group=sysadm1, home
directory=/export/home/archive
- Applied DB2 fixpak
- Updated the instance archive using db2iupdt
- Added root user to group sysadm1
- Created links using db2ln

Thanks in advance.

Foo-Wah

Nov 12 '05 #2

Similar topics

9012

Can't connect to remote host (10061)

by: Ryan Stewart | last post by:

I'm running MySQL server on a WinXP box at home. I have a cable modem/router. I've set up port forwarding on port 3306 to the machine running MySQL. I can connect locally just fine, but when I try to connect from a remote location using: mysql -h xxx.xxx.xxx.xxx -P 3306 -u root -p mysql I get: ERROR 2003: Can't connect to MySQL server on 'xxx.xxx.xxx.xxx' (10061) When I try:

MySQL Database

694

Can't hear vb6 winsock connect request in C# listener

by: Bill | last post by:

When vb6 Winsock.RemoteHost is set to "127.0.0.1", c# socket listener cannot hear connect request (my old vb6 winsock listener could hear it...). Why doesn't this work, and is there a work around I can make on the C# side to hear the connect request? -Bill (don't reply by e-mail, the address is a fake) ______________________________ Steps to reproduce: Start the C# Listener

.NET Framework

4610

Oracle Net VS DB2 Connect

by: Kona | last post by:

Hello, Is it right to tell that DB2 Connect has the same function that Oracle Net ? If I have an ODBC application is it also right to tell that I have 2 possibilities on my client workstation to acces a remote UDB database on a Sun machine : a) with a run-time client b) with DB2 Connect Personnal Edition Thank you

DB2 Database

7435

is it possible to connect to db2/390 without having db2 connect?

by: aka | last post by:

Hi I have a DB2 v8.1 on AIX and DB2 Connect EE on Solaris wich is connected to OS/390 DB2 subsystems via APPC / SNA. I have cataloged the DB2 Connect instance as tcpip node and then the Host DB cataloged on that node...this works from v7.2 Fixpack 11 clients and servers, but with v8.1 server I get SQL1334N. Does anyone has an idea? Thanks

DB2 Database

4546

by: Zorba.GR | last post by:

IBM DB2 Connect Enterprise Edition v8.2, other IBM DB2 (32 bit, 64 bit) (MULTiOS, Windows, Linux, Solaris), IBM iSoft Commerce Suite Server Enterprise v3.2.01, IBM Tivoli Storage Resource Manager Express Edition v1.3.2 Win, IBM Tivoli System Automation v1.2.0 Linux, IBM Tivoli Workload Scheduler Virtualized Data Centers v8.2 , other IBM Tivoli CDs, WEBSPHERE EVERYPLACE MOBILE PORTAL v5.0 - ALTIUM , other IBM WebSphere Business CDs...

DB2 Database

25270

Socket connect vs. bind? What is the difference

by: DaTurk | last post by:

I am makeing a Multicast server client setup and was wondering what the difference is between Socket.Connect, and Socket.Bind. It may be a stupid question, but I was just curious. Because I tried a test, and I can't bind two sockets to the same port/ip but I can connect with one socket, and bind with another to the same ip/port. Thanks

C# / C Sharp

2765

Can't connect to postgresql server

by: Clodoaldo Pinto | last post by:

Can't connect to postgresql server php error log message: PHP Warning: pg_connect() : Unable to connect to PostgreSQL server: could not connect to server: Permission denied\n\tIs the server running on host "127.0.0.1" and accepting\n\tTCP/IP connections on port 5432? php connection string:

PHP

7041

HELP! Why is SqlException being caught in this code if it can't connect to SQL Server?

by: Marcus | last post by:

I have a function that simply returns TRUE if it can connect to a particular Sql Server 2005 express, or FALSE if it cannot. I am getting some strange error codes returned when the computer that sql server resides on is not reachable. The error is different depending on the connection string that I use. If I use the following connection string: "server=192.1.1.1; Initial Catalog=master; uid=The_User; password=The_Password; Connect...

Visual Basic .NET

4530

ftp_nlist "425 Can't open data connectoin"

by: blackpuppy | last post by:

I am just beginner on PHP. I am reading "Spring Into PHP 5" but cannot make the ftp examples work. I am running PHP scripts on a Fedora Core 5 (VMWare virtual machine) on top of a Windows XP Professional. The PHP version is 5.1.4. The PHP script is shown below. #! /usr/bin/php <?php $ftp_server = "myftpserver";

PHP

3768

php script can't connect to local mysql, what the heck?

by: d3vkit | last post by:

Okay so I am at a loss here. I have a website that I've previously had no trouble connecting to the mysql DB on. I have an include to a connect file with the relevant connection info, and it was working fine until today. I am trying to implement some ajax with the javascript framework mootools (although I don't see how this is causing the problem it started happening right around this time sooo...) I am sending info from my login form to the...

MySQL Database

9548

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

9374

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

8244

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

6076

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

4607

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

4876

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

3315

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

2787

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

2215

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General