#db2 tips

DB2 Five key areas to improve Performance

In DB2 performance management is the main role of Senior software developers. The real complex point is where you need to focus. I have given here key ares to improve performance.

Performance reduces CPU used and then your application running cost you can reduce.

 Right Access Path…

Here, how to find right access path.

Access path determined by during bind time

Access path at execution time

Stati…

Real logic you need to connect DB2 using PHP engine

You connect DB2 database using any high level language like Java, C#, PHP. So, my post here is how to connect DB2 in PHP engine.

You already familiar that in my earlier article, I have mentioned that there are 2 kinds of  stored procedures or functions

Internal functions/Stored procedures

External stored procedures/functions

In both the cases, when you are trying to access DB2 server, to run your…

Top DB2 privileges really useful for certification seekers

The privilege in DB2 useful to know how DB2 protecting your data. This question asked many times in certification exams.

The privileges under different groups have different meaning. Only SYSADM group has control and can access data

SYSADM Group: The SYSADM authority provides a nominated user with total control over all the resources and data controlled by the associated instance.

This is highest…

DB2 UDF sample function read now with awesome interview question

You are aware that all DB2 functions and stored procedures stored in Database server, and whenever you invoke them they will be triggered. I want to share with you that UDFs you can write using any language SQL, C or COBOL.

I have explained with sample function.

UDF: Function is basically something repeatedly you  are using in your SQL query. Then, you can call your function in main SQL query to…

Real idea Left outer JOIN you always need to code in DB2 read now

The story of JOINS in SQL is to get data from many tables. Actually in DB2 there are both LEFT and RIGHT outer JOINS present.

There is no difference between a left outer join and right outer join other than where the starting driver is coded

LEFT JOIN

SELECT D.DEPTNO, D.DEPTNAME, D.MGRNO, E.LASTNAME FROM DEPT D LEFT JOIN EMP E ON D.MGRNO = E.EMPNO

Right JOIN

SELECT D.DEPTNO, D.DEPTNAME,…

Alias an optional column name three top rules you need to know

Alias is called associate name to actual column name. The alias also called user defined column name. The advantage is you can hide original column name.

SELECT CUSTOMER_NAME as CNAME, CUSTOMER_ID as "CUST ID" , PRODUCT_ID as "AVG" FROM PRODUCT_TABLE WHERE PRODUCT_ID = '120'

Notes: The “CUST ID” has space and “AVG” is reserved word

3 Top rules to give alias

‘AS’ is optional-but if you miss…

4 top DB2 host variable points you need to know before write program

Host variable declaration is one of the main step in developing application program using DB2. You add Host variables in application program why because, the data from database to be received by language which you are using , example COBOL or PLI. In simple terms Host variable is related to host language not related to SQL.

Host variables

A host variable is a data item that you declare in a…

5 top DB2 sections surely you need to touch before interview

Below is the top summary of which DB2 sections you need to touch before your interview. The best method is reading questions and answers using mobile phone. The selected area here really good to revise your knowledge.

Tuning DB2

Use of buffer pools

Use of TableSpaces

Tuning of SQL queries

DB2 Optimizer

DB2 Architecture

Plan, Bind, Packages and Collections

Storage areas or groups

Utilities

Load…