Hi all, in windows machine ,i have db2 with following details .
C:\Documents and Settings\icmadmin>db2level
DB21085I Instance "DB2" uses "32" bits and DB2 code release "SQL08026" with
level identifier "03070106".
Informational tokens are "DB2 v126.96.36.199", "s060801", "WR21371", and FixPak
Product is installed at "D:\IBM\SQLLIB".
After taking backup , i am getting backup in following folder format
This is an expected behavior for db2 8 on Windows: Backup overview: Note: DB2 Universal Database™, Version 8.2.2 and earlier versions used a four-level subdirectory tree when storing backup images on Windows operating systems:
This directory structure is recognizable by the RESTORE utility of newer db2 versions.
Version 8.x does NOT support long names, because v8.x was still supported on Windows that had file name limitation 8-3 (eight for file name and three for file extension). So in this case it was not possible to store all of the info in file name, so directory structure was used. In DB2 v8.x it is not possible to execute backup command and to get new long-file-name. You can create a backup on 8.x and restore on newer database version. Just use: db2 restore database from c:\backup
if there is only single backup image (plus directory structure) in it.