(Rajan Kumar and Brent Gross) The goal of this tutorial is to show UniVerse and UniData (U2) application developers how to develop a next-generation, master-detail ASP.NET Web application, Web service, and ASP.NET Crystal Report using IBM® Data Server Provider for .NET and IBM Database Add-ins. For
Tag: IBM
Upcoming IBM teleconference: Data governance: Get in-depth DB2 auditing for more confident compliance
(Willie Favero) I thought this no-charge teleconference might be of interest to some of you. It’s a few weeks away but I wanted to give you time to get it onto your calendar. Everything in blue is copied directly from the IBM announcement of the event.
The SQL Programming Language?
(Robert Catterall) During the mid-1990s, when I was with IBM, I did some consulting work for a large media company. These folks had a very sophisticated data warehouse set up, with DB2 for z/OS being at the heart of it all. One day, a person on the company’s data warehouse team asked me if I wanted
The information perspective of an SOA design, Part 2: The value of applying the business glossary pattern in SOA
(Brian Byrne, John Kling, Dr. Guenter Sauter and Peter Worcester) Do you find it challenging when simple terms cause your ideas about data integration to come across as confusing and ambiguous? This second article in the series "The information perspective of SOA design" helps you eliminate these mi
Prefetch on, prefetch off, prefetch on, prefetch off, prefetch….
(Willie Favero) Sequential prefetch has been a part of DB2 since Version 1.2. In fact, it’s hard to imagine getting along without. Even when the “R” in the plan table column ACCESSTYPE gets misinterpreted sometimes as a bad thing, if you’ve been around DB2 long enough you learn that an access using
IBM releases DB2 adapter for SQLAlchemy
(Antonio Cangiano) A while ago I informally announced IBM’s intention to develop an SQLAlchemy adapter for DB2 and Informix IDS. Today, I’m happy to inform you that we have a first working release for DB2 on Linux, Unix and Windows (LUW). Support for Informix IDS is next (almost done), and after tha
Generating daily usage statistics
(Bernd Kuennen) Sometimes you’ll want to know how many logins there’re on your web site and how the daily usage profile looks like. Usually the first attempt to evaluate this is to copy some log files or unload some database table which holds the login information and then import it to Excel or a si
Database applications made easy with WebSphere Application Server Community Edition, DB2 Express-C and Eclipse
(Anitha Krishnasamy and Sridhar Kuna) IBM WebSphere Application Server Community Edition provides excellent support for JDBC-enabled databases through a J2CA framework, making it easy for your application to access a backend database. This tutorial describes how you can easily develop a simple datab
DB2 Sliding Scale Space Allocation
(Troy Coleman) As a production support DBA I used to get weekly reports on dataset size and extents. The main purpose of this was to figure out which datasets are near the maximum number of extents and schedule an alter primary/secondary quantity and reorganize the table space or index space to redu
Becoming a Certified Informix Professional
(Eric Herber) Have you ever thought about becoming a certified IBM Informix professional? This article will give you an overview of the current IBM certification test 918 – System Administration for IBM Informix Dynamic Server 11.
