You shouldn’t care where your data resides, or which computer processes your request. You should be able to request information or computation and have it delivered – as much as you want, and whenever you want. This is analogous to the way electric utilities work, in that you don’t know where th
Other News
Managing Geographic Raster Data Using GeoRaster
GeoRaster is a feature of Oracle Spatial in Oracle Database 10g that lets you store, index, query, analyze, and deliver GeoRaster data, that is, image and gridded raster data and its associated metadata. GeoRaster provides Oracle Spatial data types and an objectrelational schema. You can use these d
INSERTS from DTS to DB2 Through OLE DB Provider for DB2 May Not Work Correctly
If a DTS package is built to export a SQL Server table to DB2/MVS (version 5.1) by using the Microsoft OLE DB Provider for DB2 (DB2OLEDB) and the AUTOCOMMIT property of the provider is set to FALSE, the following error may be reported: [OLE/DB provider returned message: A SQL error has occurred.
Java interview questions
What are synchronized methods and synchronized statements? Synchronized methods are methods that are used to control access to an object. For example, a thread only executes a synchronized method after it has acquired the lock for the method’s object or class. Synchronized statements are similar to
DB2 Basics: Demystifying table and table space states
(Roman B. Melnyk) DB2 uses table and table space states to control access to data or to help protect the integrity of the database. This article describes these states and shows you, by way of working examples, typical conditions under which they appear, and how to respond to them.
For Your Eyes Only
(Sean Maloney) Congratulations on your new job! You are the new database analyst for MedicalDb Company, and the CEO is making you responsible for selecting and implementing a secure patient-records privacy solution. Success means that your solution works well, saves the company from expensive li
Rinse, Lather, Repeat: Utilizing Recursive SQL on DB2 UDB for z/OS
(Daniel L. Luksetich) While recursive SQL will become a reality for mainframers with DB2 UDB for z/OS Version 8, it has been available on DB2 UDB for Linux, Unix, and Windows for quite some time. This very powerful SQL construct can be utilized to quickly solve many business functions, and will
Turn Off AUTO_CLOSE
(Brian Moran) My SQL Server logs contain messages such as “2003-12-01 21:34:56 50 spid51 Starting Up Database ‘IhateSpam’.” Is it typical for SQL Server to constantly restart all my databases? (R,$)
Every DBA Should Know Which Databases are be Backed Up
(Leo Peysakhovich) Every DBA knows that databases should be backed up. SQL Server provides some powerful mechanism for the database backups called ‘Database Maintenance Plan’ to support scheduled full and log backups. It is easy to create a plan to backup all user and system databases. The probl
DB2 Java connectivity with JDBC
(Kulvir Bhogal and Grant Hutchinson) DB2 UDB provides for JDBC connectivity through a number of Java classes and interfaces that implement the JDBC specification. The implementation is known as a JDBC driver. DB2 currently offers JDBC drivers known as legacy/CLI drivers and the universal JDBC driver