没有合适的资源?快使用搜索试试~ 我知道了~
资源详情
资源评论
资源推荐
DB2 Ve r s ion 9.1 fo r z/OS
Administration Gui de
SC18-9840-00
DB2 Ve r s ion 9.1 fo r z/OS
Administration Gui de
SC18-9840-00
Note
Before using this information and the product it supports, be sure to read the general information under “Notices” on page
879.
First Edition (March 2007)
This edition applies to DB2 Version 9.1 for z/OS (DB2 V9.1 for z/OS), product number 5635-DB2, and to any
subsequent releases until otherwise indicated in new editions. Make sure you are using the correct edition for the
level of the product.
Specific changes are indicated by a vertical bar to the left of a change. A vertical bar to the left of a figure caption
indicates that the figure has changed. Editorial changes that have no technical significance are not noted.
© Copyright International Business Machines Corporation 1982, 2007. All rights reserved.
US Government Users Restricted Rights – Use, duplication or disclosure restricted by GSA ADP Schedule Contract
with IBM Corp.
Contents
About this book . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xiii
Who should read this book . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xiii
Terminology and citations . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xiii
Accessibility features for DB2 Version 9.1 for z/OS . . . . . . . . . . . . . . . . . . . . . . xiv
Accessibility features . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xiv
Keyboard navigation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xiv
Related accessibility information . . . . . . . . . . . . . . . . . . . . . . . . . . . xiv
IBM and accessibility . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xiv
How to send your comments . . . . . . . . . . . . . . . . . . . . . . . . . . . . .xv
Part 1. DB2 Concepts . . . . . . . . . . . . . . . . . . . . . . . . . . . . .1
Chapter 1. Introduction to DB2 concepts . . . . . . . . . . . . . . . . . . . . .3
DB2 data structures . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .3
DB2 databases . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .5
DB2 storage groups . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .6
DB2 table spaces . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .7
DB2 tables . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .19
DB2 views . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .23
DB2 indexes . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .24
DB2 keys . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .41
DB2 schemas . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .42
System structures . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .44
DB2 catalog . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .44
DB2 directory . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .45
Active and archive logs . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .45
Bootstrap data set . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .46
Buffer pools . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .46
Data definition control support database . . . . . . . . . . . . . . . . . . . . . . . .46
Resource limit facility database . . . . . . . . . . . . . . . . . . . . . . . . . . . .47
Work file database . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .47
Control and maintenance of DB2 . . . . . . . . . . . . . . . . . . . . . . . . . . . .47
High availability . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .48
The DB2 environment . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .49
Address space . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .50
DB2 internal resource lock manager . . . . . . . . . . . . . . . . . . . . . . . . . .50
DB2 attachment facilities . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .51
DB2 and distributed data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .55
DB2 and z/OS . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .56
DB2 and the Parallel Sysplex environment . . . . . . . . . . . . . . . . . . . . . . . .56
DB2 and the Security Server for z/OS . . . . . . . . . . . . . . . . . . . . . . . . .57
DB2 and DFSMS . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .57
DB2 sample tables . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .57
Activity table (DSN8910.ACT) . . . . . . . . . . . . . . . . . . . . . . . . . . . .58
Department table (DSN8910.DEPT) . . . . . . . . . . . . . . . . . . . . . . . . . .58
Employee table (DSN8910.EMP) . . . . . . . . . . . . . . . . . . . . . . . . . . .60
Employee photo and resume table (DSN8910.EMP_PHOTO_RESUME) . . . . . . . . . . . . . .63
Project table (DSN8910.PROJ) . . . . . . . . . . . . . . . . . . . . . . . . . . . .65
Project activity table (DSN8910.PROJACT) . . . . . . . . . . . . . . . . . . . . . . . .66
Employee to project activity table (DSN8910.EMPPROJACT) . . . . . . . . . . . . . . . . . .67
Unicode sample table (DSN8910.DEMO_UNICODE) . . . . . . . . . . . . . . . . . . . . .68
Relationships among the sample tables . . . . . . . . . . . . . . . . . . . . . . . . .68
Views on the sample tables . . . . . . . . . . . . . . . . . . . . . . . . . . . . .70
Storage of sample application tables . . . . . . . . . . . . . . . . . . . . . . . . . .74
© Copyright IBM Corp. 1982, 2007 iii
剩余992页未读,继续阅读
wangpc9896
- 粉丝: 0
- 资源: 4
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功
评论0