Using IBM Db2 LUW as a source for AWS SCT

Using IBM DB2 LUW as a source for AWS SCT ? Read more →

Privacy Policy

Update Privacy Policy for dba-db2.com to comply with GDPR Read more →

How to sum Linux directory disk allocated

Question: I need to report on the sum of disk allocated for Linux directories dedicated to DB2 LUW directories . How can I sum the directories disk allocated ? I've tried various procedures but the sums arent't adding to same totals that are displayed when df - h is printed Answer: There's a few different ways of getting to the same total . Here's a simple example of the sum of disk allocated for two directories. In the example below - I'm adding disk allocated for /mydir and /mydir/logs df -h /mydir/ /mydir/logs | awk '{ alloc += $1 }... Read more →

How to fix DB2 TSA resource FAILED OFFLINE and MEMBERINPROBLEMSTATE

Question: During a change on a server , I had to do a TSA failover as part of testing . For various reasons - outside of TSA - the failover failed. Using lssam - one of the resources - ended up in MemberInProblemState and Failed offline Both the network and virtual ip resources are in a state of equivalency How can I fix and reset ? Answer: When a resource is marked as failed offline:clear the state and return that resource to normal operation #resetrsrc -s 'Name =="resource1"' IBM.Application #resetrsrc -s "Name like 'db2_db2inst1_0-rs' AND NodeNameList in {'MY_HOST_NAME'}" IBM.Application For... Read more →

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 →

dba-db2.com - Top 10 posts viewed in 2018

DB2 list schemas of a database DB2 How to get a view definition DB2 check DB2 instance status Database Size DB2 reorg database How to copy a DB2 database table DB2 backup history Current timestamp minus days DB2 prune inactive transaction logs How to monitor a DB2 reorg Read more →

What is using my Linux swap space?

Question: I'm familiar with how to monitor swap space usage for processes. There is more detail about the methods I've adopted for using vmstat to check swap in and swap out on Linux swap space and DB2 . How can I check what is currently in the Linux wasp space ? Answer: Sometimes out of curiosity I like to check what is consuming Linux swap space on a server . Various security type scans always appear to abound on servers and I like to differentiate between ad- hoc , regular processes. The more relevant information you've got - allows better... Read more →