Results 1 to 2 of 2

Thread: ADD Storage

  1. #1
    Join Date
    Mar 2011
    Posts
    41

    Unanswered: ADD Storage

    Hello Team,

    I have the below file system info .

    /dev/hd4 2097152 196640 91% 17657 25% /
    /dev/hd2 6291456 4003460 37% 48867 6% /usr
    /dev/hd9var 2097152 1762004 16% 8254 3% /var
    /dev/hd3 3145728 2919516 8% 2280 1% /tmp
    /dev/hd1 2097152 2096224 1% 56 1% /home
    /dev/hd11admin 262144 261760 1% 5 1% /admin
    /proc - - - - - /proc
    /dev/hd10opt 2097152 1849152 12% 8754 3% /opt
    /dev/livedump 262144 261776 1% 4 1% /var/adm/ras/livedump

    /dev/fslv07 10485760 9907392 6% 423 1% /db2/db2rep1
    /dev/fslv08 10485760 6566704 38% 1391 1% /db2rep1/IBM
    /dev/fslv09 78643200 78630864 1% 4 1% /db2/db2rep1/data1
    /dev/fslv10 78643200 78630864 1% 4 1% /db2/db2rep1/data2
    /dev/fslv11 20971520 20967992 1% 4 1% /db2/db2rep1/log
    /dev/fslv12 10485760 10483832 1% 4 1% /db2/db2rep1/log_Second
    /dev/fslv13 31457280 31452152 1% 4 1% /db2/db2rep1/log_Archive

    As shown above I would like to add the storage /db2/db2rep1/data1 and /db2/db2rep1/data2 and hence am executing the below command .


    db2 "alter database add storage on '/db2/db2rep1/data1'" '/db2/db2rep1/data2'"

    and getting the below error :

    $ db2 "alter database add storage on '/db2/db2rep1/data1', '/db2/db2rep1/data2'"
    DB21034E The command was processed as an SQL statement because it was not a
    valid Command Line Processor command. During SQL processing it returned:
    SQL1051N The path "/db2/db2rep1/data1" does not exist or is not valid.
    SQLSTATE=57019


    I googled alot couldn't able to find what am I missing .

    Please throw some light on the same .

    PS : This database is autostorage enabled .

    Regards
    Sam

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Check directory permissions.

Posting Permissions

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