资源预览内容
第1页 / 共5页
第2页 / 共5页
第3页 / 共5页
第4页 / 共5页
第5页 / 共5页
亲,该文档总共5页全部预览完了,如果喜欢就下载吧!
资源描述
软件学院 实验报告课程: 数据库原理与实用技术实验 学期: 任课教师: 专业: 学号: 姓名: 成绩: 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 associated with it?_c. What is the value of NODETYPE (look under Environment)?_5
收藏 下载该资源
网站客服QQ:2055934822
金锄头文库版权所有
经营许可证:蜀ICP备13022795号 | 川公网安备 51140202000112号