ChannelDB2

DB2 IN INDIA Discussions (69)

← Back to DB2 IN INDIA
Discussions Replies Latest Activity

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 yesterday

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

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

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

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

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

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

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

0 Jul 1

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

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

RSS

Try BLU Acceleration on Cloud

© 2015   Created by channeldb2.

Badges  |  Report an Issue  |  Terms of Service