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. |
January 07, 2009
Willie Favero |
More on Data StudioMy last post covered the Data Studio V2.1 and pureQuery announcement from last December. If you find Data Studio and/or pureQuery, here are a few more resources for you check out including a little thing that you Visual Explain user might be interested in. |
January 06, 2009
Susan Visser |
Want to know more ?Want to know more about ECM or Filenet? Here are some IBM Redbooks that can help you learn more about these IBM solutions: * IBM Content Manager OnDemand Web Enablement Kit Java APIs: The Basics and Beyond This book is intended for application developers who are responsible for developing Web applications that interface with Content Manager OnDemand. It also serves as a good r… |
DB2utor |
Tracking XML Changes Changes for the BetterI spent part of 2008 learning and blogging about XML support delivered in DB2 V9 for z/OS. Well, the learning process (as well as the... |
Adam Gartenberg |
Students band together to prepare for DB2 CertificationIt's great to see posts like this one show up in my Google Alerts. A number of students at PUCPR in Brazil have formed their own DB2 User Group and decided to focus on helping each other pass the DB2 Fundamentals 730 Certification Exam. Congratulations to César Felipe de Souza, Rafael Junqueira, and Thiago Rosseto on passing the exam! Andrea Rodacki shared the news, and links over to the students' DB2@PUCPR site, which has more details about how they created and structured the group. (And,… |
|
Willie Favero |
Good reading on Business Intelligence trends in 2009This morning while going through my subscriptions at a slow enough rate for a change, I notice what I think is an excellent and extremely interesting article by David Stodder in Intelligent Enterprise's newsletter. |
|
Willie Favero |
And I quote "The unthinkable has happened..."Getting straight to the point.. IBM has released a version of DB2 for the Mac OS X. |
FreeDB2 |
The unthinkable has happened …While Macworld attendees will be hearing about the new cool products coming from the from 1 Infinite Loop in Cupertino, we at IBM have done what would have been unthinkable only a few years ago and delivered a major product for the Mac OS X. Over the holidays we released DB2, the flagship IBM DBMS, for the Mac OS X.
<a href="http://…
|
January 05, 2009
Data Studio Team |
New Demos for pureQuery and Optimization Expert on z/os
Hi all,Just want to let you know that we recently posted another demo for Data Studio on DemoZone. This is a two-part, scenario-based demo focused on a DB2 for z/OS environment. In part 1, we wanted to show some cool features available in DB2 Optimization Expert for z/OS for tuning and optimizing query performance. The second part is an extension to the previous demo set, with details of steps in setting up and using the client optimization feature in Data Studio Developer and pureQuery Runtime for performance stability. Let us know your comments on this video and what specific demos you’d like to see. I found DB2 Optimization Expert for z/OS easy to use. Of course, when you’re trying to create a demo that shows off the features, it can be challenging. We wanted to come up with a query that would enable us to get tuning recommendations from all the advisors in the product to showcase its capabilities. That was a bit difficult but we managed to do it. You can read more about the various advisors in Ray’s blog entry. DB2 Optimization Expert is currently available only for z/OS. As query tuning capabilities are a key skill for all database professionals, you might expect to see more database platforms supported in the future. In addition to the demos on DemoZone, we are posting other less formal, more feature-oriented demos on Channel DB2. In particular, there is a series of demo for new features in Data Studio 2.1 including What’s New for Data Studio Developer and DB2 Performance Expert Extended Insight Feature. We’re looking forward to hearing from you – just either add a comment to this blog or send an email to dstudio@us.ibm.com. Thanks. --Thuan Bui |
Craig Mullins |
VOLATILE: A Useful Little KeywordJust a short blog entry today to remind everyone about the VOLATILE keyword. This keyword was added in DB2 Version 8 and it can be specified on a table using CREATE TABLE and/or ALTER TABLE statements.OK, so what will VOLATILE do? Basically, this keyword is used to indicate that the volume of data in the table is volatile and is likely to fluctuate. One common scenario where VOLATILE will be helpful is for tables that are emptied nightly and then repopulated the next day, such as an … |
|
Adam Gartenberg |
January Blogging 101, 201, 301Since January 1st was technically the first Thursday of the month, I'm shifting this month's Blogging 101, 201, 301 sessions by a week (but somehow I don't think any of you will mind). Please see below for more details and for links to add the sessions to your calendar. I do want to thank those of you that have already joined me for these sessions, and a special note of appreciation to the handful of folks that have even completed a Blogging Series hat trick by attending all three sessions! Y… |
Robert Catterall |
Databases in the clouds?A few years ago, I put together a presentation in which I included a simplified diagram of an application system. It was an end-to-end depiction, with users (external to the application-owning organization) on the one side, the company's IT infrastructure on the other side, and in between, a cloud, representing the Internet, through which said users interacted with the application.For years, people have used a cloud in diagrams to represent the Inte… |
|
Susan Visser |
Love your Mac!Happy 2009 to one and all! May it be a joyful and prosperous year for you and your loved ones! The last week of December the following announcement was made and I wanted to make sure that you didn't miss it: DB2 Express-C for Mac OS X is finally available for download. This beta release will no doubt be of interest to developers, particularly those who use scripting languages like Ruby, Pyt… |
Leons Petrazickis |
Dynamic SQL playlists in MusikCubeOn Windows, my music player of choice is musikCube. It’s fast, clean, elegant, and powerful. Oh, and it has an embedded SQL engine underlying its song library. It has conventional playlists, but it also has dynamic playlists based on queries of the underlying SQL database. For example, this query gives the Top 10 Most Played [...] |
January 02, 2009
|
Craig Mullins |
Recovery AssuranceExpert for DB2 z/OS: Automating the IT risk management of business availabilityBusiness availability is more than just having a reliable hardware and database platform in place. Even the best high availability environment cannot safeguard itself from logical errors. Since most companies cannot afford downtime, it is important that the enterprise data on which they depend is always available.Well-planned recovery procedures should be able to assure a complete recovery of enterprise-critical data within a pre-defined time window that provides for minimum disrupti… |
developerWorks |
Instant Information: Stream ComputingTalk about low latency. IBM's new InfoSphere Streams technology lets companies analyze data in motion, bringing results in milliseconds. |
|
Adam Gartenberg |
Take a tour of the value delivered by InfoSphere WarehouseThe InfoSphere Warehouse team has recently posted 21 videos that walk through the multiple levels of value and benefits that InfoSphere Warehouse can deliver for your company. To see them all, head over here, or you can click on one of the four links below to take a more focused approach based on what interests you the most. ... |
January 01, 2009
|
developerWorks |
Java Garbage CollectionHow to configure Tomcat to capture Java Garbage Collection logs to file, and a suggested tool for monitoring Heap Utilisation. |
|
developerWorks |
Image Indicators in a CrosstabHow to unlock the contents of your crosstab fact cells to include an image. The image is conditionally displayed based on the data included in the crosstab and can be used as a metric indicator for the measure values. |
Omer Brandis |
another sap classfication performance problemThe following sql ... In include lclscf2c was using the wrong index... |
December 31, 2008
DB2 pureXML Team |
Generating XML from relational data in SQLOn this last day of year 2008, I'd like to share with you on how easy it is to generate XML from relational data using SQL in DB2 V8 and DB2 9 for z/OS. To start with, I'd like to show a simple example of SQL functions that generates the following XML: <name> <firstname>John</firstname> <lastname>Doe</lastname> </name> The SQL functions to construct this XML is the following: XMLELEMENT(NAME "name", XMLELEMENT(… |
Jeffrey Benner |
DB2 - Oracle Migration Workbench a no goThe Oracle Migration Workbench (OMWB) will not work for DB2 to Oracle migrations if DB2 version is past 7.x. Why: the Workbench consists of two components, a set of common files for all databases; and a plugin (plug-in) for the specific database and version. The most recent plugin available for OMWB is for DB2 version 7.2, and that only for the DB2 LUW Windows platform. There are, however, third-party tools available which supports current DB2 releases. |
December 30, 2008
Conor O'Mahony |
Anant Jhingran on Improving XML ApplicationsAnant Jhingran is the CTO of IBM’s Information Management division. He recently penned an article in DMReview.com titled Improve your XML Applications. The article is vendor-agnostic and describes the benefits that native XML databases offer developers, as they develop XML-based applications. It’s definitely worth a read. |
|
Conor O'Mahony |
XForms and Native XML StorageOne area where it makes a lot of sense to preserve an end-to-end flow of XML data is with XForms applications. In other words, it makes sense to use XForms to implement electronic forms and then to store the information from those forms in a native XML database. This is an area where [...] |
|
Jeffrey Benner |
IT Contractors: response to Kurt Cagle of O’ReillyKurt Cagle, online editor for O'Reilly Media, has written an extremely interesting article on the need for change in the world of IT contracting. He points out that a large portion of recent IT workforce cutbacks have been the discontinuation of contract workers. I discuss his conclusions, disagree with some, agree with others, and add some further ideas to move the discussion along. I talk about contractor workers collectives, telecommuting and more flexible, modular approaches than the 40 hour workweek. |
ChannelDB2 Videos |
XML Challenge XML Challenge |
|
Omer Brandis |
what's your take on the latest war between Israel and the hamas?Please feel free to post your opinion, and or vote in the following poll, because I don't know what to think any more. |
Vincent McBurney |
How the IBM Information Server uses Oracle metadata and dataA look at all the ways the IBM Information Server products can import metadata from Oracle databases and applications and extract or load data back to those data stores. |
December 29, 2008
|
Jeffrey Benner |
db2pd: Rapidly Evolving DB2 Performance Tooldb2pd is a relatively new DB2 LUW performance monitoring and troubleshooting tool introduced with DB2 version 8.2. Because it retrieves information from DB2 memory sets, it does not issue latches and is therefore a very low-cost means of monitoring DB2. We present an overview of new features that have been rolled out steadily since db2pd was introduced. |
DB2 on Campus |
DB2 Express-C on Mac OS XI cannot remember how many times I've been asked the question "Does DB2 Express-C run on the Mac?". I recall in my trip to Portugal a few months ago, many students and teachers using the Mac. I'm happy I can now answer "Yes" to that question. As of December 23rd, 2008 IBM has released a beta version of DB2 Express-C 9.5.2 for the Mac OS X Leopard 64-bit (Intel)!!! You can download it here. This be… |
December 26, 2008
|
Robert Catterall |
Whither DB2 for z/OS Self-Tuning Memory Management?In my own experience as a DB2 consultant, I've seen organizations put their trust in DB2 for Linux, UNIX, and Windows (LUW) when it comes to automatic management of the server memory resources utilized by DB2 - with positive results. Self-tuning memory management (STMM) was activated for databases by default starting with DB2 9.1 for LUW, and DB2 9.5 added several memory-related configuration parameters to the list of those for which a value of AUTOMATIC can … |
|
Conor O'Mahony |
Native XML Storage for the MacIBM recently released the Beta of DB2 Express-C for the Mac. This means that IBM’s native XML storage capability—DB2 pureXML—is now available on the Mac. This release of DB2 on the Mac is a direct response to the growing community of developers who are choosing Mac OS X as their operating system of choice. [...] |
December 25, 2008
Ian Hakes |
Testing out ScribeFireLet's see if having an integrated blog update function in my Firefox browser will help me write more frequent blog posts.
|
|
|
AboutIBM 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. |
Bloggers
|
