ChannelDB2

DB2 for Linux, UNIX, Windows Discussions (79)

← Back to DB2 for Linux, UNIX, Windows
Discussions Replies Latest Activity

How to Restrict Access to Instance or Database during Maintenance Operations

Hi All, Video Tutorial-How to Restrict Access to Instance or Database during Maintenance Operations.Solution:QUIESCE the INSTANCE with REST…

Started by Harishkumar Baburao Pathangay

0 Jan 22

How to Find unused tables,indexes,Stored Procedures in the Database

Hi All, Video Tutorial-How to Find unused tables,indexes,Stored Procedures in the Database.Find out when it was last accessed? Solution:LAS…

Started by Harishkumar Baburao Pathangay

0 Jan 20

How to Find which Application is consuming most Statistics or Statement Heap

Hi All, Video Tutorial Demonstrating How to Find which Application is consuming most Statistics or Statement Heap.Solution:db2mtrk -a -vMON…

Started by Harishkumar Baburao Pathangay

0 Jan 16

How to Find which Application is consuming most System Temp Table Space

Hi All, Video Tutorial Demonstrating How to Find which Application is consuming most System Temp Table Space.Solution:db2pd -db dbname -tcb…

Started by Harishkumar Baburao Pathangay

0 Jan 9

How to Exclusively lock set of Rows using select query

Hi All, Video Tutorial Demonstrating How to Exclusively lock a set of Rows using select query.Solution:Use LOCK REQUEST Clause in Select Qu…

Started by Harishkumar Baburao Pathangay

0 Dec 31, 2013

Override Current Committed Semantics,DB2_SKIPINSERTED,SKIPDELETED,EVALUNCOMMITTED for a specific select query

Hi All,Video Tutorial Demonstrating How to Override Current Committed Semantics,DB2_SKIPINSERTED,DB2_SKIPDELETED,DB2_EVALUNCOMMITTED for a…

Started by Harishkumar Baburao Pathangay

0 Dec 24, 2013

How to Avoid Transaction Rollback after Lock Timeout

Hi All,Video Tutorial Demonstrating How to Avoid Transaction Rollback after Lock Timeout.Set Registry Variable:db2set DB2LOCK_TO_RB = STATE…

Started by Harishkumar Baburao Pathangay

0 Dec 14, 2013

How to Find and Fix Invalid DB Objects

Hi All,Video Tutorial Demonstrating How to Find and Fix Invalid DB Objects.Admin View : SYSCAT.INVALIDOBJECTS : For Finding Invalid DB Obje…

Started by Harishkumar Baburao Pathangay

0 Dec 9, 2013

How to Find Routine Name from Package Name

Hi All,Video Tutorial Demonstrating How to Find Routine Name from Package Name.Types of Routines - UDF or Stored ProcedureUse Admin View :…

Started by Harishkumar Baburao Pathangay

0 Dec 7, 2013

How to Enable user for multiple Authorization Ids

Hi All, Video Tutorial Demonstrating How to Enable user for multiple Authorization Ids. GRANT setsessionuser Privilege by SECADM User can s…

Started by Harishkumar Baburao Pathangay

0 Dec 2, 2013

RSS

Try BLU Acceleration on Cloud

© 2014   Created by channeldb2.

Badges  |  Report an Issue  |  Terms of Service