 |
|
|
IBM Informix
IBM Informix software delivers superior database performance for transaction intensive environments. developerWorks is the technical resource center for IBM Informix software, including technical articles, documentation, downloads, and support information.
|
|
|
| |
DB2 for Linux, UNIX and Windows
IBM DB2, IBM's relational database management system, provides the foundation of information on demand. developerWorks is the technical resource center for the IBM DB2, including technical articles, tutorials, documentation, downloads, and support information.
|
|
|
| |
DB2 family
The IBM DB2 family provides the foundation of information on demand.
It's designed to meet your business needs whether large or small.
|
|
|
| |
DBA Central
developerWorks DBA Central page is the technical resource center for the IBM Information Management database administrator and includes technical articles, tutorials, downloads, tools, code samples, and more.
|
|
|
| |
Use REALbasic to develop Informix Dynamic Server database applications on
Mac OS
In this tutorial, see how to develop IBM Informix Dynamic Server (IDS)
database applications for Apple Mac OS using REALbasic. REALbasic is a
cross-platform programming language and development platform that you can use
to write a single application code base and deploy it on Mac as well as Linux
and Windows platforms. This tutorial shows you how to develop REALbasic
database applications on Mac OS that leverage the functionality of IDS on the
Mac OS platform.
|
|
Tutorial |
| |
Create an alerts system using XMPP, SMS, pureXML, and PHP
Thanks to the native XML support that pureXML offers IBM DB2 database developers, you can load XML data directly into your database, freeing up development time to add functionality to your application. Follow along in this tutorial to import an XML file with Euro foreign exchange rates into an IBM DB2 database and use special XQuery and SQL/XML functions to split this XML into separate database rows. You will also create a PHP script that pulls down new rates from the European Central Bank (ECB) Web site each day. Then you will extend the script to send update alerts to a Google Talk user using the XMPP protocol, and to a cell phone by SMS text message using the Clickatell SMS gateway service. Finally, you will create a PHP script that generates a PNG (Portable Network Graphics) graph of this data.
|
|
Tutorial |
| |
Data Importing using IIF function for IBM Cognos Controller
This document will explain how to use IIF functions with importing data into IBM Cognos Controller.
|
|
Articles |
| |
Gauge SQE use in DB2 for i 6.1
This article explains how to collect a SQL Performance Monitor and understand how many of the SQL queries are using SQE and why other SQL statements continue to use CQE. SQE is the strategic query engine on DB2 for i, with better performance, scaling and tooling such as the SQL Plan Cache.
|
|
Articles |
| |
Trial: IBM Mashup Center
Download a free trial of IBM Mashup Center, an enterprise mashup platform enabling the rapid creation, sharing, and discovery of reusable application building blocks (widgets, feeds, mashups) that can be easily assembled into new applications or leveraged within existing applications - with the governance and security IT requires. Mashup Center is also available on Amazon Elastic Compute Cloud (EC2).
|
|
Trial Downloads |
| |
Guidelines to building Cash Flow in IBM Cognos Controller
This document will describe the process to create cash flow in IBM Cognos Controller.
|
|
Articles |
| |
Guidelines in including subgroup companies in datamart
Document will provide guidelines on how to include subgroups in datamart template.
|
|
Articles |
| |
U2 SELECT verb list extension
This article provides a general solution to the problem of record selection based on a large
list of non-primary-key values. It is a step-by-step guide to building a new verb which selects records based on a
match between dictionary values and standard UniData SAVE.LIST and SELECT buffer lists.
For those who like to build their own tools, it offers an interesting project. For those who prefer to use tools
others have built, the completed verb source code is available as a download.
|
|
Articles |
| |
Informix Dynamic Server 11.50 Fundamentals exam 555
Certification Preparation, Part 5: Using SQL
This tutorial is the fifth in a series of 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. This
tutorial covers the use of SQL to manipulate data.
|
|
Tutorial |
| |
Build FileNet BPM applications using IBM ECM Widgets, Part
3: Expanding ECM Widgets using third-party widgets
With IBM Enterprise Content Management Widgets (ECM Widgets), business
analysts can easily design and create new enterprise applications to meet
business requirements. The ECM Widgets application provides rich user
interfaces to communicate with third-party widgets. Business analysts can
create their own widgets or use existing widgets to connect with ECM Widgets
to gain more business value. This article, the third and last in the series,
shows you the IBM iWidget event mechanism, the ECM Widgets event framework,
and how to develop an application that combines third-party widgets and ECM
Widgets.
|
|
Articles |
| |
Information Management and XML technology
Support for XML in IBM Information Management products fosters the
dynamic representation of data in a format that can be easily shared across
databases and across platforms. developerWorks is the technical resource
center for using XML technology with DB2, Informix, U2, and all the IBM
Information Management products.
|
|
|
| |
Open source development for Information Management
Use PHP and other open source tools to develop applications for IBM Information Management servers.
|
|
|
| |
Build a Support Knowledge Base using DB2 pureXML and PHP
Creating applications that use a hybrid of relational data and XML data is easy thanks to
the pureXML feature of IBM DB2 database servers.
In this tutorial, you use PHP to create a Web application that connects to an IBM DB2 Express-C
database and stores some of its data in traditional relational database columns, and some of it in native XML columns.
You also learn how to use SQL/XML queries to retrieve, insert, update, and delete data from this database.
Beyond the hands-on, project-based training, the tutorial equips you with the skills
and conceptual knowledge you need to develop your own hybrid applications.
|
|
Tutorial |
| |
IBM solidDB product family
IBM solidDB is known worldwide for delivering data with extreme speed. There are more than 3,000,000 deployments of solidDB in telecommunications networks, enterprise applications, and embedded software and systems.
|
|
|
| |
Optim Development Studio and pureQuery Runtime
IBM Data Studio Developer is an Eclipse-based integrated database
development environment that speeds application design, development, and
deployment while increasing data access efficiency and performance. Using Data
Studio Developer, you can develop and test routines, generate and deploy
data-centric Web services, create and run SQL and XQuery queries, and develop
and optimize Java technology applications. Designed for use with IBM Data
Studio pureQuery Runtime, together these offerings improve application
performance, security, and manageability. Integrated with the Rational
Software Delivery Platform, Data Studio Developer complements and extends the
capabilities of Rational Application Developer and Rational Developer for
System z.
|
|
|
| |
Optim family
The IBM Optim product family now encompasses Data Studio to provide an
integrated data management environment that offers a comprehensive solution to
help you design, develop, deploy, and manage database applications throughout
the data lifecycle.
|
|
|
| |
Data warehousing
IBM's warehousing solutions provide you with all of the capabilities necessary to glean maximum return from your information.
|
|
|
| |
InfoSphere
Find developer resources, tutorials, and articles for IBM InfoSphere software.
InfoSphere products enable trusted information by transforming, reconciling, and maintaining information, and delivering it in real time to the people, processes, and applications that need it
|
|
|
| |
DB2 Everyplace
IBM DB2 Everyplace is a relational database and synchronization server that extends enterprise applications and data to mobile devices such as personal digital assistants (PDAs) and smart phones. developerWorks is the technical resource center for DB2 Everyplace, including articles, documentation, support, downloads, redbooks and more.
|
|
|
| |
DB2 for z/OS
DB2 on the mainframe allows you to run powerful enterprise applications
and make e-commerce a reality. developerWorks is the technical resource center
for DB2 for z/OS and OS/390.
|
|
|
| |
IMS
IMS is a hierarchial database and transactional server for critical on-line operational applications and data where support for high availability, performance, capacity and integrity, and low cost are key factors. developerWorks is the technical resource center for developing applications for IMS, including technical articles, tutorials, documentation, support, redbooks and more.
|
|
|
| |
Understanding the New Contributor Web Grid
This document will discuss the technology used in the new Contributor Eclipse based grid, as well as install routines, and setting modifications. It will also cover logging.
|
|
Articles |
| |
Installing Business Viewpoint with SQL Server
This document provides a guideline for installing and configuring IBM Cognos 8 Business Viewpoint into a SQL Server 2005 environment.
|
|
Articles |
| |
Configuring SSL for Business Viewpoint
This document walks through generating the SSL certificate, and making the necessary configuration changes in Business Viewpoint to allow the use of SSL.
|
|
Articles |
| |
Guidelines to IBM Cognos Controller Functions
This document will provide information on the IBM Cognos Controller Excel Functions.
|
|
Articles |
| |
Building Period Close Schedules in IBM Cognos Controller
This document will provide guidelines to building period ending closing schedules for IBM Cognos Controller.
|
|
Articles |
| |
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. [2009 Nov 13: Updated to show Linux support.
--Ed.]
|
|
Articles |
| |
Integrating IBM Cognos 8 with Perforce
This article shows you how to integrate the widely used Configuration Management System, Perforce, with IBM Cognos.
|
|
Articles |
| |
Integrating IBM Cognos 8 with CA Siteminder
This document describes how to integrate IBM Cognos 8 with the CA Siteminder for authentication. It will describe how to leverage CA Siteminder with IBM Cognos BI in particular but mention general concepts and things to know about when integrating with other IBM Cognos products as well.
|
|
Articles |
| |
Guidelines to Yearend Procedures for IBM Cognos Controller
This document will provide guidelines to closing yearend and starting a new yearend in IBM Cognos Controller Application.
|
|
Articles |
| |
Get started with Informix Warehouse Feature, Part
2: Extract, load, and transform your data in Design Studio
The new IBM Informix Warehouse Feature provides an integrated and
simplified software platform to design and deploy a warehouse repository on
your existing IBM Informix Dynamic Server (IDS) infrastructure. This tutorial,
the second part of a series, gives you a hands-on and example-driven view of
the Informix Warehouse Client component, the Design Studio. Follow the steps
for designing and testing the data movements and transformations
(Extract-Load-Transform, or ELT jobs) in the form of data flows and control
flows that will do the task of populating the new data warehouse repository
you created in Part 1 of this series.
|
|
Tutorial |
| |
Build FileNet BPM applications using IBM ECM Widgets, Part
2: Constructing a business process management solution
IBM Enterprise Content Management Widgets (ECM Widgets) is a new
Web 2.0 application based on mashup technology. ECM Widgets is an important
component of the IBM Agile ECM FileNet(R)
portfolio. It provides a set of widgets for business designers, analysts,
IT specialists, and end users. The ECM Widgets application is highly flexible, easy to use, and
convenient to expand. A user can quickly construct a FileNet business process
management (BPM) solution by
dragging and dropping widgets to easily configure the solution. ECM Widgets
can significantly reduce the cost of implementation for enterprise business
process management. This article focuses on how to construct a BPM solution
using ECM Widgets 4.5.1 from a business designer's perspective and from a
business analyst's perspective.
|
|
Articles |
| |
Copy your SAP ERP system across platforms using DB2 redirected restore
With DB2 Version 8 or later you can use redirected restore operation to copy an SAP system from one platform to another.
This article provides you with the step-by-step instructions on how to do this and
describes the resources you need before you start.
|
|
Articles |
| |
Guidelines to logging out users and times out for IBM Cognos Controller
This document will provide guidelines to logging out users from IBM Cognos Controller.
|
|
Articles |
| |
Guidelines to setting up menu items for IBM Cognos Controller
This document will provide information on customizing Menu Items in IBM Cognos Controller.
|
|
Articles |
| |
Guidelines to Consolidation by Steps or Status - IBM Cognos Controller 8X
This document will provide guidelines to running consolidation by status or by steps.
|
|
Articles |
| |
Top 10 Cognos Business Intelligence Proven Practices
This landing page contains links to last month's 10 most popular Cognos IB Proven Practices, based on web hits.
|
|
|
| |
InfoSphere Data Architect
IBM InfoSphere Data Architect (formerly Rational Data Architect) is an
enterprise data modeling and integration design tool. InfoSphere Data
Architect is differentiated from other data modeling tools based on its
lifecycle integration that enhances productivity, quality, and
governance.
|
|
|
| |
Information Management and SOA
Learn how you can use SOA and Web services technology with IBM Information Management products.
|
|
|
| |
Top 10 Cognos Financial Performance Management Proven Practices
This landing page contains links to last month's 10 most popular Cognos FPM Proven Practices, based on web hits.
|
|
|
| |
Build a pureXML and JSON application, Part 3: Create OpenSocial gadgets for pureXML
With the Web 2.0 technology of OpenSocial gadgets, developers can easily
include their applications in popular Web sites, such as iGoogle, MySpace, Hi5,
LinkedIn, and others. In this article, explore OpenSocial gadgets through hands-on construction of an application that leverages the pureXML
capability of DB2. This article is the last in a series of three that illustrates how to build a
pureXML application whose user interface is a gadget that you can deploy in any OpenSocial compliant
Web site. Follow the steps in this article to build a user interface that stores and retrieves the
JSON data described in the first article through JSON Universal Services created in the second article.
|
|
Articles |
| |
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 |
| |
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 |
| |
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 |
| |
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 |
| |
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 |
| |
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 |
| |
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 |
| |
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 |
| |
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 |
| |
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 |
| |
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 |
| |
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 |
| |
IBM OmniFind
This page is your resource for technical information about IBM OmniFind, IBM's enterprise search and information access solution, Find links to technical articles, tutorials, documentation, and more.
|
|
|
| |
Information Management and Rational application development
The Rational tool set provides an array of capabilities for developing your database applications. Quickly design, develop, analyze, test, and deploy Web, Web services, Java, J2EE, and portal applications using this comprehensive IDE. This site contains technical articles, tutorials, documentation, redbooks, forums, and more.
|
|
|
| |
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 |
| |
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 |
| |
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 |
| |
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 |
| |
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 |
| |
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 |
| |
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 |
| |
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 |
| |
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 |
| |
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 |
| |
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 |
| |
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 |
| |
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 |
| |
News Bytes: IBM Data Management magazine Oct. 2009 Edition
News and updates from IBM Data Management magazine
|
|
Articles |
| |
IBM Data Management magazine
This is the current cover of IBM Data Management magazine, a four times a year publication of IBM and TDA Group serving data management professionals around the world.
|
|
|
| |
Customizing XML storage in DB2
A review of best practices for when and how to customize your XML storage
|
|
Articles |
| |
Public Service Gets Smarter
A look at how governments and public-sector organizations are using data warehousing and BI
|
|
Articles |
| |
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 |
| |
High-performance data mining
An examination of the capabilities of IBM InfoSphere Balanced Warehouse through a scoring performance study
|
|
Articles |
| |
Change, Challenge and the Data Warehouse
A look at how data warehouse managers are tackling five industry trends
|
|
Articles |
| |
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 |
| |
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 |
| |
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 |
| |
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 |
| |
Information Management and Java technology
IBM Information Management software supports Java programming, including
client applications, server-side capabilities, and tools to make development
and deployment easier. developerWorks is the technical resource center for
programming Java applications to access the Information Management database
servers data and includes technical articles, tutorials, downloads, tools,
code samples, and more.
|
|
|
| |
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 |
| |
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 |
| |
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 |
| |
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 |
| |
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 |
| |
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 |
| |
Data Manager: Right-Sized Analytics
A regional furniture retailer uses better insights (and analytics) to target customers more effectively
|
|
Articles |
| |
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 |
| |
DB2 pureScale
DB2 pureScale reduces the risk and cost of business growth by providing unlimited capacity, continuous availability, and
application transparency. DB2 pureScale on IBM Power Systems incorporates PowerHA pureScale technology to deliver levels of
database scalability and availability unmatched on UNIX or x86 systems. This complements DB2 for z/OS and System z, the undisputed
leader in total system availability, scalability, security and reliability.
|
|
|
| |
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 |
| |
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 |
| |
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 |
| |
Efficient Report Design using Excel addin
This document will provide guidelines to designing reports using the Excel add-in link.
|
|
Articles |
| |
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 |
| |
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 |
| |
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 |
| |
