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,956 Views
svisser1 2700018UK9 2,929 Views
Last year I met a student name Ankit Asthana who was working in the Toronto Lab for the summer. Ankit came to me to see if I was able to help him publish a book that he had written on a previous co-op term. I'm not sure if I was much help at all, but Ankit's book was recently published by New Age International: C++ For Beginners.....Masters.
Congratulations Ankit! I hope you feel much pride for publishing this book so early in your career!
Two DB2-related Blogs were chosen as "the best" on ITtoolbox.
+ An Expert's Guide to DB2 Technology (Best New Blog)
+ Getting the Most out of DB2 for z/OS (Best Technical Blog)
View the full list of winners and discuss the final results here: http://www.ittoolbox.com/r/da.asp?r=173711.
IBM Launched a whole series of Express editions of products to fit the needs of small to medium-sized businesses. Attend the webcast on Oct 12 to learn more:
Webcast: IBM Express Portfolio Announcements - Oct. 12
Designed, built and priced specifically to address the on demand business needs of mid-sized companies, the IBM Express Portfoliofeatures: relevant, scalable technologies that work with existing IT infrastructure; selected configurations that are easier to acquire, install and manage than traditional offerings; competitive pricing and enhanced availability; 100 solutions for mid-sized businesses, ranging from hardware and software to services, and; low-rate financing and simple, affordable leasing options. Register today for this live Web broadcast.
We also specially created the following book to support the express edition:
DB2 Express : Easy Development and Administration by Paul Yip, Kit Man Cheung, Jason Gartner, Clara Liu, Stephen O'Connell
Buy it directly from IBM Press to get a 30% discount:
What is in the book?
IBM DB2 UDB Express Edition Version 8.2 delivers everything small to medium-sized businesses need to accelerate time-to-value and dramatically reduce TCO in their database applications. Now, IBM's own experts show exactly how to get started with DB2 Express, and use it to develop, deploy, and manage superior applications from start to finish.
Like DB2 Express itself, this book cuts out the complexity--helping you achieve the full business benefits of today's most advanced database platform simply and quickly. You'll find step-by-step guidance and expert tips for every facet of DB2 Express development and administration, including: application design; development with both Visual Basic .NET and Java; security; deployment; performance tuning; day-to-day administration; and more.
IBM's own DB2 specialists demonstrate how to use DB2 Express' graphical tools to manage DB2 more easily than any other full-function relational database. Along the way, they help you make the most of DB2 Express' powerful "autonomic" features for self-administration, self-tuning, and self-healing to drive down costs throughout the entire application lifecycle.
This book will help you:
* Understand DB2 Express architecture and its implications for development and administration
* Install DB2 Express, create databases, and master essential DB2 Express tools
* Work with database objects: schemas, data types, tables, relationships, views, and indexes
* Develop VB.NET applications with ADO.NET and the DB2 .NET Data Provider
* Develop Java applications with JDBC and SQLJ
* Leverage DB2's concurrency model to design efficient transactions and improve user experience
* Introduce database functions, stored procedures, and triggers to improve application design
* Generate and manipulate data efficiently: LOAD, IMPORT, exporting to Microsoft Excel, reporting, and more
* Tune performance: optimize your configuration, analyze SQL with Visual Explain, and optimize SQL with Design Advisor
* Secure your applications: authentication, authorization, group privileges, and more
* Deploy to production, and master silent DB2 installations
* Define a solid database maintenance plan that fully leverages DB2 Express autonomic features
* Troubleshoot DB2 Express and avoid common pitfalls
Whether you're a developer, administrator, IT manager, or end-user, this definitive single-source guide will help you achieve results fast... and maximize DB2 Express' business value, every step of the way.
About the Authors
Paul Yip is a database consultant at IBM Canada. As a member of IBM's Channel and Partner Enablement Team, he works closely with partners, ISVs, and integrators to develop and tune third-party products for DB2. He coauthored DB2 SQL Procedure Language for Linux, UNIX and Windows (Prentice Hall, 2003) with Clara Liu.
Kit Man Cheung, member of IBM's DB2 Tools Development Team, has deep technical insight into DB2 Version 8.2's new GUI tools.
Jason Gartner, member of IBM's DB2 Tools Development Team, has deep technical insight into DB2 Version 8.2's new GUI tools. He is Development Manager for DB2 administration tools.
Clara Liu is a database consultant at IBM Canada. As a member of IBM's Channel and Partner Enablement Team, she works closely with partners, ISVs, and integrators to develop and tune third-party products for DB2. She coauthored DB2 SQL Procedure Language for Linux, UNIX and Windows (Prentice Hall, 2003) with Paul Yip.
Stephen O'Connell, member of IBM's DB2 User-Centered Design Team, has worked on the DB2 Web client and many other IBM-wide DB2 initiatives.
svisser1 2700018UK9 2,912 Views
Join us for The IMS Integration Suite: What, when, where, why, who and how questions answered teleconfence, Tuesday, April 10, 2007
You’ve been counting on IMS for years for the power of its transaction processing. Now that SOA has arrived, there’s no reason to stop. It’s possible to access your IMS application programs as Web services with direct access to IMS databases from service-based applications. With the right tools and techniques, you can easily integrate your existing assets with an SOA programming model.
In this teleconference, we’ll discuss the role of IMS in SOA implementations, and how IMS customers can leverage existing IMS applications and data in an SOA solution. You’ll learn about the IBM development tools and the IMS integration technologies that can be used to access IMS application programs and databases, as well as details on IMS V10 support for access to Web services.
You’ll come away with a good understanding of how to:
* Rapidly deploy Web services * Use the IMS database for XML documents * Simplify and reduce time or costs for application development * Integrate with Web services and SOA architecture
Speaker: Kenny Blackman – IBM Advanced Technical Support Group, IMS connectivity
In order to accommodate multiple time zones, the teleconference is offered at two separate times. Each will include a live Q&A session.
First Call: 9:30 am ET, 2:30 pm BST, 3:30 pm CET Second Call: 9:30 am PT, 12:30 pm ET, 5:30 pm BST, 6:30 pm CET Susan[Read More]
svisser1 2700018UK9 2,911 Views
This one is Exam 732 - DB2 for z/OS V9 Database Administration exam.
If you are already certified as an IBM Certified Database Administrator - DB2 8 for z/OS, all you need is to take and pass the new exam 732.
If you are new to certification, you must take Exam 732 plus the prerequisite: Exam 730 - DB2 9 Fundamentals.
Exam 732 has 73 questions and you are allowed a maximum of 90 minutes to complete the exam. You must score 57% or greater to pass the exam. The sections and weightings for this exam are:
* Design and Implementation 26%* Operation and Recovery 29%* Security and Auditing 11%* Performance 29%* Installation and Migration/Upgrade 5%
The IBM Certified Database Administrator - DB2 9 for z/OS certification is meant for the lead database administrator (DBA) for the DB2 9 product on the z/OS operating system. This individual has significant experience as a DBA and extensive knowledge of the DB2 9, specifically the new features and functionality related to Version 9. They are capable of performing the intermediate to advanced tasks related to database design and implementation, operation and recovery, security and auditing, performance, and installation and migration/upgrades specific to the z/OS operating system.
For more information about this exam and others that were released for DB2 9, see our Training and Certification web site.
Susan Lawson's book is getting close to being available as well... stay tuned... but I suspect it will be ready in time for the IOD conference in October. If you are planning to be at the conference, consider signing up for the pre-conference class to help you prepare to pass the exam, free of charge, while at the conference.
Apache Derby -- Off to the Races
Duffbert's Random Musings
"If you've ever been curious about using or integrating Apache Derby (or IBM Cloudscape) into your project, here's the book you'll need... Apache Derby - Off to the Races by Paul C. Zikopoulos, Dan Scott, and George Baklarz. Very well done... "-- Thomas Duff
Buy the book: http://www.amazon.com/gp/product/0131855255/102-8524566-1932154?n=283155
svisser1 2700018UK9 2,889 Views
In the mail today, I received an invitation to the next IDUG NA Conference that is taking place in San Jose in May. Given the recent announcement of DB2 9 for z/OS, and the close proximity to the lab that creates the product, I'm sure you'll have a chance to meet many of the developers who took part in the product's creation.
Also at the conference, Roger Sanders and Susan Lawson will be offering their pre-conference cert prep courses:
DB2 V8 for z/OS DBA Certification Crammer CourseSusan Lawson, YL&AFull-day
DB2 9 for LUW Database Administrator Certification Exam PreparationRoger E. Sanders, Network Appliance, Inc.Full-day During the conference you'll have a chance to test your skills by taking the V9 exams, free of charge. Come prepared to pass! Roger's next book will be published just in time for the conference, but Susan's will be in production, so only pre-orders will be possible.
The invitation I received today mentioned a special early bird registration rate when you register on or before March 23, 2007. Also, see the IDUG site to find out how you can win your registration fee!
I hope to see you at the conference.
svisser1 2700018UK9 2,886 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.
svisser1 2700018UK9 2,880 Views
Building an Intelligent Web: Theory and Practice will be available in October. The book is intended to be a textbook, so the price is higher than other books that I mention.
Here are the details:
The World Wide Web has become an extremely popular way of publishing and distributing electronic resources. Though the Web is rich with information, collecting and making sense of this data is difficult because it is rather unorganized. Building an Intelligent Web introduces students and professionals to the state-of-the art development of Web Intelligence techniques and teaches how to apply these techniques to develop the next generation of intelligent Web sites. Each chapter contains theoretical bases, which are also illustrated with the help of simple numeric examples, followed by practical implementation. Students will find Building an Intelligent Web to be an active and exciting introduction to advanced Web mining topics.
Topics covered include Web Intelligence, Information Retrieval, Semantic Web, Classification and Association Rules, SQL, Database Theory, Applications to e-commerce and Bioinformatics, Clustering, Modeling Web Topology, and much more!
Includes IBM DB2 Express-C, a data server used in the development and deployment of applications including: XML, C/C++, Java, .NET, PHP, and more.
If you are a professor or curriculum developer, request a sample copy from the publisher. We're very pleased that the authors and publisher of this book decided to include DB2 Express-C on the CD that is shipped with the book. Most publishers are reluctant to ship CDs with their books any longer, but it can be very important, especially for students.