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

吉林大学DB2实验报告班级： 14级9班 姓名：郭世鑫学号名郭世鑫学验项目2. Creating databases and data placement实验性质□演示性实验 □验证性实验 操作性实验 □综合性实验实验地点A110机器编号06指导教师康辉实验时间年 月 日 时 分一、实验综述1. 实验目的及要求During this lab, you will create your database and your table spaces. Also in this lab, you will select information on table spaces from the system catalog (SYSCAT) views.At the end of the lab, students should be able to: ? Create a database ? Create a table space ? Execute a script file to create multiple table spaces ? Access the SYSCAT views containing table space information ? List table space information ? List container information 2. 实验设备、软件PC,?windows?XP Professional,?DB2?9?Express-c二、实验过程（实验步骤、记录、数据、分析）Section 1 - Creating the Database 1. Creating a database can be done with the DB2 command create database. Use the online help facility to display the DB2 command syntax for create database. Show your work below by printing screen.2. What information can you specify on the create database command? The name of the database, the location of the database, an alias name,, the codeset and territory for storing the data, a collating sequence, a default extent size, automatic storage, and table space information can be specified on the create database command. 3. Based on what you learned in lecture, what table spaces are created when a database is created? SYSCATSPACE,USERSPACE1,and TEMPSPACE14. What type of table space, SMS or DMS, will your database use by default for these default table spaces? —————————————————————————————————DMS table spaces for SYSCATSPACE and USERPACE1,and SMS for TEMSPACE1.Note that in DB2 UDB V8.2 and earlier the default table spaces are SMS.5. Before we create our MUSICDB database, remember what you learned in lecture about what some of the defaults will be. ?What is the default path that the database will be created on? ?What will be the default table space type (SMS or DMS) for the table spaces that will be created to house User Tables, Catalog Tables, and Tempor