When you try to create the FileNet P8 domain an receive the following error:

FNRCD0009E: DB_ERROR: The database access failed with the following error: ErrorCode -104, Message 'DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=SELECT 1 FROM ****INSERT.;BEGIN-OF-STATEMENT;<values>, DRIVER=4.34.30' SQL: ""SELECT 1 FROM ****INSERT.FNGCD  for update with RS""

In this case there is some error with the deployapplication.xml where the database schema is set. In my case the values was empty as default. Just set the specific schema name in the configManager and redeploy the application.