DB2 SQL error: SQLCODE: -1041, SQLSTATE: 57032, SQLERRMC: null

jithudb2 · #1 (**permalink**) 08-19-09, 11:43

Hi,

I am trying to connect to a DB2 database version 8.1 on a different machine from the one where application (JBoss) is running.

I am getting the following error while opening a connection.

DB2 SQL error: SQLCODE: -1041, SQLSTATE: 57032, SQLERRMC: null

I couldnt find any information about this error.

Can anyone please tell me what does this error mean?

Thanks

Jithu

ARWinner · #2 (**permalink**) 08-19-09, 13:00

Code:

SQL1041N  The maximum number of concurrent databases have already been
      started.

Explanation:

The application attempted to start an inactive database but the number
of active databases already equals the maximum value defined in the
system configuration file.

The command cannot be processed.

User response:

Wait for one of the databases to become inactive. If more databases are
required to be active at the same time, increase the value for numdb.
The new value takes effect after the next successful database manager
start.

 sqlcode: -1041

 sqlstate: 57032

You have too many databases open.

Andy