IBM DB2 Manual de usuario Pagina 241
- Pagina / 298
- Tabla de contenidos
- MARCADORES
Valorado. / 5. Basado en revisión del cliente
Chapter 5. Deploying pre-configured databases 227
The complete Windows example
Example 5-9 shows the full script used to create our ITSO sample database. All
DB2 commands are logged in the file createdb.log.
Example 5-9 The complete windows script for generating the database
@REM -------------------------------------------
@REM Step 1
@REM -------------------------------------------
setlocal
set DB2CLP=**$$**
@REM -------------------------------------------
@REM Step 2
@REM -------------------------------------------
call createdb.cmd
if errorlevel == 4 exit /b %errorlevel%
@REM -------------------------------------------
@REM Step 3
@REM -------------------------------------------
db2 -o- -l createdb.log -s CONNECT TO ITSODB
if errorlevel == 4 goto error
@REM -------------------------------------------
@REM Step 4
@REM -------------------------------------------
db2 -o- -l createdb.log -s -c- -tf itsodb.ddl
if errorlevel == 4 goto error
@REM -------------------------------------------
@REM Step 5
@REM -------------------------------------------
db2 -o- -l createdb.log commit
if errorlevel == 4 goto error
goto success
@REM -------------------------------------------
@REM Step 6a
@REM -------------------------------------------
:error
db2 -o- -l createdb.log rollback
db2 -o- -l createdb.log connect reset
exit /b 4
@REM -------------------------------------------
@REM Step 6b
@REM -------------------------------------------
:success
- 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
© 2020, manymanuals.es. Todos los derechos reservados | 0.092 s |
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Comentarios a estos manuales