Tuning and configuring a DB2 database can be a complex process that sometimes overwhelms new DBAs. There are, however, a great number of tools, functions, and applications included with DB2 that make this task much simpler. The release of DB2 Universal Database V8.1 includes new tools and informati
Author: SSWUG Research
Measuring resources for a MySQL server on Linux
(Giuseppe Maxia) Sometimes my customers (especially the ones who are used to different database servers,) ask me about the CPU and memory consumption of a MySQL server process.
A quick start with C# and Websphere MQ
(Laishram Priyokumar) This article is trying to help the developers who want to start integrating .NET applications with Websphere MQ. Here we are going to start with the simplest Queue process of putting a message to a queue and getting the same message back.
The Next Data Management Frontier: Unstructured Data
(Patricia Cupoli) At the April 2006 Wilshire Meta Data Conference/DAMA International Symposium, there were a number of presentations that dealt with metadata, ontologies (organization of knowledge and terms), semantics, controlled vocabularies and taxonomy/classification. You may ask why these topic
Oracle Partitions: Divide and perform
(Alf Pedersen) Oracle partitions addresses the key problem of supporting very large tables and indexes by allowing you to decompose them into smaller and more manageable pieces called partitions. Once partitions are defined, SQL statements can access and manipulate the partitions rather than enti
Hot Standby Security Configuration for Operational Reporting
(Roger Doherty) In my last post I talked about how I used SQL Server 2005 log shipping to create a hot standby of the Airframe production database to be used for both disaster recovery and as a data source for operational reporting. In this post I’ll discuss how to configure security on the product
Google Web Toolkit: AJAX Buzz Meets Real World Development
(Gautam Shah) Developing AJAX applications is really hard, because few developers have a complete grasp of JavaScript—the language of AJAX (Asynchronous JavaScript and XML). Making matters worst, every browser has idiosyncrasies in its JavaScript implementation, which introduces incompatibility nigh
Creating user profiles for the LPEX editor in WebSphere Developer for zSeries v6.0
(John Casey) In my previous article, Extending the LPEX Editor in WebSphere Developer for zSeries v6.0, I showed how to create and deploy a new LPEX action. To use the new action, you needed to manually identify the action and its shortcut key to the LPEX editor. With user profiles, you can eliminat
Singleton Pattern
(rajesh mg) In software engineering, the singleton design pattern is designed to restrict instantiation of a class to one (or a few) objects. This is useful when exactly one object is needed to coordinate actions across the system. Sometimes it is generalized to systems that operate more efficiently
SQL Server – Convert UTC to Local Time
(Chris Tillotson) SQL Server does not provide a simple way to convert a UTC datetime value to a local time value. This project includes a table (tbTimeZoneInfo) with data to provide the Time Zone information and two functions to convert a UTC datetime value to any Local Time Zone.