|
|
-
|
|
To return only severe messages
db2diag –merge db2diag.1.log db2diag.2.log -level severe ? Merge 2 dlog files filtering on severe
...
|
|
-
|
|
First thing this morning – a request from a DBA to confirm if Differential BACKUPS can be restored on a database in SIMPLE RECOVERY mode. Yes , you can.
A few assumptions are made :
1) A Differential base exists
2) The Differential base is not a COPY_ONL...
|
|
-
|
|
Common reasons for query time-outs are :
1) The application starts using a query not optimal for the index
2) Hardware changes\ Configuration changes
3) Increased load
If you suspect the query time-out is due to memory issue , continue reading.
Debugging a query-timeout is tricky. I......
|
|
-
|
|
Managing a large SQL Server inventory requires an efficient management processes.
Following on from DBA productivity and less is more , this post outlines the system I use to manage the DBA scripts across the database server environment
1) Develop a script library covering the essentials ......
|
|
-
|
|
To list a SQL Server Agent Job Steps use the T-SQL example below.
This example displays the step id, SQL Server Agent Job name, Step name.
The code has 1 input parameter - @job_name
DECLARE @job_name VARCHAR(128)
SET @job_name = 'My SQL Server Agent Job'
SELECT js.step_id ,j.name,js.step_name F......
|
|
-
|
|
This article describes some methods of checking DB2 is running on a Linux Server
Method 1
Log onto the server and execute db2start as the instance owner. If the instance is running you’ll see , something like:
02/10/2012 23:36:14 0 0 SQL1026N The database manager is already active......
|
|
-
|
|
To copy a table from another SQL Server Instance is easy. Create a Linked Server on the destination server and reference the Linked Server in the SELECT statement.
1) Create linked server
/****** Object: LinkedServer [SERVER1\SQL_SERVER_INSTANCE_1] Script Date: 02/02/2012 09:29:33 ******/
EX......
|
|
-
|
|
This article explains how to send an email through Powershell.
Very useful if you have a requirement to automate your scripts and send notifications .
The example is calling the SmtpClient Class , which is part of the .Net Framework.
You can call a Function – which makes your scripting ......
|
|
-
|
|
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......
|
|