Multiple clustered IS writing to a single DB for logging.

, , ,
1

Hi guys,

We have 2 Clustered IS writing sharing the same DB for logging purposes.
I expect to see the exact same errors with the exact same timestamp under Logs/Error in the Admin Console.
But this is not the case.
I do see both the IS writing to the DB ( I see the Server ID) in the DB.
Both the IS are 6.5
on Windows 2003
Java Version 1.4.2_07 (48.0)

The JDBC pools are configured to point to the same DB.

I have this under my extended setting to enable DB logging instead of filebased:
watt.server.auditStore=database

You guys think im missing a fix or an update?
I currently have these:
IS_6-5_SP2_Core_Fix5
IS_6-5_SP2_PubSub_Fix1
IS_6-5_SP2
WmPRT_6-5-1_SP1

Any help would be monumentally appreciated.
Sincerely,
Scoobydooo

2

the error log entries are stored and retreived by hostname. you will only see the errors for the physical server you are attached to even though it is the same database.

3

Mark,
How do i see the same logs in both the IS logs pages simultaneously?
Is there a way?
Any help would be monumentally appreciated.
Thanks
Scoobydoo

4

I’m not aware of anything within IS Administrator nor mWS that would do this. The best bet may just be a generic DB tool like TOAD.

5

Mark & Rob,
You guys are right.
The logs are associated with the ServerID of IS that inserts and retrieves them.
Retreiving them from another IS is not possible.

Thanks a lot for your help gentlemen.
I appreciate your help.
Scoobydoo !

6