ANR0264E
A database file IO error is prohibiting activation of db name with sqlcode dbCode.

Explanation

While attempting to activate the database an IO error occurred when processing a database file. The problem may have occurred in one of the following situations: The system cannot open, read from, or write to a database file. The system cannot create the database because an error occurred while the system was creating a database file or a directory for the database. The system cannot drop the database because an error occurred while the system was deleting a database file or a directory for the database. The system cannot create the database because an interrupt was received while the system was creating or deleting a database file or a directory for the database. The system cannot locate the database subdirectory or database configuration file during connect. Problem causes are ordered in terms of their frequency of occurrence: A log file cannot be found in the active log path directory. There may be a problem with the database directory the operation is being attempted on. There may be inadequate disk space to complete the operation. The database cannot be used.

System action

The server is not started because the database cannot be activated.

User response

Appropriate responses for the problem causes described above are: To verify if a log file is missing, check the db2diag.log for the presence of a logging error (return code contains SQLO_FNEX). If present, this error will contain the name of the missing log file. Ensure that the file is located in the active log path directory. If the file cannot be located, restore and roll-forward the database to an earlier point in time referenced in a log file preceding the missing log file (use a timestamp that is earlier than that of the missing file). There may be a problem with the database directory. Check the integrity of the directory. Examples of potential problems include: permissions issues, mount point problems, corruption. Increase filesystem size.