By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,924 Members | 1,727 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,924 IT Pros & Developers. It's quick & easy.

db2Backup API and DB2BACKUP_INCLUDE_LOGS

P: n/a
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

Sep 27 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On Sep 27, 6:13 pm, chandra.krothapa...@gmail.com 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

Oct 8 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.