IBM Data Server DB2 User Manual
Page 178
164
DB2 Deployment Guide
Example 4-10 A failed connect test using itso_cliapp
db2inst1@mensa:~/work> ./itso_cliapp mensa 50000 itso db2inst1 wrongassword
Connecting to the database itso ...
Failed to connect to the database itso.
SQLSTATE = 08001
SQLCODE = -30082
Message: [IBM][CLI Driver] SQL30082N Security processing failed with
reason "24" ("USERNAME AND/OR PASSWORD INVALID"). SQLSTATE=08001
Preparing the deployment package
Once the redistributable driver files and the application executable file are ready,
you can package them together for deploying. We have built a redistributable
package itso_cli.tar.gz and a sample application called itso_cliapp. Now we put
them into a single package and deploy the package using a script:
1. Under the DB2 development environment, create a working folder
install_image. Create two subdirectories under install_image, named
bin
and
odbcdrv
.
mkdir -p ~/install_image/bin ~/install_image/odbcdrv
2. Copy the sample application and ODBC CLI driver into the subdirectories
respectively. So we copy itso_cliapp to bin, and itso_cli.tar.gz to odbcdrv.
3. Create a deployment script app_install under directory app_install. The entire
directory should look as shown in Example 4-11.
Example 4-11 The complete contents of install_image
db2app@mensa:~/install_image> ls -Rl
.:
total 4
-rwxr--r-- 1 db2app appgrp 2771 2008-06-20 17:40 app_install
drwxr-xr-x 2 db2app appgrp 72 2008-06-20 16:20 bin
drwxr-xr-x 2 db2app appgrp 80 2008-06-20 16:20 odbcdrv
./bin:
total 12
-rwxr-xr-x 1 db2app appgrp 11801 2008-06-20 16:20 itso_cliapp
./odbcdrv:
total 9345
-rw-r--r-- 1 db2app appgrp 9557108 2008-06-20 16:20 odbc_cli.tar.gz