IBM Data Server DB2 manuals

Ibm Data Server DB2 User Manual (298 pages)

Brand: Ibm | Category: Computer Accessories | Size: 3.72 MB |

English

Table of contents

DB2 Deployment Guide

1

October 2008

3

First Edition (October 2008)

4

“Notices” on page vii

4

Contents

5

Contents v

7

Trademarks

10

The team that wrote this book

11

Acknowledgements

12

Become a published author

13

Comments welcome

13

Introduction to DB2

15

1.1 DB2 deployment overview

16

1.2.1 DB2 Server products

17

DB2 Workgroup Server Edition

18

DB2 Enterprise Server Edition

18

IBM Data Server Client

18

6 DB2 Deployment Guide

20

1.2.4 Other DB2 products

22

Client/server relationship

27

14 DB2 Deployment Guide

28

1.3.4 License considerations

34

Processor Value Unit license

35

Requirements

37

Limitations

37

1.3.7 Other considerations

40

DB2 Setup wizard Yes Yes

41

28 DB2 Deployment Guide

42

DB2 server deployment

43

2.1.1 System requirement

44

Instance owner user

45

Fenced user

45

Administration server user

46

DB2 Configuration Assistant

49

Database configuration

52

Example 2-2 db2look output

53

Remote shell

55

Communication settings

56

2.2.1 DB2 Setup wizard

57

2.2.2 db2_install

60

2.2.3 Response file

62

# mkdir -p /tmp/db2rsp

66

# cd /tmp/db2rsp

66

54 DB2 Deployment Guide

68

Baltic Banda

72

2.3.1 Setup of SSH and NFS

73

2.3.2 DB2 license

77

66 DB2 Deployment Guide

80

68 DB2 Deployment Guide

82

Command line options

83

Running a mass deployment

85

2.4 Fix pack deployment

89

2.4.1 Fix pack overview

90

Deployment method

92

Environment

92

Zaire NFS Server

93

Sample deployment script

95

82 DB2 Deployment Guide

96

84 DB2 Deployment Guide

98

86 DB2 Deployment Guide

100

88 DB2 Deployment Guide

102

DB2 client deployment

103

DB2 Deployment Guide

104

3.1.2 Footprint

105

Configuration profile

106

3.1.5 Compatibility

107

ODBC, CLI, and .NET

108

DB2 Setup wizard

110

Response file install

110

102 DB2 Deployment Guide

116

Microsoft SMS

120

114 DB2 Deployment Guide

128

116 DB2 Deployment Guide

130

118 DB2 Deployment Guide

132

Figure 3-30

132

Figure 3-34 Packages window

135

122 DB2 Deployment Guide

136

124 DB2 Deployment Guide

138

126 DB2 Deployment Guide

140

128 DB2 Deployment Guide

142

3.3 Thin Client deployment

145

Edition on the code server

146

\\computer_name\share_name

148

136 DB2 Deployment Guide

150

Deploying applications with

151

Prerequisites

152

Installation procedure

154

4.2 Java

164

4.3.1 CLI and ODBC

168

Comparison of CLI and ODBC

169

4.3.2 Sample application

170

Redistributable driver files

172

Connecting to database

172

166 DB2 Deployment Guide

180

4.4 PHP

183

4.4.1 PDO_IBM

184

4.4.2 IBM_DB2

184

4.4.5 Sample application

188

CLI driver files

190

178 DB2 Deployment Guide

192

4.5 Ruby

195

186 DB2 Deployment Guide

200

4.5.5 Help and support

202

4.6 Python

203

196 DB2 Deployment Guide

210

4.7 Perl

213

4.8 .NET

222

212 DB2 Deployment Guide

226

Deploying pre-configured

227

5.1 Introduction

228

5.1.1 Sample database

229

Database creation

231

Database layout

231

Database objects

233

5.2.2 Using a shell script

236

CLP return codes

237

UNIX script

238

Windows script

239

The complete Windows example

241

5.2.3 Using an application

242

Java sample applications

245

5.4 Populating the database

246

Using a shell script

247

Using an application

248

5.4.2 Using DB2 utilities

249

Import utility

250

Load utility

251

The db2move utility

252

Exporting data with db2move

253

Importing data with db2move

253

Loading data with db2move

253

5.5.2 Updating table objects

256

Using a custom script

258

Current

259

Configuration

259

Building the dependency map

262

5.6 Samples overview

265

5.6.1 Scripts

266

5.6.2 Shell scripts

266

254 DB2 Deployment Guide

268

Example:

268

5.6.3 Java applications

269

DDLExecuter. The name of the

271

258 DB2 Deployment Guide

272

Sample applications

273

260 DB2 Deployment Guide

274

A.2 PHP

276

A.3 Ruby

277

A.4 Python

278

A.5 Perl

279

266 DB2 Deployment Guide

280

Additional material

281

Using the Web material

282

Related publications

283

IBM - DB2 9

284

Related publications 271

285

Online resources

286

How to get Redbooks

287

Help from IBM

287

274 DB2 Deployment Guide

288

Numerics

289

276 DB2 Deployment Guide

290

278 DB2 Deployment Guide

292

280 DB2 Deployment Guide

294

More products and manuals for Computer Accessories IBM

Models	Document Type
DB2 Everyplace 7.2.1	User Manual IBM DB2 Everyplace 7.2.1 User Manual, 18 pages
6633 - 4LE	User Manual IBM 6633 - 4LE User Manual, 19 pages
8271	User Manual IBM 8271 User Manual, 6 pages
Volition Dual Speed Mini-Hub VOL-2008	User Manual IBM Volition Dual Speed Mini-Hub VOL-2008 User Manual, 3 pages
02L1333	User Manual IBM 02L1333 User Manual, 6 pages
ZG09-0629	User Manual IBM ZG09-0629 User Manual, 24 pages
19K4260	User Manual IBM 19K4260 User Manual, 105 pages
THINKPAD S05L-1270-01	User Manual IBM THINKPAD S05L-1270-01 User Manual, 716 pages
iSeries 270 and 820 SENG-3002-01	User Manual IBM iSeries 270 and 820 SENG-3002-01 User Manual, 30 pages
524	User Manual IBM 524 User Manual, 2 pages
8260	User Manual IBM 8260 User Manual, 25 pages
250000	User Manual IBM 250000 User Manual, 19 pages
X3950 M2	User Manual IBM X3950 M2 User Manual, 19 pages
AT-FS202SC/FS3	User Manual IBM AT-FS202SC/FS3 User Manual, 44 pages
8276	User Manual IBM 8276 User Manual, 4 pages
X3400	User Manual IBM X3400 User Manual, 16 pages
612	User Manual IBM 612 User Manual, 2 pages

IBM devices