backup for Maxdb fails -Errorcode 3700 "hostfile_error"

[Former Member]

Hi all,

I am trying to take an online backup on disk for content server on Maxdb 7.6 but it fails with the error Errorcode 3700 "hostfile_error".

Can anyone help?

1. Defined a backup template in

./dbmcli on ADB>medium_put ADBcompleteDataBackup \"/tmp/backup" FILE DATA 0 6 NO

OK

2. Start Backup

./dbmcli on ADB>backup_start ADBcompleteDataBackup

ERR

-24988,ERR_SQL: Sql error

-903,Host file I/O error,Could not open volume

3,Data backup failed

17,Servertask Info: because Error in backup task occured

10,Job 1 (Backup / Restore Medium Task) [executing] WaitingT172 Result=3700

6,Error in backup task occured, Errorcode 3700 "hostfile_error"

Thanks,

Murali

[Former Member]

Hi Melanie,

thanks for the quickee.

Do I need to create a file "backup" under /tmp?

the knldiag gives the below error

Backup - Error in backup task occured, Errorcode 3700 "hostfile_error"

2007-06-07 17:13:57 38 ERR 11000 d0_aopen Cannot open device, No such file or directory

2007-06-07 17:13:57 38 ERR 11000 d0_aopen Device name '\"/tmp/backup"'

Thanks,

Murali

[henrik_hempelmann]

Murali,

\"/tmp/backup" is an invalid volume name - have a look at your declaration:

./dbmcli on ADB>medium_put ADBcompleteDataBackup \"/tmp/backup" FILE DATA 0 6 NO

the '\' escapes the double quote, so you have unbalanced quotes in the medium definition.

You can simply ignore any quotes here:

medium_put ADBcompleteDataBackup /tmp/backup FILE DATA 0 6 NO

Henrik

[Former Member]

Hi Henrick,

I gave the following but the problem still exists.

$ ./dbmcli -d ADB -u superdba,Dms01288

./dbmcli on ADB>db_connect

OK

---

./dbmcli on ADB>medium_put ADBcompleteDataBackup /tmp/backup FILE DATA 0 6 NO

OK

---

./dbmcli on ADB>backup_start ADBcompleteDataBackup

ERR

-24988,ERR_SQL: Sql error

-903,Host file I/O error,No more devices

3,Data backup failed

17,Servertask Info: because Error in backup task occured

10,Job 1 (Backup / Restore Medium Task) [executing] WaitingT191 Result=3700

6,Error in backup task occured, Errorcode 3700 "hostfile_error"

---

thanks,

Murali

[henrik_hempelmann]

OK,

fine

the error changed from '-903,Host file I/O error,Could not open volume'

to '-903,Host file I/O error,No more devices'

due to the number of failures it seems you ran out of internal device descriptors.

How many backup devices (parameter: MAXBACKUPDEVS) are configured in your system?

Anyway, you have to restart the database to fix the problem. There is no way to dynamically increase the number of device descriptors.

Henrik

[Melanie]

Hello Murali,

please check file knldiag for a more detailed error message concerning which file could not be opened.

Is /tmp/backup a directory? You have to specify a file name there.

Best regards,

Melanie