slide1
Download
Skip this Video
Download Presentation
INT413 ECDA 12.6 Optimization

Loading in 2 Seconds...

play fullscreen
1 / 48

INT413 ECDA 12.6 Optimization - PowerPoint PPT Presentation


  • 78 Views
  • Uploaded on

INT413 ECDA 12.6 Optimization. Jerry Kauffman Software Development Manager [email protected] 7/19/2004. The Enterprise. Unwired. Manage Information. Unwire Information. Unwire People. Information Management Core. Capture. Publish. Enrich. Deliver.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about ' INT413 ECDA 12.6 Optimization ' - lefty


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
slide1

INT413 ECDA 12.6 Optimization

Jerry Kauffman

Software Development Manager

[email protected]

7/19/2004

the enterprise unwired
The Enterprise. Unwired.

Manage

Information

Unwire

Information

Unwire

People

Information

Management

Core

Capture

Publish

Enrich

Deliver

the enterprise unwired1
The Enterprise. Unwired.

Industry and Cross Platform Solutions

Manage

Information

Unwire

Information

Unwire

People

  • 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

directconnect 12 6 where it fits
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

directconnect 12 6
DirectConnect 12.6
  • First major release in 3 years.
  • Major redesign of several products.
all directconnect 12 6 products updated
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
12 6 themes
12.6 Themes
  • Performance, Scalability
  • Peaceful Coexistence
  • New Features
  • DCManager Update
12 6 themes1
12.6 Themes
  • Performance, Scalability
  • Peaceful Coexistence
  • New Features
  • DCManager Update
performance scalability
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
new product architecture background
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
12 5 product architecture
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 5 product architecture1
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

Service Library

(dcany.so)

Open Server Based

Event Handler,

Service Manager

12 5 product architecture2
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

Open Server Based

Event Handler,

Service Manager

(direct)

Service Library,

DB Operations,

Data Conversions

(dcany.so)

ODBC Drivers

(MVMSSS19.so)

(MVINFX19.so)

(MVDB219.so)

TDS Event Hdler,

Data conversions,

DB operations

(dc2any)

new product architecture
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
12 6 product architecture
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)

12 6 product architecture1
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)

12 6 product architecture2
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

Open Server Based

Event Handler,

Service Manager

(direct)

Service Library,

DB Operations,

Data Conversions

(dcany.so)

ODBC Drivers

(MVMSSS19.so)

(MVINFX19.so)

(MVDB219.so)

12 5 software layers removed
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

performance scalability1
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
smp open server conversion
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
smp open server conversion of directconnect
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.
smp open server conversion cont
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
smp open server conversion1
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
12 5 vs 12 6 performance comparison
12.5 vs. 12.6 Performance Comparison
  • ~25% performance increase
12 6 themes2
12.6 Themes
  • Performance, Scalability
  • Peaceful Coexistence
  • New Features
  • DCManager Update
peaceful coexistence
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
peaceful coexistence changes cont
Peaceful Coexistence Changes (cont)
  • Isolation of common libraries
  • InstallShield
  • Minimize dependency on system environment
  • New start and add server scripts
directconnect 12 6 themes
DirectConnect 12.6 Themes
  • Performance, Scalability
  • Peaceful Coexistence
  • New Features
  • DCManager Update
new features
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
directconnect for as400 migration
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
directconnect for as400 migration cont
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
directconnect 12 6 themes1
DirectConnect 12.6 Themes
  • Performance, Scalability
  • Peaceful Coexistence
  • New Features
  • DCManager Update
dcmanager update
DCManager Update
  • Enhanced Usability
  • Support for DirectConnect for Oracle
  • Multiple Platform support
  • Enhanced Compatibility with other Sybase Central Plug-ins
enhanced usability other
Enhanced Usability – Other
  • 508 Compliant
  • Sybase Central v4.3 Support
  • Up to date JConnect Support
dcm direct connect for oracle support
DCM - Direct Connect for Oracle Support
  • All the administrative features DirectConnect for Oracle provides are now supported by DCManager.
dcm multiple platform support
DCM - Multiple Platform support
  • Windows NT, 2000, 2003
  • Linux
  • Solaris
  • HP-UX
  • AIX
dcm enhanced compatibility
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.
dc 12 6 availability
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_mfc126beta

  • GA Q1 2005
dc 12 6 what s next
DC 12.6 What’s Next
  • Port the remaining DirectConnects to Linux platform
  • Add support for the Unicode datatype
  • Add support for the new data types “Date” and “Time”
slide48

INT413 ECDA 12.6 Optimization Questions?

Jerry Kauffman

Software Development Manager

[email protected]

7/19/2004

ad