DB2 FOR LUW / DB2FORLUW / 970 - DB2

db2dart fails with 
Error: Failed sqledosd API on open local database directory 
C:\Program\DB2_01. 
 
SQL1031N  The database directory cannot be found on the 
indicated file system. 
on Windows and Linux when you use a dbpath that contains blanks. 
eg. C:\Program Files\DB2_01 would be truncated to 
C:\Program\DB2_01

**************************************************************** 
* USERS AFFECTED:                                              * 
* All                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.7 Fix Pack 9.                       * 
****************************************************************

A workaround could be to use Windows generation of 
MS-DOS-compatible 
file name in 8.3 format. 
 
e.g. use 
 
db2 "create db test on 'C:\Progra~1\DB2_01'" 
 
instead of 
 
db2 "create db test on 'C:\Program Files\DB2_01"

DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
 

First fixed in DB2 Version 9.7 Fix Pack 9.

not known / see Local fix

forerunner  : APAR is sysrouted TO one or more of the following: IC91670 IC95266 
follow-up : 

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

19.04.2013
17.12.2013
17.12.2013

9.7.FP9