OS/2 Client Access to DB2 using CLI/ODBC

Before DB2 CLI and ODBC applications can successfully access a DB2 database from an OS/2 client, perform the following steps on the client system:

1.The DB2 database (and node if the database is remote) must be cataloged. To do so, use the CCA (or the command line processor).

For more information see the on-line help in the CCA

2.If you are using ODBC applications to access DB2 data, perform the following steps. (If you are using only CLI applications, skip this step and go to the next step.)

a.Check that there is an ODBC Driver Manager installed. The ODBC Driver Manager is not installed with DB2; we suggest you use the Driver Manager that was shipped with your ODBC application. Also ensure that the DB2 CLI/ODBC driver is installed:

1)Run the ODBC Administration tool as described in its documentation. This is usually done in one of two ways:

vDouble-click on the ODBC Folder in OS/2, and double-click on the ODBC Administrator icon.

vRun odbcadm.exe from the command line.

The Data Sources window opens.

2)Click on the Drivers push button. The Drivers window opens.

3)Verify that ²IBM DB2 ODBC DRIVER² is shown in the list.

If the ODBC Driver Manager is not installed then follow the installation instructions that came with your ODBC application. If the IBM DB2 CLI/ODBC driver is not installed then double-click on the Install ODBC Driver icon in the DB2 folder to install the DB2 CLI/ODBC driver.

b.Register the DB2 database with the ODBC driver manager as a data source using either of these methods:

v Using the CCA:

1)Select the DB2 database alias that you want to add as a data source.

2)Click on the Properties push button.

3)Select the Register this database for ODBC check box.

vUsing the ODBC Driver Manager:

1)Run the ODBC Driver Manager, as described in its documentation. This is usually done in one of two ways:

±Double-click on the ODBC Folder in OS/2, and double-click on the ODBC Administrator icon.

±Run odbcadm.exe from the command line.

Chapter 10. Running Your Own Applications 125

Page 136 Page 138
Page 137
Image 137
IBM GC09-2830-00 manual OS/2 Client Access to DB2 using CLI/ODBC
Page 136 Page 138

GC09-2830-00 specifications

The IBM GC09-2830-00 is a crucial technical document that details the features, technologies, and operational characteristics of the IBM Enterprise Storage System. This guide is essential for IT professionals, data engineers, and system administrators who work with IBM storage solutions.

One of the main features of the IBM GC09-2830-00 is its focus on providing a comprehensive overview of the IBM storage system's architecture. It highlights the seamless integration of various storage technologies, including the IBM Spectrum Storage Suite, which supports a range of deployment models from on-premises to hybrid cloud environments.

The document outlines the storage system's capabilities, such as high availability, which ensures that data is accessible at all times. This feature is essential for businesses that rely on continuous operation and minimal downtime. The IBM GC09-2830-00 also emphasizes the importance of scalability, allowing organizations to adjust their storage solutions as their data needs grow.

Another critical aspect covered in the GC09-2830-00 is data protection and management. The document details the robust security features inherent in the IBM storage environment, including encryption, access control, and comprehensive data backup solutions. These characteristics are vital in today’s era of rising cybersecurity threats.

In terms of performance, the document illustrates the efficient data handling capabilities of the IBM storage system. It incorporates advanced caching and tiering technologies that optimize storage resources, improving response times for applications and reducing latency.

The IBM GC09-2830-00 also discusses the user-friendly management interfaces that simplify the administration of storage resources. The integration of artificial intelligence and machine learning capabilities further enhances system management, providing predictive analytics and insights to help admins address potential issues before they impact operations.

Finally, the document emphasizes IBM's commitment to sustainability, outlining how its storage solutions minimize energy consumption and promote efficient resource usage. This characteristic aligns with the growing demand for environmentally responsible technology solutions.

In summary, the IBM GC09-2830-00 is a pivotal resource for understanding the powerful features and technologies of IBM's Enterprise Storage System, equipping users with the knowledge to leverage these tools effectively in their data management strategies.
Top Page Image Contents