ChannelDB2

Ramya's Blog (5)

Oracle Toplink Setup in DB2

Oracle Toplink:-

Oracle TopLink supports access to any data store accessible through standard JDBC using standard SQL.

Additionally TopLink offers database platforms that allow for specific functionality to be exposed such as

native SQL, sequencing, out-join syntax, custom date/timestamp operators and formats, and schema import

and generation with the mapping editors.



To setup Oracle Toplink please follow the below steps :-



1.We need to identify the…

Continue

Added by Ramya on September 18, 2014 at 5:41am — No Comments

How to create Federated Procedures in DB2 10.5

This post is useful for DB2 developers, administrators, database architects to learn how to access Oracle database

stored procedures from DB2 database sources.

A federated system is a special type of distributed database management system (DBMS).

A federated system consists of a DB2® database system that operates as a federated server, a database that acts

as the federated database, one or more data sources, and clients (users and applications) that access the…

Continue

Added by Ramya on June 24, 2014 at 4:01am — No Comments

Improving DB2 Database Performance - Part I 7 Things to remember while range partitioning

One of the techniques to improve database performance and achieve greater scalability is using table partitioning. According to live industry observations  when you see the following symptoms you should consider table partitioning

Slow queries that return small amounts or no data

Slow queries that return large amounts of data

Blocking between readers and writers (inserts or updates)

As tables grow in size, it may be easier to manage your…

Continue

Added by Ramya on May 1, 2014 at 6:00am — No Comments

DB2 Expression Based Indexes

With expression-based indexes, you can create an index that includes expressions. The performance of queries that  involves expressions is improved if the database manager chooses an index that is created on the same expressions. Expression-based indexes are best suited when you want an efficient evaluation of queries that involve a column expression. Simple index keys consist of a concatenation of one or more specified…

Continue

Added by Ramya on March 6, 2014 at 12:56pm — No Comments

How to create DB2 with BLU Acceleration database to speed your analytics applications

DB2 with BLU Acceleration speeds analytics and reporting using dynamic in-memory columnar technologies. In-memory columnar technologies provide an extremely efficient way to scan and find relevant data. Coupled with innovations such as parallel vector processing and actionable compression, it makes your analytic queries far faster and less complex. So you can connect with the information you need at breakthrough speed and…

Continue

Added by Ramya on March 6, 2014 at 12:54pm — No Comments

Featured Downloads

Try BLU Acceleration on Cloud

© 2019   Created by channeldb2.   Powered by

Badges  |  Report an Issue  |  Terms of Service