Coming soon to an online bookstore near you: http://www.amazon.com/Understanding-DB2-Security-Rebecca-Bond/dp/0131345907
Understanding DB2 9 Security (Hardcover) by Rebecca Bond, Kevin Yeung-Kuen See, Carmen Ka Man Wong, Yuk-Kuen Henry Chan
Rebecca is a long time consultant who works on DB2 projects. Kevin, Carmen and Henry are employees of the Toronto Lab who have built expertise in Security. You may be read articles on dWorks from Kevin, Carmen or Henry:
By Kevin: DB2 UDB security, Part 2: Understand the DB2 Universal Database security plug-ins Learn about the DB2 UDB security plug-ins, a new feature introduced in version 8.2. This article explains what the security plug-ins accomplish and teaches you how to enable and write your own security plug-ins. http://www.ibm.com/developerworks/db2/library/techarticle/dm-0512chong/
DB2 UDB security, Part 6: Configure Kerberos for authentication on DB2 UDB for Linux, UNIX, and Windows Using Kerberos for authentication provides a central repository for user IDs (or principals), thus centralizing and simplifying principal or identity management.http://www.ibm.com/developerworks/db2/library/techarticle/dm-0603see/
DB2 security, Part 7: Object ownership management for DB2 9 Transfer ownership is a new DB2 9 feature where the ownership of a database object can transfer to another authorization ID (authid). There are two general usages for this feature. http://www.ibm.com/developerworks/db2/library/techarticle/dm-0608see/
DB2 security, Part 10: Deploy customized security plug-ins in DB2 9 Determine what should be tested before deploying your own customized security plug-ins. Accompanying this article, there is a security plug-in loader program. This article also discusses how to take advantage of the new enhancements to the security ... http://www.ibm.com/developerworks/db2/library/techarticle/dm-0610see/
DB2 Label-Based Access Control, a practical guide, Part 1: Understand the basics of LBAC in DB2http://www.ibm.com/developerworks/edu/dm-dw-dm-0605wong-i.html
DB2 label-based access control: A practical guide, Part 2: A step-by-step guide to protect sensitive data using LBAChttp://www.ibm.com/developerworks/edu/dm-dw-dm-0605wong2-i.html
Co-author on one of the articles from Kevin: DB2 UDB security, Part 6: Configure Kerberos for authentication on DB2 UDB for Linux, UNIX, and Windows Using Kerberos for authentication provides a central repository for user IDs (or principals), thus centralizing and simplifying principal or identity management.http://www.ibm.com/developerworks/db2/library/techarticle/dm-0603see/
Order the book at a discount from http://www.ibmpressbooks.com/bookstore/product.asp?isbn=0131345907&rl=1
Keep on Learning
svisser1 2700018UK9 2,887 Views
Have you heard of the DB2 Detective Game? I was part of a small team that created this game a few years ago with the objective of teaching people how to query a DB2 database. Our original audience was a SHAD Valley group of high achieving high school students (http://www.shad.ca/). One of the people on our team was a former SHAD grad who was on a coop term at IBM. Teaching the students was an amazing experience. They like the competitiveness of playing a game, but it was astonishing how quickly they picked up the skill of writing queries to get important information from the database.
The game has gone through many iterations of improvements and is now called the DB2 business game and is available on developerWorks for all to "play". Give it a try....
Here are the details:
The DB2 business gamehttp://www.ibm.com/developerworks/edu/dm-dw-dm-0609cao-i.htmlTest your DB2 querying skillsLevel: Introductory
If you're a beginner with IBM® DB2® and SQL, you may wonder how the technical skills you're learning are used in the "real world." Here is a chance for you to put your DB2 SQL skills into play in this interactive game! Jump into a "run your own business" scenario, where your company's future depends on a key report needed to secure funds for a critical upgrade. Use your relational database skills to build this report.
Put your DB2 SQL skills into play using a "real world" business scenario.
At the IOD conference, we lauched two brand new DB2 certifications. Exam 730 DB2 9 Fundamentals and Exam 731 DB2 9 Database Administration.
• New DB2 9 Fundamentals Professional Certification Now you can validate your skills and demonstrate your proficiency on IBM DB2 9 technology by becoming an IBM Certified Database Associate - DB2 9 Fundamentals. To achieve this new level of certification, candidates must take and pass the brand new exam DB2 9 Fundamentals- Exam 730. See http://www.ibm.com/certify/certs/dbda9fun.shtml for details on the exam objectives, cutscore, number of questions, and more.
• New DB2 9 DBA for Linux UNIX and Windows Professional Certification Demonstrate your DBA proficiency on IBM DB2 9 technology by becoming an IBM Certified Database Administrator – DB2 9 DBA for Linux, UNIX and Windows. To achieve this new level of certification, candidates must take and pass the brand new exam DB2 9 DBA for Linux, UNIX and Windows- Exam 731. See http://www-03.ibm.com/certify/certs/dbdadba.shtml for details on the exam objectives, cutscore, number of questions, and more.
The books to help you prepare these exams are currently being written. In the meantime, I suggest that you study via the tutorials that have been created: http://www.ibm.com/software/data/education/selfstudy.html#5
These tutorials provide a solid base for each section of the two new DB2 9 Professional Certification exams which have just been released. There is a series of 7 tutorials developed to help you prepare for the new DB2 9 Fundamentals Exam, 730 and a series of 7 tutorials developed to help you prepare for the new DB2 9 DBA for Linux Unix and Windows Exam 731. After a quick registration, you can begin a tutorial. Each tutorial should take about an hour to complete. You can take the tutorials on-line, or download a PDF or zip file.
Tomorrow I'll tell you about some of the other new exams that were recently launched and will tell you about the exams that are under development.
svisser1 2700018UK9 2,685 Views
Have you had a chance to check out the IBM Information Server Guided Tour and Demo? It provides a graphic "guided tour" and demonstration of IBM Information Server that was announced at the IOD conference.
To get to the demo: http://www.ibm.com/software/sw-library/en_US/detail/N182391G31164I31.html
I'm way behind on my blogging, but plan to get back on track today!
svisser1 2700018UK9 2,612 Views
Wayne Brady from the TV show "Whose Line is this Anyway?" was the host of the keynote session this morning. He was hilarious! He had us laughing so hard that it hurt. The funniest scene was with an audience member named Mark who "was wearing Friday casual on a Monday". Ambuj Goyal delivered the keynote interspirsed with interesting video customer references. Likely the most memorable was one from Harly Davidson.
No one introduced the female rap singer who performed during the opening. She did wonderful job of working in tons of IBM related terms into a rap song. If anyone knows who she was, let me know.
I had another Devon Harris book signing starting at lunch time. Many books were sold and it was interesting to hear how moved everyone was with his story. By the way... the movie Cool Runnings that was based on the Olympic Jamaican bobsled team that Devon was part of.... was fiction..... and there are four "original" bobsleds spread across many locations in the world! Devon emailed me with his newsletter and to tell me that his flight was delayed and he spent 5 hours in LAX waiting for his flight to NY.
My big event of the week took place after Arvind Krishna's keynote about data servers. I had arranged to have every attendee of Arvind's session receive a copy of the "Introduction to DB2 9 New Features" book that is an abridged version of the McGraw-Hill book that will be published in December written by Paul Zikopoulos, Chris Eaton, George Baklarz, and Leon Katsnelson. George isn't at the conference this week, but the other three were really good sports at signing hundreds of books! The biggest complaint I heard is that Leon's signature is illegible! I hope you enjoy reading the book!
After the session, I delivered left over copies to the Hilton hotel where the executive sessions are taking place. Bruno Bagala helped me find suitable locations for the books. I managed to make it back to the Expo before the Hampton String (Rock) Quartet were finished playing and got a bite to eat before the Gladys Knight concert. Hampton String Quartet were amazing! They play extremely well known rock songs with string instruments. Definately worth checking out!
Gladys Knight was also amazing. I knew fewer songs than I thought I would but she has a very sweet personality. It was funny when she made a comment about the audience being at show with people who they loved. We all laughed.... since we were actually there with our co-workers....
After the concert I went to the party in James Sobieski's party at the Hilton. I walked to the party with Sandra Beattie, Terry Mason, and Susan Gausden. There was no shortage of food at this party! I ate as much as I could before I was too tired. I spent a bit of time talking to my good friend Catalin Comsia. I loved hearing his story about his races and soccer. If you know Cat, ask him about being offered a new job as a soccer goalie!
I was also invited to Frank Filmore's party, but unfortunately I ran out of steam before I was able to make it there..... I hope I'm able to spend time talking to Frank and Ray before the week is over.
svisser1 2700018UK9 2,634 Views
I arrived in California at noon on Sunday for the conference and was pleasantly pleased with how warm the weather is here compared to Toronto! I arrived just in time to organize the signing of Devon Harris's book "Yes, I can". It was amazing to meet Devon and he clearly is inspirational. His talk was at 8 am on Sunday morning, so unfortunately many people weren't able to attend his talk. I hope that if you have a future opportunity to meet or hear Devon that you take it!
Sunday night the opening reception was held in the Expo area and the band "Toxic Audio" played. They are five lovely accapella singers who have an amazing amount of energy! The music was beautiful and the band was fun to listen to. We had a signing for their CD after their show, but unfortunately it was in a very bad location so we had very few people. The band was a good sport about it anyway.
Now work stuff.... I met up with Berni Scheifer on the plane and he gave me a few performance related topics to blog about that I'll get to later. Ellice Uffer, my colleague on IBM Press, tells me that she has self-published a book about her puppy... when I get her website I'll post it.
I spent some time with conference organizers Carolyn Woods and Bonnie-Lynn Murphy to go over some logistics for the next couple of days. Apparently Carolyn wore a pedometer to the conference and clocked 13 miles in a single day!
It makes for a very long day traveling from Toronto to Anaheim and working at a conference until 10 pm!
more to come.....
svisser1 2700018UK9 2,701 Views
I'm spending a good portion of each day now getting ready for the big IOD conference that is only a few weeks away! I guess I should book my flight soon!
One of the things that I am doing this year is arranging for authors, speakers, or entertainment to sign either their books or CDs. Make sure you bring a bit of spending money, as I'm sure you'll be very interested in buying at least one book or CD, either for yourself, or as a gift for someone special to you.
The one I'm most excited about is the children's inspirational book by Devon Harris, the Jamaican bobsled Olympian. I haven't yet met Devon, but I've been told that not only is he talented and good looking, but he is a super nice person as well. I've arranged to have Devon available to sign his book on two separate days. Here is a link to Devon's site: http://www.devonharrislive.com/.
Gladys Knight will be performing at the conference, but is not available to sign her CD.... unfortunately. She is required to travel immediately after the show for another event. Her CD, however, will still be available for sale at the conference.
There are two other entertainers who will be selling their CDs. I've never heard of either of them, but in doing my research, I'm sure they will be amazing shows and the CDs will be worth buying. The bands are Toxic Audio and Hampton String Quartet. Toxic Audio (http://www.toxicaudio.com) is an acapella band that borders on comedy. There may be room for audience participation too, but I'm not sure. The Hampton String Quartet (http://monalisarecords.com/basic/details/takeNoPrisonersCDDetail.html) play classical rock music such as Zeppelin, the Stones, the Who, and more.
Michael Eisner has agreed to sign copies of his latest book called "camp". It is a book about his personal experiences as a child at a camp in Vermont that shaped Michael's life and allowed him to be the success that he is.
Beyond the "big" names, we also have some lesser known, but equally important authors available to sign their latest creations: Paul Zikopoulos, Chris Eaton, Leon Katsnelson, Chris Stakutis, and John Todor.
The bookstore at the conference will have these and many more books available for sale at excellent prices. I hope you are able to take advantage of some of these deals, and most importantly, the rare opportunity to get a celebrity to sign their work.
svisser1 2700018UK9 2,651 Views
Have you checked out the DB2 XML (pureXML) wiki yet?
This wiki was designed to help you come up to speed quickly on DB2's XML technology. You'll find links to many tutorials, reference papers, and other resources that explore DB2's support for managing, storing, and querying XML data. Here are the main subsections:
* News * Books and magazine issues * Technical papers and articles * Webcasts and demonstrations * Free software downloads * Education
To keep informed about new materials posted to this site, you can create your own RSS or ATOM feed.
svisser1 2700018UK9 3,245 Views
Here's another book that was just recommended to me:
Querying XMLXQuery, XPath, and SQL/XML in context (The Morgan Kaufmann Series in Data Management Systems)by Jim Melton, Stephen Buxton
Foreword by Don Chamberlin
Although the book was written BEFORE the release of DB2 9, it is an excellent product-indepentant book that can help you learn how to query the XML you wish to store in a database.
From the Back CoverThere is no more authoritative pair of authors on Querying XML than Jim Melton and Stephen Buxton. Best of all, as readers of Jim's other books know, his informal writing style will teach you what you need to know about this complex subject without giving you a headache. If you need a comprehensive and accessible overview of Querying XML, this is the book you have been waiting for.-from the foreword by Don Chamberlin, IBM Fellow, Almaden Research Center
Enjoy! Susan[Read More]
svisser1 2700018UK9 2,818 Views
Last month we published an ebook entitled: DB2 9: pureXML Overview and Fast StartYou can find this ebook on the redbook site: http://www.redbooks.ibm.com/abstracts/sg247298.html
This ebook is a collection of important XML articles that previously appeared on devworks, written by Cynthia M. Saracco, Don Chamberlin, and Rav Ahuja. We feel that this is the essential group of articles that you need to read to quickly become aware of how XML would benefit your company.
Here is the Table of Contents:Chapter 1. Managing XML for maximum returnChapter 2. What’s new in DB2 9: XML to the core Chapter 3. Get off to a fast start with pureXML Chapter 4. Querying XML data with SQL Chapter 5. Querying XML data with XQuery Chapter 6. Developing Java applications for XML data Chapter 7. Case study: Storebrand Foreword by Sal Vella; V.P., IBM DB2 Development:
Services Oriented Architectures (SOA) are an integral part of building an agile enterprise capable of making decisions quickly, and responding rapidly to new products and services opportunities, as well as to competitive threats. The explosive growth of XML data in businesses today across multiple industries has underscored the role of XML as the "fabric of Services Oriented Architectures" and the need to integrate XML data into enterprise information infrastructure.
DB2 9 (previously code-named “Viper”) enables an information-centric approach to service oriented architecture implementations, which rely upon the ability to access a myriad of data stored across multiple formats. With its dual pure XML data management and traditional relational data capability, DB2 9 delivers information as a service in SOA environments, connecting information on-the-fly, where you need it, and when you need it!
XML data requires the same coveted qualities of service that relational databases provide: high availability, reliability, protection, and performance. The pureXML™ technology in DB2 9 unlocks the latent potential of XML by providing simple efficient access to XML with the same levels of security, integrity, and resiliency taken for granted with relational data. With pureXML innovation in DB2 9, your organization can expect breakthrough increases in availability, speed, and versatility of your XML information, along with dramatically reduced development and administrative costs.
This IBM Redbook serves as an introduction to the hybrid XML data services in DB2 9 for Linux, UNIX, and Windows. It also provides data server professionals a fast start for using and exploring pureXML capabilities in DB2 9 and get them started with leveraging XML information for maximum return.