cancel
Showing results for 
Search instead for 
Did you mean: 

Warning: No connection to Auditing Data Store from CMS

Former Member
0 Kudos

Hello everyone.

I have the folowing issue. I have my auditing repository in DB2, when I try to configure the Auditing Data Store from CMC, I get this error "Warning: No connection to Auditing Data Store from CMS sia_incop_pro.CentralManagementServer."

In my BI server I delete all .txt files that automatically are created in the path: /bobje/bobjxi/sap_bobj/data/Auditing. When  I do that, I solve the issue of No connection to Auditing Data Store, but this is only for a short time because the .txt files are created again and the error message comes again. I tried the solution that I found in the following discussion: http://scn.sap.com/thread/3395164 but still not working. Any suggestion?

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

I resolved the issue.

The problem was that I didn´t have enough space in my tablespace, so I configured my tablespace as automatic resizing with maximum size with the following comands in my linux server:

1. db2 connect to <database>

2. db2 alter tablespace <name> autoresize yes

3. db2 alter tablespace <name> maxsize none

You use none to not specify a maximun limit to your tablespace.

Regards and thank you for your time

Answers (1)

Answers (1)

former_member191664
Active Contributor
0 Kudos

"Warning: No connection to Auditing Data Store from CMS" It seems that your DB2 Audit database tablespace is full.  The resolution is simply increase the tablespace of the Auditing database for new data to be written. Hope this SAP KB "1645207 - No CMS was configured as Auditor on BI 4 using DB2 Audit Database" would help to resolve your Auditing problem. Hope this helps, Jin-Chong

Former Member
0 Kudos

Hi Jin-Chong.

Yes I think that's the problem. Actually the moment that I created my Auditing Repository I followed the steps in that SAP Note (1645207) so I already have a tablespace created but I'm not sure about how resize the tablespace of my Auditing tablespace, I would like to know also the size of my tablespace in this moment, and how many space I should increase to it.

I used this command to see my tablespace and its containers.

db2 list tablespaces

db2 list tablespace containers for 5

Thanks for your response

Regards

former_member191664
Active Contributor
0 Kudos

Run the list tablespaces with show detail to find out which tablespace free pages run out space. db2 list tablespaces show detail and add more tablespace (temp) to it.  Hope you'd fine this SAP KB 334608 - DB6: SMS tablespace ##(PSAPTEMP##) is FULL helps Hope this helps, Jin-Chong