db2relocatedb trouble

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Ilja Booij
    #1

    db2relocatedb trouble

    Hi all,

    I'm having trouble using the db2relocatedb command. I have to move a
    database which was created under the db2inst1 user home dir, to a
    separate partition. Following the instructions in the DB2 online
    manuals, I have come up with the following config file for
    db2relocatedb:

    DB_NAME=IPI
    DB_PATH=/db2home/db2inst1,/database
    INSTANCE=db2ins t1

    When I execute db2relocatedb I get the following message:
    [db2inst1@db2 db2inst1]$ db2relocatedb -f relocatedb.cfg
    DBT1006N The file/device
    "/database/db2inst1/NODE0000/sqldbdir/sqldbdir" could not be opened.

    Can anyone tell what I'm doing wrong here?

    BTW, I'm running DB2 UDB 8.1 on RedHat Linux 8.0

    Thanks,
    Ilja Booij
    --
    IC&S
    Stadhouderslaan 57
    3583 JD Utrecht
    Tags: None
    • Bill
      #2
      Re: db2relocatedb trouble

      The db2relocatedb command doesn't actually relocate any files or create any
      directories. You need to create the database path directories yourself and
      move the files over. Then run the db2relocatedb command to tell DB2 what
      you did. When you create the directories make sure they are owned by the
      instance user and the permissions match the old directory permissions.
      "Ilja Booij" <ilja@ilja-booijs-computer.local> wrote in message
      news:slrnc0kupm .cnv.ilja@ilja-booijs-computer.local. ..[color=blue]
      > Hi all,
      >
      > I'm having trouble using the db2relocatedb command. I have to move a
      > database which was created under the db2inst1 user home dir, to a
      > separate partition. Following the instructions in the DB2 online
      > manuals, I have come up with the following config file for
      > db2relocatedb:
      >
      > DB_NAME=IPI
      > DB_PATH=/db2home/db2inst1,/database
      > INSTANCE=db2ins t1
      >
      > When I execute db2relocatedb I get the following message:
      > [db2inst1@db2 db2inst1]$ db2relocatedb -f relocatedb.cfg
      > DBT1006N The file/device
      > "/database/db2inst1/NODE0000/sqldbdir/sqldbdir" could not be opened.
      >
      > Can anyone tell what I'm doing wrong here?
      >
      > BTW, I'm running DB2 UDB 8.1 on RedHat Linux 8.0
      >
      > Thanks,
      > Ilja Booij
      > --
      > IC&S
      > Stadhouderslaan 57
      > 3583 JD Utrecht[/color]


        Comment

        • Ilja Booij
          #3
          Re: db2relocatedb trouble

          Hi,
          (inline reply)
          In article <wM%Ob.10308$nt 2.9264@newssvr1 6.news.prodigy. com>, Bill wrote:[color=blue]
          > The db2relocatedb command doesn't actually relocate any files or create any
          > directories. You need to create the database path directories yourself and
          > move the files over. Then run the db2relocatedb command to tell DB2 what
          > you did. When you create the directories make sure they are owned by the
          > instance user and the permissions match the old directory permissions.[/color]

          I was under the impression that db2relocatedb would do this for me :)
          Your answer clears things up a lot, thanks!

          Ilja

            Comment

            Previous template Next
            Working...