(Dave Beulke) Within every DB2 LUW or DB2 z/OS systems there are things that always need to be cleaned up. Test systems with unused databases, production jobs that need their schedule tweaked, reorgs for tables or indexes that need to be analyzed and scheduled.
Other News
Building an HTML5 App with ASP.NET
(Stephen Walther) I’m teaching several JavaScript and ASP.NET workshops over the next couple of months (thanks everyone!) and I thought it would be useful for my students to have a really easy to use JavaScript reference. I wanted a simple interactive JavaScript reference and I could not find one so
Convert Excel 2007 XML to OASIS code lists
(Betty Harvey) Genericode—an OASIS specification—is an XML vocabulary for encoding code lists or authority lists in XML. These lists are usually developed and maintained by business users who are familiar with Microsoft Office solutions but are not proficient in XML technologies. In this article, ga
MySQL Cluster – Cluster circular replication with 2 replication channels
(Shinguz) A few days ago I had to deal with MySQL Cluster replication. I did not do this for a while so I was prepared to expect some interesting surprises once again.
A new BIND PACKAGE option for DB2 10 for z/OS
(Willie Favero) As long as packages have been around, if you didn’t specify something on the BIND PACKAGE command and that option was defined at the PLAN level, the package inherited what ever behavior was defined at the PLAN level. This includes the RELEASE option.
Modeling your business processes with IBM WebSphere Lombardi Edition, Part 1: Overview and Architecture
(Xi Ning Wang, Lei (Joyce) He and Liu Yu) In this series, you’ll learn how to use WebSphere Lombardi Edition V7.1 to model end-to-end business processes using a sample purchase order scenario. Part 1 provides an overview of the Lombardi features and architecture.
Reading sql_variant in Entity Framework
(dasblinkenlight) Although Entity Framework does not have built-in support for the sql_variant data type [1][2] of SQL Server, it is possible to work around this limitation. This article describes an approach that lets you read columns of type sql_variant using an Entity Framework EDM.
Converting a BIGINT datetime
(Mike Lewis) An application I support uses a BIGINT to store date and time data. Our installation is SQL Server 2005, so the lack of accuracy in the datetime data type is probably a driver behind this.
Finding performance problems using statistics
(James Koopmann) Statistics are at the core of determining whether your tuning efforts are working or if you still have a system that is suffering from performance problems. This article focuses on Oracle’s performance method to give us a better understanding of how to tune a database with statistic
What is the default for a METHOD_OPT value using SIZE REPEAT?
(Neil Johnson) Past experience has always led me to believe that a METHOD_OPT value of gFOR ALL COLUMNS SIZE REPEATh would default to gSIZE 1 on columns without statistics. I have never explicitly tested this default however so this is the quick test I did to put my mind at rest.