Mostly asked certification questions in DB2. You need more focus on these areas before you take the test.
DB2 Certification focus more on these questions now
Continue reading
Advertisements
Tag: DB2 Tips and Solutions
DB2 program preparation these you need to know
You need these tips handy when embedding DB2 database in application program like COBOL or PL/I
Three magic points you need to know on Delete SQL query
You need to know these SQL query and rules to delete a row from a Table in DB2 database
Fetch first 1 Row only real usage in DB2
In DB2 database there are many ways to achieve performance. I explained one way here. Read more.
DB2 logical storage theory to define when creating table
Table spaces are completely logical in any database. Many developers confused that they always access data from physical storage. But actually that is not correct. So this post clarifies how to define a table with logical storage. Sample SQL really helps you to understand quickly.
Top DB2 authority questions DBA to know
DBA primary role is access- control. DB2 has many in-built security features and authority controls. These questions really good to know by DBA.
REORGCHK utility top role in DB2 maintenance
REORG is a useful utility in DB2. While Loading or Unloading, you get different errors. Run this utility to resolve your errors.
SQL Query with CASE logic avoid UNION why
Avoid multiple UNION when you want to write better SQL query. Always better to USE case statement this improves performance. Read more.
