DB2 Everyplace

• Using the DB2 Everyplace information center
  • Accessing DB2 Everyplace books and release information
  • Features of the DB2 Everyplace Information Center
  • Finding topics in the DB2 Everyplace Information Center
  • Viewing technical documentation directly from the DB2 Everyplace CD
• Accessibility features
• Product overview
  • What is DB2 Everyplace?
  • Components of the DB2 Everyplace solution
    • The mobile database
    • The Sync Server
    • The Sync Client
    • The Mobile Application Builder
    • The sample applications
  • An example DB2 Everyplace scenario
• Installing DB2 Everyplace
  • On a server
    • Pre-installation tasks
      • Linux
      • Solaris
      • AIX
    • Migrating to V8.1.4
    • Installing Enterprise Edition for Windows
    • Installing Enterprise Edition for UNIX
    • Installing Express for Windows
    • Installing Express for Linux
    • Post installation tasks
      • Creating a DB2 Everyplace instance on UNIX
      • Mapping a source database to a mid-tier server
      • Enabling replication
      • Setting up sample databases and applications
      • Testing the servlet
      • Configuring Sync Server to use with IBM WAS Version 4.0
      • Configuring Sync Server to use with IBM WAS Version 5.0
        • Gathering configuration information
        • The WAS installation scripts
        • Installation and configuration overview
        • Creating and installing an application server
        • Creating a cluster environment
          • Adding the server nodes
          • Creating the cluster
          • Adding servers to the cluster
        • Regenerating the Web server plugin
        • Adminstrative tasks
          • Uninstalling
          • Starting and stopping the server
          • Deleting the cluster
      • Configuring a multiple server environment
        • Server groups and clones
        • Planning considerations and tips
        • Setting up to create application server clones
        • Creating application server clones
        • Post-configuration tasks
  • On a mobile device
    • Using the Install on Mobile Devices tool
    • Installing manually
      • On a Palm OS device
      • On a Windows CE device
      • On a Symbian OS Version 6 device
      • On a Symbian OS Version 7 device
      • On a QNX Neutrino or embedded Linux mobile device
      • On a Sharp Zaurus device
      • On a MIDP supported device
      • On a Win32 client
    • Updating Sync Client software with the Update tool
      • Setting up on the Sync Server
      • Installing on a mobile device
      • Troubleshooting
    • Post installation tasks
• Setting up a mobile device for synchronization
  • Palm OS mobile device or emulator
    • Setting up the device or emulator
    • Installing files
    • Synchronizing and verifying data
  • Symbian OS v6.0 mobile device
    • Setting up the device
      • Configuring m-Router Connect on a workstation
      • Configuring m-Router Connect on the device
      • Configuring ISync on the device
      • Using a Remote Access Service
      • Setting up the serial cradle for Windows Remote Access Service
    • Synchronizing data
  • Testing synchronization using IBM Sync
    • Overview
    • Configuring
    • Menu options
    • Synchronizing data
• Setting up the server for synchronization
  • Installing the sample database
  • Creating a JDBC subscription to access source data
  • Grouping subscriptions into mobile subscription sets
  • Creating mobile users
  • Creating a data synchronization group
  • Starting the application server
  • Configuring the Windows Remote Access Service on the Windows workstation
• Setting up data sources for synchronization
  • JDBC subscriptions
    • Configuring the Sync Server
      • Supported JDBC drivers list
      • Configuring the Sync Server using supported drivers
      • Configuring the Sync Server using unsupported drivers
      • Specifying the JDBC driver in the Mobile Device Administration Center
      • Configuring the JDBC driver to access Lotus Domino data
      • Common data source restrictions
        • Lotus Domino data source restrictions
  • DataPropagator subscriptions
    • Creating a DataPropagator table subscription
      • What is a DataPropagator subscription?
        • What is a replication source?
      • Configuring DataPropagator for DB2 Everyplace subscriptions
      • Associating DataPropagator Subscription Sets with table subscriptions
      • Data source restrictions for DataPropagator subscriptions
      • Improving DataPropagator performance
        • Batching synchronization requests
        • Replicating on demand
  • Filtering data from data sources
    • Filtering data horizontally
      • Defining simple horizonal filters
        • Subscription level
        • Group level
        • User level
      • Defining complex horizontal filters
    • Filtering data vertically
  • Creating an application using the remote query and stored procedure adapter
    • The remote query and stored procedure adapter
      • Supported data types for stored procedures
      • CLI functions and restrictions for result sets
    • Using the sample application
      • Creating a data source
      • Creating a stored procedure
      • Creating the Agent Adapter subscription
      • Creating a DB2 Everyplace application
    • Sample code
• Understanding synchronization
  • Components of DB2 Everyplace synchronization
  • Basic setup for the DB2 Everyplace solution
  • The synchronization process
  • Synchronization from the mobile device to the source database
  • Synchronization from the source database to the mobile device
  • Handling synchronization problems
• Managing users and data
  • Mobile Devices Administration Center and synchronization objects
    • What is the Mobile Devices Administration Center?
    • Starting the Mobile Devices Administration Center
    • The Mobile Devices Administration Center interface
    • Synchronization objects
      • What is a synchronization object?
      • Where synchronization objects are stored
      • Creating synchronization objects
        • Creating an object from the object tree
        • Creating a new object when working with another
    • Information displayed in the contents pane
      • Refreshing the view
      • Filtering the contents pane
      • Editing a synchronization object
      • Deleting an object
  • Using the Mobile Devices Administration Center
    • Evaluating the characteristics of your mobile users
    • Creating a data synchronization group
      • What is data synchronization?
      • Identifying the group
      • Enabling the group to access data and files
        • What is a subscription set?
      • Defining a data filter for a group
        • What is a data filter?
        • Data filter example
      • Assigning a user to a group
        • What is a user?
    • Defining mobile users to the Sync Server
      • Creating users
        • Identifying the user
        • Assigning the user to a group
        • Setting the users password
        • Filtering the data available to the user
      • Registering the user's device
      • Importing user definitions from another source
    • Setting up data and replication sets
      • What is a replication set?
      • What is a subscription set?
      • Creating a JDBC subscription
        • What is a JDBC subscription?
        • Identifying the subscription
        • Specifying the encryption level
        • Specifying the source database driver and URL
        • Specifying the mirror database driver and URL
        • Specifying source tables, target table, and privileges
        • Filtering data in the subscription
        • Batching synchronization requests
          • Replication invocation
        • Assigning a subscription set to a JDBC subscription
      • Creating an upload subscription
        • What is an upload subscription?
        • Identifying the upload subscription
        • Specifying the encryption level
        • Specifying the source database driver and URL
        • Specifying source tables, target table, and privileges
        • Assigning a subscription set to an upload subscription
      • Creating a file subscription
        • What is a file 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
      • Creating a custom subscription
        • Identifying the Custom subscription
          • The default adapters
        • Launch the customizer
        • Assigning a subscription set to a custom subscription
    • Enabling groups to access their data
      • What is a subscription set?
      • 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
  • The XML Scripting Tool
    • Overview
    • Exporting an XML script
    • Invoking the XML tool on the command line
    • Example code for programmers
    • XML sample scripts
    • Restrictions
  • Monitoring client synchronization status
    • Accessing the Synchronization Monitor tool
    • Using the Synchronization Monitor tool
      • Setting an automatic refresh
      • Selecting a view
      • Customizing the column display
      • Exporting data
  • Synchronization problems
    • The order of synchronization and error messages
    • Troubleshooting
      • Accessing the error log
      • Purging the error log
      • Defining the trace level
    • Creating error-handling logic
    • Viewing the log on the client
    • Resetting the client user ID
• Developing DB2 Everyplace applications
  • C/C++ applications
    • Developing C/C++ applications
    • C/C++ supported operating systems
    • Supported C/C++ development tools
    • Preparing, compiling, and linking a C/C++ project
    • Testing a C/C++ application
  • C++ Sync Client applications
  • Java applications
    • Developing Java applications
    • JDBC interface supported operating systems
  • Java Sync Client applications
    • Java Sync API supported operating systems
    • IBM Java Sync APIs
    • Overview of DB2 Everyplace synchronization providers
      • Native synchronization providers
      • Installing DB2 Everyplace native synchronization providers
        • Installing the JNI-based native synchronization provider
          • On Win32
          • On Nokia 9210/9290 Communicator devices using Symbian V6
          • On Windows CE
        • Installing the trap-based native synchronization provider
      • Java synchronization providers
        • J2ME MIDP synchronization provider
        • Java Sync Client for Cloudscape
  • Visual Basic applications
    • Visual Basic supported operating systems
    • Developing Visual Basic applications
  • JSP applications
    • JSP supported operating systems
    • Overview of DB2 Everyplace JSP applications
    • Overview of DB2 Everyplace JSP support
    • Setting up for JSP development
      • On a Windows workstation
      • On a Windows CE device
        • Installing the J9 JVM run-time environment
        • Installing and verifying DB2 Everyplace JSP support
      • On a Symbian OS Version 6 device
    • Transferring a JSP application to a Windows CE device
    • Running a JSP application
      • Configuring the mini HTTP Web server
      • Running on a Windows workstation
      • Running on a Windows CE device
      • Running on a Symbian OS Version 6 device
    • Supported JSP Version 1.1 subsets
    • IBM custom tags for JSP application database access
    • Troubleshooting JSP applications
  • .NET applications
    • Synchronization support
      • ISync.NET API file locations
      • Using the ISync.NET API
      • Using ISyncComponent
      • Sample application using ISync.NET API
    • .NET support for building applications
      • Overview of .NET support
      • Using the DB2 Everyplace .NET Data Provider
      • Sample .NET code for WinCE and Win32
  • Accessing a DB2 Everyplace database
    • Overview of the database tables
    • Handling naming conflicts
    • Connecting to the database
    • Connection serialization
    • DB2 Everyplace databases on read-only media
  • Cursor behavior within the context of a connection
  • Piecemeal retrieval of data through CLI
  • Adding parameter markers to SQL queries
    • Overview
    • Examples of usage
    • DB2 Everyplace supported parameter markers
  • Encrypting local data
    • Overview of local data encryption
    • Establishing a connection to the database
    • Granting a user encryption privileges
    • Creating an encrypted table
    • Managing encryption privileges
    • Encryption using the DB2eCLP
• Sample DB2 Everyplace applications
  • Overview of DB2 Everyplace sample applications
  • Visiting Nurse sample application
    • Overview
    • Running
    • Visiting Nurse application tables
  • CLP application
    • Overview
    • CLP Commands
    • Importing and exporting data using CLP
  • Remote query and stored procedure adapter sample code
  • C/C++ applications
  • Java applications
    • Overview of the sample Java applications
    • Compiling and running on Palm OS
      • Installing WCE tooling for WSDD
      • Creating a WSDD project
      • Adding the JDBC driver and java.sql to the build path
      • Importing into WSDD
      • Running on an emulator
    • Compiling and running on other targets
      • Installing WCE tooling for WSDD
      • Creating a WSDD project and adding jar files to the build path
      • Importing into WSDD
      • Running
        • On Win32
        • On Windows CE
        • On QNX Neutrino or embedded Linux
        • On Symbian
  • Visual Basic application
    • Overview of the sample Visual Basic application
    • Compiling and testing the sample Visual Basic application
  • JSP applications
  • Synchronization applications
    • Sync Client C/C++ application
    • Java native synchronization application
    • Java MIDP synchronization application
      • Developing with the Sun Wireless Toolkit
      • Developing with ANT and the Sun Wireless Toolkit command line
    • GoISyncConsole sample Java synchronization application
• Reference information
  • Synchronization server
    • Syntax for creating filters
    • Data type mapping and restrictions
      • DB2 Universal Database
      • Informix 9.x
      • Oracle 8i
      • Sybase 11.9x
      • Lotus Domino
      • SQL Server 2000
      • Cloudscape
  • Application development
    • Supported SQL statements
      • 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
        • SQL symbolic and default data types
        • Data type attributes
    • Supported DB2 CLI/ODBC functions
      • DB2 CLI function summary
      • DB2 CLI function descriptions
        • 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
        • SQLColumns - Get Column Information for a Table
        • 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
        • SQLGetConnectAttr - Returns the current setting of a connection attribute
        • 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
        • SQLNumParams - Get Number of Parameters in A SQL Statement
        • 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
        • SQLTables - Get Table Information
      • Data conversion by DB2 CLI functions
    • Supported JDBC methods
      • Overview of JDBC support
      • Interfaces in the java.sql package
        • Blob interface
        • CallableStatement interface
        • Connection interface
        • DB2eConnection class
        • DatabaseMetaData interface
        • Driver interface
        • PreparedStatement interface
        • ResultSet interface
        • ResultSetMetaData interface
        • Statement interface
        • DB2eStatement class
      • Interfaces in the javax.sql package
        • DataSource interface
  • Supported ADO.NET classes
    • DB2eCommand Members
    • DB2eCommandBuilder Members
    • DB2eConnection Members
    • DB2eDataAdapter Members
    • DB2eDataReader Members
    • DB2eError Members
    • DB2eException Members
    • DB2eParameter Members
    • DB2eTransaction Members
    • DB2eType Enumeration
    • Application Programming Interfaces (APIs)
      • IBM Sync Client C-API
        • 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
        • IBM Sync Client C-API function descriptions
          • Key to IBM Sync Client C-API function descriptions
          • iscGetVersion()
          • iscServiceOpen()
          • iscServiceOpenEx()
          • iscServiceClose()
          • iscConfigOpen()
          • iscConfigClose()
          • iscConfigPurge()
          • iscConfigOpenCursor()
          • iscConfigCloseCursor()
          • iscConfigGetNextSubsSet()
          • iscConfigEnableSubsSet()
          • iscConfigDisableSubsSet()
          • iscConfigResetSubsSet()
          • iscConfigSubsSetIsEnabled()
          • iscConfigSubsSetIsReset()
          • iscConfigGetSubsSetStatus()
          • iscEngineOpen()
          • iscEngineClose()
          • iscEngineGetInfo()
          • iscEngineSetListener()
          • iscEngineListenerPF
          • iscEngineSetPref()
          • iscEngineGetPref()
          • iscEngineSync()
          • iscEngineSyncConfig()
  • Warning and error messages
    • Synchronization server and client
    • Application development
      • SQLState listing
        • Summary of SQLState class codes
        • SQLState messages reported by SQL
        • SQLState messages reported by CLI
        • SQLState messages reported by JDBC
  • DB2 Everyplace System Catalog base tables
  • DB2 Everyplace limits
  • DB2 Everyplace reserved words
  • National language support (NLS)
    • NLS support by operating system
    • Character encoding in Java applications
    • Language enablers
    • UNICODE support
• Index