Keep on Learning
svisser1 2700018UK9 3,738 Views
Put your comments in for all to read! Here's what a few others have done:
1) Author Roger Sanders created a discussion about the pre-conference education classes being offered at IOD at the end of the month.
2) The Search for an XML Superstar contest opened today.
3) I received feedback from someone who read an early copy of the upcoming Expert Preparation for Exam 734 - DB2 9 for Linux, UNIX, and Windows Advanced Database Administration Certification Study Guide and posted the feedback in the DB2 in Books group. 4) Multiple people blogged today. See PlanetDB2
4) 60 people have joined ChannelDB2 in the past week and are watching videos, listening to podcasts, and reading posts.
It's just noon in my time zone, so I'm hoping to see much more activity as the day goes on.
Earlier this week I blogged about the TDD Workshop that Justin Gordon is running tomorrow (July 25) in Chicago: link. I have a recommended book list to go with this session:
xUnit Test Patterns: Refactoring Test Code (The Addison-Wesley Signature Series) by Gerard Meszaros
Automated testing is a cornerstone of agile development. An effective testing strategy will deliver new functionality more aggressively, accelerate user feedback, and improve quality. However, for many developers, creating effective automated tests is a unique and unfamiliar challenge.
xUnit Test Patterns is the definitive guide to writing automated tests using xUnit, the most popular unit testing framework in use today. Agile coach and test automation expert Gerard Meszaros describes 68 proven patterns for making tests easier to write, understand, and maintain. He then shows you how to make them more robust and repeatable--and far more cost-effective.
Loaded with information, this book feels like three books in one. The first part is a detailed tutorial on test automation that covers everything from test strategy to in-depth test coding. The second part, a catalog of 18 frequently encountered "test smells," provides trouble-shooting guidelines to help you determine the root cause of problems and the most applicable patterns. The third part contains detailed descriptions of each pattern, including refactoring instructions illustrated by extensive code samples in multiple programming languages.
Topics covered include:# Writing better tests--and writing them faster# The four phases of automated tests: fixture setup, exercising the system under test, result verification, and fixture teardown# Improving test coverage by isolating software from its environment using Test Stubs and Mock Objects# Designing software for greater testability# Using test "smells" (including code smells, behavior smells, and project smells) to spot problems and know when and how to eliminate them# Refactoring tests for greater simplicity, robustness, and execution speed
This book will benefit developers, managers, and testers working with any agile or conventional development process, whether doing test-driven development or writing the tests last. While the patterns and smells are especially applicable to all members of the xUnit family, they also apply to next-generation behavior-driven development frameworks such as RSpec and JBehave and to other kinds of test automation tools, including recorded test tools and data-driven test tools such as Fit and FitNesse.
Working Effectively with Legacy Code (Robert C. Martin Series) by Michael Feathers
Get more out of your legacy systems: more performance, functionality, reliability, and manageability
Is your code easy to change? Can you get nearly instantaneous feedback when you do change it? Do you understand it? If the answer to any of these questions is no, you have legacy code, and it is draining time and money away from your development efforts.
In this book, Michael Feathers offers start-to-finish strategies for working more effectively with large, untested legacy code bases. This book draws on material Michael created for his renowned Object Mentor seminars: techniques Michael has used in mentoring to help hundreds of developers, technical managers, and testers bring their legacy systems under control.
The topics covered include:# Understanding the mechanics of software change: adding features, fixing bugs, improving design, optimizing performance# Getting legacy code into a test harness# Writing tests that protect you against introducing new problems# Techniques that can be used with any language or platform—with examples in Java, C++, C, and C## Accurately identifying where code changes need to be made# Coping with legacy systems that aren't object-oriented# Handling applications that don't seem to have any structure
This book also includes a catalog of twenty-four dependency-breaking techniques that help you work with program elements in isolation and make safer changes. Next Generation Java Testing: TestNG and Advanced Concepts by Cédric Beust and Hani Suleiman
Enterprise Java developers must achieve broader, deeper test coverage, going beyond unit testing to implement functional and integration testing with systematic acceptance. Next Generation Java™ Testing introduces breakthrough Java testing techniques and TestNG, a powerful open source Java testing platform.
Cédric Beust, TestNG's creator, and leading Java developer Hani Suleiman, present powerful, flexible testing patterns that will work with virtually any testing tool, framework, or language. They show how to leverage key Java platform improvements designed to facilitate effective testing, such as dependency injection and mock objects. They also thoroughly introduce TestNG, demonstrating how it overcomes the limitations of older frameworks and enables new techniques, making it far easier to test today's complex software systems.
Pragmatic and results-focused, Next Generation Java™ Testing will help Java developers build more robust code for today's mission-critical environments.
This book: # Illuminates the tradeoffs associated with testing, so you can make better decisions about what and how to test# Introduces TestNG, explains its goals and features, and shows how to apply them in real-world environments# Shows how to integrate TestNG with your existing code, development frameworks, and software libraries# Demonstrates how to test crucial code features, such as encapsulation, state sharing, scopes, and thread safety# Shows how to test application elements, including JavaEE APIs, databases, Web pages, and XML files# Presents advanced techniques: testing partial failures, factories, dependent testing, remote invocation, cluster-based test farms, and more# Walks through installing and using TestNG plug-ins for Eclipse, and IDEA# Contains extensive code examples
Whether you use TestNG, JUnit, or another testing framework, the testing design patterns presented in this book will show you how to improve your tests by giving you concrete advice on how to make your code and your design more testable.
Test Driven: TDD and Acceptance TDD for Java Developers by Lasse Koskela
In test driven development, you first write an executable test of what your application code must do. Only then do you write the code itself and, with the test spurring you on, you improve your design. In acceptance test driven development (ATDD), you use the same technique to implement product features, benefiting from iterative development, rapid feedback cycles, and better-defined requirements. TDD and its supporting tools and techniques lead to better software faster.
Test Driven brings under one cover practical TDD techniques distilled from several years of community experience. With examples in Java and the Java EE environment, it explores both the techniques and the mindset of TDD and ATDD. It uses carefully chosen examples to illustrate TDD tools and design patterns, not in the abstract but concretely in the context of the technologies you face at work. It is accessible to TDD beginners, and it offers effective and less well known techniques to older TDD hands.
What's Inside:# Learn hands-on to test drive Java code# How to avoid common TDD adoption pitfalls# Acceptance test driven development and the Fit framework# How to test Java EE components-Servlets, JSPs, and Spring Controllers# Tough issues like multithreaded programs and data access code
Refactoring Databases: Evolutionary Database Design by Scott Ambler and Pramodkumar J. Sadalage
Refactoring has proven its value in a wide range of development projects–helping software professionals improve system designs, maintainability, extensibility, and performance. Now, for the first time, leading agile methodologist Scott Ambler and renowned consultant Pramodkumar Sadalage introduce powerful refactoring techniques specifically designed for database systems.
Ambler and Sadalage demonstrate how small changes to table structures, data, stored procedures, and triggers can significantly enhance virtually any database design–without changing semantics. You’ll learn how to evolve database schemas in step with source code–and become far more effective in projects relying on iterative, agile methodologies.
This comprehensive guide and reference helps you overcome the practical obstacles to refactoring real-world databases by covering every fundamental concept underlying database refactoring. Using start-to-finish examples, the authors walk you through refactoring simple standalone database applications as well as sophisticated multi-application scenarios. You’ll master every task involved in refactoring database schemas, and discover best practices for deploying refactorings in even the most complex production environments.
The second half of this book systematically covers five major categories of database refactorings. You’ll learn how to use refactoring to enhance database structure, data quality, and referential integrity; and how to refactor both architectures and methods. This book provides an extensive set of examples built with Oracle and Java and easily adaptable for other languages, such as C#, C++, or VB.NET, and other databases, such as DB2, SQL Server, MySQL, and Sybase.
Using this book’s techniques and examples, you can reduce waste, rework, risk, and cost–and build database systems capable of evolving smoothly, far into the future.
As of this morning, ChannelDB2.com now has 471 members....much lower than I expected. But that can change, right?
Why should you join?
As Willie says:
Believe it or not, DB2 is now into "social networking" with the ChannelDB2 web site. ChannelDB2 is a DB2 community (all flavors of DB2 and all things DB2) featuring content such as DB2 related videos, podcasts, blogs, photos, resources, etc... for Linux, UNIX, Windows, System z, and System i. It's your one stop shopping for just about anything you might be looking for in DB2 land.
I agree with Willie and suggest that after you become a member of ChannelDB2, that you join one or more of the following groups:
DB2 in Books
I've listed every published book in this discussion group and I encourage you to use this as a way to reach the authors or to find related information such as events that the authors are taking part in, podcasts or webinars that are related to the book topic, and so on....
DB2 for Linux, UNIX, Windows
This is a place where you can find information about anything related to DB2 for LUW. Feel free to add discussions for areas that are not yet created. I've created a few discussions that you might find useful, including information about the latest ILO courses or current promotions that are being offered.
DB2 for z/OS
Same as the one above, only content is specific to the z platform.
I just started this group to be a collection of the many things that are happening at the IOD conference. With so much information being sent on a daily basis in regards to the conference, isn't it nice to have one spot that collects that information? And better yet, this is a place where you can share your thoughts on events that are taking place at the conference.
What do you think? Worth checking out? I hope so. When you're a member, make me a friend! A girl can never have too many friends!
875 exams taken after 4 days! Very steady business. We offer DB2, WebSphere, Lotus, Tivoli and Rational exams, but clearly this is a DB2 crowd! We offer all the exams to help people become cross trained in all SWG products.
I had dinner with Roger Sanders last night. I first met Roger years ago just after he published his first book about DB2. I'm glad that I was able to work with him on the three Exam Study guides that he wrote for our Version 8 exams and I'm working very hard to get more book projects for Roger.
Roger tells me that he gets lots of reader feedback about his sample questions and how useful readers find it that he explains the reason an answer is correct. I'm sure that now that IBM charges $10 per take on the assessment exams, more people will choose to use Roger's books for his assessment questions as well as the content of the book.
One of the projects I got involved with in January was to set up a program for Russia to get more people trained and certified. I suggested that we translate Roger's Exam 700 Study Guide along with a few other materials. I am happy to say that Roger's book is now available in Russia and that Roger has been invited to run a crammer course to a select group. It is great how quickly we were able to make this initiative a reality! If we are successful in getting people certified at the entry level, we'll continue the program and focus on Exams 701 and 703.
I was also privileged to meet several people from Brazil this week. We talked at great lengths about the various ways we can increase certifications there as well. I fully believe that you can't just throw a test at someone and hope that they pass. You need to build a program around the test, similar to what we are doing in Russia: a book that people can read and keep to refer to over time, hands on experience, and if possible, training sessions. And then the exams. I am very hopeful that we will be able pull something together for Brazil and other countries as well.
I'm writing this entry on Friday morning at 9:00 am and we have a room filled with people who are currently taking an exam and another room full of people waiting to take their exams before heading home. It has been a very successful week and I look forward to working at next year's conference planned for Dallas in August 2006.
First, let's look at the intended audience for the test as well its structure.
The target audience is a database developer who has an in-depth knowledge of:
* all common programming tasks
* embedded SQL programming, ODBC/CLI programming, or Java programming
There are 63 multiple choice questions on the test and you are required to get a score of 57% or better to pass. The following 7 sections are on the test:
* Database objects and Programming Methods (13%)
* Data Manipulation (26%)
* Embedded SQL Programming (11%)
* ODBC/CLI Programming (13%)
* Java Programming (13%)
* Advanced Programming (16%)
* User Defined Routines (8%)
Section 1: Database objects and Programming Methods (13%)
This section tests:
* Your ability to identify the different database objects that are available with DB2 UDB.
* Your ability to identify the naming conventions used for DB2 UDB objects.
* Your knowledge of the constraints available and your ability to identify when and how NOT NULL, default, check, unique, and referential integrity constraints should be used.
* Your ability to identify how operations performed on the parent table of a referential integrity constraint are reflected in the child table of the constraint.
* Your ability to identify the more common privileges used when developing or running DB2 UDB applications.
* Your knowledge of the various special registers available and your ability to obtain the current value of any special register using SQL.
* Your ability to identify the similarities and differences between static embedded SQL and dynamic embedded SQL.
* Your ability to identify the difference between CLI/ODBC, JDBC, and SQLJ.
Today's assessment question:
Given a table created using the statement:
CREATE TABLE abc.stuff (i INT)
A user called XYZ is to be enabled to access data from table ABC.STUFF using an implicit schema.
Assuming the necessary privileges have been granted, which of the following statements issued by user ABC will provide this result?
A. CREATE ALIAS stuff FOR abc.stuff
B. CREATE VIEW abc.stuff FOR xyz.stuff
C. CREATE ALIAS abc.stuff FOR xyz.stuff
D. CREATE VIEW xyz.stuff AS SELECT i FROM abc.stuff
Where to find the answer:
1) Chapter 2 of Roger Sanders book: DB2(R) Universal Database V8.1 Certification Exam 703 Study Guide
2) Tutorial: http://www.ibm.com/software/data/education/selfstudy.html#2.
3) Product document: search on 'alias'
Tip: If you are an employee of IBM, search for Roger's book on Books 24x7.
Susan Visser[Read More]
Yesterday I took part in an event that our skill resouces team ran to give information about certification testing to our 2500 employees of the Toronto Lab. I thought I'd share with you a few of the tips that I provided to these attendees.
Select desired certification by visiting http://www.ibm.com/software/data/education/cert/
This site was recently re-launched and is the best place to start to find out everything you will want to know about getting prepared to take a DB2 certification exam.
* Certification Roadmaps
* Complimentary Certification Tutorials
* Exam Preparation Documents
* On-line Assessment Exams
* Certification Guides
* Certification Process Checklist
Recommended Study Materials for DB2 Certification Exams
Exams 700, 701, and 703 each have a study guides written specifically for the exam. See http://www.ibm.com/software/data/education/bookstore/certify.html for a list of the books that are available to prepare for exams within each job role.
DB2 UDB V8.1 Certification Test 700 Study Guide by Roger Sanders
DB2 UDB V8.1 Certification Test 701 and 706 Study Guide by Roger Sanders
DB2 UDB V8.1 Certification Test 703 Study Guide by Roger Sanders
The series of study guides by Roger Sanders is recommended for those who need a quick refresh of the exam material. He includes sample questions and has focused the books on just what you need to pass the exams.
DB2 UDB v8.1 for Linux, UNIX, and Windows Database Administration Certification Guide, 5/e by George Baklarz, Bill Wong
DB2 UDB v8.1 Application Development Certification Guide, 2/e by Steve Sanyal, Kevin Gashyna, David Martineau, Mike Kyprianou
Advanced DBA Certification Guide and Reference for DB2 Universal Database v8.1 for Linux, UNIX, and Windows, 1/e by Dwaine Snow, Tom Phan
The series of Certification Guides is recommended for those who need to prepare for the exam, but also wish to have information beyond the exam for learning or reference purposes.
svisser1 2700018UK9 3,683 Views
The Information On Demand 2008 Conference is the premier IBM information management event... meaning that you will have opportunities for extensive learning opportunities via the 780 Sessions: 120 Business Leadership, 600 Technical Skill Building, and 60 Cognos Sessions.
Did you also know that there is a further learning opportunity via the pre-conference classes? These full day education classes will be offered on Sunday only, October 26th, 2008 from 8:30 am to 4:30pm at the Mandalay Bay Convention Center.
Take advantage of preferred attendee pricing of US $399.00 and get a full day of education, delivered by professional IBM instructors.
Available education is listed below, on-line registration will open to conference attendees soon! Seats will be limited.
IBM Cognos 8 BI: Essentials for Managing BI Projects (version 8.3) Accelerated
Speaker: Norm Goddard
IBM Cognos 8 BI: Essentials for Managing BI Projects (version 8.3) is a one-day, instructor-led course that provides participants with essential knowledge to ensure the success of their Cognos 8 BI implementation. Participants will be introduced to the Cognos Solutions Implementation Methodology (Cognos SIM), the elements of IBM Cognos 8 BI, and the underlying architecture. They will examine the process of creating an IBM Cognos 8 BI solution, and discuss how IBM Cognos 8 BI relates to the other parts of IBM Cognos 8. Participants will be shown a range of resources to help them successfully manage their implementations.
DB2 Migration, How To Move Forward and Never Fall Back
Speaker: Albert Grankin
Production system migration, whether hardware or software is a task that requires very detailed and careful preparation. This session will go over aspects of database migration that are usually not covered in our migration guides. We’ll cover topics including how to prepare your production system for migration and what additional information to collect before starting. It will also cover important steps after migration including comparative performance monitoring, identifying and resolving issues.
DB2 V9/V9.5 for Linux, UNIX and Windows Problem Determination
Speakers: Aman Lalla, Pavel Sustr
Learn how to identify and resolve problems such as database hangs, locking problems, crashes and optimizer/performance problems. DB2 V9 also provides various problem determination facilities and tools such as db2fodc (First Occurrence Data capture). Knowing how and when to use these tools is critical in resolving problems quickly.
DB2 Operational Performance, Success Without Stress
Speaker: Rajib Sarkar
This session will demonstrate effective ways to monitor a DB2 database system for performance and provide tips & tricks in analyzing & monitoring data. The session will also focus on diagnostic tools and techniques used by IBM support personnel and how some of them could be used by DB2 Database Administrators, IT Specialists and Developers for identifying and solving operational performance issues.
Speakers: Hyun-Ju Vega, Suma Vinod, Mark Jamison, Ron Privett
Learn more about troubleshooting from the experts – the IBM Informix advanced support team. Attendees will learn Informix diagnostic methods and tools, how to troubleshoot and diagnose performance problems, connectivity and network issues, memory problems, ER/HDR problems, and Windows specific issues.
Leveraging DB2 Optimizer
Speaker: Yasir Warraich & Samir Kapoor
Learn everything there is to know about the optimizer architecture. We start with discussion about basic concepts such as optimization levels and timer ons. Advanced topics such as data access methods, join methods, analyzing the optimizer access plans will be covered and additionally we'll describe different operators and help identify problematic areas to look into in an access plan. We'll also show how to take counts at different branches in an access plan. Having understood how to analyze an access plan, we'll also demonstrate usage of STATVIEWS, CGS ger,and OPTIMIZATION GUIDELINES to improve query performance.
DB2 for z/OS DBA Certification Crammer (Exam 732)
Speaker: Susan Lawson
This high level certification preparation review is intended to help you take IBM Certification Test 732, DB2 9 DBA for z/OS. Gain an intense overall review of those areas that are on the certification exam.
DB2 9 for Linux & Windows DBA Certification Crammer (Exam 731)
Speaker: Roger Sanders
This training is designed to introduce the student to the concepts a test candidate must know in order to take and pass the DB2 9 DBA for Linux, UNIX, and Window certification exam (Exam 731). The material for this course is aligned with the 731 exam objectives.
Insuring Data Privacy in Your Test Environment using Optim
Speaker: Tom Bauch
Data in your testing environment is often not as tightly controlled or audited as your production data. This 1-day class provides an overview of how to mask your test data to eliminate the risk of data loss and comply with privacy standards using Optim. The class will also review how to simplify the creation and management of your test data, easily creating a subset of your test data to minimize disk requirements, and simplify your ability to create and manage test data environments.
And... if you need help justifying your attendance at the conference, use this conference justification information.
Make sure you bookmark the ChannelDB2 website to see the very latest videos that are uploaded. Rav Ahuja filmed me when we were in Las Vegas for the IOD conference last year where I spoke about the latest releases of books related to IM products. Here is the link: My Video.
Personally I'm not happy with how it turned out... but my co-workers tell me that it's fine. (Do we ever like seeing ourselves on video?)
I asked Rav to make an update as there have been several new books published since that recording was made. He suggested that I simply turn the camera on myself, film a new segment and upload it. I think I'll do that! And I encourage anyone else who feels that they have something to share to do the same.
I also noticed that there is a place to put photos as well. I have a few photos from several conferences that I'd also like to share, so I'll add them there too.
Also see my blog on PlanetDB2.com.[Read More]
CASCON, The Centre for Advanced Studies Conference, is taking place this week in Toronto. CASCON is the premiere computer science and software engineering conference in Canada. This conference is an excellent venue for exchanging ideas, showcasing results, experiences and tools, and networking with researchers and practitioners from academia, industry, and government.
Here is a link to give more information: https://www.ibm.com/ibm/cas/cascon/
Yesterday I had lunch with Stephen Perelgut who ran a workshop on popular technologies such as blogging, podcasting, and RSS feeds. Stephen is running two sessions this week, and both are full to capacity. I was too late to sign up for either of his workshops, so I'm not able to attend. Stephen tells me that he may run another session in the Toronto Lab for employees in a few months.
After lunch I met with Dr. Imran A. Zualkernan who is working on a technology to turn flow diagrams into test questions. Dr. Zualkerman showed me this technology in action using a flow diagram for a few DB2 UDB task. Seems interesting, but I don't think it's ready for prime time use yet. I'll provide some user scenarios to Dr. Zaulkerman so he can further test this technology. Using this technology might be helpful when creating sample study questions. We'll see.
I spent the afternoon in a Women in Technology Workshop: Tenth Workshop on Women in Technology: Global Transformation for Women & ICT.
This workshop discussed the ongoing action needed to transform the global position of women in Information and Communication Technology (ICT). The speakers/facilitators included: Claudia Morrell, Kelly Lyons, Sophia Huyer, and Ann Holmes.
It is conceived as a follow-on to the First International Symposium on Women and ICT that took place June 12-14, 2005 in Baltimore, Maryland, USA. Two hundred and fifty participants, representing six continents and 29 developing and developed countries, including leaders from business, government, non-government agencies, and education, gathered to explore concrete ways to increase girls' and women's participation and leadership with Information and Communication Technology in order to effect economic, social, and political change.
The focus of the CASCON session was to discuss the messages that should be presented at the second United Nations World Summit on the Information Society, Tunis 16-18 November 2005. The goal is to change the gender disparity evidenced in Women and Information Technology: Fast Facts at http://www.umbc.edu/cwit/fastfacts.html and planning for continuing action.
Some interesting facts:
* Computer-related occupations, 2004, U.S.
* Computer and information systems managers, 31.0% female
* Computer scientists and systems analysts, 29.4% female
* Computer programmers, 26.7% female
* Computer software engineers, 25.0% female
* Computer support specialists, 29.7% female
* Database administrators, 33.6% female
* Network and computer systems administrators, 20.3% female
* Network systems and data communications analysts, 21.9% female
* Operations research analysts, 43.0% female
Source: U.S. Bureau of Labor Statistics, 2005
The database area has had very highly ranked women running the business until recently: Janet Perna and Pat Selinger. Both of whom have recently retired.
I can't say that I've overly passionate about this subject yet, but it does bother me to hear that fewer and fewer women are going to university and even fewer are choosing technical degrees. There are lots of studies that try to figure out the reason for the decline as well as many programs in place to help. One of the things that we discussed yesterday was the need to figure out what programs exist around the world and to share these ideas so we can make programs accessible to people every where in the world. A portal is being designed, so hopefully that will help.
Kind of in line with this topic, last night I volunteered to help out at a Girl Guides event in support of a technology badge. This is one of the many programs that IBM takes part in to encourage girls to take an interest in technology.
svisser1 2700018UK9 3,654 Views
Now is the PERFECT time to validate your skills and demonstrate your IBM DB2 9 proficiency with Information Management Professional Certification. Ensure your success on exam day by taking advantage of our preparation resources.
IBM DB2 9 Database Administration for Z/OS Exam (732)
Length: 73 questionsPassing score: 57%Duration: 90 minutes
Job Role Description:The IBM Certified Database Administrator is 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.
To attain the IBM Certified Database Administrator - DB2 9 for z/OS certification, candidates must pass two exams (730 and 732) or be certified as an IBM Certified Database Associate - DB2 Universal Database V8.1 (exam 700) and pass exam 732.
* section 1 Design and Implementation 26% * section 2 Operation and Recovery 29% * section 3 Security and Auditing 11% * section 4 Performance 29% * section 5 Installation and Migration/Upgrade 5%
Study Materials:Self Study Preparation TutorialsOn-line Professional Certification Assessment ExamsTake an IBM Exam at Thompson PrometricTake an IBM Exam at Pearson VUE
For additional information, see the Information Management Certification website.
Coming soon:1) New DB2 for z/OS Certification Study Guide by Susan Lawson and Daniel Luksetich.. to be published in June or July by MC Press. Pre-order information will be blogged about when the information is available.
2) IDUG pre-conference Crammer Course featuring Susan Lawson.
This is the month when many certification exams are launching. Stay tuned for more details!
Now there is no better time to build your technical reference library of IBM Press books. Until December 31, 2007 you can save 35% off your order when you make a purchase at the IBM Press Bookstore. PLUS you can receive FREE ground shipping in the U.S. To take advantage of this special offer, simply visit the IBM Press Bookstore, select your books and enter case-sensitive coupon code SAVEDB2 at Step 3 during checkout.
Here are some titles that published this year that you may want to consider:
Understanding DB2 9 Securityby Rebecca Bond, Kevin Yeung-Kuen See, Carmen Ka Man Wong, Yuk-Kuen Henry ChanUnderstanding DB2 9 Security is the only comprehensive guide to securing DB2 and leveraging the powerful new security features of DB2 9. Direct from a DB2 Security deployment expert and the IBM DB2 development team, this book gives DBAs and their managers a wealth of security information that is available nowhere else. It presents real-world implementation scenarios, step-by-step examples, and expert guidance on both the technical and human sides of DB2 security.
Mining the Talk: Unlocking the Business Value in Unstructured Informationby Scott Spangler, Jeffrey Kreulen Written by IBM researchers, and describes, techniques used in research assets used internally at IBM and by IBM consultants on customer service engagements. IBM Alphaworks provides a free demonstration copy of one of the early text-mining tools called IBM Unstructured Information Modeler as an adjunct to this book.
DB2 9 for Linux, UNIX, and Windows DBA Guide, Reference, and Exam Prepby George Baklarz and Paul ZikopoulosEverything a DBA needs to know about DB2 9... from installation to XML to security.
Apache Con starts this Sunday in San Diego: http://apachecon.com
George Baklarz, one of the authors of "Apache Derby-Off to the Races", will be at the conference giving a free copy of the book to each attendee!
If you are not attending the conference, we've set up an electronic coupon that gives you a 35% discount and free shipping in the US. See http://www.ibm.com/software/data/education/bookstore/ for details.
I've made this book the Recommended Book for December" as well.
"Apache Derby-Off to the Races," includes details of IBM Cloudscape. Derby benefits include running on both Linux and Windows and supporting JDBC, SQLJ, PHP, Python and Perl--open source at its finest. The book illustrates all the basics of the database and provides an extensive overview of all the APIs supported by IBM Cloudscape. Sample applications are worked throughout the book, and the reader may apply skills learned immediately.
On Friday I dropped into a bank to deposit a royalty cheque. The bank teller was quite interested to hear that I am an author and that I help others publish books. Even though I told her that I have a very narrow field: technical books about DB2, she still wanted my card and has followed up with a few questions about how to get started.
She's from Croatia and would like to write a travel book for those traveling there. I have no idea as to where to start for this type of book, but I gave her the same advice that I would give to anyone writing any book. Here is what I would say for someone wanting to write a technical book:
1) Search on amazon to see what books are available. Read the TOC or Index if you can and see if it would be different than the book you have in mind. For technical books, also check to see if there a redbook that covers the topic.
2) Read the comments from the readers to see what people like or dislike about the various books. Use this information to help you decide on what you want to focus on.
3) Look into buying a book about writing a book. I found several on amazon for writing travel books, but here's what I'd suggest for technical books:
Developing Quality Technical Information: A Handbook for Writers and Editors (2nd Edition)
4) Consider checking out blogs on the topic you are interested in. Do the blogs exist? Are you considered an expert or knowledgeable in the area? Would you start your own blog? Apparently some people are putting their draft chapters in blogs to be reviewed and critiqued before the material is finalized and published.
5) Consider writing an article to be published in a magazine or online. Quite often you will be paid for the content. This will help you make a name for yourself in the topic area.
6) Answer the following questions, as these are likely the questions a publisher will ask you to determine if they want to take the risk on your book:
1. Working Title:
2. Brief Description: In one or two paragraphs, describe the work, its purpose, rationale, and approach.
3. Outstanding Features: Briefly list what you consider to be the three (or more) outstanding, distinctive or unique features of the work and why.
a. Identify the intended target audience.
b. At what level is the book targeted (beginner, intermediate, advanced)?
c. Is it primarily descriptive or qualitative, elementary or rigorous, etc.?
d. Estimate the size of the target audience and ways to verify the estimate.
e. Identify some of the obstacles faced by this target audience when it comes to mastering the proposed topic.
5. Status of the Book:
a. What portion of the material is now complete?
b. When do you expect to have a complete manuscript?
c. If chapters are not available now for review, when will they be ready to submit?
d. How many and what type of figures (e.g. drawings, half-tones, charts, photos, etc.) do you plan?
e. If producing the material electronically, what hardware, operating system, software, macros, etc. will you be using?
6. Competition: Consider the existing books in this field and discuss their strengths and weaknesses individually and specifically. This material is written for reviewers and not for publication, so please be as frank as possible.
a. Identify competing titles currently available, noting the author, title, publisher, price, page count, and year. Compare each to your proposed work, noting the similarities as well as the differences.
b. Indicate why the work you propose to deliver is unique. Compare and contrast your credentials to the credentials of the authors of the other books.
c. If there are no books on this subject, explain why you believe there still is market interest.
Also visit http://www.ibm.com/ibmpress for a proposal template that you can download as well as answers to frequently asked questions.
Don't get scared off by the number of steps listed above! Writing a book is very possible and the thing you need most is passion for the topic!
The International DB2 Users Group (IDUG®) is pleased to promote the SoftBase DB2 UDB for z/OS Version 8: FOR DEVELOPERS ONLY Webinar featuring Craig S. Mullins, a DB2 educational event being held this Wednesday, May 3, 2006 at 2:00 PM - 3:30 PM EST.
This technical session will highlight DB2 UDB for z/OS Version 8 enhancements that directly impact DB2 application developers when performing their jobs. The target audience is Application Developers, Project Leaders, Application Managers or any IT staff members who will be involved in developing, testing and deploying DB2 for z/OS Version 8 applications.
To register for this Webinar, please visit http://www.softbase.com/db2developersonly/index.php?ncid=4606
Highlights of this Webinar include:* Overview of all key SQL enhancements within DB2 UDB for z/OS Version 8 such as SELECT from INSERT, MULTI-ROW FETCH & INSERT, SEQUENCE and IDENTITY columns and MULTIPLE DISTINCT* Review of all new DB2 for z/OS Version 8 SQL Error Codes* Examples of program code to handle new DB2 Version 8 GET DIAGNOSTICS and SQL Error Codes* Explanation of new Star Join enhancements in DB2 for z/OS Version 8* Explanation of new Recursive SQL* Review of new Materialized Query Tables in DB2 Version 8 that dramatically improve DB2 Data Warehousing Application performance* SoftBase will be raffling off 10 free copies of the DB2 Developer's Guide by Craig S. Mullins to registered participants at the end of the webinar* All webinar attendees will receive complimentary SoftBase DB2 for z/OS Version 8 Highlights and SQL Error Code reference cards* And much, much more![Read More]
The list of books that readers of the db2mag.com voted on are similar to the list that I put together a month ago on my blog.
DB2 Magazine Email Newsletter
Volume 6, Issue 12
"If gifts of knowledge are on your holiday list, take another look at these five titles that clicked with this newsletter's readers.
--SQL in a Nutshell, 2nd Edition
--Understanding DB2: Learning Visually with Examples
--Self-Service Linux: Determining Problems and Finding Solutions
--Rexx Programmer's Reference
--Apache Derby--Off to the Races
Congratulations to the authors of these books for publishing one of the best books of the year! Thanks also to the staff at db2mag.com for their continued interest in the books that we publish.
Today's assessment question is also from Section 1: Database objects and Programming Methods (13%). Specifically, it tests this objective:
* Your ability to identify the different database objects that are available with DB2 UDB.
Given the following CREATE TABLE statement:
CREATE TABLE tab1
(empid INTEGER GENERATED ALWAYS AS IDENTITY,
Which of the operations will cause an error to be generated?
A. INSERT INTO tab1 VALUES (DEFAULT, 'Jagger', 'E01')
B. INSERT INTO tab1 VALUES (1, 'Jagger', 'E01')
C. INSERT INTO tab1 (name) VALUES ('Jagger')
D. INSERT INTO tab1 (name) VALUES (NULL)
Where to find the answer:
1) Chapter 2 of Roger Sanders book: DB2(R) Universal Database V8.1 Certification Exam 703 Study Guide
2) Tutorial: http://www.ibm.com/software/data/education/selfstudy.html#2.
3) Product document: search on 'identity columns'
svisser1 2700018UK9 3,545 Views
One of the books that we featured at IOD was The Execution Premium by authors Robert Kaplan and David Norton.
The publisher sent me information about a webinar related to this book that you might be interested in:
The Execution Premium: Making Strategy Your Competitive Advantage NowA conversation with David Norton, author of The Balanced Scorecard and The Execution PremiumWednesday, December 10, noon – 1:30 U.S./Canadian EST
To learn more, click here.[Read More]
svisser1 2700018UK9 3,543 Views
Episode # 8
Topic: DB2 Workload Manager
Friday Dec 11
To register for this episode click here.
svisser1 2700018UK9 3,538 Views
Today I'd like to tell you about a book that is coming out in September that I think you'll like. The book is:
Self-Service Linux: Mastering the Art of Problem Determination
by Mark Wilding, Dan Behman
Save 34% on amazon.com today! Book will be shipped to you on Sept 21, 2005.
Why this book? Well first of all, I worked for months (possibly as much as 2 years) with Mark and Dan to get this book published. Originally it was to be a title under IBM Press, but at the last minute it was moved to the Bruce Perens' Open Source Series.
As part of my job, I needed to get the manuscript reviewed by as many people as possible. Here are a few of the comments I received:
'This welcome addition to the Linux bookshelf provides real insight into the black-art of debugging. Its stance is based on the scenario of the live environment, which often requires of the problem solver a great deal of ingenuity. The introductory material provides real insight into process of debugging and will provide valuable guidance to anyone wishing to engage in this process. All too often debugging books concentrate solely on the tools but this book avoids that pitfall by concentrating on examples. The authors dissect and discuss each example in detail; in so doing they give invaluable insight into the Linux environment from a debugging perspective and the use of the debugging tools.'
Richard J Moore
IBM Advanced Linux Response Team - Linux Technology Centre
'Good stuff. I particularly like the tongue-in-cheek flavor of the writing. '
IBM Linux Technology Center
'It was quite comprehensive and very readable. I learnt a few things, too!'
IBM Linux Technology Centre
So, what's in the book? Here are some details from the back cover of the book:
* The indispensable troubleshooting resource for every Linux administrator, developer, support professional, and power user!
* Systematically resolve errors, crashes, hangs, performance slowdowns, unexpected behavior, and unexpected outputs
* Master essential Linux troubleshooting tools, including strace, gdb, kdb, SysRq, /proc, and more
* Includes production-ready data collection script that can save you hours in debugging remote mission-critical systems
The indispensable start-to-finish troubleshooting guide for every Linux professional
Now, there's a systematic, practical guide to Linux troubleshooting for every power user, administrator, and developer. In Self-Service Linux, two of IBM's leading Linux experts introduce a four-step methodology for identifying and resolving every type of Linux-related system or application problem: errors, crashes, hangs, performance slowdowns, unexpected behavior, and unexpected outputs. You'll learn exactly how to use Linux's key troubleshooting tools to solve problems on your ownnd how to make more effective use of professional support services and the Linux community's knowledge.
If you use Linux professionally, this book can dramatically increase your efficiency, productivity, and marketability. If you're involved with deploying or managing Linux in the enterprise, it can help you significantly reduce operations costs, enhance availability, and improve ROI.
Another reason why I want you to know about this book is that DB2 on Linux continues to make news for its performance benchmarks. Here is a link to an article that published earlier this month:
With such great performance and now books to help get over any Linux hurdles, it seems to me that we'll be seeing much more of these two products in the future!