ChannelDB2

DB2 for Linux, UNIX, Windows Discussions (128)

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

DB2 Tips n Tricks Part 66 - Regular Restore of 32 BIT DB into 64 BIT Instance not possible

Hi All, How Regular Restore of 32 BIT DB into 64 BIT Instance IS not possible Solution: Use Redirected Restore or specify ON Clause during…

Started by Harishkumar Baburao Pathangay

0 Jul 13, 2015

DB2 Tips n Tricks Part 65 - How Load Utility consumes Huge Transactional Log Space

Hi All, How Load Utility consumes Huge Transactional Log Space Solution: LOAD using valid Data Sets without redundant records Increase LOGS…

Started by Harishkumar Baburao Pathangay

0 Jul 8, 2015

DB2 Tips n Tricks Part 63 - How To Install DB2 using Response File

Hi All, How To Install DB2 using Response File or Silent Installation Solution: db2setup -r response file DB2SETUP Thanks, Happy Learn…

Started by Harishkumar Baburao Pathangay

0 Jun 17, 2015

DB2 Tips n Tricks Part 62 - How Snapshot Monitor displays incorrect Application Code page

Hi All,How Snapshot Monitor displays incorrect Application Code page.Solution:Snapshot Monitor displays technically correct but functionall…

Started by Harishkumar Baburao Pathangay

0 May 19, 2015

DB2 Tips n Tricks Part 61 - How To Restrict Non Unicode clients accessing Unicode Database

Hi All, How To Restrict Non Unicode clients accessing Unicode Database. Solution: Create Connections Table based Event Monitor. Create Stor…

Started by Harishkumar Baburao Pathangay

0 May 16, 2015

DB2 Tips n Tricks Part 60 - How To Export Import Catalog Entries from one Instance to Another

Hi All,How To Export Import Catalog Entries from one Instance to Another.Solution:Use DB2CFEXP for Export and DB2CFIMP for Import of DB2 Di…

Started by Harishkumar Baburao Pathangay

0 Apr 27, 2015

DB2 Tips n Tricks Part 59 - How To Find various Paths used by Database

Hi All, How To Find various Paths used by Database. Solution: Use Admin View SYSIBMADM.DBPATHS union SYSIBMADM.DBCFG DB2 PATHS Thanks,…

Started by Harishkumar Baburao Pathangay

0 Apr 22, 2015

DB2 Tips n Tricks Part 58 - How To Find Indexes used by Query without getting Explain Plan

Hi All, How To Find Indexes used by Query without getting Explain Plan. Solution: Use MON_GET_SECTION_OBJECT Routine No Need of Explain Tab…

Started by Harishkumar Baburao Pathangay

0 Apr 15, 2015

DB2 Tips n Tricks Part 57 - How to Catch specific Error Code using db2pdcfg Utility

Hi All,How to Catch specific Error Code using db2pdcfg UtilitySolution:Use db2pdcfg -catch option and db2cos.sh call out script. DB2PDCFG U…

Started by Harishkumar Baburao Pathangay

0 Apr 7, 2015

DB2 Tips n Tricks Part 56 - How to Force Query to use IXSCAN over a TBSCAN

Hi All, How to Force Query to use IXSCAN over a TBSCAN Solution: Define Optimization Profile with guidelines accordingly. DB2 Optimization…

Started by Harishkumar Baburao Pathangay

0 Jan 23, 2015

RSS

Try BLU Acceleration on Cloud

© 2016   Created by channeldb2.   Powered by

Badges  |  Report an Issue  |  Terms of Service