Results 1 to 7 of 7
  1. #1
    Join Date
    Dec 2002
    Location
    Madrid - Spain
    Posts
    422
    Provided Answers: 1

    Unanswered: error in db2start v8.

    good morning,
    I have DB2 V8 32-bit AIX 5.3.
    I have run this to change the memory of the instance:

    db2 update dbm cfg using INSTANCE_MEMORY 262,144

    and running the db2start command gives me this error:

    11/01/2012 00:00:24 0 0 SQL1220N The database manager shared memory can not be September allocated.
    SQL1032N No start database manager command was issued. SQLSTATE = 57019

    can someone give me a hint of why the error?

    Thank you very much and best regards.
    DBA DB2 for LUW

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Check db2diag.log
    ---
    "It does not work" is not a valid problem statement.

  3. #3
    Join Date
    Dec 2002
    Location
    Madrid - Spain
    Posts
    422
    Provided Answers: 1
    Good morning,

    This error show me in db2diag.log
    2012-11-01-01.12.52.121881+060 I18786981C1498 LEVEL: Event
    PID : 2691316 TID : 1 PROC : db2start
    INSTANCE: ulises NODE : 000
    FUNCTION: DB2 UDB, base sys utilities, sqleStartStopSingleNode, probe:1130
    DATA #1 : String, 27 bytes
    /ulises/sqllib/adm/db2star2
    DATA #2 : Hexdump, 256 bytes
    0x2FF1D4A8 : 2F75 6C69 7365 732F 7371 6C6C 6962 2F61 /ulises/sqllib/a
    0x2FF1D4B8 : 646D 2F64 6232 7374 6172 3200 4E4F 4D53 dm/db2star2.NOMS
    0x2FF1D4C8 : 4700 0000 0000 0000 0000 0000 0000 0000 G...............
    0x2FF1D4D8 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
    0x2FF1D4E8 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
    0x2FF1D4F8 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
    0x2FF1D508 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
    0x2FF1D518 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
    0x2FF1D528 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
    0x2FF1D538 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
    0x2FF1D548 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
    0x2FF1D558 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
    0x2FF1D568 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
    0x2FF1D578 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
    0x2FF1D588 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
    0x2FF1D598 : 0000 0000 0000 0000 0000 0000 0000 0000 ................

    Greetings.
    DBA DB2 for LUW

  4. #4
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Quote Originally Posted by georgipa View Post
    This error show me in db2diag.log
    2012-11-01-01.12.52.121881+060 I18786981C1498 LEVEL: Event
    Obviously, this isn't an error. This is an "event". The error must be somewhat later in the file.
    ---
    "It does not work" is not a valid problem statement.

  5. #5
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    Quote Originally Posted by georgipa View Post
    good morning,
    I have DB2 V8 32-bit AIX 5.3.


    db2 update dbm cfg using INSTANCE_MEMORY 262,144

    Why are you trying to set INSTANCE_MEMORY to 1GB? It's usually small in v8. Change it to automatic and let db2 deal with it.

  6. #6
    Join Date
    Dec 2002
    Location
    Madrid - Spain
    Posts
    422
    Provided Answers: 1
    the value of this parameter before editing was instance_memory 100000,
    this is about 390 mb, 1 gb need to modify, my question is because DB2 can not change this parameter and what is the reason.

    Greetings.
    DBA DB2 for LUW

  7. #7
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    You don't want to set instance_memory to 1GB for v8. Read The DB2 UDB memory model to understand what's part of instance_memory.

    As n_i mentioned, look for errors in the db2diag.log.

Posting Permissions

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