Professional Web Applications Themes

runstats and error code 930 - IBM DB2

DB2 UDB ESE V8.1 (64bit) + fp2 on AIX5L I kept fighting with this error and finally I got tired. $ db2 "runstats on table blah.blah with distribution and detailed indexes all" SQL2310N The utility could not generate statistics. Error "-930" was returned. =========== 2003-07-25-11.12.13.516092 Instance: Node:000 PID:34882(db2agent (x) 0) TID:1 Appid:*LOCAL..0823B5154618 oper system services MemAllocate Probe:203 Database: OS memory allocation (malloc()) failure. errno = 0x0FFFFFFFFFFF2D60 : 0x0000000C ============= How much memory does this utility try to get? ??? There is at least 6G physical memory left and my pageing space is 2G (I don't need a big one). Does ...

  1. #1

    Default runstats and error code 930

    DB2 UDB ESE V8.1 (64bit) + fp2 on AIX5L
    I kept fighting with this error and finally I got tired.

    $ db2 "runstats on table blah.blah with distribution and detailed
    indexes all"
    SQL2310N The utility could not generate statistics. Error "-930" was
    returned.

    ===========
    2003-07-25-11.12.13.516092 Instance: Node:000
    PID:34882(db2agent (x) 0) TID:1
    Appid:*LOCAL..0823B5154618
    oper system services MemAllocate Probe:203 Database:
    OS memory allocation (malloc()) failure.
    errno =
    0x0FFFFFFFFFFF2D60 : 0x0000000C
    =============

    How much memory does this utility try to get? ???
    There is at least 6G physical memory left and my pageing space is 2G (I
    don't need a big one).

    Does anyone have any idea?
    BTW, I need the detailed statistics information.

    ================================
    $ db2 ? sql0930


    SQL0930N There is not enough storage available to process the
    statement.

    Explanation:

    A request was made to the database that required another memory
    page but no more pages are available to the database manager.

    The statement cannot be processed.

    User Response:

    Possible solutions include:

    o Verify that your system has sufficient real and virtual
    memory.

    o Remove background processes.

    o If the error occurs during DUOW resynchronization, increase
    the maxagents and reduce the resync_interval database
    manager configuration parameter values.

    o If the error occurs on a statement which referenced a routine
    (UDF, stored procedure or method), it may be that the storage
    required to contain the arguments and return values was more
    than the memory available in the system. This might occur if
    the routine is defined with BLOB, CLOB, DBCLOB parameters or
    return values, having a large size (2GB for example).



    If the possible solutions listed above do not solve the problem,
    it may be necessary to consider changing the definition of the
    routine.

    sqlcode : -930

    sqlstate : 57011


    Regards,
    Fan Ruoxin

    Fan Ruo Xin Guest

  2. #2

    Default Re: runstats and error code 930

    I'd play around here :

    db2mtrk executable/memory tracker. (available on unix?)
    Statistics Heap has max size of 18120704 bytes

    GET DB CFG FOR ...
    Statistics heap size (4KB) (STAT_HEAP_SZ) = 4384

    PM

    "Fan Ruo Xin" <fanruoxsbcglobal.net> a écrit dans le message de news:
    [email]3F343794.352CD8CAsbcglobal.net[/email]...
    > DB2 UDB ESE V8.1 (64bit) + fp2 on AIX5L
    > I kept fighting with this error and finally I got tired.
    >
    > $ db2 "runstats on table blah.blah with distribution and detailed
    > indexes all"
    > SQL2310N The utility could not generate statistics. Error "-930" was
    > returned.
    >
    > ===========
    > 2003-07-25-11.12.13.516092 Instance: Node:000
    > PID:34882(db2agent (x) 0) TID:1
    > Appid:*LOCAL..0823B5154618
    > oper system services MemAllocate Probe:203 Database:
    > OS memory allocation (malloc()) failure.
    > errno =
    > 0x0FFFFFFFFFFF2D60 : 0x0000000C
    > =============
    >
    > How much memory does this utility try to get? ???
    > There is at least 6G physical memory left and my pageing space is 2G (I
    > don't need a big one).
    >
    > Does anyone have any idea?
    > BTW, I need the detailed statistics information.
    >
    > ================================
    > $ db2 ? sql0930
    >
    >
    > SQL0930N There is not enough storage available to process the
    > statement.
    >
    > Explanation:
    >
    > A request was made to the database that required another memory
    > page but no more pages are available to the database manager.
    >
    > The statement cannot be processed.
    >
    > User Response:
    >
    > Possible solutions include:
    >
    > o Verify that your system has sufficient real and virtual
    > memory.
    >
    > o Remove background processes.
    >
    > o If the error occurs during DUOW resynchronization, increase
    > the maxagents and reduce the resync_interval database
    > manager configuration parameter values.
    >
    > o If the error occurs on a statement which referenced a routine
    > (UDF, stored procedure or method), it may be that the storage
    > required to contain the arguments and return values was more
    > than the memory available in the system. This might occur if
    > the routine is defined with BLOB, CLOB, DBCLOB parameters or
    > return values, having a large size (2GB for example).
    >
    >
    >
    > If the possible solutions listed above do not solve the problem,
    > it may be necessary to consider changing the definition of the
    > routine.
    >
    > sqlcode : -930
    >
    > sqlstate : 57011
    >
    >
    > Regards,
    > Fan Ruoxin
    >

    PM \(pm3iinc-nospam\) Guest

  3. #3

    Default Re: runstats and error code 930

    Thank you, PM.

    I believe the value of db cfg statistics heap is only a SOFT LIMIT,
    which should not cause my runstats fail. Anyway I still use the maximum
    allowed heap size and failed with the same error.

    I found the reason - that because one of the indexes I created is based
    on a generated column. Even the value of generated column is based on
    the other column(s). But they are still physical stored, right? It is
    hard to understand why runstats needs to malloc(a_big_size)???

    I am really wondering why I am the first person who eats the crab.

    Regards,
    Fan Ruoxin

    ================================================== =====

    From: PM \(pm3iinc-nospam\) (Pm3iinc.NoSpamsympatico.ca)

    Subject: Re: runstats and error code 930

    Date: 2003-08-08 21:48:11 PST



    I'd play around here :

    db2mtrk executable/memory tracker. (available on unix?)

    Statistics Heap has max size of 18120704 bytes



    GET DB CFG FOR ...

    Statistics heap size (4KB) (STAT_HEAP_SZ) = 4384



    PM



    ================================================== ==============

    From: Fan Ruo Xin (fanruoxsbcglobal.net)

    Subject: runstats and error code 930

    Date: 2003-08-08 17:02:09 PST



    DB2 UDB ESE V8.1 (64bit) + fp2 on AIX5L

    I kept fighting with this error and finally I got tired.



    $ db2 "runstats on table blah.blah with distribution and detailed
    indexes all"

    SQL2310N The utility could not generate statistics. Error "-930" was
    returned.



    ===========

    2003-07-25-11.12.13.516092 Instance: Node:000

    PID:34882(db2agent (x) 0) TID:1

    Appid:*LOCAL..0823B5154618

    oper system services MemAllocate Probe:203 Database:

    OS memory allocation (malloc()) failure.

    errno =

    0x0FFFFFFFFFFF2D60 : 0x0000000C

    =============



    How much memory does this utility try to get? ???

    There is at least 6G physical memory left and my pageing space is 2G.



    Does anyone have any idea?

    BTW, I need the detailed statistics information.


    Fan Ruo Xin Guest

  4. Moderated Post

    Default Re: runstats and error code 930

    Removed by Administrator
    Fan Ruo Xin Guest
    Moderated Post

Similar Threads

  1. runstats - oracle
    By janagana in forum IBM DB2
    Replies: 5
    Last Post: August 23rd, 05:31 PM
  2. runstats use all the CPUs?
    By Fan Ruo Xin in forum IBM DB2
    Replies: 2
    Last Post: July 26th, 12:22 AM
  3. runstats and embedded sql
    By Larry Menard in forum IBM DB2
    Replies: 2
    Last Post: July 9th, 11:32 PM
  4. Runstats issue
    By Kota in forum IBM DB2
    Replies: 3
    Last Post: July 7th, 12:50 PM
  5. runstats
    By xixi in forum IBM DB2
    Replies: 10
    Last Post: July 3rd, 12:51 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139