Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2007
    Posts
    15

    Unanswered: SQL1041N maximum databases already started

    Hi,

    DB2 UDB V8.1 fixpak 8a Workgroup server edition on Windows 2003

    I have 4 local databases in instance. When i am trying to activate or connect to 4th database i am getting the following error.

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

    I have only 3 active databases at that time.( list active databases). And NUMDB dbm cfg is 4. (get dbm cfg show detail showing 4 for both current and pending). Not sure where its going wrong.

    Do you have some suggestions ?

    Thanks
    Ramesh

  2. #2
    Join Date
    Jul 2006
    Location
    Pune , India
    Posts
    433
    just guessing....may be the toolsdb
    Rahul Singh
    Certified DB2 9 DBA / Application Developer

  3. #3
    Join Date
    Mar 2007
    Posts
    15
    Its tools db . But sometimes if i activate toolsdb as the 3rd database i can not activate the other database.

  4. #4
    Join Date
    Jan 2003
    Posts
    1,605
    Hi,
    if I remember correctly default value for NUMDB is 8. Why did you change this parameter? If you need more databases active at the same time then increase NUMDB parameter.

    If you thing this is a bug, then report problem to IBM. But before that you may look into bug list if this problem is not already solved.

    Hope this helps,
    Grofaty

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •