DB2® limits the number of database connections
that can be active at one time.
- Symptoms
- The database manager configuration parameter NUMDB determines
the maximum number, which is 8 by default. After you reach the maximum
number of connections in the Administration Explorer or
in the Data Source Explorer, you cannot create
a new connection. Therefore, when you attempt to deploy your change
commands, they might fail. The error message from DB2 is
"error in the script file."
- Resolving the problem
- This error is caused by having too many connections to DB2.
Delete one of your unused or less-used connections from the Administration
Explorer or in the Data Source Explorer or
consider increasing the size of NUMDB.