吉林大学--DB2实验报告1.docxVIP

吉林大学DB2实验报告班级： 九班 姓名：郭世鑫学号名郭世鑫学验项目1. DB2 customization实验性质□演示性实验 □验证性实验 操作性实验 □综合性实验实验地点计算机楼A108机器编号06指导教师康辉实验时间年 月 日 时 分一、实验综述1. 实验目的及要求This exercise will let you explore the CLP and DB2 GUIs, making you familiar with them using the DB2 default instance - DB2 - and the SAMPLE database.At the end of the lab, students should be able to: ? Use the CLP ? Use the different GUIs ? Know the possibilities of the CLP and the GUIs2. 实验设备、软件PC,?windows?XP Professional,?DB2?9?Express-c二、实验过程（实验步骤、记录、数据、分析）Section 1 - Exploring the CLP usage1. If using a Windows system, and you are not already logged on, log on now using the DB2 Administrator name. Use your Windows username and Windows password.2. First, try to get general information about commands that can be used in the CLP.Show your work below by printing screen.3. Now examine what can be done with the get command.Show your work below by printing screen.4. Next let’s assume you receive an SQLSTATE=08003. How you can determine what this sqlstate means? Execute the correct command and explain the meaning.5. Next let’s examine the options set for your CLP session. Issue the correct command and determine which options are set to on.6. Next let’s create a script with the name myscript, which connects to the sample database, selects the columns empno and lastname from the table employee and lists the database manager configuration.Show your work below by printing screen.7. Now execute the created script using your CLP session and echo the current command.Show your work below by printing screen.8. As there is a lot of information returned from the select statement and the database manager configuration, it might be helpful to store the information in a file called myout to be able to examine it step by step. Execute the script again and save the output in a file named myout.Show your work below by printing screen.Section 2 - Looking at Release Notes1. Look at the files located in the Readme subdirectory. They a