beautypg.com

IBM Data Server DB2 User Manual

Page 225

background image

Chapter 4. Deploying applications with DB2

211

Example 4-51 Call to testconn20 and the resulting output

c:>testconn20 "database=itso; server=9.43.86.48:50000; user id=db2inst1;
password=***"

Step 1: Printing version info
.NET Framework version: 2.0.50727.832
DB2 .NET provider version: 9.0.0.2, file version: 9.5.1.2
Capability bits: ALLDEFINED
Build: 20080328
Factory for invairant name IBM.Data.DB2 verified
Elapsed: 1,8226208

Step 2: Connecting using "database=itso; server=9.43.86.48:50000; user
id=db2inst1; password=***"
Server type and version: DB2/NT 09.01.0003
Elapsed: 6,2289568

Step 3: Selecting rows from SYSIBM.SYSTABLES to validate existance of packages
SELECT * FROM SYSIBM.SYSTABLES FETCH FIRST 5 rows only
Elapsed: 0,9113104

Step 4: Calling GetSchema for tables to validate existance of schema functions
Elapsed: 0,4606624

Test passed.

You can download the application along with the response file and command file
from the IBM Redbooks Web site. Refer to Appendix B, “Additional material” on
page 267 f
or the download instructions.