Accessing DB2 Data from the Web Using Java

Java Database Connectivity (JDBC) and Embedded SQL for Java (SQLJ) are provided with DB2 to allow you to create applications that access data in DB2 databases from the Web.

Programming languages containing embedded SQL are called host languages. Java differs from the traditional host languages C, COBOL, and FORTRAN, in ways that signi®cantly affect how it embeds SQL:

vSQLJ and JDBC are open standards, enabling you to easily port SQLJ or JDBC applications from other standards-compliant database systems to DB2 Universal Database.

vAll Java types representing composite data, and data of varying sizes, have a distinguished value, null, which can be used to represent the SQL NULL state, giving Java programs an alternative to NULL indicators that are a ®xture of other host languages.

vJava is designed to support programs that, by nature, are heterogeneously portable (also called ²super portable² or simply ²downloadable²). Along with Java's type system of classes and interfaces, this feature enables component software. In particular, an SQLJ translator written in Java can call components that are specialized by database vendors in order to leverage existing database functions such as authorization, schema checking, type checking, transactional, and recovery capabilities, and to generate code optimized for speci®c databases.

vJava is designed for binary portability in heterogeneous networks, which promises to enable binary portability for database applications that use static SQL.

vYou can run JDBC applets inside a web page on any system with a Java-enabled browser, regardless of the platform of your client. Your client system requires no additional software beyond this browser. The client and the server share the processing of JDBC and SQLJ applets and applications.

The JDBC server and the DB2 client must reside on the same machine as the Web server. The JDBC server calls the DB2 client to connect to local, remote, host, and AS/400 databases. When the applet requests a connection to a DB2 database, the JDBC client opens a TCP/IP connection to the JDBC server on the machine where the Web server is running.

14Quick Beginnings

Page 25 Page 27
Page 26
Image 26
IBM GC09-2830-00 manual Accessing DB2 Data from the Web Using Java
Page 25 Page 27

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