Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2006
    Posts
    105

    Unanswered: Error while connecting db

    Hello All,

    DB2 is running with v9.7fp3a with os version as windows2003. DB2 instance with two db.

    Getting error while connecting to one db, and able to connect to the other one.


    SQL1042c An unexpected system error occured SQLSTATE:58004

    error seems to be memory issue.

    Error in diag.log: attached:

    Thanks for your help in advance.

    Regards
    Meena.s
    Attached Files Attached Files

  2. #2
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,369
    You have a 32-bit instance - limit is 2GB for all databases. Need to reduce some config parameters (ie. bufferpools) to be able to activate both databases at the same time.

    Check this article for info about /3GB switch:
    The DB2 UDB memory model

Posting Permissions

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