You can activate different traces to create a detailed log of the messages issued by the database system.
Database Administration, Traces
Database Administration in CCMS, Tools