Through a DB2 client, these applications can access all servers and, by using the DB2 Connect product (or the DB2 Connect functionality supplied with DB2 Enterprise - Extended or DB2 Enterprise Edition), they can also access DB2 Universal Database for AS/400, DB2 Universal Database for OS/390, and DB2 for VSE & VM database servers.

The DB2 Software Developer's Kit allows you to develop applications that use the following interfaces:

vEmbedded SQL

vCall Level Interface (CLI) development environment (which is compatible with ODBC from Microsoft)

vJava Database Connectivity (JDBC)

vEmbedded SQL for Java (SQLJ)

vDB2 Application Programming Interfaces (APIs) that use administrative functions to manage a DB2 database.

The DB2 Software Developer's Kit includes:

vPrecompilers for Java, C, C++, COBOL, and FORTRAN.

vLibraries, include ®les, and code samples to develop applications that use SQLJ and DB2 CLI.

vJDBC and SQLJ support to develop Java applications and applets.

vInteractive SQL, through the CLP, to prototype SQL statements and perform ad-hoc database queries.

vAn API to enable other application development tools to implement precompiler support for DB2 directly with their products.

vAn SQL92 and MVS Conformance Flagger to identify embedded SQL statements in applications not conforming to the ISO/ANSO SQL92 Entry Level standard, or which are not supported by DB2 for OS/390.

For complete information on the functionality of the Software Developer's Kit, and instructions on how to use them, as well as a full list of supported compilers for your platform, refer to the Application Building Guide.

Running Your Own Applications

Various types of applications can access DB2 databases:

vApplications developed using a DB2 Software Developer's Kit that include embedded SQL (including Java SQLJ applications and applets), APIs, stored procedures, user-de®ned functions, calls to DB2 CLI, or calls to JDBC applications and applets.

vODBC applications such as Lotus Approach, Microsoft Visual Basic, PowerSoft PowerBuilder, Borland Delphi and thousands more.

Chapter 1. About DB2 Connect 19

Page 31
Image 31
IBM GC09-2830-00 manual Running Your Own Applications

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.