Subscribe
Download DB2
Get free book
Join ChannelDB2
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 listingBelow 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, & TriggersSpecial 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 zIIPIn 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 DutyMainframe 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 CSTOur 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/7Baltimore-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 ChoiceThe 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 APARsLast 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 ComeThe 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 SolutionsSpecial 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 waySo 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, & RoadmapsSpecial 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 CenturyPart 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… |
Smarter Questions |
SPECjEnterprise2010 benchmark questions answeredSmarterQuestions 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 featuresToday, 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 NetezzaDavid 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 softwareIn 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 ColumnLast 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 ClaimYesterday, 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 10Rowand 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 102012 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 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/OSI'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... |
