Title: Arial 28pt'

1
INT413 ECDA 12.6 Optimization
Jerry Kauffman Software Development
Manager jerry.kauffman_at_sybase.com 7/19/2004
2
The Enterprise. Unwired.
Unwire People
Unwire Information
Manage Information
Information Management Core
Capture
Publish
Enrich
Deliver
3
The Enterprise. Unwired.
Industry and Cross Platform Solutions
Unwire People
Unwire Information
Manage Information

• Adaptive Server Enterprise
• Sybase IQ
• Dynamic Archive
• Dynamic ODS
• Real Time Data Services
• Replication Server
• OpenSwitch
• Mirror Activator
• PowerDesigner
• Connectivity Options
• Enterprise Application Server
• PowerBuilder Family

• Unwired Accelerator
• Unwired Orchestrator
• Unwired Toolkit

• SQL Anywhere Studio
• Mobile Email Applications
• Enterprise Portal
• XcelleNet Frontline Solutions
• PocketBuilder
• AvantGo

Sybase Workspace
4
DirectConnect 12.6 (Where it fits)
Any mainframe data
Mainframe Connect
ASE/CIS
Oracle MS SQL Server Sybase DB2 UDB for OS/390,
NT/UNIX AS/400 Informix ODBC-enabled
databases Documents/Files
Any Client Or Browser
DirectConnect
Specialty Data Store Toolkit
Custom Specialty Data Stores
Proxy Tables
Make all your enterprise data look like one
database
5
DirectConnect 12.6

• First major release in 3 years.
• Major redesign of several products.

6
All DirectConnect 12.6 Products Updated

• Enterprise Connect Data Access IPS
• DirectConnect for Microsoft SQL Server
• DirectConnect for DB2 UDB
• DirectConnect for Informix
• DirectConnect for ODBC
• DirectConnect for Oracle
• MainframeConnect IPS
• DirectConnect for OS/390
• DirectConnect for AS400
• Migration to DB2 UDB

7
12.6 Themes

• Performance, Scalability
• Peaceful Coexistence
• New Features
• DCManager Update

8
12.6 Themes

• Performance, Scalability
• Peaceful Coexistence
• New Features
• DCManager Update

9
Performance, Scalability

• New Product Architecture
• DirectConnect for Microsoft SQL Server
• DirectConnect for DB2 UDB
• DirectConnect for Informix
• DirectConnect for ODBC
• SMP Open Server Conversion
• All DirectConnects

10
New Product Architecture - Background

• Predecessor Product Architecture
• Multiple processes
• New process for each connection
• Interprocess communications
• Excess data conversions
• 12.6 Product Architecture
• Single Process
• New thread for each connect
• Data sharing between main thread and connection
  threads
• Simplified data conversions

11
12.5 Product Architecture
Main Process
O P E N S E R V E R
S E R V E R M G R
ASE/CIS Rep. Server
Open Server Based Event Handler, Service
Manager
12
12.5 Product Architecture
Main Process with Service Library Loaded
O P E N S E R V E R
S E R V E R M G R
C O N N H A N D L R
D B T O O L S
D T Y P E C O N V
T D S L I B R A R Y
ASE/CIS Rep. Server
Open Server Based Event Handler, Service
Manager
Service Library (dcany.so)
13
12.5 Product Architecture
Dc2any process (one per connection)
Main process
O P E N S E R V E R
S E R V E R M G R
C O N N H A N D L R
D B T O O L S
D A T A C O N V
T D S L I B R A R Y
T D S S E R V E R
D A T A C O N V
S Y B O D B C
O D B C M G R
ODBC DRIVERS MSSS INFX DB2
UDB
ASE/CIS Rep. Srvr
Target DB
pipe
Service Library, DB Operations, Data
Conversions (dcany.so)
Open Server Based Event Handler, Service
Manager (direct)
TDS Event Hdler, Data conversions, DB
operations (dc2any)
ODBC Drivers (MVMSSS19.so) (MVINFX19.so) (MVDB219.
so)
14
New Product Architecture

• Predecessor Product Architecture
• Multiple processes
• New process for each connection
• Interprocess communications
• Excess data conversions
• 12.6 Product Architecture
• Single Process
• New thread for each connection
• Data sharing between main thread and connection
  threads
• Simplified data conversions

15
12.6 Product Architecture
Main process
O P E N S E R V E R
S E R V E R M G R
ASE/CIS Rep. Server
Open Server Based Event Handler, Service
Manager (direct)
16
12.6 Product Architecture
Main process
O P E N S E R V E R
S E R V E R M G R
C O N N H A N D L R
D A T A C O N V
S Y B O D B C
O D B C M G R
ASE/CIS Rep. Server
Open Server Based Event Handler, Service
Manager (direct)
Service Library, DB Operations, Data
Conversions (dcany.so)
17
12.6 Product Architecture
Main process
O P E N S E R V E R
S E R V E R M G R
C O N N H A N D L R
D A T A C O N V
S Y B O D B C
O D B C M G R
ODBC DRIVERS MSSS INFX DB2
UDB
(one thread per connection)
ASE/CIS Rep. Server
Target Database
Service Library, DB Operations, Data
Conversions (dcany.so)
ODBC Drivers (MVMSSS19.so) (MVINFX19.so) (MVDB219.
so)
Open Server Based Event Handler, Service
Manager (direct)
18
12.5 Software Layers Removed
Dc2any process (one per connection)
Main process
D B T O O L S
D A T A C O N V
T D S L I B R A R Y
T D S S E R V E R
pipe
19
12.5 vs. 12.6 Executable Size
Disk Space (KB)
20
12.5 vs. 12.6 Memory 1 Connection
Memory Utilized (MB)
21
12.5 vs. 12.6 Memory 10 Connections
Memory Utilized (MB)
22
12.5 vs. 12.6 Memory 10 Connections
23
Performance, Scalability

• New Product Architecture
• DirectConnect for Microsoft SQL Server
• DirectConnect for DB2 UDB
• DirectConnect for Informix
• DirectConnect for ODBC
• SMP Open Server Conversion
• All DirectConnects

24
SMP Open Server Conversion

• SMP Open Server Conversion
• DirectConnect for Microsoft SQL Server
• DirectConnect for DB2 UDB
• DirectConnect for Informix
• DirectConnect for ODBC
• DirectConnect for Oracle ( available since 12.5)
• DirectConnect for OS/390
• db2 access service
• trstcp access service
• trslu62 access service

25
SMP Open Server Conversion of DirectConnect

• All DirectConnects are based on Sybase's Open
  Server SDK. The SDK can be used to build TDS
  based, database event handling servers.
• Open Server can be configured to manage event
  threads in many ways.
• Open Server release 12.5 introduced the SMPOS
  option, which provides reentrant libraries for
  preemptive event handling with native threads.

26
SMP Open Server Conversion (cont)

• DirectConnect 12.5 operated in non-preemptive
  mode using Open Server threads. DirectConnect
  controlled context switches, usually after all
  work for the thread was completed. Results in
• Fewer context switches
• Poor CPU utilization
• Lower throughput

27
SMP Open Server Conversion

• DirectConnect 12.6 uses Open Server preemptive
  scheduling which utilizes native operating system
  threads. The operating system controls context
  switching. Results in
• Frequent context switches for improved time
  slicing
• Efficient CPU utilization (including SMP)
• Higher throughput
• Scales to handle more users
• Synchronized access to shared resources, ensure
  reentrancy and thread safety

28
12.5 vs. 12.6 Performance Comparison

• 25 performance increase

29
12.6 Themes

• Performance, Scalability
• Peaceful Coexistence
• New Features
• DCManager Update

30
Peaceful Coexistence

• Definition Internal initiative to improve
  ability of Sybase products to peacefully coexist
  when installed together. Minimize/eliminate
  interference between Sybase applications running
  on the same machine and within the same directory
  structure.
• Achieved by product and installation changes
• Verified by departmental peaceful coexistence
  testing and independent Sybase quality assurance
  teams

31
Peaceful Coexistence Changes (cont)

• Isolation of common libraries
• InstallShield
• Minimize dependency on system environment
• New start and add server scripts

32
DirectConnect 12.6 Themes

• Performance, Scalability
• Peaceful Coexistence
• New Features
• DCManager Update

33
New Features

• Windows Service Execution (All)
• Date and Time datatype support (Oracle)
• LINUX
• DC/Oracle
• DCManager
• Express Transfer
• Microsoft SQL Server, DB2 UDB, Informix, and ODBC
• UNIX and Windows Platforms

34
DirectConnect for AS400 Migration

• DirectConnect for DB2 UDB
• Has been available for access to AS400 since
  12.5.3
• ECDA IPS 12.6 (and beyond) will no longer include
  the AS400 option
• TCP/IP Access Only
• SNA is not supported
• Migrate AS400.cfg files to dcany.cfg file
• Reconfigure connectivity and character set
  translation
• Migrate Sybase AS400 SQL stored procedures to
  native AS400 SQL stored procedures
• Native stored procedures utilize extensive IBM
  SQL programming language

35
DirectConnect for AS400 Migration (cont)

• Benefits of using DirectConnect for DB2 UDB
• Express Transfer to/from AS400 targets
• More powerful SQL stored procedures
• TCP/IP access
• Login name and password encryption
• Keeping pace of DB2 UDB AS400 updates and new
  features
• Uses new architecture and the SMPOS

36
DirectConnect 12.6 Themes

• Performance, Scalability
• Peaceful Coexistence
• New Features
• DCManager Update

37
DCManager Update

• Enhanced Usability
• Support for DirectConnect for Oracle
• Multiple Platform support
• Enhanced Compatibility with other Sybase Central
  Plug-ins

38
Enhanced Usability More Informative
39
Enhanced Usability Verbose Mode
40
Enhanced Usability Bottom Panel

41
Enhanced Usability Limited Field Help

42
Enhanced Usability Other

• 508 Compliant
• Sybase Central v4.3 Support
• Up to date JConnect Support

43
DCM - Direct Connect for Oracle Support

• All the administrative features DirectConnect for
  Oracle provides are now supported by DCManager.

44
DCM - Multiple Platform support

• Windows NT, 2000, 2003
• Linux
• Solaris
• HP-UX
• AIX

45
DCM - Enhanced Compatibility

• DCManager has been designed to work on the latest
  version of Sybase Central (Version 4.3) along
  with the other major Sybase products (ASE and
  Rep-Server) to enhance compatibility across
  multiple product plug-ins.

46
DC 12.6 Availability

• Beta Q4 2004
• Beta Period - November 23, 2004 through January
  18, 2005
• For more Info Visit http//www.sybase.com/ecda_mf
  c126beta
• GA Q1 2005

47
DC 12.6 Whats Next

• Port the remaining DirectConnects to Linux
  platform
• Add support for the Unicode datatype
• Add support for the new data types Date and
  Time

48
INT413 ECDA 12.6 Optimization Questions?
Jerry Kauffman Software Development
Manager jerry.kauffman_at_sybase.com 7/19/2004