backup fails after 3 hours

[Former Member]

Hello experts,

We are using Maxdb on linux.

till last week it was fine.

but suddenly it started showing error.

In normal case it takes 3 hours, but now it takes 3 and a half hours.

here is the job log:

• DBA Action starts:

Timestamp: 20081031230014 Function: sda Object: DATA

• SAVE/RESTORE request:

SAVE DATA QUICK TO '/dev/st0' TAPE BLOCKSIZE 8 NO CHECKPOINT MEDIANAME 'PRO_DATA_MON'

• SAVE/RESTORE request accepted:

OK

• SAVE/RESTORE result:

OK

Returncode -8020

Date 20081031

Time 00230018

Server sap-prod

Database PRO

Kernel Version Kernel 7.6.00 Build 018-123-119-055

Pages Transferred 7822120

Pages Left 2990064

Volumes

Medianame PRO_DATA_MON

Location /dev/st0

Errortext end of file

Label DAT_000000516

Is Consistent true

First LOG Page 37788260

Last LOG Page

DB Stamp 1 Date 20081031

DB Stamp 1 Time 00230015

DB Stamp 2 Date

DB Stamp 2 Time

Page Count 10812160

Devices Used 1

Database ID sap-prod:PRO_20070131_191115

Max Used Data Page 0

• SAVE/RESTORE request:

SAVE DATA IGNORE

• SAVE/RESTORE request accepted:

OK

• SAVE/RESTORE result:

ERR

-24988,ERR_SQL: Sql error

-3004,Invalid host file sequence

2,Backupmedium #1 (/dev/st0)

• SAVE/RESTORE request:

SAVE DATA CANCEL

• SAVE/RESTORE request accepted:

OK

• SAVE/RESTORE result:

OK

Returncode 0

Date

Time

Server

Database

Kernel Version

Pages Transferred 0

Pages Left 0

Volumes

Medianame

Location

Errortext

Label

Is Consistent

First LOG Page

Last LOG Page

DB Stamp 1 Date

DB Stamp 1 Time

DB Stamp 2 Date

DB Stamp 2 Time

Page Count 0

Devices Used

Database ID

Max Used Data Page

• DBA Action ends:

Timestamp: 20081101022232 State: Failure

need some help

thanks and regards,

pratap

[Former Member]

Dear Pratap,

does KNLDIAG or KNLDIAGERR anything tell you? You may find a lot more information in these files. Please have a look.

o.t. @Markus

7.6 is very very old? Well, we're still running some SAP systems on basis of 7.3. Must be very³³ old

Regards

André

[markus_doehr2]

o.t. @Markus

7.6 is very very old? Well, we're still running some SAP systems on basis of 7.3. Must be very³³ old

You BUILD is very old - 7.6.5.10 is the actual one.

And yes, 7.3 is also old - but still maintained - whereas 7.6.0.x is no more

Markus

[markus_doehr2]

Is your tape full? Which capacity does it have?

And: you´re MaxDB version is VERY VERY old...

Markus