Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2009

    Unanswered: DB2 Shared Memory Error

    I am getting following error when trying to run db2 connect to <dbname> command.

    SQL1084C Shared memory segment cannot be allocated. SQLSTATE = 57019

    1. I have increased the size of the kernel.shmmax value.
    2. I have set the intance_memory database configuration setting to AUTOMATIC.

    but no success. Please help.

    Thank you.

  2. #2
    Join Date
    Jan 2009
    Zoetermeer, Holland
    V9.5? Try this:
    db2 update dbm cfg using Instance_Memory 001000000
    db2 update db  cfg using Database_Memory automatic
    This will limit your RAM consumption to 1,000,000 pages (4G).
    If the database starts normally, you can set Instance_Memory to automatic as well. You must stop/start the instance
    To reset your bufferpools, you can
    db2set DB2_override_BPF=4096
    After start/stop all the bufferpools come up with 4096 pages. STMM will pick them up and bring them to the ideal values in a day or 2.
    Last edited by dr_te_z; 04-24-09 at 07:58.

Posting Permissions

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