IBM Support

SQL1041N The maximum number of concurrent databases have already been started

Technote (troubleshooting)


This technote explains how to resolve an SQL1041N error that can occur when trying to connect to an IBM® DB2® Test Datastore from IBM Rational® TestManager (TM).


The default number of databases that can be concurrently active (that is, have applications connected to them) is 8.

Resolving the problem

Change the number of databases that can be concurrently active to the desired number. The valid range is 1 to 256.

To change this number:

  1. Open the DB2 Control Center
  2. Expand All Systems -> [server name] -> Instances
  3. Right-click on the instance that you want to change (DB2 instance) and choose Configure Parameter from the pop-up menu
  4. Scroll down to NUMDB (under Environment)
  5. Change the value to the desired number
  6. Restart the DB2 service (Start -> Run -> services.msc)

Cross Reference information
Segment Product Component Platform Version Edition
Software Development Rational TestManager Datastore Windows 2003.06.15, 7.0

Document information

More support for: Rational TestManager

Software version: 7.0,,,,, 7.0.1,,,, 7.0.2, 2003.06.15, 2003.06.16

Operating system(s): Windows

Reference #: 1256971

Modified date: 27 October 2010