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 > pureScale (v9.8) InfoCenter

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 05-28-10, 16:43
db2girl db2girl is offline
∞∞∞∞∞∞
 
Join Date: Aug 2008
Location: Toronto, Canada
Posts: 1,816
pureScale (v9.8) InfoCenter

Reply With Quote
  #2 (permalink)  
Old 06-02-10, 11:39
MarkhamDBA MarkhamDBA is offline
Registered User
 
Join Date: Dec 2008
Location: Toronto, Canada
Posts: 381
for 9.8 all tablespaces should be converted to automatic storage. Traditionally we are still using SMS tablespaces (did not change since I think v6 or v7). I wonder how many db2 shops are using AS.
__________________
DB2 v9.5 ESE on AIX v6.1/ v9./10 on z/OS
Reply With Quote
  #3 (permalink)  
Old 06-02-10, 14:24
db2girl db2girl is offline
∞∞∞∞∞∞
 
Join Date: Aug 2008
Location: Toronto, Canada
Posts: 1,816
Quote:
Originally Posted by MarkhamDBA View Post
for 9.8 all tablespaces should be converted to automatic storage.
I didn't know pureScale required all tablespaces to use automatic storage
Reply With Quote
  #4 (permalink)  
Old 06-02-10, 14:58
MarkhamDBA MarkhamDBA is offline
Registered User
 
Join Date: Dec 2008
Location: Toronto, Canada
Posts: 381
the bad news is that AS tablespaces can not be created in database with no AS. But the good news is that in 9.8
"If the database is not enabled for automatic storage, use the ALTER DATABASE command with the ADD STORAGE ON
storage-path option to enable it for automatic storage "
(which was not possible in 9.5)
__________________
DB2 v9.5 ESE on AIX v6.1/ v9./10 on z/OS
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