Table of contents

DB2 Everyplace Common

  • Concepts
  • DB2 Everyplace 정의
  • DB2 Everyplace 모빌 데이터베이스
  • DB2 Everyplace Sync Server
  • DB2 Everyplace Sync Client
  • DB2 Everyplace Mobile Application Builder
  • DB2 Everyplace 샘플 응용프로그램
  • DB2 Everyplace 시나리오 예제
  • 액세스 가능성
  • DB2 Everyplace 정보 센터에서 주제 찾기
  • DB2 Everyplace 정보 센터의 기능
  • DB2 Everyplace 책 및 릴리스 정보 액세스
  • DB2 Everyplace CD에서 기술 문서 직접 보기

    • 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
  • WAS 설치 스크립트
  • Visiting Nurse 샘플 응용프로그램의 개요
  • CLP 응용프로그램의 개요
  • IBM Sync 개요
  • IBM Sync 메뉴 옵션
  • 다중 서버 환경 구성
  • 서버 그룹 및 복제본
  • 계획 고려사항 및 팁
  • Tasks
  • 서버에 설치
  • Websphere Application Server 버전 5.0의 DB2 Everyplace 구성 및 설치
  • 클러스터 환경 작성
  • 관리 태스크
  • 버전 8.1.4의 이주 고려사항
  • Windows용 서버에 설치
  • 샘플 데이터베이스 및 응용프로그램 설정
  • Sync Server servlet 테스트
  • IBM WebSphere Application Server에서 사용할 수 있도록 Sync Server 구성
  • 미드 티어 서버에 소스 데이터베이스 맵핑
  • 복제 사용 가능
  • 서버 노드 추가
  • 클러스터 작성
  • 클러스터에 새 서버 추가
  • 구성 정보 수집
  • 웹 서버 플러그인 다시 만들기
  • WAS에서 DB2 Everyplace 설치 제거
  • DB2 Everyplace 응용프로그램 서버(AS) 시작 및 중지
  • 클러스터 삭제
  • 설치 및 구성 개요
  • 응용프로그램 서버(AS) 작성 및 설치
  • 모빌 디바이스에 설치 도구를 사용한 설치
  • Palm OS 디바이스에 DB2 Everyplace 파일 설치
  • Windows CE 디바이스에 파일 설치
  • Symbian OS 버전 6 디바이스에 파일 설치
  • QNX Neutrino 또는 임베디드 Linux 모빌 디바이스에 파일 설치
  • MIDP 지원 디바이스에 파일 설치
  • Win32 클라이언트에서 파일 설치
  • Sharp Zaurus 디바이스에 파일 설치
  • Symbian OS 버전 7 디바이스에 파일 설치
  • 모빌 디바이스에서의 설치 후 태스크
  • DB2 Everyplace 파일 수동 설치
  • 모빌 디바이스 설치
  • DB2 Everyplace 갱신 도구로 Sync Client 소프트웨어 갱신
  • Sync Server에 DB2 Everyplace 갱신 도구 설정
  • 모빌 디바이스에 DB2 Everyplace 갱신 도구 설치
  • 동기화를 위한 Palm OS 모빌 디바이스 설정
  • Palm OS 모빌 디바이스 또는 에뮬레이터 설정
  • Palm OS 모빌 디바이스 또는 에뮬레이터에 파일 설치
  • Palm OS 모빌 디바이스 또는 에뮬레이터에서 데이터 동기화 및 확인
  • 동기화를 위한 Symbian OS V6.0 모빌 디바이스 설정 및 구성
  • 워크스테이션에 m-Router Connect 구성
  • 디바이스에서 m-Router Connect 구성
  • 디바이스에 ISync 구성
  • Symbian OS V6.0 디바이스에서 데이터 동기화
  • Visiting Nurse 응용프로그램 실행
  • CLP로 데이터 임포트 및 익스포트
  • Palm OS용 IBM Sync 구성
  • IBM Sync로 데이터 동기화
  • 응용프로그램 서버(AS) 클론을 작성하기 위한 설정
  • 응용프로그램 서버 복제본 작성
  • 구성 후 태스크
  • Linux용 운영 체제 매개변수 조정
  • Solaris용 운영 체제 매개변수 조정
  • AIX용 운영 체제 매개변수 조정
  • UNIX용 서버에 설치
  • Windows용 서버에 DB2 Everyplace Express 설치
  • Linux용 서버에 DB2 Everyplace Express 설치
  • UNIX에서 DB2 Everyplace 인스턴스 작성
  • Reference
  • DB2 Everyplace 갱신 도구 오류 메시지
  • CLP 명령
  • Visiting Nurse 샘플 응용프로그램 테이블
  • DB2 Everyplace 샘플 응용프로그램의 개요

    • 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 모빌 사용자
  • 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 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 업로드 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 업로드 subscription
  • Specifying the encryption level
  • Specifying the source database driver and URL
  • Specifying source tables and target tables
  • Assigning a subscription set to an 업로드 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
  • Creating 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
  • Using XML Scripting tool parameters
  • Example code for programmers
  • 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

    • 색인