(Peter Blackburn and William Vaughn) Security can be a very large and daunting topic. It’s often difficult to understand and more difficult to get right. In our experience, developers often feel that they’re out of their area of expertise when people start discussing Public Key Infrastructure (PKI),
Other News
How Does Federated Technology Relate to Data Warehousing?
(Barry Devlin, Bill O’Connell, Pat Selinger and Hamid Pirahesh) Time and colums in this column, I have written about leading edge data warehousing using DB2 UDB and also about IBM’s recently-introduced product, DB2 Information Integrator, that features, among other things, IBM’s data federation capa
A Colorful Introduction to DB2 UDB Version 8 for UNIX, Linux and Windows
(Raul F. Chong) If you are new to IBM DB2 Universal Database(UDB) for Linux, UNIX and Windows, or are preparing to take the certification exams, this article may save you some time trying to grasp the main concepts about the DB2 environment. It is commonly said that a picture is worth a thousand
Data concurrency
This tutorial will introduce you to the concept of data consistency and to the various mechanisms that are used by DB2 Universal Database to maintain database consistency in both single- and multi-user environments. In this tutorial, you will learn: –What data consistency is –What transactions
Migration by Proxy
(Jonathan Gennick and Isobel Eckhardt) With Oracle9i marking the terminal release of the Oracle Names software, it’s time for all Names users to think about migrating to another naming method. The most logical migration path, if you want to maintain centralized name resolution, is to migrate to dire
Report: Oracle pricing won’t lure SQL Server users
(Robert Westervelt) Oracle’s new price incentives are a good sign that the company is beginning to acknowledge the demand for lower database costs, but it has much further to go if it wants to lure SQL Server users, according to a recent report by Boston-based AMR Research. (R)
Finding Local Time Zone in Oracle8i
(Krishna Sarabu) To convert date and time from the local time zone to any other time zone or vice versa, it is necessary to find out the local time zone of the database first. The NEW_TIME function in Oracle 8i converts the date and time value from one time zone to another time zone, but it won’t pr
XML DataTypes in SQL Server Yukon
(Suhil Srinivas) This article provides some elementary information about the new datatype in the latest release of SQL Server called Yukon beta 1. This article is a good starting point for any developer who is aware of SQL Server 2000 or any comparable database.
Alert! Alert! Backup and Restore Baby!
(Jeremy Kadlec) At many organizations I doubt red lights flash with the sound of blaring sirens when backups fail in production environments, but I believe at every organization backups are one of the most critical IT functions. Of all backups, database backups, by most accounts, are considered the
Setting up connectivity for ADO and ADO.NET application developers
(Jalud Abdulmenan and Raul F. Chong) This is the fifth article in a series discussing connectivity scenarios involving DB2 UDB for Linux, UNIX and Windows version 8, DB2 UDB for iSeries 5.2 and DB2 UDB for z/OS V8. The focus of this article is on workstation application development connectivity for