实验7：DB2 Customization.doc

软件学院 实验报告
课程： 数据库原理与实用技术实验 学期： 任课教师：
专业： 学号： 姓名： 成绩：
Exercise 1_DB2 Customization
Section 2 - Creating a New User ID
1. Use the User Manager application to create your new user ID called inst1.

Section 4 - Creating the Instance
1. 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 Environment
1. 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:\SQLLIB\BIN in its value?
___Yes_ D:\PROGRA~1\IBM\SQLLIB\BIN ________________________
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 Parameters

4. 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