ChannelDB2

DB2 in Brazil Discussions (82)

← Back to DB2 in Brazil
Discussions Replies Latest Activity

How to Remotely Start Stop DB2 Instance from Client Machine

Hi All, Video Tutorial-How to Remotely Start Stop DB2 Instance from Client Machine.Solution:db2 stop dbm remote bjp hostname 192.168.137.1…

Started by Harishkumar Baburao Pathangay

0 Jun 13

How to set custom,user friendly Client Application Name for Client Connection

Hi All, Video Tutorial-How to set custom,user friendly Client Application Name for Client Connection.Solution:set Client Application Name P…

Started by Harishkumar Baburao Pathangay

0 Jun 8

Video Tutorial-How to Configure Port Number for DB2 Instance

Hi All, Video Tutorial-How to Configure Port Number for DB2 Instance.Solution:db2set DB2COMM=TCPIPdb2 update dbm cfg using svcename db2inst…

Started by Harishkumar Baburao Pathangay

0 May 20

Video Tutorial-How to Find Which Application is consuming most transaction log space

Hi All, Video Tutorial-How to Find Which Application is consuming most transaction log space. Solution: db2pd -db dbname -transactions db2…

Started by Harishkumar Baburao Pathangay

0 Apr 20

How to Find Which DB2 Thread is consuming High CPU

Hi All, Video Tutorial-How to Find Which DB2 Thread is consuming High CPU.Solution:db2pd -edusTop -Hp db2syscpidPs -Lp db2syscpid -o pid,pp…

Started by Harishkumar Baburao Pathangay

0 Feb 7

How to Persist Locks even after transaction commits

Hi All, Video Tutorial-How to Persist Locks even after transaction commits.Solution:db2set DB2_KEEPTABLELOCK=CONNECTION DB2_KEEPTABLELOCK-T…

Started by Harishkumar Baburao Pathangay

0 Feb 3

How to Avoid Non Logged Operations in a Database

Hi All, Video Tutorial-How to Avoid Non Logged Operations in a Database.Solution:DB CFG Parameter BLOCKNONLOGGED YES BLOCKNONLOGGED-Tutoria…

Started by Harishkumar Baburao Pathangay

0 Jan 31

How to Start DB2 instance in QUIESCE mode for Maintenance Operations

Hi All, Video Tutorial-How to Start DB2 instance in QUIESCE mode for Maintenance Operations.Solution:db2 start dbm ADMIN MODEdb2start ADMIN…

Started by Harishkumar Baburao Pathangay

0 Jan 23

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

RSS

Try BLU Acceleration on Cloud

© 2014   Created by channeldb2.

Badges  |  Report an Issue  |  Terms of Service