According to a report from econsultancy.com 34% of shoppers prefer to buy online.  As buying habits change and consumers move more towards online shopping, the need for a robust and scalable IT infrastructure becomes greater.  According to Internet Retailing, internet retail sales in the UK hit £49.8 billion, up 21% from 2008. Overall, up to [...]

This document provides an example of installing and upgrading TM1 9.5 including TM1 9.5 Server, TM1 9.5 Web, and TM1 9.5 Contributor. This example is performed on a Single Server running MS Windows XP 32-bit and using IIS and Apache Tomcat.

No more subtle hints at the end of this blog. July 22, 2010 has arrived. With it, IBM's latest (and maybe greatest) mainframe has arrived also. The IBM zEnterprise System; their hybrid mainframe. With 96 5.2 GHz processors, up to 3 TB of memory... more to come...

The IBM Data Server .NET Provider supports application development for IBM Informix. It is available for download as part of the Informix Client Software Development Kit (SDK). This article describes the two .NET providers that support .NET application development for Informix, and highlights the benefits of using the Data Server .NET Provider. The article also provides examples to help you quickly get started using the IBM Data Server .NET Provider.

The concept of shell sharing between Eclipse-based products means that you can share the core Eclipse components so that they are not duplicated between each Eclipse-based product. Shell sharing can save disk space, eliminate duplication of components, and enable products to interact with each other, making each product stronger than if it were run stand-alone. This article explains the process of sharing Eclipse shells between many different IBM products by showing an example of this using InfoSphere Data Architect (IDA), Optim Development Studio (ODS) and Optim Database Administrator (ODA).

Get 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.

If not, why not? This could be one of the more significant events being held this year... maybe even in the last decade.

No, I'm not going to discuss SQL performance best practices, although it does seem that SQL tuning is something I get more calls for every week. No, for this post I'm just going to point you to a short blurb out on the IBM support web.

By Clair Ross Following on from James Gill’s recent blog post about the Coupling Facility today I’m sharing with you our experiences of working with Insert Load & Replication in DB2 pureScale.  In order to test the load capacity of the IBM DB2 pureScale machine we needed some test data and lots of it!  Being somewhat familiar [...]

This document is intended as a guideline on how to use IBM Cognos 8 as a data source to build IBM Cognos 8 BI Transformer PowerCubes.

New, cool, and simple to useÂ… What else could you ask for? Oh, not enough, you want even moreÂ… How about, it will make your life as a DB2 DBA or DB2 security administrator simpler and more productive. Just how, you might ask? IÂ’ll tell you howÂ…

This article gives an end-to-end example of how an Open SQL query that handles arbitrary JOINS between SAP tables that are not known during coding time can be executed dynamically. You will learn how joins are done in Open SQL, how to specify the needed clauses of this statement during runtime, and how to dynamically create the target structure that is needed with the help of the RTTS (Run Time Type Services) API of ABAP. Specifying Open SQL conditions with joins during execution time has many applications, including when the queries are only known during runtime. Data extraction and data browsing of the SAP system are examples. In another example, specifying queries dynamically helps if the main application logic is not implemented in ABAP code but in a remote program. In this case, this article describes how only a small generic ABAP program is needed, and the SQL queries can be maintained externally.

IBM Informix 4GL is a comprehensive development and production environment for creating sophisticated database applications. The 7.50.xC4 release of Informix 4GL includes direct support for file I/O without requiring function calls in another language such as C. This article describes the advantages of using the direct I/O support and provides you with an introduction to how you can use it with operations such as OPEN FILE, CLOSE FILE, READ, WRITE, and SEEK. The article includes code samples that can help you get started with implementing the file I/O feature in your own applications.

The IBM Enterprise Content Management Widgets (ECM Widgets) product is gaining traction in banking, insurance, health care, and many other fields. The ease of use and programming-free nature of the widgets enable business application developers to quickly produce content management applications. For industry solutions that require customized widgets, developers can build new widgets to meet their own business requirements. These customized widgets can be easily integrated into the ECM widgets environment by events wiring. In this article series, learn how to develop custom widgets to integrate them with four ECM widgets to build powerful solutions. Part 1 details how to use events of the In-basket widget and how to develop a role selector widget to work with the In-basket widget.

pureQuery improves application throughput on DB2(R) for z/OS(R) by making it easy to deploy static SQL for Java(TM) for any new or existing application. For new applications, this can be accomplished by using the pureQuery DAO interfaces and annotated methods. The client optimization feature enables capture and bind of SQL in any Java application, including those using a framework. This article has been updated with the latest performance numbers from the Version 2.2 release of the Optim(TM) pureQuery Runtime.

In his latest article for Database Journal Julian Stuhler shares his pick of the most important current trends in the world of IBM Information Management. Some are completely new and some are evolutions of existing technologies, and he’s betting that every one of them will have some sort of impact on data management professionals during the [...]

Yes, another addendum.. What can I say, I like the word.... err, I mean I like keeping things as complete as possible. In my post last week on DFSMS ("DFSMS; I think it may actually catch on", I discussed the DB2 catalog and DB2 directory moving to DB2 managed control or SMS controlled. That could be an "Oh my goodness..." to some because I left out what might be a pertinent piece of information. What does DB2 1

Private protocol was introduced more than 20 years ago in DB2 V2.2 giving us a way to talk between mainframe DB2 subsystems. Although private protocol was limited to dynamic SQL only and never did support stored procedures once they arrived, it did open the DB2 doors to distributed processing. It did have one very nice feature that would end up keeping private protocol hanging around for quite some time; three-part names. A feature DRDA (Distributed Relational Database Architecture) wouldn't have for another 1

As I'm sure you know, "A rose by any other name would smell as sweet" is a quote by good old William Shakespeare from a little thing he wrote entitled "Romeo and Juliet"; you may have heard of it. What does it have to do with DB2? If I really stretch your imagination a bit, I can tie it into the names DB2 has had over the years.

Everyone likes to talk about DB2 performance. And if it's not performance, it's SQL and Application stuff. There are even long conversations about installation, migrations, backup and recovery, and disaster recovery. However, you just don't hear all that much about security. Yes, it's out there.. just not as much as I think it should be.