DB2 "No Storage Available for allocation" DIA8305C Memory allocation failure occurred

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • caviler
    New Member
    • Feb 2014
    • 5

    DB2 "No Storage Available for allocation" DIA8305C Memory allocation failure occurred

    db2diag.log shows error:

    =============== =============== ============
    MESSAGE : ZRC=0x850F0005=-2062614523=SQLO _NOSEG
    "No Storage Available for allocation"
    DIA8305C Memory allocation failure occurred.
    =============== =============== ============

    just simpley set kernel parameter kernel.randomiz e_va_space = 0

    1. append kernel.randomiz e_va_space = 0 to sysctl
    nano /etc/sysctl.conf

    2. apply
    sysctl -p
  • przytula
    New Member
    • Jun 2009
    • 13

    #2
    and what seems to be the problem ?
    best regards, Guy Przytula

    Comment

    • caviler
      New Member
      • Feb 2014
      • 5

      #3
      no problem, just share information, this error spent me 4 hours to find out how to fix it!

      Comment

      • Sjray12
        New Member
        • Sep 2022
        • 2

        #4
        Db2

        Same error, but that sequence did not fix my issue, any other suggestions

        Comment

        Working...