The SYSIBM.SYSSTATFEEDBACK table introduced in Db2 for z/OS V11 Part 2
In the previous post we discussed how it is possible to extract your Integer values from IBM’s new Db2
Category: 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
DB2-Database Monitoring-2
Hello Everyone , I am back with next part of Database monitoring . You should read the first article
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
Bash Script For Online DB backup DB2
Taking Online backup via Script this is helpful if you have multiple database in single instance.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 |
#!/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 which You are going to Execute(e.g:DDMMYY)" read cobdate echo "Type of Application Backup (Type "Before" or "After" Backup If more then One COB will be executed on same day type Before1 or After1" read bkup cb="$dbname"_"$bkup"_"$cobdate"_COB mkdir -p /backup/$cb echo $cb db2 connect to $dbname date date > backup_rpt.txt db2 backup database $dbname online to /backup/$cb compress >> backup_rpt.txt date date >> backup_rpt.txt du -ms /backup/$cb >> backup_rpt.txt echo "Current DB Backup Size" du -ms /backup/$cb echo "Your $dbname-$bkup-$cobdate DB Backup is Created" mail -s "$dbname-$bkup-$cobdate DB ONLINE BACKUP" < backup_rpt.txt |
How to extract DB2 audit logs into files
First, delete previous delimiter files which were offloaded from the archive log. This can be regenerated.
|
1 2 3 |
rm /dbawork/auditarch/delfile/*.del db2audit flush |
Below
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 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
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
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