 |
 |
 |
 |
 |
 |
Oracle to DB2 Conversion Guide: Compatibility Made Easy
This Oracle to DB2 migration guide describes new technology, best practices for moving to DB2, and how to handle some common scenarios. It is now dramatically easier than ever to move to DB2 and experience the benefits of the IBM industry leading database, which offers a lower cost of ownership, ease of use, storage savings, industry leading performance, and superior customer support.
|
 |
Redbooks |
 |
09 Nov 2009 |
|
| |
Using Integrated Data Management To Meet Service Level Objectives
We learn how The Great Outdoor Company, a fictional retailer of outdoor products, uses Integrated Data Management solutions by IBM to optimize data management for performance, productivity, and manageability, allowing them to get the most from their data assets and to ensure they can meet service level objectives (SLOs).
We discuss how organizational and infrastructure complexities can negatively affect overall performance and productivity and how an integrated data management approach can help bridge these silos and gaps to provide end-to-end data and data application life cycle support. To illustrate, we focus on how to optimize an enterprise Java application using the Optim Development Studio (formerly Data Studio Developer) and pureQuery Runtime to improve performance, manageability, and security.
We discuss the practical aspects of managing the deployment and maintenance of pureQuery applications. Because an integrated data management approach extends to the problem solving aspect of the data life cycle, we also discuss how DB2 Performance Expert, DB2 Performance Expert Extended Insight Feature (PE/EI), and IBM Tivoli Composite Application Manager (ITCAM) can help you pinpoint problems in complex application environments.
|
 |
Redbooks |
 |
09 Nov 2009 |
|
| |
Detect resource leaks using IBM DB2 tracing and the Eclipse Modeling Framework
Using the IBM DB2 tracing mechanism to detect database resource leaks can be
challenging.
However, with the Eclipse Modeling Framework (EMF),
you can easily design and implement an intuitive tool
that you can use to quickly detects leaks.
|
 |
Articles |
 |
05 Nov 2009 |
|
| |
Use Technology Explorer for IBM DB2 to manage user and group
authentication for DB2 for Linux, UNIX, and Windows
Learn how to use the Technology Explorer (TE) for IBM DB2(R) to control
user and group authentication to DB2 through the use of a security plug-in
called db2auth. The plug-in uses a DB2 database for storing authentication
information instead of an external authentication repository, such as an
operating system or Kerberos. The plug-in allows for a smoother migration from other
database software such as MySQL, which also stores authentication information
within the database. This article also describes how the support in TE for the
db2auth plug-in was implemented.
|
 |
Articles |
 |
05 Nov 2009 |
|
| |
Build FileNet BPM applications using IBM ECM Widgets, Part
1: Introducing IBM Enterprise Content Management Widgets
IBM Enterprise Content Management Widgets (ECM Widgets) is a new
Web 2.0 application based on mashup technology. As an important part of the FileNet
P8 product, the application provides
several widgets that developers can use as-is or can customize to easily create
content-centric business process applications for FileNet(R) P8. This first
artlcle in the series introduces ECM Widgets features and advantages.
|
 |
Articles |
 |
05 Nov 2009 |
|
| |
Creating Mailing Lables in IBM Cognos 8 Report Studio
This document will outline how to create mailing labels in IBM Cognos 8 Report Studio.
|
 |
Articles |
 |
03 Nov 2009 |
|
| |
Creating an XML electronic forms solution with an Adobe PDF form and IBM DB2 pureXML
The eForms solution described in this article involves three components: an electronic form, a web service, and a database. Because all three speak XML, there is no need for complex data mapping or conversion steps between components. The XML data format used in this example implementation is a very simple structure but you can easily expand the format to meet specific needs or even base the format on one of the many XML-based industry standards for data exchange such as NIEM for government, ACORD for insurance, or FIXML for financial markets. This solution places the collected data into the XML business format at collection time and keeps that format throughout submission and storage for a streamlined process that culminates in the business format being stored in a database where it is available for downstream processes or business analysis. You can follow the steps in this article to build and run the three components needed for this efficient XML electronic forms data collection solution.
|
 |
Articles |
 |
03 Nov 2009 |
|
| |
Leveraging pureXML in a Flex microblogging application, Part 3: Using pureXML Web services to publish microblog entries to an HTML page
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.
In Part 1 of the series, you learned about Web Services and how they are enabled
using DB2 pureXML as you created the microblog database and tested it. Part 2
tapped into Adobe Flex and ActionScript to create the user interface of your application. In this article, the final part of the series, you will learn how to use your pureXML Web Services to publish your microblog entries to an HTML page.
|
 |
Articles |
 |
03 Nov 2009 |
|
| |
Leveraging pureXML in a Flex microblogging application, Part 1: Enabling Web services with DB2 pureXML
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.
|
 |
Articles |
 |
03 Nov 2009 |
|
| |
Build a pureXML and JSON application, Part 2: Create Universal Services for pureXML that expose JSON
The pureXML Universal Services for JSON (abbreviated to JSON Universal Services in this article) are a set of database operations, including insert, update, delete, and query, exposed as Web services. These services enable an application to persist JSON in pureXML and to query it easily through HTTP with WebSphere Application Server. Get started with configuring and testing JSON Universal Services in this article.
|
 |
Articles |
 |
03 Nov 2009 |
|
| |
Leveraging pureXML in a Flex microblogging application, Part 2: Building the application user interface with Flex
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.
In Part 1 of the series, you learned about Web Services and how they are enabled
using DB2 pureXML as you created the microblog database and tested it. In this
article, Part 2 of the series, you will tap into Adobe Flex and ActionScript to
create the user interface of the application.
|
 |
Articles |
 |
03 Nov 2009 |
|
| |
Consume Web services using Informix 4GL
Enable IBM Informix 4GL (I4GL) as a service consumer to leverage and
reuse existing Web services and business logic coded in I4GL or other
programming languages. Enabling I4GL as a service consumer opens up many
possibilities of using I4GL to communicate with any programming language while
still enjoying the ease of coding using I4GL.
|
 |
Articles |
 |
29 Oct 2009 |
|
| |
Using DB2 incremental backup
Incremental backup is one of the key high availability features in DB2 9.5 for Linux, UNIX, and
Windows in a data warehouse environment.
This article describes how incremental backup works, when you might want to use it, and strategies for ensuring smooth recoveries. This article
has been updated for DB2 9.5.
|
 |
Articles |
 |
29 Oct 2009 |
|
| |
Use IBM Informix 4GL to develop applications that support UTF-8 character sets
After an introduction to the UTF character set, this article
describes some of the Informix(R) 4GL capabilities, including searching, editing UTF
characters, displaying UTF characters, and creating reports with UTF-8 characters.
After reading this article, you will know how to configure Informix 4GL
7.50.xC1 to support the UTF-8 character set.
|
 |
Articles |
 |
29 Oct 2009 |
|
| |
Compare the distributed DB2 9.7 database servers
In a side-by-side comparison table, author Paul Zikopoulos makes it simple to
understand the basic licensing rules, functions, and feature differences between the members of the distributed
DB2 9.7 server family as of its general availability date of June 19th, 2009.
|
 |
Articles |
 |
29 Oct 2009 |
|
| |
Licensing distributed DB2 9.7 servers in a high availability (HA) environment
Are you trying to ensure you're licensing your DB2 servers correctly in a high availability environment? Don't have the time nor the will to read through the announcement letters, PLETs, or your licensing sheets? Author Paul Zikopoulos explains it all in plain English for the DB2 9.7 release that became generally available on June 17th, 2009.
|
 |
Articles |
 |
29 Oct 2009 |
|
| |
DB2 and IBM's Processor Value Unit pricing
A number of years ago (3Q06), IBM Software Group (SWG) announced a new methodology for processor-based pricing and
introduced the concept of the Processor Value Unit (PVU) as a way to determine the processor rating of a server. This article describes
how DB2 for Linux, UNIX, and Windows (DB2) is licensed with the new PVU methodology for unlimited users.
|
 |
Articles |
 |
29 Oct 2009 |
|
| |
Which distributed edition of DB2 9.7 is right for you? (With a dash of DB2 9.8 pureScale)
Learn the details on what makes each edition of DB2 9.7 for Linux, UNIX, and Windows unique. The author lays out the specifications for each edition, licensing considerations, historical changes throughout the DB2 9.7 release cycle, and references to some interesting things customers are doing with DB2. This popular article is updated during the release for any intra-version licensing changes announced in a Fix Pack as well. This article also discusses some details of the DB2 9.8 release that's the shipment vehicle for the new DB2 pureScale feature.
|
 |
Articles |
 |
29 Oct 2009 |
|
| |
Enabling Kerberos SSO in IBM Cognos Express
This document describes and demonstrates the basic steps that are required in order to enable Integrated Sign On (or Single Sign On) with Active Directory in IBM Cognos Express using the Microsoft IIS 6 Web server.
|
 |
Articles |
 |
28 Oct 2009 |
|
| |
Best practices for DB2 for Linux, UNIX, and Windows: Cost reduction strategies with DB2
Learn how to use the Configuration Advisor, the Design Advisor, and autonomic features, such as the self-tuning memory manager,
to reduce the human costs associated with DB2 maintenance. Help your organization develop a holistic view of reducing costs across hardware, software, and maintenance
over time as part of the lost-cost evolution.
|
 |
Articles |
 |
28 Oct 2009 |
|
| |
How IBM Cognos Planning Scales
This document will help technical and administrative users of IBM Cognos Planning to understand the nature of some scaling behaviors.
|
 |
Articles |
 |
27 Oct 2009 |
|
| |
Implementing InfoSphere Master Data Management behavior extensions
This tutorial shows you how to implement behavior extensions for InfoSphere Master Data Management
Server using the InfoSphere Master Data Management Workbench.
Behavior extensions provide event capabilities that
create actionable master data and improve the business value of your deployed Master Data
Management (MDM) solution.
|
 |
Tutorial |
 |
22 Oct 2009 |
|
| |
Prompt for Groups of Data with Common Syntax in IBM Cognos 8 Report Studio
In some cases users would like to return groupings of data based on common words found in the data itself. This document illustrates how authors can incorporate data grouping prompts using macros in a report filter.
|
 |
Articles |
 |
22 Oct 2009 |
|
| |
Get started with Informix Dynamic Server user interface tools
Learn about the user interface utilities that help to access,
administer, and monitor IBM Informix Dynamic Server (IDS). This article
highlights the utilities DB-Access, AGS Server Studio, Open Admin Tool, and
Informix Server Administrator. In addition, learn about some new features that
help you leverage IDS capabilities using these tools.
|
 |
Articles |
 |
22 Oct 2009 |
|
| |
Day in the life of a DBA
This demo shows how Integrated Data Management solutions from IBM help one
database administrator (DBA) respond quickly to a wide variety of requirements. The
DBA uses DB2 Performance Expert and Extended Insight Feature to help diagnose complex
performance problems quickly. With Optim Database Administrator, daily database
administration tasks are simpler and less tedious, and database changes can be managed
with less risk and greater auditability. Creating a right-sized test database is easy
to do with Optim Test Data Management, even when private data needs to be
unidentified. Finally, the DBA demonstrates how a colleague can use Optim High
Performance Unload to meet a requirement to migrate large quantities of data up to 10 times faster.
|
 |
Demos |
 |
21 Oct 2009 |
|
| |
News Bytes: IBM Data Management magazine Oct. 2009 Edition
News and updates from IBM Data Management magazine
|
 |
Articles |
 |
20 Oct 2009 |
|
| |
Customizing XML storage in DB2
A review of best practices for when and how to customize your XML storage
|
 |
Articles |
 |
19 Oct 2009 |
|
| |
Public Service Gets Smarter
A look at how governments and public-sector organizations are using data warehousing and BI
|
 |
Articles |
 |
19 Oct 2009 |
|
| |
Top Performance Features in DB2 9 for z/OS
A look at indexing on expressions and index compression in DB2 9 for z/OS
|
 |
Articles |
 |
19 Oct 2009 |
|
| |
High-performance data mining
An examination of the capabilities of IBM InfoSphere Balanced Warehouse through a scoring performance study
|
 |
Articles |
 |
19 Oct 2009 |
|
| |
Change, Challenge and the Data Warehouse
A look at how data warehouse managers are tackling five industry trends
|
 |
Articles |
 |
19 Oct 2009 |
|
| |
Programmers Only: Reducing Conversations with DB2 for z/OS: Part 1
A look at SQL that's unnecessary and should be eliminated, SQL that is executed more times than necessary, and SQL that should be replaced
|
 |
Articles |
 |
19 Oct 2009 |
|
| |
Tuning Job Servers in Cognos Planning
How to tune job servers in Cognos Planning to allow for maximum hardware usage, and less locking delays.
|
 |
Articles |
 |
16 Oct 2009 |
|
| |
Use Optim software to manage privatized test data from design to
deployment
With Optim(TM) Development Studio 2.2, built-in integration with Optim
Test Data Management enables developers and database administrators to use
copy-and-paste function to generate an Optim Test Data Management request. The
request can then be used for the efficient creation of a consistent,
right-sized, referentially intact subset of data for testing. This methodology
also enables you to enforce data privacy standards that were originally
defined in the data model that used InfoSphere(TM) Data Architect. Developers
can see which columns are private to ensure that the generated script enforces
the requirement to include the Optim Data Privacy option for de-identifying
private data. This article offers an end-to-end example scenario depicting a
data architect, a database administrator, and a developer completing the steps
needed for the solution.
|
 |
Articles |
 |
15 Oct 2009 |
|
| |
Using the script option to rename PDF files to the Burst Key value
Burst output can be directed to a file system rather than being stored within the Content Store. This process produces uniquely named output files created with a generated key. A script can be used to rename these files according to the burst key value.
|
 |
Articles |
 |
15 Oct 2009 |
|
| |
Durable Models
This document discusses some of the concepts behind designing a durable model to help with the lifecycle of a model in an organization.
|
 |
Articles |
 |
15 Oct 2009 |
|
| |
Writing great code with the IBM FileNet P8 APIs, Part 3: Take a number
Yes, you, too, can have an ECM-backed corner bakery with a tidy customer queue! Just have them take a number. This article discusses
implementation techniques for getting reliably unique sequence numbers from a FileNet P8 repository. Some of the obvious approaches have hidden dangers,
but a correct and useful approach is simple and performant. Along the way to solving this common problem, we'll see some things about
P8 development that have a much wider scope.
|
 |
Articles |
 |
15 Oct 2009 |
|
| |
Sharing Knowledge, Driven by Passion
The IBM Information Champion program recognizes dedicated IBM product advocates who share their opinions and years
of experience with others in the same field. Meet two of the newest (and youngest) recipients.
|
 |
Articles |
 |
13 Oct 2009 |
|
| |
6 Keys to Real-Time Analytics
This article provides six best practices for data management professionals to ensure that their performance management and analytics initiatives are set up for success.
|
 |
Articles |
 |
13 Oct 2009 |
|
| |
Distributed DBA: Using Materialized Query Tables
This article explains what MQTs are, shows you how to create and populate a system-maintained and a user-maintained MQT, and details some situations where
using MQTs can be beneficial.
|
 |
Articles |
 |
13 Oct 2009 |
|
| |
Build a pureXML and JSON application, Part 1: Store and query JSON with DB2 pureXML
JavaScript Object Notation (JSON), a popular textual notation in Web 2.0, is used to represent objects (or data structures) as serialized text when clients and servers exchange information. Some applications benefit from persisting JSON objects to maintain state across sessions. In this article, learn how DB2 pureXML can store, manage, and query JSON when you adopt a simple JSON-to-XML mapping.
|
 |
Articles |
 |
13 Oct 2009 |
|
| |
System z Rocks (Again)
Why IBM System z and DB2 are not only a popular combination for BI, but the primo platform for data warehousing
|
 |
Articles |
 |
12 Oct 2009 |
|
| |
Data Manager: Right-Sized Analytics
A regional furniture retailer uses better insights (and analytics) to target customers more effectively
|
 |
Articles |
 |
12 Oct 2009 |
|
| |
Smarter is: Boosting the IQ of Galway Bay
Learn how the Marine Institute Ireland SmartBay information project is netting impressive results with the help
of IBM InfoSphere Streams software.
|
 |
Articles |
 |
12 Oct 2009 |
|
| |
How to identify unused indexes in DB2 for Linux, UNIX, and Windows
During database application development, developers tend to define a large number of
indexes on tables to guarantee that each and every query performs well.
After application development has been
finished and a database has gone into production, the existence of too many indexes turns
out to be a cause for decreased
database performance.
Many indexes mean more work for the database system when executing UPDATE, INSERT, and
DELETE (UID) operations.
In addition, regular maintenance activities like RUNSTATS and REORG also run
considerably longer in cases where many indexes are present.
Therefore, to achieve the best database performance, it is
critical to be able to determine which indexes are necessary for query execution and which
indexes you can
safely drop without impacting query runtimes.
This article explains several methods that a DB2 for Linux, UNIX, and Windows (DB2 LUW) database
administrator (DBA) can use to identify unused and seldom used indexes.
|
 |
Articles |
 |
08 Oct 2009 |
|
| |
Using collaborative technologies for healthcare in the home
The number of people in the U.S. diagnosed with diabetes is now
reaching 24 million. Diabetes requires monitoring. In this article, get an
introduction to the concept of continuing care, particularly in the home. This
article describes how diabetes monitoring can be improved through
collaborative technologies. See how software from MyCareTeam, IBM, and other
organizations are used in an example in support of diabetes monitoring.
Understand information and Web-based technologies, such as XML storage and
services (for example, through IBM DB2 pureXML) in the
context of continuing care, as well as related initiatives, such as the
Continua Health Alliance's role in selecting appropriate standards. This
article summarizes the impact of these technologies on the building of agile
and collaborative systems for healthcare, and highlights the significant
benefits of collaborative continuing care that include cost reduction and
increased quality of healthcare.
|
 |
Articles |
 |
08 Oct 2009 |
|
| |
IBM Cognos TM1 Back-up and Recovery Guide
This document provides guidance on implementing a backup and recovery policy for IBM Cognos TM1 data.
|
 |
Articles |
 |
07 Oct 2009 |
|
| |
Effiicent Report Design using Excel addin
This document will provide guidelines to designing reports using the Excel add-in link.
|
 |
Articles |
 |
06 Oct 2009 |
|
| |
Cognos 8 BI online trial
Try an online trial of IBM Cognos 8 BI, which delivers the complete range of business intelligence capabilities on a single service-oriented architecture (SOA) by providing reports, analysis, dashboards and scorecards to monitor business performance, analyze trends, and measure results.
|
 |
Trial Downloads |
 |
05 Oct 2009 |
|
| |
Transfer Data from TM1 to IBM Cognos Controller with a TM1 Process
This document will provide information on using Turbo Integrator with IBM Cognos Controller.
|
 |
Articles |
 |
05 Oct 2009 |
|
| |
Guidelines to importing data using lookup splits - IBM Cognos Controller
This document will provide information around using lookup splits to break different types of balances and move them from asset to liability account.
|
 |
Articles |
 |
01 Oct 2009 |
|
| |
Building efficiencies into a DBA's day
Optim Database Administrator (ODA), previously known as Data Studio Administrator, helps improve Database
Administrator (DBA) productivity by providing advanced change management capabilities as well as support for common database
administration tasks. The SQL and XQuery Editor in ODA (also available as part of Data Studio and other Optim products) provides contextual
help that makes command editing quick and command execution less error-prone.
This article shows you how to
use templates and create customized templates to improve your productivity when using database commands.
It also shows you how to test your customized templates and export them to share with other members of your team.
|
 |
Articles |
 |
01 Oct 2009 |
|
| |
DB2 9.7 on Amazon Elastic Compute Cloud (EC2)
DB2 9 is an innovative database server for managing relational and XML data and is ideally suited for Cloud deployments. DB2 Workgroup is the data server for deployment in a departmental, workgroup, or medium-sized business environment, and exploits up to 16GB of memory.
|
 |
Trial Downloads |
 |
30 Sep 2009 |
|
| |
DB2 Express-C 9.7 on Amazon Elastic Compute Cloud (EC2)
Use IBM DB2 Express-C on Amazon Elastic Compute Cloud (EC2). IBM DB2 Express-C, the no-charge edition of the relational and XML hybrid DB2 data server, is ideally suited for use in Cloud environments and delivering Data-as-a-Service (DAAS).
|
 |
Trial Downloads |
 |
30 Sep 2009 |
|
| |
Integrating IBM InfoSphere Master Data Management Server for Product
Information Management with WebSphere Commerce
This article describes the Product Information Management (PIM) for
Commerce accelerator and best practices on how to use it. You will learn about
the different components and how you can use them to accelerate an integration
between the IBM InfoSphere Master Data Management for PIM and WebSphere
Commerce.
|
 |
Articles |
 |
30 Sep 2009 |
|
| |
Configuring Intercompany Dividend Elimination - IBM Cognos Controller 8x
This document will provide guidelines to configuring the elimination dividends using the intercompany control tables.
|
 |
Articles |
 |
29 Sep 2009 |
|
| |
IBM Cognos 8 and WebSphere Clustering
This document describes how to set up IBM Websphere clustering for a IBM Cognos 8.4 Environment.
|
 |
Articles |
 |
29 Sep 2009 |
|
| |
IBM Cognos Special Edition - Installation and Configuration
This document gives extra instruction on the installation and configuration of the IBM Cognos 8.4 Special Edition.
|
 |
Articles |
 |
29 Sep 2009 |
|
| |
Installing and Configuring the JBOSS Application Server for IBM Cognos 8
This document give extra instructions to set up JBoss against IBM Cognos 8.4 environment.
|
 |
Articles |
 |
29 Sep 2009 |
|
| |
SAP Web Configuration and IBM Cognos 8 Deployment
This document is for those who have limited experience with SAP Web Application Server (SAP WAS) and who wish to set up a SAP WAS environment. The document consists of detailed instructions that explain the steps required. The primary goal is to set up a basic environment for testing purposes and not necessarily a high performance production environment.
|
 |
Articles |
 |
29 Sep 2009 |
|
| |
Sun Java Systems Application Server (SJSAS) Installation
This document give extra instructions to set up Sun JSAS against IBM Cognos 8.4.
|
 |
Articles |
 |
29 Sep 2009 |
|
| |
BEA WebLogic Configuration and IBM Cognos Application Deployment
This document give extra instructions to set up BEA Weblogic against IBM Cognos 8.4.
|
 |
Articles |
 |
29 Sep 2009 |
|
| |
Installing and Configuring the IBM Cognos Application
This document give extra instructions to set up IBM Cognos 8.4.
|
 |
Articles |
 |
29 Sep 2009 |
|
| |
Installing and Configuring Oracle 10g Application Server for IBM Cognos 8.4
This document give extra instructions to set up Oracle 10g against IBM Cognos 8.4 environment.
|
 |
Articles |
 |
29 Sep 2009 |
|
| |
BEA WebLogic - Installing the Application Server
This document descibes how to setup and configure BEA Weblogic against IBM Cognos 8.4 BI.
|
 |
Articles |
 |
29 Sep 2009 |
|
| |
Configure SAP Application Server against IBM Cognos 8.4
This document give extra instructions to set up SAP Application server against IBM Cognos 8.4.
|
 |
Articles |
 |
29 Sep 2009 |
|
| |
Eliminating Interco Dividends using Automatic Journals
This document will provide guidelines to using automatic journals to eliminate intercompany dividends.
|
 |
Articles |
 |
28 Sep 2009 |
|
| |
IBM Cognos Express trial download
Download a free trial of IBM Cognos Express V9, the first and only integrated business intelligence (BI) and planning solution purpose-built to meet the needs of midsize companies. It delivers the essential reporting, analysis, dashboard, scorecard, planning, budgeting and forecasting capabilities that midsize companies need at a price they can afford. Everything is included in a pre-configured solution that is easy to install, easy to use and easy to buy.
|
 |
Trial Downloads |
 |
24 Sep 2009 |
|
| |
Informix Dynamic Server 11.50 Fundamentals Exam 555
certification preparation, Part 8: Backup and restore
In this tutorial, learn about essential Informix Dynamic Server 11.50
database backup and restore concepts, and about ON-Bar and ontape utilities to
backup and restore database server data. You will also learn about table-level
restore with archecker utility.
|
 |
Tutorial |
 |
24 Sep 2009 |
|
| |
System Management Methodology
Documentation and resource files for System Management Methodology.
|
 |
Articles |
 |
24 Sep 2009 |
|
| |
U2 Compact Framework
Rapidly evolving client needs are driving advances in information technology that are
making the world seem smaller and flatter.
One of the basic underlying requirements of these needs is
access to information anywhere, on any device, at any time.
The U2 UniObjects for .NET Compact Framework (UO.NETCF) library makes this
kind of access possible.
This article provides an example of how to take an existing PC-based application
that communicates with a U2 database, and use it as the
basis for developing a new mobile application using UO.NETCF.
|
 |
Articles |
 |
24 Sep 2009 |
|
| |
Multi-row fetch support with type 2 connectivity in DB2 V9 for z/OS
Multi-row FETCH (MRF) can provide you with better performance than retrieving one row with
each FETCH statement.
This article explains what MRF is and how to use it.
The article also includes a sample Java program that illustrates how to set
MRF in an application.
For IBM Data Server Driver for JDBC and SQLJ type 2 connectivity on DB2 for z/OS,
multi-row FETCH can be used for forward-only cursors
and scrollable cursors.
For other types of connectivity, multi-row FETCH can be used
only for scrollable cursors.
|
 |
Articles |
 |
17 Sep 2009 |
|
| |
Informix Dynamic Server 11.50 Fundamentals Exam 555
certification preparation, Part 9: Informix replication technologies
This is the last tutorial in a series of nine tutorials to help you
prepare for the Informix Dynamic Server (IDS) 11.50 Fundamentals certification
exam 555. This tutorial discusses replication technologies and provides an
overview of high availability technologies available in IDS. Learn the
difference between High Availability Data Replication and Enterprise
Replication, and follow the steps for how to set up an IDS server for
replication and high availability.
|
 |
Tutorial |
 |
17 Sep 2009 |
|
| |
Informix Dynamic Server 11.50 Fundamentals Exam 555
certification preparation, Part 7: Tools and utilities
With a good understanding of the tools and utilities that come with IBM
Informix Dynamic Server (IDS), you'll find the database easier to monitor and
administer. In this tutorial, learn about those tools. This is the seventh of
a series of nine tutorials that will help prepare you for IDS exam
555.
|
 |
Tutorial |
 |
17 Sep 2009 |
|
| |
Global Deployment Guide
Locale considerations for a IBM Cognos Series 7 deployment.
|
 |
Articles |
 |
16 Sep 2009 |
|
| |
Trial: IBM Cognos Express
Download a free trial of IBM Cognos Express V9, the first and only integrated business intelligence (BI) and planning solution purpose-built to meet the needs of midsize companies. It delivers the essential reporting, analysis, dashboard, scorecard, planning, budgeting and forecasting capabilities that midsize companies need at a price they can afford. Everything is included in a pre-configured solution that is easy to install, easy to use and easy to buy.
|
 |
Trial Downloads |
 |
15 Sep 2009 |
|
| |
Developing a Web 2.0 application using the InfoSphere Business Glossary REST API
IBM InfoSphere Business Glossary enables users to create, manage, and share an enterprise vocabulary and classification system.
In version 8.1.1, the Business Glossary team introduced a REST API that makes
glossary content easier to consume by enabling the development of custom applications based on particular needs.
This article provides step-by-step instructions on how to develop a portable, dynamic
read-write widget that uses the IBM InfoSphere
Business Glossary REST API in conjunction with various Web 2.0 technologies.
The widget enables users to find terms, examine the term's details, and make basic edits.
Our goal is for InfoSphere Business Glossary customers to
use the knowledge gained through building this sample widget as inspiration
for using the REST API to create their own custom applications.
This article is intended for software engineers who are familiar with Web 2.0
technologies and product designers who can apply the tools provided here to real world situations.
|
 |
Articles |
 |
10 Sep 2009 |
|
| |
Using virtual cubes in IBM InfoSphere Warehouse 9.7 to combine business
scenarios and to improve performance
Virtual cubes are one of the new Cubing Services features in IBM
InfoSphere(TM) Warehouse 9.7. A virtual cube provides a way to merge different
cubes together to allow a single query destination that returns merged results
from the cubes that compose it. Virtual cubes can be used to drastically
improve the response time of the cube server queries by using efficient data
partitioning for optimum cache utilization (in some cases, over 100 times
better response times). Virtual cubes also offer a solution for combining
results by merging different regional cubes into a country cube. They also
enable merging sales numbers with currency exchange rates to provide a global
view of the business. This article explains how virtual cubes are created, how
they work, and how to use them for InfoSphere Warehouse Cubing Services
9.7.
|
 |
Articles |
 |
10 Sep 2009 |
|
| |
Designing and deploying a security model using IBM InfoSphere Warehouse
Cubing Services
In IBM InfoSphere(TM) Warehouse V9.7, Cubing Services modify the way you
secure your cubes and provide a way for you to secure your dimensions. You
might need to limit access to your OLAP data at the level of the cube or at
the more granular level of the dimension, depending on your security
requirements. In this article, you will learn how to define security on cubes
and dimensions by creating roles, policies, and authorizations in the Design
Studio. This article describes how to export the security model to a file and
how to use the Administration Console to import the security model to the
InfoSphere Warehouse control database. After importing the security model, you
will learn how to instruct the Cube Server to enforce the rules in the
security model.
|
 |
Articles |
 |
03 Sep 2009 |
|
| |
Informix Dynamic Server 11.50 Fundamentals Exam 555
certification preparation, Part 4: Examining database objects
This tutorial continues your journey into Informix Dynamic Server by
discussing many of the objects that can be created and used inside of a
database. Some of these objects include tables, indexes, triggers, and views.
This tutorial discusses what they are, how they are used, and how to create
them.
|
 |
Tutorial |
 |
03 Sep 2009 |
|
| |
IBM InfoSphere DataStage and DB2 pureXML, Part 2: Building an XML-enabled data warehouse
Learn how to integrate business-critical XML data into your data warehouse using IBM InfoSphere DataStage 8.1 and DB2 9.5 pureXML.
This two-part article series provides step-by-step instructions for using pureXML as both
a source and target data source for InfoSphere DataStage jobs.
|
 |
Articles |
 |
03 Sep 2009 |
|
| |
Guidelines to Currency Translation in IBM Cognos Controller
Document will provide guidelines to handling investment adjustment when 100 percent ownership exists.
|
 |
Articles |
 |
02 Sep 2009 |
|
| |
Understanding Unexpected Drill-Through Behavior in IBM Cognos 8
This document is intended as a reference guide for various IBM Cognos 8 BI drill-through scenarios in which the results may be unexpected.
|
 |
Articles |
 |
02 Sep 2009 |
|
| |
InfoSphere Warehouse: Trial download
Download a free trial of IBM InfoSphere Warehouse V9.7 Enterprise Edition, which makes it easier to discover hidden business opportunities and provides a comprehensive platform to design, optimize, discover and grow departmental data marts and enterprise data warehouses.
|
 |
Trial Downloads |
 |
31 Aug 2009 |
|
| |
IBM High Availability Solution for IBM FileNet P8 Systems
This IBM Redbooks® publication describes strategies and options for core IBM FileNet P8 system components. In addition, the book provides detailed, step-by-step procedures that we used to implement high availability for our case study IBM FileNet P8 system. This book serves as a practical reference when you design and implement highly available IBM FileNet P8 systems. This book is intended for IT architects, IT specialists, project managers, and decision makers identifying the best high availability strategies and integrating them into the IBM FileNet P8 system design process.
|
 |
Redbooks |
 |
31 Aug 2009 |
|
| |
Informix Dynamic Server 11.50 Fundamentals Exam 555
certification preparation, Part 3: DBMS instances and storage objects
This tutorial is the third in a series of nine tutorials designed to
help you become familiar with all the different aspects of IBM Informix
Dynamic Server (IDS) and help you get ready for the IDS Fundamentals
Certification exam. In this part, which corresponds with Part 3 of the exam,
learn how to identify and connect to IBM Informix database servers and
databases. Learn also how to create and configure database storage objects,
and gain an understanding of system databases and system catalog
tables.
|
 |
Tutorial |
 |
27 Aug 2009 |
|
| |
Text Analysis in InfoSphere Warehouse, Part 3: Develop and integrate custom UIMA text analysis engines
In the first two articles of this series, you learned about IBM InfoSphere Warehouse text analysis capabilities,
how to use regular expressions and dictionaries to extract information from text, and how to publish the results with
a Cognos report.
This article describes how to use the Unstructured Information Management Architecture (UIMA) framework to create a custom
text annotator and use it in InfoSphere Warehouse.
The ability of InfoSphere Warehouse to use UIMA based annotators in analytic flows is a powerful feature.
You can write
custom annotators that can extract almost any information from text.
Plus you can use UIMA based annotators that are provided by IBM, other companies, and
many universities.
For example, you can find UIMA annotators that tokenize words and extract
concepts such as persons or sentiments.
|
 |
Articles |
 |
27 Aug 2009 |
|
| |
New options for XML data integrity and validation in DB2 V9.5
DB2 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.
|
 |
Articles |
 |
27 Aug 2009 |
|
| |
Optim solutions for accelerating Java database access
This demo shows how the staff at one fictional organization, the Great
Outdoors Company, takes advantage of Optim solutions to help them gain more value from their business-critical Java applications.
|
 |
Demos |
 |
27 Aug 2009 |
|
| |
DB2 9.7: Using PL/SQL anonymous blocks in DB2 9.7
IBM DB2(R) for Linux(R), UNIX(R), and Windows(R) 9.7 introduces support
for PL/SQL anonymous blocks: a feature that enables PL/SQL application
developers to test, troubleshoot, and prototype new procedural code, simulate
application runs, and dynamically build complex ad-hoc queries and reports.
This article describes the concept of anonymous blocks in DB2 9.7 and
illustrates the use of this feature using common database scenarios.
|
 |
Articles |
 |
27 Aug 2009 |
|
| |
IBM Cognos 8 Go! Dashboard FP1 and FP2 Companion Guide
This document will help assist any installation issues that might occur while installing, configuring and using IBM Cognos 8 Go! Dashboard FP1 or IBM Cognos 8 Go! Dashboard FP2.
|
 |
Articles |
 |
26 Aug 2009 |
|
| |
DB2 Optimization Techniques for SAP Database Migration and Unicode Conversion
This book provides in-depth information about the best practices and recommendations for the source system database export, the advanced migration techniques, database layout and configuration, database import recommendations, SAP NetWeaver Business Warehouse, as well as background information about Unicode. We summarize our recommendations in one chapter that can be used as a quick reference for experienced migration consultants.
|
 |
Redbooks |
 |
24 Aug 2009 |
|
| |
IBM InfoSphere DataStage and DB2 pureXML, Part 1: Integrate XML operational data into a data warehouse
Learn how to integrate business-critical XML data into your data
warehouse using IBM InfoSphere DataStage 8.1 and DB2 9.5 pureXML. This
two-part article series provides step-by-step instructions for using pureXML
as both a source and target data source for InfoSphere DataStage
jobs.
|
 |
Articles |
 |
20 Aug 2009 |
|
| |
Developing with PL/SQL in IBM Data Studio 2.2 and Optim Development Studio 2.2
This article describes how you can use
IBM Data Studio 2.2 and
Optim Development Studio 2.2
to develop routines that use Oracle PL/SQL.
It shows you how to create, edit, deploy, and debug PL/SQL packages,
procedures, and functions for the following databases:
DB2 for Linux, UNIX, and Windows Version 9.7,
Oracle 10g, and Oracle 11g.
|
 |
Articles |
 |
20 Aug 2009 |
|
| |
Informix Dynamic Server 11.50 Fundamentals Exam 555
certification preparation, Part 2: Security
Get an introduction to the concepts of authentication,
authorization, and privileges as they relate to IBM Informix Dynamic Server 11.50
(IDS). This tutorial is the second in a series of nine tutorials designed to help you
prepare for the IDS Fundamentals Certification Exam (555).
|
 |
Tutorial |
 |
20 Aug 2009 |
|
| |
Understanding IBM Cognos 8 PowerPlay Performance
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.
|
 |
Articles |
 |
20 Aug 2009 |
|
| |
Passing Use and Display Values on a URL
This document focuses on passing 'Display values' as the primary value, and also includes details on how to pass complex parameters such as ranges.
|
 |
Articles |
 |
18 Aug 2009 |
|
| |
An IBM Mashup Center plug-in to convert HTML to XML
Learn how to build a plug-in for the IBM Mashup Center that can convert HTML into
XML, opening the door for some simple data extraction from HTML pages using the Feed Mashup Editor.
|
 |
Articles |
 |
18 Aug 2009 |
|
| |
Trial: IBM InfoSphere Warehouse 9.7 Enterprise Edition
Download a free trial version of IBM InfoSphere
Warehouse V9.7 Enterprise Edition, which makes it easier to
discover hidden business opportunities. It provides a comprehensive platform to design, optimize, discover and grow departmental data marts and enterprise data warehouses.
|
 |
Trial Downloads |
 |
18 Aug 2009 |
|
| |
Loading a large volume of Master Data Management data quickly
The Rapid Deployment Package (RDP) for IBM InfoSphere(TM) Master Data
Management Server solution addresses the needs of clients in the first phase
of implementing initial load solutions. Using MDM, clients need to perform
initial and delta loads, typically as a batch. This article focuses on the
maintenance transaction approach to perform initial loads, including an
introduction, installation, and setup. It also covers performance tuning tips
and best practices. You can leverage recommendations in this article as
guidance in your own MDM Server initial load solutions using RDP.
|
 |
Articles |
 |
14 Aug 2009 |
|
| |