(Ganesh R. Gosavi) Are you planning to port your Oracle application to IBM DB2 for Linux, UNIX and Windows? Learn how to accomplish this task using the steps described in this article. Sample scripts are included to make the tasks easier.
Other News
Disabling the Submit Button Until a CheckBox is Checked
(Scott Mitchell) ASP.NET provides a variety of validation Web controls that can be used to validate a user’s form field inputs. Unfortunately, the validation Web controls do not work with the CheckBox or CheckBoxList Web controls. In a previous article, Creating Validator Controls for the CheckBox a
MySQL 5.1 partitions in practice
(Giuseppe Maxia) This article explains how to test the performance of a large database with MySQL 5.1, showing the advantages of using partitions.
Introduction to Locking in SQL Server
(Mladen Prajdiæ) Locking is a major part of every RDBMS and is important to know about. It is a database functionality which without a multi-user environment could not work. The main problem of locking is that in an essence it’s a logical and not physical problem. This means that no amount of hardwa
Oracle BI EE 10.1.3.3/2 – Presentation Variable in Report Titles
(Venkatakrishnan J) I thought of blogging about another pretty common question which keeps getting repeated in the forums. The question is “How do we refer the Presentation Variables in the Title of a report?”. Lets try to achieve that here. To take an example, i have a dashboard page containing a d
How not to re-use XML technologies
(William Vambenepe) I like XML. Call me crazy but I find it relatively easy to work with. Whether it is hand-editing an XML document in a text editor, manipulating it programmatically (as long as you pick a reasonable API, e.g. XOM in Java), transforming it (e.g. XSLT) or querying an XML back-end th
Getting One Record Per Group From A One-to-Many Join
(Ben Nadel) Often times in an application, I have wanted to output a simple list of items that have a one-to-many relationship with other items in the database. One scenario that I come across very often involves attorneys and offices; many attorneys will work out of more than one office, but in an
Create aliases to make MySQL administration easier
(George J. Trujillo Jr.) When working in a Unix/Linux/Mac OS environment, aliases can make things a lot easier if you are running the same commands over and over again. Here are a few aliases you can define to simplify running MySQL commands. Then just type the alias name. Put these in one of you
DB2 9 DBA Exam Sample Questions: Recovering a database and LBAC
(Roger Sanders) How ready are you for the DB2 9 DBA certification exam? Find out by testing your knowledge against these sample questions from the book DB2 9 for Linux, UNIX, and Windows Database Administration: Certification Study Guide, published by MC Press. The questions are reprinted here with
You cannot start the SQL Server Agent service of a failover cluster of SQL Server 2005 if the build of SQL Server is 3179 or a later build
Consider the following scenario: • You install and then configure a failover cluster of Microsoft SQL Server 2005. • The build of SQL Server 2005 is 3179 or a later build.