|
|
-
|
|
When executing a DB2 backup command, an error message appeared
db2 backup db MyDB online use TSM include logs
SQL2033N An error occurred while accessing TSM during the processing of a
database utility. TSM reason code: "106".
Accoring to the ibm infocentre
The specified file is being u......
|
|
-
|
|
On Windows 2008 R2 , a System Reserved Partition is created. It is 100 MB and acts as a preparatory step for implementing Bitlocker. The installation doesn’t install Bitlocker. BitLocker is a disk encryption method for full disk encryption.
The System Reserved Partition can cause problems in so......
|
|
-
|
|
Table variables and Temporary tables are used interchangeably – but they were designed for different purposes.
Temporary tables were designed for storage and manipulation of temporal data.
Table variables were designed to return User Defined Function (UDF) datasets.
Which type should be used ?......
|
|
-
|
|
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 ......
|
|
-
|
|
Lazy writing , eager writing and checkpoint use asynchronous IO in writing pages to disk. The purpose of asynchronous IO is to release resources and for other tasks to progress.
i.e releases the thread to allow further threads.Usually this takes less than 10 ms – but under circ......
|
|
-
|
|
Bulk loading with large amounts of data requires strategy. The Data Loading Performance Guide for SQL Server 2008 and SQL Server 2005 is a very useful document.
Highlights
Understanding Minimally Logged OperationsTrace Flag 610 (sql server 2008)Summarizing Minimal Logging Conditions
Bulk Load M......
|
|
-
|
|
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 following commands are useful to gather Linux server information. The Linux system information is useful for such scenarios as: a) The Server Engineer requests a spec for a new Linux server build from the DBA. b) Collating inventory information for disaster recovery planning
cat /proc/cpuinf......
|
|