Keep on Learning
Canada Day is tomorrow and it seems that everyone is already on vacation! The office is incredibly quiet and I'm not getting much mail.
This weekend is Independance Day in the US... and I'm looking forward to being in NYC for this celebration.
All the teachers and kids are finished school and many families are on vacation.
I hope you have a wonderfully fun summer... stay safe!
Quick - you want to learn about IBM technology...you a) put on slippers or b) don a conference badge? What's your favorite way to improve your technical skills? Help us improve the way we deliver IBM training by taking our quick online survey today.
CLICK HERE FOR 5 MINUTE SURVEY – NO Annoying questions about who you are and what you do for a living :)
If you have responses that weren’t covered in the survey… let me know!
Thanks very much!!!
Join Scott Hayes and special guest Burt Vialpando from IBM tomorrow (Friday June 18) on the DB2Night Show.
Burt will provide a side by side comparison of architectures, terminology, file system layouts, directory structures, administration commands, memory architectures, parameters, storage models and so much more.
If you are a DB2 LUW professional, after this session you will be able to understand your Oracle peers (really, it isn't a foreign language). If you are an Oracle professional, you will discover that the DB2 people aren't so strange after all.
If you've considered making the move to DB2, developerWorks has made it easier than ever to find out everything you need to know.
The new DB2 enablement page for DBAs and database developers is loaded with resources -- articles, tutorials, demos, webcasts, and more -- to help you understand the benefits of DB2 for Linux, UNIX, and Windows. Benefits like industry-leading performance, autonomic admin features, and lower costs.
Are you already working with another relational database management system (like, say, Oracle)? Why not find out how easy it is to migrate your applications to DB2 9.7? Plus, new SQL compatibility features in DB2 9.7 (including support for Oracle's SQL and PL/SQL dialects) make it easy to reuse your PL/SQL knowledge.
And for more on all of IBM's data solutions, stop by our Information Management zone here on developerWorks.
And don’t forget the great books that are available for you to make the move to DB2:
Beginning DB2: From Novice to Professional
Understanding DB2®: Learning Visually with Examples, 2nd Edition
Improve performance by 74%, while lowering data costs and downtime by up to 40%
Modern day levels of high-velocity data growth have put increased pressure on today's database management systems to support increasingly complex workloads, applications and service levels to meet business demand.
Attend our upcoming seminar to learn how IBM's integrated server and DB2 software offerings can help you improve application performance by up to 73% while lowering your data management costs by up to 40%.
Register today by calling Jen Tobin at (617) 431-9722 or completing our quick online registration form.
WHY YOU SHOULD ATTEND:
Whether you’re considering a new information infrastructure or are interested in learning how to meet next generation database workloads, attending this complimentary seminar will enable you to:
Switching information platforms has never been easier or more cost-effective. Find out how to break free from high data management costs while minimizing IT complexity, reducing energy consumption and improving service levels.
Register today by calling Jen Tobin at (617) 431-9722 or completing our quick online registration form.
DW 2.0 - Architecture for the Next Generation of Data Warehousing
Data Warehousing has been around for 20 years and has become an integral part of the IT infrastructure. In this session Bill Inmon, the "father of data warehousing" will discuss the evolution of DW 2.0 and the future of data warehousing that is technologically possible now, at both an architectural level and technology level. Discover how your organization stacks up as Bill explores the overall architecture requirements and delves into the underlying components to help you determine: what new technology to buy, how to plan extensions to the data warehouse, what can be salvaged from the current system, and how to justify the expense--at the most practical level.
You’ll walk away with a comprehensive overview of how best to implement the necessary technology and tools to enable the new generation of the DW: metadata, temporal data, ETL, unstructured data, and data quality control.
Meeting your Next Generation Database Needs
The automation of database admin tasks and sophisticated workload management capabilities are redefining how easy it is to optimize performance for your database software, while industry leading XML data management and data compression capabilities ideally position DB2 to handle your evolving workloads. When these features are tightly integrated with IBM servers to deliver workload-optimized systems, organizations are realizing benefits such as improving performance by up to 73% and lowering costs by up to 40%. Learn how organizations like yours can realize such benefits too.
POWER7 servers are a new generation of Smarter Systems
The new Power systems feature virtualization without limits, resiliency without downtime, dynamic energy optimization, and management with automation. Learn about the workload optimized features that make these systems the choice for both transaction processing and throughput processing - features that can dramatically reduce your costs and improve service to your end users.
Moving to IBM DB2 has Never Been Easier, Cheaper and Faster
In this session you'll learn about the built-in feature's of IBM DB2 that enable smoother, easier migration from other database platforms. In particular, IBM DB2 9.7 enables you to port applications written for a different database, with minimal or no change to your code. In addition, switching to DB2 can reduce operational costs and increase throughput through innovative technologies packed into the heart of the database engine. Learn how a move to DB2 guarantees these benefits, coupled with DB2's strong tradition of reliability, resiliency, and availability.
Smart Warehousing, Smart Decisions with the IBM Smart Analytics System
The recent surge in data warehouse technologies and appliances has led to a lot of hype surrounding the business intelligence (BI) and analytics space. Find out why IBM is uniquely positioned to deliver the most comprehensive workload optimized solution – one that includes not only an integrated data warehouse on IBM Servers – but also the required BI reporting, data mining and OLAP capabilities expected to make smart decisions. This session will provide an overview of how IBM’s Smart Analytics System can provide your organization with BI capabilities to hit the ground running with scalability to grow and adapt as your analytic requirements change. You'll also hear concrete examples from current customers using the technology.
Optimize your SAP system by significantly reducing the TCO
Architected, integrated and optimized together DB2/SAP on Power is the best combination for your SAP applications. Come and learn why customers including SAP have chosen to run their SAP applications on DB2. Over 100 customers migrated with 100% success to DB2 in the past 6 months, come talk to the thought-leaders as to how you too can benefit from DB2/SAP on Power – you will be able to reduce the memory, storage significantly while still getting superior SAP system performance.
Best Practices: Managing DB2 for Oracle® Applications and beyond
Attendance is limited. Reserve your seat today by calling Jen Tobin at (617) 431-9722 or apply online.Susan
JayAllen 120000G6WH 3,836 Views
Testing remote blogging
I don't know about you, but I keep running into examples in the world where technology could be used to improve the experience. Here are a few recent examples:
A friend of mine was charged a fee for not using her chequing account for a 3 month period. When she called the bank they told her that they are trying to encourage people to come into the branch. That doesn't make much sense... but that's what they said. So, my friend plans to write herself a cheque every month for the amount of $1 and deposit it into the same account. Complete silliness!
I've been using the Toronto Transit lately and the last time I needed to buy tokens, I noticed two things. First of all, you can only buy tokens for cash. Credit cards are not accepted. I can use my credit card to pay $1.50 for parking somewhere, but can't buy 8 tokens for $20 unless I pay cash. The day I was there, the machine wasn't working, so I had to walk a fair distance to find a ticket booth that had an employee to sell me tokens. I don't carry cash very often, so I must first find a bank machine. Don't you think this could be easily automated and simplified?
In some cases the technology exists, but someone chooses to bypass the technology and end up making the experience a miserable one. For instance, I ordered a Blackberry that was to be shipped to my home via UPS. The phone company I purchased the Blackberry from decided to limit UPS in how and when they delivered the phone to me. UPS could only deliver during regular business hours when it just so happens that I'm at work! I asked for them to deliver to the local UPS store so I could pick up the phone after hours, but again the phone company restricted UPS and forced them to deliver to their central warehouse which is very far from my house. I should have cancelled the phone, but instead I had to work from home in order to receive the shipment.
What can we do about all this stupidity? IBM's current campaign about a SMARTER PLANET is the ultimate answer... and hopefully they are successful in improving the situation somewhat.
There are three books that I've read where the answer is provided... and I encourage all to read these books and help find people to build a smarter planet:
Also take a look at some cool videos that IBM put together:
Do you have examples of stupidity as well? Share them if you like.
Thanks to Leons Petrazickis for reminding me about the DB2 Wiki. Leons was able to add a recently written white paper to the site and I thought this would give me a good opportunity to tell you what you can find on this site.
The white paper that was just added is:
Authors: Andre Albuquerque, Irina DelidjakovaThis paper will help you get started with DB2 Express-C and Virtuozzo Containers for Linux. Combined with Parallels Virtuozzo Containers 4.0 for Linux®, DB2 Express-C software can be a powerful addition to your information management infrastructure. Virtuozzo Containers offers a high-performance, space-efficient operating system virtualization solution that you can use to create new virtual machines, also known as containers,within seconds.
What else can you find on this wiki?
This wiki contains an extensive list of articles, publications, tutorials, and other DB2 material. Check the appropriate document in this wiki to see the full list.
These are our latest featured DB2 articles and tutorials. This is just a small subset of all the material available in the wiki, so if you don't see what you need in this list, check the complete listings.
I hope you find something of interest on this site. If you have or know of content that should be placed here, let me or Leons know and we'll see what we can do.....
Have you seen Leon's recent blog entry?
My last post about the DB2Night Show was in error... I said that Mark Wilding was the special guest this week... but it's actually Mike Winer! I'm sure Mark will be rescheduled for a future show.
So, what's Mike Winer going to talk about? I was a recent guest at his new cottage, but I'm sure that topic won't come up! Instead, he's talking about DB2 Locking. Mike was at the IDUG Tampa conference and at last week's CCDB2UG, so if you missed those talks, you'll be able to catch up in this special 90 minute webinar with Scott Hayes.
Educate - Inform - Entertain ...
The DB2Night Show Episode #22
by Abhishek Sanghani
Over 80 great recipes for taking control of Cognos 8 Report Studio
Cognos Report Studio is widely used for creating and managing business reports in medium to large companies. It is simple enough for any business analyst, power user, or developer to pick up and start developing basic reports. However, when it comes to developing more sophisticated, fully functional business reports for wider audiences, report authors will need guidance.
This book helps you understand and use all the features provided by Report Studio to generate impressive deliverables. It will take you from being a beginner to a professional report author. It bridges the gap between basic training provided by manuals or trainers and the practical techniques learned over years of practice.
This book covers all the basic and advanced features of Report Authoring. It begins by bringing readers on the same platform and introducing the fundamental features useful across any level of reporting. Then it ascends to advanced techniques and tricks to overcome Studio limitations.Develop excellent reports using dimensional data sources by following best practices that development work requires in Report Studio. You will also learn about editing the report outside the Studio by directly editing the XML specifications.
Learn techniques and hacks to make the best out of your Cognos 8 Report Studio
What you will learn from this book
Written in cookbook style, this book offers learning and techniques through recipes. It contains step-by-step instructions for Report Studio 8 users to author effective reports. The book is designed in such a way that you can refer to things chapter by chapter, and read them in no particular order.
You will see a new fictional business case in each recipe that will relate to a real-life problem and then you will learn how to crack it in Report Studio.
Who this book is written for
If you are a Business Intelligence or MIS Developer (programmer) working on Cognos Report Studio who wants to author impressive reports by putting to use what this tool has to offer, this book is for you. You could also be a Business Analyst or Power User who authors his own reports and wants to look beyond the conventional features of Report Studio 8.
This book assumes that you can do basic authoring, are aware of the Cognos architecture, and are familiar with Studio.
SPVC courses are self-paced online training that offer you the flexibility to take training when and where you want.
With several courses available in trial format, you can experience this exciting new learning method first hand at no charge!
Take these new SPVC courses today:
1L610T - Trial version of Advanced DB2 SAP for Administrators
1WA52T - Trial Version of InfoSphere Warehouse Components 9 – SQL Warehousing Tool and Administration Console
2X101T - Trial Version of Developing Applications Using Informix 4GL
For more information, see the SPVC website.
Once you try this format for learning, you may give up on all other methods! Let me know what you think.
We're down to the wire... only 4 episodes remaining in the premier season of the DB2Night Show.
Ergin Babani discusses the REDISTRIBUTE command with Scott Hayes in tomorrow's episode (June 4, 11:00 am Eastern).
June 11 – IBM Mark Wilding on DB2 in the Cloud – a technical talk – probably Part 1 of 3 part series. June 18 – Comparing DB2 LUW and Oracle by IBM’s Burt Vialpando June 25 – Our Season 1 show FINALE – Berni Schiefer returns with DB2 LUW Storage I/O optimization
June 18 – Comparing DB2 LUW and Oracle by IBM’s Burt Vialpando
June 25 – Our Season 1 show FINALE – Berni Schiefer returns with DB2 LUW Storage I/O optimization
PS..... If you've missed any episodes, remember that they were recorded and can be found on the DB2Night Show site.
IBM's Information on Demand (IOD) Conference took place in
My purpose at the conference was to sell books to attendees, but I wasn't able to arrange for a bookseller to set up shop. I'm not able to sell books myself so I promoted both electronic books and buying books directly from the publisher.
Safari Books Online joined me as they provide one of the available options for electronic books. Erin and Martin from Safari were giving demonstrations of their system to attendees. We gave out bookmarks that promoted a free trial subscription for people to try Safari. The URL is: http://safaribooksonline.com/requesttrial/ (Feel free to give it a try!) IBM has a corporate license to Books 24x7 which provides a similar service, but there are fewer technical books than are available via Safari Books Online.
The books we've published through IBM Press, MC Press, Apress, and Packt can be purchased in the traditional print format, Kindle format, PDF format, or through online book engines such as Safari Books Online and Books 24x7. Although owning a book reading device is nice, it isn't necessary. There are apps that run on smart phones and computers to optimize the online reading experience.
I brought my Kindle to the conference to show people technical content on this device. I don't think that it is the best option for technical books. I've downloaded all the readers and find the PC eReaders to be very good. I suspect that iPads will be suitable, but have not been able to use one yet.
The publishers who I work with sent me a sample copy of each book I requested. I likely had 50 books in total. These were merely for display so the attendees could browse through the books and to see the range of tit
Magnus Lindkvist, keynote speaker and facilitator
Author of Book: Everything We Know Is Wrong – The Trendspotter’s Handbook
Magnus brought copies of his book to the conference and sold nearly 100 copies for cash.
Mario Godinez, Eberhard Hechler, Klaus Koenig, Steve Lockwood,
Authors of Book: The Art of Enterprise Information Architecture
IBM purchased 300 copies of this book to be given to qualified attendees. Attendees needed to attend a session hosted by one of the authors or to visit the InfoSphere Demo Room. The event was very successful and all the books were claimed in about an hour.
I arranged to have a number of the previously published flashbooks available to hand out. These included:
New Intelligence for a Smarter Planet – Driving Business Innovation with IBM Analytic Solutions
Break free with DB2 9.7: A Tour of Cost-Slashing New Features
Information on Demand for Dummies, 2nd edition
SAP DBA Cockpit - Flight Plans for DB2 LUW Administrator
I had about 50 copies of each title and they were very well received. Some of the books were moved to the Education Zone to attract / reward people who visited.
I was able to meet with many authors and potential authors! This networking has resulted in more books in the pipeline. I'll have more information on the tit
James Lumsden from Packt Publishing flew into
I met an IBM university ambassador for
Since this was the first time showcasing books at a conference rather than selling them, I learned a few things that I'd like to improve for future events:
Since I had books from 5 or 6 different publishers, it was difficult for me to give one URL for people to go to for our books. Our bookstore website needs to be redesigned and updated to include all the relevant books in both electronic and printed format.
I need a piece of collateral that can highlight the messages we can give to the customer about the book strategy. This can be a flyer, postcard, or bookmark.
DB2 9.7 brought the biggest infusion of SQL features since DB2 V2.1. In this presentation, learn about features that lead to a ten-fold reduction in enablement costs when Oracle-based applications are enabled for DB2. The virtual tech briefing covers the following:
IOD EMEA which took place in Rome last week was a huge success. I'm working on my trip report and will post some of it here.
Monday and Tuesday next week, I'll be at the Toronto conference CCDB2UG where the Central Canada DB2 Users Group is celebrating their 25th anniversary! I'm quite looking forward to my annual visit with some of the most amazing people I've ever met. For more information, see this blog entry I did recently: Local Conference - Central Canada User Group.
I've already began planning for our huge IOD event that will take place in Vegas the last week of October. I'm looking forward to see the sessions and speakers who have been chosen for the event. The bookstore is arranged already, so just the signings are left to plan. I'm hoping this year that we have the book signing events included in the agenda builder so you won't miss what the signings that you want to attend. More on this conference coming up.
I've talked to a few people about the IDUG conference that is taking place in Vienna the second week of November. I'm not sure what my involvement will be at this point, but it would be a nice one to attend, don't you think?
There are many free webinars that are coming up soon... I hope you are able to take advantage of the amazing content that is available to you for free! I know time is always a factor, but most of the webinars are recorded so you can benefit from the content after the fact.
My favourite ones are:
1) DB2Night Show - tomorrow is Sam Lightstone, and there are several more speakers planned for the coming weeks.
2) Chat with the Lab - there was an event today, but you can keep on top of the scheduled and recorded events by joining this group: Channel DB2 Chat with the Lab
3) Surekha Parekh does a fine job of informing the world of the events surrounding DB2 for z/OS. I strongly suggest that you join one of the groups that she posts to in order to stay on top of what's happening. The World of DB2 for z/OS is one of the places she updates regularly.
svisser1 2700018UK9 Tags:  lightstone hayes live career db2night_show software making_it_big 6,391 Views
Don't miss Sam's appearance on the
Get your copy of book:
•This book is designed to reach out to a wide client audience on a global basis leveraging IBM‘s vision and products in the Information Management area.
If you are at the IOD2010 conference taking place in Rome, come by the Bookstore at 1:15 pm to get your free copy of this book. The author team will be signing copies and look forward to meeting you to discuss your Information needs. . Get your coupon at the InfoSphere booth in the expo to get your free book.
Magnus is a trendspotter and futurologist based in Stockholm, Sweden, his mission is to help companies make sense (and money) out of future possibilities and inspire people into action. He founded his company Pattern Recognition AB in 2005 and have a mix of large conglomerates and nimble upstarts within finance, energy, media and IT on the client list. Furthermore, he was elected Sweden’s Business Speaker of the Year in 2009.
Leveraging Spatial Capabilities in your Database
Date: 5/27/2010 (Thursday May 27, 2010)
Time: 11:30 AM - 1:00 PM Eastern (GMT-04:00)
10:30 AM Central / 8:30 AM Pacific / 16:30 hrs London / 17:30 hrs Frankfurt, Paris / India 9PM
Presented By: Sal Vella (IBM), David Adler (IBM)
This chat introduces the spatial capabilities of IBM relational databases, focusing on the DB2 LUW Spatial Extender. Much of the business data that we work with has a spatial characteristic, such as customer or office locations, sales regions, hazard polygons or facilities such as utility lines and highways. By representing this spatial information in a relational table as spatial datatypes, SQL queries can incorporate spatial functions to perform spatial analysis in the database. Business value is derived by being able to answer questions like:
- where are customers who may be interested in buying flood insurnce?
- what are the patterns of high crime activity
- should a new service center be constructed to support new customers
- where are preferred service providers along a route I plan to take
DB2 with the Spatial Extender is being used to answer these questions.
To learn more join experts from IBM labs - Sal Vella and David Adler.
Presentation charts for this Chat will be downloadable from ibm.com/db2/labchats
To register for this event and receive instructions for attending goto:
If clicking the above link does not work, please copy the entire link and paste tinyurl.com/spatialdb into your Web browser.
For questions/comments/suggestions: http://www.channeldb2.com/group/db2chatwiththelab
How and why do companies use XML? In which cases do they decide to store, index, and query XML in a databases? What are some of the common patterns for such XML usage?
Join XML expert Matthias Nicola to hear the answers to these questions in a Webcast on May 18, at 11am US Eastern Time (15:00 GMT).
He will describe XML use cases that are applicable to a variety of industries, such as finance, insurance, healthcare, and government, and discuss the benefits that XML brings to these application scenarios.
The webcast will be of interest to users who are new to managing XML in a database as well as to experienced XML practitioners. It will also benefit IT architects who have an interest in XML strategies. Basic understanding of databases and of XML will be useful for this webcast.