RUNSTATS utility perform statistics in DB2. Should be perform Weekly or Monthly basis. Following Script helps to gather statistics on all tables excluding XML …

Following script is useful when you have multiple databases on single instance. When you need to provide your operation team to take backup of DB1 …

  First, delete previous delimiter files which were offloaded from the archive log. This can be regenerated. [crayon-673f29d5231a0489442061/]   Below command will archive Instance level …

First, check audit parameter in DB2 LUW; as you can see “audit active” is FALSE, which shows that currently auditing is not enabled on your instance. …

  Setting communication protocols for a DB2 instance is part of the main task of configuring TCP/IP or SSL communications for a DB2 instance. Set …

How to activate DB2 License, If you purchased a DB2 V10.5, V10.1, V9.8, V9.7, V9.5, V9.1 product then you can obtain license key from Passport …