Access Reporter is a utility that will audit the access permissions on all objects within the Upfront datastore as well as provide all user memberships within the Series 7 namespace.

When extended with the downloadable IBM Integration Module, the IBM Optim pureQuery Runtime simplifies the process of generating DB2 static SQL for Hibernate and iBATIS applications. It does this without requiring you to make changes to your application code or to gather SQL from production workloads. The Optim pureQuery Runtime also enables Hibernate and iBATIS applications that access DB2 or Informix to benefit from the heterogeneous batching feature in pureQuery. With the heterogeneous batching feature, you can batch multiple INSERT, UPDATE, and DELETE requests before sending them across the network, even when the requests reference multiple tables. This article is part one of a two part series. It describes using the IBM Integration Module with Hibernate applications. Part two will focus on iBATIS applications. This article includes a downloadable sample application that illustrates how you can easily enable both these capabilities. The article also provides informal elapsed time performance measurements.

XML is increasingly becoming common as a means for information exchange. A web service application is an example of the type of application that uses XML to exchange information. Any business intelligence product or solution must have sufficient capability to query information that could be in the form of XML. Learn how IBM Cognos 8 delivers a comprehensive, flexible, secure, and scalable solution to query and report on XML data sources, including web services, by leveraging the IBM Cognos Virtual View Manager.

Learn about advanced query statistics, a new feature introduced in IBM OmniFind Enterprise Edition V9.1, based on query log index technology. This new feature offers access to three critical types of statistical information about searches executed using OmniFind: changes in query activity over time, popular queries issued by users, and query history. By monitoring and analyzing these statistics, you can gain insights that enable you to enhance search performance and improve the quality of search results.

This technique uses JavaScript to allow a user to pass multiple values provided to an IBM Cognos 8 Report Studio textbox prompt.

This document provides some tips and techniques when creating a custom style (or "skin") in IBM Cognos 8.4.x.

This second article in the series focuses on the integration of InfoSphere(TM) Streams and WebSphere(R) ILOG(R) JRules. InfoSphere Streams is a high-performance stream processing engine that is capable of performing calculations and analysis of data streams in real time. ILOG JRules is a business rules management system that enables the creation of rule-based applications. This article presents a simple, algorithmic trading scenario in which InfoSphere Streams operate on a stream of market data and, under certain circumstances, a business rule is invoked using ILOG JRules. In order to perform this task, you will learn how to integrate the two products together in an efficient manner.

Many companies need an out-of-the-box solution for integrating IBM FileNet Business Process Manager (BPM) and IBM Content Manager V8 (CM8). Today, using new capabilities provided by IBM Enterprise Content Management Widgets (ECM Widgets) 4.5.2 and IBM WEB Interface (WEBi) 1.0.4, IBM's Enterprise Content Management products bring you an easy way to integrate BPM and CM8 at the runtime tier. Using these new features, enterprise business analysts can manage their business processes using CM8 content without having to invest any additional development effort. This article describes the business background, the architecture, and the procedures for integrating BPM and CM8 repositories at runtime.

Information protection is one of the common entry points for organizations getting started with information governance. Protecting sensitive data serves a clear business need, and protecting data is the goal of many current regulations. In 2008, the average cost of a data breach to an organization was $6.5M - and these only represent the ones that were found. Most of these breaches were internal.

The story of a team of IBM data architects tasked with creating data models for the Model City Mannheim smart grid project. The team built on the existing International Electrotechnical Commission (IEC) Common Information Model (CIM), finding ways to match new smart energy grid concepts and needs with existing model definitions, and in some cases proposing ways to expand the model.

Alameda County Social Services Agency uses IBM DB2, InfoSphere Identity Insight Solutions, and Cognos to implement a Social Services Integrated Reporting System that helps generate the information that the agency needs to continue to qualify for state and federal funding. The solution also helps reduce waste and direct resources where they are most needed.

Are you following best practices in your programming methods? Bonnie Baker offers up more examples of bad SQL habits that need to be broken to help eliminate or reduce conversations with DB2 for z/OS, including removing unnecessary re-reads

Here are five ways to reduce costs and improve performance by paying attention to database detail. Database maintenance means more than just cleaning up--it's about understanding the specific platform that your database runs on, and taking advantage of new technologies.

Why, where, when, and how to partition tables in DB2 for Linux, UNIX, and Windows.

Get the latest data management news, including the new IBM pureScale Application System, Smart Analytics System, DB2 SQL Skin for Sybase ASE, new Informix Editions, SPSS Decision Management software, InfoSphere BigInsights, and a new look for IDUG.

Lester Knutsen shows how to design dimension tables in part two of a three-part series on data model and schema design for data warehouses.

Stuart Litel explains how the new editions of Informix relate to each other, reports on the success of the spring 2010 IIUG Informix Conference, and gives a preview of coming events at the IBM Information on Demand 2010 Global Conference.

This article describes the technical details of IBM InfoSphere Guardium, a solution for real-time database activity monitoring and protection. Existing information security solutions often leave databases vulnerable to advanced hacking techniques and insider attacks. InfoSphere Guardium automatically monitors database transactions and can respond in real-time to access policy violations.

A discussion of the reliability and performance characteristics of Informix that make it an excellent candidate for use as an embedded database server, and a walkthrough of creating an embedded deployment. Informix provides features--such as the Deployment Wizard and Deployment Utility--that simplify the creation of a deployment optimized for an embedded environment.

Dave Beulke reports on the IDUG 2010 North America conference, including new features for DB2 10 for zOS, migration stories from users moving from Oracle to DB2, and improved XML functions in DB2 9.7 for Linux, UNIX, and Windows