Need to add datafiles

[Former Member]

Hi Experts,

Please let me know how can i add the data files using brtools

Please note the db02 datafiles current sizes

Table Space Size (kb) Free size Used (%) Tab/ind Extents AutoExt (kb) Used (%) Status Backup

PSAPSR3 40.960.000 832.512 97 155.893 194.35 204.800.000 20 ONLINE NOT ACTIVE

PSAPSR3700 65.024.000 386.752 99 908 10.971 163.840.000 39 ONLINE NOT ACTIVE

PSAPSR3USR 20.48 18.304 10 33 33 10.240.000 0 ONLINE NOT ACTIVE

PSAPTEMP 2.048.000 2.048.000 0 0 0 10.240.000 0 ONLINE NOT ACTIVE

PSAPUNDO 8.949.760 8.475.456 5 17 292 10.240.000 5 ONLINE NOT ACTIVE

SYSAUX 266.24 22.464 91 949 1.888 10.240.000 2 ONLINE NOT ACTIVE

SYSTEM 839.68 2.112 99 1.204 2.739 10.240.000 8 ONLINE NOT ACTIVE

Total 118.108.160 11.785.600 90 159.004 210.273

Regards,

Reddy V

[andreas_herzog]

all your current tablespaces are set to extend automatically (autoextend on and the maximum size is given, for example: PSAPSR3 is 40.960.000 bytes big but can grow till 204.800.000 bytes - if sufficient disk space is provided)....

so, why is the need to add datafiles?

GreetZ, AH

[Former Member]

Hi Andreas,

Thank you for your valuable information

Please let me know how can we know that the table spaces are reached max.size

in DB02. In db02 table PSAPSR3 it is showing two used percentages i.e 99% and 20% which one i have to consider and how can i found the growth of the table space.

Regards,

Reddy V

[andreas_herzog]

by the time posting your tablespace PSAPSR3 has allocated 40 gb of which 99% are filled ...but: as all data files of that tablespace have the autoextend option activated the tablespace will grow until 200 gb are reached - if sufficient hard disk space is available, meaning at least 200 gb (if not the tablespace cannot grow!) - 40 gb / 200 gb is 20%...

when the autoextend option is active one has to monitor the disk space rather than the filling grade of the tablespace...

GreetZ, AH

[Former Member]

Hi Andreas,

Thank You for your detailed information.

As per your information i have checked all the table space sizes and all are having enough space.

But i have observed that in db02 under tables and indexes option it is showing that 3 indexes are missing in database

Tables Indexes

Total number 70.933 86.319

Total size/kb 32.346.368 40.426.560

More than 1 extent 2.799 3.313

Missing in database 0 3

Missing in R/3 DDIC 0 0

Space-critical objects 0 0

The indexes are

/BIC/FZCF_FLWN-010

/BIC/FZCF_FLWN-020

/BIC/FZCF_FLWN-040

Please let me know you suggestion/solution on the same

Regards,

Prakash V

[markus_doehr2]

Please read

http://help.sap.com/saphelp_nwpi71/helpdata/en/47/13f0462c1721bfe10000000a114a6b/content.htm

Markus