SQL1024N SQL1013N messages in DB2

SQL1024N SQL1013N messages in DB2 were coming up after running Create and Insert queries. While working on IB< Connections database setup, I have received the following error messages in logs.

SQL1024N A database connection does not exist. SQLSTATE=08003
SQL1013N The database alias name or database name “FNOS” could not be found.

The is repeated for rest of WIKIS, Activities and other databases that are required for Connections.

DB2 is on v10.5, IC 5.0 and User is db2inst1.

Resolution

This was pretty easy one to troubleshoot as I was executing the queries (create or insert) using root user and the database instance here is with db2inst1 user. After changing to db2inst1 user, the queries were executed. Also, the SQL files that needs to be executed were changed to db2inst1 user role so that there wont be any problem during execution.

These error messages are mostly related to Role specific changes.