Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

User activity no longer recorded in DB2 Audit database

Questions
Tags
Users
Badges
James Wright
(6●4●3) 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 ?

0 votes

2 answers
9,358 views
0 votes

2 answers

Permanent link
Petroula Pantazopoulos
JAZZ DEVELOPER (366●1●2) Jul 27 '10, 10:50 a.m.
What do you mean by "Audit DB2 database"? Can you provide some context? Have you enabled auditing in DB2?

0 votes

Permanent link
James Wright
(6●4●3) 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>

0 votes

Your answer

Register or log in 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.

Ask a question
Guidelines
FAQ
Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details

Question asked: Jul 16 '10, 4:20 a.m.

Question was seen: 9,358 times

Last updated: Jul 16 '10, 4:20 a.m.

Confirmation Cancel Confirm