The database system logs errors and important messages in several log files. For information about the name, path and function of log files, see Concepts of the Database System, Log Files.
By monitoring the log files, you can identify unusual activity in a timely way.
Regularly check the following log files for failed logon attempts:
· Log file of the Database Manager
· Log file of the Loader
Messages from the Database Manager for the database instance DEMODB are logged in the log file c:\Documents and Settings\All Users\Application Data\sdb\data\wrk\DEMODB\dbm.prt. In the event of a failed logon attempt, the Database Manager writes the following message in this log file:
ERR_USRFAIL: user authorization failed