Results 1 to 7 of 7
  1. #1
    Join Date
    Feb 2009
    Posts
    12

    Unhappy Unanswered: Trouble starting DB2 service

    Hi all,

    I've got trouble starting DB2 windows services. I got this error :

    "Windows could not start the DB2 - DB2COPY1 - DB2 on Local Computer. For more information, review the System Event Log. Th this is a non-Microsoft service, contact the service vendor, and refer to service-specific error code -1220"

    Could someone help me to resolve this problem ?

    Thanks in advance,

    Yan302

  2. #2
    Join Date
    Feb 2009
    Posts
    114
    SQL1220N The database manager shared memory set cannot be allocated.

    Explanation:

    The database manager could not allocate its shared memory set. The cause
    of this error may be insufficient memory resources either for the
    database manager or the environment in which its operation is being
    attempted. Memory resources that can cause this error include:
    * The number of shared memory identifiers allocated in the system
    * The size of the shared memory segment
    * The amount of paging or swapping space available in the system
    * The amount of physical memory available in the system

    User response:

    One or more of the following:
    * Validate that sufficient memory resources are available to satisfy
    the database manager's requirements, and those of the other programs
    running on the system.
    * On Linux 32-bit, increase the kernel parameter shmmax to 256 MB. On
    Linux 64-bit, increase the kernel parameter shmmax to 1GB.
    * Reduce database manager's memory requirement for this memory set by
    reducing the database manager configuration parameters which affect
    it. These are: fenced_pool and, numdb.
    * Where appropriate, stop other programs using the system.

  3. #3
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    have you tried db2start from the command line - maybe the license
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  4. #4
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    please check instance_memory dbm cfg. If it's not automatic, change it and retry db2start

  5. #5
    Join Date
    Feb 2009
    Posts
    12
    Thanks for your answers.

    The problem is now resolved!

  6. #6
    Join Date
    Sep 2009
    Posts
    1
    Hi Yan302,
    Could you please let me know how you resolved the problem. Thanks.

    bohoa

  7. #7
    Join Date
    Dec 2009
    Posts
    1
    just go to command window of db2 and type the following one:

    db2 UPDATE DBM CFG USING INSTANCE_MEMORY automatic

Posting Permissions

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