Skip to Content
0
Former Member
Feb 16, 2011 at 10:08 AM

Tablespace creation options

414 Views

Hi people,

I need to create a TS, for the EHP4 installation. In the log file explains which are the command for to do this.The command will be the first,not?

1. These are examples for brspace commands to extend/create the required

2. tablespaces. You can adapt them according to your own needs.

3. Add option '-c force' to call the commands in batch mode.

4. Change option '-autoextend' to 'yes' and set '-maxsize' and '-incrsize'

5. to create autoextensible segments.

brspace -function tscreate -tablespace PSAPSR3701X -owner SAPSR3 -data both -size 20000 -autoextend no

brspace -function tsextend -tablespace PSAPSR3701X -size 20000 -autoextend no

brspace -function tsextend -tablespace PSAPSR3701X -size 20000 -autoextend no

brspace -function tsextend -tablespace PSAPSR3701X -size 9869 -autoextend no

But I want to set the autoextend to yes, but I´m not sure what to put in the paremeters -maxsize and -incrsiz

More thanks.