ChannelDB2

DB2 for Linux, UNIX, Windows Discussions (128)

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

DB2 Tips n Tricks Part 75 - How To Reorganize Index without using REORG Command

Hi All, How To Reorganize Index without using REORG Command Solution: Set MINPCTUSED attribute during Index Creation Truly - Online Ind…

Started by Harishkumar Baburao Pathangay

0 Nov 15, 2015

DB2 Tips n Tricks Part 74 - How To Talk with DB2 in your Language

Hi All, How To Talk with DB2 in your Language Solution: LANG='pt_BR.utf8' export LANG DB2CLP Thanks, Happy Learning & Sharing htt…

Started by Harishkumar Baburao Pathangay

0 Nov 2, 2015

DB2 Tips n Tricks Part 73 - How to Find if STMM is Active or Idle

Hi All, How to Find if STMM is Active or Idle Solution: db2 get db cfg show detail SYSIBMADM.DBCFG Instance_Home/sqllib/db2dump/stmmlog/stm…

Started by Harishkumar Baburao Pathangay

0 Oct 7, 2015

DB2 Tips n Tricks Part 72 - How db2 get instance displays incorrect instance

Hi All, How db2 get instance displays incorrect instance How to Switch between multiple instances Solution: Execute /home/db2inst1/sqllib/d…

Started by Harishkumar Baburao Pathangay

0 Sep 17, 2015

DB2 Tips n Tricks Part 71 - How To Change Fenced User Id after Instance Creation

Hi All, How To Change Fenced User Id after Instance Creation Solution: db2iupdt -u userid instname DB2 FENCED USER Thanks, Happy Learn…

Started by Harishkumar Baburao Pathangay

0 Aug 30, 2015

DB2 Tips n Tricks Part 70 - How To Clone or Copy a Database ASAP

Hi All, How To Clone or Copy a Database as soon as possible Solution: Restore from local named pipe Backup to local named pipe DB2 BACKUP R…

Started by Harishkumar Baburao Pathangay

0 Aug 24, 2015

DB2 Tips n Tricks Part 69 - How To Find Index Rebuild is Slowing Query Execution

Hi All, How To Find Index Rebuild is Slowing Query Execution Solution: Use MON_GET_AGENT Routine along with SYSIBMADM.MON_CURRENT_SQL DB2…

Started by Harishkumar Baburao Pathangay

0 Aug 15, 2015

DB2 Tips n Tricks Part 68 - How To Disable Health Monitor or db2acd process completely

Hi All, How To Disable Health Monitor or db2acd process completely. Solution: Use db2set DB2_FMP_COMM_HEAPSZ=0 DB2ACD DISABLE Thanks,…

Started by Harishkumar Baburao Pathangay

0 Aug 8, 2015

DB2 Tips n Tricks Part 67 - How to change from BACKUP PENDING to NORMAL State asap

Hi All, How to change from BACKUP PENDING to NORMAL State asap Solution: Use Backup dbname online to /dev/null DB2 BACKUP TO NULL DEVICE…

Started by Harishkumar Baburao Pathangay

0 Jul 24, 2015

DB2 Tips n Tricks Part 64 - How To Restrict Load Utility during Online Database Backup

Hi All, How To Restrict Load Utility during Online Database Backup Solution: Define Work Class for Work Type - LOAD Define Work Action "Pre…

Started by Harishkumar Baburao Pathangay

1 Jul 21, 2015
Reply by Luis Reina

RSS

Try BLU Acceleration on Cloud

© 2016   Created by channeldb2.   Powered by

Badges  |  Report an Issue  |  Terms of Service