Results 1 to 7 of 7
  1. #1
    Join Date
    Jul 2011
    Posts
    10

    Unanswered: Error SQL1084C when start db2

    I have a database db2 on Win 2003 32 bit.

    Anh I can't start database after config memory of database.

    The error is SQL1084C Shared memory segments cannot be allocated. SQLSTATE=57019.

    How can I start my database? Please help..........

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    You do not have enough memory for your configuration.

    Please post output from "GET DBM CFG" and "GET DB CFG...". Also supply us with how much memory you have on the server.

    Andy

  3. #3
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    What changes did you make to the memory configuration. My first guess would be to revert them.

  4. #4
    Join Date
    Jul 2011
    Posts
    10
    Quote Originally Posted by n_i View Post
    What changes did you make to the memory configuration. My first guess would be to revert them.
    I don't remember what I do

  5. #5
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Looking in db2diag.log might give you a hint.

  6. #6
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    What you can try to do is to set DB2_OVERRIDE_BPF registry variable to, let's say, 1000 and restart the instance. Then, connect to the db and reduce some config parameters (ie. bufferpools). Remember to unset this register variable and restart the instance after you're done.

  7. #7
    Join Date
    Jul 2011
    Posts
    10
    Quote Originally Posted by db2girl View Post
    What you can try to do is to set DB2_OVERRIDE_BPF registry variable to, let's say, 1000 and restart the instance. Then, connect to the db and reduce some config parameters (ie. bufferpools). Remember to unset this register variable and restart the instance after you're done.
    Ok thanks, I will try...

Posting Permissions

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