ChannelDB2

DB2 for Linux, UNIX, Windows Discussions (123)

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

DB2 Tips n Tricks Part 80 - How DB2PD reports incorrect dirty pages in buffer pool

Hi All,   How DB2PD reports incorrect dirty pages in buffer pool Solution: Use db2pd -db dbname -dirtypages summary   DB2PD Dirty Pages…

Started by Harishkumar Baburao Pathangay

0 Jan 30

DB2 Tips n Tricks Part 79 - How To Find Application Execution or Idle Time

Hi All, How To Find Application Execution or Idle Time Solution: Use Routine MON_GET_AGENT DB2 Agent State Time Thanks, Happy Learnin…

Started by Harishkumar Baburao Pathangay

0 Jan 6

DB2 Tips n Tricks Part 78 - How Classic Offline Reorganization consumes more Transactional Log Space

Hi All, How Classic Offline Reorganization consumes more Transactional Log Space Solution: Provide Additional Transactional Log Space fo…

Started by Harishkumar Baburao Pathangay

0 Dec 27, 2015

DB2 Tips n Tricks Part 77 - How Table Data and Indexes are not allowed in separate SMS Tablespaces

Hi All, How Table Data and Indexes are not allowed in separate SMS Tablespaces Solution: Use DMS or Automatic Storage Tablespaces SMS T…

Started by Harishkumar Baburao Pathangay

0 Dec 24, 2015

DB2 Tips n Tricks Part 76 - How DMS Temporary Tablespace reduces concurrency of Reorganization

Hi All, How DMS Temporary Tablespace reduces concurrency of Reorganization Solution: Use SMS Temporary Tablespace for Reorganization Do not…

Started by Harishkumar Baburao Pathangay

0 Dec 17, 2015

DB2 Tips n Tricks Part 75 - How To Reorganize Index without using REORG Command

Hi All, How To Reorganize Index without using REORG Command Solution: Set MINPCTUSED attribute during Index Creation Truly - Online Ind…

Started by Harishkumar Baburao Pathangay

0 Nov 15, 2015

DB2 Tips n Tricks Part 74 - How To Talk with DB2 in your Language

Hi All, How To Talk with DB2 in your Language Solution: LANG='pt_BR.utf8' export LANG DB2CLP Thanks, Happy Learning & Sharing htt…

Started by Harishkumar Baburao Pathangay

0 Nov 2, 2015

DB2 Tips n Tricks Part 73 - How to Find if STMM is Active or Idle

Hi All, How to Find if STMM is Active or Idle Solution: db2 get db cfg show detail SYSIBMADM.DBCFG Instance_Home/sqllib/db2dump/stmmlog/stm…

Started by Harishkumar Baburao Pathangay

0 Oct 7, 2015

DB2 Tips n Tricks Part 72 - How db2 get instance displays incorrect instance

Hi All, How db2 get instance displays incorrect instance How to Switch between multiple instances Solution: Execute /home/db2inst1/sqllib/d…

Started by Harishkumar Baburao Pathangay

0 Sep 17, 2015

DB2 Tips n Tricks Part 71 - How To Change Fenced User Id after Instance Creation

Hi All, How To Change Fenced User Id after Instance Creation Solution: db2iupdt -u userid instname DB2 FENCED USER Thanks, Happy Learn…

Started by Harishkumar Baburao Pathangay

0 Aug 30, 2015

RSS

Try BLU Acceleration on Cloud

© 2016   Created by channeldb2.   Powered by

Badges  |  Report an Issue  |  Terms of Service