Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2004

    Unanswered: rollforward failed, SQL1042C

    $ db2 rollforward db nsnpd to end of logs
    SQL1042C An unexpected system error occurred. SQLSTATE=58004

    I check the db2diag.log ,it shows:

    2008-02-19- I8844855G517 LEVEL: Error
    PID : 1890 TID : 3005864448 PROC : db2agent (NSNPD)
    INSTANCE: db2inst1 NODE : 000 DB : NSNPD
    APPHDL : 0-55 APPID: *LOCAL.db2inst1.080219023054
    FUNCTION: DB2 UDB, recovery manager, sqlpForwardRecovery, probe:1230
    RETCODE : ZRC=0x87100027=-2028994521=SQLP_TRECTYPERR
    "A record other than those expected has been read during abort"
    DIA8536C A bad record type was encountered.

    What's wrong with it? Thx.

  2. #2
    Join Date
    May 2003
    You will need to call IBM support. The will probably want some trace data.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

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