IBM Data Studio
provides an integrated data management environment that offers a comprehensive solution to help you design, develop, deploy, and manage database applications throughout the data lifecycle.
Give it a try!
Download IBM Data Studio Administrator for DB2 for Linux, UNIX, and Windows V2.1
at no cost.
Improve database administrators (DBAs) productivity and reduce application outages by automating and simplifying complex DB2 structural changes. This helps DBAs easily manage DB2 structural changes, while consistently ensuring data integrity and reducing application downtime. Enhancements for v2.1 include:
- New task assistants for common database administration tasks
- Faster navigation to the data sources you care about
- Initiation of tasks easily and intuitively from the Data Source Explorer
Download IBM Data Studio Developer V2.1
at no cost.
Improve development productivity up to 50 percent for developing and testing SQL, XQuery, and Java queries, stored procedures, Web services, and data access layers.
IBM Data Studio Developer 2.1 enhancements include:
- Reducing or eliminating SQL injection risk for Java database applications
- Giving developers more information to focus SQL tuning efforts
- Simplifying impact analysis for any databases changes
Not sure where to start? Check out these demos
that illustrate how a fictional company uses Data Studio software to enhance collaboration among team members for improved productivity and application performance while solving a real-world business problem.
Don't forget to sign up for the DataStudio newsletter
so you can keep on top of changes as they happen.
I don't know about you, but I find it pretty easy to learn something new every day! What did I learn today?
1. To better organize my blog. I was given the book Blogging for Dummies
by my friends at Wiley. I decided to read the book to see if there was anything that I didn't know... given that I've been blogging for 4 years! Yes, I did learn plenty and you'll benefit by seeing some changes. First off, I've gone back through my entries that were posted in the last year and put them into categories. Now you'll have a easier time of finding my old posts or related posts.
I also fixed a few broken links and cleaned up a bit. Do I have more to learn? Yes! I'm still reading the book and will use everything I learn.
2. Our community keeps growing! I was very happy to see that we now have more than 1100 members on channeldb2.com! See my post from a few months ago for some getting started with communities
information... What did I learn? There are 1100 members on channeldb2.com and 43 groups... but not many people join the groups. My favourite group is DB2 in Books
, for obvious reasons, but this group only has 39 members :< Can more people join? Or tell me why this group isn't appealing so I can improve it.
3. I've found a productivity wiki (inside IBM's firewall) and a link to some new IBM software (inside as well). Although I can't share what I've found... I'm glad I found it. I like to eliminate waste everywhere I can... especially if it makes it possible for me to get more done in a day.
4. Lotus Symphony
.... I must admit that I've been using Microsoft Office tools for awhile but was encouraged to try the new document, spreadsheet, and presentation software (thanks to Bob Picciano
). I've successfully created new documents and will now try to import all my previous documents into this new software.
5. I've heard about another blogger that I plan to check out: Todd Watson
6. In terms of social marketing, I'm reading the free ebook: Web 2.0 Marketing
. I've finished the first chapter: Measure Your Search Marketing Success and have new ideas about measuring the success of my blog. I'm looking forward to finding the time to read other chapters in this book as well.
That's all I can share today. Keep on learning!
Thanks to Farzana Anwar
from DB2 Information Development for this incredible list of sites that you might want to visit or bookmark.DB2 for Linux, Unix, and Windows
(Product Web site)This IBM DB2 product Web site contains information about the latest release and new features, links to important related Web sites, announcements about the release and more. This is a good starting point for information about DB2 for LUW.DB2 for Linux, Unix, and Windows Editions
(Product Web site)This product Web site provides information about IBM DB2 product editions. It contains information about the various editions of DB2 that are available. This Web site highlights the key features available with each edition and compares them in a tabular format. If you are not sure what edition of DB2 is appropriate for your needs this is a good starting point and reference.DB2 for Linux, UNIX, and Windows Features and Benefits
(Product Web site, Video with Sal Vella)This product Web site provides information about value-added features. It describes the value added features that are available to extend the core features available with a DB2 edition. Value added features are generally used to address specific business problems that might not be of general use to all customers. The value added features can be purchased separately and enabled with a separate license key.Overview of DB2 9.5
by Chief Architect Tim Vincent
(Podcast, mp3 file)This podcast which can be listened to or downloaded from the Voice of the DB2 Community Web site provides an overview of new DB2 9.5 features.Introducing DB2 9: DB2 Unveiled
(Article by Rav Ahuja
)This article contains a comprehensive overview of new features available in DB2 9.1 with a focus on how you can use the features to help lower business costs and improve business data management. It links to several related articles that describe specific features in more detail. The content also applies to DB2 9.5 and DB2 9.7 data servers. Compare the Distributed DB2 9 Data Servers
(Article by Paul Zikopoulos
)This article compares the various DB2 9.1 data server products. The content also applies to DB2 9.5 and DB2 9.7 data servers.Which edition of DB2 9 is right for you?
(Article by Paul Zikopoulos
)This article describes and compares the product specifications, licensing considerations, and specific features and capabilities of each edition of DB2 9.1. The content is generally also appropriate for DB2 9.5 and DB2 9.7.DB2 Version 9 Product and Packaging Information
(Technote)This technote explains the DB2 product packaging options that are available. It contains links to packaging information for DB2 data servers, clients, and add-on features.IBM DB2 9 New Features
(Book)IBM DB2 9 New Features is an easy-to-read book that includes illustrations and examples. The content applies to both DB2 9.1 and DB2 9.5 data servers, however new features in DB2 9.5 are not described in this book.
There were many more links in the document that Farzana sent to me... and I'll share the links with you over the next few days.
Did you know..... Information Management will have a major presence at this year's Lotusphere conference
with four pedestals and 11 sessions featuring Information On Demand solutions.
It is easy to see that the world is changing very quickly in front of our very eyes.... so does that mean we should begin ACTING differently? I think so. Where to start?Faster decision making
: IBM's next generation Lotus collaboration and WebSphere Portal technologies facilitate closer relationships among employees, customers, and partners - resulting in faster decision making.Trusted information
: Making great decisions requires the use of trusted information. Recent surveys indicate that almost 50% of business users lack confidence in their company's information. Information On Demand is designed to help enterprises unlock the business value of information by delivering timely and trusted information to employees, customers and partners.
So....By linking people with people
- and people with trusted information
- Information On Demand solutions tightly integrated with Lotus collaboration and WebSphere Portal technologies empower people to act on trusted information faster and with greater confidence.
Here are some of the ways for you to learn more about our integrated solutions:IBM Enterprise Content Management and Lotus Quickr
: the most complete single-vendor end-to-end content management solution in the industry.IBM Content Collector and Lotus Domino
: the comprehensive e-mail archiving and retrieval solution for any Notes database or server platform.Cognos 8 BI and WebSphere Portal
: out-of-the-box Cognos portlets for WebSphere Portal.InfoSphere MashupHub and Lotus Mashups
: the first complete mashup portfolio for business, empowering individuals to create situational applications. (Bundled & sold as IBM Mashup Center)DB2 pureXML and Lotus Forms
: efficient, integrated, and cost effective electronic forms solutions.
For a full agenda, see Lotusphere Agenda
I won't be at the conference, so if you are there, send those of us back in the office some details about what you liked the most.
I stumbled on this yesterday and have started to read this free downloadable ebook
, Web 2.0 Marketing
. This is a collection of chapters from 10 existing books that focus on the latest techniques on search marketing, PR 2.0, business blogging, email marketing, Facebook, YouTube, and more.
The chapters include:
Measure Your Search Marketing SuccessChapter 7 from book Search Engine Marketing, Inc., Second Edition
by Mike Moran
and Bill Hunt
. The Social Media News Release: An Overdue FaceliftChapter 7 from book PR 2.0: New Media, New Tools, New Audiences
by Deirdre Breakenridge
Don’t be cheap: email cuts other costs, so invest in itTruth 5 from book The Truth About Email Marketing
by Simms Jenkins
Blogging for Business Chapter 3 from book How to Win Sales & Influence Spiders
by Catherine Seda
Hosting Your Own Facebook EventsChapter 4 from book Facebook Marketing
by Steven Holzner
The New VesselsChapter 10 from book The New Language of Marketing 2.0
by Sandy Carter
How YouTube Can Help You Market Your BusinessChapter 1 from book YouTube for Business, Online Video Marketing for Any Business
by Mike Miller
. O.P.E.N. For Business Chapter 2 from book The Open Brand
by Kelly Mooney
and Nita Rollins
Customers Votes with Their MiceChapter 6 from book Do It Wrong Quickly
by Mike Moran
A social networking marketing plan is not a traditional marketing plan Truth 19 from book The Truth About Profiting from Social Networking
by Patrice-Anne Rutledge
If you like on of the sample chapters, you may decide to buy the entire printed book where the chapter came from.
Enjoy the free ebook: Web 2.0 Marketing
A recent article published in Certification Magazine
entitled Developing your Leadership Skills
by Katherine Spencer Lee lists some basic ways to develop into a leader:
1) Keep Learning2) Increase your Involvement3) Develop Your Communication Skills4) Serve as a mentor and/or mentee
I think that Katherine provides sound advice for all... and would like to embellish a bit with some suggestions in each of these categories:
1) Keep Learning
My blog is filled with suggestions for books, tutorials, and articles to read. I'll add to that list with some suggestions for books more in the business area:
* Reaching The Goal: How Managers Improve a Services Business Using Goldratt's Theory of Constraints
* Can Two Rights Make a Wrong?: Insights from IBM's Tangible Culture Approach
* SOA Governance: Achieving and Sustaining Business and IT Agility
* New Language of Marketing 2.0, The: How to Use ANGELS to Energize Your Market
* Search Engine Marketing, Inc.: Driving Search Traffic to Your Company's Web Site, 2nd Edition
2) Increase your Involvement
One of the best ways that I can suggest for you to become involved is via ChannelDB2.com
. With 1057 members as of today, this is the perfect place for you to get and/or share information with other database experts in the world.
As a reward for those who get involved, they have a chance to win the IBM Data Champion Award
. There is still time to nominate a champion... so if you have someone in mind, please go to the site and give them recognition. And who knows, maybe you'll be nominated next year!
3) Develop Your Communication Skills
You'll find loads of advice regarding how to improve your communication skills, just about everywhere you look, but the best advice I can give is that practice makes perfect. So look for opportunities to write, present, review, blog, podcast, etc. The more you do, the better you'll be.
I need to recommend a book as well! This is one of our classics, but is so highly rated that it is clearly a winner in providing advice for improving writing and reviewing skills:
* Developing Quality Technical Information: A Handbook for Writers and Editors, 2nd Edition
4) Serve as a mentor and/or mentee
Mentoring is such a key opportunity for improving both your skills and your network. Benefit from this book that was written by a team of IBMers: Drawing on IBM's experience, the authors demonstrate how to build a diverse portfolio of effective mentoring programs...use mentoring to strengthen organizational intelligence...build sustainable communities of mentors and mentees...promote collaboration across differences...and above all, link mentoring to strategy and use it to sustain competitive advantage.
* Intelligent Mentoring: How IBM Creates Value through People, Knowledge, and Relationships
All of the books I've mentioned in today's blog are IBM Press books. You may purchase these books in a number of places... the obvious is through amazon
. Direct from the publisher sites include:USA
and in India
, try our publishing partner Shroff Publishers
. If they don't have the book on their site, send a message to them requesting a book and they will see if they can sell it on their site.
And last, but not least, for electronic versions of these books, you can purchase Kindle
versions from amazon or subscribe to Books 24x7
or Safari Books Online
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 reference guide for developers and system administrators to fine-tune and troubleshoot Content Manager OnDemand Web applications.
* IBM Enterprise Content Management and System Storage Solutions: Working Together
This book provides the necessary information to IBMers, business partners, and customers on how to implement FileNet® ECM with IBM Storage Solutions.
* Introducing IBM FileNet Business Process Manager
This publication provides a basic introduction to IBM FileNet® Business Process Manager (BPM) V4.0. BPM enables organizations to create, modify, and manage content centric business processes. One key advantage of BPM is its ability to work with active content, which refers to the ability of content to trigger or affect business processes.
This book is useful for system architects, process analysts, and process designers who require an understanding of IBM FileNet Business Process Manager. It also serves as a practical guide for those who want detailed instructions in order to implement a BPM system.
* IBM FileNet Content Manager Implementation Best Practices and Recommendations
This publication covers the implementation best practices and recommendations for P8 Content Manager solutions. It introduces the functions and features of P8 Content Manager, common use cases of the product, and a design methodology that provides implementation guidance from requirements analysis through deployment and administration planning.
The book addresses various implementation topics including system architecture design, capacity planning, business continuity, repository design, security, and application design. Administrative topics covered include deployment, system administration and maintenance, and troubleshooting. We also discuss solution building blocks that you can specify and combine to build a solution.
This book is intended to be used in conjunction with the product manual and online help to provide guidance to architects and designers about implementing P8 Content Manager solutions.
See also Product Documentation
for IBM FileNet P8 Platform.
* Content Manager OnDemand Guide
This publication provides helpful, practical advice, hints, and tips for those involved in the design, installation, configuration, system administration, and tuning of an OnDemand system. It covers key areas that are either not well known to the OnDemand community or are misunderstood.
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, Python and PHP. These communities are in fact, increasingly embracing Mac OS X as their operating system of choice.
If you haven't already seen it, see also an announcement from Antonio Cangiano
Funny side note.... I own a Mac myself and when I tell people, they treat me like I'm a traitor to IBM! I'm quite pleased that IBM is not tying their software to a single platform and that we long term IBMers can happily and proudly say that we use a Mac... and our top tier software runs quite nicely on it.
As we approach the end of the year, you'll find that everyone has a list that they want to share with you. I like lists... and you can likely find a few in previous blog entries. But, this entry is about a few other lists that I've discovered when reading newsletters in the past week. I hope you find one or two of these interesting!The ten reasons why software companies lose in a losing economy?
by Judith HurwitzFive reasons why the Web Services Test Forum is critical Marcia KaufmanStress-Busters: 12 Ways to Renew Yourself
by Kathleen BartonEnterprise Web 2.0, Four part series
* Part 1 examines the business and technical drivers behind Web 2.0, the challenges and opportunities Web 2.0 presents to enterprises, and the relationship between Web 2.0 and SOA. * Part 2 covers the major solution types emerging through which enterprises can exploit Web 2.0. * Part 3 presents a collection of industry and business scenarios in which those solutions can be deployed, and explains the value that can be realised by doing so. * Part 4 is a more technical article focusing on the options for exposing the content and functions of core information and transaction systems such as IBM® CICS®, IBM Information Management System (IMS)™ and IBM DB2® in Web 2.0 solutions.1013 members of channeldb2.com.
37 groups that you can join, including my favourite DB2 in BooksFive new SOA certifications from the SOA Certified Professional (SOACP) programThe Top 10 stories of 2008: Not business as usual
from PCWorld.caThe 10 most embarrassing tech flubs that could happen to you
from ITBusiness.caFive competition classes available in "The Search for the XML Superstar"
Prizes include laptop computers, GPS devices, iPod® portable media players and PlayStation® games. All who register at http://www.xmlchallenge.com and complete a short quiz receive free tee shirts. Individuals can join contest groups at Facebook, LinkedIn, Twitter and Orkut. Contestants who invite a friend to enter earn points toward the XML Superstar Grand Master prize. The Grand Master prize is a Bose Wave Radio.
Happy Holidays everyone! See you in 2009.All the best to you and your family!
Two New Demos
: See Informix Dynamic Server products in action. Thanks to Carolyn M. Kniffin
for this information!
Watch how Informix Dynamic Server (IDS) products can deliver blazing online transaction processing (OLTP) performance, legendary reliability and nearly hands-free administration. IBM Informix Dynamic Server Enterprise Replication
:This illustrated demo shows the capabilities of IBM IDS Enterprise Replication and how it can help ensure an effective and consistent delivery of corporate data, enterprise-wide.IBM Informix Dynamic Server High Availability
:This illustrated demo presents IBM Informix Dynamic Server (IDS) High Availability solutions and how they can drive maximum business value and fully leverage your hardware and software investments.
> Read the blog posting in the DEMOcentral News blog
for more information> Watch the "IBM Informix Dynamic Server Enterprise Replication"
demo> Check out the "IBM Informix Dynamic Server High Availability"
I'm interested in what your answer is.... What new skills will you pursue in 2009?
1. XML2. SOA-related skills3. Database modeling and design4. Information systems design5. New programming languages and techniques6. Catching up with new features in DB2 and Informix7. Certification8. All of the above9. None of the above
From:IBM Database MagazineDecember 16, 2008Volume 9, Issue 26
At IBM... keeping our skills current is one of the most important goals we set for ourselves each year. But the typical human trait of procrastinating quite often sets in, leaving December the time when people scramble to take courses and exams! If you are like this... I have good news for you.... there are lots of options available for you. Here are five options:
1) Take a free ILO course. See this blog entry by Kate
2) Take a certification exam. You can take exams at Prometric Testing Centers
, so book your time now.
3) Which exam should you take? For exam objectives and cutscores for each exam, see the exam preparation documents
4) Read a book. See my blog entry for a list of my suggestions
5) Enter a contest. See my blog entry for some choices.
One of my favourite topics to blog about is ILO = Instructor Led Online Training
. Why? I think largely because I believe that this kind of training fits into modern life so perfectly. With the world focusing on "green" options, is there anything more green than attending a class to upgrade your skills while staying at home? With the financial pressures that the world is currently under, everyone needs to do their part to reduce costs, but keeping skills up to date remains CRITICAL. ILO provides the same excellent transfer of skills that you've come to expect in classroom training, but it eliminates the most expensive part of taking a class: traveling.
ILO also keeps getting better. This time with new scheduling options:
* ILO Select
provides targeted information in a packed lecture of three hours or less, at a much lower price than full training courses.
* ILO Flex Time
offerings enable you to experience the full scope of ILO from anywhere in the world over several days so that you can balance both work and education.
These two new ILO options give you the ability to enhance your skills when and where it is convenient for you.
And lastly, more ILO classes are being added all the time. See the list of featured classes below, but make sure you check the ILO website
to keep current on the latest courses that are available.Featured Courses
* 3E060 - (FREE) Basics of the Data Studio Environment- ILO Select * 3N120 - SQL Workshop - ILO Flex Time * 3N610 - Advanced DB2 SAP for Administrators - ILO Flex Time * 3S490 - HADR High Availability Disaster Recovery Implementation - ILO Select * 3S410 - Introduction to Data Sharing - ILO Select * 3S301 - Managing Informix DS Using the SQL Admin API and Scheduler - ILO Select * 3L242 - DB2 9 for LUW Multiple Partition DBA Workshop - Classic ILO * 3E120 - SQL Workshop - Classic ILO * 3L201 - DB2 9 Database Administration Workshop for Linux - Classic ILO * 3L211 - DB2 9 Database Administration Workshop for UNIX - Classic ILO * 3L231 - DB2 9 Database Administration Workshop for Windows - Classic ILO
Yesterday I blogged
about a few contests that were available for you to join. Today I want to remind you to nominate someone as an IBM Data Champion
to recognize exceptional contributions to the Data Management community.
Here are details from the website: Technical communities, Web sites, books, conference speakers and blogs all contribute to the success of IBM’s Data Management products. But these activities don’t run themselves. Behind the scenes there are dedicated and loyal individuals who put in their own time to run user groups, manage community Web sites, speak at conferences, post to forums and write blogs. Their time is uncompensated.
IBM is honoring the commitment of these individuals with a special designation — Data Champion — as a way of showing our appreciation for the time and energy these exceptional community members expend.
Data Champions are objective experts. They have no official obligation to IBM. They simply share their opinions and years of experience with others in the field, and their work contributes greatly to the overall success of Data Management.
Do you know an exceptional community member who should be recognized as a Data Champion? Nominate them today!
Do you need a few suggestions? Take a look at the blogs that you can read from Planet DB2
. You'll quickly see a growing community as well as prolific community members.
Also look at
for active DB2 members.
different contests for you to join:
* Video Contest
: Invent a creative use of XML, XQuery or DB2 and record yourself doing it.* Gadget Contest
: Develop a downloadable gadget or widget leveraging DB2.* Query Contest
: Use XQuery to find five answers. The best queries win the best prizes!* Ported App Contest
: Port or develop a new app for DB2. Enter as an individual or assemble a team.* XML Contest
: Win by building useful, user-friendly XML apps from scratch. Enter as an individual or assemble a team.
The Ported Application Contest
and pureXML Programming Contest
went live in the USA on December 1st! Four new countries are going live this month: France, Japan, Italy and Israel.
This competition consists of five different contests aimed at students
alike. Each contest offers its own recognition and set of prizes. The range of skills encompasses those with a passing interest in XML and database technology to those with hardcore programming skills in DB2. Before participating, you will first need to take a Quick Quiz, a short questionnaire that requires no prior XML or database experience to complete. You only have to take the Quick Quiz once.
Start now by registering for one of the contests. Earn participation points for each entry. A special prize will be given to the contestant— the “XML Grand Master”
—that amasses the most participation points.