How to increase the database size

[Former Member]

Hi All ,

Our Client is going to increase their customers from 3.5 million to 5 millions

(12 millions in future ) and there is no increase in the existing licenses..

At present we have very less space in Data base server. We are Going Live at the End of the Month.

How to increase the database size to meet the Client requirements.

we have to increase the No of Processerors etc...

Below are the details of Servers:

System Model: IBM,7040-681

Machine Serial Number: 830D5BF

Processor Type: PowerPC_POWER4

Number Of Processors: 2

Processor Clock Speed: 1904 MHz

CPU Type: 64-bit

Kernel Type: 64-bit

LPAR Info: 4 bgl-svr-biap

Memory Size: 4096 MB

Good Memory Size: 4096 MB

Note : Server is IBM P690.

1) System Lansdcape --> Two System Landsacpe ( Dev to Prod )

2) BW Version --> 3.5

3) SAP Basis --- > 6.4

4) No of Application servers currently having --> Only One Server

Can any body suggest me how to solve this.....

Thanks in Advance..

Kasi Chukka

[Former Member]

Hi Kasi,

Your question is not very clear, from the looks of it, the load on your client's system will be doubling soon.

You need to look at the system stats on how the system is handling the current load, use transactions ST06, ST04 and ST02 to check if the DB hit ratios are as expected, the cpu idle time, the busy periods. Identify if there is large amounts of paging on the server(candidate for increase in real memory).

On AIX level, you will need to look at CPU / Memory usage.

On SAP Application server, you need to look at SAP Buffers.

On Oracle end, look at SGA stats, if it need to increase, the data growth that is current and estimated growth (DB02).

You will not get an exact answer to it, you will need to analyze the existing load and then estimate (guess). The hardware upgrade will also depend on what the client is willing to spend, its always a good practise to add 20% to what you have estimated as these figures are never accurate.

All the best.

Cheers,

Nisch

[Former Member]

hi

DB size means physical files data files where data resides.

Increase all file sizes with file system but not now increase it depends on requirement.

For tht you can use any DB admin Tools like BR tools or OEM.

Vinod

[Former Member]

You can increase the DB size by adding more disk space to your file system.Depending on the growth of the DB size its for you to decide how much you need to increase the size.This could have cost impact also associated with it.

With Regards,

Junaid

[Former Member]

Hi,

u didnt specified the Database..considering ur using Oracle..Attach one more Harddisk and extend the tablespace by adding new datafiles in newer hardisk..Use Brtools or sapdba..

Regards

Umesh K