Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2010
    Posts
    5

    Question Unanswered: DB2 HADR standby error

    Sir/Mam,

    I have configured HADR setup successfully, but in standby database i am unable to access database tables.

    Error:

    SQL1776N The command cannot be issued on an HADR standby database. Reason code = '1'

    After referring to DB2 9.5 information center, I got :

    1.The command is not supported on an HADR standby database.
    2.Connection requests are not allowed while a database is switching from primary to standby.
    3.The MIGRATE DATABASE command is not supported on an HADR standby database.


    Pls suggest..how could i issue Migrate command in primary or resolve that problem??

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    You cannot connect to an HADR standby database (although in 9.7 FP1, you can connect to the stanby if the standby is enabled for read only mode and then only certain select statements are allowed).

    Can you elaborate on exactly what commands or funcitons you want to do on the standby. Please give the exact syntax of the commands you want to issue.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

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