DB2基础管理实践指南：Linux与Windows版

需积分: 13 47 浏览量更新于2024-07-18 收藏 1.11MB PDF 举报

身份认证购VIP最低享 7 折!

领优惠券(最高得80元）

"DB2管理练习手册，英文版，包含了DB2基础管理的练习题和答案，适用于Linux和Windows环境" DB2是IBM公司推出的一款关系型数据库管理系统（RDBMS），广泛应用于企业级数据存储和管理。这本DB2管理练习手册主要针对DB2 10 for Linux, UNIX, and Windows (LUW)版本，提供了基本的管理实践题目和解答，旨在帮助用户提升在这些操作系统上的DB2管理技能。手册中的内容可能包括以下几个方面： 1. **安装与配置**：介绍如何在Linux和Windows环境下安装DB2，设置环境变量，配置数据库实例，以及进行初始的数据库创建和配置。 2. **数据库管理**：讲解如何创建、修改和删除数据库，包括空间管理、日志管理、备份与恢复策略等。 3. **安全性管理**：涉及用户权限设置、角色管理、访问控制列表（ACL）配置，以及如何实现数据库的安全审计。 4. **性能优化**：涵盖SQL查询优化、索引设计、内存调优、数据库监控工具的使用，以提高系统性能。 5. **故障诊断与恢复**：介绍错误日志分析、故障排查步骤，以及如何进行数据恢复操作。 6. **备份与恢复**：讲解完整备份、增量备份、差异备份的不同策略，以及如何利用DB2的备份工具执行备份和恢复任务。 7. **复制服务**：介绍DB2的复制技术，如Q Replication和PureScale，用于数据同步和灾难恢复。 8. **高可用性与灾难恢复**：包括集群配置、故障切换机制、以及DR（灾难恢复）计划的制定。 9. **Instructor Exercises Guide with Exercise Solutions**：这部分可能包含指导性的练习题目，涵盖上述各个主题，并提供了解答，有助于读者巩固所学知识。值得注意的是，尽管手册中的信息可能已经过IBM的内部审查，但不提供任何正式的保证或承诺。每个组织在尝试应用这些技术和解决方案时，需要根据自身的环境和需求进行评估和适应，IBM对此结果不承担任何责任。此外，手册可能包含对美国政府用户的特定使用条款，如受限权利的文档。通过这本DB2管理练习手册，学习者不仅可以理论联系实际，增强DB2管理能力，还能为实际工作中的问题解决和性能优化打下坚实的基础。

资源详情

资源推荐

Instructor Exercises Guide with Exercise Solutions with hints

Course materials may not be reproduced in whole or in part

without the prior written permission of IBM.

1-4 DB2 10 for LUW: Basic Admin for Linux and Windows © Copyright IBM Corp. 1999, 2013

Starting the VMware image

Note

If you are in the ILO class - 3L2X3 or 3L203 - then your instructor will inform you of how

you can use an eLab environment for your exercises.

Note

The Steps 1 through 3 are not used for the eLab environment.

The VMware VM (virtual machine) image you will be using is a Virtual Machine image of an

operating system, run within the native Windows operating system of your computer.

__ 1. Logon to your student workstation with the username and password supplied by

your instructor.

________________________________________________________________

__ 2. Start a Linux VMware VM image on your computer.

__ a. On your local computer, find the VMware Player icon and start it.

__ b. The VMware Player window opens, which is a browser. Navigate on the browser

to the location of your VMware VM image (your instructor will inform you of the

location).

________________________________________________________________

__ c. Select the file with the .vmx extension, whose icon looks like this:

__ d. Click the Open button.

__ 3. This starts your Virtual Machine image. The image has preset parameters which will

ensure that the native OS will not be overtaxed for resources.

__ 4. Leave your Virtual Machine image running while we continue the class.

Instructor Exercises Guide with Exercise Solutions with hints

Course materials may not be reproduced in whole or in part

without the prior written permission of IBM.

V5.4.0.3

Uempty

Section 1: Creating the instance

Note

For the single-user VMware Linux environment, your user ID will generally be inst20.

Note

This set of exercise instructions performs the administrative tasks using various DB2 and

system commands in a command line mode. If you would prefer to perform the exercises

using the facilities of a graphical user interface (GUI) tool, an alternate Exercise Guide is

provided that uses the IBM Data Studio on a Windows operating system to perform many

of the exercise steps.

__ 1. We will use the system logon inst00 initially. We will use this login as a means to

perform the system level tasks that require root authority for UNIX based DB2

systems. Once the DB2 instance is created we will log in using the DB2 instance

owner name inst20, For now, log in as inst00.

inst00’s Password: ibm2blue

The login dialog might be different — depending on the vendor of the Linux system

— but will always require a username and password.

__ 2. You might want to take a few minutes to become familiar with the method of file

handling and navigation for the system you are using.

Linux

SUSE: Right-click the inst00’s Home icon in the upper left of the screen, and

select Browse Folder. This opens a window similar to Windows Explorer that you

can use to work with files in the various directories. Double-click the Filesystem

icon. You can see some of the file folders we will use to support our database,

including the folders/directories named database and dbauto.

__ 3. You might want to maximize your VMware VM image by clicking the Maximize icon

on the upper right of your image window.

__ 4. If not already done, open a Terminal session.

__ a. Right-click the empty Linux desktop and select Open Terminal.

Instructor Exercises Guide with Exercise Solutions with hints

Course materials may not be reproduced in whole or in part

without the prior written permission of IBM.

1-6 DB2 10 for LUW: Basic Admin for Linux and Windows © Copyright IBM Corp. 1999, 2013

If you see a message that the db2profile cannot be found – this can be ignored at

this time.

__ 5. The DB2 instance creation and maintenance is performed using a system root user

authority on UNIX and Linux based DB2 servers. Use the UNIX su command to

switch user to root.

su - root

Enter root's password that your instructor gave you. (The default is dalvm3)

Important

For UNIX and Linux based DB2 systems, each DB2 instance has an instance

owner, a system logon user id that matches the DB2 instance name. Two Linux

userids have already been created to support the new DB2 instance by the system

administrator:

• The DB2 instance owner is inst20, the default password is ibm2blue. This user

was created with a primary group name of adm20.

• A second user ID, fenced20, was created for use by fenced procedures, to keep

these applications from having the full authority of the DB2 instance owner.

Background Information — Do not execute these steps.

The command syntax to create a DB2 Instance on your Linux server is

(DO NOT issue this command now; it will be issued later):

db2icrt -u FencedID InstName

You must be the Linux system administrator (root) in order to execute this

command. The command can be found in the DB2DIR/instance directory

where DB2DIR =

/opt/ibm/db2/V10.1

As an alternative, you can have the DB2 Installer utility

, db2setup, create the

groups and usernames for the DB2 Administration Server and a default user

instance. The DB2 Installer program can also be used to create additional

instances after the DB2 product is installed. Reference the appropriate chapter

for your operating system in the Getting Started with DB2 Installation and

Administration on Linux and Windows.

The InstName and FencedID names must already exist before you issue the

db2icrt command. You also need separate and unique Group names for the

InstName and FencedID names for security purposes.

剩余141页未读，继续阅读

penghan4914

粉丝: 0
资源: 1

DB2基础管理实践指南：Linux与Windows版

db2的入门手册压缩包

DB2资料sql语法.zip

深入解析db2--高级管理,内部体系结构与诊断案例 pdf

idb db2 odbc driver

db2 v10.5 官方文档

shell脚本db2用法

linux安装DB2

db2 v11.1 windows

db2官方中文文档‘’

windows db2创建用户

linux环境连接db2数据库

toad for db2 6.3

dbeaver关于db2离线安装包

db2top命令详解

DB2 pureScale优缺点

db2jcc和db2jcc4有什么区别

dbeaver使用教程db2

db2.app.driver

oracle和db2的异同

db2 community edition下载

最新资源