[IQUG] IQUG Digest, Vol 61, Issue 16

Steve Shen sshen at sscinc.com
Wed Jan 31 13:52:48 MST 2018


Mark,

I got it  now.  Thank you very much again.

Regards,
Steve Shen

From: Mark Mumy [mailto:markdmumy at gmail.com]
Sent: Wednesday, January 31, 2018 3:51 PM
To: Steve Shen
Cc: Ron Watkins; iqug at iqug.org
Subject: Re: [IQUG] IQUG Digest, Vol 61, Issue 16

Just normal permissions, roles, and authorizations.  No different on a writer, reader, or coordinator.  Side note, all that type work actually gets sent to the coordinator for execution.

Mark


On Jan 31, 2018, at 2:46 PM, Steve Shen <sshen at sscinc.com<mailto:sshen at sscinc.com>> wrote:

When the secondary node is “Writer node”, was there an easy way to enforce users and developers from changing the schema from the Writer node?

Thank you.

Regards,
Steve Shen


From: Steve Shen
Sent: Wednesday, January 31, 2018 3:43 PM
To: 'Ron Watkins'; iqug at iqug.org<mailto:iqug at iqug.org>
Subject: RE: IQUG Digest, Vol 61, Issue 16

Hi Ron,

Yes, I am aware of this.  Thank you.

Regards,
Steve Shen
From: Ron Watkins [mailto:rwatkins at dssolutions.com]
Sent: Wednesday, January 31, 2018 3:27 PM
To: Steve Shen; iqug at iqug.org<mailto:iqug at iqug.org>
Subject: RE: IQUG Digest, Vol 61, Issue 16

Also, be aware that when you perform a “restore” operation in DR, once you “start” the DR IQ node (for any reason, such as DBCC or other checks), you are required to resume restores using a fresh FULL dump, you can no-longer apply incrementals once you have started the IQ DR server as the state of the devices is changed by the startup.
Ron

From: Steve Shen [mailto:sshen at sscinc.com]
Sent: Wednesday, January 31, 2018 1:05 PM
To: 'Ron Watkins'; iqug at iqug.org<mailto:iqug at iqug.org>
Subject: RE: IQUG Digest, Vol 61, Issue 16

Hi Ron,

You are correct in terms of using the terminology on full and incremental backups in IQ instead of log-shipping.

Senior Unix SAs were afraid of potential concurrent disk corruptions.  They had decided not considering Snap/Clone HW replications.

Thank you.

Regards,
Steve Shen
From: Ron Watkins [mailto:rwatkins at dssolutions.com]
Sent: Wednesday, January 31, 2018 2:54 PM
To: Steve Shen; iqug at iqug.org<mailto:iqug at iqug.org>
Subject: RE: IQUG Digest, Vol 61, Issue 16

FYI, there is no such thing as log shipping in IQ.
Your only options are:
1)      Full/Incremental dump/restore (somewhat slow).
2)      Snap/Clone using HW to replicate IQ quickly.
Ron

From: Steve Shen [mailto:sshen at sscinc.com]
Sent: Wednesday, January 31, 2018 12:24 PM
To: iqug at iqug.org<mailto:iqug at iqug.org>; 'Ron Watkins'
Subject: RE: IQUG Digest, Vol 61, Issue 16

Hi all,

I am  appending one more sub-topic:
4. How to take full and transaction dumps from an Multiplex with the Coordinator node and the Writer Node and restore them to the DR Multiplex with two nodes using log shipping?

Assuming that I have the primary Multiplex with the Coordinator node (PC) and the Writer Node (PW) and the DR Multiplex with (DC) and (DW) machine names, how do I restore full backups and transaction backups from the primary Multiplex to the DR Multiplex?  Of course we have only utility_db running in either DC and DW hosts.

Please advise.  Thank you.

Regards,
Steve Shen
_____________________________________________
From: iqug-bounces at iqug.org<mailto:iqug-bounces at iqug.org> [mailto:iqug-bounces at iqug.org] On Behalf Of iqug-request at iqug.org<mailto:iqug-request at iqug.org>
Sent: Tuesday, January 23, 2018 9:56 AM
To: iqug at iqug.org<mailto:iqug at iqug.org>
Subject: IQUG Digest, Vol 61, Issue 16


Send IQUG mailing list submissions to
        iqug at iqug.org<mailto:iqug at iqug.org>

To subscribe or unsubscribe via the World Wide Web, visit
        http://iqug.org/mailman/listinfo/iqug
or, via email, send a message with subject or body 'help' to
        iqug-request at iqug.org<mailto:iqug-request at iqug.org>

You can reach the person managing the list at
        iqug-owner at iqug.org<mailto:iqug-owner at iqug.org>

When replying, please edit your Subject line so it is more specific
than "Re: Contents of IQUG digest..."


Today's Topics:

   1. How to restore full database and transaction backups from an
      IQ Simplex to an IQ Multiplex? (Steve Shen)
   2. Re: How to restore full database and transaction backups  from
      an IQ Simplex to an IQ Multiplex? (Ron Watkins)
   3. Re: How to restore full database and transaction backups from
      an IQ Simplex to an IQ Multiplex? (Steve Shen)


----------------------------------------------------------------------

Message: 1
Date: Tue, 23 Jan 2018 13:49:06 +0000
From: Steve Shen <sshen at sscinc.com<mailto:sshen at sscinc.com>>
To: "iqug at iqug.org<mailto:iqug at iqug.org>" <iqug at iqug.org<mailto:iqug at iqug.org>>
Subject: [IQUG] How to restore full database and transaction backups
        from an IQ Simplex to an IQ Multiplex?
Message-ID:
        <0C03FF7E7FA66E41A61525750FD653399035E00E at ykt1emxprd6.globeop.com<mailto:0C03FF7E7FA66E41A61525750FD653399035E00E at ykt1emxprd6.globeop.com>>
Content-Type: text/plain; charset="us-ascii"

Subject:
How to restore a full database dumps from an IQ Simplex to an IQ Multiplex?
                How to restore transaction dumps from an IQ Simplex to an IQ Multiplex?

Assuming that I have an IQ Simplex machine name S and an IQ Multiplex with two nodes, coordinator node M1 and reader node M2.

If I take the full backups from the Simplex machine S, is it possible to restore the backups to the coordinator node M1?

If I take transaction dumps from the Simplex machine S, is it possible to restore the transaction backups to the coordinator node M1?

If I change the Multiplex (M1 + M2) to Simplex (M1), I will be able to load the full and transaction backups from S; but I am wondering whether I can avoid this step because I will have to convert it to Multiplex again.

Please advise.  Thank you.

Regards,
Steve Shen


This email with all information contained herein or attached hereto may contain confidential and/or privileged information intended for the addressee(s) only. If you have received this email in error, please contact the sender and immediately delete this email in its entirety and any attachments thereto.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://iqug.org/pipermail/iqug/attachments/20180123/8326daa2/attachment-0001.html>

------------------------------

Message: 2
Date: Tue, 23 Jan 2018 07:50:08 -0700
From: "Ron Watkins" <rwatkins at dssolutions.com<mailto:rwatkins at dssolutions.com>>
To: "'Steve Shen'" <sshen at sscinc.com<mailto:sshen at sscinc.com>>,  <iqug at iqug.org<mailto:iqug at iqug.org>>
Subject: Re: [IQUG] How to restore full database and transaction
        backups from an IQ Simplex to an IQ Multiplex?
Message-ID: <00e801d39459$76f2f330$64d8d990$@dssolutions.com<mailto:00e801d39459$76f2f330$64d8d990$@dssolutions.com>>
Content-Type: text/plain; charset="us-ascii"

No, when you "restore", you will get a copy of the simplex server. After the
restore, you can "add" the second node to make it a multiplex.

The "restore" is done using the utility database, so the target server is a
complete copy of the source server. It doesn't restore into an existing
simple or multiplex server, but over-writes and creates a new stand-alone
server.

Ron



From: iqug-bounces at iqug.org<mailto:iqug-bounces at iqug.org> [mailto:iqug-bounces at iqug.org] On Behalf Of
Steve Shen
Sent: Tuesday, January 23, 2018 6:49 AM
To: iqug at iqug.org<mailto:iqug at iqug.org>
Subject: [IQUG] How to restore full database and transaction backups from an
IQ Simplex to an IQ Multiplex?



Subject:

How to restore a full database dumps from an IQ Simplex to an IQ Multiplex?

                How to restore transaction dumps from an IQ Simplex to an IQ
Multiplex?



Assuming that I have an IQ Simplex machine name S and an IQ Multiplex with
two nodes, coordinator node M1 and reader node M2.



If I take the full backups from the Simplex machine S, is it possible to
restore the backups to the coordinator node M1?



If I take transaction dumps from the Simplex machine S, is it possible to
restore the transaction backups to the coordinator node M1?



If I change the Multiplex (M1 + M2) to Simplex (M1), I will be able to load
the full and transaction backups from S; but I am wondering whether I can
avoid this step because I will have to convert it to Multiplex again.



Please advise.  Thank you.



Regards,

Steve Shen



This email with all information contained herein or attached hereto may
contain confidential and/or privileged information intended for the
addressee(s) only. If you have received this email in error, please contact
the sender and immediately delete this email in its entirety and any
attachments thereto.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://iqug.org/pipermail/iqug/attachments/20180123/a41e85d5/attachment-0001.html>

------------------------------

Message: 3
Date: Tue, 23 Jan 2018 14:56:10 +0000
From: Steve Shen <sshen at sscinc.com<mailto:sshen at sscinc.com>>
To: 'Ron Watkins' <rwatkins at dssolutions.com<mailto:rwatkins at dssolutions.com>>, "iqug at iqug.org<mailto:iqug at iqug.org>"
        <iqug at iqug.org<mailto:iqug at iqug.org>>
Subject: Re: [IQUG] How to restore full database and transaction
        backups from an IQ Simplex to an IQ Multiplex?
Message-ID:
        <0C03FF7E7FA66E41A61525750FD653399035EA17 at ykt1emxprd6.globeop.com<mailto:0C03FF7E7FA66E41A61525750FD653399035EA17 at ykt1emxprd6.globeop.com>>
Content-Type: text/plain; charset="us-ascii"

Hi Ron,

It's very interesting!  You have answered my question.

Thank you very much.

Regards,
Steve Shen

From: Ron Watkins [mailto:rwatkins at dssolutions.com]
Sent: Tuesday, January 23, 2018 9:50 AM
To: Steve Shen; iqug at iqug.org<mailto:iqug at iqug.org>
Subject: RE: [IQUG] How to restore full database and transaction backups from an IQ Simplex to an IQ Multiplex?

No, when you "restore", you will get a copy of the simplex server. After the restore, you can "add" the second node to make it a multiplex.
The "restore" is done using the utility database, so the target server is a complete copy of the source server. It doesn't restore into an existing simple or multiplex server, but over-writes and creates a new stand-alone server.
Ron

From: iqug-bounces at iqug.org<mailto:iqug-bounces at iqug.org<mailto:iqug-bounces at iqug.org%3cmailto:iqug-bounces at iqug.org>> [mailto:iqug-bounces at iqug.org] On Behalf Of Steve Shen
Sent: Tuesday, January 23, 2018 6:49 AM
To: iqug at iqug.org<mailto:iqug at iqug.org<mailto:iqug at iqug.org%3cmailto:iqug at iqug.org>>
Subject: [IQUG] How to restore full database and transaction backups from an IQ Simplex to an IQ Multiplex?

Subject:
How to restore a full database dumps from an IQ Simplex to an IQ Multiplex?
                How to restore transaction dumps from an IQ Simplex to an IQ Multiplex?

Assuming that I have an IQ Simplex machine name S and an IQ Multiplex with two nodes, coordinator node M1 and reader node M2.

If I take the full backups from the Simplex machine S, is it possible to restore the backups to the coordinator node M1?

If I take transaction dumps from the Simplex machine S, is it possible to restore the transaction backups to the coordinator node M1?

If I change the Multiplex (M1 + M2) to Simplex (M1), I will be able to load the full and transaction backups from S; but I am wondering whether I can avoid this step because I will have to convert it to Multiplex again.

Please advise.  Thank you.

Regards,
Steve Shen

This email with all information contained herein or attached hereto may contain confidential and/or privileged information intended for the addressee(s) only. If you have received this email in error, please contact the sender and immediately delete this email in its entirety and any attachments thereto.
This email with all information contained herein or attached hereto may contain confidential and/or privileged information intended for the addressee(s) only. If you have received this email in error, please contact the sender and immediately delete this email in its entirety and any attachments thereto.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://iqug.org/pipermail/iqug/attachments/20180123/43c59c5a/attachment.html>

------------------------------

_______________________________________________
IQUG mailing list
IQUG at iqug.org<mailto:IQUG at iqug.org>
http://iqug.org/mailman/listinfo/iqug

End of IQUG Digest, Vol 61, Issue 16
************************************

This email with all information contained herein or attached hereto may contain confidential and/or privileged information intended for the addressee(s) only. If you have received this email in error, please contact the sender and immediately delete this email in its entirety and any attachments thereto.
This email with all information contained herein or attached hereto may contain confidential and/or privileged information intended for the addressee(s) only. If you have received this email in error, please contact the sender and immediately delete this email in its entirety and any attachments thereto.
This email with all information contained herein or attached hereto may contain confidential and/or privileged information intended for the addressee(s) only. If you have received this email in error, please contact the sender and immediately delete this email in its entirety and any attachments thereto. _______________________________________________
IQUG mailing list
IQUG at iqug.org<mailto:IQUG at iqug.org>
http://iqug.org/mailman/listinfo/iqug

This email with all information contained herein or attached hereto may contain confidential and/or privileged information intended for the addressee(s) only. If you have received this email in error, please contact the sender and immediately delete this email in its entirety and any attachments thereto.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://iqug.org/pipermail/iqug/attachments/20180131/7059ef90/attachment-0001.html>


More information about the IQUG mailing list