Ibm Data Server DB2 User Manual Page 241
- Page / 298
- Table of contents
- BOOKMARKS
Rated. / 5. Based on customer reviews
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
Related products and manuals for Computer Accessories Ibm Data Server DB2
Computer Accessories Ibm 19K4260 User Manual
(105 pages)
(105 pages)
Computer Accessories Ibm 524 User Manual
(2 pages)
(2 pages)
Computer Accessories Ibm 8260 User Manual
(25 pages)
(25 pages)
Computer Accessories Ibm 250000 User Manual
(19 pages)
(19 pages)
© 2020, manymanuals.com. All rights reserved. | 0.101 s |
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Comments to this Manuals