Keep on Learning
svisser1 2700018UK9 3,834 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.
A fellow blogger (Bill Higgins) pointed to an interesting article by Joan Houlihan that gives tips on how to become an author. I thought I'd point to this article in my blog as well.
My job is similar to Mary O'Brien role, but I focus on Information Management titles.
One of the things that Joan mentions in her articles is "Despite the prevalence of online communications, book sales have steadily increased over the past decade
I'm not sure that I've seen the same trend, but I hope to see an increase in book sales! I'm planning to change a few things in the DB2 library for the next release to help achieve this. I can't reveal my strategy at this time, but maybe in the near future.
svisser1 2700018UK9 3,821 Views
DB2Night Show: Nov 19: What's NEW and COOL with DB2 LUW, and a peek into the crystal ball!
Nov 19, 2010
11:00 - 12:00 EST
Register: click here.
If you have ever attended a DB2 related conference, you have probably attended a presentation given by George Baklarz. George keeps us all tuned in to DB2 LUW's newest and coolest features, and frequently shares his crystal ball thoughts on "what's coming" as well.
In this episode of The DB2Night Show, George has agreed to join us as special guest. By the end of 2010, he will have flown about two billion miles around the globe. We're not sure how he has found the time to join us, but we are awfully darned appreciative.
Participate as a studio audience member as one studio audience member will be randomly selected to win an electronic gift certificate. If you can't make the scheduled time, register anyways so that you get information about recorded replays. Lastly, please forward this invitation to at least 5 of your friends! Thank you!
On top of being a very successful presenter, George is also a very successful author of 10 books about DB2. I’m very proud to say that I’ve been alongside George for every single book and am glad that his is such a prolific author. Let’s hope that I can continue to convince him to write books despite his insane travel schedule!
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]
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.
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.
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.
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]
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!
svisser1 2700018UK9 3,728 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!
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.
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.
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]
svisser1 2700018UK9 3,676 Views
Leon's blog post just made me aware of this Consumability Survey for Information Management products.
The Consumability Survey was designed to gain insight into your business priorities and experiences with IBM software. It will take approximately 30 minutes to complete and must be completed in one session. The survey allows you to provide your input based on your experience and priorities for 31 product characteristics. You are then given the opportunity to prioritize those areas that matter most according to the demands of your business. When answering the survey, please be as specific as possible so that we can take appropriate actions to improve the product. At the survey Web site, please enter the optional invitation code: IMSOFTWARE.
You may wonder, what is consumability? The term is used to describe the difference between a product that works and one that makes your work easier, such as:
* How easily you were able to find the product that matched your business needs* How quickly you installed and configured the product to your environment* How well the product fulfilled its function within your organization* How efficiently the product suited your organization's usage on a daily basis* How easily you were able to derive business value from the product on a long-term basis
By taking the participating in our Consumability Survey, you're helping IBM focus on improving our software in ways that make the difference to your success.
See instructions in Leon's blog post if you want to provide feedback for DB2 Express-C.
Your opinion is very important to us, so thanks in advance for taking the survey.
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,617 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,615 Views
Episode # 8
Topic: DB2 Workload Manager
Friday Dec 11
To register for this episode click here.
svisser1 2700018UK9 3,615 Views