ChannelDB2

DB2 for Linux, UNIX, Windows Discussions (141)

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

DB2 Tips n Tricks Part 88 - How To Find if a Change in DB2 Registry Variable is Effective Immediately

Hi All, How To Find if a Change in DB2 Registry Variable is Effective Immediately Use: db2set -info variablename DB2SET   Thanks, Happy L…

Started by Harishkumar Baburao Pathangay

0 May 28, 2016

DB2 Tips n Tricks Part 87 - How To Map Table File Object Id with Table Name in SMS Table Space

Hi All, How To Map Table File Object Id with Table Name in SMS Table Space Use: TABLEID Column in SYSCAT.TABLES TAB_FILE_ID Column in MON…

Started by Harishkumar Baburao Pathangay

0 Apr 8, 2016

DB2 Tips n Tricks Part 86 - How To Export Table Data to Tab Delimited File

Hi All,   How To Export Table Data to Tab Delimited File Use Export Command with File Type Modifier COLDEL   DB2 EXPORT   Thanks, H…

Started by Harishkumar Baburao Pathangay

0 Mar 25, 2016

DB2 Tips n Tricks Part 85 - How Archive Log Start End Time in List History Output is counter intuitive

Hi All,   How Archive Log Start End Time in List History Output is counter intuitive How To Find How Long a Transaction Log File is in Ac…

Started by Harishkumar Baburao Pathangay

0 Mar 18, 2016

DB2 Tips n Tricks Part 84 - How DB2 is not logging Start Time for Archival of Transaction Log Files

Hi All,   How DB2 is not logging Start Time for Archival of Transaction Log Files DB2 Archival Logging   Thanks, Happy Learning & S…

Started by Harishkumar Baburao Pathangay

0 Mar 13, 2016

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, 2016

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, 2016

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

2 Feb 15, 2016
Reply by Harishkumar Baburao Pathangay

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, 2016

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, 2016

RSS

Try BLU Acceleration on Cloud

© 2017   Created by channeldb2.   Powered by

Badges  |  Report an Issue  |  Terms of Service