Return
-
Title
SQL0443N Routine "SYSPROC.DB_PARTITIONS" (specific name "DB_PARTITIONS") has returned an error SQLSTATE with diagnostic text "db2nodes.cfg reading error" -
Description
After setting up a remote DB2 agent no data is displayed in the database drilldowns.
This error is printed in the DB2 agent log file
SQL0443N Routine "SYSPROC.DB_PARTITIONS" (specific name "DB_PARTITIONS") has returned an error SQLSTATE with diagnostic text "db2nodes.cfg reading error".
-
Cause
Missing db2nodes.cfg file
-
Resolution
The file db2nodes.cfg is missing because the DB2 instance has been set up as a Workgroup Edition instance, but the software installation is an Enterprise Edition. So during instance setup something went wrong and no db2nodes.cfg file has been created.
If you have an Enterprise Edition software installation, do not configure Workgroup Edition instances.