Resolving problems with the BACKUP DB and the RESTORE DB commands

Edit online

The server BACKUP DB and RESTORE DB commands request the IBM Db2 database application to back up the IBM Storage Protect database to the server.

Backup data is then sent to the server through the client application programming interface (API).

When a BACKUP DB or RESTORE DB command fails with a Db2 SQLCODE or a SQLERRMC message with return codes, get a description of the Db2 SQLCODE by completing the following procedures:

Open a Db2 command-line interface:
- For Windows, click Start > All Programs > IBM Db2 and click Command Line Tools > Command Line Processor.
- For all other supported platforms, log on to the Db2 instance ID and open a shell window, then issue the command DB2.
Enter the SQLCODE. For example, if the Db2 SQLCODE is -2033, issue the following command:
```
? sql2033
```

You can use the details of the error condition to debug the problem with the BACKUP DB or RESTORE DB command. If the SQLERRMC code is also displayed, it is explained in the SQLCODE description that you are provided. You can find more information about the API return codes through the following files:

tsm\api\include\dsmrc.h
tsm/client/api/bin64/sample/dsmrc.h