Restore returns SQL 5099N database configuration parameter "IMAGELOGPATH" is not valid, reason code "2".

Cause

From 11.5.6, the "NEWLOGPATH" needs to be specified in RESTORE command if

1) The source database where the backup was taken is not using the default path for active logs; or

2) On the machine executing the RESTORE, there is an existing database of that name that is using nondefault path for active logs

Otherwise, error SQL5099N The value " PATH " indicated by the database configuration parameter "IMAGELOGPATH" is not valid, reason code "2" is return.

These conditions in the past might be handled by Db2 where at the end of the RESTORE Db2 would detect the path is not safe to use and change the resulting database to use the default. As it is not always the correct intention of the user, and can result in other error conditions. Therefore, starting with 11.5.6 Db2 is detecting this condition at the start of RESTORE processing and returning SQL 5099N. The user is asked to specify exactly what they want to use as active log path, instead of guessing or imposing the use of default log path. This change is intended, not a defect.