APW values & data extent size

C

casorohi

Member
Hi guys guide me in following things
Environment info:
Red Hat Liunx-5 64bit with 16CPU & 48GB RAM
OE 102B02

1. At what size data extent should be fixed for best performance (5GB is ok) ?
2. While binary upload how many APW should I start (DB size -120 to 200 GB) ?
3. While binary upload shall I increase the below APW values ? any impact
APW buffers per scan: 1024 to 2048 or higher
APW writes per scan: 1024 to 2048 or higher
(The reason I am asking that after binary upload DB taking too long to shut down, the binary load started with –i and –r params)

Thanks in advance
 
There is no special size that matters. Years and years ago you might find certain sizes mattered based on the internals of the host filesystem. But that is not a concern on any modern filesystem.

You should start enough APWs to avoid flushing buffers. During normal operations 1 or 2 is generally sufficient. For a highly parallel binary load you might need 5 or 6.

Changing the pw* params doesn't usually improve anything. It is generally more effective to increase the bi cluster size and the number of bi buffers. Also, use -big row when you create the new db.
 
You must log in or register to reply here.
Back
Top