db2Backup API and DB2BACKUP_INCLUDE_LOGS

[chandra.krothapalli]

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

[Bernard Dhooghe]

On Sep 27, 6:13 pm, [e-mail] wrote:

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

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