Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2009
    Posts
    6

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

    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

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    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

  3. #3
    Join Date
    Jul 2009
    Posts
    6

    Thank you

    Thank you for the prompt reply.

    But we have only one database running?

  4. #4
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    What OS is DB2?

    What is output of db2level?

    What is output of "db2 list db directory" on the DB2 server?

    What is the dbm config?

    Andy

Posting Permissions

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