Image | Audio | Video |
---|---|---|
X | X | X |
Creates a DB2 extenders instance. You should create multiple instances of DB2 extenders server if you have multiple instances of DB2. On UNIX, you create a client instance when you install the DB2 extenders client; creating the client instance sets up your environment for using the DB2 extenders.
Authorization
SYSADM
On UNIX, you must have root authority.
Command syntax
In a non-partitioned database environment:
>>- DMBICRT--+--------------+---instanceName------------------->< '- -s--client--'
In a partitioned database environment in UNIX:
>>- DMBICRT--+--------------+---instanceName---- -q:--dataPath-->< '- -s--client--'
In a partitioned database environment in Windows:
>>- DMBICRT--instanceName---------------------------------------> >----- -q:--dataPath-- -r:--start_port--,--end_port------------><
Command parameters
Examples
Create an instance of DB2 extenders server for the DB2 instance DEVINST in a non-partitioned database environment:
dmbicrt devinst
Usage notes
The DMBICRT command creates a DB2 extender instance directory for the files used by the instance. This directory is named:
If a DB2 instance with the name specified does not exist when you use the DMBICRT command, you are prompted to create it.
EEE Only:
Although you can run DMBICRT from the root user ID of any participating node, it is recommended that you create all DB2 extenders server instances using the same node. The node should be the same one used to create the DB2 instance and where the DB2 instance directory resides. If you use a different node to create the DB2 extenders server instance, the list of instances stored on any node may not be complete.
The shared directory or file system specified as dataPath is
saved as the value of the DB2MMDATAPATH environment variable in
$INSTHOME/dmb/dmbprofile in UNIX and in Windows in the
registry key:
\\HKEY_LOCAL_MACHINE\SOFTWARE\IBM\DB2 Extenders\PROFILES
\instance_name\DB2MMDATAPATH
On UNIX, you must have the port range added to the /etc/services file before creating the instance. Add two entries to the file using the following syntax:
The range must be large enough for all the nodes in the partitioned database environment.
You must create the DB2 instance before creating an instance of DB2 extenders server.
To create a Text Extender instance in a partitioned database environment, use the TXTICRT command, as described in DB2 Universal Database Text Extender Administration and Programming.