DBA primary role is access- control. DB2 has many in-built security features and authority controls. These questions really good to know by DBA.
Tag: DB2 Tips and Solutions
REORG is a useful utility in DB2. While Loading or Unloading, you get different errors. Run this utility to resolve your errors.
How to choose either UNION or CASE in the SQL query is best explained.
In DB2 giving TIMESTAMP is very common and it is so important data type. I have given some popular points on it.
How Db2audit plays crucial role in DB2 and what is the use of it. Really good stuff. Read more.
The 3 options in DB2 12 are going to be replaced by new functions. Read for more details.
The RPN Table space in DB2. What is new in it. How DB2 is handling big data. Read more.
The very simple way you can do DATE and TIME calculations in DB2. You can use these examples in your SQL instantly. Also, you can get DATE and TIME from your Timestamp. Read more.
In DB2 Date , time and timestamp are three different columns in a table. So this post gives the best idea on how to choose these columns in Table to suit project requirements as well as better performance.
Working principle of Stored procedures in DB2 explained in a way that any developer can understand quickly
The best syntax for EXPLAIN PLAN -EXPLAIN——————————————————> >–+-+-PLAN-+–+———————+–FOR–explainable-sql-statement-+->< | ‘-ALL–‘ ‘-SET QUERYNO=integer-‘ | +-STMTCACHE–+-ALL——————————–+—————–+ |…
Below are the best techniques either ways you can use. As your wish if you…
You must be logged in to post a comment.