Table of contents

DB2 Everyplace Common

  • Concepts
  • What is DB2 Everyplace?
  • The DB2 Everyplace mobile database
  • The DB2 Everyplace Sync Server
  • The DB2 Everyplace Sync Client
  • The DB2 Everyplace Mobile Application Builder
  • The DB2 Everyplace sample applications
  • An example DB2 Everyplace scenario
  • Accessibility

    • DB2 Everyplace Application Development

  • Concepts
  • The sample C/C++ applications
  • Overview of the sample Java applications
  • Overview of the sample Visual Basic application
  • DB2 Everyplace JSP support overview
  • Developing DB2 Everyplace JSP applications
  • The sample JSP applications
  • Overview of DB2 Everyplace synchronization providers
  • DB2 Everyplace native synchronization
  • DB2 Everyplace J2ME MIDP synchronization
  • DB2 Everyplace Java Sync Client for Cloudscape
  • DB2 Everyplace Java synchronization
  • The sample Java native synchronization applications
  • The sample Java MIDP synchronization applications
  • The sample Sync Client C/C++ application
  • Overview of the DB2 Everyplace database tables
  • Connection serialization
  • DB2 Everyplace databases on read-only media
  • Cursor behavior within the context of a connection
  • Encryption using the DB2eCLP
  • Character encoding in Java applications
  • Overview of parameter markers
  • Examples of parameter marker usage
  • ISync.Net API file locations
  • Simple example application using the ISync.NET API
  • Overview of .NET support for building applications on the client database
  • Sample DB2 Everyplace .NET Data Provider application code for WinCE and Win32
  • Tasks
  • Developing DB2 Everyplace C/C++ applications
  • Preparing, compiling, and linking a C/C++ project
  • Testing a C/C++ application
  • Developing DB2 Everyplace Java applications
  • Creating a WSDD project for DB2eAppl.java for Palm OS targets
  • Installing WCE Tooling for WSDD for Palm OS targets
  • Installing WCE Tooling for WSDD for non-Palm OS targets
  • Creating a WSDD project and adding jar files to the build path for DB2eAppl.java for non-Palm OS targets
  • Adding the DB2 Everyplace JDBC Driver and java.sql package to the build path
  • Importing DB2eAppl.java into WSDD for Palm OS
  • Importing DB2eAppl.java into WSDD for non-Palm OS targets
  • Running DB2eAppl.java on Win32
  • Running DB2eAppl.java on Windows CE
  • Running DB2eAppl.java on a Palm OS emulator
  • Running DB2eAppl.java on QNX Neutrino or embedded Linux
  • Running DB2eAppl.java on Symbian
  • Compiling and running sample Java applications on Palm OS targets
  • Compiling and running sample Java applications on non-Palm OS targets
  • Developing DB2 Everyplace Visual Basic applications
  • Compiling and testing the sample Visual Basic program
  • Verifying JSP support on a Windows workstation
  • Setting up for JSP development on a Windows CE device
  • Installing and verifying JSP support on a Windows CE device
  • Installing the J9 JVM run-time environment on a Windows CE device
  • Transferring a JSP application to a Windows CE device
  • Running a JSP application on a Windows workstation
  • Running a JSP application on a Windows CE device
  • Configuring the mini HTTP Web server
  • Running a JSP application
  • Installing and verifying JSP support on a Symbian OS Version 6 device
  • Running a JSP application on a Symbian OS Version 6 device
  • Installing the JNI-based native synchronization provider
  • Installing the JNI-based synchronization provider on Win32
  • Installing the JNI-based synchronization provider on Nokia 9210/9290 Communicator devices using Symbian V6
  • Installing the JNI-based synchronization provider on Windows CE
  • Developing the isync4j for MIDP application with the Sun Wireless Toolkit
  • Developing the isync4j for MIDP application with ANT and the Sun Wireless Toolkit Command Line
  • Installing and verifying the trap-based native synchronization provider
  • Compiling and running the GoISyncConsole sample Java synchronization application
  • Developing DB2 Everyplace Sync Client applications using C/C++
  • Handling naming conflicts
  • Connecting to the DB2 Everyplace database
  • Piecemeal retrieval of data through CLI
  • Overview of local data encryption
  • Establishing a connection to the DB2 Everyplace database
  • Granting a user encryption privileges
  • Creating an encrypted table
  • Managing encryption privileges
  • Using the ISync.NET API
  • Using ISyncComponent
  • Overview of developing ADO.NET applications using the DB2 Everyplace
  • Reference
  • Supported C/C++ development tools
  • C/C++ supported operating systems
  • JDBC interface supported operating systems
  • Visual Basic Interface supported operating systems
  • Supported JSP Version 1.1 subsets
  • IBM custom tags for JSP application database access
  • JSP supported operating systems
  • Troubleshooting JSP applications
  • Overview of DB2 Everyplace SQL statement support
  • CALL
  • CREATE INDEX
  • CREATE TABLE
  • DELETE
  • DROP
  • EXPLAIN
  • GRANT
  • INSERT
  • REORG TABLE
  • REVOKE
  • SELECT
  • UPDATE
  • Data type compatibility for assignments and comparisons
  • DB2 Everyplace supported parameter markers
  • SQL symbolic and default data types
  • Data type attributes
  • SQLState listing
  • Summary of SQLState class codes
  • SQLState messages reported by SQL
  • SQLState messages reported by CLI
  • SQLState messages reported by JDBC
  • DB2 CLI function summary
  • Key to DB2 CLI function descriptions
  • SQLAllocConnect--Allocate connection handle
  • SQLAllocEnv--Allocate environment handle
  • SQLAllocHandle--Allocate handle
  • SQLAllocStmt--Allocate a statement handle
  • SQLBindCol--Bind a column to an application variable
  • SQLBindParameter--Bind a parameter marker to a buffer
  • SQLConnect--Connect to a data source
  • SQLDescribeCol--Return a set of attributes for a column
  • SQLDisconnect--Disconnect from a data source
  • SQLEndTran--Request a COMMIT or ROLLBACK
  • SQLError--Retrieve error information
  • SQLExecDirect--Execute a statement directly
  • SQLExecute--Execute a statement
  • SQLFetch--Fetch next row
  • SQLFetchScroll--Fetch row set and return data for all bound columns
  • SQLForeignKeys--Get the list of foreign key columns
  • SQLFreeConnect--Free connection handle
  • SQLFreeEnv--Free environment handle
  • SQLFreeHandle--Free handle resources
  • SQLFreeStmt--Free (or reset) a statement handle
  • SQLGetCursorName--Get cursor name
  • SQLGetData--Get data from a column
  • SQLGetDiagRec--Get multiple fields settings of diagnostic record
  • SQLGetInfo--Get general information
  • SQLGetStmtAttr--Get current setting of a statement attribute
  • SQLNumResultCols--Get number of result columns
  • SQLPrepare--Prepare a statement
  • SQLPrimaryKeys--Get primary key columns of a table
  • SQLRowCount--Get row count
  • SQLSetConnectAttr--Set options related to a connection
  • SQLSetStmtAttr--Set options related to a statement
  • Data conversion by DB2 CLI functions
  • SQLGetConnectAttr--Get current setting of a connection attribute
  • SQLTables - Get Table Information
  • SQLColumns - Get Column Information for a Table
  • SQLNumParams - Get Number of Parameters in A SQL Statement
  • Blob interface
  • Connection interface
  • DatabaseMetaData interface
  • Driver interface
  • PreparedStatement interface
  • ResultSet interface
  • ResultSetMetaData interface
  • Statement interface
  • DB2eStatement class
  • DB2eConnection class
  • Overview of DB2 Everyplace JDBC support
  • DataSource interface
  • CallableStatement interface
  • Comparisons between IBM Sync Client C-API Version 8.1 and Version 7.2
  • IBM Sync Client C-API function summary
  • IBM Sync Client C-API data types
  • Key to IBM Sync Client C-API function descriptions
  • iscGetVersion()
  • iscServiceOpen()
  • iscServiceClose()
  • iscServiceOpenEx()
  • iscConfigOpen()
  • iscConfigClose()
  • iscConfigPurge()
  • iscConfigOpenCursor()
  • iscConfigCloseCursor()
  • iscConfigGetNextSubsSet()
  • iscConfigEnableSubsSet()
  • iscConfigDisableSubsSet()
  • iscConfigResetSubsSet()
  • iscConfigSubsSetIsEnabled()
  • iscConfigSubsSetIsReset()
  • iscConfigGetSubsSetStatus()
  • iscEngineOpen()
  • iscEngineClose()
  • iscEngineGetInfo()
  • iscEngineSetListener()
  • iscEngineListenerPF
  • iscEngineSetPref()
  • iscEngineGetPref()
  • iscEngineSync()
  • iscEngineSyncConfig()
  • IBM Java Sync APIs
  • Java Sync API supported operating systems
  • DB2 Everyplace System Catalog base tables
  • The DB2 Everyplace information set
  • DB2 Everyplace limits
  • National language support (NLS)
  • DB2 Everyplace NLS support by operating system
  • DB2 Everyplace language enablers
  • DB2 Everyplace UNICODE support
  • DB2 Everyplace reserved words
  • DB2eCommandBuilder Members
  • DB2eCommand Members
  • DB2eConnection Members
  • DB2eDataAdapter Members
  • DB2eDataReader Members
  • DB2eError Members
  • DB2eException Members
  • DB2eParameter Members
  • DB2eTransaction Members
  • DB2eType Enumeration

    • DB2 Everyplace Installation

  • Concepts
  • The WAS installation scripts
  • Overview of the Visiting Nurse sample application
  • Overview of the CLP application
  • Overview of IBM Sync
  • IBM Sync menu options
  • Configuring a multiple server environment
  • Server groups and clones
  • Planning considerations and tips
  • Tasks
  • Installing on the server
  • Configuring and Installing DB2 Everyplace with WebSphere Application Server Version 5.0
  • Creating a cluster environment
  • Administrative tasks
  • Migration considerations for Version 8.1.4
  • Installing on a server for Windows
  • Setting up sample databases and applications
  • Testing the Sync Server servlet
  • Configuring Sync Server to use with IBM WebSphere Application Server
  • Mapping a source database to a mid-tier server
  • Enabling replication
  • Adding the server nodes
  • Creating the cluster
  • Adding new servers to the cluster
  • Gathering configuration information
  • Regenerating the Web Server plugin
  • Uninstalling DB2 Everyplace from WAS
  • Starting and stopping the DB2 Everyplace application server
  • Deleting the Cluster
  • Installation and configuration overview
  • Creating and installing an application server
  • Installing using the Install on Mobile Devices tool
  • Installing DB2 Everyplace files on a Palm OS device
  • Installing files on a Windows CE device
  • Installing files on a Symbian OS Version 6 device
  • Installing files on a QNX Neutrino or embedded Linux mobile device
  • Installing files on a MIDP supported device
  • Installing files on a Win32 client
  • Installing files on a Sharp Zaurus device
  • Installing files on a Symbian OS Version 7 device
  • Post installation tasks on the mobile device
  • Installing DB2 Everyplace files manually
  • Installing mobile devices
  • Updating Sync Client software using the DB2 Everyplace Update Tool
  • Setting up the DB2 Everyplace Update Tool on the Sync Server
  • Installing the DB2 Everyplace Update Tool on a mobile device
  • Setting up a Palm OS mobile device for synchronization
  • Setting up the Palm OS mobile device or emulator
  • Installing files on a Palm OS mobile device or emulator
  • Synchronizing and verifying data on a Palm OS mobile device or emulator
  • Setting up and configuring a Symbian OS V6.0 mobile device for synchronization
  • Configuring m-Router Connect on a workstation
  • Configuring m-Router Connect on the device
  • Configuring ISync on the device
  • Synchronizing data on a Symbian OS V6.0 device
  • Running the Visiting Nurse application
  • Importing and exporting data using the CLP
  • Configuring IBM Sync for Palm OS
  • Synchronizing data using IBM Sync
  • Setting up to create application server clones
  • Creating application server clones
  • Post-configuration tasks
  • Adjusting operating system parameters for Linux
  • Adjusting operating system parameters for Solaris
  • Adjusting operating system parameters for AIX
  • Installing on a server for UNIX
  • Installing DB2 Everyplace Express on a server for Windows
  • Installing DB2 Everyplace Express on a server for Linux
  • Creating a DB2 Everyplace instance on UNIX
  • Reference
  • DB2 Everyplace Update Tool error messages
  • CLP commands
  • Visiting Nurse sample application tables
  • Overview of DB2 Everyplace sample applications

    • DB2 Everyplace Sync Server administration

  • Concepts
  • The synchronization process
  • Synchronization from the mobile device to the source database
  • Synchronization from the source database to the mobile device
  • Synchronization conflict resolution
  • Components of the DB2 Everyplace solution
  • Default JDBC drivers list
  • The remote query and stored procedure adapter
  • Using the remote query and stored procedure adapter in an application
  • Mobile Devices Administration Center and synchronization objects
  • What is the Mobile Devices Administration Center?
  • The Mobile Devices Administration Center interface
  • What is a synchronization object?
  • Where synchronization objects are stored
  • Information displayed in the contents pane
  • Evalutating the characteristics of your mobile users
  • What is data synchronization?
  • What is a subscription set?
  • Data filter example
  • What is a data filter?
  • What is a user?
  • Data set up and replication
  • Replication Invocation
  • What is a replication source?
  • Data filtering and replication
  • What is an upload subscription?
  • What is a subscription set?
  • The default adapters
  • What is a file subscription?
  • What is a DataPropagator subscription?
  • What is a JDBC subscription?
  • What a subscription set?
  • What is a replication subscription?
  • Overview of the XML Scripting tool
  • XML Scripting tool restrictions
  • The order of synchronization and reception of error messages
  • Custom logic
  • Improving replication performance
  • Utilizing the XML Scripting tool
  • Handling synchronization problems
  • Tasks
  • Configuring synchronization
  • Creating a DataPropagator subscription to access data
  • Using a Remote Access Service
  • Configuring the Sync Server to access data sources
  • Creating a DataPropagator Version 8 table subscription
  • Filtering data from data sources
  • Filtering data horizontally
  • Defining simple horizontal filters
  • Creating an application using the remote query and stored procedure adapter
  • Using the Mobile Devices Administration Center
  • Creating a data synchronization group
  • Creating users in the Mobile Devices Administration Center
  • Creating a JDBC subscription
  • Creating a DataPropagator subscription
  • Creating an upload subscription
  • Creating a file subscription
  • Creating a custom subscription
  • Enabling groups to access their data and files
  • Monitoring client synchronization status
  • Using the Synchronization Monitor tool
  • Basic setup for the DB2 Everyplace solution
  • Installing the sample database
  • Creating a JDBC subscription to access source data
  • Setting up sources for DataPropagator subscriptions
  • Creating the DataPropagator subscription
  • Configuring the databases and starting Capture for DataPropagator subscriptions.
  • Grouping subscriptions into mobile subscription sets
  • Creating mobile users
  • Creating a data synchronization group
  • Starting the application server
  • Setting up the serial cradle for use with Windows Remote Access Service
  • Configuring the Windows Remote Access Service on the Windows workstation
  • Configuring the Sync Server for JDBC sources using supported drivers
  • Configuring the Sync Server for JDBC sources using unsupported drivers
  • Configuring the JDBC driver to access Lotus Domino data
  • Specifying the JDBC driver in the Mobile Device Administration Center
  • Configuring DataPropagator for DB2 Everyplace subscriptions
  • Associating the DataPropagator Subscription Set with a DB2 Everyplace table subscription
  • Filtering data at the subscription level
  • Filtering data at the group level
  • Filtering data at the user level
  • Defining complex horizontal filters
  • Filtering data vertically
  • Defining the default value data-filter parameters
  • Creating an AgentAdapter subscription
  • Creating a data source using the sample application
  • Creating the Agent Adapter subscription for the sample application
  • Starting the Mobile Devices Administration Center
  • Creating an object from the object tree
  • Creating synchronization objects
  • Refreshing the view
  • Filtering the contents pane
  • Editing a synchronization object
  • Deleting an object
  • Creating a new object when working with another
  • The administration process
  • Concluding the administration process
  • Identifying the group
  • Enabling the group to access data and files
  • Defining a data filter for a group
  • Assigning a user to a group
  • Identifying the user
  • Assigning the user to a group
  • Setting passwords for the user
  • Filtering the data available to the user
  • Registering a device
  • Importing user definitions from another source
  • Identifying the JDBC subscription
  • Specifying the encryption level
  • Specifying the source database driver and URL
  • Specifying the mirror database driver and URL
  • Specifying source tables, target tables, and privileges for the subscription
  • Filtering the data that will be replicated during synchronization
  • Batching synchronization requests
  • Assigning a subscription set to a JDBC subscription
  • Identifying the subscription
  • Specifying the encryption level
  • Mapping the source to the target
  • Identifying the mirror database
  • Adding a replication source
  • Creating a filter for replicated data
  • Batching synchronization requests
  • Providing a user ID and password for the subscription
  • Specifying the subscription sets that use this subscription
  • Identifying the upload subscription
  • Specifying the encryption level
  • Specifying the source database driver and URL
  • Specifying source tables and target tables
  • Assigning a subscription set to an upload subscription
  • Identifying the subscription
  • Specifying the encryption level
  • Specifying the name of the source file
  • Specifying subscription sets that use the subscription
  • Flagging a subscription that references a changed file
  • Identifying the Custom subscription
  • Specifying the encryption level
  • Launch the customizer
  • Assigning a subscription set to a Custom subscription
  • Replicating on demand
  • Identifying the subscription set
  • Specifying what information the subscription set accesses
  • Making the subscription set available to a group
  • Enabling and disabling synchronization
  • Enabling synchronization
  • Disabling synchronization
  • Exporting XML scripts
  • Viewing the error log to diagnose problems
  • Purging error log entries automatically
  • Defining the tracing level
  • Providing your own error-handling logic
  • Viewing the log on the client
  • Resetting the user ID
  • Accessing the Synchronization Monitor tool
  • Setting an automatic refresh
  • Selecting a view
  • Customizing the column display
  • Exporting data
  • Enabling the sample application for custom logic
  • Using the custom logic sample application
  • Developing custom logic
  • Reference
  • Lotus Domino data source restrictions
  • XML sample scripts
  • Common restrictions for JDBC data sources
  • Data source restrictions for DataPropagator subscriptions
  • Syntax for filters
  • Supported data types for stored procedures
  • CLI functions and restrictions for result sets
  • Create a data source
  • Creating a stored procedure using the sample application
  • Creating a DB2 Everyplace application
  • Sample application code
  • Invoking the XML Scripting tool from the command line
  • Invoking the XML tool programmatically
  • Error messages
  • Data type mappings between DB2 Everyplace and data sources
  • DB2 Universal Database
  • Informix
  • Oracle
  • Sybase
  • Lotus Domino
  • Data type mapping restrictions
  • SQL Server 2000
  • XML Scripting tool DTD
  • Cloudscape
  • Command line scripts for the DB2 Everyplace Sync Server

    • Index