DB2 FOR LUW / DB2FORLUW / A50 - DB2

When we use $[number]N partition expression for storage path in 
a create tablespace statement, we will get SQL0294N as follows: 
 
$ db2 "CREATE TABLESPACE TS1 MANAGED BY DATABASE 
> USING (FILE '/home/db2inst1/filepath/NODE \$4N' 4096) ON 
DBPARTITIONNUM (0 to 2)" 
DB21034E  The command was processed as an SQL statement because 
it was not a 
valid Command Line Processor command.  During SQL processing it 
returned: 
SQL0294N  The container is already in use.  SQLSTATE=42730 
 
This APAR will resolve the above observed issue.

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* See SYSROUTE APARs to see where this APAR is addressed       * 
****************************************************************

use $N instead of $[number]N. 
 
$ db2 "CREATE TABLESPACE TS1 MANAGED BY DATABASE 
> USING (FILE '/home/db2inst1/filepath/NODE000 \$N' 4096) ON 
DBPARTITIONNUM (0 to 2)" 
DB20000I  The SQL command completed successfully.

keiner bekannt / siehe Local-Fix

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

20.08.2014
09.05.2017
09.05.2017