云南大学软件学院数据库实验7：DB2-Customization.doc

云南大学软件学院 实验报告Exercise 1_DB2 Customization（用户化）Section 2 - Creating a New User ID1. Use the User Manager application to create your new user ID called inst1.Answer:1） create your new user ID called inst1.（用户名：inst1全名：inst1 Instance SysAdmin描述：System Administrator for INST1 Instance密码：inst1用户组：Administrators）右击计算机，选择管理，.2） 更改inst1的账户类型在控制面板里，.将账户类型改为管理员Section 4 - Creating the Instance1. Open up a DB2 Command Window and issue the following command: db2ilist Record the output:Answer:在开始菜单里找到IBM的DB2，打开命令行工具输入db2ilist，查看主机的实例得：2. For your lab environment, you will create another instance called INST1. （创建称为 inst1 的新实例）Answer：在命令窗口中输入如下命令：1）输入db2icrt inst1，创建称为 inst1 的新实例2）查看你所创建的新实例inst1输入db2ilist后显示：3. Reissue the command to list your instances. Now which instances are listed?Answer:实例有：inst1 和DB2,Section 5 - Creating the DB2 System Administrator Group(建立DB2 系统管理员用户组)按以下要求建立DB2 系统管理员用户组adm1(adm1 应小写而且),并且使inst1 和db2admin成为该组成员组名:adm1描述:inst1 Instance SysAdmin Group可以桌面上，右击“计算机”，选择“管理”，右如下界面创建新组adm1(adm1 应小写而且),并且使inst1 和db2admin成为该组成员，同样，先建adm1再按照要求添加那2个用户，就可以了结果：Section 6 - Setting the Environment1. Perform the following tasks to check your DB2 environment variables.( 执行以下任务以检查当前 DB2 环境变量) What is the DB2INSTANCE (default instance) Value in System Variables?Answer:做如下的选择Change the system variable value of DB2INSTANCE to INST1.（系统变量中DB2INSTANCE所对应的值,默认情况下为DB2,现将其改为inst1） Does the PATH variable include the path of X:SQLLIBBIN in its value?Answer: 我查到的包含如下所示D:MATLAB701binwin32;%SystemRoot%system32;%SystemRoot%;%SystemRoot%system32wbem所以，没有包含X:SQLLIBBIN2. Do the following to verify your DB2 environment variables are correct.Answer: 选择开始菜单程序附件命令提示符;输入: set | more 注意：启动DB2-inst1和DB2DAS - DB2DAS00服务,并将其启动类型设置为自动点控制面板里的管理工具，双击服务选项，讲DB2的启动类型设为自动（有机，属性3. Check the values of your registry variables(注册变量表) (hint: use db2set on a DB2 Command Window).在DB2的命令窗口中What is the value for your DB2 Administration Server?Answer:4. What is your system name?Answer:注意：再次查看注册表变量.输入db2set all,注意在输出列表中实例级的注册表变量旁边标以“i”,全局级的注册表变量旁边标以“g”。Section 7 - Exploring and Setting Database Manager Configuration Parameters4. Record the following values:（打开控制中心，按照要求去找）a. Does the AUTHENTICATION parameter have a value (look under the Administration)? What is the purpose of this parameter? What are the possible values for this parameter?answer：目的：确定进行用户认证方式和位置为服务器其可能值为：b. Does the SYSADM_GROUP parameter have a value (look under Administration)? What is the valu