ChannelDB2

DB2 in Brazil Discussions (132)

← Back to DB2 in Brazil
Discussions Replies Latest Activity

DB2 Tips n Tricks Part 83 - How MON_GET_DATABASE Routine reports incorrect db activation state

Hi All,   How MON_GET_DATABASE Routine reports incorrect db activation state Solution: Watch DB2 Tips n Tricks Part 40   DB2 DB_ACTIVAT…

Started by Harishkumar Baburao Pathangay

0 Mar 3

DB2 Tips n Tricks Part 82 - How To Find Recent Reorganization date-time of a Table

Hi All,   How To Find Recent Reorganization date-time of a Table Solution: Use List History Reorg All For dbname Use SYSIBMADM.DB_HISTO…

Started by Harishkumar Baburao Pathangay

0 Feb 24

DB2 Tips n Tricks Part 81 - How To Flush Static Packages from Package Cache Memory

Hi All,   How To Flush Static Packages from Package Cache Memory Solution: Use SYSPROC.ADMIN_REVALIDATE_DB_OBJECTS Stored Procedure   D…

Started by Harishkumar Baburao Pathangay

0 Feb 15

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

RSS

Try BLU Acceleration on Cloud

© 2016   Created by channeldb2.   Powered by

Badges  |  Report an Issue  |  Terms of Service