22 Oct
by dbtut
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 on this site. In this article we will briefly look at the history of SQL Server. Then I will make a comparison with other relational databases from my […]
13 Oct
by Tina Bhagwati
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
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: online backup script
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
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: AUDITING
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 communication, db2set, how to setup port in db2, SVCENAME
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: activation of license, db2, how to, license, register db2, register db2 on aix
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
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
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 […]
