Can't connect to db

[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

[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