Can't connect to db

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Foowah Ip

    Can't connect to db

    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:
    [color=blue]
    >db2 => connect to archive
    >SQL1031N The database directory cannot be found on the indicated file[/color]
    system. SQLSTATE=58031[color=blue]
    >db2 => list database directory
    >SQL1031N The database directory cannot be found on the indicated file[/color]
    system. SQLSTATE=58031[color=blue]
    >
    >$ db2ilist
    >archive
    >$[/color]

    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

    #2
    Re: Can't connect to db

    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:
    [color=blue]
    > 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:
    >
    >[color=green]
    >>db2 => connect to archive
    >>SQL1031N The database directory cannot be found on the indicated file[/color]
    >
    > system. SQLSTATE=58031
    >[color=green]
    >>db2 => list database directory
    >>SQL1031N The database directory cannot be found on the indicated file[/color]
    >
    > system. SQLSTATE=58031
    >[color=green]
    >>$ db2ilist
    >>archive
    >>$[/color]
    >
    >
    > 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[/color]

    Comment

    Working...