|
|
-
|
|
2012-03-14-21.59.22.121301+000 E1040722932E430 LEVEL: Severe
PID : 26754 TID : 182956718112 PROC : db2bp
INSTANCE: db2my NODE : 000
FUNCTION: DB2 UDB, bsu security, sqlexGetDefaultLoginContext, probe:150
MESSAGE : ADM1...
|
|
-
|
|
On a routine scan of Event Viewer System, Logs I found this message on 4 different servers hosting SQL Server installations
The kerberos client received a KRB_AP_ERR_MODIFIED error from the server MYCOMPUTER$. This indicates that the password used to encrypt the kerberos service ticket is differe......
|
|
-
|
|
$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......
|
|
-
|
|
Sometimes end users interchange the terms : C2 auditing and Traces. They server different purposes.
c2 auditing records all attempts (successfull and failed) on objects and statements. Typically a SQL Server DBA will use a c2 audit to monitor security compliance .
A trace will will monitor an even......
|
|
-
|
|
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......
|
|
-
|
|
For Tivoli Application Dependancy Discovery Manager (TADDM) to successfully discover DB2 instances, standardising OS and DB2 security access is the key, particularly for a large DB2 server inventory.
A non – standardised approach can lead to may hours of troubleshooting and false negatives.
Buil......
|
|
-
|
|
A sql reindex command was being blocked by two active transactions in MS DTC. Use
sys.dm_tran_active_transactions to report more detail on transactions
select * from sys.dm_tran_active_transactions where transaction_uow = '922D5B60-A5CA-4C96-8891-703021B40AD8'
/*Returns:
Transact......
|
|
-
|
|
Developers like to have some control over the development process. An example is index building. Asking a DBA repeatedly for changes to a Development Database might not be the best use of time – for either parties.
For example, a developer may want to work over the weekend to finish a Data Impor......
|
|
-
|
|
The current DBA trend is increased database management requirements and less DBAs to manage.
Many factors are responsible, such as:
1)Global trends and predictions for increased data requirements
2)Automation
3)Economic pressure to decrease size of IT departments
You can see why for many DBAs ......
|
|
-
|
|
Granting execute rights to all stored procedures used to be a cumbersome problem up to before SQL Server 2005. You either had to give elevated rights to the user or run a script to GRANT EXECUTE on every stored procedure.
I still see plenty of databases where a DBA has granted db_owner rights, sim......
|
|