|
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. |
July 29, 2010
ChannelDB2 Videos |
Using Data Replication for Continuous Availability![]() Replication has become a popular way of implementing availability and active-active solutions for data. This short video provides an overview using Q Replication. This v…… |
Susan Visser |
Free Webinar: Getting started with IBM Data StudioI'm still catching up on work after being away for my summer vacation... so forgive me for the lack of posts I've made! I saw this from Leon and would like to simply repeat it: A replay of this free webinar http://www.channeldb2.com/events/webinar-getting-started-with is now available. This is about FREE IBM Data Studio that naturally works with the FREE DB2 Express-C. One really important point. Recently we released "lite" versions of DB2 Express-C. These versions are faster to download but they are missing some of the components. One of those components is ... drum roll ... Control Center. Yes, you know Control Center is going away and is being replaced by the IBM Data Studio. So, watch the replay of the webcast, grab Data Studio, DB2 Express-C and the free books on DB2 Express-C and Data Studio. Susan |
Vincent McBurney |
Customer License Keys a Thing of the Past for IBM Information Server SoftwareIf you buy an Information Server software you now get a default license key that will let you install and use whatever products you want in any quantity you want. The catch is – whatever software you use you will eventually have to pay for.&#... |
July 28, 2010
|
DB2 Express-C Team |
DB2 Express-C database now 44% lighter The DB2 Express-C database server is downloaded worldwide, but broadband internet is not yet universal. Because of this, we are releasing a light version of DB2 Express-C 9.7.2 for Windows. It's an amazing 44% smaller than the full download.Unlike the lighter download, the DB2 Express-C (full)… |
Henrik Loeser |
Catalog view xmlstrings for simpler access to stringID informationThe XML support in DB2 is tightly integrated into the database engine and provides fast and sophisticated processing of XML data. In the past I had explained why - for compactness and speed - element and attribute names, namespace information is replaced with so-called stringIDs. The string to stringID mappings are stored in a cached dictionary which is persisted in a system catalog. That system |
Keith McDonald |
db2top: Memory screen and db2mtrk (video)Today’s video is a comparison between the output of the db2mtrk command and the db2top Memory screen. It covers current allocations, high watermarks, and maximum allocations for the instance, database, and application groups of memory pools as well as the repeat mode of db2mtrk. Watch “db2top: Memory screen and db2mtrk” directly on YouTube. Related posts:db2top: Regular [...] Related posts:
|
Data and Technology |
What Does a DBA Do?There are many tasks that database administration (DBA) must perform to keep databases -- and the applications that rely upon them -- available and efficient. Continue reading
|
Dave Beulke |
True Performance within the New zEnterpriseThe new zEnterprise IBM computer was announced last week and it can run any workload. Yes any workload! Your company can now run mainframe, UNIX and some Windows applications within the new environment. The new zEnterprise is designed with performance and capacity for large-scale consolidation of any workload. As has been done recently with consolidating [...] |
July 27, 2010
DB2 on Campus |
Data Studio webinar replayIf you missed the Data Studio Webinar held on July 27th, the replay is available here:http://tinyurl.com/276y96j Cheers, Raul. |
DB2utor |
DB2 for z/OS ResourcesAs a DB2 database consultant for many years, I know it's important to keep up with what's new on DB2 for LUW as well as... |
|
Triton Consulting |
The industry’s fastest, most scalable and flexible enterprise server – IBM zEnterprise SystemLast week IBM unveiled their latest mainframe – the IBM zEnterprise System. According to the official launch site the zEnterprise brings: The industry’s fastest enterprise system. Delivering 50 BIPS, zEnterprise is ideal for large-scale data and transaction serving and mission critical enterpris applications. Unified management for multi-platform environments. Unified Resource Manager, part of the IBM System Director family, [...] |
July 26, 2010
Rav Ahuja |
Is Database on the Cloud an Appliance?Database and Data Warehsousing appliance's (from Netezza, Teradata, Oracle - Exadata, IBM - pureScale system, Greenplum, etc.) that bundle and tightly integrate the right hardware, storage, networking and software are all the rage these days. So why note take this concept a little further where you get all the benefits of an appliance but don't have to worry about physical maintenance, or more |
|
DB2 Express-C Team |
Getting Started with IBM Data Studio webinar on TuesdayThere's a Data Studio webinar on Tuesday, July 27 at 11:30 Eastern:Getting Started with IBM Data Studio |
Willie Favero |
The July PeopleSoft Discussion Forum Conference CallWell, it's the end of the month so it must be time to remind you all about this month's CA sponsored PeopleSoft Discussion Forum conference call. This is your opportunity to dial into a conference call with other PeopleSoft users, ask questions about PeopleSoft, answer questions others might have about PeopleSoft, or just listen to the various discussion that come up. |
Omer Brandis |
The warm-up effectHe was right of course, things do tend to work faster the second and third and forth and X time you run them in a sap system, and labeling it the warm-up effect is rather accurate. So for all those who are puzzled by this effect, here's a short technical explanation as to how and why this happens... |
Keith McDonald |
db2top: Buffer pool hit ratio (video)Today’s video is a demonstration of buffer pool hit ratio in the Bufferpools screen of db2top. To produce a hit ratio of 100%, we query a single row repeatedly to perform logical reads with no corresponding physical reads. To reduce the hit ratio, we query more data than can fit in the buffer pool, resulting [...] Related posts: |
July 23, 2010
Frank Fillmore |
IBM zEnterprise Has Benefits on Many LevelsI attended IBM’s zEnterprise announcement in New York yesterday. IBM Senior VP Steve Mills said it was the most important announcement IBM had ever made in its impact on saving customers money. He also said IBM spent US$1.5 billion dollars on the zEnterprise research and development effort over the past several years. So, as movie reviewers ask [...] |
Rav Ahuja |
Want a free Data Studio book?IBM Data Studio if you don't know is a free tool for administering and developing server side / app routines for DB2 (both LUW and z/OS). [Of course there is a lot more to it but I assume you get the concept.] Over time it will replace the DB2 Control Center. So if you're new to DB2 or have been using the Control Center, it is a good idea to get yourself familiar with Data Studio. And an easy way to do that is to attend this webinar on Tuesday Jul 27, at 11:30-1 PM Eastern. You can… |
|
Triton Consulting |
A growing online retail sector needs the right IT solution to support customer serviceAccording to a report from econsultancy.com 34% of shoppers prefer to buy online. As buying habits change and consumers move more towards online shopping, the need for a robust and scalable IT infrastructure becomes greater. According to Internet Retailing, internet retail sales in the UK hit £49.8 billion, up 21% from 2008. Overall, up to [...] |
Keith McDonald |
db2top: Regular expressions (video)Today’s video is a demonstration of the regular expressions (regex) feature of db2top. In the video, I apply regular expressions to the Dynamic SQL screen to filter what SQL statements are shown. I demonstrate setting and clearing a regex, simple regular expressions, and POSIX extended regular expression metacharacters: Watch “db2top: Regular expressions” directly on YouTube. Related posts:db2top: [...] Related posts:
|
July 22, 2010
ChannelDB2 Videos |
DB2 + Ubuntu Cloud Appliance![]() In this video you will learn to quickly launch Amazon EC2 instances with Ubuntu 10.04 linux and DB2 Express-C 9.7.1 database server configured and ready to go. Before attempting the… |
Adam Gartenberg |
IBM SPSS Predictive Analytics Helps City of Memphis Reduce Serious Crime by More Than 30%Along with yesterday's report about the benefits Sun World is getting from predictive analytics comes another case study with very impressive results. IBM has been worked with the Memphis Police Department (MPD) to enhance its crime fighting techniques through the use of IBM predictive analytics software. As a result of these efforts, the City of Memphis is reporting a 30% reduction in serious crime, including a 15% reduction in violent crimes since 2006. These gains come from the ability t… |
Henrik Loeser |
New generation of mainframes and an integrated accelerator for warehouse workloadsIBM today announced a new generation of its mainframe computers, labeled zEnterprise. Based on a hybrid architecture, zEnterprise BladeCenter Extensions (zBX), it allows to integrate and manage POWER7 blades or System x blades from within the mainframe infrastructure. (One of) the first to exploit the zBX feature is the IBM Smart Analytics Optimizer. The latter allows to significantly speed up |
Willie Favero |
The IBM Mainframe has just raised the bar: Introducing the "IBM zEnterprise System"No more subtle hints at the end of this blog. July 22, 2010 has arrived. With it, IBM's latest (and maybe greatest) mainframe has arrived also. The IBM zEnterprise System; their hybrid mainframe. With 96 5.2 GHz processors, up to 3 TB of memory... more to come... |
July 21, 2010
Kim May |
Summer Services SpecialAs much as I dislike the relentless repetition that’s part of the nature of the world of blogs and twitter and listserves and email blasts, here I go with a shameless pitch for a TFG special services offering I emailed to several DB2 users earlier today. I am doing this because, at the end of [...] |
FreeDB2 |
A different view on a “Database Appliance” conceptAs the open source faithful have gathered in Portland for the annual O’Reilly Open Source Convention (OSCON) Canonical, the company behind an ever popular Linux distribution Ubuntu, announced that it has paired up the latest version of the free DB2 Express-C v9.7 with the latest version of Ubuntu 10.04 LTS to deliver a free enterprise-grade cloud database appliance. Not that kind of an appliance Database appliances, especially for data warehousing, … |
Willie Favero |
Have you signed up for IBM's Breakthrough System Virtual Event for July 22If not, why not? This could be one of the more significant events being held this year... maybe even in the last decade. |
Adam Gartenberg |
Smarter Farming: California’s Sun World Transforms Produce Business with IBM Analytics TechnologyIn a press release issued this morning (Smarter Farming: California's Sun World Transforms Produce Business with IBM Technology), IBM shared how Sun World LLC is using IBM Cognos TM1 BI and analytics technology from IBM BP Applied Analytix t to "improve crop yields, reduce waste and expand its customer base, while providing more cost effective and energy efficient harvesting practices." The company's director of budgets and reporting describes how the use of analytics has allowed them to shift … |
Henrik Loeser |
Two days in France (in August for pureXML)If you live in France or are in Paris in the middle of August or want to be in Paris on August 17/18, here is what I **would** do: Attend a DB2 pureXML bootcamp. Susan Malaika and I will be running an intense, packed bootcamp which covers everything pureXML from basics over XML storage and indexing to performance best practices. The bootcamp will be held at the IBM Forum Paris. And yes, it's |
July 20, 2010
DB2 on Campus |
Free Data Studio webinar - Receive book for attending!This Tuesday, July 27th, I will be delivering a free webinar about the free IBM Data Studio software. Receive a hard copy of the book "Getting started with IBM Data Studio for DB2" just for attending!The presentation will show you all the possibilities available for database administration and development using Data Studio. Details: Date: Tuesday, July 27th Time: 11:30am - 1:00pm EST Link: <a href="https://de202.centra.com:443/GA/main/0000017cff6600000128b5… |
|
Triton Consulting |
Five Days in the labs – Part 3. DB2 pureScale Insert Load & ReplicationBy Clair Ross Following on from James Gill’s recent blog post about the Coupling Facility today I’m sharing with you our experiences of working with Insert Load & Replication in DB2 pureScale. In order to test the load capacity of the IBM DB2 pureScale machine we needed some test data and lots of it! Being somewhat familiar [...] |




The DB2 Express-C database server is downloaded worldwide, but broadband internet is not yet universal. Because of this, we are releasing a light version of DB2 Express-C 9.7.2 for Windows. It's an amazing 44% smaller than the full download.
