实例从os角度就是一组进程和内存.db2的实例与Oracle有很大的不同.Oracle的实例是一个实例对应一个
db,rac模式是多实例对应一个db.而在db2的世界里用户可以创建多个实例,每个实例可以包含若干个db,其中一个
实例stop了.并不影响其它实例的db.
相关命令如下:
创建实例,安装完db2之后创建实例需要root权限.执行db2icrt.在linux&unix上创建实例需要对应os用户,该用户可以叫"instance user",创建完之后会在用户目录下生成一些文件和子目录
cd /opt/ibm/db2/V9.7/instance (执行实例创建需要进入db2安装目录,这是我的db2安装目录)
[db2inst1@localhost ~]$ sudo groupadd db2_test
[db2inst1@localhost ~]$ sudo useradd -g db2_test -d db2_test
[db2inst1@localhost /]$ cd /home/
[db2inst1@localhost home]$ ls
aa db2fenc1 db2inst1 db2_test test[db2inst1@localhost home]$ cd /opt/ibm/db2/V9.7/instance/
[db2inst1@localhost instance]$ sudo ./db2icrt -u db2_test db2_test
DBI1070I Program db2icrt completed successfully.[db2inst1@localhost ~]$ sudo su - db2_test
[db2_test@localhost ~]$ ls
sqllib[db2_test@localhost ~]$ ps -ef | grep -i db2 (查看db2进程)
db2_test 12690 12687 2 11:29 pts/0 00:00:00 db2sysc 0
root 12691 12690 0 11:29 pts/0 00:00:00 db2ckpwd 0
root 12692 12690 0 11:29 pts/0 00:00:00 db2ckpwd 0
root 12693 12690 0 11:29 pts/0 00:00:00 db2ckpwd 0
db2_test 12697 12690 1 11:29 pts/0 00:00:00 db2vend (PD Vendor Process - 1)
db2_test 12702 12687 4 11:29 pts/0 00:00:00 db2acd 0 ,0,0,0,1,0,0,0000,1,0,8a6740,14,1e014,2,0,1,11fc0,0x210000000,0x210000000,1600000,168015,2,1a8018
至此实例创建完毕了.如果创建很多实例如何查看呢?使用db2ilist
[db2_test@localhost ~]$ db2ilist
db2inst1
db2_test
如果需要更加详细的信息.比如需要实例的版本、实例目录可以使用db2gerg.这里就不演示了.
实例的启停,前面出现过.这里在说一下吧.
db2start,db2stop.
如果实例停止不了.使用db2stop force
设置实例,比如我这台机器有很多实例.我想使用其中一个或者查看当前使用的哪个实例怎么办呢?
db2 get instance闪亮登场啦.
set instance=db2_test设置实例
删除实例
db2idrop (删除时别忘记停止db2喔!!!)
如何查看实例参数呢?
db2 get dbm cfg
以下是我的
[db2_test@localhost ~]$ db2 get dbm cfg
Database Manager Configuration
Node type = Enterprise Server Edition with local and remote clients
Database manager configuration release level = 0x0d00
CPU speed (millisec/instruction) (CPUSPEED) = 1.491821e-06
Communications bandwidth (MB/sec) (COMM_BANDWIDTH) = 1.000000e+02
Max number of concurrently active databases (NUMDB) = 8
Federated Database System Support (FEDERATED) = NO
Transaction processor monitor name (TP_MON_NAME) =
Default charge-back account (DFT_ACCOUNT_STR) =
Java Development Kit installation path (JDK_PATH) = /home/db2_test/sqllib/java/jdk64
Diagnostic error capture level (DIAGLEVEL) = 3
Notify Level (NOTIFYLEVEL) = 3
Diagnostic data directory path (DIAGPATH) = /home/db2_test/sqllib/db2dump/
Alternate diagnostic data directory path (ALT_DIAGPATH) =
Size of rotating db2diag & notify logs (MB) (DIAGSIZE) = 0
Default database monitor switches
Buffer pool (DFT_MON_BUFPOOL) = OFF
Lock (DFT_MON_LOCK) = OFF
Sort (DFT_MON_SORT) = OFF
Statement (DFT_MON_STMT) = OFF
Table (DFT_MON_TABLE) = OFF
Timestamp (DFT_MON_TIMESTAMP) = ON
Unit of work (DFT_MON_UOW) = OFF
Monitor health of instance and databases (HEALTH_MON) = ON
SYSADM group name (SYSADM_GROUP) = DB2_TEST
SYSCTRL group name (SYSCTRL_GROUP) =
SYSMAINT group name (SYSMAINT_GROUP) =
SYSMON group name (SYSMON_GROUP) =
Client Userid-Password Plugin (CLNT_PW_PLUGIN) =
Client Kerberos Plugin (CLNT_KRB_PLUGIN) =
Group Plugin (GROUP_PLUGIN) =
GSS Plugin for Local Authorization (LOCAL_GSSPLUGIN) =
Server Plugin Mode (SRV_PLUGIN_MODE) = UNFENCED
Server List of GSS Plugins (SRVCON_GSSPLUGIN_LIST) =
Server Userid-Password Plugin (SRVCON_PW_PLUGIN) =
Server Connection Authentication (SRVCON_AUTH) = NOT_SPECIFIED
Cluster manager (CLUSTER_MGR) =
Database manager authentication (AUTHENTICATION) = SERVER
Alternate authentication (ALTERNATE_AUTH_ENC) = NOT_SPECIFIED
Cataloging allowed without authority (CATALOG_NOAUTH) = NO
Trust all clients (TRUST_ALLCLNTS) = YES
Trusted client authentication (TRUST_CLNTAUTH) = CLIENT
Bypass federated authentication (FED_NOAUTH) = NO
Default database path (DFTDBPATH) = /home/db2_test
Database monitor heap size (4KB) (MON_HEAP_SZ) = AUTOMATIC(90)
Java Virtual Machine heap size (4KB) (JAVA_HEAP_SZ) = 2048
Audit buffer size (4KB) (AUDIT_BUF_SZ) = 0
Size of instance shared memory (4KB) (INSTANCE_MEMORY) = AUTOMATIC(94209)
Agent stack size (AGENT_STACK_SZ) = 1024
Sort heap threshold (4KB) (SHEAPTHRES) = 0
Directory cache support (DIR_CACHE) = YES
Application support layer heap size (4KB) (ASLHEAPSZ) = 15
Max requester I/O block size (bytes) (RQRIOBLK) = 32767
Workload impact by throttled utilities(UTIL_IMPACT_LIM) = 10
Priority of agents (AGENTPRI) = SYSTEM
Agent pool size (NUM_POOLAGENTS) = AUTOMATIC(100)
Initial number of agents in pool (NUM_INITAGENTS) = 0
Max number of coordinating agents (MAX_COORDAGENTS) = AUTOMATIC(200)
Max number of client connections (MAX_CONNECTIONS) = AUTOMATIC(MAX_COORDAGENTS)
Keep fenced process (KEEPFENCED) = YES
Number of pooled fenced processes (FENCED_POOL) = AUTOMATIC(MAX_COORDAGENTS)
Initial number of fenced processes (NUM_INITFENCED) = 0
Index re-creation time and redo index build (INDEXREC) = RESTART
Transaction manager database name (TM_DATABASE) = 1ST_CONN
Transaction resync interval (sec) (RESYNC_INTERVAL) = 180
SPM name (SPM_NAME) = localho1
SPM log size (SPM_LOG_FILE_SZ) = 256
SPM resync agent limit (SPM_MAX_RESYNC) = 20
SPM log path (SPM_LOG_PATH) =
TCP/IP Service name (SVCENAME) =
Discovery mode (DISCOVER) = SEARCH
Discover server instance (DISCOVER_INST) = ENABLE
SSL server keydb file (SSL_SVR_KEYDB) =
SSL server stash file (SSL_SVR_STASH) =
SSL server certificate label (SSL_SVR_LABEL) =
SSL service name (SSL_SVCENAME) =
SSL cipher specs (SSL_CIPHERSPECS) =
SSL versions (SSL_VERSIONS) =
SSL client keydb file (SSL_CLNT_KEYDB) =
SSL client stash file (SSL_CLNT_STASH) =
Maximum query degree of parallelism (MAX_QUERYDEGREE) = ANY
Enable intra-partition parallelism (INTRA_PARALLEL) = NO
Maximum Asynchronous TQs per query (FEDERATED_ASYNC) = 0
No. of int. communication buffers(4KB)(FCM_NUM_BUFFERS) = AUTOMATIC(4096)
No. of int. communication channels (FCM_NUM_CHANNELS) = AUTOMATIC(2048)
Node connection elapse time (sec) (CONN_ELAPSE) = 10
Max number of node connection retries (MAX_CONNRETRIES) = 5
Max time difference between nodes (min) (MAX_TIME_DIFF) = 60
db2start/db2stop timeout (min) (START_STOP_TIME) = 10
db2的实例先写到这里吧..das我也没写呢..我还饿着肚子呢..^_^