In the previous post we discussed how it is possible to extract your Integer values from IBM’s new Db2 table as of Db2 for …
Read More »
DB2
About SQL Server and Comparison with Other Relational Database Management Systems
SQL Server is a relational database management system (RDBMS) that Microsoft has provided to us. You can find a lot of articles about SQL Server …
Read More »DB2-Database Monitoring-2
Hello Everyone , I am back with next part of Database monitoring . You should read the first article of this series. “DB2-Database Monitoring-1” …
Read More »Script To Gather Statistics On Table and Indexes On DB2
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 »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-604719b30fb52172832988/] 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 »The SYSIBM.SYSSTATFEEDBACK table introduced in Db2 for z/OS V11
IBM introduced a new Db2 table with Db2 for z/OS V11 called SYSIBM.SYSSTATFEEDBACK. The table verifies if statistics were collected and if the correct …
Read More »