(Ofer Harel) There are some situations when a critical data or rollback segment is locked, but you cannot find the blocker session. In those cases you can suspect an in-doubt transaction. When you use the two-phase commit mechanism — such as using a joined query with dblink — there are some situat
Author: SSWUG Research
DB2 and C++ – True RAD with Borland C++ Builder
Author Bob Swart shows you how to get started using DB2 as a database for applications written with Borland C++Builder 6 Enterprise and dbExpress.
Tutorial: Converting IBuySpy to DB2 UDB
How easy is it to port a SQL Server .NET application to DB2 UDB? Take this tutorial and find out! Our authors take you step by step through the process.
Linux frenzy sweeps Oracle user conference
By John Geralds – Linux was the talk of the Oracle database user conference in the US last week, with firms looking at evaluating or moving corporate applications with database servers to run on the open source operating system.
Oracle Mounting Full-Scale Linux Assault In China
By Antone Gonsalves – Oracle is working with China’s leading Linux developer in building support for the open-source operating system in all of Oracle’s product lines.
The OS Factor
By Michael Otey – One aspect of database performance that’s rarely considered is the OS itself, which ultimately handles all I/O requests.
Identifying Stored Procedure Recompilation Problems in SQL Server 2000
Andy Novick discusses the reasons that SQL Server 2000 decides to recompile a stored procedure and demonstrates the tools and techniques that you can use to monitor recompilation. Read the article, watch the movie!
Luxury models face cost-conscious buyers
By Martin LaMonica – Software from Oracle and IBM–the top two sellers of database system by revenue–has long anchored the coveted high-end systems that are the backbone of big business, such as high-volume credit card transaction and airline reservation systems.But just as the leading data
DB2 failure prompts bank to set up extra disaster recovery
After software bugs took its systems down last month, Danske Bank is reluctant to rely solely on IBM recovery tools.Danske Bank has taken steps over and beyond industry best practices to avoid a failure in its IBM Geographically Dispersed Parallel Sysplex mainframe system.
Solving the Data Warehouse Puzzle
By Barry Devlin – How do you meet changing business intelligence needs without scrapping your data warehouse investments? Fitting federation into your existing system may be the answer.