James Pickel

The DB2 Connect clients have a large number of driver properties that can be used to improve your remote application performance. Many of the property defaults may not give you the best performance when accessing a DB2 z/OS server. This session goes through each client property and provides ways to improve your elapsed time while minimizing DB2 costs. This includes properties that can be changed to obtain the best query performance and best insert performance. Also, the factors are reviewed to help you determine what DB2 Connect client is right for you, The recommended network topology is discussed in order for you to obtain the highest availability when accessing a DB2 Data Sharing group. What properties can be used to obtain the best query performance or best insert performance.

This session goes through the steps needed to configure DB2 Connect clients to support high security connections used to protect remote access. The latest IBM Data Server Drivers provide support for certificate authentication for connections to DB2 10 for z/OS. Client certificate authentication security on a DB2 for z/OS data server supports the use of digital certificates for mutual authentication by requesters and servers. By using z/OS digital certificates, the Secure Socket Layer (SSL) protocol supports server and client authentication during the handshake phase. A data server can validate the certificates of a client at the server, which prevents the client from obtaining a secure connection without an installation approved certificate. The authentication of the remote client’s digital certificate is performed by Application Transparent Transport Layer Security (AT-TLS) that is provided with the z/OS Communications Server TCP/IP stack.