db2 customization试验报告.docx

1、db2 customization试验报告学 生 实 验 报 告学 院： 课程名称： 现代数据库技术 专业班级： B01 姓 名： 学 号： 学生实验报告学生姓名学号同组人：无实验项目DB2 Customization必修 选修 演示性实验 验证性实验 操作性实验 综合性实验实验地点H121实验仪器台号 指导教师实验日期及节次2009-3-4 9、A节一、实验综述1、实验目的及要求During this lab you will create a DB2 System Administrator userid, and use it to customize your DB2 system a

2、nd instance.At the end of the lab, students should be able to: Create a DB2 system administrator user name Create an instance Create a DB2 system administrator group Set system environment variables Update necessary Database Manager Configuration parameters2、实验仪器、设备或软件A computer, windows XP, DB2 9 E

3、xpress-c二、实验过程（实验步骤、记录、数据、分析）Section 0 Set the System Date, Time and Time Zone_ 1. Change the Windows System Date, Time and Time Zone settings._ Select Start button in the lower left corner of your screen._ Choose Settings - Control Panel. Open the Date/Time Properties window._ Select Time Zone tab.

4、_ Select the drop-down arrow near the top of the window to get a list of all time zones._ Select the time zone corresponding to the local time zone._ Verify that there is a check in the box adjacent to Automatically adjust clock for daylight saving changes._ Select Date & Time tab._ Set the Date._ S

5、et the Time._ Check your settings._ Click Apply._ Click OK._ Leave the Control Panel up for the next task.Section 1 Creating a New User ID_ 1. Use the User Manager application to create your new user ID called inst1. You should make inst1 a member of the local group named Administrators. This will m

6、ake the user ID a Windows administrator. Inst1s password should be ibm4es._Section 2 Log in using your DB2 System dministrator User ID_ 1. Issue the following commands to log off the userid admin that you are currently logged onto, and log on as your newly created Administrator userid of inst1. For

7、the remainder of all labs, when asked to log on, log on as inst1 unless thedirections specify differently.Select Start - Shut Down.Select Log off admin.Click OK.Enter inst1 as the User name.Enter ibm4es as the password.Click OK.Uncheck “Show this screen at startup” option and click Exit on theGettin

8、g Started with Windows 2000 window.Section 3 Creating the Instance_ 1. When DB2 for Windows is installed, a default instance is created called DB2. To verify the DB2 instances existence, open up a DB2 Command Window and issue the following command: db2ilistRecord the output:_2. For your lab environm

9、ent, you will create another instance called inst1. Issue the command to do so._3. Reissue the command to list your instances. Now which instances are listed?_4. Exit your DB2 Command Window._Section 4 Creating the DB2 System Administrator Group_ 1. Create your database system administrator group ca

10、lled adm1. Make the user ID inst1 a member of the adm1 group. Also include the user ID of db2admin as a member of your adm1 group. IMPORTANT: be consistent and use lower case for adm1._Section 5 Setting the Environment_ 1. Perform the following tasks to check your DB2 environment variables, set your

11、 default instance to the one you just created (inst1)._ a. Open the Control Panel if it is not already open._ b. From the Control Panel, select System._ c. On the System Properties window, select the Advanced tab._ d. Click the Environment Variables button._ e. There are two panes of data: the top i

12、s User variables for inst1 and the bottom is System variables. System variables impact every user; User variables only impact the current user._ f. What is the DB2INSTANCE (default instance) Value in System variables?_db2admin_ g. Change the system variable value of DB2INSTANCE to inst1._ h. Does th

13、e PATH variable include the path of X:SQLLIBBIN in its value?_ i. Use the Control Panel / Administrative Tools / Services icon to start the inst1instance service and the DB2DAS service automatically._ 2. Do the following to verify your DB2INSTANCE environment variable is set correctly. If it is not

14、properly set, repeat the steps necessary to correct the values.Select Start - Programs - Accessories - Command Prompt.Enter the following command:set | moreDB2INSTANCE should be set to a value of inst1.Exit the Command Prompt window._ 3. Check the values of your registry variables (hint: use the db2

15、set command from a DB2 Command Window).What is the value for your DB2 Administration Server (DAS)?_ 4. What is your system name?_db2admin_ 5. Set the DB2COMM variable in your DB2 Registry at the instance and global levels, indicating that you support TCP/IP communications to your instance._db2set db

16、2comm=tcpip I inst 1 db2set db2comm=tcpip-g_ 6. Check the values of your registry variables again. Look at the difference between how the setting of DB2COMM is shown for your instance versus how it is shown for the Administration server. Summarize how you can tell what level applies to each of the r

17、egistry variable settings._ 7. Reboot your system.Section 6 Exploring & Setting Database ManagerConfiguration ParametersUse your DB2 Control Center to view and set DBM CFG parameter values._ 1. Start your Control Center by doing the following:Select Start - Programs - IBM DB2 - General Administratio

18、n Tools -Control Center._ 2. Select OK to use the Advanced Control Center View._ 3. Select the + sign next to the All Systems folder. Select the + sign next to yourmachine name. For simplicity, in this lab document, it is referred to as CF2xnn._ 4. Select the + sign next to the Instances folder.If I

19、NST1 is not listed as an instance, then do the following:Right-click Instances, and select Add from the pop-up menu.Enter INST1 for the Instance name and for the Instance node name.Click Apply.Click Cancel._ 5. View your database manager configuration file._ 6. Record the following values:_ a. Does

20、the AUTHENTICATION parameter have a value (look under the Administration keyword)? What is the purpose of this parameter? What are the possible values for this parameter?_no_db2_b. Does the SYSADM_GROUP parameter have a value (look underAdministration)? What is the value of this parameter? What is t

21、he hint associated with it?_c. What is the value of NODETYPE (look under Environment)?7. Update the SYSADM_GROUP parameter and set the value to adm1._ 8. To put your change in effect, stop and start your INST1 instance service._ 9. If you received an SQL5043N message, then support for one or more co

22、mmunications protocols failed to start successfully, however, core databasemanager functionality started successfully. Close the message. Earlier in this exercise, you set the DB2COMM registry variable to a value of TCPIP.When the instance started this time, DB2 tried to start that communications pr

23、otocol, but did not find a services port to use. The SVCENAME parameter in the database manager configuration file needs to be set to a port number or a services file entry name, to indicate a port for incoming TCP/IP clients to use._ 10. Update the TCP/IP service name (SVCENAME) parameter and set t

24、he value to 55000._ 11. Stop and start the instance._ 12. An alternate method for setting up communications can be found using the Setup Communications option of the instance. Verify your TCP/IP communications parameters through that facility._13. You have now completed this lab exercise. Close all open windows on your desktop.三、结论1、实验结果2、分析讨论四、指导教师评语及成绩：评语： 成绩： 指导教师签名： 批阅日期：3月7日