The first time you sign into developerWorks, a profile is created for you. Select information in your developerWorks profile is displayed to the public, but you may edit the information at any time. Your first name, last name (unless you choose to hide them), and display name will accompany the content that you post.

All information submitted is secure.

The first time you sign in to developerWorks, a profile is created for you, so you need to choose a display name. Your display name accompanies the content you post on developerworks.

Please choose a display name between 3-31 characters. Your display name must be unique in the developerWorks community and should not be your email address for privacy reasons.

All information submitted is secure.

My developerWorks:

My notifications:

Sign out

Select a language:

DB2 Everyplace Version 8.2 synchronization horizontal filtering

John Casey (jcasey@us.ibm.com), Consulting IT Software Specialist , IBM Corporation

John Casey is an IBM Certified IT Specialist focused on application development . During his 29 years at IBM, he has been involved in many application projects on both distributed and zSeries platforms. He has authored and conducted technical workshops both inside and outside of IBM. In his current role, he assists IBM customers throughout the world in understanding and using IBM development tools, such as Rational Developer for zSeries and Rational Asset Analyzer, to address their Enterprise Modernization needs.

Summary: Fewer rows synchronized yields faster synch times and faster table scans on your mobile device. This article explains horizontal filtering, a method for synchronizing a select subset of rows between the server and the DB2® Everyplace mobile device that can significantly enhance performance.

Tag this!

Date: 28 Oct 2004
Level: Introductory

Activity: 2775 views
Comments:

Introduction

IBM® DB2® Everyplace is a relational database and enterprise synchronization server that enables enterprise applications and enterprise date to be extended to mobile devices, such as personal digital assistants (PDAs) and smart phones.

When designing your usage of the synchronization capabilities of the DB2 Everyplace Enterprise solution, a significant part of that design will be deciding what rows of a table will be synchronized to each mobile device. The intent of this article is to expand the IBM DB2 Everyplace Sync Server Administration Guide manual with additional examples, complex examples, and screen shots of MDAC as the examples are explained.

Highlights include:

Explanation of filtering
Filtering based upon a value in a table
Filtering based upon a value in a related table
Table definitions
XML definitions

Read the full article (PDF) here:

Description	File type	File size	Type of download
dm-0410casey1.pdf	pdf	136 KB	FTP

About the author

Close [x]

Report abuse help

Report abuse

Thank you. This entry has been flagged for moderator attention.

Close [x]

Report abuse help

Report abuse

Report abuse submission failed. Please try again later.

Close [x]

developerWorks: Sign in

The first time you sign into developerWorks, a profile is created for you. Select information in your developerWorks profile is displayed to the public, but you may edit the information at any time. Your first name, last name (unless you choose to hide them), and display name will accompany the content that you post.

All information submitted is secure.

Close [x]

Choose your display name

The first time you sign in to developerWorks, a profile is created for you, so you need to choose a display name. Your display name accompanies the content you post on developerWorks.

Please choose a display name between 3-31 characters. Your display name must be unique in the developerWorks community and should not be your email address for privacy reasons.

All information submitted is secure.

Rate this article

Comments

Close [x]

Help: Update or add to My dW interests

What's this?

This little timesaver lets you update your My developerWorks profile with just one click! The general subject of this content (AIX and UNIX, Information Management, Lotus, Rational, Tivoli, WebSphere, Java, Linux, Open source, SOA and Web services, Web development, or XML) will be added to the interests section of your profile, if it's not there already. You only need to be logged in to My developerWorks.

And what's the point of adding your interests to your profile? That's how you find other users with the same interests as yours, and see what they're reading and contributing to the community. Your interests also help us recommend relevant developerWorks content to you.

View your My developerWorks profile

Return from help

Close [x]

Help: Remove from My dW interests

What's this?

Removing this interest does not alter your profile, but rather removes this piece of content from a list of all content for which you've indicated interest. In a future enhancement to My developerWorks, you'll be able to see a record of that content.

View your My developerWorks profile

Return from help

static.content.url=http://www.ibm.com/developerworks/js/artrating/

SITE_ID=1

Zone=Information Management

ArticleID=24191

ArticleTitle=DB2 Everyplace Version 8.2 synchronization horizontal filtering

publish-date=10282004

author1-email=jcasey@us.ibm.com

author1-email-cc=