If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > ADD Storage

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 05-09-11, 07:42
ssatish.81 ssatish.81 is offline
Registered User
 
Join Date: Mar 2011
Posts: 41
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
Reply With Quote
  #2 (permalink)  
Old 05-09-11, 08:03
n_i n_i is offline
:-)
 
Join Date: Jun 2003
Location: Toronto, Canada
Posts: 4,449
Check directory permissions.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On