实验7：DB2 Customization.doc

软件学院 实验报告课程： 数据库原理与实用技术实验 学期： 任课教师： 专业： 学号： 姓名： 成绩： Exercise 1_DB2 CustomizationSection 2 - Creating a New User ID1. Use the User Manager application to create your new user ID called inst1. Section 4 - Creating the Instance1. Open up a DB2 Command Window and issue the following command: db2ilist Record the output: 2. For your lab environment, you will create another instance called INST1. _ 3. Reissue the command to list your instances. Now which instances are listed?_ Section 5 - Creating the DB2 System Administrator Group Section 6 - Setting the Environment1. Perform the following tasks to check your DB2 environment variables. What is the DB2INSTANCE (default instance) Value in System Variables? DB2 Change the system variable value of DB2INSTANCE to INST1. Does the PATH variable include the path of X:SQLLIBBIN in its value?_Yes_ D:PROGRA1IBMSQLLIBBIN _2. Do the following to verify your DB2 environment variables are correct. 3. Check the values of your registry variables (hint: use db2set on a DB2 Command Window). What is the value for your DB2 Administration Server?_4. What is your system name?_ _ _ _ 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?_b. Does the SYSADM_GROUP parameter have a value (look under Administration)? What is the value of this parameter? What is the hint