ChannelDB2

DB2 IN INDIA Discussions (58)

← Back to DB2 IN INDIA
Discussions Replies Latest Activity

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

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

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

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

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

DB2 Tips n Tricks Part 55 - How Table Size increased after Table Reorganization

Hi All, How Table Size increased after Table Reorganization Solution: Check for PCTFREE Table Attribute; If set to 50 then after table reor…

Started by Harishkumar Baburao Pathangay

0 Jan 16

DB2 Tips n Tricks Part 54 - How To Force Off Idle Applications Automatically

Hi All, How To Force Off Idle Applications Automatically Solution: Use Threshold Object - Connection Idle Time Predicate DB2 Connection I…

Started by Harishkumar Baburao Pathangay

0 Dec 24, 2014

DB2 Tips n Tricks Part 53 - How To Find Application Idle Time

Hi All, How To Find Application Idle Time Solution: Use Application Snapshot - Application Idle Time Monitor Element Use Routine MON_GET_C…

Started by Harishkumar Baburao Pathangay

0 Dec 14, 2014

DB2 Tips n Tricks Part 52 - How to Find If Backup Image is consuming RAM

Hi All, How to Find If Backup Image is consuming RAM Solution: By Pass File System Caching by DB2SET DB2_BACKUP_USE_DIO=ON DB2 BACKUP DIO…

Started by Harishkumar Baburao Pathangay

0 Dec 7, 2014

DB2 Tips n Tricks Part 51 - How To List all Database Objects in a Schema

Hi All, How To List all Database Objects in a Schema Solution: Use SYSIBMADM.OBJECTOWNERS Admin View or db2look -d dbname -e -z schema-nam…

Started by Harishkumar Baburao Pathangay

0 Dec 3, 2014

RSS

Try BLU Acceleration on Cloud

© 2015   Created by channeldb2.

Badges  |  Report an Issue  |  Terms of Service