With working on different customer systems we regularly come across databases that have been created on default drives eg, C:\ and are running out of space or have problems with sql logs shipping in mirrored environments. To move a database from one drive to another eg, C: to D: use the following steps can be [...]
Posted tagged ‘database’
Relocating a DB2 database – db2relocatedb
March 14, 2011MS SQL – Failover a SQL Mirrored Database
February 1, 2011Following is a short step by step procedure for failing over a MS SQL Mirrored Database: We are assuming the 1st SQL server is no longer responding and flipping the databases to be active on the 2nd SQL server. 1.) Obviously, log in with admin rights to the SQL Enterprise Management Studio [...]
The DB/2 Health Centre
October 17, 2010Problem: Working with a variety of customers on different platforms I see the following error occur in the Windows Event Log or db2diag.log on Linux. ADM10500E Health indicator “Monitor Heap Utilization” (“db2.mon_heap_util”) breached the “upper” alarm threshold of “95 %” with value “180 %” on “instance” ”DB2″. Calculation: “((db2.mon_heap_cur_size/db2.mon_heap_max_size)*100);” = ”((589824 / 327680) * 100)” = “180 %”. [...]
DB2 & Scheduled Tasks
June 23, 2010So you want to schedule some tasks – maybe weekly backups to complement your daily ones. Or some housekeeping in the form rbinds. The easiest place to do this is in the Task Center but what if it isn’t setup? Not a problem the following steps will take you through it and have you scheduling [...]
