|
|
-
|
|
Often there is a requirement to enforce SQL Server Security Policies. This powershell script - in part 7 -
will take a list of sql server instances, iterate through every instance, generate a list of Logins and return TRUE or FALSE for the fixed server roles: SYSADMIN, SECURITY, SERVER ADMIN, SETU......
|
|
-
|
|
To send BCC and Copy in SQL Sp_send_dbmail, use this way to send email from a configured Database Mail server.
EXEC msdb.dbo.sp_send_dbmail
@recipients = N'JackVamvas@sqlserver-dba.com',
@copy_recipients = 'JackVamvas@sqlserver-dba.com’
@blind_copy_recipients = 'tuning@sqlserver-dba.com&r......
|
|
-
|
|
I've compiled a list of the questions that I get asked most frequently. If you have a question that I haven't answered or you need a more detailed answer, you can comment on the blog or contact me. Please read through to see if I've answered it already. FAQs were lasted updated on 13th August 201......
|
|
-
|
|
Use this process to record all sql statements for a give period of time on DB2.
In other words, a trace
#connect to db
#1-Create event monitor- make sure you've got write permissions to stated folder
db2 "CREATE EVENT MONITOR stmon FOR STATEMENTS WRITE TO FILE '/tmp'"
#2 Turn on event monitor
......
|
|
-
|
|
A very useful approach to clearing down data from tables. This will truncate a specific table, without it being logged.
Use with caution!
ALTER TABLE schema.table_name activate not logged initially with empty table
Republished from http://www.dba-db2.com/.......
|
|
-
|
|
I found this message in the db2diag.log:
ADM1823E The active log is full and is held by application handle
"371". Terminate this application by COMMIT, ROLLBACK or FORCE
APPLICATION.
Doing some research there were a couple of potential causes
Potentially long running query - not commi......
|
|
-
|
|
This problem of Euro symbol was diagnosed on this platform:
Red Hat Linux 4.6
DB2 V9.5.0.0
Database
Database territory = US
Database code page = 1208
Database code set = UTF-8
A developer outlined a problem where: When euro symbol was inserted - it converts as 3 characters. Theref......
|
|
-
|
|
DB2 9.1.3 ESE
I had a crash recovery on DB2 and found the database to not be in a valid state, with the following message:
In-doubt transaction(s) exists at the end of crash recovery.
The main reason is log file size not large enough
I resolved this situation by
1)Connect to relevant database:......
|
|
-
|
|
This set of messages appeared as separate, but in a row - which indicates it's one underlying problem.
ADM1822W The active log is being held by dirty pages.
DM1823E The active log is full and is held by application handle
"79". Terminate this application by COMMIT, ROLLBACK or FORCE
APP......
|
|
-
|
|
Platform
-------------------------------
OS = RedHat Linux ESE 4.6 32 bits
DB2 versiion = v9.1.0.3
DB2 code release = SQL09013
Tivoli Storage Automation (TSA) = SAFMP V310
Problem
--------------------------------
Assumption - installed OK - and system has been running OK
i.e scheduled ......
|
|