Our installer is run shell scripts with following commands:
DB2 CREATE DATABASE %DbName% ON %DbDisk% USING CODESET UTF-8 TERRITORY US
DB2 CONNECT TO %DbName% USER %DbUser% USING %DbPassword%
DB2 CREATE BUFFERPOOL BufferR2010 ALL NODES SIZE 200 PAGESIZE 8192
DB2 CREATE REGULAR TABLESPACE REMxxx PAGESIZE 8192 MANAGED BY SYSTEM USING ('C:\db2\RemXxx\') EXTENTSIZE 256 PREFETCHSIZE 32 BUFFERPOOL BufferR2010
And that works fine when DB2 Server is installed on the same compute where we installing our product.
But now we got a new life-pushed requirement - we need to create DB2 database on remote node (not on the current computer!).
Do you know - if that is possible at all?
Note: target DB2 versions are 9.x and 10.x.
Please also note: I had already tried approach described here
- it does not work. It is able to catalog node, attach node - that is works ok, but the "create database xxx" command is always creating database on local node (not on the remote/attached one). :-\