(Neeraj Nagpal) It is difficult to keep track of critical things like backup, space, and error logs in large environments. Different database management tools from third party vendors can help you monitor these but the tools are normally expensive. There is an inexpensive alternative. In this se
Author: SSWUG Research
Best Practices for Printer Management in the Oracle E-Business Suite
Managing printers within the Oracle E-Business Suite is challenging. In this paper, we will discuss tips and tricks to reduce printer setup and management effort and how to enable users to print Oracle output to any local or network printer. (R)
PyQT: Handling Windows and Buttons
(A.P.Rajshekhar) In this article, you will continue to learn about the process of building a GUI in PyQT. Specifically, you will learn about QDialog and QPushButton, which handle windows and buttons, the building blocks of most GUIs.
XML Storage – Part 2
(Chris Eaton) In the last post I described the motivation for using a completely new storage engine within DB2 for storage and management of XML data. In this post I will describe the storage in a bit more detail along with the syntax for using an XML datatype.
Optimizing Queries with Operators, Branching and Functions, continued
(Jon Stephens and Chad Russell) We are now going to look at a number of MySQL functions. Again, the focus here is on the central premise of this chapter: replacing programming logic with SQL logic is a key optimization skill, and it is almost always the best course of action to make the database per
Staying Power, Part 2
(Robert Catterall) In my previous column, I covered DB2 high availability in terms of dealing with “localized” failure events: situations that can be disruptive but don’t incapacitate an entire data center, such as server or disk subsystem failure or the abnormal termination of an operating system o
ISV success with DB2 Viper
(Louisa Ford) DB2 Viper has been designed to permit ISVs to focus more on application development and less on database configuration and administration. The new and enhanced development tools will make it even easier for developers to rapidly develop and deploy database applications, and the signifi
IBM DB2 Content Manager for iSeries, Part 6: Customize eClient
(Jack Boswell) The eClient is a Web application that enables users to search for and retrieve documents from content servers. Learn to customize your eClient application to meet the needs of your organization. (pdf)
A DBA’s view on SQL 2005 Database Snapshots
(Andrew Calvett) Database Snapshots are a new Enterprise Edition-only tool, introduced in SQL 2005, that provide a read-only, “virtual” copy of a database, at a given point in time. This article will discuss how, as a DBA, you might use snapshots in a production environment and why you might not con
Facilitating Information Sharing Using Meta-Data
(Patrick Cross and Booz Allen Hamilton) Information sharing has consistently been a significant problem across government and industry. Once IT portfolios grew beyond a few simple applications the need to share and integrate information across those applications has grown along with the increase in