DB2 SQL1041N The maximum number of concurrent databases have already been started (4043613)

Date - 11/2007
Affected Product & Version - NetVault: Backup 7.4 Upwards
Affected Module & Version - APM for DB2 (Version 2.6.x)
OS Version - Any
Application Information - DB2 8.x


Description:
Specific problem with NetVault: Backup, APM for DB2 (Version 2.6.x) and DB2 8.x

Symptoms:
When backing up one or more DB2 databases the backup fails with the error "SQL1041N The maximum number of concurrent databases have already been started. SQLSTATE=57032".

This problem is seen in DB2 installations with more than one DB2 database.

The user can connect to the database using the DB2 tools

First check that there are no stray applications keeping the databases open. Then either:

1) Increase the value of the DB2 database manager parameter NUMDB (default is 8). Note that a DB2 service restart is required for this to take effect.
or
2) split the Netvault DB2 backup jobs into smaller jobs each containing less than NUMDB DB2 databases.


Explanation:
The DB2 configuration parameter NUMDB specifies the maximum number of local databases that can be concurrently active (that is, have applications connected to them), or the maximum number of different database aliases that can be catalogued on a DB2 Connect(TM) server. Each database takes up storage, and an active database uses a new shared memory segment.

In the process of the NetVault DB2 backup, the connection is maintained to all databases for the duration of the entire backup job, not just for the time that the individual database is being backed up.

To backup all the required databases in one NetVault job, increase the NUMDB parameter to allow sufficient concurrently active databases. Note however that this does have an impact on memory usage, so this needs to be considered by the DBA.

To find out the current setting of NUMDB run a db2 command prompt and use:

db2=> get dbm cfg

This will show all the Database Administration parameters, search for the NUMDB value.

The change numdb use:

update dbm cfg using numdb 1

A DB2 service restart is required for this to take effect.

Alternatively the DB2 backup job can be split into several smaller NetVault jobs, each only backing up a subset of the DB2 databases. When the first DB2 job finishes, it will release the active connection to all the databases it is backing up. Note however, these jobs must not be run concurrently.

English version available ID: 3192
Version française disponible ID
Deutsche Version verfügbar ID