Skip to content

developerWorks : Information Management : Technical library : Articles
Syndicate content developerWorks
The latest content from IBM developerWorks
Updated: 5 hours 55 min ago

Alternating Page Headers

Mon, 03/08/2010 - 06:00
This document will show a technique on how to alternate your page header in a IBM Report Studio report. This is most effective when the report is published to PDF.
Categories: Companies, DB2

Using Multi-Page Report View in IBM Cognos 8 BI

Mon, 03/08/2010 - 06:00
This document will show the best way to create a multi-tab report veiw in the IBM Cognos 8 Portal.
Categories: Companies, DB2

Use DB2 pureXML to implement a healthcare industry data solution

Thu, 03/04/2010 - 06:00
Interoperability and standards are the latest buzzwords in the healthcare industry today. Use of standards is key to giving hospitals and doctors the capability to interoperate to share patient records better. IBM Research has been investigating the healthcare industry's evolution of standards, including the IHE and HL7 standards. This article offers a brief introduction to these standards and protocols, and it offers a scenario of an IBM DB2(R) pureXML(R) solution that follows the IHE QED protocol.
Categories: Companies, DB2

Understanding IBM FileNet Content Manager storage management

Thu, 03/04/2010 - 06:00
This article discusses the storage mechanisms of IBM FileNet Content Manager and describes how to effectively use storage areas and storage policies with IBM FileNet P8 applications. It also discusses storage farming strategies to distribute I/O load and to provide for continuous storage availability. Finally, it discusses storage area state transitions and what to do when a storage area reaches its size limit.
Categories: Companies, DB2

IBM Cognos 8 Go! Dashboard 8.4.1 Companion Guide

Thu, 03/04/2010 - 06:00
This document will help assist any installation issues that might occur while installing, configuring andusing IBM Cognos 8 Go! Dashboard FP1 or IBM Cognos 8 Go! Dashboard FP2.
Categories: Companies, DB2

Displaying Dates in Crosstabs within IBM Cognos 8 Report Studio

Wed, 03/03/2010 - 06:00
This document describes a technique that can be used to display dates as the measure values in a crosstab.
Categories: Companies, DB2

Guidelines to using Calculation Accounts for IBM Cognos Controller

Tue, 03/02/2010 - 06:00
This document will provide guidelines to using Calculation Accounts.
Categories: Companies, DB2

Auto-Size Select and Search Prompt within IBM Cognos 8 Report Studio

Tue, 03/02/2010 - 06:00
This document details an optional switch which may be used to make the display areas dynamically re-size to meet the demands of the wider data.
Categories: Companies, DB2

In_Range Filters and Character Fields

Tue, 03/02/2010 - 06:00
This document details an optional setting which may be used to have a report return data within a range regardless if the From value is greater than the To.
Categories: Companies, DB2

Architecture and Server Sizing for IBM Cognos Controller 8.5

Mon, 03/01/2010 - 06:00
This document will provide guidelines on architecture and server sizing for IBM Cognos Controller 8.5.
Categories: Companies, DB2

Understanding IBM Cognos 8 PowerPlay Performance

Mon, 03/01/2010 - 06:00
This document is intended to provide IBM Cognos Series 7 PowerPlay administrators an overview of the tuning mechanisms in place for IBM Cognos 8 PowerPlay.
Categories: Companies, DB2

IBM Cognos 8 PowerPlayTuning and Best Practices

Mon, 03/01/2010 - 06:00
This document provides various tuning suggestions and guidelines IBM Cognos 8 PowerPlay such that customers are able to obtain optimal performance in their current environment.
Categories: Companies, DB2

Automatically extend dbspaces in Informix Dynamic Server 11.5

Thu, 02/25/2010 - 06:00
As productive databases containing important information systems rapidly grow larger and larger, automated space management becomes more and more important. This article shows you how to avoid out-of-space situations by using existing features of Informix Dynamic Server (IDS) to implement space management functionality. IDS 11.5 delivers a system database called SYSADMIN that includes administrative stored procedures and an integrated DB scheduler. Together, the stored procedures and scheduler enable the database server to execute database functions and procedures at predefined times. You can use the scheduler to continuously monitor all Informix dbspaces, and to extend space when necessary. The article features a sample program that demonstrates how you can implement this function.
Categories: Companies, DB2

IBM Cognos 8 - XML as a Data Source

Wed, 02/24/2010 - 06:00
IBM Cognos provides many types of data sources to connect to for reporting including XML. This document will illustrate techniques for connecting to XML data sources with IBM Cognos 8.
Categories: Companies, DB2

IBM Cognos 8 BI Report Request Service (c8ReportRequestService)

Tue, 02/23/2010 - 06:00
A IBM Cognos 8 SDK application that provides a web services interface to run an IBM Cognos 8 BI report.
Categories: Companies, DB2

Manage XML Schemas in DB2, Part 2: XML schema evolution and XML data management

Tue, 02/23/2010 - 06:00
In the first article in this series, you learned to register several types of XML schemas, how to validate XML data with them, and ways to get the validated information. Now explore several scenarios about evolving XML schemas and ways to manage the XML data in this article.
Categories: Companies, DB2

Manage XML Schemas in DB2, Part 1: Manage XML schemas and validate XML data

Tue, 02/23/2010 - 06:00
XML schemas come in various types, including an XML schema with or without a namespace, XML schemas consisting of multiple definitions, and XML schemas consisting of multiple namespaces. This article takes those kinds of XML schemas, and introduces ways to register XML schemas, ways to validate XML data, ways to get the XML schema used for validating XML data, and so on. This article is described based on DB2 9.7 for Linux, UNIX and Windows.
Categories: Companies, DB2

Achieve high availability with InfoSphere Master Data Management Server and WebSphere Application Server

Thu, 02/18/2010 - 06:00
Master data, by its nature, is mission-critical. Organizations that employ IBM InfoSphere Master Data Management (MDM) Server need it to be available continuously. Loss of the MDM Server's capabilities could have a significant impact on an organization's operations. In this article, understand the capabilities of MDM Server in conjunction with IBM WebSphere Application Server Network Deployment (WAS ND) and IBM HTTP Server (IHS) that offer organizations the ability to ensure that MDM Server will be available whenever it is needed. This article also offers programming and configuration guidance to help ensure that the high availability capabilities of MDM Server, WAS ND, and IHS are used successfully.
Categories: Companies, DB2

Understanding the packaging of Optim Solutions for database development, administration, and performance management

Thu, 02/18/2010 - 06:00
Get a brief overview of the functionality and packaging of the development, administration, and performance management offerings in the IBM Optim(TM) products (many of which have been renamed from Data Studio). The products described in this article include IBM Data Studio, Optim Development Studio and pureQuery Runtime, Optim Query Tuner and Query Workload Tuner, Optim Database Administrator, Optim High Performance Unload, InfoSphere(TM) Data Architect, and DB2 Performance Expert and DB2 Performance Expert Extended Insight Feature. This article reflects new names, packaging, and capabilities from what was described in the article "Understand Data Studio Version 2 software packaging 2.1." [18 Feb 2010: This article has been updated from its original Sep 2009 publication to include changes that were announced or made available in Nov/Dec 2009. --Ed.]
Categories: Companies, DB2

Using pipes to load data in DB2 for Linux, UNIX, and Windows

Thu, 02/18/2010 - 06:00
Moving data from a source database to IBM DB2 for Linux, UNIX, and Windows can be a challenge; particularly when the source database is quite large and you do not have enough space available to hold the intermediate data files. You can solve this problem by using a pipe. The sample code provided and described in this article, provides you with a means to use a pipe to load data into DB2 in Windows and UNIX environments without using intermediary files. This article provides sample code and describes how you can use a pipe to load data into DB2 in Windows and UNIX environments.
Categories: Companies, DB2