Articles & Content

Archives

Unicode Implementations in DB2: Performance Study (A14)

Topic: 2009 NA

Subtopic: DB2 for z/OS



DATE: 2009-5-15 (10:30 AM - 11:30 AM)
SPEAKERS: Konstantin Tadenev (UPS)

We need Unicode to enable our databases for global commerce. But how do we implement it while maintaining optimal performance and containing costs? The author and his colleagues conducted a study aimed at answering this question in preparation for a major IT Globalization effort. This presentation explores two Unicode implementations in DB2: UTF-8 and UTF-16. It examines how these implementations fit in the overall enterprise data strategy and how they influence performance of Java and COBOL applications. Rich empirical data collected during the study challenged preconceptions and helped shape a set of best practices for the database and application designers.

EXP. LEVEL: Intermediate,Advanced

OBJECTIVES:

UTF-8 and UTF-16 as Unicode implementations in DB2

Unicode data exchange challenges between z/OS and other platforms

Performance and capacity of Java workloads in DB2 Unicode databases: study results

Performance and capacity of COBOL workloads in DB2 Unicode databases: study results

Study conclusions: guidelines and best practices



Click Here to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.