Ibm Data Server DB2 Bedienungsanleitung Seite 252
- Seite / 298
- Inhaltsverzeichnis
- LESEZEICHEN
Bewertet. / 5. Basierend auf Kundenbewertungen
238 DB2 Deployment Guide
load from "staff.ixf" of ixf messages "staff.msg" insert into itso.staff copy
no indexing mode autoselect;
set integrity for itso.employee allow no access immediate checked;
set integrity for itso.adefusr allow no access immediate checked;
Because referential integrities are not checked during load, you can load the
tables in any order you like. However, the set integrity commands must be
issued in the right order. It must be done until no tables in the database are in
check pending mode.
Checking one table can put another table in check pending mode.
There are several other options that can be used to control the load utility. For a
thorough description, refer to the DB2 Infocenter:
http://publib.boulder.ibm.com/infocenter/db2luw/v9r5/topic/com.ibm.db2.luw.admi
n.dm.doc/doc/c0004587.html
The set integrity statement that is usually required after a load is described in the
DB2 Infocenter at:
http://publib.boulder.ibm.com/infocenter/db2luw/v9r5/topic/com.ibm.db2.luw.sql.
ref.doc/doc/r0000998.html
The db2move utility
Both the import utility and the load utility operates on individual tables. It can
therefore be quite cumbersome to move data between databases if there are a
lot of tables. We can use the DB2 utility db2move to help us manage a group of
tables, for instance, all the table under one schema. db2move works as a calling
interface to the export, import, and load commands. The syntax of the command
is as follows:
db2move dbname action [options]
Where action can be export, import, load, or copy. The copy option is not covered
in this book. The options allow us to specify a group of tables, action options, and
so on.
Note: Only a small subset of the options from the different utilities can be
specified in db2move. For instance, the identifyoverride option for load is not
available in db2move.
- 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
Verwandte Produkte und Handbücher für Computerzubehör Ibm Data Server DB2
Computerzubehör Ibm 8271 Bedienungsanleitung
(6 Seiten)
(6 Seiten)
Computerzubehör Ibm 19K4260 Bedienungsanleitung
(105 Seiten)
(105 Seiten)
Computerzubehör Ibm 524 Bedienungsanleitung
(2 Seiten)
(2 Seiten)
Computerzubehör Ibm 8260 Bedienungsanleitung
(25 Seiten)
(25 Seiten)
Computerzubehör Ibm 250000 Bedienungsanleitung
(19 Seiten)
(19 Seiten)
Computerzubehör Ibm X3950 M2 Bedienungsanleitung
(19 Seiten)
(19 Seiten)
Whirlpool GC751TX manuály
Uživatelské manuály a uživatelské příručky pro Sporáky Whirlpool GC751TX.
Poskytujeme 1 manuály pdf Whirlpool GC751TX ke stažení zdarma podle typů dokumentů: Návod k použití
Kommentare zu diesen Handbüchern