How do you work with DB2? How do you issue SQL and/or XQuery statements and enter DB2 commands? Are there graphical tools that can make your administration tasks easier? This article provides the answers to all of these questions. DB2 provides a wide range of tools, both graphical and command-driven, to help you work with DB2.
Learn some considerations that new software as a service (SaaS) vendors need to take into account when developing applications or modifying existing ones to enable them for multi-tenancy on the cloud. The article discusses the considerations only from a database perspective — specifically, from an IBM® DB2® perspective. Six cases or methods are described.
EJB V3.0 provides a robust toolset for data persistence in Java™ technology. Using EJBs doesn't have to be hard. Learn how to access these features in an Eclipse environment and have stronger integration of your applications with the data available. Trial versions of IBM® WebSphere® Application Server and DB2® were used for the examples, but the techniques discussed are transferable to the Community editions of WebSphere Application Server and DB2. Apache OpenEJB is included in IBM WebSphere Application Server CE.
With the increasing interest in Ruby on Rails from companies in the enterprise world, some observers have posed questions about its suitability when it comes to the demanding requirements in this arena. One issue that some have called attention to is that ActiveRecord, Rails' Object-Relational Mapper (ORM), doesn't use prepared statements—or at least it didn't until now. With the latest release of DB2® on Rails, parameterized queries are automatically available and bring with them important performance and security benefits to Rails applications.
IBM® DB2® pureXML® allows you to store XML data natively in a relational database management system, giving you the power and flexibility to report on this data without disturbing the advantages that its XML format offers. In this tutorial, you will learn how to connect to a DB2 database from the Python programming language, importing data about population from the United States Census Bureau. You will use Python to convert this CSV file into XML, before inserting this XML data natively into DB2. Finally, you will use Python to create a command-line application that produces some informative tables that you can access through a menu system.
The pureXML® capabilities of IBM DB2® allow you to store XML natively in a database without modification, while Adobe Flex applications can read XML directly and populate Flex user interfaces. In this three-part article series, you will create a microblogging application that takes advantage of pureXML, Web services, and Adobe Flex; and even allows you to publish your microblogging updates on Twitter.
IBM® DB2® for Linux®, UNIX®, and Windows® introduced pureXML® technology in Version 9. This technology allows you to store XML data in its native form, maintaining the hierarchical structure and permitting you to query it using SQL/XML and XQuery. Just as with relational data, the ability to ensure the integrity of XML data stored in DB2 is mandatory. The methods and mechanisms for ensuring the integrity of XML data, however, are a bit different than the methods for traditional relational data integrity. In this article, you'll learn about XML data integrity in the context of DB2, and explore the various options you have to guarantee integrity in different scenarios.
This article describes how to build a complete IBM DB2 application in a day using an end-to-end XML architecture. The latter means that XML is used for storing, viewing, and manipulating information. The application may be shown to colleagues and customers to get feedback on the architecture, infrastructure, and user interface. Being able to develop, augment, and modify applications through short iterations promotes an agile application development approach.
Starting in IBM DB2 for Linux, UNIX, and Windows 9, a new memory tuning feature, self-tuning memory manager (STMM), simplifies the task of memory configuration by automatically setting values for several critical memory configuration parameters. This article introduces a simple tool to parse the STMM log files to simplify the task of monitoring the decisions made by the memory manager. It has been updated to describe significant improvements to the log parser.