Results 1 to 3 of 3
  1. #1
    Join Date
    May 2002
    Location
    General Deheza, Cba, Arg.
    Posts
    276

    Log archive failed with rc -2045837302

    hi,
    I recive this messages in the db2diag.log. any idea?

    TIA
    -------------------------------------------------------------------------------
    2005-02-11-08.26.39.010000-180 I372393H319 LEVEL: Error
    PID : 1220 TID : 4352 PROC : db2syscs.exe
    INSTANCE: DB2INST1 NODE : 000
    FUNCTION: DB2 UDB, data protection, sqlpgArchivePendingLogs, probe:1500
    MESSAGE : Log archive failed with rc -2045837302 for LOGARCHMETH1.

    2005-02-11-08.26.40.010000-180 I372714H363 LEVEL: Error
    PID : 1220 TID : 4352 PROC : db2syscs.exe
    INSTANCE: DB2INST1 NODE : 000
    FUNCTION: DB2 UDB, data protection, sqlpgArchiveLogDisk, probe:2500
    RETCODE : ZRC=0x860F000A=-2045837302=SQLO_FNEX "File not found."
    DIA8411C A file "" could not be found.

    2005-02-11-08.26.40.025000-180 I373079H485 LEVEL: Error
    PID : 1220 TID : 4352 PROC : db2syscs.exe
    INSTANCE: DB2INST1 NODE : 000
    FUNCTION: DB2 UDB, data protection, sqlpgArchiveLogFile, probe:3160
    MESSAGE : Failed to archive log file S0098470.LOG to
    F:\DB2INST1\NODE0000\SQL00001\log_archivados\DB2IN ST1\DWCORP\NODE0000\
    C0000002\ from F:\DB2INST1\NODE0000\SQL00001\SQLOGDIR\ with rc =
    -2045837302.

    2005-02-11-08.26.40.025000-180 I373566H319 LEVEL: Error
    PID : 1220 TID : 4352 PROC : db2syscs.exe
    INSTANCE: DB2INST1 NODE : 000
    FUNCTION: DB2 UDB, data protection, sqlpgArchivePendingLogs, probe:1500
    MESSAGE : Log archive failed with rc -2045837302 for LOGARCHMETH1.

    2005-02-11-08.26.41.025000-180 I373887H363 LEVEL: Error
    PID : 1220 TID : 4352 PROC : db2syscs.exe
    INSTANCE: DB2INST1 NODE : 000
    FUNCTION: DB2 UDB, data protection, sqlpgArchiveLogDisk, probe:2500
    RETCODE : ZRC=0x860F000A=-2045837302=SQLO_FNEX "File not found."
    DIA8411C A file "" could not be found.

    2005-02-11-08.26.41.025000-180 I374252H485 LEVEL: Error
    PID : 1220 TID : 4352 PROC : db2syscs.exe
    INSTANCE: DB2INST1 NODE : 000
    FUNCTION: DB2 UDB, data protection, sqlpgArchiveLogFile, probe:3160
    MESSAGE : Failed to archive log file S0098471.LOG to
    F:\DB2INST1\NODE0000\SQL00001\log_archivados\DB2IN ST1\DWCORP\NODE0000\
    C0000002\ from F:\DB2INST1\NODE0000\SQL00001\SQLOGDIR\ with rc =
    -2045837302.

    2005-02-11-08.26.41.025000-180 I374739H319 LEVEL: Error
    PID : 1220 TID : 4352 PROC : db2syscs.exe
    INSTANCE: DB2INST1 NODE : 000
    FUNCTION: DB2 UDB, data protection, sqlpgArchivePendingLogs, probe:1500
    MESSAGE : Log archive failed with rc -2045837302 for LOGARCHMETH1.

  2. #2
    Join Date
    Mar 2004
    Posts
    448
    Chech your logging path

    db2 get db cfg for <database_name>|grep LOG

    check what type of type of archiving(if at all) you are using.

    Important is to find the space

    df -k

    LOG_RETAIN or USER_EXIT

    USER_EXIT wrote the error in AUDIT_ERROR_PATH.

    Finally do a manually archiving

    db2 archive log .....

  3. #3
    Join Date
    May 2002
    Location
    General Deheza, Cba, Arg.
    Posts
    276

    Thumbs up

    very thanks..
    the LOGARCHMETH1 parameter's path is incorrex...
    now ok

Posting Permissions

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