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.
Reorganisation in DB2 is many times a usable utility. When you want to do loading or unloading there you may face many different errors. So this is one of the main solution to reorganise the table space.
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.