13 Oct by Tina Bhagwati

DB2-Database Monitoring-2

Hello Everyone , I am back with next part of Database monitoring . I have been preparing db2 materials for learners or freshers.Therefore, this materials contains very basic language to make understand everyone. Currently, many are performance monitoring tool has been introduced  from v8.x to v11.x.On daily basis ,we all are learning something new. Currently […]
12 Oct by Syed Naveed Raza

Script to gather statistics on table and indexes

RUNSTATS utility perform statistics in DB2. Should be perform Weekly or Monthly basis. Following Script helps to gather statistics on all tables excluding XML columns and there associated indexes . Output will be emailed. First, it will generate the RUNSTATS command-line output into [/dbawork/runstats.out], then same output file will be executed with command-line db2 -tvf  Script […]
12 Oct by Syed Naveed Raza Tags:

Bash Script For Online DB backup DB2

Taking Online backup via Script this is helpful if you have multiple database in single instance.   #!/bin/bash clear echo "======================================" echo echo "ONLINE DB Backup Script" echo echo "======================================" echo echo "List of database" echo db2 list db directory |grep "Database name" echo echo "Type database name" read dbname echo "Enter COB date For […]
8 Oct by Syed Naveed Raza

How to extract DB2 audit logs into files

First, delete previous delimiter files which were offloaded from the archive log. This can be regenerated. rm /dbawork/auditarch/delfile/*.del   db2audit flush Below command will archive Instance level activities. db2audit archive to /dbawork/auditarch Below command will archive database level activities. db2audit archive database COREDB to /dbawork/auditarch Member DB Partition AUD Archived or Interim Log File Number […]
8 Oct by Syed Naveed Raza Tags:

How to setup Auditing in DB2

It is also a good idea to use a buffer to hold audit records. The audit_buf_sz controls its size: db2 update dbm cfg using audit_buf_sz 64 db2audit configure scope audit status both archivepath /dbawork/audit/ db2audit configure scope audit status both datapath /dbawork/audit/archive db2 connect to COREDB CREATE AUDIT POLICY BANKAUDIT CATEGORIES AUDIT STATUS BOTH,SECMAINT STATUS […]
5 Oct by Syed Naveed Raza Tags: , , ,

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 Communication protocol: Run with db2inst1 user db2set DB2COMM=tcpip db2set –all db2stop db2start This parameter contains the name of the TCP⁄IP port which a database server will use to await communications from […]
5 Oct by Syed Naveed Raza Tags: , , , , ,

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 Advantage. Starting with DB2 Version 9.1, the license file for DB2 products is shipped separately in a file called the Activation key. Connect with Instance owner (db2inst1) and unzip DB2_ESE_PVU_QS_Activ_10.5.0.5.zip […]
4 Oct by Ian Sampson

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 statistics were collected. Instead of rehashing the information already covered in the IBM online magazine concerning the new Db2 table SYSIBM.SYSSTATFEEDBACK written by Willie Favero, which you can find here, I […]
23 Sep by Tina Bhagwati

DB2-Database Monitoring-1

Hello Everyone, This is my first blog here regarding db2 database monitoring.I am going to start from the basic level ,therefore starts and learners can easily understand. I will try to make more interesting and I hope users will like to read more on db2 .  1.<What this unit is about > This unit introduces […]