ontape and onunload on a RSS Secondary
Good morning IIUG family,
Quick question for those who have a bit more experience with RSS secondaries
than I do. Context: My HDR Primary is so busy 24 x 7 x 365 with users and
after-hours cron-jobs processing, that performing ontapes backups and
onunloads on the secondary has become critical because of heavy usage. I am
currently unable to use either ontape or onunload on my HDR Read-only
secondary. My question: After converting my HDR Read-only Secondary to an RSS
secondary, will I able to perform an "ontape -s -L 0" full backup as well as
onunloads of databases from that RSS secondary?
Thanks for any advice.
V/r,
Jonathan Smaby
Database & Systems Admin
Pomona College
----
SPC / E-4 (CA) CSMR,
Training NCO
----
HAM: KK6FAR
"If people stop bringing you problems, you've stopped leading." - LTG Jeffrey
W. Talley, US Army Reserve
Jonathan:
The only kind of archives that you can do on ANY secondary server is an
external archive from an RSS secondary. You cannot use ontape or onbar or
onunload from a secondary server of any type.
If that is important to you, then go to IBM's Request For Enhancement (RFE)
pages and put in an RFE or add your vote to an existing one (though I did
not find this one when I looked):
https://www.ibm.com/developerworks/rfe/execute?use_case=changeRequestLanding
If you do create an RFE, post the description or keywords here so others
who are interested can vote for it.
Art
Art S. Kagel, Principal Consultant
ASK Database Management
Blog: http://informix-myview.blogspot.com/
Disclaimer: Please keep in mind that my own opinions are my own opinions
and do not reflect on the IIUG, nor any other organization with which I am
associated either explicitly, implicitly, or by inference. Neither do
those opinions reflect those of other individuals affiliated with any
entity with which I am affiliated nor those of the entities themselves.
On Mon, Mar 3, 2014 at 12:45 PM, Jonathan Smaby
<Jonathan.Smaby@pomona.edu>wrote:
> Good morning IIUG family,
>
> Quick question for those who have a bit more experience with RSS
> secondaries
> than I do. Context: My HDR Primary is so busy 24 x 7 x 365 with users and
> after-hours cron-jobs processing, that performing ontapes backups and
> onunloads on the secondary has become critical because of heavy usage. I am
> currently unable to use either ontape or onunload on my HDR Read-only
> secondary. My question: After converting my HDR Read-only Secondary to an
> RSS
> secondary, will I able to perform an "ontape -s -L 0" full backup as well
> as
> onunloads of databases from that RSS secondary?
>
> Thanks for any advice.
>
> V/r,
>
> Jonathan Smaby
> Database & Systems Admin
> Pomona College
> ----
> SPC / E-4 (CA) CSMR,
> Training NCO
> ----
> HAM: KK6FAR
>
> "If people stop bringing you problems, you've stopped leading." - LTG
> Jeffrey
> W. Talley, US Army Reserve
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--001a113800160e039904f3b7aa73
Art,
As always, thank-you for your wisdom and advice. I assume means an external
archive means using external tables?
I created an RFE this morning. I hope everyone will submit a vote. IBM will
listen to its Informix User community if we show them our interest in this
topic. The RFE # is 45728. You can search on "ontape" or "onbar" keywords.
We'll see what IBM does with it.
Thank-you again Art.
V/r,
Jonathan Smaby
Database & Systems Admin
Pomona College
----
SPC / E-4 (CA) CSMR,
Training NCO
----
HAM: KK6FAR
"If people stop bringing you problems, you've stopped leading." - LTG Jeffrey
W. Talley, US Army Reserve
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Art Kagel
Sent: Monday, March 03, 2014 10:08 AM
To: ids@iiug.org
Subject: Re: ontape and onunload on a RSS Secondary [32627]
Jonathan:
The only kind of archives that you can do on ANY secondary server is an
external archive from an RSS secondary. You cannot use ontape or onbar or
onunload from a secondary server of any type.
If that is important to you, then go to IBM's Request For Enhancement (RFE)
pages and put in an RFE or add your vote to an existing one (though I did not
find this one when I looked):
https://www.ibm.com/developerworks/rfe/execute?use_case=changeRequestLanding
If you do create an RFE, post the description or keywords here so others who
are interested can vote for it.
Art
Art S. Kagel, Principal Consultant
ASK Database Management
Blog: http://informix-myview.blogspot.com/
Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on the IIUG, nor any other organization with which I am
associated either explicitly, implicitly, or by inference. Neither do those
opinions reflect those of other individuals affiliated with any entity with
which I am affiliated nor those of the entities themselves.
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--001a113800160e039904f3b7aa73
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
Art and all,
I just received an email confirmation from the RFE site, you may contribute
votes here:
Notification generated at: 03 Mar 2014, 01:32 PM Eastern Time (ET)
ID: 45728
Headline: Backup from RSS or HDR Secondaries using ontape, onunload, onbar,
dbexportSubmitted on: 03 Mar 2014, 01:32 PM Eastern Time (ET)
Brand: Information management
Product: Informix Servers
Link:
http://www.ibm.com/developerworks/rfe/execute?use_case=viewRfe&CR_ID=45728
Thank-you.
V/r,
Jonathan B. Smaby
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Art Kagel
Sent: Monday, March 03, 2014 10:08 AM
To: ids@iiug.org
Subject: Re: ontape and onunload on a RSS Secondary [32627]
Jonathan:
The only kind of archives that you can do on ANY secondary server is an
external archive from an RSS secondary. You cannot use ontape or onbar or
onunload from a secondary server of any type.
If that is important to you, then go to IBM's Request For Enhancement (RFE)
pages and put in an RFE or add your vote to an existing one (though I did not
find this one when I looked):
https://www.ibm.com/developerworks/rfe/execute?use_case=changeRequestLanding
If you do create an RFE, post the description or keywords here so others who
are interested can vote for it.
Art
Art S. Kagel, Principal Consultant
ASK Database Management
Blog: http://informix-myview.blogspot.com/
Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on the IIUG, nor any other organization with which I am
associated either explicitly, implicitly, or by inference. Neither do those
opinions reflect those of other individuals affiliated with any entity with
which I am affiliated nor those of the entities themselves.
On Mon, Mar 3, 2014 at 12:45 PM, Jonathan Smaby
<Jonathan.Smaby@pomona.edu>wrote:
> Good morning IIUG family,
>
> Quick question for those who have a bit more experience with RSS
> secondaries than I do. Context: My HDR Primary is so busy 24 x 7 x 365
> with users and after-hours cron-jobs processing, that performing
> ontapes backups and onunloads on the secondary has become critical
> because of heavy usage. I am currently unable to use either ontape or
> onunload on my HDR Read-only secondary. My question: After converting
> my HDR Read-only Secondary to an RSS secondary, will I able to perform
> an "ontape -s -L 0" full backup as well as onunloads of databases from
> that RSS secondary?
>
> Thanks for any advice.
>
> V/r,
>
> Jonathan Smaby
> Database & Systems Admin
> Pomona College
> ----
> SPC / E-4 (CA) CSMR,
> Training NCO
> ----
> HAM: KK6FAR
>
> "If people stop bringing you problems, you've stopped leading." - LTG
> Jeffrey W. Talley, US Army Reserve
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--001a113800160e039904f3b7aa73
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
External Archive is when you freeze the server with onmode -c block, copy
the chunks or break mirrors, then release the server with onmode -c
unblock. If you've broken mirrors you would copy the mirror disks then
reestablish the mirroring and let them catch up with the mains. You can do
that with an RSS secondary. See the Backup and Restore Guide for details
and gotchas.
Art
Art S. Kagel, Principal Consultant
ASK Database Management
Blog: http://informix-myview.blogspot.com/
Disclaimer: Please keep in mind that my own opinions are my own opinions
and do not reflect on the IIUG, nor any other organization with which I am
associated either explicitly, implicitly, or by inference. Neither do
those opinions reflect those of other individuals affiliated with any
entity with which I am affiliated nor those of the entities themselves.
On Mon, Mar 3, 2014 at 1:39 PM, Jonathan Smaby
<Jonathan.Smaby@pomona.edu>wrote:
> Art,
>
> As always, thank-you for your wisdom and advice. I assume means an external
> archive means using external tables?
>
> I created an RFE this morning. I hope everyone will submit a vote. IBM will
> listen to its Informix User community if we show them our interest in this
> topic. The RFE # is 45728. You can search on "ontape" or "onbar" keywords.
>
> We'll see what IBM does with it.
>
> Thank-you again Art.
>
> V/r,
>
> Jonathan Smaby
> Database & Systems Admin
> Pomona College
> ----
> SPC / E-4 (CA) CSMR,
> Training NCO
> ----
> HAM: KK6FAR
> "If people stop bringing you problems, you've stopped leading." - LTG
> Jeffrey
> W. Talley, US Army Reserve
>
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Art
> Kagel
> Sent: Monday, March 03, 2014 10:08 AM
> To: ids@iiug.org
> Subject: Re: ontape and onunload on a RSS Secondary [32627]
>
> Jonathan:
>
> The only kind of archives that you can do on ANY secondary server is an
> external archive from an RSS secondary. You cannot use ontape or onbar or
> onunload from a secondary server of any type.
>
> If that is important to you, then go to IBM's Request For Enhancement (RFE)
> pages and put in an RFE or add your vote to an existing one (though I did
> not
> find this one when I looked):
>
>
> https://www.ibm.com/developerworks/rfe/execute?use_case=changeRequestLanding
>
> If you do create an RFE, post the description or keywords here so others
> who
> are interested can vote for it.
>
> Art
>
> Art S. Kagel, Principal Consultant
> ASK Database Management
>
> Blog: http://informix-myview.blogspot.com/
>
> Disclaimer: Please keep in mind that my own opinions are my own opinions
> and
> do not reflect on the IIUG, nor any other organization with which I am
> associated either explicitly, implicitly, or by inference. Neither do those
> opinions reflect those of other individuals affiliated with any entity with
> which I am affiliated nor those of the entities themselves.
>
>
>
>
*******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
> --001a113800160e039904f3b7aa73
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--089e01175e7d35420704f3b88ab9