Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

BRSPACE create new tablespace for compressed table

Dear expert,

I'm plannng to create new tablespace  PSAPCOMP for compressed table by brspace.

the current total size of the tables that i want to compression is 1T.

Now i have  2 question about the brspace script

1.How big size should the PSAPCOMP be , let's say 500G?

2. i'm confused about the datafile_dir value i should put (please refer to the attachment for current datafile_dir design)

Could you help to correct/improve the scritpts as following?

scriptA : brspace -f tscreate -t PSAPCOMP -s 5120 -a yes -i 100 -m 15360 -f sapdata4 -l 2 --> assign to sapdata4

repeat scriptB for 20 times

scriptB : brspace -f tsextend -t PSAPCOMP -s 5120 -a yes -i 100 -m 15360 -f sapdata4 -l 2 -f1 4 -f2 4 -f3 4 -f4 4 -f5 4 --> extend 25G in one run

Qestion: is it OK to assign the PSAPCOMP only to "sapdata4"? or i should specify "-f sapdata1 sapdata2 sapdata3 sapdata4" so the table data can distribute among different sapdata_dir?


Thank you!


sapdata_dir.xml (55829 B)
Tags:
Former Member

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question