February 2010 Blog Posts (8)

Porting LIMIT and OFFSET SELECT clauses to DB2

Opensource databases such as MySQL and PostgreSQL supports non standard SELECT extension for limiting number of returned rows from query. You can see description in PostgreSQL manual. Look for keywords LIMIT and OFFSET. LIMIT specifies the maximum number of rows to return, while OFFSET specifies the number of rows to skip before starting to return…


Added by Radim Kolar on February 28, 2010 at 11:30am — 2 Comments

Distributing Data to a Large Number of DB2 Servers

Once you get past the simple case of copying changed data from one system to another, the next most common replication solution is data distribution. In this scenario, you distribute data from a central database to two or more databases, maybe even 100's, that are likely remote. An example is sending changes from a corporate headquarters to branch offices or retail locations. You may only need the data to flow one way - from a central database to others. Or, you may also need some data to…


Added by david t on February 15, 2010 at 4:00pm — No Comments

Client Optimization vs. pureQuery API

You may have heard about several different capabilites available with pureQuery such as Client Optimization, Annotated Method and In-Line. Some questions that I have had about these options would include what is the difference between these methods and where do I use each? I wanted to just quickly write a few paragraphs to answer these two primary questions.

In answer to the first question, both Annotated Method and In-Line are part of the pureQuery API. Annotated Method uses…


Added by Dan Galvin on February 10, 2010 at 4:18pm — 1 Comment

A Fast Way to Get Started with Cache Tables (Distributed Caching)

I often get asked if it's easy to set up IBM cache tables and whether they can be set up with scripts instead of a GUI  The answer I give is yes to both questions.  Cache tables, a form of distributed caching, are very easy to set up and you can do it with scripts. The challenges are that (1) IBM's documentation could be better and (2) a good sample is needed. I'm hoping a few pictures, a little text, and a small sample are all that's needed to improve the situation…


Added by david t on February 5, 2010 at 9:00pm — No Comments


HAve anyone give Db2 9 certication,
Please can you give me dumps of same and some reference amterials for the same

Added by vandana on February 4, 2010 at 12:52am — No Comments

IBM P series shutdown process for DB2,Datastage,Essbase and hyperion application in IBM DS4300 storage

IBM Pseris shutdown process

I was working as DB2 DBA ,Unix admin for the DWH project in my previous company. Some of the real time experience and problems which I faced in this project and how I came up with the solution.

Let me explain

We had IBM Pseries 570 with DS3400 storage


1. DB2 Server -- ---AIX 5.3

2. ESSBase Server-- ---AIX 5.3

3. ETL Server-- ---AIX5.2

4. Analyzer (hyperion)--… Continue

Added by Lohith on February 3, 2010 at 5:52am — No Comments

DB2 DBA Administration


I am lohith working on DB2 DBA administration from past 5 yr.

Let me explain the DB2 DBA real time experience and the problem faced by me and the solution for the problem.

General DB2 DBA responsibility.

•Creating primary database storage structures (table spaces) once developers have designed an application.

•Modifying the database structure, as necessary, from information given by application developers.

•Manage Backup, Security, and Controls… Continue

Added by Lohith on February 2, 2010 at 8:00am — 3 Comments

Datawarehouse project working with DB2,Datastage 7.5,IBM AIX and crystal report


I am working on this data warehouse project from past 4.5 yr. starting from initial hardware invoice process to aix OS installation and mount point creation, DB2 installation, datastage installation, datastage configuration for Oracle, SQL and DB2 database and finally crystal report generation.

Let me explain how the DWH(Datawarehosue) process works.

General work flow.

S1(oracle)---------------------ETL(Datastage)---DWH(DB2 database)--Crystal report… Continue

Added by Lohith on February 1, 2010 at 8:00am — 1 Comment

Monthly Archives













Featured Downloads

Try BLU Acceleration on Cloud

© 2020   Created by channeldb2.   Powered by

Badges  |  Report an Issue  |  Terms of Service