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.
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.
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.