Problems with db2 log archive

[Ricardo Silva]

Hello,

In the db2diag.log I've this error's :

2005-02-15-16.35.19.488157+000 I37715388C366 LEVEL: Error
PID : 30414 TID : 1 PROC : db2logmgr
(RMDB) 0
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgArchiveLogFile, probe:3160
MESSAGE : Failed to archive log file S0000000.LOG to USEREXIT from
/Database/logs/NODE0000/ with rc = 24.

2005-02-15-16.35.19.488674+000 I37715755C369 LEVEL: Warning
PID : 30414 TID : 1 PROC : db2logmgr
(RMDB) 0
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgRetryFailedArchive,
probe:4780
MESSAGE : Still unable to archive log file 0 due to rc 24 for
LOGARCHMETH1
using method 4 and target .
and in db2uext2.err this message:

************************************************** ******************************
Time of Error: Tue Feb 15 16:36:01 2005

Parameter Count: 8
Parameters Passed:
Database name: RMDB
Logfile name: S0000000.LOG
Logfile path: /Database/logs/NODE0000/
Node number: NODE0000
Operating system: AIX
Release: SQL08020
Request: ARCHIVE
Audit Log File:
System Call Parms:
Media Type: disk
User Exit RC: 24

Error isolation: Unable to Get Log Configuration Information

************************************************** ******************************

I don't know what this means, the only thing I know is that I can't
rollfoward a db becouse it gives me this message :

SQL1268N Roll-forward recovery stopped due to error "24" while
retrieving log
file "S0000000.LOG" for database "TESTE" on node "0".
Anyone Know's what's passing with my db2.

Best Regard's

Ricardo Silva

[Larry]

I would recommend that you open a PMR with IBM support.

Larry Edelstein

Ricardo Silva wrote:

Hello,

In the db2diag.log I've this error's :

2005-02-15-16.35.19.488157+000 I37715388C366 LEVEL: Error
PID : 30414 TID : 1 PROC : db2logmgr
(RMDB) 0
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgArchiveLogFile, probe:3160
MESSAGE : Failed to archive log file S0000000.LOG to USEREXIT from
/Database/logs/NODE0000/ with rc = 24.

2005-02-15-16.35.19.488674+000 I37715755C369 LEVEL: Warning
PID : 30414 TID : 1 PROC : db2logmgr
(RMDB) 0
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgRetryFailedArchive,
probe:4780
MESSAGE : Still unable to archive log file 0 due to rc 24 for
LOGARCHMETH1
using method 4 and target .
and in db2uext2.err this message:

************************************************** ******************************
Time of Error: Tue Feb 15 16:36:01 2005

Parameter Count: 8
Parameters Passed:
Database name: RMDB
Logfile name: S0000000.LOG
Logfile path: /Database/logs/NODE0000/
Node number: NODE0000
Operating system: AIX
Release: SQL08020
Request: ARCHIVE
Audit Log File:
System Call Parms:
Media Type: disk
User Exit RC: 24

Error isolation: Unable to Get Log Configuration Information

************************************************** ******************************

I don't know what this means, the only thing I know is that I can't
rollfoward a db becouse it gives me this message :

SQL1268N Roll-forward recovery stopped due to error "24" while
retrieving log
file "S0000000.LOG" for database "TESTE" on node "0".
Anyone Know's what's passing with my db2.

Best Regard's

Ricardo Silva

[tex1244]

You might post this over in the Db2eug users group.

www.herethey.com

On 15 Feb 2005 08:42:54 -0800, c9******@dcc.online.pt (Ricardo Silva) wrote:

:Hello,
:
:In the db2diag.log I've this error's :
:
:2005-02-15-16.35.19.488157+000 I37715388C366 LEVEL: Error
:PID : 30414 TID : 1 PROC : db2logmgr
:(RMDB) 0
:INSTANCE: db2inst1 NODE : 000
:FUNCTION: DB2 UDB, data protection, sqlpgArchiveLogFile, probe:3160
:MESSAGE : Failed to archive log file S0000000.LOG to USEREXIT from
: /Database/logs/NODE0000/ with rc = 24.
:
:2005-02-15-16.35.19.488674+000 I37715755C369 LEVEL: Warning
:PID : 30414 TID : 1 PROC : db2logmgr
:(RMDB) 0
:INSTANCE: db2inst1 NODE : 000
:FUNCTION: DB2 UDB, data protection, sqlpgRetryFailedArchive,
:probe:4780
:MESSAGE : Still unable to archive log file 0 due to rc 24 for
:LOGARCHMETH1
: using method 4 and target .
:
:
:and in db2uext2.err this message:
:
:************************************************* *******************************
:Time of Error: Tue Feb 15 16:36:01 2005
:
:Parameter Count: 8
:Parameters Passed:
:Database name: RMDB
:Logfile name: S0000000.LOG
:Logfile path: /Database/logs/NODE0000/
:Node number: NODE0000
:Operating system: AIX
:Release: SQL08020
:Request: ARCHIVE
:Audit Log File:
:System Call Parms:
:Media Type: disk
:User Exit RC: 24
:
:> Error isolation: Unable to Get Log Configuration Information
:
:************************************************* *******************************
:
:I don't know what this means, the only thing I know is that I can't
:rollfoward a db becouse it gives me this message :
:
:SQL1268N Roll-forward recovery stopped due to error "24" while
:retrieving log
:file "S0000000.LOG" for database "TESTE" on node "0".
:
:
:Anyone Know's what's passing with my db2.
:
:Best Regard's
:
:Ricardo Silva

[Bob [IBM]]

#define RC_NOTFOUND 24 /* db2uext2() / file not found */

Are you sure your userexit executable file is in the correct location? Generally (if I
recall correctly) $HOME/sqllib/adm works...

--

Bob
Engagement Specialist - DB2 Information Management Software - IBM Software Group
IBM Toronto Lab
[My comments are solely my own and are not meant to represent an official IBM position -
ask my cat!]
"Ricardo Silva" <c9******@dcc.online.pt> wrote in message
news:c7**************************@posting.google.c om...

Hello,

In the db2diag.log I've this error's :

2005-02-15-16.35.19.488157+000 I37715388C366 LEVEL: Error
PID : 30414 TID : 1 PROC : db2logmgr
(RMDB) 0
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgArchiveLogFile, probe:3160
MESSAGE : Failed to archive log file S0000000.LOG to USEREXIT from
/Database/logs/NODE0000/ with rc = 24.

2005-02-15-16.35.19.488674+000 I37715755C369 LEVEL: Warning
PID : 30414 TID : 1 PROC : db2logmgr
(RMDB) 0
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgRetryFailedArchive,
probe:4780
MESSAGE : Still unable to archive log file 0 due to rc 24 for
LOGARCHMETH1
using method 4 and target .
and in db2uext2.err this message:

************************************************** ******************************
Time of Error: Tue Feb 15 16:36:01 2005

Parameter Count: 8
Parameters Passed:
Database name: RMDB
Logfile name: S0000000.LOG
Logfile path: /Database/logs/NODE0000/
Node number: NODE0000
Operating system: AIX
Release: SQL08020
Request: ARCHIVE
Audit Log File:
System Call Parms:
Media Type: disk
User Exit RC: 24

Error isolation: Unable to Get Log Configuration Information

************************************************** ******************************

I don't know what this means, the only thing I know is that I can't
rollfoward a db becouse it gives me this message :

SQL1268N Roll-forward recovery stopped due to error "24" while
retrieving log
file "S0000000.LOG" for database "TESTE" on node "0".
Anyone Know's what's passing with my db2.

Best Regard's

Ricardo Silva

[Ricardo Silva]

Yes, it's in the correct place. I manage other RS/6000 machine's , and
the user exit work well in them.

thank's anyway!!

"Bob [IBM]" <Bo******@canada.com> wrote in message news:<37*************@individual.net>...

#define RC_NOTFOUND 24 /* db2uext2() / file not found */

Are you sure your userexit executable file is in the correct location? Generally (if I
recall correctly) $HOME/sqllib/adm works...

--

Bob
Engagement Specialist - DB2 Information Management Software - IBM Software Group
IBM Toronto Lab
[My comments are solely my own and are not meant to represent an official IBM position -
ask my cat!]
"Ricardo Silva" <c9******@dcc.online.pt> wrote in message
news:c7**************************@posting.google.c om...

Hello,

In the db2diag.log I've this error's :

2005-02-15-16.35.19.488157+000 I37715388C366 LEVEL: Error
PID : 30414 TID : 1 PROC : db2logmgr
(RMDB) 0
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgArchiveLogFile, probe:3160
MESSAGE : Failed to archive log file S0000000.LOG to USEREXIT from
/Database/logs/NODE0000/ with rc = 24.

2005-02-15-16.35.19.488674+000 I37715755C369 LEVEL: Warning
PID : 30414 TID : 1 PROC : db2logmgr
(RMDB) 0
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgRetryFailedArchive,
probe:4780
MESSAGE : Still unable to archive log file 0 due to rc 24 for
LOGARCHMETH1
using method 4 and target .
and in db2uext2.err this message:

************************************************** ******************************
Time of Error: Tue Feb 15 16:36:01 2005

Parameter Count: 8
Parameters Passed:
Database name: RMDB
Logfile name: S0000000.LOG
Logfile path: /Database/logs/NODE0000/
Node number: NODE0000
Operating system: AIX
Release: SQL08020
Request: ARCHIVE
Audit Log File:
System Call Parms:
Media Type: disk
User Exit RC: 24

Error isolation: Unable to Get Log Configuration Information

************************************************** ******************************

I don't know what this means, the only thing I know is that I can't
rollfoward a db becouse it gives me this message :

SQL1268N Roll-forward recovery stopped due to error "24" while
retrieving log
file "S0000000.LOG" for database "TESTE" on node "0".
Anyone Know's what's passing with my db2.

Best Regard's

Ricardo Silva