Need to be monitor CPU , memory usage Standalone DB Servers Cluster

[Former Member]

Dear all,

We have PRODCI , PROD APP1 , PRODAPP2 and PRODDB in Cluster .

PRODDB is standalone Server Cluster.

I have checked ST06n and it shows Systems under SID PRODCIXI_IRP_01 , PROD APP1_SID_00 , PRODAPP2_SID_00 and PRODORADB_IRP_01

and i got CPU and Memory Usages for PRODCIXI_IRP_01 , PROD APP1_SID_00 , PRODAPP2_SID_00 but i cant get PRODORADB_IRP_01 , its show like

Info Operating system

Info Timestamp No data

I have checked OS07 SAPOSCOL Destination , I found the below information ,

PRDAPP1_IRP_00 Application server

PRDAPP2_IRP_00 Application server

PRDCIXI_IRP_01 Application server

SAPCCMSR.PRODORADB.99 RFC Destination for CCMS agent sapccmsr. X X

I have checked SAPCCMSR.PRODORADB.99, its not showing any Interval value.

CPU

Utilization user % 0 Count 0

system % 0 Load average 1 min 0.00

idle % 0 5 min 0.00

io wait % 0 15 min 0.00

System calls/s 0 Context switches/s 0

Interrupts/s 0

Memory

Physical mem avail Kb 0 Physical mem free Kb 0

Pages in/s 0 Kb paged in/s 0

Pages out/s 0 Kb paged out/s 0

Pool

Configured swap Kb 0 Maximum swap-space Kb 0

Free in swap-space Kb 0 Actual swap-space Kb 0

Disk with highest response time

Name Response time ms 0

Utilization 0 Queue 0

Avg wait time ms 0 Avg service time ms 0

Kb transfered/s 0 Operations/s 0

Kindly advise

Kindly advise how can

[sunny_pahuja2 · Accepted solution]

Hi,

Check whether saposcol is running on your DB server or not.

Thanks

Sunny

[Former Member · Accepted solution]

Dear

Let me know how can i check if SAPOSCOl is configured in PRODORADB .

Kindly suggets .

[Former Member · Accepted solution]

logon to PRODORADB server and if this is windows then under task manager check for saposcol process, for UNIX do ps -eaf | grep saposcol

to start saposcol follow http://help.sap.com/saphelp_nw70ehp1/helpdata/en/c4/3a6c19505211d189550000e829fbbd/frameset.htm

[Former Member · Accepted solution]

Dear ,

We are using AIX .

I havechecked PROD DB , pls check below

ROOT@PRODORADB:/#ps -eaf | grep saposcol

root 372904 573732 0 13:54:16 pts/0 0:00 grep saposcol

Kindly suggest .

[Former Member · Accepted solution]

your saposcol is not running.

please execute below command to start:

saposcol -l

[Former Member · Accepted solution]

dear ,

pls check below .

PRODORADB:irpadm 2> saposcol -l

-l

***********************************************************************

• This is Saposcol Version COLL 20.95 700 - AIX v11.15 5L-64 bit 080317

• Usage: saposcol -l: Start OS Collector

• saposcol -k: Stop OS Collector

• saposcol -d: OS Collector Dialog Mode

• saposcol -s: OS Collector Status

• The OS Collector (PID 417894) is already running .....

************************************************************************

PRODORADB:irpadm 3> saposcol -s

**************************************************************

Collector Versions :

running : COLL 20.95 700 - AIX v11.15 5L-64 bit 080317

dialog : COLL 20.95 700 - AIX v11.15 5L-64 bit 080317

Shared Memory : attached

Number of records : 17640

Active Flag : active (01)

Operating System : AIX PRODORADB 3 5 00018B6AD400

Collector PID : 417894 (00066066)

Collector : running

Start time coll. : Wed Oct 13 14:52:48 2010

Current Time : Wed Oct 13 14:53:19 2010

Last write access : Wed Oct 13 14:52:58 2010

Last Read Access : Thu Jan 1 05:30:00 1970

Collection Interval : 60 sec (next delay).

Collection Interval : 10 sec (last ).

Status : free

Collect Details : required

Refresh : required

Header Extention Structure

Number of x-header Records : 1

Number of Communication Records : 60

Number of free Com. Records : 60

Resulting offset to 1.data rec. : 61

Trace level : 2

Collector in IDLE - mode ? : YES

become idle after 300 sec without read access.

Length of Idle Interval : 60 sec

Length of norm.Interval : 10 sec

**************************************************************

PRODORADB:irpadm 4>

Kindly suggest

[Former Member · Accepted solution]

stop saposcol using

saposcol -k

and again start using

saposcol -l

[Former Member · Accepted solution]

Dear Sunil ,

now SAPOSCOL is running on PROD DB .

Pls check below

ROOT@PRODORADB:/#ps -eaf | grep saposcol

irpadm 417894 1 0 14:52:48 - 0:00 saposcol

root 585992 282868 0 14:57:43 pts/0 0:00 grep saposcol

Even though still i cant get CPU , Memory usages details on OS07

I have selected SAPCCMSR.PRODORADB.99 (SAPOSCOL Destination) .

SAPCCMSR.PRODORADB.99 RFC Destination for CCMS agent sapccmsr. X X

still its not showing any values and i got below error.

Partner SAPCCMSR.PRODORADB.99 not reached (reading table )

Kindly suggest ,

[Former Member · Accepted solution]

You will have SAPCCMSR.PRODORADB.99 RFC destination.

Go to SM59 --> under TCP/IP connection --> select SAPCCMSR.PRODORADB.99 and do connection test.

also check whether you have give correct gateway and program ID.

[Former Member · Accepted solution]

Dear Sunil ,

Pls check the below error log.

Logon Connection Error

Error Details Error when opening an RFC connection

Error Details ERROR: program prodoradb.sapccmsr.99 not registered

Error Details LOCATION: SAP-Gateway on host PRDCIXI / sapgw01

Error Details DETAIL: TP prodoradb.sapccmsr.99 not registered

Error Details COMPONENT: SAP-Gateway

Error Details COUNTER: 8083

Error Details MODULE: gwr3cpic.c

Error Details LINE: 1835

Error Details RETURN CODE: 679

Error Details SUBRC: 0

Error Details RELEASE: 700

Error Details TIME: Wed Oct 13 15:21:15 2010

Error Details VERSION: 2

kindly suggest,

[Former Member · Accepted solution]

Do ps -eaf | grep for sapccm and check whether below two agents are running if not then you can start as below

sapccmsr -DCCMS

sapccm4x u2013DCCMS pf=/usr/sap/<SID>/SYS/profile/<SID>_<INSTANCE>_<host>

[Former Member · Accepted solution]

I should check from DB side or Central Instance side ?

[Former Member · Accepted solution]

On DB

only

sapccmsr -DCCMS

[Former Member · Accepted solution]

Dear Sunil ,

ROOT@PRODORADB:/#ps -eaf | grep sapccm

root 717304 671868 0 15:27:33 pts/0 0:00 grep sapccm

ROOT@PRODORADB:/#

Kindly suggest .

[Former Member · Accepted solution]

its not running try to start.

sapccmsr -DCCMS

[Former Member · Accepted solution]

Now its working fine.

Edited by: satheesh0812 on Oct 13, 2010 12:24 PM