Expert analysis has no data after March 1

[former_member219198]

This question was originally submitted as message 282669, but I was asked to post it to this forum instead:

I need to do detailed CPU utilization analysis on the PKA liveCache,

but the daily data under Expert Analysis stops on March 1. I cannot do

a manual aggregation of the data because the Basis support pack level

on PKA isn't high enough, and it would take awhile to get a downtime in

order to do an upgrade.

I assume there's some batch job that generates this data, but after

looking at note 978027 and related notes, I still couldn't find what

that batch job would be. The

jobs /SAPAPO/OM_REORG_DAILY, /SAPAPO/OM_DELETE_OLD_SIMSESS,

and /SAPAPO/DELETE_LC_ANCHORS are all set up OK, according to

the /SAPAPO/OM13 checks. Could you please point me in the right

direction to find the batch job that needs to be checked?

PKA uses LC 7.4.3 Build 041, Basis 6.20 SP 39, and kernel 6.40, patch

level 175.

Thanks very much.

Gordon

[former_member251078 · Accepted solution]

Hi

One more thing,

If you started x_server not as user 'pkaadm', could you please stop it as 'root' once and start it as 'lc1adm' once afterwards ?

Also could you check DBAN.err file as well ? please input the output of this file as well.

Regards

Dileep

[former_member219198]

We weren't able to start the DB Analyzer by the suggested methods. We had to start it at the operating system level with this command:

nohup ./dbanalyzer -u superdba,admin -d PKL -t 60 &

LC10 still considers the status to be "unknown", but the DB Analyzer is running, which is what we wanted.

Thanks very much to all who contributed.

Gordon

[Melanie]

Hello Gordon,

if it is not possible to start dbanalyzer via transaction LC10 or with dbmcli command dban_start,

I suggest to open another message that SAP support can analyze this.

Best regards, Melanie

[former_member251078]

Hi Gordon,

Have you enabled database analyzer in LC10--> Integration --> Automatic Monitoring tab ?

You can also manually start the dbanalyzer by going to LC10--> LiveCache : Monitoring --> Database analyzer --> Bottlenecks --> Start Analysis.

Regards

Dileep

[former_member219198]

Markus,

This does refer to the DB Analyzer logs which you see under "Expert Analysis".

The Database Analyzer Status is X -- Status cannot be determined. When I click on "Determine Status", I get "Error determining status". I then ran dban_state from the dbmcli and got this:

dbmcli on bdhp4720 : PKL>dban_state

ERR

-24964,ERR_EXECUTE: error in program execution

32512,dbanalyzer -d PKL -u , -state

sh: dbanalyzer: not found.

I found the dbanalyzer binary under /sapdb/programs/bin, as it should. The ownership is different, pkladm:sapsys rather than sdb:sdba, but the permissions are read/execute at every level, so that shouldn't result in a "not found" error.

Not sure what I'm misssing here. I'm not so familiar with the 7.4.3 LC; my experience is on 7.6. Thanks very much.

Gordon

[markus_doehr2]

Are you running your SCM backend on the same machine using MaxDB?

I was under the impression that 7.4.3 is out of support already...

Markus

[markus_doehr2]

> I need to do detailed CPU utilization analysis on the PKA liveCache,

> but the daily data under Expert Analysis stops on March 1.

are you talking about the DBAnalyzer logs? Is the analyzer running (did it run after that date)?

Markus