DB2-LUW-ACADEMY @db2luwacademy - Tumblr Blog

How To Find Storage and Table space Paths of Database from Backup image only

#DB2 check backup #DB2CKBKP #DB2 backup verification

Video for Obviating a Drop Table Scenario Uploaded. See Restrict on Drop clause in Action

#DB2 Restrict on Drop #DB2 Drop Table Accidentally

How To Restore an accidentally dropped table space....

#DB2 Restore #DB2 Rebuild #DB2 Drop Table space #Rebuild Database Subset of Table spaces

Security Routines for Authorities: VALUES SYSPROC.AUTH_GET_INSTANCE_AUTHID() - Get Instance Owner SYSPROC.AUTH_LIST_AUTHORITIES_FOR_AUTHID() - List Authorities for User/Group/Roles SYSPROC.AUTH_LIST_ROLES_FOR_AUTHID() - List Roles for User/Group/Roles SYSPROC.AUTH_LIST_GROUPS_FOR_AUTHID() - List Group Association for Users Admin Views for Privileges and Object ownerships: SYSIBMADM.AUTHORIZATIONIDS - List of Users/Groups/Roles having access to the Database SYSIBMADM.PRIVILEGES - Detailed Information on Privileges held by Users on Database Objects SYSIBMADM.OBJECTOWNERS - Detailed Information on Ownership of Database Objects

DB2 Tips n Tricks Part 6 - A Simplified Audit Feature - Change History Event Monitor

Tracks Changes to the Database Through New Event Monitor in V10. Track the Following Changes: DB/DBM CFG and Registry Variable Changes Structural Changes on Database - DDL Changes Execution of Utilities - LOAD,RUNSTATS,BACKUP,RESTORE,REORG

#Event Monitor #Simple Audit Feature #Change History #DDL Changes

DB2 Tips n Tricks Part 5 - Table Level Monitoring by MON_GET_TABLE() Function

Monitoring Table Activities : Tables with most Number of Rows Read,Inserted,Updated,Deleted Categorize Read or Write Intensive Tables Number of Table scans indicating Need for Indexes Number of Rows Read per Table Scan Hit Ratio - Physical Reads / Logical Reads at a Table level useful for Buffer pool Tuning Lock Wait Time / Number of Lock Waits - Calculate Average Time an Application waits for acquiring a lock on a table.

#Table Monitoring #Table Hit Ratio #Average Lock Wait Time #Routines

DB2 Tips n Tricks Part 4 - Move or Copy Data without Intermediate Files

Method 1 : Load With Cursor Called as Remote Load Method 2 : DB2MOVE Utility with COPY Action

#LOAD #DB2MOVE #LOAD WITH CURSOR #MOVE WITH COPY

DB2 Tips n Tricks Part 3 - How to Use SET INTEGRITY for Re-Generation of Generated Columns

#SET INTEGRITY #GENERATED COLUMNS

View SYSIBMADM.ADMINTABINFO for finding physical sizes of table,compression dictionary size and re-org recommended alter operations and a lot more....

#ADMINTABINFO TABLE SIZE INDEX SIZE

DB2-Tips n Tricks Part 1 - History, Time taken, Performance for RUNSTATS

#RUNSTATS

Trending Blogs

Recently Viewed Blogs

DB2-LUW-ACADEMY