HP-UX 11.0 kernel Tunning parameters for Universe databse

[Jawed Akhtar]

Hi,
We are running universe database on HP-UX 11.0 64 bit OS N-Class server. The number of users are 160 on average and Memory is 4GB.
We face slow response complaina from users when running reports.
Could any one suggest the tuuned kernel parameter set for HP-UX kernel and relative parameteres setting in uvconfig file of universe.

dbc_max_pct 40
dbc_min_pct 5

Thanks in advance

[Steve Steel · Accepted solution]

Hi


Well covered here

http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=627418


Stevce Steel

[Jawed Akhtar]

Thanks Steve, And sorry for being late in assigning points.

[OldSchool]

Jawed,

We have the same type of set-up here, HP-UX 11.00 Universe Database,
Total Configured Memory: 2816 MB.
Kernel settings are:

dbc_max_pct=25
dbc_min_pct=5

The problem I see with the way the Universe database on our system was set up. The Database is on the same LVM (3 disks in the group) and tends slow down when a user runs a report or large query on the database.

Check your disk bottleneck when a user is running a query or report. What I tend to see here it has become a bottleneck issue, not a memory issue.

Tom

[Jawed Akhtar]

Thanks Tom
Our universe is install on local disk and application is installed on mirrored LV.
Yes the bottlenck is Hard disk during report generation.
But what about the other HP-UX kernel parameteres like Number of processes per user, open files, ninodes etc. I think they may require some explanation reagrding universe usage bcoz univers open number of files at a time.
What are your tunned parametres in uvconfig and what fron end application are u using with univers. We have around 400 users.

Regd
JAwed

[Mark Di Donato]

Jawed,

Couple of areas to check:

If you are using static hashed files then consider resizing. (At TCL use tools like FILE.STAT, and HASH.HELP and HASH.AID, to get info on your files.)

Also check the MFILES uniVerse tunable. There may be excessive file rotation occurring.

Your application may be opening many files. As a rule, I believe MFILES should be set to 8 less than maxfiles.

You need to determine the average amount of open files in a UV session, make a change to the tunable and then regen UniVerse. (If you have Glance installed, use the adviser)

Hope this helps.

Mark.