decor
 

planetDB2 logo

  planetDB2 is an aggregator of blogs about the IBM DB2 database server. We combine and republish posts by bloggers around the world. Email us to have your blog included.
 

January 27, 2012


Ember Crooks

Where do you find professional inspiration?

I don’t know about you but sometimes I get in “head-down just doing the basics DBA” mode. This just about always happens over the holidays when my retail clients are so busy and...

...

Nivasreddy Inaganti

db2 wallpapers- dbm cfg parameter listing

Below is the chart that you should pin to your cubes: It depicts: You can print the chart by going to the below URL DBM_cfg_print_URL

...

Willie Favero

The 2011 Master the Mainframe Contest has come to a conclusion

(Posted January 27, 2012) And the results keep right on improving...  we have a very smart kids out there with good futures in the world of computers should they choose to go the direction.  To paraphrase Darth Vader (Star Wars): “The Mainframe is strong with this g...

(Read more)

DB2Night Replays

The DB2Night Show #68: Problem Determination for SQL/PL, PL/SQL, & Triggers

Special Guest: Serge Rielau STSM, IBM Canada Destined for Top 25 of 2012! Replays available in WMV and M4V formats! 96% of our audience learned something! Our special guest, Serge Rielau, Senior Technical Staff Member at IBM Canada, shared with our audience advanced techniques for problem determination in SQL/PL, PL/SQL, and triggers - complete with demonstrations! And, the source codes are available! If you use these capabilities of DB2...

(Read more)

Triton Consulting

41-54% DB2 CPU Reduction Achieved using zIIP

In a current customer engagement we are enabling zIIP to reduce CPU consumption.  Our first overnight install has been a great success.  On the 1st mainframe LPAR (out of 4) we are seeing initial signs of 41-54% DB2 CPU reduction … Continue reading →

(Read more)
 

January 26, 2012


DB2Night Show News

2012 DB2's GOT TALENT Still Seeking 15 Contestant Applications!

I am very excited about the Contestant Applications we received today. A senior IBM employee will be talking about "How to debug a high CPU spike issue on a system" using core DB2 commands, and...

...

Craig Mullins

A Forced Tour of Duty

Mainframe developers are well aware of the security, scalability, and reliability of mainframe computer systems and applications. Unfortunately, though, the bulk of new programmers and IT personnel are not mainframe literate. This should change. But maybe not for the reasons you are thinking. Yes, I am a mainframe bigot. I readily admit that. In my humble opinion there is no finer platform for...

(Read more)

DB2Night Show News

Join us for Episode #68 of The #DB2Night Show on 27 Jan 10am CST

Our special guest is Serge Rielau, IBM Canada, and he will be talking about Advanced Problem Determination for PL SQL, SQL PL, triggers, and UDFs using new DB2 9.7 monitoring APIs and Profiling....

...

Kim May

zEnterprise – The Ideal Basis for Smarter Computing, DC, 2/7

Baltimore-Washington area DB2 for z users – IBM is hosting a *free* full-day of informational sessions and I recommend you attend if you can.  For details and registration information go to the...

(Read more)
 

January 25, 2012


Willie Favero

The "2012 DB2's GOT TALENT Contest" is almost here! Have you entered?

(Posted January 25, 2012) Have you ever been listening to a presenter at a conference or user group meeting thinking to yourself “I could do that”.   Well, here’s your chance to let the world (or at least the Db2 community) that YES you really can that.   ...

(Read more)

DB2 News

Win a Trip to the IDUG Conference of your Choice

The International DB2 User Group (IDUG) is a user-run organization. If you want independent information about DB2, IDUG is the place to go. This year, IDUG are have conferences in the US (Denver),...

(Read more)

Willie Favero

Be careful how you define your partition-by-growth universal table space

(Posted January 25, 2012) I recently had a conversation with a friend about the additional work they may have made for themselves by misinterpreting one sentence for a keyword when they creating a whole pile of their partition-by-growth universal table space.  I looked...

(Read more)

DB2utor

DB2 10 Information APARs

Last week I listed some recently updated IBM Redbooks. When I looked more closely at one of these publications, the "DB2 10 for z/OS Performance...
 

January 24, 2012


DB2Night Show News

DB2's GOT TALENT around the world. But in the USA?

Contestant Applications are still being accepted for 2012 DB2's GOT TALENT. Is it true that the USA lags other countries in skills and education? LUW Applications arrived today from India, Brazil,...

...

Dave Beulke

DB2 10 for z/OS: Value for Years to Come

The discussion of the z/OS platform and specifically the value of DB2 10 is very interesting. As I work with clients on both the distributed and the z/OS platforms, the z/OS value is extending its use within the enterprise. Based on these cost of z/OS and the value of DB2 10 discussion, I offer up ...

(Read more)

DB2Night Replays

The DB2Night Show #Z20: Data Skew and Real World Performance Solutions

Special Guest: Cristian Molaro IBM DB2 GOLD Consultant Expert Advice and Solid Solutions Replays available in WMV and M4V formats! 98% of our audience learned something! Our special guest, Christian Molaro, DB2 Independent Specialist, shared with our audience the perils of Data Skew and provided solid, workable performance solutions. What did you miss? Watch the replay...

(Read more)
 

January 23, 2012


Ember Crooks

Analyzing Deadlocks – the new way

So you can still use the old way, and if you want to avoid event monitors that write to tables, that’s still the only way. See Analyzing Deadlocks – the old way for more details on that...

...
 

January 22, 2012


DB2Night Replays

The DB2Night Show #67: DB2 Certification Insider Secrets, Tips, & Roadmaps

Special Guest: Roger Sanders Director, EMC Corporation Destined for Top 25 of 2012! Replays available in WMV and M4V formats! Plus a PDF! 96% of our audience learned something! Our special guest, Roger Sanders, Senior Systems Consultant and Director at EMC Corporation, shared with our audience how DB2 Certification Tests are created, road maps to various certifications (for z/OS and LUW), and provided advice on how to take the tests! If you...

(Read more)
 

January 21, 2012


Matthias Nicola

Business Records in the 21st Century

Part 2 of our article “Data normalization reconsidered” is now available at http://www.ibm.com/developerworks/data/library/techarticle/dm-1201normalizationpart2/index.html The second part discusses alternative to a traditional normalized relation representation of data. Such alternatives include for example XML, JSON, and RDF because they can often help you overcome normalization...

(Read more)<img height="1" src="http://feeds.feedburner.com/~r/NativeXmlDatabasePlanetDB2&hellip;

Smarter Questions

SPECjEnterprise2010 benchmark questions answered

SmarterQuestions reader has asked several Smart questions in response to this WAS vs. WLS performance comparison article. Below are reader questions and my answers. QUESTION: “Is the operating...

(Read more)
 

January 20, 2012


Henrik Loeser

DB2 and PL/SQL features

Today, I answered an email in which I was asked whether DB2 supports PL/SQL and such features as exception handling, the Oracle data dictionary (system catalog), triggers, etc. My response was that...

(Read more)
 

January 19, 2012


Ember Crooks

Oracle’s SCN Flaw – could it happen in DB2?

I read an article on a flaw in Oracle that was recently discovered. It had to do with the SCN number that is constantly increasing in any database:...

...

Smarter Questions

Video: David Birmingham of Brightlight Consulting talks about the power of Netezza

David Birmingham of Brightlight Consulting talks about the power of Netezza and what you can do with Netezza compared with its competitors.

(Read more)

Triton Consulting

What to do when you’re forced to stay on out of date software

In an ideal world all organisations would be running the latest software versions and upgrading when new versions came out, in order to benefit from the latest innovations and also to ensure that software was officially supported by the vendor. … Continue reading →

(Read more)

Robert Catterall

A Note on the Data Capacity of a DB2 for z/OS LOB Column

Last week, a DBA asked me a few questions about LOBs (large objects) in a DB2 for z/OS context. Most of you probably know that a LOB is a DB2 data type. There are actually two LOB data types: BLOB (binary large object -- a string of bits) and CLOB (character large object -- a string of characters). One key difference between LOB and non-LOB data types is capacity with respect to the size of individual data values: a table column defined with the VARBINARY or VARCHAR attribute (these being the...…
 

January 18, 2012


DB2 News

Anatomy of an Oracle Marketing Claim

Yesterday, Oracle announced a new TPC-C benchmark result. They claim: In this benchmark, the Sun Fire X4800 M2 server equipped with eight Intel® Xeon® E7-8870 processors and 4TB of Samsung’s Green...

(Read more)

Triton Consulting

Customer says best feature in DB2 9.7 is Storage Optimization…

…it gave compression of up to 5 times resulting in more space savings and enhanced performance. In 2011 we worked with one of our longest standing customers, Holiday Extras, on a migration project and helped them migrate from their DB2 … Continue reading →

(Read more)

PlanetDB2 News

Welcome Ember!

PlanetDB2 will now include the DB2 for WebSphere Commerce blog by Ember Crooks.

If you'd like to have your blog included, please email us: join [at] planetdb2.com

Cheers,

Leons Petrazickis
PlanetDB2 Administrator
 

January 17, 2012


Craig Mullins

Row and Column Access Control in DB2 Version 10

Rowand column access control enables you to manage access to a table at the level ofa row, a column, or both. It enables you to build policies for the particularsof which data can be accessed by specific users, groups, or roles. Row accesscan be controlled using row permissions and column access control can beaccomplished using column masks. Row andcolumn access control differs from multilevel...

(Read more)

Dave Beulke

Three Areas to Examine Before Your DB2 Migration to DB2 10

2012 has kicked off with a vengeance and everybody is back in the office and wants everything done right now. The crowded calendar continues and people want your DB2 migration to DB2 10 schedule as soon as possible. There is no time to get your existing applications and SQL improved before your DB2...

(Read more)

ChannelDB2 Videos

Holiday Extras DB2 9.7 Migration Success Story


Thumbnail

In this video we chat to Holiday Extras about their successful migration to DB2 9.7 and how Triton helped with the project.

DB2utor

Updates to Redbooks on DB2 10 for z/OS

I've written quite a bit about both IBM DB2 for z/OS manuals and IBM DB2 Redbooks. I generally use the manuals to educate myself about...

About

planetDB2 is an aggregator of blogs about the IBM DB2 database server. We combine and republish posts by bloggers around the world. Email us to have your blog included.
 

Search

Bloggers

decor
Web Analytics