The database system logs errors and important messages in several log files. By monitoring the log files, you can identify unusual activity early on.
Regularly check the following log files for failed logon attempts:
Database Manager log file: dbm.prt
Loader Server log file: loader.log
More information: Database Administration, Log Files
If a user enters an incorrect user name or password when logging on to the DEMODB database using Database Studio, the system writes the following message to the Database Manager log file dbm.prt:
ERR_USRFAIL - user authorization failed