|
|
-
|
|
A quick method to use for executing a script on Linux start.
After all the other processes are started by the init command at boot time, the script is run on Red Hat based systems:
/etc/rc.d/rc.local
Add any extra script\commands references to this file.
See Also
db2start at st......
|
|
-
|
|
If some long running error situation , the Error Log can become very big. In those situations , it can be time-consuming to search for specific Messages.
It is a good idea to recycle the SQL Server Error Logs . To create a new Error Log file without restarting SQL Server , use the sp_cycle_e......
|
|
-
|
|
By default , when creating a new DB2 database , the Log path is on the same drive as the data files.
To change the log path , configure the NEWLOGPATH database parameter
db2 update db cfg for MYDB using NEWLOGPATH /newpath/
See Also
OLTP performance checklist
Republished with author's......
|
|
-
|
|
In large Tivoli environments – System Adminstrators prefer to manage the installation of the Monitoring Agents
As a DBA you may need to exclude the ITMA from the DB2 server installation. Methods are:
1) To prevent the DB2 installer from installing ITMA in a response file installation, s......
|
|
-
|
|
A neat test for read speed backup throughput is to use the Backup to NUL .
NUL is a special “file”. It's as a nul device , anything “written” to it is discarded.Don’t confuse with the SQL reserved word NULL.
Before you run this statement , note that even as the file is not going anywhere , SQL Se......
|
|
-
|
|
A busy Database Server and application development environment can have – Sandbox, Dev, Test, QA, Staging, Production .
Maintaining multiple environments requires consideration of various factors.
Reasons for maintaining different environments
Part of well audited database server system includ......
|
|
-
|
|
$working_dir/$logfile
echo "operatation began `date`" $working_dir/$logfile
for i in `db2 list db directory | grep 'Database name' | awk '{print $4}'`;
do
echo "==============================" $working_dir/$logfile ;
echo "getting :DB AUTH,USER AUTH,PLAN AUTH for: $i" $working_dir/$logfil......
|
|
-
|
|
For a quick check on the DB2 instance status on Linux use:
ps aux | less | grep 'db2sysc'
Lists all DB2 instances running on the server.
db2sysc is the main DB2 engine
Related Posts
DB2 health script
Author: Jack Vamvas(http://www.dba-db2.com)
Republished with auth......
|
|
-
|
|
SQL Server Books online defines the wait type WRITELOG as “Occurs while waiting for a log flush to complete. Common operations that cause log flushes are checkpoints and transaction commits. “
A checkpoint writes all SQL dirty pages , currently in the buffer, onto disk. Transaction commits m......
|
|
-
|
|
I completed a DB2 backup on server1 with the command:
db2 backup db sample online include logs
Backup successful. The timestamp for this backup image is : 20120106215500
There was a requirement to RESTORE this database from TSM onto Server2.I logged on to Server2 and checked I could view t......
|
|