How do I add an 8K tablespace to an existing database instance? 2

[SantaMufasa]

Our application software expects an 8K tablespace named "USERSPACE8K1". There are currently no 8K tablespaces in the target db instance.

Can someone please post the syntax to create such a tablespace?

Thanks,

Mufasa
(aka Dave of Sandy, Utah, USA)
[

http://www.dasages.com:

Providing low-cost remote Database Admin services]
Click here to join Utah Oracle Users Group on Tek-Tips if you use Oracle in Utah USA.

 

[notadba]

Hi Santamufasa,

Not sure which version of DB2 you are on, but hopefully this link will be of use:

http://publib.boulder.ibm.com/infoc...topic=/com.ibm.db2.udb.doc/admin/r0000929.htm

Good luck.

 

[Truusvlugindewind]

Do not forget to define a 8K bufferpool first and use that for your new tablespace.

 

[SantaMufasa]

Thanks to both of you for pointing me in absolutely the correct direction. Have a couple of Purple Stars.

Mufasa
(aka Dave of Sandy, Utah, USA)
[

http://www.dasages.com:

Providing low-cost remote Database Admin services]
Click here to join Utah Oracle Users Group on Tek-Tips if you use Oracle in Utah USA.