Skip to Content
author's profile photo Former Member
0
Former Member

Trace files related to Database analyzer

Posted on Aug 14, 2009 at 04:48 AM 19 Views

Hi Experts,

We recieved a request to investigate why database analyzer was not running from 8th to 12 th August.

I couldnt find any log or trace related to database analyzer .

The info i could find was that LVC data base was restarted on 5th August

dbmcli on LP5>dban_state

OK

0,OK: everything works fine

0,/sapdb/programs_plsaplp500/bin/dbanalyzer -d LP5 -u , -state

MaxDB Database Analyzer, The Performance Analysis Tool, Version 7.6.05.12

Copyright 2000-2008 by SAP AG

Using log directory: /sapdb/data_plsaplp500/wrk/LP5/analyzer

INFO 20: Database Analyzer not active in directory "/sapdb/data_plsaplp500/wrk/LP5/analyzer".

Database = LP5

Node =

Rundirectory = /sapdb/data_plsaplp500/wrk/LP5

Configfile = /sapdb/programs_plsaplp500/env/dbanalyzer76.cfg

Protocoldirectory = /sapdb/data_plsaplp500/wrk/LP5/analyzer

Interval = 900

Reconnect = false

ProcessID = 5308432

SessionID = 157846709

Driver = MaxDB 7.6

Started = 2009-08-05 05:14:19

Stopped = 2009-08-08 18:24:24

So where to find log or trace files related to it so that i can get some credible info related to why it was stopped on 8th of August???

kindly help

Edited by: Ameya Joshi on Aug 14, 2009 6:54 AM

Edited by: Ameya Joshi on Aug 14, 2009 7:07 AM

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • author's profile photo Lars Breddemann
    Lars Breddemann
    Posted on Aug 14, 2009 at 08:02 AM
    0

    > We recieved a request to investigate why database analyzer was not running from 8th to 12 th August.

    >

    > I couldnt find any log or trace related to database analyzer .

    >

    > The info i could find was that LVC data base was restarted on 5th August

    > So where to find log or trace files related to it so that i can get some credible info related to why it was stopped on 8th of August???

    HI Ameya,

    the first place to look would be the DBM.PRT file (database manager protocol) and check for "DBAN_START" or "DBAN_STOP" commands during the timeframe you mentioned.

    Apart from that you can find the DBAnalyzer logfiles in the analyzer subfolder of the RUNDIRECTORY of the the MaxDB/liveCache-instance.

    The files you should check are DBAN.err and DBAN.prt (check the [documentation|http://maxdb.sap.com/doc/7_7/45/7936cc1f2f401ee10000000a1553f6/content.htm] as well!).

    best regards,

    Lars

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.