DB backup warnings

[Damir]

Hello,
does someone know what these two warnings mean, while executing a full
database backup:

--
Srdačan pozdrav,
Damir Wilder
ETNA d.o.o.
tel: +3851-4611-111
fax: +3851-4612-722
---

[Damir]

Hello,
does someone know what these two warnings mean, while executing a full
database backup:

SQL2540W Restore is successful, however a warning "2539, 2580" was
encountered during Database Restore while processing in No Interrupt mode.

Here is a corresponding db2diag log entry:

2009-01-31-05.16.18.464546+060 E355613102A939 LEVEL: Warning
PID : 2179286 TID : 1 PROC : db2agent (PPZPROD)
0
INSTANCE: db2 NODE : 000 DB : PPZPROD
APPHDL : 0-899 APPID: *LOCAL.db2.090131041618
AUTHID : DB2
FUNCTION: DB2 UDB, database utilities, sqludMRResponse, probe:1390
MESSAGE : SQL2540W Restore is successful, however a warning "" was
encountered
during Database Restore while processing in No Interrupt mode.
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: 2540 sqlerrml: 10
sqlerrmc: 2539, 2580
sqlerrp : sqluComp
sqlerrd : (1) 0x00000000 (2) 0x00000000 (3) 0x00000000
(4) 0x00000000 (5) 0x00000000 (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:

Thanks,
Damir

[Damir]

Typo error, it was a restore, not a backup...

[Serge Rielau]

db2 => ? SQL2539;

SQL2539W Warning! Restoring to an existing database that is the same as
the backup image database. The database files will be deleted.

Explanation:

The database aliases, names and seeds of the target database and
database image are the same, indicating these are the same databases.
The current database will be overwritten by the backup version.

User response:

Return to the utility with the callerac parameter indicating processing
to continue or end.

db2 => ? SQL2580;

SQL2580W Warning! Restoring logs to a path which contains existing log
files. Attempting to overwrite an existing log file during restore
will cause the restore operation to fail.

Explanation:

The specified log target path contains at least one file with a name
which matches the log filename format. If the restore operation later
attempts to extract a log file of the same name, this will cause the
restore to fail.

User response:

Either remove the existing log files from the log target path, or
otherwise ensure that the files which exist in the log target will not
match the filenames of any logs to be extracted from this backup image.
Then return the utility with a callerac parameter indicating that
restore processing should either continue or terminate.

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

[Damir]

Oh...
Thank you, that makes perfect sense!
Searching the InfoCenter for the strings "2539" and "2580" (without the
"SQL" prefix) didn't return any (relevant) results :-((

Regards,
Damir

"Serge Rielau" <sri...@ca.ibm.com> wrote in message
news:6uo8j7F...@mid.individual.net...