(Ember Crooks) One of the features I would most like IBM to add into DB2 is the managing of TSA States through DB2 commands. I’m not a TSA expert, but I would like to find a class or opportunity to study it further. There are plenty of scenarios where I have to go in as root and run various commands
Author: SSWUG Research
DB2 10 for z/OS: Take Advantage of ‘Native’ SQL User-Defined Functions
(Robert Catterall) Lots and lots of mainframe DB2 people know about the native SQL procedure technology delivered with DB2 9 for z/OS.
Cancelling Slow Parallel Loop Iterations
(Richard Carr) Parallel loops can be stopped early due to an exception being thrown or by calling the Break or Stop methods of the linked ParallelLoopState object. These actions do not cancel any scheduled iterations, which can be problematic for slow processes.
Silent Installation of RAC 12c database
(Andrey Goryunov) Nowadays everyone is installing #db12c in different variants, posting screenshots, talking about a better tool to run GUI through.
MDX YTD Calculation Issus
(Mike Davis) If you are using the templates for MDX calculation built into SSAS 2008 you might run into some strange issues. In the image below you can see the calculation is working for all years except for 2008.
Searching For SSIS Packages
(Shaun J Stuart) SSIS packages are handy. They can do all sorts of things and the developers here use them a lot. One very useful feature is that you can set up connection objects in your package so it can connect to any of your servers to do what it needs to do. This is also one of their drawbacks.
(Kenneth Fisher) What the heck? Even indexes have WHERE clauses these days. I can’t remember what I was reading when I saw this but it completely flabbergasted me. If you go look at MERGE in BOL you will see what I mean. So does this mean you can’t restrict data in a MERGE?
Getting Started with Columnstore Index in SQL Server 2014 – Part 1
(Arshad Ali) Column Store Index, which improves performance of data warehouse queries several folds, was first introduced in SQL Server 2012. Though it had several limitations, now SQL Server 2014 enhances the columnstore index and overcomes several of those earlier limitations.
Regular Expressions (10): Position Characters a.k.a. Anchors
(Ged Mead) ‘Anchoring’ in this context means specifying whereabouts in an input string the pattern should be found. A common requirement is to find a pattern that exists at the very start of the input string.
Oracle SQL Developer and the Dreaded Connection Busy Message
(Jeff Smith) So you’re minding your own business, doing your work, and you click in your favorite Oracle Database IDE. Do you get what you asked for? No! Instead, you are rewarded for your troubles with this puzzling and frustrating message.