|
|
| |
SSWUG Articles
DB2 History 101: Version 2.1
|
(Willie Favero) This is the first new version of DB2 delivered since its initial release. It was announced in April, 1988 and went generally available (GA) in September, 1988.
|
Still looking for open source DB2 monitoring tools?
|
(Fred) It's fun when somebody crashes a dull party, and very few parties have been more dreary over the past few years than the gathering of open-source monitoring tools that work out of the box with
|
CodeSnip: Selecting the nth Record from a Table Using Oracle
|
(Deepankar Sarangi) In this code snippet, the author examines the usage of Oracle's ROWNUM keyword to select the nth row of a table. It also deals with the other possible methods of selection along wi
|
Navigation using Treeview Control and SQL Reporting Services 2005
|
(Michael Richards) I spent several hours sifting through article after article about how to build tree navigations dynamically. They assumed that the order of the data coming in was 'orderly' and that
|
Ecommerce Functions in XPath
|
(Jennifer Kyrnin) There are many advanced functions of XPath to allow you to manipulate your XSLT. These functions help you reduce the amount of programming you need to do after transforming the data.
|
Extend WebSphere Portal with OmniFind Enterprise Edition search solution
|
(Ajay Wanchoo) Learn how to implement IBM OmniFind Enterprise Edition as a search engine with IBM WebSphere Portal. This tutorial introduces the two products, describes the advantages of using them to
|
Add automatic content classification to your IBM FileNet P8
|
(Xiaomei Wang and Shirley Braley) Concerned about records compliance and legal discovery effectiveness? Challenged by maintaining consistent and reliable access to content items in various repositorie
|
Use IBM Rational Data Architect to model your Oracle databases
|
(Anson Kokkat) Find out why IBM Rational Data Architect is gaining momentum as a database modeling tool that is optimized for IBM databases, yet also provides functionality to model other major databa
|
An addendum to Monday's History 101 post on DB2 V1.2
|
(Willie Favero) In our discussion of DB2 Version 1 Release 2 on Monday, I forgot to mention a significant change in V1R2 that most would have probably never noticed. It was one of those changes you go
|
Package Cache in DB2 LUW
|
(Manoj K Sardana) I was a little busy from past sometime so didn't get a chance to post anything. There are a lot new things I read from last 1 month. There are some interesting posts from Susan Visse
|
DB2 History 101: Version 1.3
|
(Willie Favero) After only 14 months, a new release (DB2 V1 R3) went GA on June 26, 1987. Even in that short period of time, there were lots of changes made to DB2. The GA announcement of DB2 V1.3 was
|
Cool New Features in DB2 for LUW V9 : Part 2 : Auto Updating Timestamps
|
(Philip Nelson) I promised you two "cool new features" in my last post. I ran out of time after the first of these, and it has taken me a few days to get round to adding the second : so here it comes.
|
Running XQuery from the Command Line with JRuby
|
(Matthew) During daylight hours, I work on a CMS.
We use XQuery to transform a lot of our display-agnostic XML content to be more UI-friendly. We use XOM as our XML parser and Nux as a bridge betwe
|
Loading XML data in Flash using ActionScript
|
(Blue_Chi) XML can be used to load external data in Flash to provide an easy method for structuring content so that it is easy to understand, process, and update. This tutorial will teach you the basi
|
Mimicking Production Database
|
(Radhesh Kumar) If you are a DB2 DBA, most likely you have already used db2look to extract the DDL from a DB2 database. However, db2look can do more than just extracting the DDL. Sometimes you may wan
|
Oracle Database 11g: SQL Plan Management, Part 1
|
(Jim Czuprynski) Oracle Database 11gR1 introduces SQL Plan Management, a new set of tools that allows an Oracle DBA to capture and preserve the most efficient execution plans for any SQL statement, th
|
DB2 History 101: Version 1.2
|
(Willie Favero) Even though DB2 V1.1 had only been GA for 10 months, Database 2 (DB2) Version 1 Release 2 was announced on February 4, 1986. Just one month later on March 7, V1.2 went GA. Since DB2 ha
|
DB2 Backup Basics - Part 3
|
(Chris Eaton) So far we have discussed backup syntax including targets and backup types and some options for backup. In this posting let’s look at a few other options on the backup command.
|
XPath for HTML
|
(Victor Zverovich) This article presents an implementation of XPathNavigator that can be used to perform XPath queries over HTML documents.
|
Compression Strategies
|
(Sunil Agarwal) In the previous blogs, I had described the data compression in SQL Server 2008 and its implications on CPU and IO. One of the question that keeps coming up is ‘Should I compress my dat
|
|
|
|