Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2004
    Location
    earth
    Posts
    96

    Unanswered: Db2 hadr tsa + fodc

    Hello,
    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?

    Thank you

  2. #2
    Join Date
    Feb 2004
    Location
    earth
    Posts
    96
    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.

  3. #3
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •