I am excited to share that IBM released the much awaited Db2 release. In this release, IBM is delivering multiple new features that will help us build new use-cases and exciting new enhancements that could help us bring down the cost of our data management. In this blog we will go through new enhancement in DB2 V11.5.7.0.
Download link : https://www.ibm.com/support/pages/node/6524304
Note: DB2 V11.5.7.0 is currently available only for DB2 On-Premise systems.
I am excited to share that IBM will be releasing the much awaited Db2 release in the end of June 2021. In this release, IBM is delivering multiple new features that will help us build new use-cases and exciting new enhancements that could help us bring down the cost of our data management. To ensure that we have all the information and get an opportunity to ask IBM questions, IBM is organizing a 5-session webinar series open to all, free of cost. Register using below link to learn about DB2 11.5.6 from IBM experts.
While working with count function with huge data set you will get error SQL0802N Arithmetic overflow or other arithmetic exception occurred. SQLSTATE=22003. You might also receive sqlcode -802, sqlstate 22003 error in your application log. You might get confused by seeing error Arithmetic overflow or other arithmetic exception occurred. for count function.
User Data security is one of the critical aspects of database administration. Its DBAs responsibility to ensure data must only be accessed by authorized users and DBAs can control that by restricting access at various level. In some cases you want to completely or partially conceal data depending on who is accessing it, e.g. In Payroll application, manager can view only last 4 digit of employees SSN while a team member cannot see SSN of other employees but can see his/her SSN. If we try to achieve this at application level it will increase application complexity as well as might impact application performance but still your database is vulnerable. If a user gets access to database they can see any employee SSN. Best way to achieve it by Data Masking at database level.
Data breaches might lead to financial loss, reputational damage, operational downtime, legal action, loss of sensitive data. With changing data privacy law and regulations its even critical now to ensure data is adequately protected.
In DB2 LUW database Data Masking can be achieved with the help of Column Mask which was introduced in DB2 10.1 as part of Row and Column Access Control (RCAC) . In this blog we will go through steps to enable data masking in DB2 LUW and few scenarios of data masking.
How to Create Column Mask in DB2 LUW?
Column Mask can be created using CREATE MASK command. To create mask user must have SECADM authority, no other privilege is require like select on table or execute on function.
CREATE MASK <mask name> ON <table name> FOR COLUMN <column name> RETURN <case expression> ENABLE
While working with PuTTY to SSH to Unix/Linux servers you might get error Putty Fatal Error : Couldn't agree a key exchange algorithm. Sometime this error can be specific to some servers while for other servers ssh works perfectly fine. In this blog we will see how to fix this issue.
