Baanboard.com

Go Back   Baanboard.com > Forum > Baan SIGs > Performance & Tuning

User login

Frontpage Sponsor

Main

Poll
For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
35%
Installation Wizard into new VRC
42%
Manual into existing VRC
3%
Manual into new VRC
19%
Total votes: 31

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 1st February 2002, 05:28
Stephen_Simpson Stephen_Simpson is offline
Newbie
 
Join Date: Jan 2002
Posts: 2
Stephen_Simpson is on a distinguished road
Performance management tools

Does anyone know of any user or performance management tools, to be able to see which user is running what session and how much of the system resources are being used.

It would be good if the tool could also keep a history of system useage statistics for comparison purposes.

Specifically, this is for a Unix/Informix environment.

I know there are tools such as licmon, onstat and other unix commands, but what our client would really like is something that combines all of these into an easy to use interface.

Regards,

Stephen Simpson
e-Enterprise Software
New Zealand
Reply With Quote
Sponsored Links
  #2  
Old 7th February 2002, 17:24
Frank Rogers Frank Rogers is offline
Senior Member
 
Join Date: Dec 2001
Location: Camberley Surrey
Posts: 196
Frank Rogers is on a distinguished road
Baan: 4c4 SP10 - DB: Informix 7.31 FC4 - OS: HP-UX 11
Stephen

We are operating under HPUX 11 and use HP Producct called Glance .within HP Openview . Not cheap but very helpful

Frank
__________________
Frank
Reply With Quote
  #3  
Old 8th February 2002, 04:31
Stephen_Simpson Stephen_Simpson is offline
Newbie
 
Join Date: Jan 2002
Posts: 2
Stephen_Simpson is on a distinguished road
I have seen Glance before and it is a good tool for viewing system resources at the operating system level.

The problem with it is that it does't show things like -

How many Baan users are on the system
Which sessions users are running
How much of the database resources a baan user is taking

You have to go though quite a few steps to find this sort of information out, using a command line interface.
Reply With Quote
  #4  
Old 8th February 2002, 08:18
norwim's Avatar
norwim norwim is offline
Guru
 
Join Date: Oct 2001
Location: Germany Moenchengladbach
Posts: 450
norwim is on a distinguished road
Baan: some - DB: more - OS: many
Hi Stephen,

just do some scripting, use bshcmd6.1 to get details about running sessions and time consumption within the bshells.
If the customer wants "graphical" output, use php and the intranet to display these gathered information and to communicate with the script.
For the parameters of bshcmd, just enter bshcmd6.1 -U.

Hth

Norbert
__________________
Have a nice day
Reply With Quote
  #5  
Old 25th March 2002, 15:24
shonorio's Avatar
shonorio shonorio is offline
Newbie
 
Join Date: Mar 2002
Location: Brazil
Posts: 2
shonorio is on a distinguished road
Baan: Baan IV - DB: SQL Server 7.0 - OS: Windows NT 4.0
Talking

Norbert,

Do you have any script to publish these session information that you can share with us ?

Regards,
__________________
Solli Moreira Honorio
shonorio@alpargatas.com.br
Sao Paulo - Brazil
Reply With Quote
  #6  
Old 25th March 2002, 17:54
toolswizard toolswizard is offline
Senior Member
 
Join Date: Aug 2001
Location: USA
Posts: 292
toolswizard is on a distinguished road
Baan: 4c4, 50b, 50c, ERP ln - DB: Informix, Oracle, Sql - OS: Unix, NT, AIX
Baan has several performace tools packaged with the software and are discribed in the Performance Guide.
Reply With Quote
  #7  
Old 25th March 2002, 18:06
Frank Rogers Frank Rogers is offline
Senior Member
 
Join Date: Dec 2001
Location: Camberley Surrey
Posts: 196
Frank Rogers is on a distinguished road
Baan: 4c4 SP10 - DB: Informix 7.31 FC4 - OS: HP-UX 11
Hi Toolswizard !

Could you educate us what the "performance guide" is and where we can access it ?


Frank
__________________
Frank
Reply With Quote
  #8  
Old 26th March 2002, 01:31
norwim's Avatar
norwim norwim is offline
Guru
 
Join Date: Oct 2001
Location: Germany Moenchengladbach
Posts: 450
norwim is on a distinguished road
Baan: some - DB: more - OS: many
Hi Shonorio,

as I am not at a baan box at the moment, I can only give you some clues from memory

ps -ef | grep bshell | grep -v grep
gives a list of PID's of the running bshells
Let's assume that the 5th column of the output is the PID
(I am not at all sure about this, just try and see which column it is)
so:
ps -ef | grep bshell | grep -v grep | awk '{print $5}' > pidlist
produces a neat file with bshell PID's, which can be processed
suchlike:

while read mypid
do
rm $BSE_TMP/$mypid.PID # you have to clean the old files
bshcmd6.1 -p -s -u1 -w1 $mypid > $mypid.log1
done < pidlist

if you run this script twice (after a minute or so) and produce .log2 files this time, you can evaluate these two logfiles, compare the ticks of the bshell-subprocesses with one another and you have a good clue, which bshell is how active.

I will start my vacation tommorow, but feel free to ask for more info.

good luck
__________________
Have a nice day
Reply With Quote
  #9  
Old 26th March 2002, 12:02
Markus Schmitz's Avatar
Markus Schmitz Markus Schmitz is offline
Guru
 
Join Date: Feb 2002
Location: Cyprus
Posts: 668
Markus Schmitz is on a distinguished road
Baan: Ivc4 - DB: Oracle8i/9i/10g - OS: HP-Ux11i
According to Marketing Statements of Baan a long time ago, Baan planned to introduce in Baan ERP an interface to the ARM (Application response Measurement) Interface of IBM and HP.

So, if you are using BaanERP glance should be able to show all the information you are looking for.

If you are using Baan4c4, you can still use glance quite nicely by defining application groups. Let's say a group for all bshells, then glance will display the numbers of running bshells and the total CPU consumption and so forth.

Regards

Markus
Reply With Quote
  #10  
Old 29th March 2002, 17:00
JamesV JamesV is offline
Senior Member
 
Join Date: Aug 2001
Location: Grand Rapids, MI, USA
Posts: 225
JamesV is on a distinguished road
Baan: Baan IV/5 - DB: Oracle 7/8/8i,Informix, SQL Server, UDB - OS: AIX, HP-UX, Tru64, Solaris, NT/2000
Tools...

First of all, Glance is a great tool and every HP-UX account should be using either glance (text version) or gpm (X windows) for the analysis of OS resources (CPU, memory, IO) in use.

Glance also runs on AIX and Solaris.

For Informix, there are no good tools to tie the UNIX process back to the session. You have to use the onstat -g ses options, etc. to get this information.

You can use the bshcmd for Baan processes. My company, Open Systems Technologies, also markets a new product called uGuage which can be used to run traces, check on licensing, see which sessions are running, etc. We have not tied this to the database back end processes.

I am currently working with another customer to build this three part integration into a system management framework. But, it is not ready yet.

BTW -- the ARM reporting in Baan 5, Glance, Measureware and PerfView is really slick and works great. Unfortunately, Baan has refused to put this in place for Baan IV.

-- Jim
__________________
Jim VanderMey
VP of Technical Operations
Open Systems Technologies
Grand Rapids, Michigan, USA
jvandermey@ostusa.com
Reply With Quote
  #11  
Old 1st April 2002, 17:38
toolswizard toolswizard is offline
Senior Member
 
Join Date: Aug 2001
Location: USA
Posts: 292
toolswizard is on a distinguished road
Baan: 4c4, 50b, 50c, ERP ln - DB: Informix, Oracle, Sql - OS: Unix, NT, AIX
Frank,

Sorry it took so long to reply. There are two such guides that I know about. One is the Rapiditas Performance Guide M2002A US for Baan IV. It is part of Knowledge Quest and might be obtainable from Baan Support. The other is M2017B US Application Performance Guide for Baan V and up. I believe that this was on one of the Baan V documentation CD's but I can not be sure. This guide is more pratical and easier to read. Both seem to be a up to date manual of SQL 6.0 Baan released when it introduced SQL into there product. It has a lot of good tips in it also.
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Issues with mimic of database auths. sessions BaanTech Tools Administration & Installation 3 6th February 2017 07:40
List of free and commercial Oracle security tools petefinnigan Operating Systems & Databases 0 26th March 2004 15:06
Performance degredation with Tools SP 11 & 12 chadwickh Tools Administration & Installation 2 15th May 2003 13:17
Project management tools Commandeur General Discussion & Chat 3 9th October 2001 13:59


All times are GMT +2. The time now is 16:49.


©2001-2017 - Baanboard.com - Baanforums.com