verify /brconnect job fails in livecache

[Former Member]

Hi all,

Iam newbie into MaxDB database.

We have problem with the verify and brconnect job in livecache. Both this jobs are is fired from external UC4 tool.

The SAP system is version SCM 5.0 and runs on Solaris 5.9 box with livecache version:

KERNEL 7.6.00 BUILD 029-123-130-265

The job log UC4 shows following log for verify job:

-

---

dbmcli -d LCG -n mchp75sa -uUTL -tpi G27 -tpp no_longer_used -tpc LCA db_execute check data

Error! Connection failed to node mchp75sa for database LCG:

tp error: connect failed

-

---

and the job log for brconnect displays below log:

-

---

setenv SQLOPT "-d LCG -u SAPLCG,owanta4s"

xpu -u -s -e 20000 1

Can't exec program </sapdb/LCG/db/pgm/pu> : No such file or directory

-

---

I have checked in OS level but Iam unable to find the "pu" file which the brconnect job is refering to.

Iam really not aware about technical usage of this file in livecache environment .

I have checked in LC10 and its displays livecache operational state running status.

Also I checked in other SAP system ( SCM 4.1) which has livecache version

KERNEL 7.5.0 BUILD 035-123-123-944

I can see the pu file in the same path.

Does any MaxDB expert has any ideas ?

Awaiting for response.

Thanks !

Kind Regards

Neenad

[former_member229109 · Accepted solution]

Hello Neenad,

-> How did you schedule the job?

Please let me know the output of the following commands::

dbmcli -d LCG -n mchp75sa -u control,<pwd> db_state

dbmcli -n mchp75sa db_enum

Do you have the liveCache instance LCG installed on mchp75sa server?

Did you create the SAP OSS message on this issue?

Please review the SAP note::

521870 Database structure check (Verify/Check Data) of a liveCache

-> For the UPDATE Statistics you was using the old SAP note 389770.

Please see answer on 35. question in the SAP note 940420.

You should no longer use xpu outside of the DB13c in the new MaxDB versions 7.5 and 7.6 and following.

Please review the SAP notes::

990602 FAQ: CCMS for MaxDB/SAP liveCache technology

1001874 Incorrect status/name for database structure checks

Thank you and best regards, Natalia Khlopina