Oracle/DB2/Postgresql/Mysql/Hadoop/Greenplum/Postgres-xl/Mongodb
分类: DB2/Informix
2012-04-18 05:33:11
Creates DB2® instances.
On Linux and UNIX operating systems, this utility is located in the DB2DIR/instance directory, where DB2DIR represents the installation location where the current version of the DB2 database system is installed. On Windows operating systems, this utility is located under the DB2PATH\bin directory where DB2PATH is the location where the DB2 copy is installed.
The db2icrt command creates DB2 instances in the instance owner's home directory.
Root user authority on Linux and UNIX operating systems or Local Administrator authority on Windows operating systems.
For Linux and UNIX operating systems
>>-db2icrt--+-----+--+-----+--+---------------+-----------------> +- -h-+ '- -d-' '- -a--AuthType-' '- -?-' >--+---------------+--+---------------+--+---------------+------> '- -p--PortName-' '- -s--InstType-' '- -u--FencedID-' >--InstName----------------------------------------------------><For Windows operating systems
>>-db2icrt--InstName--+---------------+-------------------------> '- -s--InstType-' >--+-------------------------+--+-------------------+-----------> '- -u--UserName, Password-' '- -p--InstProfPath-' >--+---------------+--+----------------+------------------------> '- -h--HostName-' '- -r--PortRange-' >--+------------------------------------------------------+-----> '- -j--"TEXT_SEARCH-+--------------+-+-------------+-"-' '-,servicename-' '-,portnumber-' >--+-----+----------------------------------------------------->< '- -?-'For Linux and UNIX operating systems
-h | -? Displays the usage information. -d Turns debug mode on. Use this option only when instructed by DB2 database support. -a AuthType Specifies the authentication type (SERVER, CLIENT or SERVER_ENCRYPT) for the instance. The default is SERVER. -p PortName Specifies the port name or number used by the instance. This option does not apply to client instances. -s InstType Specifies the type of instance to create. Use the -s option only when you are creating an instance other than the default associated with the installed product from which you are running db2icrt. Valid values are: client Used to create an instance for a client. This is the default instance type for IBM® Data Server Client,IBM Data Server Runtime Client, and DB2 Connect™ Personal Edition. standalone Used to create an instance for a database server with local clients. It is the default instance type for DB2 Personal Edition. ese Used to create an instance for a database server with local and remote clients with partitioned database environment support. This is the default instance type for DB2 Enterprise Server Edition or DB2 Advanced Enterprise Server Edition. wse Used to create an instance for a database server with local and remote clients. This is the default instance type for DB2 Workgroup Server Edition, DB2 Express® Edition or DB2 Express-C, and DB2 Connect Enterprise Edition.DB2 database products support their default instance types and the instance types lower than their default ones. For instance, DB2 Enterprise Server Edition supports the instance types of ese, wse, standalone and client.
-u Fenced ID Specifies the name of the user ID under which fenced user-defined functions and fenced stored procedures will run. The -u option is required if you are not creating a client instance. InstName Specifies the name of the instance which is also the name of an existing user in the operating system. This has to be the last argument of the db2icrt command.For Windows operating systems
InstName Specifies the name of the instance. -s InstType Specifies the type of instance to create. Currently, there are four kinds of DB2 instance types. Valid values are: client Used to create an instance for a client. This is the default instance type for IBM Data Server Client, IBM Data Server Runtime Client, and DB2 Connect Personal Edition. standalone Used to create an instance for a database server with local clients. It is the default instance type for DB2 Personal Edition. ese Used to create an instance for a database server with local and remote clients with partitioned database environment support. The -s ese -u Username, Passwordoptions have to be used with db2icrt to create the ESE instance type and a partitioned database environment instance. wse Used to create an instance for a database server with local and remote clients. This is the default instance type for DB2 Workgroup Server Edition, DB2 Express Edition or DB2 Express-C, and DB2 Connect Enterprise Edition.DB2 database products support their default instance types and the instance types lower than their default ones. For instance, DB2 Enterprise Server Edition supports the instance types of ese, wse, standalone and client.
-u Username, Password Specifies the account name and password for the DB2 service. This option is required when creating a partitioned database instance. -p InstProfPath Specifies the instance profile path. -h HostName Overrides the default TCP/IP host name if there is more than one for the current machine. The TCP/IP host name is used when creating the default database partition (database partition 0). This option is only valid for partitioned database instances. -r PortRange Specifies a range of TCP/IP ports to be used by the partitioned database instance when running in MPP mode. For example, -r 50000,50007. The services file of the local machine will be updated with the following entries if this option is specified:DB2_InstName baseport/tcp DB2_InstName_END endport/tcp /j "TEXT_SEARCH" Configures the DB2 Text Search server using generated default values for service name and TCP/IP port number. This parameter cannot be used if the instance type is client. /j "TEXT_SEARCH, servicename"Configures the DB2 Text Search server using the provided service name and an automatically generated port number. If the service name has a port number assigned in the services file, it uses the assigned port number.
/j "TEXT_SEARCH, servicename, portnumber"Configures the DB2 Text Search server using the provided service name and port number.
/j "TEXT_SEARCH, portnumber"Configures the DB2 Text Search server using a default service name and the provided port number. Valid port numbers must be within the 1024 - 65535 range.
-? Displays usage information.On AIX 6.1 (or higher), when running this command from a shared DB2 copy in a system workload partition (WPAR) global environment, this command must be run as the root user.