Published: 29 Mar 2017 07:47:38 +0000Copyright: Copyright 2004 IBM Corporation.
23 Mar 2017 04:00:00 +0000This document will show how you can load monthly data into Controller.
23 Mar 2017 04:00:00 +0000Importing structures into Controller using Staging Tables and Microsoft SQL Server.
23 Mar 2017 04:00:00 +0000This document will provide information on using Turbo Integrator with IBM Cognos Controller.
23 Mar 2017 04:00:00 +0000This document will provide information around using lookup splits to break different types of balances and move them from asset to liability account.
22 Mar 2017 04:00:00 +0000This document will explain how to use IIF functions with importing data into IBM Cognos Controller.
10 Mar 2017 05:00:00 +0000This document will provide information on importing intercompany balances when the general ledger account is the counter company.
09 Mar 2017 05:00:00 +0000Document will provide guidelines to handling investment adjustment when 100 percent ownership exists.
09 Mar 2017 05:00:00 +0000This document provides guidelines to configuring intercompany profit.
09 Mar 2017 05:00:00 +0000How to set up both general configuration and automatic journals.
09 Mar 2017 05:00:00 +0000This document will provide guidelines to eliminating the intercompany gain and losses on sales fixed/depreciable assets.
09 Mar 2017 05:00:00 +0000This document will provide information on performing allocations in IBM Cognos Controller
08 Mar 2017 05:00:00 +0000This document will provide guidelines to using Calculation Accounts.
08 Mar 2017 05:00:00 +0000The purpose of this document is to layout the different approaches to importing data into Controller.
08 Mar 2017 05:00:00 +0000This document will provide guidelines around using company and group journals.
08 Mar 2017 05:00:00 +0000Import and exporting of structures
08 Mar 2017 05:00:00 +0000This document will provide guidelines to using Change Tables.
08 Mar 2017 05:00:00 +0000The document provides guidelines to building notes/commentary in IBM Cognos Controller.
08 Mar 2017 05:00:00 +0000How to setup and configure Z Consolidation Method.
02 Feb 2017 05:00:00 +0000The steps to provide the pagination feature in a Cognos BI 10.2.2 report.
01 Feb 2017 05:00:00 +0000This document examines how investment elimination should work when both currency conversions methods - Method 1 (Current) and Method 2 (MNM) - are in use in a single consolidation.
01 Feb 2017 05:00:00 +0000Guideline to importing of general journals into Controller
01 Feb 2017 05:00:00 +0000Lookup tables are used to convert information in a file from another system into Controller keys. Define lookup tables under Transfer/External Data/Define Lookup tables.
01 Feb 2017 05:00:00 +0000Guidelines to setting up and using historical rates in IBM Cognos Controller.
05 Jan 2017 05:00:00 +0000The FlexID panel is included with IBM
09 Aug 2016 04:00:00 +0000Are you writing SQL applications that need to be portable across platforms? Here's the information you need to make sure your applications are portable. The tables in this article summarize the common SQL application features and make it easy for you to develop applications using SQL that is portable across the DB2 family, including DB2 for z/OS, DB2 for i, and DB2 for Linux, UNIX, and Windows.
05 Aug 2016 04:00:00 +0000Management of large amounts of data is a challenge that provides the opportunity to explore different approaches to managing complex states and analyzing numerous metrics. Our professional golf and tennis tournaments generate terabytes of data from site traffic alone. The Predictive Cloud Computing (PCC) system utilizes IBM DB2 to store aggregated information generated from the source data and Graphite to analyze metrics and profile our codebase. Each of these tools gives the PCC system the ability to store and analyze large amounts of data and provide straightforward retrieval for latent analysis.
24 Jul 2016 04:00:00 +0000This tutorial series describes common tasks to manage spatial data with IBM DB2 Spatial Extender, including importing and creating spatial data, constructing and executing spatial queries, working with IBM, third-party, and open source spatial tools, tuning performance, and considering special circumstances in a data warehouse environment. In this first article in the series, learn how to acquire spatial data and build applications. Learn how to use shapefiles, spatial data tables, and spatial indices.
22 Jul 2016 04:00:00 +0000Get an introduction to the various editions of IBM Informix, and compare features, benefits, and licensing considerations in a side-by-side table. Regardless of which edition you choose, Informix brings you legendary ease of use, reliability, stability, and access to extensibility features.
01 Jun 2016 04:00:00 +0000In Version 10, IBM Security Guardium
19 Apr 2016 04:00:00 +0000IBM Security Guardium
05 Apr 2016 04:00:00 +0000Learn about the cross-industry and industry specific sample applications and tools available in the IBM Datacap Taskmaster Capture Development Kit (DDK), and find links to each of the components.
05 Apr 2016 04:00:00 +0000A healthy IBM® DB2® workload needs temporary storage to perform efficiently. Understanding and managing this storage is the key to keep your system running effectively. This article describes five important temporary storage types that the SQL Query Engine (SQE) uses on IBM i.
01 Apr 2016 04:00:00 +0000Learn how to configure a failover solution for DB2 for Linux, UNIX, and Windows, using the DB2 high availability disaster recovery (HADR) feature and the the DB2 high availability instance configuration utility (db2haicu). This article walks you through the concepts and then shows how to set up two distinct configurations for automated failover.
05 Mar 2016 05:00:00 +0000To create effective, enterprise-ready mobile applications, you need to make the back-end data easier to consume. APIs in IBM
01 Mar 2016 05:00:00 +0000SAP
24 Feb 2016 05:00:00 +0000Native I/O is widely used in RPG and COBOL programs for getting access to the data stored in the database. Data access is mostly performed with the help of data description specifications (DDS) keyed physical and logical files. Unfortunately DDS is an outdated technology, while all future development regarding the database and data access is only integrated into SQL. For profiting from the new indexing technologies in release 6.1, native I/O does not need to be replaced with embedded SQL. SQL indexes can be used with native I/O like any keyed logical file. Moreover, the enhanced indexing technologies could first be used with native I/O while the SQL query optimizer could only partially profit from these enhancements.This article explains how SQL indexes can be used in conjunction with native I/O and how native I/O can profit from the enhanced indexing technologies.
19 Feb 2016 05:00:00 +0000Creating solutions and architectures that harness the value and power of big data and cloud can give your company a competitive advantage, spark new innovations, and increase revenues. The Cloud Standards Customer Council's Customer Cloud Architecture for Big Data and Analytics describes a well-tested and popular reference architecture for traditional analytics production environments. In this article, see how IBM supports this architecture in a secure, scalable, and flexible manner in dedicated and on-premises public could, hybrid cloud, and private cloud environments.
17 Feb 2016 05:00:00 +0000Learn scenarios that show you how to implement IBM® InfoSphere® Master Data Management (MDM) composite transactions with MDM Application Toolkit services. This tutorial is the final part of a series that describes how to integrate IBM Business Process Manager (BPM) and master data.
10 Feb 2016 05:00:00 +0000Learn how to use IBM® InfoSphere® Master Data Management (MDM) Application Toolkit services to implement InfoSphere MDM additions and extensions. This tutorial is the third part of a series that describes how to integrate IBM Business Process Manager (BPM) and master data.
05 Feb 2016 05:00:00 +0000You need a cost-effective way to structure your company's data so that you can instantly access hot data
04 Feb 2016 05:00:00 +0000Docker containers enable you to package applications with their dependencies
02 Feb 2016 05:00:00 +0000To create effective, enterprise-ready mobile applications, you need to make the back-end data easier to consume. APIs in IBM
28 Jan 2016 05:00:00 +0000You need a cost-effective way to structure your company's data so that you can instantly access hot data
21 Jan 2016 05:00:00 +0000You need a cost-effective way to structure your company's data so that you can instantly access hot data
15 Jan 2016 05:00:00 +0000You need a cost-effective way to structure your company's data so that you can instantly access hot data
30 Dec 2015 05:00:00 +0000IBM InfoSphere Optim Solutions allows you to manage data throughout the data lifecycle. This tutorial walks you step-by-step through how to use function-level, object-level, and archive-file security to set data-specific security in a database.
18 Dec 2015 05:00:00 +0000To make it easy for you to find the best-loved Information Management tutorials in one place, we've highlighted some of our favorites from this year. Check out the top five IM tutorials from 2015.
10 Dec 2015 05:00:00 +0000The DB2 database system supports Transport Layer Security (TLS) and Secure Sockets Layer (SSL), which means that a DB2 client application that also supports SSL can connect to a DB2 database by using an SSL-protected socket. The TLS/SSL connection in the Call Level Interface (CLI) can be established by using server authentication or client authentication. This article discusses how to configure a TLS/SSL connection on a client and a server for the different types of authentication and discusses how the TLS/SSL connection process has been simplified.
03 Dec 2015 05:00:00 +0000An application's poor performance is sometimes caused by a performance problem in a database. The way that the Structured Query Languages (SQLs) in the database are performing will give you a good indication of how the database is performing. In this article, learn how to query your SQLs to see how they are ranking and to identify possible performance issues in DB2 for Linux, UNIX, and Windows databases.
26 Nov 2015 05:00:00 +0000As new kinds of devices connect to the internet, they generate petabytes of data every day. Companies analyze this valuable data to better understand and meet their customers’ needs. Streaming big data analytics gives users the ability to analyze data in real time, which is useful in time-critical applications like fraud detection. In this article, learn how to use the Spark Streaming platform for real-time keyword detection.
20 Nov 2015 05:00:00 +0000Enterprises need real-time, trusted data to make decisions and stay competitive. Data loss is unacceptable, but the process to collect and synchronize data must have little to no effect on production environments. This article shows you how to use a remote journal to configure IBM InfoSphere Data Replication (IIDR) for IBM i. This trusted solution will help you effectively gather data without affecting your other business functions.
12 Nov 2015 05:00:00 +0000Learn how to use the IBM InfoSphere Master Data Management (MDM) Application Toolkit to create basic services in IBM Business Process Manager (BPM) and to implement error handling.
01 Nov 2015 04:00:00 +0000In a side-by-side comparison table, the authors make it easy to understand the basic licensing rules, functions, and feature differences among the members of the distributed DB2 10.5 for Linux, UNIX, and Windows server family as of June 14, 2013.
23 Oct 2015 04:00:00 +0000Choosing the best file format for your development scenario can help improve performance. Apache Parquet is a columnar storage file format available to any project in the Hadoop ecosystem. Parquet is especially useful for complex, nested data structures because it supports efficient compression and encoding schemes. Learn how to use the Parquet file format with IBM InfoSphere BigInsights Big SQL and see examples of its efficiency.
08 Oct 2015 04:00:00 +0000IBM InfoSphere Data Architect is a collaborate design solution that lets you discover, model, relate, and standardize diverse and distributed data assets. We created a list of essential resources to help you get up and running with InfoSphere Data Architect.
01 Oct 2015 04:00:00 +0000This is the first tutorial in a series that describes how to integrate IBM Business Process Manager (BPM) and IBM InfoSphere Master Data Management (MDM). Specifically, this series refers to IBM BPM 8.5.5 and the IBM InfoSphere MDM Application Toolkit, both of which are provided with InfoSphere MDM 11.4. Get an overview of how to use the InfoSphere MDM Application Toolkit (MDMAT), including basic considerations and tips for how to use it effectively.
01 Oct 2015 04:00:00 +0000Build applications in Scala that access IBM Data Servers like IBM DB2 for Linux, Unix and Windows, IBM DB2 for z/OS, IBM Big SQL, IBM dashDB, and IBM Informix. This article includes sample code and instructions for creating Scala applications that access IBM data servers using IBM Data Server Driver for JDBC and SQLJ. I discuss multiple implementation options as samples of different approaches that you can take to create such applications.
21 Sep 2015 04:00:00 +0000A new era of applications focused on mobile devices is becoming increasingly important in large enterprises. Learn how you can build a DB2
11 Sep 2015 04:00:00 +0000This article explains with a hands-on laboratory exercise how to backup and recover in DB2 for z/OS. It shows in a concise way how to create backups of DB2 and how to recover lost data, using DB2 utilities and JCL (Job Control Language). An excellent method to show a customer how to use the backup and recovery features of DB2 and get him or her familiar with it.
09 Sep 2015 04:00:00 +0000This article is useful for testers who are planning to install and set up IBM Campaign for use with the remote Oracle Database 12c server. This document contains only those changes that are required for Oracle Database 12c and not the complete set of steps of Campaign installation and configuration.
04 Sep 2015 04:00:00 +0000IBM High Availability Disaster Recovery (HADR) for DB2
27 Aug 2015 04:00:00 +0000HADR standby databases are typically used as dedicated reporting databases for reducing load in a primary database. However, databases holding large-object (LOB) data have issues in replication, such as LOB data not getting replicated in a HADR standby database. LOB inlining can resolve the problem to some extent. LOB data of less than 32 KB will get replicated to a standby database and can then be fetched, but LOB data of more than 32 KB cannot be replicated in a standby database, so reports searching for LOB data with the larger size will fail in the standby database. Issues like query cost become higher for those queries accessing non-LOB column data of the same table, holding the LOB column, where inlining is performed. A higher query cost may slow down the system and should be analyzed for additional index creation. This tutorial will explain the steps for inlining, checking the errors found before and after inlining, and the resolution of the high query cost issue.
17 Aug 2015 04:00:00 +0000DB2 BLU Acceleration can provide performance improvements ranging from 35x to 73x and beyond for analytical queries with minimal tuning. In the mixed environment between OLTP and OLAP called OLTAP, DB2 shadow tables can be used to leverage BLU Acceleration without sacrificing OLTP performance. On the other hand, there are some restrictions such as data types. Though most data types are supported, some data types such as LOB and XML are not supported. For example, if your fact table contains invoice PDF data stored in a BLOB column, you cannot use BLU Acceleration as it is, which means you cannot create tables such as column-organized table. But there are ways to leverage BLU Acceleration even in such cases. This article guides you through those steps.
13 Aug 2015 04:00:00 +0000DB2 for z/OS delivers innovations in operational efficiency for out-of-the-box savings, business resiliency, warehouse deployment and enhanced business analytics. DB2 for z/OS is a cost effective, simple and proven database which offers 24x7 availability, reliability and security. This white paper illustrates how to use InfoSphere DataStage to access DB2 for z/OS database systems. It also provides insights into the performance of different connectivity options and presents valuable best practice recommendations.
07 Aug 2015 04:00:00 +0000Docker is one of the most popular cloud computing technologies due to its revolutionary container technology. It makes it easier for developers to assemble applications from components and ship them in lightweight containers. IBM UrbanCode Deploy automates the application deployment process. See how we use them together to produce a winning solution for making continuous delivery of an application easy.
04 Aug 2015 04:00:00 +0000What's a timeron worth to you? Who knows? DB2
28 Jul 2015 04:00:00 +0000Companies have access to more data than ever, but the data is often in disparate systems and dissimilar formats. Put this growing volume of data to work generating real-time insights that lead to meaningful actions. Learn how IBM's Analytics Mediation Platform (AMP) helps customers in the mining industry gain more control over mining operations, accounting, and production predictions.
23 Jul 2015 04:00:00 +0000A description of the various features available within IBM Cognos Active Report and how they can be used to create and distribute interactive reporting applications.
14 Jul 2015 04:00:00 +0000Learn how Guardium
14 Jul 2015 04:00:00 +0000The IBM z13 hardware provides a new SIMD unit. This article describes how to use the IBM z/OS XL C/C++ language to take advantage of the new processor and exploit the enhanced parallelism it offers. This article also provides an overview of the new data types, the operations that can be done on those data types, and the built-in functions to make vector programming easier.
02 Jul 2015 04:00:00 +0000This tutorial shows how to deploy the SAP side components of the InfoSphere
30 Jun 2015 04:00:00 +0000This article illustrates the steps required and best practices to find duplicates in data using IBM InfoSphere
25 Jun 2015 04:00:00 +0000IBM DB2
18 Jun 2015 04:00:00 +0000The fix-pack update for DB2
11 Jun 2015 04:00:00 +0000InfoSphere
04 Jun 2015 04:00:00 +0000DB2 tables are meant to hold enormous amounts of data for application testing, development, and production purposes. But at times, the need arises to design the table to hold just one row at a time dynamically. This tutorial introduces the basic concepts of having a DB2 for z/OS table hold one row.
03 Jun 2015 04:00:00 +0000In the SaaS environment, data information and services are the key to customer success. HP
03 Jun 2015 04:00:00 +0000In the SaaS environment, data information and services are the key to customer success. HP
29 May 2015 04:00:00 +0000This tutorial focuses on predictive analytics using IBM SPSS
08 May 2015 04:00:00 +0000The dashDB Service available in IBM Bluemix provides a powerful, easy-to-use, and agile platform for business intelligence and analytics. It is an enterprise-class managed service that is powered by the in-memory optimized, column-organized BLU Acceleration data warehouse technology. This article demonstrates how easy it is to incorporate the dashDB service into your application so that you can focus on your application.
08 May 2015 04:00:00 +0000The dashDB (formerly known as Analytics Warehouse and BLU Acceleration) service provides data warehousing and analytics as a service on IBM Bluemix. Developers can develop and deploy a heavy-duty analytic application using blazing-fast IBM BLU database technology offered in the cloud. Learn how to develop a data mining application using the Weka statistical analysis tool and leveraging the IBM BLU columnar database.
07 May 2015 04:00:00 +0000You have probably heard how DB2
07 May 2015 04:00:00 +0000Great news for people who want to write portable applications! This reference makes it easy for you to develop applications using SQL that is portable across the DB2 database family, including DB2 for z/OS Version 11, DB2 for i Version 7.2, and DB2 for Linux, UNIX, and Windows Version 10.5.
05 May 2015 04:00:00 +0000Check out the latest almost-ready-for-prime-time boilerplates and services on IBM Bluemix, including selections from integration testing, data management, content management, application quality, and application infrastructure.
30 Apr 2015 04:00:00 +0000InfoSphere
23 Apr 2015 04:00:00 +0000IBM DB2
16 Apr 2015 04:00:00 +0000Readers for the first time can explore the new data growth architecture and self-service features of InfoSphere
14 Apr 2015 04:00:00 +0000Data storage is no longer a warehousing issue; implicit in the new world of data everywhere is the implied ability to find, access, and use that data in an efficient manner. Much of that data exists on a cloud, so you need to know how to make sure data storage is optimized and doesn't become a weak link in your cloud platform. Storage techniques and software tools can help you achieve data and database optimization, and help to manage virtualized data storage through the software layer. This article explores what storage optimization tools can do for you.
09 Apr 2015 04:00:00 +0000The IBM Hardware Acceleration Lab and the InfoSphere
02 Apr 2015 04:00:00 +0000Learn the details of what makes each edition of IBM
02 Apr 2015 04:00:00 +0000After your database is encrypted with DB2 native encryption, learn to manage your master keys to ensure that they are secured and protected. DB2 native encryption is available through the DB2 Encryption Offering as of DB2 10.5 Fix Pack 5. It supports master key management based on the public-key cryptography standard 12 (PKCS#12). This tutorial provides an easy-to-follow step-by-step guide to manage a GSKit PKCS#12-compliant keystore.
31 Mar 2015 04:00:00 +0000In the first installment of a five-part series on data-integration standards and technologies, Brian Sletten introduces the Resource Description Framework (RDF) as the basis for a new set of standards called Open Services for Lifecycle Collaboration (OSLC). As part of the World Wide Web Consortium (W3C) Semantic Web technology stack, RDF is designed to facilitate information integration among multiple participants without the need for extensive precoordination.
26 Mar 2015 04:00:00 +0000This tutorial explains how to implement InfoSphere
23 Mar 2015 04:00:00 +0000A geobrowser for DB2, Informix and Netezza is now available as a free download. You can easily list tables containing spatial data and select the tables to be displayed as a map using a combination of points, lines and polygons. The color, symbols, linestyle and shading are user selectable. Map navigation tools allow you to zoom in and out, pan the map and select and display the alphanumeric values associated with each graphic object. The geobrowser can render the results of spatial analysis using DB2, Informix or Netezza. Application developers can use these components to construct custom spatial visualization applications. This tutorial shows you step-by-step how to use the free geobrowser to visualize data from DB2 tables.
20 Mar 2015 04:00:00 +0000IBM Data Server Manager is a new, integrated tool for managing performance and administering DB2
06 Mar 2015 05:00:00 +0000This article shows how to apply Model Driven Architecture principles to accelerate the design and development of Java Enterprise Applications that use mainstream technology, such as Java Persistence API, Enterprise Java Beans and Java API for RESTful Web Services. It investigates each step of the model-driven development process from the initial domain design to the generation of EJB 3.0 and JAX-RS design and implementations.
01 Mar 2015 05:00:00 +0000This series of tutorials takes you through common tasks that work with spatial data in the DB2/reg> Spatial Extender. These tasks include importing and creating spatial data, constructing and executing spatial queries, working with IBM spatial tools, working with third-party and open source software, improving application performance, and taking special considerations in a data warehouse environment.
13 Feb 2015 05:00:00 +0000Learn how to create a simple Node application that uses the IBM Object Storage service for Bluemix. The application shows how to obtain access tokens for a user, create a folder, and upload a document. In the application code, you also find code blocks to handle requests such as list folders of a user, list documents in a folder, delete a document, and other requests. Using what you learn in this tutorial, you can quickly and easily develop great applications using Object Storage.
04 Feb 2015 05:00:00 +0000Are you trying to license your IBM DB2 10.5 for Linux, UNIX, and Windows servers correctly in a high availability environment? Do you need help interpreting the announcement letters and licenses? This article explains it all in plain English for the DB2 10.5 release that became generally available on June 14, 2013.