-
Title
DB2 agent active but does not collect data. Log shows "ERROR : Instance Attach SQLCODE : -1390" -
Description
A DB2 agent has been configured and is active but is not collecting any data. Alarms are also being received stating that the connection to the database has failed.
-
Cause
SQL1390C The environment variable DB2INSTANCE is not defined or is invalid.
Explanation: The environment variable DB2INSTANCE is not defined
or is not set to a valid instance owner. -
Resolution
Set the DB2INSTANCE environment variable to the name of the instance to use. If you do not know the name of the instance to use or how to set the DB2INSTANCE environment variable to the instance name, refer to the DB2 Administration Guide.
Federated system users: refer to the DB2 Installation and Configuration Supplement for DB2INSTANCE information.
Ensure your PATH environment variable contains the sqllib/adm path in the home directory of the instance you want to use (for
example, /u/instance/sqllib/adm, where /u/instance is the home directory of the instance owner on a UNIX system).