Results 1 to 11 of 11
  1. #1
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11

    Unanswered: hadr and load copy

    db2 ese 9.5 on p/linux
    db on primary and standby with hadr
    started a load with copy yes on prim
    finished on primary
    now standby gets the command to execute the load copy
    hadr takeover --> hanging because the load is still running on standby
    how to identify the load copy ?
    list applications/utilities does not show this load copy
    only an entry in db2diag log : received the load copy command..
    now both db are in standby and we have to wait the takeover to complete
    no access to db anymore because of this status
    thanks for all update/help
    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

  2. #2
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    Does db2pd -util show anything on standby? I guess you can use a db2 tool to format the transaction logs. I gave it to some customers in the past and showed how to format the logs and identify different load operations. Or just use the info in the db2diag.log.

  3. #3
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    db2pd -tablespaces

    may also provide some info
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  4. #4
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    Can you execute db2pd -tablespaces without connecting to the db on standby?

  5. #5
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    Can you execute db2pd -tablespaces without connecting to the db on standby?
    Definitely! AFAIK, db2pd does not require a connection to the database for any option.
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  6. #6
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    Quote Originally Posted by sathyaram_s View Post
    Definitely! AFAIK, db2pd does not require a connection to the database for any option.
    I don't know what I was thinking. The db is in active state on standby... I must be getting old and it's time for me to retire.

  7. #7
    Join Date
    Nov 2011
    Posts
    334
    Quote Originally Posted by db2girl View Post
    Does db2pd -util show anything on standby? I guess you can use a db2 tool to format the transaction logs. I gave it to some customers in the past and showed how to format the logs and identify different load operations. Or just use the info in the db2diag.log.
    Is this tools for public?

  8. #8
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    It's an internal tool, but db2 support can give it to you if you ask (and really need it).

  9. #9
    Join Date
    Nov 2011
    Posts
    334
    oh,how to ask and how to prove i really need it?

  10. #10
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    The tool is really for db2 support/dev use. I gave it to several customers who were hitting some bug in replication and needed to get some value from the log in order to restart it (don't remember the details). Another situation is when a customer wanted to identify the tables that were loaded with nonrecoverable option.

  11. #11
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    I executed db2pd -tablespaces but could not find any hint to the load copy process..
    this load/copy is not the only process connected to the db and maybe others are deleting/modifying existing data..
    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
  •