Professional Web Applications Themes

FP3 on 8.1 broke my database - IBM DB2

My UDB database was ok when I installed FP3 to test things out. After installing FP3 the database gives me this message when I try to connect to it for the first time: $ db2 connect to c814db SQL1084C Shared memory segments cannot be allocated. SQLSTATE=57019 Since installing FP3 I have backed it out (back to FP2), but the problem remained. I've also backed out FP2 with no luck. This box is low on RAM but has nothing else running and was working OK. Please help! Below is a section of the db2diag.log that might be useful. Thanks, Frank SQL8017W ...

  1. #1

    Default FP3 on 8.1 broke my database

    My UDB database was ok when I installed FP3 to test things out. After
    installing FP3 the database gives me this message when I try to
    connect to it for the first time:

    $ db2 connect to c814db
    SQL1084C Shared memory segments cannot be allocated. SQLSTATE=57019

    Since installing FP3 I have backed it out (back to FP2), but the
    problem remained. I've also backed out FP2 with no luck. This box is
    low on RAM but has nothing else running and was working OK.

    Please help!

    Below is a section of the db2diag.log that might be useful.

    Thanks,
    Frank



    SQL8017W The number of processors on this machine exceeds the defined
    entitlement of "1" for the product "DB2 Enterprise Server Edition".
    The
    number of processors on this machine is "2". You should purchase
    additional
    processor based entitlements from your IBM representative or
    authorized dealer
    and update your license using the License Center or the db2licm
    command line
    utility. For more information on updating processor based licenses,
    refer to
    the Quick Beginnings manual for your platform. For more information
    on the
    db2licm utility, refer to the DB2 Command Reference.

    2003-09-30-15.09.01.394896 pid:1891 tid:1 level:3
    Common - Generic Registry - GlobalReg::ValidateRecord() probe:30
    impact 0x90000228 Invalid Global Registry missing field mask


    2003-09-30-15.09.03.360739 Instance:db2c81 Node:000
    PID:1886(db2star2) TID:1 Appid:none
    base sys utilities startdbm Probe:911

    ADM7513W Database manager has started.

    2003-09-30-15.09.12.159216 Instance:db2c81 Node:000
    PID:1931(db2agent (C814DB) 0) TID:1
    Appid:*LOCAL.db2c81.007910190911
    base sys utilities sqleFirstConnect Probe:15

    DIA8305C Memory allocation failure occurred.
    ZRC=0x850F0005

    2003-09-30-15.09.12.222687 Instance:db2c81 Node:000
    PID:1931(db2agent (C814DB) 0) TID:1
    Appid:*LOCAL.db2c81.007910190911
    base sys utilities sqleFirstConnect Probe:16

    DiagData
    0000 0e28 ...(
    Frank Guest

  2. #2

    Default Re: FP3 on 8.1 broke my database

    Frank,

    What platform are you running on? What version/release level? Are you
    using DB2 UDB with or without the DPF?

    Your best bet is to open up a PMR with IBM support. It might be a new bug,
    but it can also be orphaned IPC processes that weren't cleaned up when DB2
    was last started. There may be other causes also.

    Larry Edelstein

    Frank wrote:
     

    Larry Guest

  3. #3

    Default Re: FP3 on 8.1 broke my database

    If this is Linux/Windows your dbheap is trying to allocate 670MB of
    space...you'll need to look at decreasing num agents, bufferpool sizes
    etc (there can be some creep in underlying db2 usage of this heap on new
    release boundaries).

    If this is non linux unix, then your dbheap is mighty tiny and you
    should make sure your box is clean as Larry suggests (ipclean -a).

    Frank wrote:
     

    Sean Guest

Similar Threads

  1. OSX 10.3.7 broke Postgresql 8.0.0b5?
    By Jerry LeVan in forum PostgreSQL / PGSQL
    Replies: 11
    Last Post: December 28th, 09:34 PM
  2. php.net is broke
    By Rodney Green in forum PHP Development
    Replies: 0
    Last Post: August 9th, 02:08 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