linux下创建DB2 DAS实例.docx

创建DAS Instance首先创建对应实例的用户和组(dasusr1,dasadm1)rootalandb2 # groupadd dasadm1rootalandb2 # mkdir -p /home/dasusr1rootalandb2 # useradd -d /home/dasusr1 -g dasadm1 dasusr1rootalandb2 # passwd dasusr1Changing password for user dasusr1.New UNIX password: BAD PASSWORD: it is based on a dictionary wordRetype new UNIX password: 创建DAS Instance,需要利用到DB2DIR/Instance下面的dascrt命令(Windows平台，我们需要用db2admin create命令来创建)：rootalandb2 instance# pwd/opt/ibm/db2/V9.5/instancerootalandb2 instance# ./dascrtDBI1025I Usage: dascrt -d -u ASUserExplanation: An invalid argument was entered for the dascrt command. Valid argumentsfor this command are: -d enters debug mode, for use with DB2 Service-u ASUser is the user the DAS will run underUser response: For more information about this command, please refer to theQuickBeginnings manual. Enter the command again as follows: dascrt -u ASUserConfirm that user IDs and group names used to create the DB2 instanceare valid. For information about naming rules, see the topic calledUser, user ID and group naming rules in the DB2 Information Center.我们来运行dascrt命令来创建名为dasusr1的DAS Instancerootalandb2 instance# ./dascrt -u dasusr1SQL4406W The DB2 Administration Server was started successfully.DBI1070I Program dascrt completed successfully.创建完成后，我们可以看到dasusr1主目录下的Instance文件已经建好。dasusr1alandb2 $ pwd/home/dasusr1dasusr1alandb2 $ lsdasdasusr1alandb2 $ cd dasdasusr1alandb2 das$ lsadm conv dasprofile java metadata usercshrcbin ctrl dump lib msg userprofilecfg dascshrc function log tmp我们可以通过db2admin start或db2admin stop命令来起停DAS Instancedasusr1alandb2 das$ which db2admin/das/bin/db2admindasusr1alandb2 das$ db2admindasusr1dasusr1alandb2 das$ db2admin stopSQL4407W The DB2 Administration Server was stopped successfully.dasusr1alandb2 das$ db2admin startSQL4406W The DB2 Administration Server was started successfully.如果我们的DB2数据库服务器版本升级，我们可以通过运行DB2DIR/instance/dasupdt的命令，对DAS Instance进行升级。我们还可以通过dasdrop命令来删除DAS Instance:rootalandb2 instance# pwd/opt/ibm/db2/V9.5/instancerootalandb2 instance# ./dasdropSQL4407W The DB2 Administration Server was stopped successfully.DBI1070I Program dasdrop completed successfully.删除完成后，对应的实例目录也就不存在了:rootalandb2 instance# su - dasusr1dasusr1alandb2 $ lsdasusr1alandb2 $ 最后需要说明的是，我们还可以通过db2 get/update/reset admin cfg 命令来查询并管理配置DAS Instance，前提是DAS Instance需要创建并存在.附：DAS维护命令DB2DIR/instance/dasauto - 自动启动DB2管理服务器DB2DIR/instance/dascrt - 创建DB2服务管理器D