Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2002
    Location
    Hamilton
    Posts
    150

    Unanswered: moving local database directory

    AIX 5.3
    DB2 8.1 FP2

    We have noticed our /home filesystem on AIX filling up and it seems related to the fact that we have for some unknown reason found out that one of our larger database's has a local database directory like the below

    Database alias = AVC
    Database name = AVC
    Local database directory = /home/avcpb1
    Database release level = a.00
    Comment =
    Directory entry type = Indirect
    Catalog database partition number = 0


    What we would like the entry to be is the following:

    Database alias = AVC
    Database name = AVC
    Local database directory = /archive/prodb/DB2/avcpb1/avc
    Database release level = a.00
    Comment =
    Directory entry type = Indirect
    Catalog database partition number = 0


    Is there a way to do this without affecting any of the data in the database?

    thanks in advance

    Mark

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    ---
    "It does not work" is not a valid problem statement.

  3. #3
    Join Date
    Feb 2002
    Location
    Hamilton
    Posts
    150
    thanks for the info

    I tried it out in our development environment and had the below results

    $ more relocate
    DB_NAME=SALES_DB
    DB_PATH=/home/avcd1,/archive/devz/DB2/avcd1/sales_db
    INSTANCE=avcd1
    $ chmod 755 relocate
    $ db2relocatedb -f relocate
    DBT1007N An error occurred while attempting to perform operation "read" on file/device "/archive/devz/DB2/avcd1/sales_db/avcd1/NODE0000/sqldbdir/sqldbdir".

    $ ls -ltr /archive/devz/DB2/avcd1/sales_db/avcd1/NODE*
    total 8
    drwxrwsrwx 2 avcd1 avcd1 512 Sep 17 12:04 sqldbdir

    $ ls -ltr /archive/devz/DB2/avcd1/sales_db/avcd1/NODE*/*
    total 0
    -rwxrwxrwx 1 avcd1 avcd1 0 Sep 17 12:04 sqldbdir

    I opened up all permissions on the file in question and it still doesn't work, any suggestions?

    thanks in advance

    Mark

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •