ChannelDB2

DB2 for Linux, UNIX, Windows Discussions (153)

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

DB2 Tips n Tricks Part 90 - How Classic Table Reorganization using Temporary Tablespace cannot be stopped

Hi All, How Classic Table Reorganization using Temporary Tablespace cannot be stopped. DB2 CLASSIC REORG Thanks, Happy Learning &…

Started by Harishkumar Baburao Pathangay

1 Jul 5, 2016
Reply by Luis Reina

DB2 Tips n Tricks Part 89 - How DB2 User Level Registry Works

Hi All, How DB2 User Level Registry Works. DB2 User signifies Instance Owner and not Database User. DB2 User Level Registry Thanks, Hap…

Started by Harishkumar Baburao Pathangay

0 May 29, 2016

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

RSS

Try BLU Acceleration on Cloud

© 2017   Created by channeldb2.   Powered by

Badges  |  Report an Issue  |  Terms of Service