DB2 Error: SQL1762N
Description : Unable to connect to database because there is not enough space to allocate active log files.
Explanation:
There is not enough disk space to allocate active log files. Possible reasons include:
- There is insufficient space available on the device used to store the recovery logs.
- If userexits are enabled, the userexit program may be failing due to an incorrect path, incorrect install directory, sharing violation, or other problem.
Solution:
Based on the cause:
- Ensure that there is sufficient space on the device for the primary logs, as DB2 may require extra space to allocate new logs so that the database will start with at least LOGPRIMARY log files. Do NOT delete recovery logs to free space, even if they appear inactive.
- Ensure the userexit program is operating correctly by manually invoking it. Review the instructions provided in the sample userexit source code for compiling and installing the userexit program. Ensure that the archive destination path exists.
Related Posts
- Error: SQL1263N Archive file name not valid
- SQL Server 2005 database DBA Checklist for database administrator
- Error: SQL0290N Table space access is not allowed
- (DBA TIPS) Maintenance Plan to avoid Transaction log file growth
- Error: SQL0284N The table was not created
Tags: DB2 Error Codes, Login Issues
