DB2 TSAMP Clustering - Resource marked as OFFLINE

Question: I've installed the latest security vulnerability patching for jdk on DB2 TASMP clustering - and while running some tests i.e fail over and fail back , I'm getting a Resource Marked as offline. I've investigated the root cause - and fixed , and now I'm trying to reset the resource back as ONLINE. How can reset the resource? Answer: Without knowing anything about how the root cause and what steps you took to fix the underlying cause, the typical steps to take is to use the resetrsrc command. This is an example of how you might reset the value... Read more →

Cannot drop database SQL1035N The operation failed because the specified database cannot be connected to in the mode requested. SQLSTATE=57019

I cannot drop the database and getting the error message SQL1035N The operation failed because the specified database cannot be connected to in the mode requested. SQLSTATE=57019 What is the safest way to work around this problem? Answer: The DB2 error message appears because the current database is not a valid state for the DROP DATABASE command you’re attempting to commit. From the IBM DB2 LUW documentation “The database must not be in use; all users must be disconnected from the database before the database can be dropped”. Before you deactivate the database , speak with the application owner and... Read more →