Subscribe
DB2 Express-C
Free book
Forum
ChannelDB2 Videos
developerWorks
Info Center
|
IBM DB2 is a full relational and XML data server. planetDB2 is an aggregator of blogs about DB2. We combine and republish posts by bloggers around the world. Email us to have your blog included. |
March 10, 2010
Keith McDonald |
db2top Database Screen (Part 2)Twitter It!In the first post of this series on the db2top Database screen, we took a look at the gauges that make up the top part of the screen and saw the additional data about backups that becomes available when the screen widened to 141 columns or wider. In this second post, we will examine [...] |
March 09, 2010
Dave Beulke |
Many New Index Options in DB2 – Version 9 Performance Features – Part 19Index design is one of the most important items or maybe the most important item in database design. Sometimes it is better to enhance the database with more indexes instead of trying to fix the application SQL. Tuning SQL is always good but tuning many SQL statements takes too much time. When [...] |
Data Studio Team |
Don't ask, don't tell -- bi-platform DBAs
Well, I'm glad I got your attention... One of the things that I've been pondering lately is what percentage of DBAs manage more than one database platform. Since this is an IBM blog, how many DBAs manage both DB2 for Linux, UNIX, and Windows and DB2 for z/OS? I've heard that they exist, but maybe I haven't been asking, and y'all haven't been telling. Does your shop have any of these elusive creatures? If so, what platforms do they support? If not, why not? Does this model work well for you? Why or why not? Is this something that you'd like to see happen? One of our objectives in creating heterogeneous database tooling is to help reduce the learning curve when using another database platform. While this is still a work in progress for parts of our portfolio, I'd sure like to know how important this is to DBAs. So, please tell... Post your answer here, or on the IBM Optim Facebook fan page (click on the Fans tab if you don't see it), or, if you're shy, you can just send me an email at bfsmith at us.ibm.com.
|
Bryan Smith
ChannelDB2 Videos |
DB2 LUW Security Primer This presentation will quickly refresh your understanding of the DB2 9.5 security capabilities and then bring you up to speed on the latest additions made in DB2 9.7 to help you better… |
DB2utor |
Old Xephon Articles Still AvailableVia the DB2-L list server, I recently discovered a treasure trove of old DB2 articles originally published in Xephon magazine. All this information is currently... |
|
|
RecommendationsThe IBM Data Management portfolio continues to grow to help you advance your skills. Study when and where you want with unlimited access to courses and labs for 90 days. New and popular courses include: DB2 9 Administration Workshop for Windows DB2 9 for LUW... |
Henrik Loeser |
Is it me or the database topic? Simple reading guaranteedToday I stumbled over an ad or a link for SEO (search engine optimization) and website grading. I put in the URL for this blog (http://blog.4loeser.net) and was surprised to see the following as part of the report: Basically, what the tool found out is that what I have been writing about in my blog requires only Primary or Elementary School education to understand my blog. Could that mean I |
Triton Consulting |
DB2 Geek Confession of the MonthMarch 2010- Unintended Consequences We’ve all done it. You see a great new feature in DB2 and jump headling into using it without fully appreciating all of the implications. Here’s a case in point: One of our clients is a large SAP customer running on DB2 for z/OS V9. With a huge number of subsystems to support [...] |
March 08, 2010
Matthias Nicola |
Integration of Altova XMLSpy with DB2 pureXMLWhen you develop XML applications, you want good tools to design and debug XML artifacts such as XML documents, XML schemas, XQuery queries, SQL/XML statements, XSL style sheets, and other things. On occasions I have seen people use plain text editors such as vi or Notepad for this, but that’s not everyone’s cup of tea. [...]
|
|
|
RecommendationsI have one final set of book recommendations that I'll blog about. These titles are largely topics that do not directly relate to our IBM Information Management products, but instead cover other IBM products or general topics. Once again if you feel that... |
Adam Gartenberg |
New IBM Ads: Why Information MattersOur advertising group just posted five new Smarter Planet ads, focused on the way data, information and analytics can reshape the way companies operate today and the ways in which we can make our world a better place for everyone. My personal favorite is the one featuring IBMer Jeff Jonas. The analogy he makes in the ad to crossing the road based on what the road looked like 5 minutes ago is the best I've seen to date as to why organizations need to keep pushing as close as possible to working… |
|
Henrik Loeser |
DB2 Performance and cost savings tip: Don't maintain unused stuff (LASTUSED)When you enjoying a regular life, over time you usually accumulate a lot of stuff. Some (most?) of that stuff is rarely used, but you have to dust off or clean it anyway, you somehow pay for keeping it through shelves or cabinets you need, through rent or paying off credits. That's one of the reasons why Spring cleaning has been invented (and my wife repeatedly asks me to clean up my home office) |
|
Keith McDonald |
db2top Database Screen (Part 1)Twitter It!The first major screen of db2top that we will examine is the Database screen. This screen gives you the big picture view of your database. You can use this screen to see how busy your database is in terms of the number of applications connected to it and issuing work, the amounts of memory [...] |
Omer Brandis |
program buffer full in development systemlong runtimes may occur in development systems due to the algorithm used to maintain the program buffer's contents...a fix is available... |
DB2usa |
More information about DB2 10 for z/OSHi DB2 user,Here are several presentations and technical documents about DB2 10 for z/OS (formally known as DB2 X) available on several IBM websites: - DB2 10 for z/OS: How can it help you? (70 pages with notes) by Roger Miller - Planning Your Migration to DB2 9 for z/… |
March 07, 2010
Frank Fillmore |
Dubuntu (DB2 + Ubuntu) ApplianceI once got in trouble with a woman I was dating because I bought her an “appliance” for Christmas. It was a combination VCR/DVD player (this was a while ago) and she liked movies. Go figure. I’ve also gotten in trouble with my wife for *not* buying an appliance - in this case a new, energy [...] |
Willie Favero |
How's your Batch workload doing?Yup, batch. The stuff that has been around on the mainframe a lot longer than I have. It's the process many of us love to hate and it seems to fit the old adage "can't live with it, can't live without it". So, here's my question. |
|
Willie Favero |
What's new this week from Optim 03/05/2010 (a guest blog post)Well, it's Friday and continuing on with my latest tradition, it's once again time to publish Kathy's guest blog post covering the latest and greatest Optim news... Enjoy!!!! |
March 05, 2010
Kate Dawson |
NEW from IM Certification: Premium Certificates and Wallet Cards!Show off your Information Management Professional Certifications with NEW premium certificates and wallet cards! The premium certificates are printed on an ultra-fine parchment paper and are officially embossed with the platinum seal of the Professional Certification Program from IBM. Included with the certificate is a newly designed wallet card. This new sleek card displays your name and certification title, demonstrating your status as an IBM Certified Professional. You can choose to print certificates and wallet cards for certifications you earned prior to this announcement. Print more than one and save on shipping!
Check out the new certificate and eStore on the IBM Professional Certification Member Site.   |
Antonio Cangiano |
Heads up: IBM is looking for top notch student hackersAs a thank you for following my blog, I’d like to introduce you to what I think is a great opportunity for the right students. My team is looking for two bright students for a 16 month, full-time internship opportunity with IBM. Aside from being a bright and ambitious student, you should currently be working towards [...] |
Craig Mullins |
Mainframes: The Safe IT Career ChoiceA recent Computerworld article (Bank of America touts mainframe work as a safe career) touts the mainframe as a safe haven for those considering a career in IT. This is an interesting article because the usual spiel you hear in industry trade rags is that the mainframe is dying and only a fool would work on such a platform. It is good to hear an alternate opinion on the matter in a journal as respected as Computerworld. (Of course, the fact that I agree with this opinion might have a little something to do with my cheer upon reading the article.) One of the highlights of this particular article is the discussion of avialable mainframe jobs at sites such as Monster (764 jobs over 30 days) and Dice.com (1,200 ads over 30 days). These are significant numbers of jobs, especially in a down economy. Another interesting tidbit from this piece is that "IBM says it's mainframe revenue has grown in eight of the last 13 quarters." This is impressive; consider the difficult servers market coupled with the impression that the platform is dying. Speaking of the death of the mainframe, don't you believe it for a minute. People having been predicting the death of the mainframe since the advent of client/server in the late 1980s. That is more than 20 years! Think of all the things that have died in that timespan while the mainframe keeps on chugging away: IBM's PC business, Circuit City, Koogle peanut butter, public pay phones, Johnny Cash... the list is endless. Some may counter that they recall reading about companies that were going to eliminate their mainframe. Well, yes, I'm sure you do remember those, I do, too. But do you recall reading many articles about companies that SUCCESSFULLY eliminated their mainframes? Many tried, few succeeded. Indeed, the re-Boot Hill web site provides examples of companies that tried to eliminate the mainframe but could not (hence, they had to re-boot). If you follow the link to the re-Boot Hill site click on the little tombstones to read the stories of failure. So, the mainframe is a rock-solid platform, continues to grow, and is producing a significant number of job opportunities... what is not to like? |
|
Craig Mullins |
This blog has movedThis blog is now located at http://db2portal.blogspot.com/. You will be automatically redirected in 30 seconds, or you may click here. For feed subscribers, please update your feed subscriptions to http://www.db2portal.com/atom.xml. |
|
Craig Mullins |
This blog has movedThis blog is now located at http://db2portal.blogspot.com/. You will be automatically redirected in 30 seconds, or you may click here. For feed subscribers, please update your feed subscriptions to http://www.db2portal.com/atom.xml.  |
Robert Catterall |
Another Note on DB2 for z/OS Buffer Pool Page-FixingIn the summer of 2008, I posted a blog entry on page-fixing DB2 buffer pools, a feature introduced with DB2 for z/OS Version 8. A recent discussion I had with a client about buffer pool page-fixing brought to light two aspects of this performance tuning option that, I believe, are overlooked by some DB2 users. In this post I'll describe how you can make a quick in… |
|
Triton Consulting |
Free DB2 Health Checks!UK DB2 customers. This services will involve one of our DB2 experts spending the day “getting under the covers” of your DB2 systemsto look at the following: Database server capacity Database software Instance & database configuration Housekeeping Back-up and recovery Data placement Performance monitoring Logging configuration Bufferpool configuration You will then receive a summary of findings outlining any areas for improvement with expected benefits and [...] |
|
Keith McDonald |
db2top Feature of the Day – GaugesTwitter It!Before we can examine the various interactive screens of data that make up db2top, we need to become familiar with one of the ways these data are presented – gauges. Gauges in db2top are graphical representations of proportions. Gauges appear on many of db2top’s screens, often grouped together. A gauge shows what percentage of a certain [...] |
March 04, 2010
Kim May |
Take Me Out to the Ball*park*The countdown to the first day of Spring is below 20! Spring can’t come soon enough for me, as here in Baltimore we’ve had over 80 inches of snow - our average is 18. In preparation for Spring I am coordinating events with the local IBM teams to introduce customers to two great technologies we hope [...] |
|
Willie Favero |
How to get ready for DB2 10 for z/OSYup, you read that correctly. It's never to early to start planning for your upgrade to the bigger and better DB2 for z/OS. There is another new release of DB2 on the horizon, DB2 10 for z/OS. With every new DB2 comes you migration/fallback PTFs; that stuff you apply to your existing system so everyone plays well together. |
|
|
RecommendationsTranslated this means: Books: Enterprise Content Management, Information Integration, Master Data Management, and Data Warehousing. I need help with today's list of books! I need better recommendations for the Enterprise Content Management area and the Data... |
March 03, 2010
Vincent McBurney |
Dear IBM Support, Could you Fix Your Broken Web Link in the Qantas ClubEvery time I visit the Qantas Club lounge in an Australian airport and switch on the wireless internet I get an IBM URL error. |
|
Triton Consulting |
Have you heard the pureScale podcast?Get the lowdown on data sharing! Click here to download the podcast. With the launch of pureScale at the end of 2009, IBM announced to the world that they were bringing mainframe style data sharing to the AIX platform - with other platforms to follow. Given that z/OS is the gold standard for reliability this is [...] |
