|
|
-
|
|
$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......
|
|
-
|
|
Question: I’ve just been handed a new Linux Server build, on a new storage system. The RAID levels are different and the storage parameters have changed. I need to measure the IO performance of the new system and compare to the current system.
DB2 will be deployed on these servers, which are ver......
|
|
-
|
|
Executing a t-sql statement with a convert function
convert(datetime, my_date_column) ,
threw an arithmetical overflow error with the message :
Message
Arithmetic overflow error converting expression to data type datetime. [SQLSTATE 22003] (Error 8115) The statement has......
|
|
-
|
|
To generate the ALTER INDEX..DISABLE and the ALTER INDEX..REBUILD statements for all nonclustered indexes for a single table use the following sql statements.
Copy and Paste the statements, execute on the database. I’ve included the URL column for easy click through to some notes on the code
1......
|
|
-
|
|
IBM DB2 documentation is very comprehensive. But I still like create and maintain my own documentation\scripts for repeatable tasks. Installing DB2 should be an efficient process, customised to a particular environment.
I maintain all DB2 documentation on the network and my laptop. One of the ma......
|
|
-
|
|
Use the script below to rebuild an index on a table
ALTER INDEX MY_INDEX_NAME on MY_TABLE_NAME REBUILD;
Check SQL Server BOL for a the full list of options
Notes
1) Issuing an Index Rebuild request, drops and recreates the index
2) If rebuilding a CLUSTERED INDEX, nonclustered index......
|
|
-
|
|
Part of the Performance Tuning series – Performance Stack, this section looks at Access Path Tuning. How does the user access the data and how can the access be maintained. The purpose of the series is a general approach to Performance Tuning – independent of database server platform. A large ......
|
|