In DB2 database there are many ways to achieve performance. I explained one way here. Read more.
Index is popular object in DB2 SQL. Popular questions to your instant knowledge given for quick reference.
All you need to know about Cursor the real use and how it works on commit or Rollback scenarios. Really useful information for SQL professionals.
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.