(Chris Eaton) In v8 IBM shipped a new problem determination tool called db2pd. The tool runs on Linux, UNIX and Windows platforms and can give you diagnostic information very quickly and in a very non intrusive manner. The tool does not take snapshots but instead attaches directly to the DB2 shared
Other News
Meet the experts: Mark Taylor on WebSphere MQ
(Mark Taylor) This question and answer article features Mark Taylor, technical strategist for WebSphere MQ, who answers top questions from users about developing applications for, or running systems with, WebSphere MQ (formerly MQSeries) on the distributed (non-z/OS) platforms.
Gotcha Lurking in Datalink File Manager for DB2/400
I’ve grown quite fond of the convenience of the DB2 SQL support in QShell, and especially the ease with which it can be invoked within a CL program, by simply calling the underlying Datalink File Manager DB2 program, QZDFMDB2. Having said that, I must also admit to getting burned by a “gotcha” lurki
Convert A MySQL Injection Script For Use In Microsoft SQL Server
(Lucas Green) MySQL Server is the most widely used database management system in the world, primarily because it is open source and free.
Build an Ajax application using Google Web Toolkit, Apache Derby, and Eclipse, Part 2: The reliable back end
(Noel Rappin) In this second article in the series on using the Google Web Toolkit (GWT) to build Asynchronous JavaScript + XML (Ajax) applications, learn how to build the Apache Derby database for your Web application, and use it to drive the GWT. Part 1 of this series introduced you to GWT and dem
Detect hierarchy loops with Oracle 10g’s new hierarchy pseudocolumns
(Bob Watkins) In a previous tip, I described how to sort the entries in a hierarchical query. For a hierarchical query to work, however, the data must not loop back upon itself. That is, a parent row may not list itself or one of its child rows as its own parent. If this were the case, Oracle could
Process and parse XML with ease using Jakarta Digester
(Melonfire) Most of the time, parsing an XML document involves either programming a parser to sequentially traverse an XML document, taking different actions as it encounters different tags (SAX) or building a tree representation of the document in memory and using tree methods to navigate the tree’
Dynamically Templated GridView with Edit, Delete and Insert Options
(G Mohyuddin) In many situations we want to bind a fully, in-place operational GridView with a dynamically changing data source. This article shows how GridView can be templated programmatically at run time and how is it possible to do edit, insert and delete operations on it. Although just binding
Index Build strategy in SQL Server – Part 3: Offline Serial/Parallel Partitioning (Aligned partitioned parallel index build)
In case of parallel build we scan and sort partitions in parallel and the actual number of sort tables existing at the same time will depends on the actual number of concurrent workers. Partitions are being chosen by workers one by one and when one worker completes with one partition it takes the ne
Clustered and non-clustered indexes in SQL Server
(Laurence Schwarz) When do I use a clustered index vs. a non-clustered index? This is somewhat of a tough question to answer, and frankly, the one I’m going to give is the age old standard database administrator’s answer; “It depends.” There are numerous factors into the when and where of index plac