DB2 Windows Backups

A DB2 IMPORT based backup can be taken from the QAD Data Warehouse Designer tool by selecting the Backup/Export the metadata (DB2 export) menu option. This option assumes that the IBM DB2 EXPORT command is available on the PC.

When executed this menu option attempts to locate the SQL Server bcp utility. This utility is normally called 'bcp' and resides in the SQL Server bin directory. If QAD Data Warehouse Designer cannot locate this utility or it has not been loaded onto the PC then the export does not proceed and an error message will be displayed.

A pop-up window asks for a directory name for the export. A directory should be chosen or created. When the save button is clicked the export will start. The following files are created. A dialog box appears to show the results of the backup.

File name	Purpose
Data Warehouse Designer.bat	Windows batch file used to run the DB2 EXPORT for each metadata table.
Data Warehouse Designer.cmd	Control file for the export. Contains an entry for each meta table to be exported.
Data Warehouse Designer.log	Log file of the EXPORT.
Data Warehouse Designer.pro	A file containing each procedure stored in the metadata.
*.ixf	Each metadata table is stored in a file with a ixf extension. This is the export of each table.
restore.drp	Command file for dropping all metadata tables. (Used in the restore prior to a reload).
restore.lst	Basis of the command file that will be used to restore the metadata. This file is modified to include the target directory prior to restore.

If problems are encountered with the backup it may be possible to manually run the generated Data Warehouse Designer.bat script file to ascertain what has gone wrong.

QAD Data Warehouse Designer metadata can be restored from a prior backup. For Oracle data warehouses the restore can take place either from UNIX or through the QAD Data Warehouse Designer tool. The same set of files as defined in the backup section are used for both restores and can be moved between the Windows and UNIX environments. For SQL Server data warehouses the restore must take place in a Windows environment either through the QAD Data Warehouse Designer tool or manually.

Note: If transferring the export files via ftp, ensure that the file.exp and .bcp files are transferred in binary mode and that the other files are transferred in ASCII mode.