Scribd
Upload
37 views3 pages

Tools For SQL Tuning: Optimization Service Center (OSC)

Uploaded by

senthur123

Tools for SQL Tuning: Optimization Service Center (OSC) helps optimize SQL queries. pureQuery can create DB2 packages for Java and .NET programs to provide static SQL. Packages provide benefits like reduced optimizer processing, consistent performance, security granted to packages instead of tables, and standardized SQL generation. pureQuery helps optimize client-side SQL for existing Java and .NET applications without code changes by using packages to determine query plans during binding.

Copyright:

© All Rights Reserved
Download as PDF, TXT or read online from Scribd
Download as pdf or txt

Tools For SQL Tuning: Optimization Service Center (OSC)

Uploaded by

senthur123
37 views3 pages
Tools for SQL Tuning: Optimization Service Center (OSC) helps optimize SQL queries. pureQuery can create DB2 packages for Java and .NET programs to provide static SQL. Packages provide benefits like reduced optimizer processing, consistent performance, security granted to packages instead of tables, and standardized SQL generation. pureQuery helps optimize client-side SQL for existing Java and .NET applications without code changes by using packages to determine query plans during binding.

Original Description:

Db2 SQL Tuning Osc

Original Title

Db2 SQL Tuning Osc

Copyright

© © All Rights Reserved

Available Formats

PDF, TXT or read online from Scribd

Did you find this document useful?

Is this content inappropriate?

Tools for SQL Tuning: Optimization Service Center (OSC) helps optimize SQL queries. pureQuery can create DB2 packages for Java and .NET programs to provide static SQL. Packages provide benefits like reduced optimizer processing, consistent performance, security granted to packages instead of tables, and standardized SQL generation. pureQuery helps optimize client-side SQL for existing Java and .NET applications without code changes by using packages to determine query plans during binding.

Copyright:

© All Rights Reserved
Download as PDF, TXT or read online from Scribd
Download as pdf or txt
37 views3 pages

Tools For SQL Tuning: Optimization Service Center (OSC)

Uploaded by

senthur123
Tools for SQL Tuning: Optimization Service Center (OSC) helps optimize SQL queries. pureQuery can create DB2 packages for Java and .NET programs to provide static SQL. Packages provide benefits like reduced optimizer processing, consistent performance, security granted to packages instead of tables, and standardized SQL generation. pureQuery helps optimize client-side SQL for existing Java and .NET applications without code changes by using packages to determine query plans during binding.

Copyright:

© All Rights Reserved
Download as PDF, TXT or read online from Scribd
Download as pdf or txt
You are on page 1/ 3

Tools for SQL Tuning:

Optimization Service Center (OSC)


pureQuery and DB2 z/OS:
Who will take advantage of pureQuery? LOTS of different folks!
pureQuery
Web Server
**Bind
Existing
Applications
pureQuery
Runtime located
with JDBC
Universal Driver
Provide client-
side optimization
for Java
Java &
.Net
Programs
Create DB2
packages to
provide static
SQL
**For Java
programs you
can generate
standardized
SQL quickly
DB2 for z/OS
**Static SQL provides:
Reduced Optimizer Processing
Thread Workload Mgt.
Java Pgm. Identification (Helps
in problem identification)
Provide client-side optimization for
JDBC access without changing a
line of existing application code
pureQuery Runtime supports .Net
Programs C# and VB.Net also
Package Security
Accounting Reports (Capacity
Planning)
Only thing installed in DB2 is a
good old SQL package
z/OS Workload
Manager(WLM)
**DB2 Distributed
Packages Proved
Thread Priority Mgt.
RMF Service
Class/Reporting Class
(Capacity Planning)
** Key areas where pureQuery helps
pureQuery and DB2 for z/OS
Why use pureQuery with DB2 for z/OS?
pureQuery can create DB2 packages for Java and .Net programs
A package is an object containing a set of SQL statements that is stored in
the DB2 Catalog
DB2 determines the access plan for the SQL statements in a package
when you perform the bind process, the access path is static and
unchanging until a bind is performed again providing consistent
repeatable performance unlike dynamic SQL which is subject to change
Packages provide improved security to pureQuery, because data access is
granted to the package and not tables
pureQuerys packages provide open systems with mainframe
discipline, similar to CICS/COBOL
pureQuery generates standardized SQL code avoids the use of literals
pureQuery provides predetermined access paths for consistent operation
pureQuery identifies application programs (beans)
pureQuery access security is granted to a package and not to tables

You might also like