(Paul Zikopoulos) In this new series, we are exploring the integrated development environment (IDE) of IBM Data Studio (formerly known as IBM Data Server Developer Workbench during the open beta), which is new with DB2 9.5 (formerly known as DB2 Viper 2). In Part 1 of this series, we looked at how t
Other News
The curse of gapless sequences
(Gints Plivna) Gapless sequences usually are one of the best examples of bad requirements gathering process. Gapless sequences means: 1) single serialization point for inserts (in one table usually) and 2) thus seriously reducing scalability and 3) thus resulting in bad performan
Choosing innodb_buffer_pool_size
(Peter Zaitsev) My last post about Innodb Performance Optimization got a lot of comments choosing proper innodb_buffer_pool_size and indeed I oversimplified things a bit too much, so let me write a bit better description.
Validate data types in U2 using XML schema
(Michael Rajkowski) IBM U2 (IBM UniData and IBM UniVerse) stores all of its data without any type validation. Thus the same field can contain an integer, a string, or even an internal date structure. While this may be useful to the application developer, it can cause problems when integrating the da
Oracle BI EE 10.1.3.3/2 – Using Image Prompts
(Venkatakrishnan J) Another question came up in the forums yesterday on how to place the images for Image Prompts. As you would know, there are 2 types of prompts in Answers. One is the Column Prompts and the other is the Image Prompts. In column prompts, one has the capability to select a value of
Getting DB2 Data From A to B
(Robert Catterall) It’s a fairly common challenge: you have an operational DB2 database (meaning, one that supports one or more of an organization’s core business applications), and a query/reporting database, and you want to make sure that the data in the latter stays fairly current with respect to
Using XSLT to Transform XML Using ASP.NET
(Sandesh Meda) This article demonstrates how to transform XML using XSLT in ASP.NET using C#. It explains the basics of XML, XSLT and how we could take advantage of XSLT in the web pages that use ASP.NET.
Introduction to IBM Data Studio, Part 1: Get started with IBM Data Studio, Version 1.1.0 and Eclipse
(Debra R. Eaton) Based on open source Eclipse technology, IBM Data Studio, Version 1.1.0 gives DB2 V9.5 database developers the ability to develop database application objects that access data in a number of data servers and replaces IBM DB2 Developer Workbench (DWB). Get an introduction to the Ecli
BIGFILE tablespace
In 10g release, Oracle came up with new type of tablespace called the bigfile tablespace. So far we were dealing with our traditional tablespaces right from the birth of the Oracle database. With the introduction of bigfile tablespace, traditional tablespaces are considered as smallfile tablespaces.
Developing a ASP .NET Control with client capabilities (using ASP .NET Ajax Extensions support)
(Brian J. Cardiff) Since the AjaxControlToolkit appears, creating extenders control like Autocomplete (AjaxControlToolkit) or Contextual Autocomplete (Web Software Factory) is a task that involves more work in JavaScript and Metadata that classic .NET programming.