实验7：db2 customization

《实验7：db2 customization》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。

1、软件学院实验报告课程：数据库原理与实用技术实验学期：任课教师：专业：学号：姓名：成绩：Exercise1_DB2CustomizationSection2-CreatingaNewUserID1.UsetheUserManagerapplicationtocreateyournewuserIDcalledinst1.Section4-CreatingtheInstance1.OpenupaDB2CommandWindowandissuethefollowingcommand:db2ilistRe

2、cordtheoutput:52.Foryourlabenvironment,youwillcreateanotherinstancecalledINST1._______________3.Reissuethecommandtolistyourinstances.Nowwhichinstancesarelisted?__Section5-CreatingtheDB2SystemAdministratorGroupSection6-SettingtheEnvironment1.Performth

3、efollowingtaskstocheckyourDB2environmentvariables.WhatistheDB2INSTANCE(defaultinstance)ValueinSystemVariables?DB2ChangethesystemvariablevalueofDB2INSTANCEtoINST1.DoesthePATHvariableincludethepathofX:SQLLIBBINinitsvalue?___Yes_D:PROGRA~1IBMSQLLIB

4、BIN________________________51.DothefollowingtoverifyyourDB2environmentvariablesarecorrect.2.Checkthevaluesofyourregistryvariables(hint:usedb2setonaDB2CommandWindow).WhatisthevalueforyourDB2AdministrationServer?_______________________________________

5、_____________________4.Whatisyoursystemname?______________________________________________5Section7-ExploringandSettingDatabaseManagerConfigurationParameters54.Recordthefollowingvalues:a.DoestheAUTHENTICATIONparameterhaveavalue(lookundertheAdministra

6、tion)?Whatisthepurposeofthisparameter?Whatarethepossiblevaluesforthisparameter?____________________________________________________________b.DoestheSYSADM_GROUPparameterhaveavalue(lookunderAdministration)?Whatisthevalueofthisparameter?Whatisthehintas

7、sociatedwithit?____________________________________________________________c.WhatisthevalueofNODETYPE(lookunderEnvironment)?____________________________________________________________5