(Willie Favero) I have a great one this afternoon. When I mentioned this APAR a few weeks ago it was still open. Well, APAR PK45916 has now been closed. This APAR eliminates the need for SORTNUM. The short description taken directly form the APAR cover letter: “DB2 utilities CHECK DATA, CHECK INDEX,
Other News
Faceted navigation for document discovery
(Alan Marwick) While there are several different ways for a user to specify metadata conditions, this article discusses one that has special advantages: faceted navigation. Follow the faceted navigation system described in this article, a technology demonstrator based on IBM Omnifind Discovery Editi
How to check MySQL Config files
(Peter Zaitsev) Probably most of MySQL users sometime had a situation when they would do changes in MySQL config file without restarting server (may be matching SET GLOBAL command to do it in run time) but either because option is misspelled or because given version does not support such option the
Installing Oracle on Linux is too difficult
(Rex Baldazo) So even though I’m not working in an Oracle environment any longer, I still want to maintain and expand my Oracle skills a bit. But now I won’t have a company-sponsored Oracle database to use, so I needed to set up an Oracle database myself. I first thought I’d use a Linux box for Orac
Scoping with SQL Types
(Andrew Clarke) The scoping rules for function calls are quite clear. Given a package with a function which has the same name as a standalone function, another function in that package will call the packaged function not the standalone one:
Differences and Similarities Between Index Coalesce and Shrink Space
(Richard Foote) As already discussed, ALTER INDEX COALESCE in 10g onwards works in a very similar manner to ALTER INDEX SHRINK SPACE.
Tricking SQL Server into making full database backups
(Jason A. Gerrish) Perhaps the most frustrating environments to work in are those in which improvement and automation take a back seat to consistently urgent fire-fighting tasks. Having the time, ability and capability to make process enhancements and produce beneficial tools, automation and monitor
Bulk Import Optimizations (Minimal Logging)
(Sunil Agarwal) In the previous blog I had listed all bulk import optimizations. Now, I will describe each of these optimizations in a separate blog entry. Let me first start with minimal logging. By the way minimal logging is also called bulk-logging but the correct term is ‘minimal logging’ while
Working with DEFAULT constraints
(Armando Prato) I have a DEFAULT defined on a table column and I have to create a script to update this DEFAULT to reflect a change in business requirements. I tried an ALTER TABLE statement, but that generates a syntax error. How can I easily redefine DEFAULTs?
Tips for using SQL Server 2005 bulk copy
Featured Article(s) Tips for using SQL Server 2005 bulk copy Here are some helpful tips to performance tune and optimize SQL Server 2005 bulk copy. Changing DBAs… In continuing the look at the need to move into new technologies (or the perceived need anyway), I wanted to pass along a couple more notes from SSWUG readers. From Brandon: "I have […]