Hi,
Now it worked !
Thank you !
The results:
* I Runtime version: X32/LINUX 7.4.3 Build 032-121-068-842
CON: 1
VAL: 1
* I Instance is up since 2006-03-01 18:43:56
CON: 1
VAL: 1
* I Configuration: number of CPUs (MAXCPU): 1, max user tasks: 150
CON: 1
VAL: 1
* I Number of data volumes: 1
CON: 1
VAL: 1
* I SQL commands executed: 32529391
CON: SQL_Cmds > 0
VAL: 32529391 > 0
* W3 Lock list escalations: 72
CON: LocklEscalations > 0
VAL: 72 > 0
So I changed MAXLOCKS to 9000 (it was 6920).
Lets see what happens...
Thank you very much,
2006/4/10, Becker, Holger <[EMAIL PROTECTED]>:
>
> Hi,
>
> looks like you missed to update the system tables after last software
> upgrade.
> Please try dbmcli -d ... -u ... load_systab and start the dbanalyzer
> again.
>
> Kind regards
> Holger
>
> > -----Original Message-----
> > From: Daniel Castro [mailto:[EMAIL PROTECTED]
> > Sent: Montag, 10. April 2006 15:25
> > To: [email protected]
> > Subject: [LIKELY JUNK]Re: Performance Problems
> >
> > I am trying to use the analyser, because I dont know which
> > query is slow...
> > It is a ERP system which I dont have the code...
> >
> > I get this message:
> >
> > SAP DB Database Analyzer, The Performance Analysis Tool, Version 7.4.3
> > Copyright (c) 1998-2002 by SAP AG
> >
> > Used protocol directory: /dados/HE/analyzer
> > Used configuration file: /opt/sapdb/indep_prog/env/dbanalyzer74.cfg
> >
> > ERROR 5: Cannot execute SQL statement.
> > [SAP AG][LIBSQLOD SO][SAP DB] Base table or view not
> > found;-4004 POS(937)
> > Unknown table name:RUNNING_PARSEIDS
> > CREATE OR REPLACE VIEW SYSMON_TASK_DETAIL_USER_AR AS SELECT
> > DBPID DBPID,
> > APPL_PROCESS APPL_PID,
> > STATEDESC STATEDESC,
> > DISPATCHCNT DISPATCHCNT,
> > REGIONACCESSCNT REGIONACCESSCNT,
> > COMMANDCNT COMMCNT,
> > TOTCMDEXECUTETIME TOTCMDEXECUTETIME,
> > VSUSPENDCNT VSUSPENDCNT,
> > VSUSPENDTOTABSTIME VSUSPENDABSTIME,
> > VWAITCNT VWAITCNT,
> > VWAITTOTABSTIME VWAITABSTIME, SIOWRITECNT +
> > DIOWRITECNT WRITECNT, SIOREADCNT +
> > DIOREADCNT READCNT, SIOREADTOTABSTIME
> > SIOREADTOTABSTIME, DIOREADTOTABSTIME
> > DIOREADTOTABSTIME,
> > PARSEID PARSEID FROM
> > SYSMON_TASK_DETAIL,RUNNING_PARSEIDS WHERE
> > TASKNAME =
> > 'User' AND NOT STATEDESC LIKE 'Connect wait' AND APPL_PROCESS > 0 AND
> > TASKID(+) = DBPID INTERNAL
> >
> > Can you help me?
> >
> > Best regards,
> >
> > 2006/4/7, Martin Cordova <[EMAIL PROTECTED]>:
> >
> > > A quick one:
> > >
> > > From SQLStudio, run the command "explain YourQueryHere..."
> > >
> > > That will tell you if there are tablescans, which are first
> > candidates
> > > for performance problems, armed with that information you can create
> > > indexes to solve the problem.
> > >
> > > When things get more dificult to diagnose, turn on the
> > analyzer for a
> > > while, it will print some warnings that will guide you to potential
> > > causes for performance problems.
> > >
> > > Hope it helps.
> > >
> > > Regards,
> > > Martin Cordova
> > > --
> > > Dinamica - RADical J2EE framework
> > > open source, easy and powerful
> > > http://www.martincordova.com
> > >
> > >
> > >
> > > On 4/7/06, Daniel Castro < [EMAIL PROTECTED]> wrote:
> > > > Hi,
> > > >
> > > > I am newbie in SAPDB issues.
> > > > I would like to know which steps do I have to take to
> > identify sapdb
> > > > performance problems.
> > > > I am having a serious performance problem and even though
> > I executed
> > > > "sql_updatestat * ESTIMATE SAMPLE 100 PERCENT"
> > > > the problem is not solved.
> > > >
> > > > Thank you very much.
> > > >
> > > > --
> > > > Daniel Castro
> > > > Website: http://danielti.no-ip.info:2139
> > > > MSN: [EMAIL PROTECTED]
> > > > Skype: danielti2005
> > > > ICQ : 316727989
> > > > Jabber: danielti
> > > > Linux User: 387864
> > > > AOL User: Danielti2005
> > > > Sola Scriptura, Sola Gratia, Sola Fide, Solus Christus,
> > Soli Deo Gloria
> > > >
> > > >
> > >
> >
> >
> >
> > --
> >
> > Daniel Castro
> > Website: http://danielti.no-ip.info:2139
> > MSN: [EMAIL PROTECTED]
> > Skype: danielti2005
> > ICQ : 316727989
> > Jabber: danielti
> > Linux User: 387864
> > AOL User: Danielti2005
> > Sola Scriptura, Sola Gratia, Sola Fide, Solus Christus, Soli
> > Deo Gloria
> >
> >
> > --
> > Daniel Castro
> > Website: http://danielti.no-ip.info:2139
> > MSN: [EMAIL PROTECTED]
> > Skype: danielti2005
> > ICQ : 316727989
> > Jabber: danielti
> > Linux User: 387864
> > AOL User: Danielti2005
> > Sola Scriptura, Sola Gratia, Sola Fide, Solus Christus, Soli
> > Deo Gloria
> >
>
--
Daniel Castro
Website: http://danielti.no-ip.info:2139
MSN: [EMAIL PROTECTED]
Skype: danielti2005
ICQ : 316727989
Jabber: danielti
Linux User: 387864
AOL User: Danielti2005
Sola Scriptura, Sola Gratia, Sola Fide, Solus Christus, Soli Deo Gloria
