It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Guidelines | FAQ
Follow this question
Question details

×1,230

question asked: Jul 16 '10, 4:20 a.m.
question was seen: 9,251 times
last updated: Jul 16 '10, 4:20 a.m.

Related questions

User activity no longer recorded in DB2 Audit database

0
James Wright (6●4●3) | asked Jul 16 '10, 4:20 a.m.
After initially working OK, I am finding the user activity logging occasionally stops being written to the Audit DB2 database.

The ipfInternal_java.log shows

43413101 WARN - LogJDBCAppender::searchXML() - SQLException
com.ibm.db2.jcc.b.SqlException: Invalid operation: statement is closed.

Has anyone else experienced this issue ?

2 answers

Most liked answers ↑|Newest answers|Oldest answers

0
permanent link
Petroula Pantazopoulos (366●1●2) | answered Jul 27 '10, 10:50 a.m.
JAZZ DEVELOPER
What do you mean by "Audit DB2 database"? Can you provide some context? Have you enabled auditing in DB2?
0
permanent link
James Wright (6●4●3) | answered Jul 27 '10, 11:28 a.m.
I have enabled audit logging to a DB2 Database within IBM Cognos Configuration as per the instructions. I find that whilst this works successfully initially and I can see Cognos writing log entries to the DB2 tables, it then stops working with a java exception :

43413101 WARN - LogJDBCAppender::searchXML() - SQLException
com.ibm.db2.jcc.b.SqlException: Invalid operation: statement is closed.

and also in the CogServer.log :

AuditDatabaseConnection jdbc:db2://d06nn99r:52000/audit Failure Log Server generic error <parameters><item><CDATA></item><item><CDATA></item></parameters>

Your answer

Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.