Can you resize a dbspace?
A user accidentally created logdbs and tmpdbs dbspaces far too small on an HDR secondary and asked how to resize them. Answers: temp dbspaces can simply be dropped and recreated (updating ONCONFIG); logical logs can be moved to a new, correctly sized dbspace via onparams -a/-d plus level-0 archives. Art Kagel noted the secondary's layout is built from the primary's definitions during the restore, so the user should just shut down the future secondary and restore the primary with ontape/onbar/ifxclone. The thread then drifts into a separate question about a seemingly stalled ontape HDR backup/restore, with advice to monitor progress via onstat -D, onstat -g ath/stk and the 'Physical Restore Completed' message; no outcome is recorded for that part.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
I am working on a dev server for HDR, and on the secondary, I made a mistake
with the size of both the logdbs and tmpdbs. I just made them, and haven't
done anything else so no information is on there yet.
Am I able to somehow redo them to the correct size?
This is what I did
onspaces -c -d logdbs -p $INFORMIXCHUNKS/logdbs -o 0 -s 20000
and I wanted
onspaces -c -d logdbs -p $INFORMIXCHUNKS/logdbs -o 0 -s 200000
Same with tmpdbs
onspaces -c -d tmpdbs -t -p $INFORMIXCHUNKS/tmpdbs -o 0 -s 20000
and I wanted
onspaces -c -d tmpdbs -t -p $INFORMIXCHUNKS/tmpdbs -o 0 -s 200000
A tmpdbs can simply be dropped and you can create a new one with the correct
size.
Just remember you have to list the new tmpdbs in onconfig, otherwise it will
not be used.
Use the onspaces utility to create/drop a temp dbspace.
A LogDBS is also simple to replace, even online.
Create a new DBS with the correct size and use the onparams (onparams -a -d)
utility to create new logfiles
in the new DBS. After that (and a Level 0 Archive), you can delete the old
logs also with onparams (onparams -d -l logno).
At the end, the old logdbs should be free and can be dropped. (requires a new
L0 Archive, since a restore
would fail without the original logdbs)
Good luck,
Marcus Haarmann
Von: "BENJI LONG" <ruggedmouse@hotmail.com>
An: "ids" <ids@iiug.org>
Gesendet: Montag, 24. April 2017 21:28:12
Betreff: Can you resize a dbspace? [39009]
I am working on a dev server for HDR, and on the secondary, I made a mistake
with the size of both the logdbs and tmpdbs. I just made them, and haven't
done anything else so no information is on there yet.
Am I able to somehow redo them to the correct size?
This is what I did
onspaces -c -d logdbs -p $INFORMIXCHUNKS/logdbs -o 0 -s 20000
and I wanted
onspaces -c -d logdbs -p $INFORMIXCHUNKS/logdbs -o 0 -s 200000
Same with tmpdbs
onspaces -c -d tmpdbs -t -p $INFORMIXCHUNKS/tmpdbs -o 0 -s 20000
and I wanted
onspaces -c -d tmpdbs -t -p $INFORMIXCHUNKS/tmpdbs -o 0 -s 200000
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
When you restore the secondary to establish it that will build all of the
chunk-dbspace infrastructure from tge definitions in the primary. You do
not build an instance on the secondary.
Art
On Apr 24, 2017 15:28, "BENJI LONG" <ruggedmouse@hotmail.com> wrote:
> I am working on a dev server for HDR, and on the secondary, I made a
> mistake
> with the size of both the logdbs and tmpdbs. I just made them, and haven't
> done anything else so no information is on there yet.
>
> Am I able to somehow redo them to the correct size?
>
> This is what I did
>
> onspaces -c -d logdbs -p $INFORMIXCHUNKS/logdbs -o 0 -s 20000>
> and I wanted
>
> onspaces -c -d logdbs -p $INFORMIXCHUNKS/logdbs -o 0 -s 200000>
> Same with tmpdbs
>
> onspaces -c -d tmpdbs -t -p $INFORMIXCHUNKS/tmpdbs -o 0 -s 20000>
> and I wanted
> onspaces -c -d tmpdbs -t -p $INFORMIXCHUNKS/tmpdbs -o 0 -s 200000>
>
> ************************************************************
> *******************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--f403045d13926a5048054deed938
Oh, I didn't realize that. So will it still work with what I have or do I need to delete anything?
Ok, thanks. I thought that was the case.
Just shutdown the fiture secondary then use ontape, onbar, or ifxclone to
restore a copy of the primary to the secondary.
Art
On Apr 24, 2017 16:10, "BENJI LONG" <ruggedmouse@hotmail.com> wrote:
> Oh, I didn't realize that. So will it still work with what I have or do I
> need
> to delete anything?
>
>
> ************************************************************
> *******************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--f403045fdf96da6b39054def8f8e
ok, thanks Art
Solaris 10
IDS 11.50.FC5
I am using the HDR scripts, ontape_HDR_backup.ksh as well as its counterpart
on the secondary server. It has been running for 20 hours, and a sar on the
secondary shows 99-100% idle. Is there anyway to check the progress or to even
see if it is making progress?
The primary shows that the backup was started 20 hours ago, and the ontape is
still running. The secondary shows that the ontape -p is also running on it.
On the secondary, the online.log shows the server starting up at the same time
the archive began on the primary. There were a few quick checkpoints and then
nothing for about 14 hours. After the 14 hours there were 2 checkpoints and 2
Checkpoint Statistics and then nothing.
Larry
Also, I changed the script to be started from the secondary to "pull" the data
rather than having the primary "push" it.
Larry
________________________________
From: LARRY SORENSEN
Sent: Monday, April 24, 2017 7:15 PM
To: ids@iiug.org
Subject: Re: Can you resize a dbspace? [39016]
Solaris 10
IDS 11.50.FC5
I am using the HDR scripts, ontape_HDR_backup.ksh as well as its counterpart
on the secondary server. It has been running for 20 hours, and a sar on the
secondary shows 99-100% idle. Is there anyway to check the progress or to even
see if it is making progress?
The primary shows that the backup was started 20 hours ago, and the ontape is
still running. The secondary shows that the ontape -p is also running on it.
On the secondary, the online.log shows the server starting up at the same time
the archive began on the primary. There were a few quick checkpoints and then
nothing for about 14 hours. After the 14 hours there were 2 checkpoints and 2
Checkpoint Statistics and then nothing.
Larry
On the secondary you can run "onstat -D" and see which chunks have already
been written out. The restore restores one dbspaces at a time in dbsnum
order writting to all chunks in each dbspace before moving on to the next
dbspace. So, you can tell how far the restore has progressed. Note that
the number of pages that will be written to each chunk will be roughly the
number of used pages in that chunk (from onstat -d) plus a few pages for
the physical log pages that overwrite pages modified during the archive to
return them to their condition as of the beginning of the archive.
Art
Art S. Kagel, President and Principal Consultant
ASK Database Management
www.askdbmgt.com
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, Apr 24, 2017 at 9:31 PM, LARRY SORENSEN <LSORENSEN25@msn.com> wrote:
> Solaris 10
>
> IDS 11.50.FC5
>
> I am using the HDR scripts, ontape_HDR_backup.ksh as well as its
> counterpart
> on the secondary server. It has been running for 20 hours, and a sar on the
> secondary shows 99-100% idle. Is there anyway to check the progress or to
> even
> see if it is making progress?
>
> The primary shows that the backup was started 20 hours ago, and the ontape
> is
> still running. The secondary shows that the ontape -p is also running on
> it.
>
> On the secondary, the online.log shows the server starting up at the same
> time
> the archive began on the primary. There were a few quick checkpoints and
> then
> nothing for about 14 hours. After the 14 hours there were 2 checkpoints
> and 2
> Checkpoint Statistics and then nothing.
>
> Larry
>
>
> ************************************************************
> *******************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--f403043a8e58b5c308054df400ac
Should an onstat -D show exactly the same results on both the primary and the
secondary?
Also, I am just letting it overwrite a previous copy of the database. Do you
see any issues with this?
Larry
________________________________
From: ids-bounces@iiug.org <ids-bounces@iiug.org> on behalf of Art Kagel
<art.kagel@gmail.com>
Sent: Monday, April 24, 2017 7:54 PM
To: ids@iiug.org
Subject: Re: Can you resize a dbspace? [39019]
On the secondary you can run "onstat -D" and see which chunks have already
been written out. The restore restores one dbspaces at a time in dbsnum
order writting to all chunks in each dbspace before moving on to the next
dbspace. So, you can tell how far the restore has progressed. Note that
the number of pages that will be written to each chunk will be roughly the
number of used pages in that chunk (from onstat -d) plus a few pages for
the physical log pages that overwrite pages modified during the archive to
return them to their condition as of the beginning of the archive.
Art
Art S. Kagel, President and Principal Consultant
ASK Database Management
www.askdbmgt.com<http://www.askdbmgt.com>;
ASK Database Management - Home<http://www.askdbmgt.com/>;
www.askdbmgt.com
Database Consulting and Support ... This is the site for Art S. Kagel's
consultancy. The soaring majesty and beauty in the image above hides the
complex ecology and ...
Blog: http://informix-myview.blogspot.com/
Informix - My view<http://informix-myview.blogspot.com/>;
informix-myview.blogspot.com
A place to share my views and ideas which may be of interest to the Informix
user Community.
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, Apr 24, 2017 at 9:31 PM, LARRY SORENSEN <LSORENSEN25@msn.com> wrote:
> Solaris 10
>
> IDS 11.50.FC5
>
> I am using the HDR scripts, ontape_HDR_backup.ksh as well as its
> counterpart
> on the secondary server. It has been running for 20 hours, and a sar on the
> secondary shows 99-100% idle. Is there anyway to check the progress or to
> even
> see if it is making progress?
>
> The primary shows that the backup was started 20 hours ago, and the ontape
> is
> still running. The secondary shows that the ontape -p is also running on
> it.
>
> On the secondary, the online.log shows the server starting up at the same
> time
> the archive began on the primary. There were a few quick checkpoints and
> then
> nothing for about 14 hours. After the 14 hours there were 2 checkpoints
> and 2
> Checkpoint Statistics and then nothing.
>
> Larry
>
>
> ************************************************************
> *******************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--f403043a8e58b5c308054df400ac
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
Finally, if it looks like all the chunks have been written to, even though the
page Wr does not match up to the primary; but the primary ontape is still
running (not looking like it is doing anything because both servers are idle)
is it safe to assume it just never completed? Is it possible to kill the
ontape -s -L 0 -t STDIO on the primary side? I just think this should havecompleted 6 or 7 hours ago when I saw the last logs written to.
Larry
________________________________
From: ids-bounces@iiug.org <ids-bounces@iiug.org> on behalf of Art Kagel
<art.kagel@gmail.com>
Sent: Monday, April 24, 2017 7:54 PM
To: ids@iiug.org
Subject: Re: Can you resize a dbspace? [39019]
On the secondary you can run "onstat -D" and see which chunks have already
been written out. The restore restores one dbspaces at a time in dbsnum
order writting to all chunks in each dbspace before moving on to the next
dbspace. So, you can tell how far the restore has progressed. Note that
the number of pages that will be written to each chunk will be roughly the
number of used pages in that chunk (from onstat -d) plus a few pages for
the physical log pages that overwrite pages modified during the archive to
return them to their condition as of the beginning of the archive.
Art
Art S. Kagel, President and Principal Consultant
ASK Database Management
www.askdbmgt.com<http://www.askdbmgt.com>;
ASK Database Management - Home<http://www.askdbmgt.com/>;
www.askdbmgt.com
Database Consulting and Support ... This is the site for Art S. Kagel's
consultancy. The soaring majesty and beauty in the image above hides the
complex ecology and ...
Blog: http://informix-myview.blogspot.com/
Informix - My view<http://informix-myview.blogspot.com/>;
informix-myview.blogspot.com
A place to share my views and ideas which may be of interest to the Informix
user Community.
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, Apr 24, 2017 at 9:31 PM, LARRY SORENSEN <LSORENSEN25@msn.com> wrote:
> Solaris 10
>
> IDS 11.50.FC5
>
> I am using the HDR scripts, ontape_HDR_backup.ksh as well as its
> counterpart
> on the secondary server. It has been running for 20 hours, and a sar on the
> secondary shows 99-100% idle. Is there anyway to check the progress or to
> even
> see if it is making progress?
>
> The primary shows that the backup was started 20 hours ago, and the ontape
> is
> still running. The secondary shows that the ontape -p is also running on
> it.
>
> On the secondary, the online.log shows the server starting up at the same
> time
> the archive began on the primary. There were a few quick checkpoints and
> then
> nothing for about 14 hours. After the 14 hours there were 2 checkpoints
> and 2
> Checkpoint Statistics and then nothing.
>
> Larry
>
>
> ************************************************************
> *******************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--f403043a8e58b5c308054df400ac
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
If things are not moving you can also run the following to see what the thread
associated with the restore are doing:
onstat -g ath | egrep -v 'lio vp|pio vp|aio vp|msc vp|fifo
vp|main_loop|soctcp|kaio|flush_sub|aslogflush|btscanner|readahead|auto_tune|onmo
de_mon|periodic|memory|session_mgr|defragclean'
IBM Informix Dynamic Server Version 12.10.FC8TL -- Fast Recovery -- Up
00:04:54 -- 185992 Kbytes
Threads:tid tcb rstcb prty status vp-class name
23 473d0bb8 4516c0c0 1 cond wait netnorm 1cpu ontape
Then get the stack for the threads via the thread id (tid), here ontape is
waiting for a prompt (_iread/asfRecv)!
onstat -g stk 23
Stack for thread: 23 ontapebase: 0x00000000473d8000
len: 102400
pc: 0x00000000013f3acf
tos: 0x00000000473ef6f0
state: cond wait
vp: 1
0x00000000013f3acf (/opt/IDS.12.10.FC8/bin/oninit) yield_processor_svp
0x0000000001409adf (/opt/IDS.12.10.FC8/bin/oninit) mt_wait
0x000000000156c170 (/opt/IDS.12.10.FC8/bin/oninit) net_buf_get
0x000000000150eec6 (/opt/IDS.12.10.FC8/bin/oninit) recvsocket
0x00000000015680c4 (/opt/IDS.12.10.FC8/bin/oninit) slSQIrecv
0x000000000155ab44 (/opt/IDS.12.10.FC8/bin/oninit) pfRecv
0x000000000155260d (/opt/IDS.12.10.FC8/bin/oninit) asfRecv
0x00000000014f8dce (/opt/IDS.12.10.FC8/bin/oninit) ASF_Call
0x0000000000ad8ad0 (/opt/IDS.12.10.FC8/bin/oninit) _iread
0x0000000000ad8ea1 (/opt/IDS.12.10.FC8/bin/oninit) _igetint
0x0000000000ad7775 (/opt/IDS.12.10.FC8/bin/oninit) sqmain
0x0000000001504176 (/opt/IDS.12.10.FC8/bin/oninit) spawn_thread
0x00000000013cc6c0 (/opt/IDS.12.10.FC8/bin/oninit) th_init_initgls
0x0000000001433568 (/opt/IDS.12.10.FC8/bin/oninit) startup
Otherwise you can see a phyrecover thread doing the chunk io for a restore:
onstat -g ath | egrep -v 'lio vp|pio vp|aio vp|msc vp|fifo
vp|main_loop|soctcp|kaio|flush_sub|aslogflush|btscanner|readahead|auto_tune|onmo
de_mon|periodic|memory|session_mgr|defragclean'
IBM Informix Dynamic Server Version 12.10.FC8TL -- Fast Recovery -- Up
00:00:11 -- 185992 Kbytes
Threads:tid tcb rstcb prty status vp-class name
23 473d0bb8 4516c0c0 1 sleeping secs: 1 1cpu ontape
24 473f4d00 4516c988 3 IO Wait 1cpu physrecover
IBM Informix Dynamic Server Version 12.10.FC8TL -- Fast Recovery -- Up
00:00:15 -- 185992 Kbytes
Stack for thread: 24 physrecoverbase: 0x0000000047844000
len: 69632
pc: 0x00000000013f3acf
tos: 0x0000000047854570
state: sleeping
vp: 1
0x00000000013f3acf (/opt/IDS.12.10.FC8/bin/oninit) yield_processor_svp
0x00000000013f6633 (/opt/IDS.12.10.FC8/bin/oninit) mt_yield
0x00000000013bc3c2 (/opt/IDS.12.10.FC8/bin/oninit) mt_aio_wait
0x00000000013c12c4 (/opt/IDS.12.10.FC8/bin/oninit) mt_aio_start
0x0000000000d874c1 (/opt/IDS.12.10.FC8/bin/oninit) chunkio_int
0x0000000000d87ca9 (/opt/IDS.12.10.FC8/bin/oninit) chunkio
0x0000000000d88607 (/opt/IDS.12.10.FC8/bin/oninit) physio
0x0000000000e82200 (/opt/IDS.12.10.FC8/bin/oninit) restore_dbs_page
0x0000000000e87eb3 (/opt/IDS.12.10.FC8/bin/oninit) dophysrecvr
0x0000000001433568 (/opt/IDS.12.10.FC8/bin/oninit) startup
Regards,
David.
> On 25 April 2017 at 02:54 Art Kagel <art.kagel@gmail.com> wrote:
>
>
> On the secondary you can run "onstat -D" and see which chunks have already
> been written out. The restore restores one dbspaces at a time in dbsnum
> order writting to all chunks in each dbspace before moving on to the next
> dbspace. So, you can tell how far the restore has progressed. Note that
> the number of pages that will be written to each chunk will be roughly the
> number of used pages in that chunk (from onstat -d) plus a few pages for
> the physical log pages that overwrite pages modified during the archive to
> return them to their condition as of the beginning of the archive.
>
> Art
>
> Art S. Kagel, President and Principal Consultant
> ASK Database Management
> www.askdbmgt.com
>
> 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, Apr 24, 2017 at 9:31 PM, LARRY SORENSEN <LSORENSEN25@msn.com> wrote:
>
> > Solaris 10
> >
> > IDS 11.50.FC5
> >
> > I am using the HDR scripts, ontape_HDR_backup.ksh as well as its
> > counterpart
> > on the secondary server. It has been running for 20 hours, and a sar on the
> > secondary shows 99-100% idle. Is there anyway to check the progress or to
> > even
> > see if it is making progress?
> >
> > The primary shows that the backup was started 20 hours ago, and the ontape
> > is
> > still running. The secondary shows that the ontape -p is also running on
> > it.
> >
> > On the secondary, the online.log shows the server starting up at the same
> > time
> > the archive began on the primary. There were a few quick checkpoints and
> > then
> > nothing for about 14 hours. After the 14 hours there were 2 checkpoints
> > and 2
> > Checkpoint Statistics and then nothing.
> >
> > Larry
> >
> >
> > ************************************************************
> > *******************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
> --f403043a8e58b5c308054df400ac
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
You to wait for ontape to complete and mark all chunks as ok, please check
whereever the output for ontape is going.
Also check the thread stacks as per my previous email.
Regards,
David.
> On 25 April 2017 at 03:16 LARRY SORENSEN <LSORENSEN25@msn.com> wrote:
>
>
> Finally, if it looks like all the chunks have been written to, even though
the
> page Wr does not match up to the primary; but the primary ontape is still
> running (not looking like it is doing anything because both servers are idle)
> is it safe to assume it just never completed? Is it possible to kill the
> ontape -s -L 0 -t STDIO on the primary side? I just think this should have> completed 6 or 7 hours ago when I saw the last logs written to.
>
> Larry
>
> ________________________________
> From: ids-bounces@iiug.org <ids-bounces@iiug.org> on behalf of Art Kagel
> <art.kagel@gmail.com>
> Sent: Monday, April 24, 2017 7:54 PM
> To: ids@iiug.org
> Subject: Re: Can you resize a dbspace? [39019]
>
> On the secondary you can run "onstat -D" and see which chunks have already
> been written out. The restore restores one dbspaces at a time in dbsnum
> order writting to all chunks in each dbspace before moving on to the next
> dbspace. So, you can tell how far the restore has progressed. Note that
> the number of pages that will be written to each chunk will be roughly the
> number of used pages in that chunk (from onstat -d) plus a few pages for
> the physical log pages that overwrite pages modified during the archive to
> return them to their condition as of the beginning of the archive.
>
> Art
>
> Art S. Kagel, President and Principal Consultant
> ASK Database Management
> www.askdbmgt.com<http://www.askdbmgt.com>;
>
> ASK Database Management - Home<http://www.askdbmgt.com/>;
> www.askdbmgt.com
> Database Consulting and Support ... This is the site for Art S. Kagel's
> consultancy. The soaring majesty and beauty in the image above hides the
> complex ecology and ...
>
> Blog: http://informix-myview.blogspot.com/
>
> Informix - My view<http://informix-myview.blogspot.com/>;
> informix-myview.blogspot.com
> A place to share my views and ideas which may be of interest to the Informix
> user Community.
>
> 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, Apr 24, 2017 at 9:31 PM, LARRY SORENSEN <LSORENSEN25@msn.com> wrote:
>
> > Solaris 10
> >
> > IDS 11.50.FC5
> >
> > I am using the HDR scripts, ontape_HDR_backup.ksh as well as its
> > counterpart
> > on the secondary server. It has been running for 20 hours, and a sar on the
> > secondary shows 99-100% idle. Is there anyway to check the progress or to
> > even
> > see if it is making progress?
> >
> > The primary shows that the backup was started 20 hours ago, and the ontape
> > is
> > still running. The secondary shows that the ontape -p is also running on
> > it.
> >
> > On the secondary, the online.log shows the server starting up at the same
> > time
> > the archive began on the primary. There were a few quick checkpoints and
> > then
> > nothing for about 14 hours. After the 14 hours there were 2 checkpoints
> > and 2
> > Checkpoint Statistics and then nothing.
> >
> > Larry
> >
> >
> > ************************************************************
> > *******************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
> --f403043a8e58b5c308054df400ac
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
No and no.
Art
Art S. Kagel, President and Principal Consultant
ASK Database Management
www.askdbmgt.com
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, Apr 24, 2017 at 10:11 PM, LARRY SORENSEN <LSORENSEN25@msn.com>
wrote:
> Should an onstat -D show exactly the same results on both the primary and
> the
> secondary?
>
> Also, I am just letting it overwrite a previous copy of the database. Do
> you
> see any issues with this?
>
> Larry
>
> ________________________________
> From: ids-bounces@iiug.org <ids-bounces@iiug.org> on behalf of Art Kagel
> <art.kagel@gmail.com>
> Sent: Monday, April 24, 2017 7:54 PM
> To: ids@iiug.org
> Subject: Re: Can you resize a dbspace? [39019]
>
> On the secondary you can run "onstat -D" and see which chunks have already
> been written out. The restore restores one dbspaces at a time in dbsnum
> order writting to all chunks in each dbspace before moving on to the next
> dbspace. So, you can tell how far the restore has progressed. Note that
> the number of pages that will be written to each chunk will be roughly the
> number of used pages in that chunk (from onstat -d) plus a few pages for
> the physical log pages that overwrite pages modified during the archive to
> return them to their condition as of the beginning of the archive.
>
> Art
>
> Art S. Kagel, President and Principal Consultant
> ASK Database Management
> www.askdbmgt.com<http://www.askdbmgt.com>;
>
> ASK Database Management - Home<http://www.askdbmgt.com/>;
> www.askdbmgt.com
> Database Consulting and Support ... This is the site for Art S. Kagel's
> consultancy. The soaring majesty and beauty in the image above hides the
> complex ecology and ...
>
> Blog: http://informix-myview.blogspot.com/
>
> Informix - My view<http://informix-myview.blogspot.com/>;
> informix-myview.blogspot.com
> A place to share my views and ideas which may be of interest to the
> Informix
> user Community.
>
> 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, Apr 24, 2017 at 9:31 PM, LARRY SORENSEN <LSORENSEN25@msn.com>
> wrote:
>
> > Solaris 10
> >
> > IDS 11.50.FC5
> >
> > I am using the HDR scripts, ontape_HDR_backup.ksh as well as its
> > counterpart
> > on the secondary server. It has been running for 20 hours, and a sar on
> the
> > secondary shows 99-100% idle. Is there anyway to check the progress or to
> > even
> > see if it is making progress?
> >
> > The primary shows that the backup was started 20 hours ago, and the
> ontape> > is
> > still running. The secondary shows that the ontape -p is also running on
> > it.
> >
> > On the secondary, the online.log shows the server starting up at the same
> > time
> > the archive began on the primary. There were a few quick checkpoints and
> > then
> > nothing for about 14 hours. After the 14 hours there were 2 checkpoints
> > and 2
> > Checkpoint Statistics and then nothing.
> >
> > Larry
> >
> >
> > ************************************************************
> > *******************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
> --f403043a8e58b5c308054df400ac
>
>
> ************************************************************
> *******************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
> ************************************************************
> *******************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--f403045e38c6037d25054df49d7d
Depending on how you started this backup & restore using STDIO, it might=20
be perfectly expected that you've got to control-C it after it has=20
completed.
E.g. ontape -s -L 0 -F -t STDIO | ssh machine=5Fb ~/imp=5Frest.sh
with imp=5Frest.sh being:
#!/bin/bash
. set=5Fix=5Fenv
ontape -p -t STDIO
Question simply is: do you have a "Physical Restore of <space=5Flist>=20
Completed." message in online.log?
From: "LARRY SORENSEN" <LSORENSEN25@msn.com>
To: ids@iiug.org
Date: 25.04.2017 04:16
Subject: Re: Can you resize a dbspace? [39021]
Sent by: ids-bounces@iiug.org
Finally, if it looks like all the chunks have been written to, even though =
the=20
page Wr does not match up to the primary; but the primary ontape is still=20
running (not looking like it is doing anything because both servers are=20
idle)=20
is it safe to assume it just never completed? Is it possible to kill the=20
ontape -s -L 0 -t STDIO on the primary side? I just think this should have =
completed 6 or 7 hours ago when I saw the last logs written to.=20
Larry=20
=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=
=5F=5F=5F=5F=5F=5F=5F=20
From: ids-bounces@iiug.org <ids-bounces@iiug.org> on behalf of Art Kagel=20
<art.kagel@gmail.com>=20
Sent: Monday, April 24, 2017 7:54 PM=20
To: ids@iiug.org=20
Subject: Re: Can you resize a dbspace? [39019]=20
On the secondary you can run "onstat -D" and see which chunks have already =
been written out. The restore restores one dbspaces at a time in dbsnum=20
order writting to all chunks in each dbspace before moving on to the next=20
dbspace. So, you can tell how far the restore has progressed. Note that=20
the number of pages that will be written to each chunk will be roughly the =
number of used pages in that chunk (from onstat -d) plus a few pages for=20
the physical log pages that overwrite pages modified during the archive to =
return them to their condition as of the beginning of the archive.=20
Art=20
Art S. Kagel, President and Principal Consultant=20
ASK Database Management=20
www.askdbmgt.com<http://www.askdbmgt.com>=20
ASK Database Management - Home<http://www.askdbmgt.com/>=20
www.askdbmgt.com=20
Database Consulting and Support ... This is the site for Art S. Kagel's=20
consultancy. The soaring majesty and beauty in the image above hides the=20
complex ecology and ...=20
Blog: http://informix-myview.blogspot.com/=20
Informix - My view<http://informix-myview.blogspot.com/>=20
informix-myview.blogspot.com=20
A place to share my views and ideas which may be of interest to the=20
Informix=20
user Community.=20
Disclaimer: Please keep in mind that my own opinions are my own opinions=20
and do not reflect on the IIUG, nor any other organization with which I am =
associated either explicitly, implicitly, or by inference. Neither do=20
those opinions reflect those of other individuals affiliated with any=20
entity with which I am affiliated nor those of the entities themselves.=20
On Mon, Apr 24, 2017 at 9:31 PM, LARRY SORENSEN <LSORENSEN25@msn.com>=20
wrote:=20
> Solaris 10=20
>=20
> IDS 11.50.FC5=20
>=20
> I am using the HDR scripts, ontape=5FHDR=5Fbackup.ksh as well as its=20
> counterpart=20
> on the secondary server. It has been running for 20 hours, and a sar on=20
the=20
> secondary shows 99-100% idle. Is there anyway to check the progress or=20
to=20
> even=20
> see if it is making progress?=20
>=20
> The primary shows that the backup was started 20 hours ago, and the=20
ontape=20
> is=20
> still running. The secondary shows that the ontape -p is also running on =
> it.=20
>=20
> On the secondary, the online.log shows the server starting up at the=20
same=20
> time=20
> the archive began on the primary. There were a few quick checkpoints and =
> then=20
> nothing for about 14 hours. After the 14 hours there were 2 checkpoints=20
> and 2=20
> Checkpoint Statistics and then nothing.=20
>=20
> Larry=20
>=20
>=20
> ************************************************************=20
> *******************=20
> Forum Note: Use "Reply" to post a response in the discussion forum.=20
>=20
>=20
--f403043a8e58b5c308054df400ac=20
***************************************************************************=
****=20
Forum Note: Use "Reply" to post a response in the discussion forum.=20
***************************************************************************=
****=20
Forum Note: Use "Reply" to post a response in the discussion forum.=20
Thank you, both of you. I can watch the final dbspaces filling with doing
onstat -D every so often and doing a diff on results. I was just worried thatnothing was happening.
Larry
________________________________
From: ids-bounces@iiug.org <ids-bounces@iiug.org> on behalf of Art Kagel
<art.kagel@gmail.com>
Sent: Monday, April 24, 2017 8:38 PM
To: ids@iiug.org
Subject: Re: Can you resize a dbspace? [39024]
No and no.
Art
Art S. Kagel, President and Principal Consultant
ASK Database Management
www.askdbmgt.com<http://www.askdbmgt.com>;
ASK Database Management - Home<http://www.askdbmgt.com/>;
www.askdbmgt.com
Database Consulting and Support ... This is the site for Art S. Kagel's
consultancy. The soaring majesty and beauty in the image above hides the
complex ecology and ...
Blog: http://informix-myview.blogspot.com/
Informix - My view<http://informix-myview.blogspot.com/>;
informix-myview.blogspot.com
A place to share my views and ideas which may be of interest to the Informix
user Community.
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, Apr 24, 2017 at 10:11 PM, LARRY SORENSEN <LSORENSEN25@msn.com>
wrote:
> Should an onstat -D show exactly the same results on both the primary and
> the
> secondary?
>
> Also, I am just letting it overwrite a previous copy of the database. Do
> you
> see any issues with this?
>
> Larry
>
> ________________________________
> From: ids-bounces@iiug.org <ids-bounces@iiug.org> on behalf of Art Kagel
> <art.kagel@gmail.com>
> Sent: Monday, April 24, 2017 7:54 PM
> To: ids@iiug.org
> Subject: Re: Can you resize a dbspace? [39019]
>
> On the secondary you can run "onstat -D" and see which chunks have already
> been written out. The restore restores one dbspaces at a time in dbsnum
> order writting to all chunks in each dbspace before moving on to the next
> dbspace. So, you can tell how far the restore has progressed. Note that
> the number of pages that will be written to each chunk will be roughly the
> number of used pages in that chunk (from onstat -d) plus a few pages for
> the physical log pages that overwrite pages modified during the archive to
> return them to their condition as of the beginning of the archive.
>
> Art
>
> Art S. Kagel, President and Principal Consultant
> ASK Database Management
> www.askdbmgt.com<http://www.askdbmgt.com>;
ASK Database Management - Home<http://www.askdbmgt.com/>;
www.askdbmgt.com
Database Consulting and Support ... This is the site for Art S. Kagel's
consultancy. The soaring majesty and beauty in the image above hides the
complex ecology and ...
>
> ASK Database Management - Home<http://www.askdbmgt.com/>;
ASK Database Management - Home<http://www.askdbmgt.com/>;
www.askdbmgt.com
Database Consulting and Support ... This is the site for Art S. Kagel's
consultancy. The soaring majesty and beauty in the image above hides the
complex ecology and ...
> www.askdbmgt.com<http://www.askdbmgt.com>;
ASK Database Management - Home<http://www.askdbmgt.com/>;
www.askdbmgt.com
Database Consulting and Support ... This is the site for Art S. Kagel's
consultancy. The soaring majesty and beauty in the image above hides the
complex ecology and ...
> Database Consulting and Support ... This is the site for Art S. Kagel's
> consultancy. The soaring majesty and beauty in the image above hides the
> complex ecology and ...
>
> Blog: http://informix-myview.blogspot.com/
>
> Informix - My view<http://informix-myview.blogspot.com/>;
> informix-myview.blogspot.com
> A place to share my views and ideas which may be of interest to the
> Informix
> user Community.
>
> 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, Apr 24, 2017 at 9:31 PM, LARRY SORENSEN <LSORENSEN25@msn.com>
> wrote:
>
> > Solaris 10
> >
> > IDS 11.50.FC5
> >
> > I am using the HDR scripts, ontape_HDR_backup.ksh as well as its
> > counterpart
> > on the secondary server. It has been running for 20 hours, and a sar on
> the
> > secondary shows 99-100% idle. Is there anyway to check the progress or to
> > even
> > see if it is making progress?
> >
> > The primary shows that the backup was started 20 hours ago, and the
> ontape> > is
> > still running. The secondary shows that the ontape -p is also running on
> > it.
> >
> > On the secondary, the online.log shows the server starting up at the same
> > time
> > the archive began on the primary. There were a few quick checkpoints and
> > then
> > nothing for about 14 hours. After the 14 hours there were 2 checkpoints
> > and 2
> > Checkpoint Statistics and then nothing.
> >
> > Larry
> >
> >
> > ************************************************************
> > *******************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
> --f403043a8e58b5c308054df400ac
>
>
> ************************************************************
> *******************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
> ************************************************************
> *******************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--f403045e38c6037d25054df49d7d
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
Hi Andreas,
I tried the scenario below on a pair of CentOS VMs and did not need to
Control-C, under what circumstances do you need to Control-C?
-bash-4.2$ ontape -s -L 0 -F -t STDIO | ssh hostb /tmp/p1Your evaluation license will expire on 2017-05-14 00:00:00
Your evaluation license will expire on 2017-05-14 00:00:00
Your evaluation license will expire on 2017-05-14 00:00:00
-bash-4.2$
-bash-4.2$ cat /tmp/p1
#!/bin/bash
. /opt/IDS.12.10.FC8/ol_informix1210.ksh
ontape -p -t STDIO
Regards,
David.
> On 25 April 2017 at 04:26 Andreas Legner <andreas.legner@de.ibm.com> wrote:
>
>
> Depending on how you started this backup & restore using STDIO, it might=20
> be perfectly expected that you've got to control-C it after it has=20
> completed.
>
> E.g. ontape -s -L 0 -F -t STDIO | ssh machine=5Fb ~/imp=5Frest.sh
>
> with imp=5Frest.sh being:
>
> #!/bin/bash
> .. set=5Fix=5Fenv
> ontape -p -t STDIO>
> Question simply is: do you have a "Physical Restore of <space=5Flist>=20
> Completed." message in online.log?
>
> From: "LARRY SORENSEN" <LSORENSEN25@msn.com>
> To: ids@iiug.org
> Date: 25.04.2017 04:16
> Subject: Re: Can you resize a dbspace? [39021]
> Sent by: ids-bounces@iiug.org
>
> Finally, if it looks like all the chunks have been written to, even though =
>
> the=20
> page Wr does not match up to the primary; but the primary ontape is still=20
> running (not looking like it is doing anything because both servers are=20
> idle)=20
> is it safe to assume it just never completed? Is it possible to kill the=20
> ontape -s -L 0 -t STDIO on the primary side? I just think this should have =>
> completed 6 or 7 hours ago when I saw the last logs written to.=20
>
> Larry=20
>
> =5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=
> =5F=5F=5F=5F=5F=5F=5F=20
> From: ids-bounces@iiug.org <ids-bounces@iiug.org> on behalf of Art Kagel=20
> <art.kagel@gmail.com>=20
> Sent: Monday, April 24, 2017 7:54 PM=20
> To: ids@iiug.org=20
> Subject: Re: Can you resize a dbspace? [39019]=20
>
> On the secondary you can run "onstat -D" and see which chunks have already =
>
> been written out. The restore restores one dbspaces at a time in dbsnum=20
> order writting to all chunks in each dbspace before moving on to the next=20
> dbspace. So, you can tell how far the restore has progressed. Note that=20
> the number of pages that will be written to each chunk will be roughly the =
>
> number of used pages in that chunk (from onstat -d) plus a few pages for=20
> the physical log pages that overwrite pages modified during the archive to =
>
> return them to their condition as of the beginning of the archive.=20
>
> Art=20
>
> Art S. Kagel, President and Principal Consultant=20
> ASK Database Management=20
> www.askdbmgt.com<http://www.askdbmgt.com>=20
>
> ASK Database Management - Home<http://www.askdbmgt.com/>=20
> www.askdbmgt.com=20
> Database Consulting and Support ... This is the site for Art S. Kagel's=20
> consultancy. The soaring majesty and beauty in the image above hides the=20
> complex ecology and ...=20
>
> Blog: http://informix-myview.blogspot.com/=20
>
> Informix - My view<http://informix-myview.blogspot.com/>=20
> informix-myview.blogspot.com=20
> A place to share my views and ideas which may be of interest to the=20
> Informix=20
> user Community.=20
>
> Disclaimer: Please keep in mind that my own opinions are my own opinions=20
> and do not reflect on the IIUG, nor any other organization with which I am =
>
> associated either explicitly, implicitly, or by inference. Neither do=20
> those opinions reflect those of other individuals affiliated with any=20
> entity with which I am affiliated nor those of the entities themselves.=20
>
> On Mon, Apr 24, 2017 at 9:31 PM, LARRY SORENSEN <LSORENSEN25@msn.com>=20
> wrote:=20
>
> > Solaris 10=20
> >=20
> > IDS 11.50.FC5=20
> >=20
> > I am using the HDR scripts, ontape=5FHDR=5Fbackup.ksh as well as its=20
> > counterpart=20
> > on the secondary server. It has been running for 20 hours, and a sar on=20
> the=20
> > secondary shows 99-100% idle. Is there anyway to check the progress or=20
> to=20
> > even=20
> > see if it is making progress?=20
> >=20
> > The primary shows that the backup was started 20 hours ago, and the=20
> ontape=20
> > is=20
> > still running. The secondary shows that the ontape -p is also running on =
>
> > it.=20
> >=20
> > On the secondary, the online.log shows the server starting up at the=20
> same=20
> > time=20
> > the archive began on the primary. There were a few quick checkpoints and =
>
> > then=20
> > nothing for about 14 hours. After the 14 hours there were 2 checkpoints=20
> > and 2=20
> > Checkpoint Statistics and then nothing.=20
> >=20
> > Larry=20
> >=20
> >=20
> > ************************************************************=20
> > *******************=20
> > Forum Note: Use "Reply" to post a response in the discussion forum.=20
> >=20
> >=20
>
> --f403043a8e58b5c308054df400ac=20
>
> ***************************************************************************=
> ****=20
>
> Forum Note: Use "Reply" to post a response in the discussion forum.=20
>
> ***************************************************************************=
> ****=20
>
> Forum Note: Use "Reply" to post a response in the discussion forum.=20
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
The process finally completed after about 30 hours. I just needed to be
patient. I can't believe that the network is that slow, but I guess it is.
Thank you all for your responses.
LArry
________________________________
From: ids-bounces@iiug.org <ids-bounces@iiug.org> on behalf of
david@smooth1.co.uk <david@smooth1.co.uk>
Sent: Tuesday, April 25, 2017 3:15 AM
To: ids@iiug.org
Subject: Re: Can you resize a dbspace? [39027]
Hi Andreas,
I tried the scenario below on a pair of CentOS VMs and did not need to
Control-C, under what circumstances do you need to Control-C?
-bash-4.2$ ontape -s -L 0 -F -t STDIO | ssh hostb /tmp/p1Your evaluation license will expire on 2017-05-14 00:00:00
Your evaluation license will expire on 2017-05-14 00:00:00
Your evaluation license will expire on 2017-05-14 00:00:00
-bash-4.2$
-bash-4.2$ cat /tmp/p1
#!/bin/bash
.. /opt/IDS.12.10.FC8/ol_informix1210.ksh
ontape -p -t STDIO
Regards,
David.
> On 25 April 2017 at 04:26 Andreas Legner <andreas.legner@de.ibm.com> wrote:
>
>
> Depending on how you started this backup & restore using STDIO, it might=20
> be perfectly expected that you've got to control-C it after it has=20
> completed.
>
> E.g. ontape -s -L 0 -F -t STDIO | ssh machine=5Fb ~/imp=5Frest.sh
>
> with imp=5Frest.sh being:
>
> #!/bin/bash
> .. set=5Fix=5Fenv
> ontape -p -t STDIO>
> Question simply is: do you have a "Physical Restore of <space=5Flist>=20
> Completed." message in online.log?
>
> From: "LARRY SORENSEN" <LSORENSEN25@msn.com>
> To: ids@iiug.org
> Date: 25.04.2017 04:16
> Subject: Re: Can you resize a dbspace? [39021]
> Sent by: ids-bounces@iiug.org
>
> Finally, if it looks like all the chunks have been written to, even though =
>
> the=20
> page Wr does not match up to the primary; but the primary ontape is still=20
> running (not looking like it is doing anything because both servers are=20
> idle)=20
> is it safe to assume it just never completed? Is it possible to kill the=20
> ontape -s -L 0 -t STDIO on the primary side? I just think this should have =>
> completed 6 or 7 hours ago when I saw the last logs written to.=20
>
> Larry=20
>
> =5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=
> =5F=5F=5F=5F=5F=5F=5F=20
> From: ids-bounces@iiug.org <ids-bounces@iiug.org> on behalf of Art Kagel=20
> <art.kagel@gmail.com>=20
> Sent: Monday, April 24, 2017 7:54 PM=20
> To: ids@iiug.org=20
> Subject: Re: Can you resize a dbspace? [39019]=20
>
> On the secondary you can run "onstat -D" and see which chunks have already =
>
> been written out. The restore restores one dbspaces at a time in dbsnum=20
> order writting to all chunks in each dbspace before moving on to the next=20
> dbspace. So, you can tell how far the restore has progressed. Note that=20
> the number of pages that will be written to each chunk will be roughly the =
>
> number of used pages in that chunk (from onstat -d) plus a few pages for=20
> the physical log pages that overwrite pages modified during the archive to =
>
> return them to their condition as of the beginning of the archive.=20
>
> Art=20
>
> Art S. Kagel, President and Principal Consultant=20
> ASK Database Management=20
> www.askdbmgt.com<http://www.askdbmgt.com>=20
ASK Database Management - Home<http://www.askdbmgt.com/>;
www.askdbmgt.com
Database Consulting and Support ... This is the site for Art S. Kagel's
consultancy. The soaring majesty and beauty in the image above hides the
complex ecology and ...
>
> ASK Database Management - Home<http://www.askdbmgt.com/>=20
ASK Database Management - Home<http://www.askdbmgt.com/>;
www.askdbmgt.com
Database Consulting and Support ... This is the site for Art S. Kagel's
consultancy. The soaring majesty and beauty in the image above hides the
complex ecology and ...
> www.askdbmgt.com=20<http://www.askdbmgt.com=20>;
> Database Consulting and Support ... This is the site for Art S. Kagel's=20
> consultancy. The soaring majesty and beauty in the image above hides the=20
> complex ecology and ...=20
>
> Blog: http://informix-myview.blogspot.com/=20
Informix - My view<http://informix-myview.blogspot.com/=20>;
informix-myview.blogspot.com
A place to share my views and ideas which may be of interest to the Informix
user Community.
>
> Informix - My view<http://informix-myview.blogspot.com/>=20
Informix - My view<http://informix-myview.blogspot.com/>;
informix-myview.blogspot.com
A place to share my views and ideas which may be of interest to the Informix
user Community.
> informix-myview.blogspot.com=20
> A place to share my views and ideas which may be of interest to the=20
> Informix=20
> user Community.=20
>
> Disclaimer: Please keep in mind that my own opinions are my own opinions=20
> and do not reflect on the IIUG, nor any other organization with which I am =
>
> associated either explicitly, implicitly, or by inference. Neither do=20
> those opinions reflect those of other individuals affiliated with any=20
> entity with which I am affiliated nor those of the entities themselves.=20
>
> On Mon, Apr 24, 2017 at 9:31 PM, LARRY SORENSEN <LSORENSEN25@msn.com>=20
> wrote:=20
>
> > Solaris 10=20
> >=20
> > IDS 11.50.FC5=20
> >=20
> > I am using the HDR scripts, ontape=5FHDR=5Fbackup.ksh as well as its=20
> > counterpart=20
> > on the secondary server. It has been running for 20 hours, and a sar on=20
> the=20
> > secondary shows 99-100% idle. Is there anyway to check the progress or=20
> to=20
> > even=20
> > see if it is making progress?=20
> >=20
> > The primary shows that the backup was started 20 hours ago, and the=20
> ontape=20
> > is=20
> > still running. The secondary shows that the ontape -p is also running on =
>
> > it.=20
> >=20
> > On the secondary, the online.log shows the server starting up at the=20
> same=20
> > time=20
> > the archive began on the primary. There were a few quick checkpoints and =
>
> > then=20
> > nothing for about 14 hours. After the 14 hours there were 2 checkpoints=20
> > and 2=20
> > Checkpoint Statistics and then nothing.=20
> >=20
> > Larry=20
> >=20
> >=20
> > ************************************************************=20
> > *******************=20
> > Forum Note: Use "Reply" to post a response in the discussion forum.=20
> >=20
> >=20
>
> --f403043a8e58b5c308054df400ac=20
>
> ***************************************************************************=
> ****=20
>
> Forum Note: Use "Reply" to post a response in the discussion forum.=20
>
> ***************************************************************************=
> ****=20
>
> Forum Note: Use "Reply" to post a response in the discussion forum.=20
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
***********************************
I was able to get replication going from the below process. I then had to
switch the Primary and secondary.
I took the Primary offline.
I ran hdrmkpri.sh new_sec_name
This takes the new primary offline.
I then ran hdrmksec.sh new_pri_name.
Toward the end of the script it asks me to bring the primary online so they
can sink. I did.
It looked like everything was working.
Logical Recovery Started.
24 Recovery worker threads will be started.
Start Logical Recovery - Star Log 77121, End Log?
Starting Log Position - 77121 0x7a60bc
DR: Cleared 28550 KB of Logical log in - seconds.
After that the secondary remains in Fast Recovery (Sec)
The primary remains in -- On-Line (Prim) (CKPT REQ) -- Blocked:CKPT
Any ideas?
Larry
________________________________
From: ids-bounces@iiug.org <ids-bounces@iiug.org> on behalf of LARRY SORENSEN
<LSORENSEN25@msn.com>
Sent: Monday, April 24, 2017 10:27 PM
To: ids@iiug.org
Subject: Re: Can you resize a dbspace? [39026]
Thank you, both of you. I can watch the final dbspaces filling with doing
onstat -D every so often and doing a diff on results. I was just worried thatnothing was happening.
Larry
________________________________
From: ids-bounces@iiug.org <ids-bounces@iiug.org> on behalf of Art Kagel
<art.kagel@gmail.com>
Sent: Monday, April 24, 2017 8:38 PM
To: ids@iiug.org
Subject: Re: Can you resize a dbspace? [39024]
No and no.
Art
Art S. Kagel, President and Principal Consultant
ASK Database Management
www.askdbmgt.com<http://www.askdbmgt.com>;
ASK Database Management - Home<http://www.askdbmgt.com/>;
www.askdbmgt.com
Database Consulting and Support ... This is the site for Art S. Kagel's
consultancy. The soaring majesty and beauty in the image above hides the
complex ecology and ...
ASK Database Management - Home<http://www.askdbmgt.com/>;
ASK Database Management - Home<http://www.askdbmgt.com/>;
www.askdbmgt.com
Database Consulting and Support ... This is the site for Art S. Kagel's
consultancy. The soaring majesty and beauty in the image above hides the
complex ecology and ...
www.askdbmgt.com<http://www.askdbmgt.com>;
ASK Database Management - Home<http://www.askdbmgt.com/>;
www.askdbmgt.com
Database Consulting and Support ... This is the site for Art S. Kagel's
consultancy. The soaring majesty and beauty in the image above hides the
complex ecology and ...
Database Consulting and Support ... This is the site for Art S. Kagel's
consultancy. The soaring majesty and beauty in the image above hides the
complex ecology and ...
Blog: http://informix-myview.blogspot.com/
Informix - My view<http://informix-myview.blogspot.com/>;
informix-myview.blogspot.com
A place to share my views and ideas which may be of interest to the Informix
user Community.
Informix - My view<http://informix-myview.blogspot.com/>;
Informix - My view<http://informix-myview.blogspot.com/>;
informix-myview.blogspot.com
A place to share my views and ideas which may be of interest to the Informix
user Community.
informix-myview.blogspot.com
A place to share my views and ideas which may be of interest to the Informix
user Community.
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, Apr 24, 2017 at 10:11 PM, LARRY SORENSEN <LSORENSEN25@msn.com>
wrote:
> Should an onstat -D show exactly the same results on both the primary and
> the
> secondary?
>
> Also, I am just letting it overwrite a previous copy of the database. Do
> you
> see any issues with this?
>
> Larry
>
> ________________________________
> From: ids-bounces@iiug.org <ids-bounces@iiug.org> on behalf of Art Kagel
> <art.kagel@gmail.com>
> Sent: Monday, April 24, 2017 7:54 PM
> To: ids@iiug.org
> Subject: Re: Can you resize a dbspace? [39019]
>
> On the secondary you can run "onstat -D" and see which chunks have already
> been written out. The restore restores one dbspaces at a time in dbsnum
> order writting to all chunks in each dbspace before moving on to the next
> dbspace. So, you can tell how far the restore has progressed. Note that
> the number of pages that will be written to each chunk will be roughly the
> number of used pages in that chunk (from onstat -d) plus a few pages for
> the physical log pages that overwrite pages modified during the archive to
> return them to their condition as of the beginning of the archive.
>
> Art
>
> Art S. Kagel, President and Principal Consultant
> ASK Database Management
> www.askdbmgt.com<http://www.askdbmgt.com>;
ASK Database Management - Home<http://www.askdbmgt.com/>;
www.askdbmgt.com
Database Consulting and Support ... This is the site for Art S. Kagel's
consultancy. The soaring majesty and beauty in the image above hides the
complex ecology and ...
ASK Database Management - Home<http://www.askdbmgt.com/>;
ASK Database Management - Home<http://www.askdbmgt.com/>;
www.askdbmgt.com
Database Consulting and Support ... This is the site for Art S. Kagel's
consultancy. The soaring majesty and beauty in the image above hides the
complex ecology and ...
www.askdbmgt.com<http://www.askdbmgt.com>;
ASK Database Management - Home<http://www.askdbmgt.com/>;
www.askdbmgt.com
Database Consulting and Support ... This is the site for Art S. Kagel's
consultancy. The soaring majesty and beauty in the image above hides the
complex ecology and ...
Database Consulting and Support ... This is the site for Art S. Kagel's
consultancy. The soaring majesty and beauty in the image above hides the
complex ecology and ...
>
> ASK Database Management - Home<http://www.askdbmgt.com/>;
ASK Database Management - Home<http://www.askdbmgt.com/>;
www.askdbmgt.com
Database Consulting and Support ... This is the site for Art S. Kagel's
consultancy. The soaring majesty and beauty in the image above hides the
complex ecology and ...
ASK Database Management - Home<http://www.askdbmgt.com/>;
ASK Database Management - Home<http://www.askdbmgt.com/>;
www.askdbmgt.com
Database Consulting and Support ... This is the site for Art S. Kagel's
consultancy. The soaring majesty and beauty in the image above hides the
complex ecology and ...
www.askdbmgt.com<http://www.askdbmgt.com>;
ASK Database Management - Home<http://www.askdbmgt.com/>;
www.askdbmgt.com
Database Consulting and Support ... This is the site for Art S. Kagel's
consultancy. The soaring majesty and beauty in the image above hides the
complex ecology and ...
Database Consulting and Support ... This is the site for Art S. Kagel's
consultancy. The soaring majesty and beauty in the image above hides the
complex ecology and ...
> www.askdbmgt.com<http://www.askdbmgt.com>;
ASK Database Mana
something to do with logical log? or a long checkpoint is occurring...?do:
onstat -l to see if your logical logs are backed up.
clear your statistics: onstat -zthen: onstat -g iof -r | grep -v 0.0 to see ifthere are i/o going on.... Let's go GreenThis email contains 100% recycled
electrons.
From: LARRY SORENSEN <LSORENSEN25@msn.com>
To: ids@iiug.org
Sent: Tuesday, April 25, 2017 1:16 PM
Subject: Re: Can you resize a dbspace? [39033]
I was able to get replication going from the below process. I then had to
switch the Primary and secondary.
I took the Primary offline.
I ran hdrmkpri.sh new_sec_name
This takes the new primary offline.
I then ran hdrmksec.sh new_pri_name.
Toward the end of the script it asks me to bring the primary online so they
can sink. I did.
It looked like everything was working.
Logical Recovery Started.
24 Recovery worker threads will be started.
Start Logical Recovery - Star Log 77121, End Log?
Starting Log Position - 77121 0x7a60bc
DR: Cleared 28550 KB of Logical log in - seconds.
After that the secondary remains in Fast Recovery (Sec)
The primary remains in -- On-Line (Prim) (CKPT REQ) -- Blocked:CKPT
Any ideas?
Larry
________________________________
From: ids-bounces@iiug.org <ids-bounces@iiug.org> on behalf of LARRY SORENSEN
<LSORENSEN25@msn.com>
Sent: Monday, April 24, 2017 10:27 PM
To: ids@iiug.org
Subject: Re: Can you resize a dbspace? [39026]
Thank you, both of you. I can watch the final dbspaces filling with doing
onstat -D every so often and doing a diff on results. I was just worried thatnothing was happening.
Larry
________________________________
From: ids-bounces@iiug.org <ids-bounces@iiug.org> on behalf of Art Kagel
<art.kagel@gmail.com>
Sent: Monday, April 24, 2017 8:38 PM
To: ids@iiug.org
Subject: Re: Can you resize a dbspace? [39024]
No and no.
Art
Art S. Kagel, President and Principal Consultant
ASK Database Management
www.askdbmgt.com<http://www.askdbmgt.com>;
ASK Database Management - Home<http://www.askdbmgt.com/>;
www.askdbmgt.com
Database Consulting and Support ... This is the site for Art S. Kagel's
consultancy. The soaring majesty and beauty in the image above hides the
complex ecology and ...
ASK Database Management - Home<http://www.askdbmgt.com/>;
ASK Database Management - Home<http://www.askdbmgt.com/>;
www.askdbmgt.com
Database Consulting and Support ... This is the site for Art S. Kagel's
consultancy. The soaring majesty and beauty in the image above hides the
complex ecology and ...
www.askdbmgt.com<http://www.askdbmgt.com>;
ASK Database Management - Home<http://www.askdbmgt.com/>;
www.askdbmgt.com
Database Consulting and Support ... This is the site for Art S. Kagel's
consultancy. The soaring majesty and beauty in the image above hides the
complex ecology and ...
Database Consulting and Support ... This is the site for Art S. Kagel's
consultancy. The soaring majesty and beauty in the image above hides the
complex ecology and ...
Blog: http://informix-myview.blogspot.com/
Informix - My view<http://informix-myview.blogspot.com/>;
informix-myview.blogspot.com
A place to share my views and ideas which may be of interest to the Informix
user Community.
Informix - My view<http://informix-myview.blogspot.com/>;
Informix - My view<http://informix-myview.blogspot.com/>;
informix-myview.blogspot.com
A place to share my views and ideas which may be of interest to the Informix
user Community.
informix-myview.blogspot.com
A place to share my views and ideas which may be of interest to the Informix
user Community.
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, Apr 24, 2017 at 10:11 PM, LARRY SORENSEN <LSORENSEN25@msn.com>
wrote:
> Should an onstat -D show exactly the same results on both the primary and
> the
> secondary?
>
> Also, I am just letting it overwrite a previous copy of the database. Do
> you
> see any issues with this?
>
> Larry
>
> ________________________________
> From: ids-bounces@iiug.org <ids-bounces@iiug.org> on behalf of Art Kagel
> <art.kagel@gmail.com>
> Sent: Monday, April 24, 2017 7:54 PM
> To: ids@iiug.org
> Subject: Re: Can you resize a dbspace? [39019]
>
> On the secondary you can run "onstat -D" and see which chunks have already
> been written out. The restore restores one dbspaces at a time in dbsnum
> order writting to all chunks in each dbspace before moving on to the next
> dbspace. So, you can tell how far the restore has progressed. Note that
> the number of pages that will be written to each chunk will be roughly the
> number of used pages in that chunk (from onstat -d) plus a few pages for
> the physical log pages that overwrite pages modified during the archive to
> return them to their condition as of the beginning of the archive.
>
> Art
>
> Art S. Kagel, President and Principal Consultant
> ASK Database Management
> www.askdbmgt.com<http://www.askdbmgt.com>;
ASK Database Management - Home<http://www.askdbmgt.com/>;
www.askdbmgt.com
Database Consulting and Support ... This is the site for Art S. Kagel's
consultancy. The soaring majesty and beauty in the image above hides the
complex ecology and ...
ASK Database Management - Home<http://www.askdbmgt.com/>;
ASK Database Management - Home<http://www.askdbmgt.com/>;
www.askdbmgt.com
Database Consulting and Support ... This is the site for Art S. Kagel's
consultancy. The soaring majesty and beauty in the image above hides the
complex ecology and ...
www.askdbmgt.com<http://www.askdbmgt.com>;
ASK Database Management - Home<http://www.askdbmgt.com/>;
www.askdbmgt.com
Database Consulting and Support ... This is the site for Art S. Kagel's
consultancy. The soaring majesty and beauty in the image above hides the
complex ecology and ...
Database Consulting and Support ... This is the site for Art S. Kagel's
consultancy. The soaring majesty and beauty in the image above hides the
complex ecology and ...
>
> ASK Database Management - Home<http://www.askdbmgt.com/>;
ASK Database Management - Home<http://www.askdbmgt.com/>;
www.askdbmgt.com
Database Consulting and Support ... This is the site for Art S. Kagel's
consultancy. The soaring majesty and beauty in the image above hides the
complex ecology and ...
ASK Database Management - Home<http://www.askdbmgt.com/>;
ASK Database Management - Home<http://www.askdbmgt.com/>;
www.askdbmgt.com
Database Consulting and Support ... This is the site for Art S. Kagel's
consultancy. The soaring majesty and beauty in the image above hides the
complex ecology and ...
www.askdbmgt.com<http://www.askdbmgt.com>;
ASK Database Management - Home<http://www
Larry,
Too late for this attempt but I quit using those scripts and now use the
following procedure to swap primary/secondary.
Old primary Old secondary
testaix05 ibm622
inf_ace_test inf_ace_test_622
on testaix05
onmode -ky
on ibm622
onmode -d make primary inf_ace_test_622
on testaix05
oninit -PHY
onmode -d secondary inf_ace_test_622
on ibm622
onmode -d primary inf_ace_test
New primary New secondary
ibm622 testaix05
inf_ace_test_622 inf_ace_test
Steps were repeated with names transversed to put them back to original setup.
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of LARRY
SORENSEN
Sent: Tuesday, April 25, 2017 1:16 PM
To: ids@iiug.org
Subject: Re: Can you resize a dbspace? [39033]
I was able to get replication going from the below process. I then had to
switch the Primary and secondary.
I took the Primary offline.
I ran hdrmkpri.sh new_sec_name
This takes the new primary offline.
I then ran hdrmksec.sh new_pri_name.
Toward the end of the script it asks me to bring the primary online so they
can sink. I did.
It looked like everything was working.
Logical Recovery Started.
24 Recovery worker threads will be started.
Start Logical Recovery - Star Log 77121, End Log?
Starting Log Position - 77121 0x7a60bc
DR: Cleared 28550 KB of Logical log in - seconds.
After that the secondary remains in Fast Recovery (Sec)
The primary remains in -- On-Line (Prim) (CKPT REQ) -- Blocked:CKPT
Any ideas?
Larry
________________________________
From: ids-bounces@iiug.org <ids-bounces@iiug.org> on behalf of LARRY SORENSEN
<LSORENSEN25@msn.com>
Sent: Monday, April 24, 2017 10:27 PM
To: ids@iiug.org
Subject: Re: Can you resize a dbspace? [39026]
Thank you, both of you. I can watch the final dbspaces filling with doing
onstat -D every so often and doing a diff on results. I was just worried thatnothing was happening.
Larry
________________________________
From: ids-bounces@iiug.org <ids-bounces@iiug.org> on behalf of Art Kagel
<art.kagel@gmail.com>
Sent: Monday, April 24, 2017 8:38 PM
To: ids@iiug.org
Subject: Re: Can you resize a dbspace? [39024]
No and no.
Art
Art S. Kagel, President and Principal Consultant ASK Database Management
www.askdbmgt.com<http://www.askdbmgt.com>;
ASK Database Management - Home<http://www.askdbmgt.com/>; www.askdbmgt.com
Database Consulting and Support ... This is the site for Art S. Kagel's
consultancy. The soaring majesty and beauty in the image above hides the
complex ecology and ...
ASK Database Management - Home<http://www.askdbmgt.com/>;
ASK Database Management - Home<http://www.askdbmgt.com/>; www.askdbmgt.com
Database Consulting and Support ... This is the site for Art S. Kagel's
consultancy. The soaring majesty and beauty in the image above hides the
complex ecology and ...
www.askdbmgt.com<http://www.askdbmgt.com>;
ASK Database Management - Home<http://www.askdbmgt.com/>; www.askdbmgt.com
Database Consulting and Support ... This is the site for Art S. Kagel's
consultancy. The soaring majesty and beauty in the image above hides the
complex ecology and ...
Database Consulting and Support ... This is the site for Art S. Kagel's
consultancy. The soaring majesty and beauty in the image above hides the
complex ecology and ...
Blog: http://informix-myview.blogspot.com/
Informix - My view<http://informix-myview.blogspot.com/>;
informix-myview.blogspot.com
A place to share my views and ideas which may be of interest to the Informix
user Community.
Informix - My view<http://informix-myview.blogspot.com/>;
Informix - My view<http://informix-myview.blogspot.com/>;
informix-myview.blogspot.com
A place to share my views and ideas which may be of interest to the Informix
user Community.
informix-myview.blogspot.com
A place to share my views and ideas which may be of interest to the Informix
user Community.
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, Apr 24, 2017 at 10:11 PM, LARRY SORENSEN <LSORENSEN25@msn.com>
wrote:
> Should an onstat -D show exactly the same results on both the primary
> and the secondary?
>
> Also, I am just letting it overwrite a previous copy of the database.
> Do you see any issues with this?
>
> Larry
>
> ________________________________
> From: ids-bounces@iiug.org <ids-bounces@iiug.org> on behalf of Art
> Kagel <art.kagel@gmail.com>
> Sent: Monday, April 24, 2017 7:54 PM
> To: ids@iiug.org
> Subject: Re: Can you resize a dbspace? [39019]
>
> On the secondary you can run "onstat -D" and see which chunks have
> already been written out. The restore restores one dbspaces at a time
> in dbsnum order writting to all chunks in each dbspace before moving
> on to the next dbspace. So, you can tell how far the restore has
> progressed. Note that the number of pages that will be written to each
> chunk will be roughly the number of used pages in that chunk (from
> onstat -d) plus a few pages for the physical log pages that overwrite> pages modified during the archive to return them to their condition as of
the beginning of the archive.
>
> Art
>
> Art S. Kagel, President and Principal Consultant ASK Database
> Management www.askdbmgt.com<http://www.askdbmgt.com>;
ASK Database Management - Home<http://www.askdbmgt.com/>; www.askdbmgt.com
Database Consulting and Support ... This is the site for Art S. Kagel's
consultancy. The soaring majesty and beauty in the image above hides the
complex ecology and ...
ASK Database Management - Home<http://www.askdbmgt.com/>;
ASK Database Management - Home<http://www.askdbmgt.com/>; www.askdbmgt.com
Database Consulting and Support ... This is the site for Art S. Kagel's
consultancy. The soaring majesty and beauty in the image above hides the
complex ecology and ...
www.askdbmgt.com<http://www.askdbmgt.com>;
ASK Database Management - Home<http://www.askdbmgt.com/>; www.askdbmgt.com
Database Consulting and Support ... This is the site for Art S. Kagel's
consultancy. The soaring majesty and beauty in the image above hides the
complex ecology and ...
Database Consulting and Support ... This is the site for Art S. Kagel's
consultancy. The soaring majesty and beauty in the image above hides the
complex ecology and ...
>
> ASK Database Management - Home<http://www.askdbmgt.com/>;
ASK Database Management - Home<http://www.askdbmgt.com/>; www.askdbmgt.com
Database Consulting and Support ... This is the site for Art S. Kagel's
consultancy. The soaring majesty and beauty in the image above hides the
complex ecology and ...
ASK Database Management - Hom
I was able to get replication going from the below process. I then had to
switch the Primary and secondary.
I took the Primary offline.
I ran hdrmkpri.sh new_sec_name
This takes the new primary offline.
I then ran hdrmksec.sh new_pri_name.
Toward the end of the script it asks me to bring the primary online so they
can sink. I did.
It looked like everything was working.
Logical Recovery Started.
24 Recovery worker threads will be started.
Start Logical Recovery - Star Log 77121, End Log?
Starting Log Position - 77121 0x7a60bc
DR: Cleared 28550 KB of Logical log in - seconds.
After that the secondary remains in Fast Recovery (Sec)
The primary remains in -- On-Line (Prim) (CKPT REQ) -- Blocked:CKPT
Any ideas?
Larry
________________________________
From: ids-bounces@iiug.org <ids-bounces@iiug.org> on behalf of LARRY SORENSEN
<LSORENSEN25@msn.com>
Sent: Monday, April 24, 2017 10:27 PM
To: ids@iiug.org
Subject: Re: Can you resize a dbspace? [39026]
Thank you, both of you. I can watch the final dbspaces filling with doing
onstat -D every so often and doing a diff on results. I was just worried thatnothing was happening.
Larry
________________________________
From: ids-bounces@iiug.org <ids-bounces@iiug.org> on behalf of Art Kagel
<art.kagel@gmail.com>
Sent: Monday, April 24, 2017 8:38 PM
To: ids@iiug.org
Subject: Re: Can you resize a dbspace? [39024]
No and no.
Art
Art S. Kagel, President and Principal Consultant
ASK Database Management
www.askdbmgt.com<http://www.askdbmgt.com>;
ASK Database Management - Home<http://www.askdbmgt.com/>;
www.askdbmgt.com
Database Consulting and Support ... This is the site for Art S. Kagel's
consultancy. The soaring majesty and beauty in the image above hides the
complex ecology and ...
ASK Database Management - Home<http://www.askdbmgt.com/>;
ASK Database Management - Home<http://www.askdbmgt.com/>;
www.askdbmgt.com
Database Consulting and Support ... This is the site for Art S. Kagel's
consultancy. The soaring majesty and beauty in the image above hides the
complex ecology and ...
www.askdbmgt.com<http://www.askdbmgt.com>;
ASK Database Management - Home<http://www.askdbmgt.com/>;
www.askdbmgt.com
Database Consulting and Support ... This is the site for Art S. Kagel's
consultancy. The soaring majesty and beauty in the image above hides the
complex ecology and ...
Database Consulting and Support ... This is the site for Art S. Kagel's
consultancy. The soaring majesty and beauty in the image above hides the
complex ecology and ...
Blog: http://informix-myview.blogspot.com/
Informix - My view<http://informix-myview.blogspot.com/>;
informix-myview.blogspot.com
A place to share my views and ideas which may be of interest to the Informix
user Community.
Informix - My view<http://informix-myview.blogspot.com/>;
Informix - My view<http://informix-myview.blogspot.com/>;
informix-myview.blogspot.com
A place to share my views and ideas which may be of interest to the Informix
user Community.
informix-myview.blogspot.com
A place to share my views and ideas which may be of interest to the Informix
user Community.
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, Apr 24, 2017 at 10:11 PM, LARRY SORENSEN <LSORENSEN25@msn.com>
wrote:
> Should an onstat -D show exactly the same results on both the primary and
> the
> secondary?
>
> Also, I am just letting it overwrite a previous copy of the database. Do
> you
> see any issues with this?
>
> Larry
>
> ________________________________
> From: ids-bounces@iiug.org <ids-bounces@iiug.org> on behalf of Art Kagel
> <art.kagel@gmail.com>
> Sent: Monday, April 24, 2017 7:54 PM
> To: ids@iiug.org
> Subject: Re: Can you resize a dbspace? [39019]
>
> On the secondary you can run "onstat -D" and see which chunks have already
> been written out. The restore restores one dbspaces at a time in dbsnum
> order writting to all chunks in each dbspace before moving on to the next
> dbspace. So, you can tell how far the restore has progressed. Note that
> the number of pages that will be written to each chunk will be roughly the
> number of used pages in that chunk (from onstat -d) plus a few pages for
> the physical log pages that overwrite pages modified during the archive to
> return them to their condition as of the beginning of the archive.
>
> Art
>
> Art S. Kagel, President and Principal Consultant
> ASK Database Management
> www.askdbmgt.com<http://www.askdbmgt.com>;
ASK Database Management - Home<http://www.askdbmgt.com/>;
www.askdbmgt.com
Database Consulting and Support ... This is the site for Art S. Kagel's
consultancy. The soaring majesty and beauty in the image above hides the
complex ecology and ...
ASK Database Management - Home<http://www.askdbmgt.com/>;
ASK Database Management - Home<http://www.askdbmgt.com/>;
www.askdbmgt.com
Database Consulting and Support ... This is the site for Art S. Kagel's
consultancy. The soaring majesty and beauty in the image above hides the
complex ecology and ...
www.askdbmgt.com<http://www.askdbmgt.com>;
ASK Database Management - Home<http://www.askdbmgt.com/>;
www.askdbmgt.com
Database Consulting and Support ... This is the site for Art S. Kagel's
consultancy. The soaring majesty and beauty in the image above hides the
complex ecology and ...
Database Consulting and Support ... This is the site for Art S. Kagel's
consultancy. The soaring majesty and beauty in the image above hides the
complex ecology and ...
>
> ASK Database Management - Home<http://www.askdbmgt.com/>;
ASK Database Management - Home<http://www.askdbmgt.com/>;
www.askdbmgt.com
Database Consulting and Support ... This is the site for Art S. Kagel's
consultancy. The soaring majesty and beauty in the image above hides the
complex ecology and ...
ASK Database Management - Home<http://www.askdbmgt.com/>;
ASK Database Management - Home<http://www.askdbmgt.com/>;
www.askdbmgt.com
Database Consulting and Support ... This is the site for Art S. Kagel's
consultancy. The soaring majesty and beauty in the image above hides the
complex ecology and ...
www.askdbmgt.com<http://www.askdbmgt.com>;
ASK Database Management - Home<http://www.askdbmgt.com/>;
www.askdbmgt.com
Database Consulting and Support ... This is the site for Art S. Kagel's
consultancy. The soaring majesty and beauty in the image above hides the
complex ecology and ...
Database Consulting and Support ... This is the site for Art S. Kagel's
consultancy. The soaring majesty and beauty in the image above hides the
complex ecology and ...
> www.askdbmgt.com<http://www.askdbmgt.com>;
ASK Database Mana
what is in the online.log of the primary ?
Shutdown the secondary instance for test (onmode -ky), it might block the
checkpoint of the primary.
Marcus Haarmann
Von: "LARRY SORENSEN" <LSORENSEN25@msn.com>
An: "ids" <ids@iiug.org>
Gesendet: Dienstag, 25. April 2017 19:36:41
Betreff: Fw: Can you resize a dbspace? HDR swap primary.... [39036]
I was able to get replication going from the below process. I then had to
switch the Primary and secondary.
I took the Primary offline.
I ran hdrmkpri.sh new_sec_name
This takes the new primary offline.
I then ran hdrmksec.sh new_pri_name.
Toward the end of the script it asks me to bring the primary online so they
can sink. I did.
It looked like everything was working.
Logical Recovery Started.
24 Recovery worker threads will be started.
Start Logical Recovery - Star Log 77121, End Log?
Starting Log Position - 77121 0x7a60bc
DR: Cleared 28550 KB of Logical log in - seconds.
After that the secondary remains in Fast Recovery (Sec)
The primary remains in -- On-Line (Prim) (CKPT REQ) -- Blocked:CKPT
Any ideas?
Larry
________________________________
From: ids-bounces@iiug.org <ids-bounces@iiug.org> on behalf of LARRY SORENSEN
<LSORENSEN25@msn.com>
Sent: Monday, April 24, 2017 10:27 PM
To: ids@iiug.org
Subject: Re: Can you resize a dbspace? [39026]
Thank you, both of you. I can watch the final dbspaces filling with doing
onstat -D every so often and doing a diff on results. I was just worried thatnothing was happening.
Larry
________________________________
From: ids-bounces@iiug.org <ids-bounces@iiug.org> on behalf of Art Kagel
<art.kagel@gmail.com>
Sent: Monday, April 24, 2017 8:38 PM
To: ids@iiug.org
Subject: Re: Can you resize a dbspace? [39024]
No and no.
Art
Art S. Kagel, President and Principal Consultant
ASK Database Management
www.askdbmgt.com<http://www.askdbmgt.com>;
ASK Database Management - Home<http://www.askdbmgt.com/>;
www.askdbmgt.com
Database Consulting and Support ... This is the site for Art S. Kagel's
consultancy. The soaring majesty and beauty in the image above hides the
complex ecology and ...
ASK Database Management - Home<http://www.askdbmgt.com/>;
ASK Database Management - Home<http://www.askdbmgt.com/>;
www.askdbmgt.com
Database Consulting and Support ... This is the site for Art S. Kagel's
consultancy. The soaring majesty and beauty in the image above hides the
complex ecology and ...
www.askdbmgt.com<http://www.askdbmgt.com>;
ASK Database Management - Home<http://www.askdbmgt.com/>;
www.askdbmgt.com
Database Consulting and Support ... This is the site for Art S. Kagel's
consultancy. The soaring majesty and beauty in the image above hides the
complex ecology and ...
Database Consulting and Support ... This is the site for Art S. Kagel's
consultancy. The soaring majesty and beauty in the image above hides the
complex ecology and ...
Blog: http://informix-myview.blogspot.com/
Informix - My view<http://informix-myview.blogspot.com/>;
informix-myview.blogspot.com
A place to share my views and ideas which may be of interest to the Informix
user Community.
Informix - My view<http://informix-myview.blogspot.com/>;
Informix - My view<http://informix-myview.blogspot.com/>;
informix-myview.blogspot.com
A place to share my views and ideas which may be of interest to the Informix
user Community.
informix-myview.blogspot.com
A place to share my views and ideas which may be of interest to the Informix
user Community.
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, Apr 24, 2017 at 10:11 PM, LARRY SORENSEN <LSORENSEN25@msn.com>
wrote:
> Should an onstat -D show exactly the same results on both the primary and
> the
> secondary?
>
> Also, I am just letting it overwrite a previous copy of the database. Do
> you
> see any issues with this?
>
> Larry
>
> ________________________________
> From: ids-bounces@iiug.org <ids-bounces@iiug.org> on behalf of Art Kagel
> <art.kagel@gmail.com>
> Sent: Monday, April 24, 2017 7:54 PM
> To: ids@iiug.org
> Subject: Re: Can you resize a dbspace? [39019]
>
> On the secondary you can run "onstat -D" and see which chunks have already
> been written out. The restore restores one dbspaces at a time in dbsnum
> order writting to all chunks in each dbspace before moving on to the next
> dbspace. So, you can tell how far the restore has progressed. Note that
> the number of pages that will be written to each chunk will be roughly the
> number of used pages in that chunk (from onstat -d) plus a few pages for
> the physical log pages that overwrite pages modified during the archive to
> return them to their condition as of the beginning of the archive.
>
> Art
>
> Art S. Kagel, President and Principal Consultant
> ASK Database Management
> www.askdbmgt.com<http://www.askdbmgt.com>;
ASK Database Management - Home<http://www.askdbmgt.com/>;
www.askdbmgt.com
Database Consulting and Support ... This is the site for Art S. Kagel's
consultancy. The soaring majesty and beauty in the image above hides the
complex ecology and ...
ASK Database Management - Home<http://www.askdbmgt.com/>;
ASK Database Management - Home<http://www.askdbmgt.com/>;
www.askdbmgt.com
Database Consulting and Support ... This is the site for Art S. Kagel's
consultancy. The soaring majesty and beauty in the image above hides the
complex ecology and ...
www.askdbmgt.com<http://www.askdbmgt.com>;
ASK Database Management - Home<http://www.askdbmgt.com/>;
www.askdbmgt.com
Database Consulting and Support ... This is the site for Art S. Kagel's
consultancy. The soaring majesty and beauty in the image above hides the
complex ecology and ...
Database Consulting and Support ... This is the site for Art S. Kagel's
consultancy. The soaring majesty and beauty in the image above hides the
complex ecology and ...
>
> ASK Database Management - Home<http://www.askdbmgt.com/>;
ASK Database Management - Home<http://www.askdbmgt.com/>;
www.askdbmgt.com
Database Consulting and Support ... This is the site for Art S. Kagel's
consultancy. The soaring majesty and beauty in the image above hides the
complex ecology and ...
ASK Database Management - Home<http://www.askdbmgt.com/>;
ASK Database Management - Home<http://www.askdbmgt.com/>;
www.askdbmgt.com
Database Consulting and Support ... This is the site for Art S. Kagel's
consultancy. The soaring majesty and beauty in the image above hides the
complex ecology and ...
www.askdbmgt.com<http://www.askdbmgt.com>;
ASK Database Management - Home<http://www.askdbmgt.com/>;
www.askdbmgt.com
Database Consulting and Support .
The secondary was blocking the checkpoint of the primary. Apparently, someone
unplugged a network cable in the middle of the final logical log download to
the secondary. This caused the secondary to be in a bad state. I had Support
log in and see if they could fix it, but alas they couldn't. Now my new
primary is up, but I am going through the 30 hour process of restarting
replication to the corrupt secondary.
Such is life.
Thanks to all those who helped.
Larry
________________________________
From: ids-bounces@iiug.org <ids-bounces@iiug.org> on behalf of Marcus Haarmann
<marcus.haarmann@midoco.de>
Sent: Tuesday, April 25, 2017 2:39 PM
To: ids@iiug.org
Subject: Re: Can you resize a dbspace? HDR swap primary.... [39039]
what is in the online.log of the primary ?
Shutdown the secondary instance for test (onmode -ky), it might block the
checkpoint of the primary.
Marcus Haarmann
Von: "LARRY SORENSEN" <LSORENSEN25@msn.com>
An: "ids" <ids@iiug.org>
Gesendet: Dienstag, 25. April 2017 19:36:41
Betreff: Fw: Can you resize a dbspace? HDR swap primary.... [39036]
I was able to get replication going from the below process. I then had to
switch the Primary and secondary.
I took the Primary offline.
I ran hdrmkpri.sh new_sec_name
This takes the new primary offline.
I then ran hdrmksec.sh new_pri_name.
Toward the end of the script it asks me to bring the primary online so they
can sink. I did.
It looked like everything was working.
Logical Recovery Started.
24 Recovery worker threads will be started.
Start Logical Recovery - Star Log 77121, End Log?
Starting Log Position - 77121 0x7a60bc
DR: Cleared 28550 KB of Logical log in - seconds.
After that the secondary remains in Fast Recovery (Sec)
The primary remains in -- On-Line (Prim) (CKPT REQ) -- Blocked:CKPT
Any ideas?
Larry
________________________________
From: ids-bounces@iiug.org <ids-bounces@iiug.org> on behalf of LARRY SORENSEN
<LSORENSEN25@msn.com>
Sent: Monday, April 24, 2017 10:27 PM
To: ids@iiug.org
Subject: Re: Can you resize a dbspace? [39026]
Thank you, both of you. I can watch the final dbspaces filling with doing
onstat -D every so often and doing a diff on results. I was just worried thatnothing was happening.
Larry
________________________________
From: ids-bounces@iiug.org <ids-bounces@iiug.org> on behalf of Art Kagel
<art.kagel@gmail.com>
Sent: Monday, April 24, 2017 8:38 PM
To: ids@iiug.org
Subject: Re: Can you resize a dbspace? [39024]
No and no.
Art
Art S. Kagel, President and Principal Consultant
ASK Database Management
www.askdbmgt.com<http://www.askdbmgt.com>;
ASK Database Management - Home<http://www.askdbmgt.com/>;
www.askdbmgt.com
Database Consulting and Support ... This is the site for Art S. Kagel's
consultancy. The soaring majesty and beauty in the image above hides the
complex ecology and ...
ASK Database Management - Home<http://www.askdbmgt.com/>;
ASK Database Management - Home<http://www.askdbmgt.com/>;
www.askdbmgt.com
Database Consulting and Support ... This is the site for Art S. Kagel's
consultancy. The soaring majesty and beauty in the image above hides the
complex ecology and ...
www.askdbmgt.com<http://www.askdbmgt.com>;
ASK Database Management - Home<http://www.askdbmgt.com/>;
www.askdbmgt.com
Database Consulting and Support ... This is the site for Art S. Kagel's
consultancy. The soaring majesty and beauty in the image above hides the
complex ecology and ...
Database Consulting and Support ... This is the site for Art S. Kagel's
consultancy. The soaring majesty and beauty in the image above hides the
complex ecology and ...
ASK Database Management - Home<http://www.askdbmgt.com/>;
ASK Database Management - Home<http://www.askdbmgt.com/>;
www.askdbmgt.com
Database Consulting and Support ... This is the site for Art S. Kagel's
consultancy. The soaring majesty and beauty in the image above hides the
complex ecology and ...
ASK Database Management - Home<http://www.askdbmgt.com/>;
ASK Database Management - Home<http://www.askdbmgt.com/>;
www.askdbmgt.com
Database Consulting and Support ... This is the site for Art S. Kagel's
consultancy. The soaring majesty and beauty in the image above hides the
complex ecology and ...
www.askdbmgt.com<http://www.askdbmgt.com>;
ASK Database Management - Home<http://www.askdbmgt.com/>;
www.askdbmgt.com
Database Consulting and Support ... This is the site for Art S. Kagel's
consultancy. The soaring majesty and beauty in the image above hides the
complex ecology and ...
Database Consulting and Support ... This is the site for Art S. Kagel's
consultancy. The soaring majesty and beauty in the image above hides the
complex ecology and ...
www.askdbmgt.com<http://www.askdbmgt.com>;
ASK Database Management - Home<http://www.askdbmgt.com/>;
www.askdbmgt.com
Database Consulting and Support ... This is the site for Art S. Kagel's
consultancy. The soaring majesty and beauty in the image above hides the
complex ecology and ...
ASK Database Management - Home<http://www.askdbmgt.com/>;
ASK Database Management - Home<http://www.askdbmgt.com/>;
www.askdbmgt.com
Database Consulting and Support ... This is the site for Art S. Kagel's
consultancy. The soaring majesty and beauty in the image above hides the
complex ecology and ...
www.askdbmgt.com<http://www.askdbmgt.com>;
ASK Database Management - Home<http://www.askdbmgt.com/>;
www.askdbmgt.com
Database Consulting and Support ... This is the site for Art S. Kagel's
consultancy. The soaring majesty and beauty in the image above hides the
complex ecology and ...
Database Consulting and Support ... This is the site for Art S. Kagel's
consultancy. The soaring majesty and beauty in the image above hides the
complex ecology and ...
Database Consulting and Support ... This is the site for Art S. Kagel's
consultancy. The soaring majesty and beauty in the image above hides the
complex ecology and ...
Blog: http://informix-myview.blogspot.com/
Informix - My view<http://informix-myview.blogspot.com/>;
informix-myview.blogspot.com
A place to share my views and ideas which may be of interest to the Informix
user Community.
Informix - My view<http://informix-myview.blogspot.com/>;
informix-myview.blogspot.com
A place to share my views and ideas which may be of interest to the Informix
user Community.
Informix - My view<http://informix-myview.blogspot.com/>;
Informix - My view<http://informix-myview.blogspot.com/>;
informix-myview.blogspot.com
A place to share my views and ideas which may be of interest to the Informix
user Community.
informix-myview.blogspot.com
A place to share my views and ideas which may be of interest to the Informix
user Community.
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
If your ntwk sucks then take a level 0 from primary, zip it, transfer over
secondary, restore, it may be faster?
> On Apr 25, 2017, at 5:53 PM, LARRY SORENSEN <LSORENSEN25@msn.com> wrote:
>
> The secondary was blocking the checkpoint of the primary. Apparently, someone
> unplugged a network cable in the middle of the final logical log download to
> the secondary. This caused the secondary to be in a bad state. I had Support
> log in and see if they could fix it, but alas they couldn't. Now my new
> primary is up, but I am going through the 30 hour process of restarting
> replication to the corrupt secondary.
>
> Such is life.
>
> Thanks to all those who helped.
>
> Larry
>
> ________________________________
> From: ids-bounces@iiug.org <ids-bounces@iiug.org> on behalf of Marcus
Haarmann
> <marcus.haarmann@midoco.de>
> Sent: Tuesday, April 25, 2017 2:39 PM
> To: ids@iiug.org
> Subject: Re: Can you resize a dbspace? HDR swap primary.... [39039]
>
> what is in the online.log of the primary ?
> Shutdown the secondary instance for test (onmode -ky), it might block the
> checkpoint of the primary.
>
> Marcus Haarmann
>
> Von: "LARRY SORENSEN" <LSORENSEN25@msn.com>
> An: "ids" <ids@iiug.org>
> Gesendet: Dienstag, 25. April 2017 19:36:41
> Betreff: Fw: Can you resize a dbspace? HDR swap primary.... [39036]
>
> I was able to get replication going from the below process. I then had to
> switch the Primary and secondary.
>
> I took the Primary offline.
>
> I ran hdrmkpri.sh new_sec_name
>
> This takes the new primary offline.
>
> I then ran hdrmksec.sh new_pri_name.
>
> Toward the end of the script it asks me to bring the primary online so they
> can sink. I did.
>
> It looked like everything was working.
>
> Logical Recovery Started.
>
> 24 Recovery worker threads will be started.
>
> Start Logical Recovery - Star Log 77121, End Log?
>
> Starting Log Position - 77121 0x7a60bc
>
> DR: Cleared 28550 KB of Logical log in - seconds.
>
> After that the secondary remains in Fast Recovery (Sec)
>
> The primary remains in -- On-Line (Prim) (CKPT REQ) -- Blocked:CKPT
>
> Any ideas?
>
> Larry
>
> ________________________________
> From: ids-bounces@iiug.org <ids-bounces@iiug.org> on behalf of LARRY SORENSEN
> <LSORENSEN25@msn.com>
> Sent: Monday, April 24, 2017 10:27 PM
> To: ids@iiug.org
> Subject: Re: Can you resize a dbspace? [39026]
>
> Thank you, both of you. I can watch the final dbspaces filling with doing
> onstat -D every so often and doing a diff on results. I was just worried that> nothing was happening.
>
> Larry
>
> ________________________________
> From: ids-bounces@iiug.org <ids-bounces@iiug.org> on behalf of Art Kagel
> <art.kagel@gmail.com>
> Sent: Monday, April 24, 2017 8:38 PM
> To: ids@iiug.org
> Subject: Re: Can you resize a dbspace? [39024]
>
> No and no.
>
> Art
>
> Art S. Kagel, President and Principal Consultant
> ASK Database Management
> www.askdbmgt.com<http://www.askdbmgt.com>;
>
> ASK Database Management - Home<http://www.askdbmgt.com/>;
> www.askdbmgt.com
> Database Consulting and Support ... This is the site for Art S. Kagel's
> consultancy. The soaring majesty and beauty in the image above hides the
> complex ecology and ...
>
> ASK Database Management - Home<http://www.askdbmgt.com/>;
>
> ASK Database Management - Home<http://www.askdbmgt.com/>;
> www.askdbmgt.com
> Database Consulting and Support ... This is the site for Art S. Kagel's
> consultancy. The soaring majesty and beauty in the image above hides the
> complex ecology and ...
>
> www.askdbmgt.com<http://www.askdbmgt.com>;
>
> ASK Database Management - Home<http://www.askdbmgt.com/>;
> www.askdbmgt.com
> Database Consulting and Support ... This is the site for Art S. Kagel's
> consultancy. The soaring majesty and beauty in the image above hides the
> complex ecology and ...
>
> Database Consulting and Support ... This is the site for Art S. Kagel's
> consultancy. The soaring majesty and beauty in the image above hides the
> complex ecology and ...
>
> ASK Database Management - Home<http://www.askdbmgt.com/>;
>
> ASK Database Management - Home<http://www.askdbmgt.com/>;
> www.askdbmgt.com
> Database Consulting and Support ... This is the site for Art S. Kagel's
> consultancy. The soaring majesty and beauty in the image above hides the
> complex ecology and ...
>
> ASK Database Management - Home<http://www.askdbmgt.com/>;
>
> ASK Database Management - Home<http://www.askdbmgt.com/>;
> www.askdbmgt.com
> Database Consulting and Support ... This is the site for Art S. Kagel's
> consultancy. The soaring majesty and beauty in the image above hides the
> complex ecology and ...
>
> www.askdbmgt.com<http://www.askdbmgt.com>;
>
> ASK Database Management - Home<http://www.askdbmgt.com/>;
> www.askdbmgt.com
> Database Consulting and Support ... This is the site for Art S. Kagel's
> consultancy. The soaring majesty and beauty in the image above hides the
> complex ecology and ...
>
> Database Consulting and Support ... This is the site for Art S. Kagel's
> consultancy. The soaring majesty and beauty in the image above hides the
> complex ecology and ...
>
> www.askdbmgt.com<http://www.askdbmgt.com>;
>
> ASK Database Management - Home<http://www.askdbmgt.com/>;
> www.askdbmgt.com
> Database Consulting and Support ... This is the site for Art S. Kagel's
> consultancy. The soaring majesty and beauty in the image above hides the
> complex ecology and ...
>
> ASK Database Management - Home<http://www.askdbmgt.com/>;
>
> ASK Database Management - Home<http://www.askdbmgt.com/>;
> www.askdbmgt.com
> Database Consulting and Support ... This is the site for Art S. Kagel's
> consultancy. The soaring majesty and beauty in the image above hides the
> complex ecology and ...
>
> www.askdbmgt.com<http://www.askdbmgt.com>;
>
> ASK Database Management - Home<http://www.askdbmgt.com/>;
> www.askdbmgt.com
> Database Consulting and Support ... This is the site for Art S. Kagel's
> consultancy. The soaring majesty and beauty in the image above hides the
> complex ecology and ...
>
> Database Consulting and Support ... This is the site for Art S. Kagel's
> consultancy. The soaring majesty and beauty in the image above hides the
> complex ecology and ...
>
> Database Consulting and Support ... This is the site for Art S. Kagel's
> consultancy. The soaring majesty and beauty in the image above hides the
> complex ecology and ...
>
> Blog: http://informix-myview.blogspot.com/
>
> Informix - My view<http://informix-myview.blogspot.com/>;
> informix-myview.blogspot.com
> A place to share my views and ideas which may be of interest to the Informix
> user Community.
>
> Informix - My view<http://informix-myview.blogspot.com/>;
> informix-myview.blogspot.com
> A place to share my views and ideas which may be of interest to the Informix
> user Community.
>
> Informix - My view<http://informix-myview.blogspot.com/>;
>
> Informix - My view<htt
Related threads
- IDS 10 table-level restore
- Informix Development Webinar December 11, 2007
- ontape -p/r with changed ROOTPATH
- Migrate from HP PA-RISC to HP ITANIUM by ontape