Too much swap occurs! 1

[Shuichi]

My Olap server running on AIX consumes up all phisical memory and causes too much swap sometimes.

The phisical memory is 4GB and the command vmstat shows 0 at free memory sometimes.
The system has 4 cpu and the command sar -P ALL indicates use of the only one cpu each time (I mean the others 0%).

Is this normal or are there any configuration needed?

Can anybody help me?

 

[Shuichi]

I mean DB2 OLAP server on AIX.

Sorry.

 

[issahar]

Hi, Shuichi !
I cannot exactly answer you question but I think next to help you:
Which storage type of cube are you using?
If HOLAP - this is the source of the problem.
Try to use MOLAP and your performance will be much more better. I did this in my databases and it began to work much more quicklier without stucking other programs...

My best regards, Issahar

 

[Shuichi]

Hi, Issahar!

Thank you for your reply. I really appreciate it

But unfortunately it is MOLAP that I use.
And the problem probably get caused when not createing a cube but getting data from it.

But anyway, I keep your reply in mind for later use.

Thank you so much

Best regards,
Shuichi

 

[issahar]

Hi Shuichi!
Try to play with Environment settings of your OLAP Server
(Right Click on you OLAP server name in OLAP console and select Properties, select Environment Tab)
There are different performance settings, that can be changed. I didn't touch as usual, but there is an explanation about this in my Olap book that it can help...
I hope, it will give you some direction...
My best regards, Issahar

 

[Shuichi]

Hi Issahar!

Thank you for your good advice
I appreciate it

After long consideration, I decided to upgrade the server from 1.1 to 7.1.

I don't know if this do good or not.
but I'll try.

Thank you so much anyway, Issahar

 

[Shuichi]

Hi Issahar!

I made it after upgarading it.

The performance's getting better.

My best regards,
Issahar.

 

[issahar]

Hi, Shuici!
What setting did you changed to make the performance better?
My best regards, Issahar

 

[Shuichi]

Hi Issahar!

The only thing I did was upgrade it from DB2 OLAP SERVER version 1.1 to 7.1 on AIX.
That's it.

I don't know exactly why it went well.
Perhaps the formar one had a few bugs.

Sorry for little info about this

My best regards,
Shuichi