IBM DB2 Bedienungsanleitung Seite 177
- Seite / 298
- Inhaltsverzeichnis
- LESEZEICHEN
Bewertet. / 5. Basierend auf Kundenbewertungen
Chapter 4. Deploying applications with DB2 163
Another approach is to compile and link manually from the command line. The
options used for compile and link vary depending on the platforms. A complete
reference can be found at:
http://publib.boulder.ibm.com/infocenter/db2luw/v9r5/topic/com.ibm.db2.luw.apdv
.cli.doc/doc/t0007141.html
In our demonstration, we use the manual method and build the application from
the command line. We use gcc, which is a popular compiler on many platforms
and sometimes is included in the default installation. The compile flag -m64 is
used to inform the compiler that operating system is 64-bit.
The build procedure is as follows:
1. Under the DB2 development environment, create a working folder, for
example, work.
2. Save the application code into the folder work. Our application is named
itso_cliapp.c.
3. Compile and link the application in one step:
gcc -o itso_cliapp -m64 -I/home/db2inst1/sqllib/include
-L/home/db2inst1/sqllib/lib -ldb2 itso_cliapp.c
4. Test the application by providing it with the connection information of a known
database. Required arguments include: host name, port number, database
name, user, and password.
A successful connection test is shown in Example 4-9.
Example 4-9 A successful connection using itso_cliapp
db2inst1@mensa:~/work> ./itso_cliapp mensa 50000 itso db2inst1 password
Connecting to the database itso ...
Connected to the database itso.
Disconnecting from the database itso...
In case there is any incorrect connectivity information input, the connection
might fail, and the application will return diagnostic messages as shown in
Example 4-10.
Note: Because we are using a DSN-less connection, the database that we
are connecting to does not have to be existing in local catalog directory.
- 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
Longshine LCS-844MT manuels
Manuels d'utilisation et guides de l'utilisateur pour Équipement Longshine LCS-844MT.
Nous fournissons des manuels en pdf 1 Longshine LCS-844MT à télécharger gratuitement par type de document : Manuel de l'utilisateur
Kommentare zu diesen Handbüchern