Recently we have setup DB2 10.5 fix pack 5 with TSA + ACR (without virtual IP address). When we do a test by running a batch job with 10,000 records, we use rgreq -o move [resource group name] and run at the standby while the
batch job is running. The first trial, the take over complete successfully and there is no FODC generated at the db2dump folder. The second time we try to use same command rgreq -o move [resource group name] and at it at the current standby(previously is primary) , the take over complete successfully but in db2diag log file , it generated a FODC folder in db2dump.
When I do a grep on db2diaglog file at the current standby(previously is primary) for fodc, it show as below : -
START : Check /db2home/sqllib/db2dump/FODC_Panic_2016-03-07-17.12.54.075076_0000/db2pd.sortheap.WASCDC.bin for additional data.
Is there any hint of guidance provide? Does it come with any tool which we could reach the FODC stack or trap file?
I found a alternative way to prevent this to happen. When batch job is running and in order and then make a hadr force fail over by using rgreq- o move [resource group]. There is no FODC showing up. To prevent the next hadr fail over by using the same command to force a hadr failover while the batch job is still running, before doing a force fail over, run db2 force application all.
This will clean up the application and force them out, then the next hadr force fail over will still succeed but without a fodc generated in your db2dump folder.
why force - you could loose transactions on standby
why not just doing takeover hadr on standby
Best Regards, Guy Przytula
Database Software Consultant
Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
Information Server Datastage Certified http://www.infocura.be