Hi,

I am tring to use db2Backup Api to make backups. If the backup I am
doing is ONLINE, as part of backup image I want include required log
files.

So I used the parameter iOptions as shown below.

/* Set minimum options for the backup */
backupStruct.iOptions = DB2BACKUP_ONLINE | DB2BACKUP_DB |
DB2BACKUP_INCLUDE_LOGS | DB2BACKUP_COMPRESS;

/* Backup the database */
db2Backup(db2Version810, &backupStruct, &sqlca);

When I do this I am getting "SQL2032N The "iOptions" parameter is not
valid." error messsage.

But If I take out the "DB2BACKUP_INCLUDE_LOGS ", every thing works
fine.

The db2 version I am using is 8.2.

DB2 code release "SQL08026" with level identifier "03070106".
"DB2 v8.1.0.120", "s060801", "MI00165", and FixPak"13".

Could some one please tell me what I am doing incorrectly.


Chandra

chandra.krothapalli (AT) gmail (DOT) com wrote:

Are you backing up a partitioned database (DPF) ? Include logs is not
compatible with DPF.

On Sep 27, 12:32 pm, Ian <ianb... (AT) mobileaudio (DOT) com> wrote:
Thanks for the quick reply. The database is not a partioned database.

On Sep 27, 6:13 pm, chandra.krothapa... (AT) gmail (DOT) com wrote:
Confirm the error on:

DB21085I Instance "db2inst1" uses "32" bits and DB2 code release
"SQL08024"
with level identifier "03050106".
Informational tokens are "DB2 v8.1.1.104", "s060120", "U805924", and
FixPak
"11".
Product is installed at "/usr/opt/db2_08_01".

and

DB21085I Instance "db2inst2" uses "64" bits and DB2 code release
"SQL09012"
with level identifier "03010107".
Informational tokens are "DB2 v9.5.0.0", "s070524", "AIX64", and Fix
Pack "0".
Product is installed at "/usr/opt/db2_09_05".

Maybe there is somewhere an include definition error?

Bernard Dhooghe