Results 1 to 1 of 1
  1. #1
    Join Date
    Sep 2010
    Posts
    34

    Unanswered: db2 rollfordward error

    Hello frieds.
    One more time I need your help.

    I run rollforware database to end of logs and get a following error:
    SQL1042C An unexpected system error occurred. SQLSTATE=58004

    The db2diag catch following:

    2011-01-11-09.28.54.640013-360 I447808256A573 LEVEL: Error
    PID : 188512 TID : 9767 PROC : db2sysc
    INSTANCE: db2inst1 NODE : 000 DB : MI_DB
    APPHDL : 0-18097 APPID: *LOCAL.db2inst1.110111152129
    AUTHID : DB2INST1
    EDUID : 9767 EDUNAME: db2agent (MI_DB)
    FUNCTION: DB2 UDB, recovery manager, sqlpForwardRecovery, probe:1230
    RETCODE : ZRC=0x8B0F0002=-1961951230=SQLO_NOMEM_DBH
    "No memory available in 'Database Heap'"
    DIA8302C No memory available in the database heap.

    2011-01-11-09.28.54.683082-360 I447808830A535 LEVEL: Severe
    PID : 188512 TID : 9767 PROC : db2sysc
    INSTANCE: db2inst1 NODE : 000 DB : MI_DB
    APPHDL : 0-18097 APPID: *LOCAL.db2inst1.110111152129
    AUTHID : DB2INST1
    EDUID : 9767 EDUNAME: db2agent (MI_DB)
    FUNCTION: DB2 UDB, data protection services, sqlufrol, probe:11500
    MESSAGE : Roll Forward Error:
    DATA #1 : Hexdump, 4 bytes
    0x0700000006BF3A20 : 8B0F 0002 ....

    2011-01-11-09.28.54.683274-360 E447809366A479 LEVEL: Warning
    PID : 188512 TID : 9767 PROC : db2sysc
    INSTANCE: db2inst1 NODE : 000 DB : MI_DB
    APPHDL : 0-18097 APPID: *LOCAL.db2inst1.110111152129
    AUTHID : DB2INST1
    EDUID : 9767 EDUNAME: db2agent (MI_DB)
    FUNCTION: DB2 UDB, data protection services, sqlufrol, probe:8180
    MESSAGE : ADM1611W The rollforward recovery phase has been completed.

    2011-01-11-09.28.54.683694-360 I447809846A504 LEVEL: Warning
    PID : 188512 TID : 9767 PROC : db2sysc
    INSTANCE: db2inst1 NODE : 000 DB : MI_DB
    APPHDL : 0-18097 APPID: *LOCAL.db2inst1.110111152129
    AUTHID : DB2INST1
    EDUID : 9767 EDUNAME: db2agent (MI_DB)
    FUNCTION: DB2 UDB, data protection services, sqlufrol, probe:8181
    MESSAGE : The rollforward recovery phase completed with a return code of
    -1961951230




    What happend????!!
    Last edited by robert_tr; 01-11-11 at 12:20.

Posting Permissions

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