What is DB2audit how it is so important

db2audit is a facility already present on DB2. It is a component that generates ogging for some security events on the database, for example authorization checking, security administration, users validation, changes in database objects.

It is an interesting way to investigate security questions in the database. db2audit basic commands.

There are some basic commands when using the db2audit.

db2audit start -> to start db2audit 
db2audit stop -> to stop db2audit 
db2audit describe -> to check status of db2audit (if it's running)
DB2 Basics for beginners
DB2 Basics for beginners

How Db2audit looks like

db2inst1@olimpio:/db/db2inst1/db2backup/home> db2audit describe DB2 AUDIT SETTINGS: Audit active: "TRUE " ---------> db2audit is running! 
Log audit events: "FAILURE" 
Log checking events: "FAILURE" 
Log object maintenance events: "FAILURE"
Log security maintenance events: "FAILURE" 
Log system administrator events: "FAILURE" 
Log validate events: "FAILURE" 
Log context events: "NONE" Return SQLCA on audit error: "FALSE " Audit Data Path: "" Audit Archive Path: "" AUD0000I Operation succeeded. 

db2inst1@olimpio:/db/db2inst1/db2backup/home> db2audit describe DB2 AUDIT SETTINGS: Audit active: "FALSE " ---------> db2audit is NOT running! 
Log audit events: "FAILURE" 
Log checking events: "FAILURE" 
Log object maintenance events: "FAILURE" 
Log security maintenance events: "FAILURE" 
Log system administrator events: "FAILURE" 
Log validate events: "FAILURE" 
Log context events: "NONE" Return SQLCA on audit error: "FALSE " Audit Data Path: "" Audit Archive Path: "" AUD0000I Operation succeeded.

Why DB2 12 adds RPN Table space best example

DB2 12
DB2 RPN Table space

Why RPN table spaces instead of the already-existing table spaces types in DB2?

The simple answer is the ability to grow the amount of data you store. RPN table spaces enable you to store large amounts of data. The DSSIZE can grow up to 1 TB for a partition. And the maximum table size increases to 4 PB with up to 256 trillion rows per table. That is a lot of data that can be stored! Think about it this way: if you were to insert 1000 rows per second it would take more than 8000 years to fill the table to capacity!

With RPN table spaces you get the ability to create larger partition sizes. The maximum partition size is now 1 TB (it used to be 256 GB). So if you are reaching the capacity size of existing table space options, RPN table spaces will allow you to store a LOT more data. Of course, this requires an expanded RID, which increases from 5 bytes to 7 bytes. So that will impact the DDL for the mapping table for your online REORG utilities.

You can find more information on DB2 RPN Table space online here.