DB2 Version 9.7 for Linux, UNIX, and Windows

Creating a database partition on an encrypted file system (AIX)

AIX® 6.1 supports the ability to encrypt a JFS2 file system or set of files. This feature is not supported with partitioned database environments in DB2® database products. An SQL10004C error will occur if you attempt to create a partitioned database environment using EFS (encrypted file systems) on AIX.

Symptoms

If you attempt to create a database on an encrypted file system in a multiple partition database environment, you will receive the following error: SQL10004C An I/O error occurred while accessing the database directory. SQLSTATE=58031

Causes

At this time it is not possible to create a partitioned database environment using EFS (encrypted file systems) on AIX. Since partitioned database partitions use rsh or ssh, the keystore in EFS is lost and database partitions are unable to access the database files that are stored on the encrypted file system.

Diagnosing the problem

The DB2 diagnostic (db2diag) log files will contain the error message and the following text: OSERR : ENOATTR (112) "No attribute found".

Resolving the problem

To create a database successfully in a partitioned database environment, you must have a file system that is available to all of the machines and it must not be an encrypted file system.