Adding Datafile

[Former Member]

Hi

I am running on DB2/Linux(2.14.18)/ECC 5.0.

I would like to know as to how I can extend a datafile to a tablespace I have this question coz i am very new to DB2 (Never done it on this platform)

Please advise.

best reagrds

Ravi

[Former Member · Accepted solution]

Hi ravi,

<u><b>Adding a datafile using BRTOOLS</b></u>

1) <b>su – ora<sid></b>

2) start <b>brtools</b>

3) Select option <b>2 -- Space management</b>

4) Select option <b>1 -- Extend tablespace</b>

5) Select option <b>3 --Tablespace name (specify tablespace name)</b> and say continue(<b>c- cont</b>)

6) Select option <b>3 – New data file to be added</b> and return

7) Select option<b> 5 -- Size of the new file in MB</b> (specify the size of the file) and say continue

regards,

kanthi

[Former Member]

Hi,

you can add data file using transaction db02

space ---> double click on tablspace

--> select table space --> click on change button

-->click on containers tab -- give the path file data file ....

SAP recomended all the data files should havd same sige..

Regards

Ben