Skip to content
Menu
nix.engineering
  • Start
  • Info
  • Link Collection
  • Site Notice
nix.engineering

SQL1041N: The maximum number of concurrent databases have already been started. SQLSTATE=57032

Posted on March 26, 2018May 20, 2019

To solve this issue, change the number of databases that can be concurrently active to the desired number by increasing the parameter “numdb”.

Show the current value of numdb:

db2 get dbm cfg | findstr NUMDB
Max number of concurrently active databases (NUMDB) = 8

 
Adjust parameter to the desired value:

db2 update dbm cfg using NUMDB 10
DB20000I The UPDATE DATABASE MANAGER CONFIGURATION command completed successfully.

 
Site notes:
– The default value is 8.
– The valid range is 1 to 256.
– It may be necessary to restart the database for the change to take effect.

 

Reference:
http://www-01.ibm.com/support/docview.wss?uid=swg21256971

SQL1041N: Die maximale Anzahl gleichzeitig ablaufender Datenbanksitzungen ist erreicht. SQLSTATE=57032

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Recent Posts

  • ntp – what time it is?
  • Remove service from services.msc
  • Oracle DBNEWID Utility for new DBID and DBNAME
  • ORA-01103: database name ‘DB1’ in control file is not ‘DB2’
  • SQL1041N: The maximum number of concurrent databases have already been started. SQLSTATE=57032

Categories

  • Database
  • DB2
  • Exploit
  • Misc
  • Oracle
  • Security

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org
©2023 nix.engineering | WordPress Theme by Superb WordPress Themes