Monday, November 30, 2009
Friday, November 27, 2009
A list of enhancements is available in the Information Center, a general DB2 9.7 FP1 overview including the list of fixes is on the support page. The major enhancements include even more PL/SQL support to make it simpler to move off of Oracle and "read on standby" in HADR environments.
When I am on business trips and back at the hotel, I usually try to check a webcam from "my place" before calling home ("I know how it looks like right now"). Do you webcam, too?
Before talking with co-workers in other locations, you can check webcams to make talking about the weather more interesting ("it is NOT snowing in your place"). Do you webcam?
Here are some webcams I use from time to time:
- Friedrichshafen has a couple of webcams and I will only list three around the airport. The so-called slashcam can be controlled and has nice views. The same goes for the Zeppelin webcam. The aero club located at the airport maintains 4 webcams.
- Boeblingen, where IBM's German Lab is located, has at least this webcam.
- For the conditions in San Jose, California, my former home and place of several IBM locations, the SJSU offers a cam.
- A very interesting "local" webcam is installed on one of the ships cruising the Lake of Constance, on the St. Gallen. In the archive you can follow the ship on its tours across the lake.
Thursday, November 26, 2009
Sometimes it is hard to say goodbye, sometimes not. Sometimes you get used to something and cannot imagine a life without it. Anyway, the day has come to move on in a different, hopefully better way. No more of it for now. The experience is nice to have, but I hopefully can live without it.
After putting up some shelves and drawers over the last few weeks, it was time to unpack the remaining moving boxes. Some of them contained stuff we took with us from Germany to California and never touched (textbooks from the time at university). One box contained framed awards from the past few years (where do we put them?), books with my first conference papers, a newspaper from the day of our wedding. All is unpacked. Goodbye moving boxes, we have moved in. The last one is done...
Wednesday, November 25, 2009
Now, starting with DB2 9.7, they have a neat feature in common: Both can be inlined. What is inlining and what are the benefits (for LOBs)?
Because LOBs and XML data can be quite large, they are stored outside the regular row data, i.e., outlined, and a LOB descriptor points to the large object. With inlining however, when the data fits into the regular data pages, it is stored as part of the row, i.e., inline.
DBAs can specify the maximum inline size for each LOB or XML column by using "INLINE LENGTH xxx" during CREATE/ALTER TABLE. The total row size, i.e., the sum of all column sizes and some overhead, needs to fit into the data pages. What this means is that if you use 8k pages, an inline length of 15000 won't work for sure. In contrast to XML columns, if no inline length is specified, for LOB columns an inline length equal to the descriptor size is set implicitly.
Why store 200 bytes outlined and have a 220 bytes LOB descriptor in the row (total 420 bytes), when all can be stored in 200 bytes in the row? And now we are already talking about the benefits of LOB inlining. If you have lots of small LOBs, inlining can improve performance and reduce storage significantly. Storage is reduced because the extra LOB descriptor is avoided. In addition, LOB data stored in the row, i.e., inlined, benefits from row compression when enabled. The performance improvement comes from the direct access (no LOB descriptor involved) and the fact that regular table data is cached in the bufferpool. The direct fetch operations to the unbuffered LOBs are avoided.
As shown, LOB inlining has many benefits and if your Large OBjects (LOBs) are really small objects you should exploit this feature. I found this article describing how LOB inlining in DB2 is used for SAP databases. Because many small LOBs exist to store properties, this can have significant performance benefits.
Monday, November 23, 2009
One of the many new features in DB2 9.7 is Scan Sharing. The optimizer now can group transactions that perform a table scan or block index scan on the same data into so-called share groups. Scanners within a share group coordinate among themselves, i.e., cooperate. The idea is that I/O and bufferpool activity is reduced by having multiple parties work on the same pages at the same time. This is great when your system is I/O bound because the costly physical I/O could be significantly reduced.
How would I explain such a feature to my kids? With the holiday season and family visits approaching I would tell them to coordinate the "bio breaks" on roadtrips. Instead of everyone independently asking for a pit-stop and daddy stopping every 30 minutes, the entire family could agree on visiting the restrooms at the same time and refilling the gas. Coordinated stops (comparable to physical I/O) would result in us significantly faster reaching the destination.
Tuesday, November 10, 2009
Tell me something cool about this article
For each of the discussed versions there is a section "Tell me something coll running on...". It shows how an IBM customer is using that specific version of DB2.
Now, here is a (free!!!) advice. Don't try to win 10 million dollars in silly contests, but read the Redbook "Oracle to DB2 Migration: Compatibility Made Easy". You can even try out what you learned on the free DB2 Express-C. You will quickly understand how to save money, run database applications faster, and make DBA life simpler.
P.S.: Did I mention Award and Promotion...?
Monday, November 9, 2009
BTW: We are in Germany and use a different washing detergent, but have a Zeppelin overhead most days...
Designers, database developers , and DBAs are all invited to join. The call will be recorded, a live chat is available, and materials will be available online. Bring your own food and questions...
Thursday, November 5, 2009
It's interesting to see statistics about your account activities in one place. The interesting question is how do you interpret, how do you analyze it (from Google's perspective)? What does Google really know (or guess) about me? The question is not Google-specific, but applies to all those companies that collect data about you.
It is good to see such a feature in place because it creates more awareness of the data privacy/data collection issue. I would like to see similar services by other companies.
Wednesday, November 4, 2009
- pureXML Wiki: https://www.ibm.com/developerworks/wikis/display/db2xml/Home
- pureXML forum: http://www.ibm.com/developerworks/forums/forum.jspa?forumID=1423
- pureXML devotees: https://www.ibm.com/developerworks/wikis/display/db2xml/devotee
- IBM Redbooks: http://www.redbooks.ibm.com/
- DB2 pureXML cookbook: http://www.ibmpressbooks.com/cookbook
- Blogs like this one (visit http://www.planetdb2.com for an overview)
- DB2 Information Center: http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/index.jsp
- my blog http://blog.4loeser.net or Conor's http://nativexmldatabase.com/
DB2 for z/OS:
- DB2 for z/OS pureXML wiki: http://www.ibm.com/developerworks/wikis/display/db2xml/DB2+for+zOS+pureXML
- DB2 pureXML team blog: http://www.ibm.com/developerworks/blogs/page/purexml
- DB2 for z/OS Information Center: http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/topic/com.ibm.db29.doc/db2prodhome.htm
Sunday, November 1, 2009
Here is a list of activities, starting from night to day
- Over night a lot of mail and packages are moved, leaving tracking data in databases.
- There are also all kind of batch jobs running to produce statements, dig into details of transactions from the day before, and much more.
- Because several alarm clocks are running, devices being on standby, and of course fridge, freezer, heating system, etc. performing their duties, energy consumption could be (e-)metered, leaving entries at the utilities. During the day, all kinds of electrical devices (stove, computer, microwave, washer/dryer, lights, etc.) will add data.
- By making phone calls, connection records (and who knows what more?) is left. If I call a hotline, sometimes phone calls are recorded, often records added to CRM databases, etc.
- When doing (grocery) shopping, a list of my items is added to the transactions. Maybe automatically some items are re-ordered.
- Using electronic payment, a credit card/check card debit action is performed.
- For paying bills, an electronic fund transfer with associated records at several banks is done.
- When surfing, my traces are left in web logs, cookies are produced, "recommendations" are processed, Google and other ad networks/analytics/tracking companies are adding to my profile, my IP connections are stored, my DSL provider probably keeps additional information.
- When parking in a downtown garage, my license plate is recorded during entry/exit.
- The local library keeps a list (and maybe a history) of books on my and the kids' account.
- and much more