onperf

[aaronkeith]

hi guys! i would like to ask for your expertise. i am trying to use the onperf command of informix but i always get "can't open display". How am i going to set the DISPLAY variable and what path do i need to add to my profile? Also, is there a way i can monitor the performance of my database for a specific time frame. Example I want to get the database's performance every 10 minutes for 24 hours? Is there a tool that i need to load or just the onperf command? by the way i am using AIX 4.3.3 and IDS 9.3

Please help me on this. I would really appreciate your reply. thank in advance

aaronkeith

 

[bgfarmer]

Well, with onperf you can try to set your DISPLAY like
DISPLAY=%ip:0.0%
export DISPLAY

You will need an x-windows type enviroment. Telnet will not work. Are you doing this from system console or desktop?

Your question on monitoring performance every 10 minutes is rather vague. What exactly are you wanting to monitor? Explain performance as to what you are looking for. You can always set up scripts that call onstat commands and run them through cron. It all depends on what you are looking for.

regards

 

[aaronkeith]

hi bgfarmer! thank you for your reply. I tried using it and i got the following error:

Xlib: connection to IP_address is refused by server
Xlib: client is not authorized to connect or server
error "can't open display"

what do i need to set? with regards to the performance monitoring, i just what to get the utilization of the database for 24 hours. the time interval to get the snapshot would be every 10 minutes. I am doing that in AIX to monitor the usage of memory, disk, etc. Is there a tool i can use in informix?

thanks again for the help!

 

[vpshriyan]

Hi,

Informix provides following utilites for monitoring performance:

1. onstat - provides a window into the shared memory structures that Informix stores and uses as SMI tables; which basically stores all the user activities that are carried out during the engine up duration.
2. onperf - a grahical view of the Online engine activities.
3. oncheck - is a check and repair utility for the database tables, indices, extents etc.

You may run onperf tool either on the computer where the database server is running or on a remote computer or terminal that has been configured to communicate with your database server instance. However, the computer that is running the onperf tool must support the X terminal or the Motif window manager (mwm).

Set the DISPLAY environment variable as follows:
DISPLAY=wheretodisplay:0.0

In above command, wheretodisplay is the name of the computer or X terminal where the onperf display window should appear.

Following is are valid Bourne shell environment setting:
export DISPLAY=:0.0
export DISPLAY=127.0.0.1:0.0

Regards,
Shriyan

 

[aaronkeith]

thank you so much for all the help! i was able to use onperf now...

thanks vpshriyan and bgfarmer! till next time

But i still need to figure out what is the best monitoring tool that i can use...