(Klaas) In episode #Z12 our special guest Dave Beulke (CEO Pragmatic Solutions, Inc. / IBM GOLD Consultant / IBM Champion ) shared a lot of his DB2 Data Warehousing tips and Tricks.
Other News
SQL SERVER – Denali – Three DMVs – sys.dm_server_memory_dumps – sys.dm_server_services – sys.dm_server_registry
(Pinal Dave) In this blog post we will see three new DMVs which are introduced in Denali. The DMVs are very simple and there is not much to describe them. So here is the simple game. I will be asking a question back to you after seeing the result of the each of the DMV and you help me to […]
Preemptive RowGuidCols on Merge Replicated Databases
(Michael K. Campbell) One thing I’ve started doing more and more frequently with Merge Publications is preemptively adding in a rowguid column to tables that I know will end up being published. Doing so can make a huge difference in the amount of time (and log space) that would occur otherwise.
IBM’s DB2 Analytics Accelerator for z/OS V2 announced today
(Willie Favero) Today, Wednesday, October 12, 2011 is a great day. Not because we had a nice turnout at our quarterly Houston Area DB2 User Group meeting, which we did, but because IBM had a significant product announcement today. Significant for me at least because it announces a product that is
Fun with ORDER BY clause
(Madhivanan) You can use Ordinal position in the ORDER BY Clause for sorting the resultset. The ordinal position refers the column position in the SELECT statement. Consider the following select statement
Understanding InfoSphere BigInsights
(Cynthia Saracco) Perhaps you’ve heard about InfoSphere BigInsights, IBM’s software platform for storing and analyzing “big data,” and you may be wondering what all the buzz is about. This article provides an introduction to BigInsights and explains what the product was designed to do, when it can b
More Code Lookup Options for Enumerations
More Code Lookup Options for Enumerations Following are more ideas for synchronizing Enumerations with database lookup tables. The goal is to have Enumerations usable in application code, validated at compile time, that have the same values as those of lookup tables in external data stores such as relational databases. Many have written to remind us that MySQL an other data […]
Save XML in a file | Read XML from a file
(manub22) Check the file in the directory set above in @filename variable.
ORA-01567: dropping log N would leave less than 2 log files for instance UNNAMED_INSTANCE_N (thread N)
(Anand) Recently we had a database refresh where a standalone db got refreshed from the 4-node RAC. After the completion of the refresh, saw 10 redo log groups.
DB2 Security – A Common Language for a Common Goal
(Craig S. Mullins and Rebecca Bond) One of the best aspects of the IDUG user community is our willingness to share knowledge. From a technical perspective, our common commitment to contributing valuable tips has served us well.