My.ADVISOR.com Sign-In
ID
Password

Member Center / Sign-Up
   
SUBSCRIPTION STATUS
If you are a subscriber to this publication, sign-in to access locked articles. To subscribe or renew go to www.AdvisorStore.com.
Go to Article

BOOK EXCERPT

What's New in IBM Lotus Notes/Domino 8 Development: DB2 Integration and View Enhancements

In this book excerpt, learn about more new features in Lotus Notes/Domino 8, including DB2 integration and view enhancements.

By Tim Speed, Dick McCarrick, Barry Rosen, Bennie Gibson, Brad Schauf, David Byrd, and Joseph Anderson


The ability to use DB/2 as an alternate back-end storage system for Domino was available in Domino 7 as a Feature Trial and also via a Limited Availability program. With the release of Notes/Domino 8, the integration with DB 2 will be generally available on certain Windows, IBM AIX, and Linux operating systems.


Figure 14


Figure 15


Figure 16


Figure 17

Using this integration, you can make data within your Domino databases available for use by relational database tools and show external relational data within Notes/ Domino views and embedded views.


View Enhancements

Domino Designer 8 view enhancements include new column number formats, extended to use available window width, defer index creation until first use, and show default items in right-mouse menu.

New Column Number Format

There is a new number format for number columns that will display the column contents in kilobytes, megabytes, or gigabytes, which makes it much easier to determine the relative size of the number represented in the column. In this example, the size of file attachments is used.

When displayed in Notes 7, the column shows just the attachments lengths for each document (figure 14).

However, when the same column is displayed in Notes 8 with the Bytes (K/M/G) number format, the column displays a much friendlier format (figure 15).

Extend to Use Available Window Width

In Notes 8, you can select which column within a view will expand to utilize the available width of the window (figure 16). In previous releases, this option was only available for the last column in a view.

For this option to work, the view level option Extend last column to window width takes precedence and must be deselected. In addition, the column to be extended must be marked as Resizable. Multiple columns can be designated to extend to use the available window width. However, only the first column, which has this attribute set, will expand.

Defer Index Creation until First Use

Index creation can now be deferred for Click on column header to sort view columns (figure 17). Using this option, the view index won't be created until a user first clicks on the column to sort it. Only views that users click to sort will have their indexes built. This can help reduce the load on servers, as not all column indexes will be created automatically. They will only be created when they are used.

Note that the deferred index creation feature requires the database to be using the new ODS (On-Disk Structure) for Notes/Domino 8. By default, Notes/Domino 8 still creates databases with ODS 43, which was introduced in release 6 and used through releases 7 and 8. To enable the creation of databases in ODS 48 format, use the Create_ R8_Databases=1 Notes.ini parameter on the Domino 8 server or the Notes 8 client.

Tim Speed is an IBM Certified Systems Architect with IBM Software Services for Lotus. In that capacity, he's responsible for designing, implementing, and supporting various engagements with its clients. Mr. Speed lives in Denton, Texas, and has been an IBM/Lotus employee for more than 12 years in a variety of networking, technical, hardware and software support and consulting positions. He has been working with Notes for more than 15 years focusing on administration roles and infrastructure. He also has international experience with working on infrastructure engagements in Spain, Japan, Hong Kong, Singapore, Malaysia, the UK, and Indonesia. Dick McCarrick is a freelance writer who has worked extensively with Lotus Notes and Domino over the years. Dick spent more than 15 years with the Lotus Notes and Domino team, initially as a documentation writer, then later with developerWorks: Lotus. Since leaving IBM, he continues to be involved with Notes/Domino, co-authoring three previous books on this product. Barry Rosen is an Advisory IT Specialist with IBM Software Services for Lotus. During the last two years, Mr. Rosen has worked on several large messaging and migration projects as well as performed Domino upgrades and messaging assessments. Before that he was a Software Engineer in Lotus Support for more than five years. While in support Mr. Rosen was on several teams specializing in mail routing, Lotus Notes Client, calendaring and scheduling, and server core. He focused on clustering, Lotus Notes for the Macintosh, and rooms and resources. Currently Mr. Rosen resides in Houston. Having graduated from the University of Texas at Austin, Mr. Rosen enjoys following Longhorn sports. Bennie Gibson is an IBM Certified Systems Architect with IBM Software Services for Lotus. In that capacity, he is responsible for managing various engagements with its clients. Mr. Gibson lives in Wake Forest, NC and has been an IBM/Lotus employee for more than 24 years in a variety of sales, consulting, and management roles. He has been working with Notes for more than 10 years focusing on architecture and infrastructure. He also has international experience with working on infrastructure engagements in Malaysia. Brad Schauf is an IBM Executive I/T Architect with more than 20 years of experience in the computer services and consulting industry. He has experience with enterprise-wide software and messaging and portal deployments, with a concentration on Lotus Notes/Domino messaging infrastructure architecture, application development, and integration as well as WebSphere portal architecture design and deployments. His experience includes API-level application development and lead programmer, enterprise lead for messaging and portal deployments to General Manager including P&L commitments. He was a founder of a successful IBM business partner before joining IBM in 1999. David Byrd is an IBM Senior Certified Executive IT Architect with IBM Software Services for Lotus from Fayetteville, GA. He has been an IBM/Lotus employee for more than 9 years in a number of consulting positions covering various technology areas. David has a deep background in virtually all areas of Lotus products and technologies covering areas ranging from low-level API development and collaborative application architectures, to security architectures and messaging architectures. His current focus is on Lotus Quickr as well as other team collaboration technologies and its deployment in enterprise customers. He has worked with Lotus Notes and Domino for more than 15 years. Joseph Anderson is an IBM Certified Senior Managing Consultant from the IBM Software Services for Lotus team. Joseph has worked with Lotus Notes/Domino, Lotus Sametime, and Lotus QuickPlace since the early 1990s, primarily as a consultant. He is currently working with the Competitive Software team focusing on Domino/Notes administration, migration/upgrade, and security. Prior to working in the consulting industry, Joseph worked in the legal industry as a Director of Operations, where he leveraged his Master of Science in Legal Administration from the University of Denver College of Law.

Printer-friendly
page layout

What's New in IBM Lotus Notes/Domino 8 Development: DB2 Integration and View Enhancements

No reader comments ... yet.

    What do YOU think about this topic? Share your advice and thoughts using this form.

    Your Name

    REQUIRED : PUBLIC

    Your E-Mail

    REQUIRED : PRIVATE

    Job, Company

    OPTIONAL : PUBLIC

    City, State, Country

    OPTIONAL : PUBLIC

    Your Web Site

    OPTIONAL : PUBLIC

    Your Comment

    Please help everyone by keeping your comments on-topic, using clean language, and not defaming or making personal attacks.


    Your e-mail address is required, but it will not be displayed to the public or given to anyone. See our Privacy Policy. Comments become visible after they pass our spam filter, and spammers and abusers are permanently blocked. Please report spam or abuse.

    ARTICLE INFO

    Web Edition: 2008 Week 19, Doc #19463

    FREE ACCESS FREE ACCESS

    Keyword Tags: Application Development, Collaboration, Development, IBM, IBM DB2, IBM Lotus, IBM Lotus Domino, IBM Lotus Notes, IBM WebSphere, IT Networking, Linux, Lotusscript, Messaging, Microsoft Windows, Portals, Security

    Use of this or any other site, content, product or service of Advisor Media constitutes acceptance of Terms of Use.
    Portions copyright ©1983-2010 Advisor Media, LLC. All Rights Reserved.
    Reuse or reproduction of any portion or quantity of Advisor Media's copyrighted content, in any form, for any purpose, requires written permission.
    ADVISOR®, the ADVISOR logo, and other names and logos that incorporate ADVISOR are registered trademarks, trademarks or service marks of Advisor Media, LLC in the United States and/or other countries.
    Other trademarks are used for identification, editorial or descriptive purposes and are the property of their owners.
    Hosted by Prominic.NET Website powered by
    LOTUS SOFTWARE
    oa speet001-05 posted 2008-5-5 mod 03/15/2010 03:12:15 AM ztdbms/ztdbms
    domino-144.advisor.com my.advisor.com 03/19/2010 01:36:33 PM