DB2 Everyplace

• 使用「DB2 Everyplace 資訊中心」
  • 存取 DB2 Everyplace 書籍及版本資訊
  • 「DB2 Everyplace 資訊中心」的特性
  • 在「DB2 Everyplace 資訊中心」中尋找主題
  • 直接從 DB2 Everyplace CD 檢視技術文件
• 協助工具特性
• 產品概觀
  • 何謂 DB2 Everyplace？
  • Components of the DB2 Everyplace solution
    • 行動資料庫
    • Sync Server
    • Sync Client
    • 行動應用程式建置器
    • 範例應用程式
  • DB2 Everyplace 實務範例
• 安裝 DB2 Everyplace
  • 在伺服器上
    • 前置安裝作業
      • Linux
      • Solaris
      • AIX
    • 移轉到 V8.1.4
    • 安裝 Enterprise Edition (Windows)
    • 安裝 Enterprise Edition (UNIX)
    • 安裝 Express (Windows)
    • 安裝 Express (Linux)
    • 後置安裝作業
      • 在 UNIX 上建立 DB2 Everyplace 案例
      • 對映來源資料庫至中層伺服器
      • 啟用抄寫
      • 設定範例資料庫及應用程式
      • 測試 servlet
      • 配置 Sync Server 以與 IBM WAS 4.0 版搭配使用
      • 配置 Sync Server 以與 IBM WAS 5.0 版搭配使用
        • 收集配置資訊
        • WAS 安裝 Script
        • 安裝與配置概觀
        • 建立及安裝應用程式伺服器
        • 建立叢集環境
          • 新增伺服器節點
          • 建立叢集
          • 將伺服器新增至叢集
        • 重建 Web 伺服器 Plugin
        • 管理作業
          • 解除安裝
          • 啟動及停止伺服器
          • 刪除叢集
      • 配置多個伺服器環境
        • 伺服器群組及複製物
        • 規劃注意事項及要訣
        • 設定以建立應用程式伺服器複製物
        • 建立應用程式伺服器複製物
        • 後置配置作業
  • 在行動裝置上
    • 使用「在行動裝置上安裝」工具
    • 手動安裝
      • 在 Palm OS 裝置上
      • 在 Windows CE 裝置上
      • 在 Symbian OS 第 6 版裝置上
      • 在 Symbian OS 第 7 版裝置上
      • 在 QNX Neutrino 或內嵌式 Linux 行動裝置上
      • 在 Sharp Zaurus 裝置上
      • 在 MIDP 支援的裝置上
      • 在 Win32 從屬站上
    • 使用更新工具來更新 Sync Client 軟體
      • 在 Sync Server 上設定
      • 在行動裝置上安裝
      • 疑難排解
    • 後置安裝作業
• 設定行動裝置來進行同步化
  • Palm OS 行動裝置或模擬程式
    • 設定裝置或模擬程式
    • 安裝檔案
    • 同步化及驗證資料
  • Symbian OS v6.0 行動裝置
    • 設定裝置
      • 在工作站上配置 m-Router Connect
      • 在裝置上配置 m-Router Connect
      • 在裝置上配置 ISync
      • Using a Remote Access Service
      • Setting up the serial cradle for Windows Remote Access Service
    • 同步化資料
  • 使用 IBM Sync 測試同步化
    • 概觀
    • 配置
    • 功能表選項
    • 同步化資料
• 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
• DB2 Everyplace 範例應用程式
  • DB2 Everyplace 範例應用程式的概觀
  • Visiting Nurse 範例應用程式
    • 概觀
    • 執行
    • Visiting Nurse 應用程式表格
  • CLP 應用程式
    • 概觀
    • CLP 命令
    • 使用 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
• 索引