ChannelDB2

DB2 in Brazil Discussions (106)

← Back to DB2 in Brazil
Discussions Replies Latest Activity

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 Utility Solution: Use db2pdcfg -catch option and db2cos.sh call out script. DB2PDCF…

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 TBSCANSolution:Define Optimization Profile with guidelines accordingly.DB2 Optimization Prof…

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

DB2 Tips n Tricks Part 50 - How to Monitor Index Reorganization

Hi All,How to Monitor Index ReorganizationSolution:db2pd -db dbname -reorg indexDB2 MONITOR INDEX REORG Thanks,Happy Learning & Sharin…

Started by Harishkumar Baburao Pathangay

0 Nov 28, 2014

DB2 Tips n Tricks Part 49 How to Find Size,Invalid Indexes and Rebuild them Manually

Hi All, How to Find Size,Invalid Indexes and Rebuild them Manually Solution: Use Routine SYSPROC.ADMIN_GET_INDEX_INFO() REORG INDEXES ALL F…

Started by Harishkumar Baburao Pathangay

0 Nov 18, 2014

DB2 Tips n Tricks Part 48 - How to Connect to Database in Single User Only Mode

Hi All, How to Connect to Database in Single User Only Mode Solution: db2 connect to dbname in exclusive mode user/using DB2 Exclusive Co…

Started by Harishkumar Baburao Pathangay

0 Oct 25, 2014

RSS

Try BLU Acceleration on Cloud

© 2015   Created by channeldb2.

Badges  |  Report an Issue  |  Terms of Service