DB2实例管理

发表于 2012 年 4 月 9 日 由 惜分飞

联系：手机/微信(+86 17813235971) QQ(107644445)QQ咨询惜分飞

标题：DB2实例管理

作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]

1.创建新实例

[root@xifenfei ~]# cd /opt/db2/V9.5/instance/
[root@xifenfei instance]# ./db2icrt -h
DBI1001I  Usage:

 db2icrt [-h|-?]
         [-d]
         [-a AuthType]
         [-p PortName]
         [-s InstType]
         -u FencedID InstName

[root@xifenfei instance]# useradd Fence2 
[root@xifenfei instance]# passwd Fence2 
Changing password for user Fence2.
New UNIX password: 
Retype new UNIX password: 
passwd: all authentication tokens updated successfully.
[root@xifenfei instance]# useradd db2inst2
[root@xifenfei instance]# passwd db2inst2
Changing password for user db2inst2.
New UNIX password: 
Retype new UNIX password: 
passwd: all authentication tokens updated successfully.
[root@xifenfei instance]# ./db2icrt -a server -p 55555 -s ese -u Fence2 db2inst2
DBI1070I  Program db2icrt completed successfully.




[root@xifenfei instance]# su - db2inst2
[db2inst2@xifenfei ~]$ db2 get instance

 The current database manager instance is:  db2inst2

[db2inst2@xifenfei ~]$ db2ilist
db2inst1
db2inst2

[db2inst2@xifenfei ~]$ db2greg -dump
S,DB2,9.5.0.0,/opt/db2/V9.5,,,0,0,,1332659153,0
S,DAS,9.5.0.0,/opt/db2/V9.5/das,lib/libdb2dasgcf.so,,,, ,,
I,DAS,9.5.0.0,dasusr1,/home/dasusr1/das,,1,,/opt/db2/V9.5/das,,
I,DB2,9.5.0.0,db2inst1,/home/db2inst1/sqllib,,1,0,/opt/db2/V9.5,,
I,DB2,9.5.0.0,db2inst2,/home/db2inst2/sqllib,,1,0,/opt/db2/V9.5,,

2.启动关闭实例

[db2inst2@xifenfei ~]$ db2stop
03/31/2012 11:57:48     0   0   SQL1064N  DB2STOP processing was successful.
SQL1064N  DB2STOP processing was successful.
[db2inst2@xifenfei ~]$ db2start
03/31/2012 11:57:52     0   0   SQL1063N  DB2START processing was successful.
SQL1063N  DB2START processing was successful.

3.删除实例

--先需要关闭实例
[root@xifenfei instance]# ./db2idrop db2inst2
DBI1070I  Program db2idrop completed successfully.
此条目发表在 DB2 分类目录。将固定链接加入收藏夹。

《DB2实例管理》有 1 条评论

  1. 惜分飞 说：
    2012 年 4 月 9 日22:08 
    [root@xifenfei instance]# ./db2icrt -h
DBI1001I  Usage:

 db2icrt [-h|-?]
         [-d]
         [-a AuthType]
         [-p PortName]
         [-s InstType]
         -u FencedID InstName

Explanation: 

An invalid argument was entered for the db2icrt command. Valid arguments
for this command are: 

-h|-?    display the usage information.

-d       turn debug mode on.

-a AuthType
         is the authentication type (SERVER, CLIENT, or SERVER_ENCRYPT)
         for the instance.

-p PortName
         is the port name or port number to be used by this instance.

-s       InstType is the type of instance to be created (ese,wse,
         standalone, or client). 

         ese      used to create an instance for a DB2 database server
                  with local and remote clients with DPF support. This
                  type is the default instance type for DB2 Enterprise
                  Server Edition.

         wse      used to create an instance for a DB2 database server
                  with local and remote clients. This type is the
                  default instance type for DB2 Workgroup Edition, DB2
                  Express or Express-C Edition, and DB2 Connect
                  Enterprise Edition.

         standalone
                  used to create an instance for a DB2 database server
                  with local clients. This type is the default instance
                  type for DB2 Personal Edition.

         client   used to create an instance for a IBM Data Server
                  Client. This type is the default instance type for IBM
                  Data Server Client products and DB2 Connect Personal
                  Edition.

          

         DB2 products support their default instance types and the
         instance types lower than their default ones. For instance, DB2
         Enterprise Edition supports the instance types of 'ese', 'wse',
         'standalone' and 'client'.


-u FencedID
         is the name of the user under which fenced UDFs and fenced
         stored procedures will be run. This flag is not required if
         only a IBM Data Server Client is installed.

InstName is the name of the instance.

User response: 

Confirm that user IDs and group names used to create the DB2 instance
are valid. For information about naming rules, see the topic called
"User, user ID and group naming rules" in the DB2 Information Center.

Refer to the DB2 Information Center for a detailed description of the
command. Correct the syntax and reissue the command.