INT413 ECDA 12.6 Optimization
This presentation is the property of its rightful owner.
Sponsored Links
1 / 48

INT413 ECDA 12.6 Optimization PowerPoint PPT Presentation


  • 46 Views
  • Uploaded on
  • Presentation posted in: General

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.

Download Presentation

INT413 ECDA 12.6 Optimization

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


Int413 ecda 12 6 optimization

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


12 5 vs 12 6 executable size

12.5 vs. 12.6 Executable Size

Disk Space (KB)


12 5 vs 12 6 memory 1 connection

12.5 vs. 12.6 Memory – 1 Connection

Memory Utilized (MB)


12 5 vs 12 6 memory 10 connections

12.5 vs. 12.6 Memory – 10 Connections

Memory Utilized (MB)


12 5 vs 12 6 memory 10 connections1

12.5 vs. 12.6 Memory – 10 Connections


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 more informative

Enhanced Usability – More Informative


Enhanced usability verbose mode

Enhanced Usability – Verbose Mode


Enhanced usability bottom panel

Enhanced Usability – Bottom Panel


Enhanced usability limited field help

Enhanced Usability – Limited Field Help


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”


Int413 ecda 12 6 optimization

INT413 ECDA 12.6 Optimization Questions?

Jerry Kauffman

Software Development Manager

[email protected]

7/19/2004


  • Login