How to prepare a Database audit

Question: How do I prepare a database audit? I need to review regularly database security and configurations. Answer: In summary, a database audit is made up of SELECT statements which report database security details. For example, access to a sensitive stored procedure which displays customer financial details or a database configuration which exposes a risk to dropping the database. Part of the skill of preparing a set of SELECT statements for database details is in the preparation Use this list as a guide to structure the database audit 1) Do you understand the applications? 2) Database servers Inventory 3) Inventory... Read more →

Shellshock resources

How can I find out more about Shellshock ? I've used the resources listed to understand the Shellshock vulnerability. Vulnerability Summary for CVE-2014-6271 Bash 'shellshock' scan of the Internet CVE-2014-6271: remote code execution through bash Patch Bash NOW: 'Shellshock' bug blasts OS X, Linux systems wide open Resolution for Bash Code Injection Vulnerability via Specially Crafted Environment Variables (CVE-2014-6271, CVE-2014-7169) in Red Hat Enterprise Linux Read more →

How to check reclaimable space enabled on DB2 tablespace with MON_GET_TABLESPACE

Question: How can I check if a DB2 database tablespace has reclaimable space enabled? A REORG completed and I need to reclaim the space Answer: You can find metrics about DB2 tablespaces using the MON_GET_TABLESPACE table function . Use the reclaimable_space_enabled column . It returns an smallint . If the value returned is 1 – reclaimable space is enabled. If 0 is returned , reclaimables space is not enabled. select substr(TBSP_NAME,1,14),reclaimable_space_enabled from table (MON_GET_TABLESPACE(NULL,-1)) WHERE TBSP_NAME NOT LIKE ('SYS%') Read More on DB2 reorg options Reorg table DB2 DB2 table reorg and table truncate DB2 Used Space and REORG Read more →

Best of DBA-DB2 com

If you are new to DBA-DB2.com, you can read our most popular posts. Also search our archives by using the search box . Most Popular posts on DBA-DB2.com in the last year DB2 list schemas of a database - DBA DB2 DB2 – DBA Scripts Reorg table DB2 - DBA DB2 Database size in DB2 - DBA DB2 DBA Interview Question and Answers for DB2 - DBA DB2 DB2 SET CURRENT SCHEMA - DBA DB2 How to grant select privileges on all tables for DB2 - DBA DB2 DB2 SQL2413N - Online backup is not allowed - DBA DB2 How... Read more →

How to generate db2support files

Question: I’m troubleshooting a DB2 server performance issue. How can I gather some general DB2 server and process information and send to a DB2 professional for problem resolution. Answer: One method is to use the db2support command. This example generates a files connecting to a database. I've added some extra options to consider db2support . -d my_db_name -c -g -s –f -c connect to database -g run on global hosts -s system detail -h 10h -m dump output into html files Read More on getting DB2 support How to report a DB2 performance problem Read more →