Database administrator’s function is not cakewalk. It is involved many functions starting from creating a database to maintain its objects. DBA has to monitor all of its objects such as Tables, Views, Indexes, Triggers, Stored procedures etc. Any database these are comman.
DBA primary role is access- control. DB2 has many in-built security features and authority controls. These questions really good to know by DBA.
REORG is a useful utility in DB2. While Loading or Unloading, you get different errors. Run this utility to resolve your errors.
DB2 Load utility with example and explained the key phrases. These are really good to have knowledge before you start working on it.
Avoid multiple UNION when you want to write better SQL query. Always better to USE case statement this improves performance. Read more.
The DB2 split string function example really nice and you can use it in your project quickly.
In DB2 giving TIMESTAMP is very common and it is so important data type. I have given some popular points on it.
The best example for Java stored procedure in DB2, also given java class path to write stored procedure and explained how to include it in the DB2 stored procedure standard block. Read more.