21 Dec
by Ian Sampson
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 z/OS V11 called SYSIBM.SYSSTATFEEDBACK. The table verifies if statistics were collected and if the correct statistics were collected. In Part 2, I would like to cover the format of the […]
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 own […]
13 Oct
by Tina Bhagwati
Hello Everyone , I am back with next part of Database monitoring . You should read the first article of this series. “DB2-Database Monitoring-1” 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 […]
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 […]
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. [crayon-5c3e69be61783744369995/]
8 Oct
by Syed Naveed Raza
First, delete previous delimiter files which were offloaded from the archive log. This can be regenerated. [crayon-5c3e69be61945726836658/] Below command will archive Instance level activities. [crayon-5c3e69be6194a456018531/] Below command will archive database level activities. [crayon-5c3e69be6194c292730848/] Note: Do not delete the file created by command-line “db2audit archive” [crayon-5c3e69be6194e612068620/]
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: [crayon-5c3e69be61b2f608368663/] The audit facility acts at both the instance and database levels, independently recording all activities in separate logs based on either the instance or the database. [crayon-5c3e69be61b35096569021/]
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 [crayon-5c3e69be61cf9915282361/] This parameter contains the name of the TCP⁄IP port which a database server will use to await communications from remote client nodes. […]
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, […]
