Running Java Programs

You can develop Java programs to access DB2 databases with the appropriate Java Development Kit (JDK) on AIX, HP-UX, Linux, OS/2, Silicon Graphics IRIX, Solaris, or Windows 32-bit operating systems. The JDK includes Java Database Connectivity (JDBC), a dynamic SQL API for Java.

For DB2 JDBC support, you must include the DB2 Java Enablement component when you install the DB2 client. With DB2 JDBC support you can build and run JDBC applications and applets. These contain dynamic SQL only, and use a Java call interface to pass SQL statements to DB2.

The DB2 Software Developer's Kit (DB2 SDK) provides support for Java embedded SQL (SQLJ). With DB2 SQLJ support and DB2 JDBC support you can build and run SQLJ applications and applets. These contain static SQL and use embedded SQL statements that are bound to the DB2 database.

Java can also be used on the server to create JDBC and SQLJ stored procedures and user-de®ned functions (UDFs).

Building and running different types of Java programs requires support from different components of DB2:

vTo build JDBC applications, you must install a DB2 client with the DB2 Java Enablement component. To run JDBC applications, your DB2 client with the DB2 Java Enablement component must connect to a DB2 server.

vTo build SQLJ applications, you must install the DB2 SDK and a DB2 Administrative Client with the DB2 Java Enablement component. To run SQLJ applications, your DB2 client with the DB2 Java Enablement component must connect to a DB2 server.

vTo build JDBC applets, you must install a DB2 client with the DB2 Java Enablement component. To run JDBC applets, the client machine does not require any DB2 components.

vTo build SQLJ applets, you must install the DB2 SDK and a DB2 Administrative Client with the DB2 Java Enablement component. To run SQLJ applets, the client machine does not require any DB2 components.

For detailed information on building and running JDBC and SQLJ programs see Application Building Guide. For more information on DB2 programming in Java, refer to the Application Development Guide. This covers creating and running JDBC and SQLJ applications, applets, stored procedures and UDFs.

For the latest, updated DB2 Java information, visit the Web Page at:

http://www.software.ibm.com/data/db2/java

Chapter 10. Running Your Own Applications 127

Page 139
Image 139
IBM GC09-2830-00 manual Running Java Programs

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.