DB2-LUW-ACADEMY

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

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

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

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

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

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.

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

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

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

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