RUNSTATS utility perform statistics in DB2. Should be perform Weekly or Monthly basis. Following Script helps to gather statistics on all tables excluding XML …
Read More »Syed Naveed Raza
DB2 Online DB backup Script
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 …
Read More »How to extract DB2 audit logs into files
First, delete previous delimiter files which were offloaded from the archive log. This can be regenerated. [crayon-6703ec190009f779078617/] Below command will archive Instance level …
Read More »How To Setup Auditing in DB2
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. …
Read More »DB2 Remote to Client connectivity via port
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 …
Read More »DB2 license activation
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 …
Read More »