Results 1 to 5 of 5

Thread: Please Help

  1. #1
    Join Date
    Mar 2009

    Unanswered: Please Help

    Hi Experts,

    I am getting error

    SQL1219N The request failed because private virtual memory could
    not be allocated. SQLSTATE=57011


    The instance was unable to allocate enough private virtual memory to
    process the request. This may be a result of shared memory allocations
    made in other (unrelated) processes.

    User response:

    The problem may be corrected by:
    * Stopping other applications running on the machine, especially those
    that use large amounts of shared memory.

    sqlcode: -1219

    sqlstate: 57011

    I am using Windows XP and DB2 9.5c express.


  2. #2
    Join Date
    May 2007
    somewhere in dbforums
    That simply means you are out of memory. What is the amount of RAM and the amount of virtual memory that you have in your system.

    Don't expect DB2 to run on 128 / 256 MB RAM

    For quick relief what you can do is try to increase the virtual memory substantially.....
    IBM Certified Database Associate, DB2 9 for LUW

  3. #3
    Join Date
    Apr 2009
    I have the same problem on Win XP SP3, 2 GB RAM even after a fresh reboot and if the control center is the only application I start after login...

  4. #4
    Join Date
    Apr 2009

    Is your DB2 user a part of the Administrator group?

    This issue is not simply a "memory" issue. Perhaps you have run into the same issue that hit me. In an attempt to increase the security of my system, I removed the DB2 user(s) from the Windows Administrators group, assuming that the DB2 user simply needed to be in the DB2ADMINS group. Apparently, a process must need to be an Administrator (or something more than a DB2ADMIN at least) to allocate the type of memory that DB2 is trying to allocate. So, you may want to check to see if your DB2 user(s) are in the Administrator group.

  5. #5
    Join Date
    Mar 2010
    I had the same problem when i changed the user who run the DB2 services. I was able to fix this problem when I add the right 'act as a part of operating system' to the user and add user to the Administrators group. I'm not sure whether it is clean solution, however it works.

    On the other side, it seems that DB2 requires OS admin rights to run the services. It is not very nice behaviour, even SQL Server can run without them ...

Posting Permissions

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