Ibm Data Server DB2 Manual do Utilizador Página 227
- Página / 298
- Índice
- MARCADORES
Avaliado. / 5. Com base em avaliações de clientes
© Copyright IBM Corp. 2008. All rights reserved. 213
Chapter 5. Deploying pre-configured
databases
In this chapter we describe how to deploy the pre-configured databases with your
application.
We present two different ways to create the database, by using DDL statements
or by using a backup image. We take a look at different ways to populate the
database and explain how to upgrade an already existing database.
Throughout the chapter we show how to do these tasks in two different execution
environments, which are shell scripts and Java applications.
In this chapter we assume that the communication between the DB2 server and
the client from where we are deploying the pre-configured database is in place.
That is, we assume that we have the user rights and connectivity required to
execute our scripts and applications. We do not cover issues such as security,
connectivity, or user rights.
5
- 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
Manuais e produtos relacionados com Acessórios para Computador Ibm Data Server DB2
(18 páginas)© 2020, manymanuals-pt.com. Todos os direitos reservados. | 0.046 s |
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Comentários a estes Manuais