DB2 V9 教程：Linux, UNIX, Windows 应用开发入门

英文手册

需积分: 3 116 浏览量更新于2024-08-02 收藏 941KB PDF 举报

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

30元优惠券

"DB2 V9 英文手册" DB2 Version 9，是IBM推出的一款企业级数据库管理系统，适用于Linux、UNIX以及Windows等操作系统。该版本的手册主要针对数据库应用程序开发，帮助开发者快速入门并掌握在这些平台上使用DB2进行应用开发的基础知识。在开始使用DB2 Version 9进行数据库应用开发前，读者需要了解相关的注意事项，这通常包括对提供的信息和所支持产品的使用条款。IBM可能会在文档中声明，这些资料包含IBM的专有信息，且受版权法保护。文档内容不提供产品保修，任何手册中的陈述都不应被视为产品保修承诺。 IBM提供了多种方式获取其出版物，包括在线订购和通过当地IBM代表。在线订购可以通过IBM Publications Center完成，网址为www.ibm.com/shop/publications/order。如果需要寻找当地的IBM代表，可以通过IBM的全球联系人目录，访问www.ibm.com/planetwide。对于DB2相关的出版物，可以直接从DB2市场营销和销售部门订购。 DB2 Version 9手册将涵盖以下关键知识点： 1. **安装与配置**：手册会指导用户如何在不同的操作系统环境下安装DB2，包括系统需求、安装步骤、配置选项等。 2. **数据库管理**：涉及创建、删除、备份和恢复数据库的基本操作，以及数据库性能监控和调整。 3. **SQL语言使用**：包括SQL语句的编写、查询优化、事务处理、存储过程和触发器的创建。 4. **安全性**：介绍如何设置和管理数据库用户的权限，以及数据加密和访问控制策略。 5. **应用程序接口(API)**：讲解如何使用JDBC、ODBC、.NET、PHP等接口进行数据库连接和数据操作。 6. **开发工具**：介绍IBM Data Studio、DB2 Control Center等开发工具的使用，帮助开发者高效地进行数据库设计和调试。 7. **故障诊断与问题解决**：提供错误代码解析、日志分析和常见问题解决方案，帮助用户应对可能出现的技术难题。 8. **高可用性和灾难恢复**：涵盖复制技术、故障切换和恢复策略，确保数据库系统的稳定性和数据的安全性。 9. **性能调优**：包括索引优化、查询改写、内存管理等方面的技巧，以提升数据库的整体性能。 10. **XML支持**：DB2 V9强化了对XML数据的支持，手册将解释如何存储、查询和处理XML数据。通过阅读这份DB2 Version 9的英文手册，开发者可以全面了解DB2的功能特性，学习如何在实际项目中有效地利用DB2开发数据库应用程序，从而提升工作效率和系统稳定性。

资源详情

资源推荐

Table 1. AIX installation prerequisites

AIX Version Operating System Hardware

AIX Version 5.2.0 DB2 client is available using the 64-bit AIX

kernel.

DB2 Enterprise Server Edition, for either

single-partition or partitioned database

environment, is available with the required

64-bit AIX kernel.

One of:

v IBM

RISC/6000

v eServer

™

pSeries

AIX Version 5.3.0 DB2 client is available using the 64-bit AIX

kernel.

DB2 Enterprise Server Edition, for either

single-partition or partitioned database

environment, is available with the required

64-bit AIX kernel.

One of:

v IBM RISC/6000

v eServer pSeries

Software considerations:

v (Clients only:) If you plan to use Kerberos Authentication, you require IBM

Network Authentication Service client v1.3 or later. The NAS client is provided

with the AIX Bonus CD.

v Use the bosboot command to switch to the 64-bit kernel.

To switch to a 64-bit kernel, you require root authority and should enter the

following commands:

ln -sf /usr/lib/boot/unix_64 /unix

ln -sf /usr/lib/boot/unix_64 /usr/lib/boot/unix

bosboot -a

shutdown -Fr

v DB2 Version 9 requires the “IBM C++ Runtime Environment Components for

AIX” which includes xlC.rte 8.0.0.4. This is available from the IBM AIX support

web site.

v One of the following browsers is required to view online help and to run First

Steps (db2fs):

– Mozilla 1.4 and up

– Firefox 1.0 and up

– Netscape 7.0 and up

DB2 product installation on NFS (Network File System):

The installation of DB2 products on NFS (Network File System) is not

recommended. Running DB2 products on NFS (for example, NFS mounting

/opt/IBM/db2/V9.1 and then running off code that was physically installed on a

remote system) requires several manual setup steps. There are also a number of

potential issues with setting up NFS for DB2. These include possible problems that

involve:

v Performance (impacted by network performance)

v Availability (you are allowing a single point of failure)

v Licensing (there is no checking done across machines)

v Diagnosing NFS errors can be difficult

As mentioned, the setup for NFS will require several manual actions including:

v Ensuring that the mount point preserve the install path

8 Getting Started with Database Application Development

v Permission must be controlled (for example, write permission should not be

given to the mounting machine)

v DB2 registries have to be set up manually and maintained across all mounting

machines

v The list installed DB2 products and features command (db2ls) must be set up

and maintained properly if you need to detect DB2 products and features

v More care is required when updating your DB2 product environment

v More steps are required when cleaning up on the exporting machine and the

mounting machine

For detailed instructions, look for the “Setting Up DB2 on NFS Mounted File

System” white paper which will be available soon after DB2 Version 9 is made

available.

Related tasks:

v “An overview of installing your DB2 product (Linux and UNIX)” in Quick

Beginnings for DB2 Servers

Related reference:

v “IBM Software Development Kit for Java levels for DB2 products” in Quick

Beginnings for DB2 Servers

v “Communication protocols supported” in Quick Beginnings for DB2 Clients

Installation requirements for DB2 clients and servers (HP-UX)

For the most up-to-date prerequisite information, see http://www.ibm.com/

software/data/db2/udb/sysreqs.html.

To install a DB2 client or server product, the following operating system, hardware,

and communications prerequisites must be met:

Table 2. HP-UX installation prerequisites for HP-UX 11iv2

Operating System Hardware

DB2 products can run on HP-UX 11iv2 (11.23.0505) for PA-RISC

2.x-based (PA-8x00) and Itanium-based systems with:

v May 2005 Base Quality (QPKBASE) bundle

v May 2005 Applications Quality (QPAPPS) bundle

and

the PHNE_32606 patch. (64-bit HP-UX kernel is required; server

only)

One of:

v HP 9000 Series 700 or 800 system

v HP Integrity Series server

Kernel configuration considerations:

A system restart is required if you update the kernel configuration parameters. The

kernel configuration parameters are set in /etc/system. Depending on the values

of your kernel configuration parameters, you might need to modify some of them

before you install the DB2 Version 9 client or server products. If the kernel

configuration parameters are modified, a reboot is necessary to make the changes

to /etc/system effective.

Software considerations:

v If you are installing the Application Development Client, you must have a C

compiler to build SQL Stored Procedures.

v One of the following browsers is required to view online help and to run First

Steps (db2fs):

Chapter 2. Support for elements of the database application development environment 9

– Mozilla 1.4 and up

– Firefox 1.0 and up

– Netscape 7.0 and up

DB2 product installation on NFS (Network File System):

The installation of DB2 products on NFS (Network File System) is not

recommended. Running DB2 products on NFS (for example, NFS mounting

/opt/IBM/db2/V9.1 and then running off code that was physically installed on a

remote system) requires several manual setup steps. There are also a number of

potential issues with setting up NFS for DB2. These include possible problems that

involve:

v Performance (impacted by network performance)

v Availability (you are allowing a single point of failure)

v Licensing (there is no checking done across machines)

v Diagnosing NFS errors can be difficult

As mentioned, the setup for NFS will require several manual actions including:

v Ensuring that the mount point preserve the install path

v Permission must be controlled (for example, write permission should not be

given to the mounting machine)

v DB2 registries have to be set up manually and maintained across all mounting

machines

v The list installed DB2 products and features command (db2ls) must be set up

and maintained properly if you need to detect DB2 products and features

v More care is required when updating your DB2 product environment

v More steps are required when cleaning up on the exporting machine and the

mounting machine

For detailed instructions, look for the “Setting Up DB2 on NFS Mounted File

System” white paper which will be available soon after DB2 Version 9 is made

available.

Related tasks:

v “Modifying kernel parameters (HP-UX)” in Quick Beginnings for DB2 Servers

Related reference:

v “Communication protocols supported” in Quick Beginnings for DB2 Clients

v “IBM Software Development Kit for Java levels for DB2 products” in Quick

Beginnings for DB2 Servers

Installation requirements for DB2 clients and servers (Linux)

For the most up-to-date prerequisite information, see http://www.ibm.com/

software/data/db2/udb/sysreqs.html.

For the latest information on supported Linux distributions, point your browser to

http://www.ibm.com/db2/linux/validate.

The supported operating systems for Linux include:

v Red Hat Enterprise Linux 4 (RHEL4) Update 2

10 Getting Started with Database Application Development

v SUSE Linux Enterprise Server 9 (SLES9) Service Pack 2

To install a DB2 client or server product, the following distribution requirements,

hardware, and communications prerequisites must be met:

Table 3. Linux prerequisites

Distribution Requirements Hardware

You should update your kernel configuration parameters

in preparation for your Linux distribution. The default

values for particular kernel parameters are not sufficient

when running a DB2 database system.

You may also have other products or applications that

require Linux system resources. You should set the

kernel configuration parameters based on the needs of

your Linux system working environment.

The kernel configuration parameters are set in

/etc/sysctl.conf. See the Modifying kernel parameters

(Linux) section of the DB2 Information Center.

Refer to your operating system manual for information

on setting and activating these parameters using the

sysctl command.

DB2 server products are supported on:

v x86 (Intel

Pentium

, Intel Xeon

, and AMD Athlon)

v x86–64 (Intel EM64T and AMD64)

v IA64 (Intel Itanium

2 or higher)

v POWER

™

(any iSeries

™

or pSeries that support Linux)

v (Server only)eServer zSeries

– The Database Partitioning Feature (DPF) is not

supported.

(Client only)64-bit zSeries or System z9

™

boxes.

Package requirements (server only):

The following tables list the package requirements for SUSE Linux and Red Hat

distributions for DB2 Version 9 partitioned servers.

v The pdksh Korn Shell package is required for all DB2 systems.

v A remote shell utility is required for partitioned database systems. DB2 supports

the following remote shell utilities:

– rsh

– ssh

By default, DB2 uses rsh when executing commands on remote DB2 nodes, for

example, when starting a remote DB2 database partition. To use the DB2 default,

the rsh-server package must be installed (see table below). For a comparison

between rsh and ssh, see the “Security issues when installing DB2” section of the

Administration Guide: Implementation.

If you choose to use the rsh remote shell utility, inetd (or xinetd) must be

installed and running as well. If you choose to use the ssh remote shell utility,

you need to set the DB2RSHCMD registry variable immediately after the DB2

installation is complete. If this registry variable is not set, rsh is used. For more

information on the DB2RSHCMD registry variable, see the Performance Guide

book.

v The nfs-utils Network File System support package is required for partitioned

database systems.

All required packages should be installed and configured before continuing with

the DB2 setup. For general Linux information, see your Linux distribution

documentation.

Package requirements for SUSE Linux

Package name Description

pdksh Korn Shell. This package is required for partitioned database

environments.

Chapter 2. Support for elements of the database application development environment 11

剩余83页未读，继续阅读

thomasbai

粉丝: 1
资源: 2

DB2 V9 教程：Linux, UNIX, Windows 应用开发入门

DB2 V9中文手册5

DB2 V9中文手册

db2jcc和db2jcc4有什么区别

linux重启db2数据库

shell脚本db2用法

CENTOS8安装DB2

DB2LOAD使用方法

linux安装db2客户端

linux环境连接db2数据库

db2查看版本命令

怎么看db2版本

cmd连接db2数据库

.net 连接Db2数据库

db2.app.driver

idb db2 odbc driver

db2top命令详解

datax的db2reader

db2look怎么用

mysql和db2差异

windows db2创建用户

最新资源