|
|
-
|
|
$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......
|
|
-
|
|
An XA transaction is a global transaction usually covering multiple resources.
Use the Microsoft SQL Server JDBC Driver to support the Java Platform based distributed transactions
Steps to enable XA transactions
1) Enable MSDTC
On Windows 2003 > Start > Run > “dcomconfg” > Expand Componen......
|
|
-
|
|
The DB2 code set value defines the character encoding used by the database. Setting the appropriate value for translation, for example: Euro symbol and DB2 database codeset
To get the DB2 database code set value, use:
db2 get db cfg for MY_DB
--From a command line, such as Putty,
db2 get ......
|
|
-
|
|
The dynamic management view (DMV) sys.dm_exec_requests returns information about each request that is executing within SQL Server.
Instead of using Activity Monitor to view the status of a Rollback, use this T-SQL code.
Activity monitor is based on window panes and is cumbersome to export any inf......
|
|
-
|
|
Torn Pages \ Corrupt pages – all in a days work for a DBA. But can anyone tell me how to use DBCC CHECKDB and the steps to take if a corrupt page is discovered?
This is a typical question I’ll ask at an interview for a DBA. In most cases the answers are vague.
My approach on DBCC CHE......
|
|
-
|
|
Use this select statement to create a list of ALTER SCHEMA statements for all stored procedures in a SQL Server 2005 database. “dbo” can be changed to whatever schema name required
USE myDb
GO
SELECT 'ALTER SCHEMA dbo TRANSFER ' + s.Name + '.' + p.Name
FROM sys.Procedures p INNER JOIN
sys.Sc......
|
|
-
|
|
When completing an installation I saw the following error – which stopped the installation.
The error occurred during the creation of Indexed View.
[2011-10-24 18:21:34.193 02944 error 'App'] A database error occurred: "ODBC error: (42000) - [Microsoft][SQL Server Native Client 10.0][SQL Server]C......
|
|
-
|
|
1) What types of JOINS exist?
Inner Joins
Outer Joins (LEFT JOIN, LEFT OUTER JOIN, RIGHT JOIN, RIGHT OUTER JOIN, FULL JOIN , FULL OUTER JOIN)
Cross Joins (aka Cartesian Join)
2) Where are JOINS used?
Joins are implemented in either the FROM or WHERE clause
3) Why use JOINS?
JOINS are use......
|
|
-
|
|
Instead of just right clicking on SSMS , these are some alternatives to locating SQL Server Collation information I use.
--To find all collations available
SELECT * FROM fn_helpcollations()
--To find the SQL Server Collation level
select SERVERPROPERTY('collation')
--To find the d......
|
|