Onspaces script
Does anyone have a script that can generate the onspaces commands for
an instance? I need to setup a replication server for HDR. I looked in the
IIUG software repository but could not find one.
I am currently using 9.20HC3 on an HP-UX 11.11 machine but will finally be
upgrding to 9.40 soon.
Thanks.
Kevin
You do not need to do this. To set replication, if
you use raw devices
(chunk), you need to define them and do a restore.
-----Original Message-----
From: KEVIN STRUC.... [mailto:kevin.struckhoff@newroads.com]
Sent: Thursday, December 30, 2004 2:10 PM
To: ids@iiug.org
Subject: Onspaces script [3945]
Does anyone have a script that can generate the onspaces commands for an
instance? I need to setup a replication server for HDR. I looked in the IIUG
software repository but could not find one.
I am currently using 9.20HC3 on an HP-UX 11.11 machine but will finally be
upgrding to 9.40 soon.
Thanks.
Kevin
Here's my version of it:
This SQL script example uses the sysmaster database to generate a shell
script called mkspaces.sh on a 2 kb page system. It's pretty easy to
change to also handle blobspaces, sbspaces and mirroring. It excludes
the creation of the root dbspace. Remember to change '* 2' to '* 4' on
aix and windoze.
unload to "/tmp/mkspaces.sh" delimiter ";"
select "onspaces -c -d " || trim(d.name)|| case when is_temp = 1 then " -t " else " " end
|| " -p " || trim(c.fname)
|| " -o " || c.offset * 2 || " -s " || c.chksize * 2
from sysdbspaces d, syschunks c
where d.fchunk = c.chknum
and d.is_blobspace = 0
and d.is_sbspace = 0
and d.dbsnum > 1
union all
select "onspaces -a " || trim(d.name)
|| " -p " || trim(c.fname)
|| " -o " || c.offset * 2 || " -s " || c.chksize * 2
from sysdbspaces d, syschunks c
where d.dbsnum = c.dbsnum
and d.nchunks > 1
and d.fchunk <> c.chknum
and d.is_blobspace = 0
and d.is_sbspace = 0;
Cheers,
Dick Snoke
Consulting IT Specialist
dsnoke@us.ibm.com
404 487 1595
"KEVIN STRUC...." <kevin.struckhoff@newroads.com>
Sent by: forum.subscriber@iiug.org
12/30/2004 02:10 PM
To
ids@iiug.org
cc
Subject
Onspaces script [3945]
Does anyone have a script that can generate the onspaces commands for an
instance? I need to setup a replication server for HDR. I looked in the
IIUG software repository but could not find one.
I am currently using 9.20HC3 on an HP-UX 11.11 machine but will finally be
upgrding to 9.40 soon.
Thanks.
Kevin
--0__=88BBE5E8DFC5244F8f9e8a93df938690918c88BBE5E8DFC5244F
Content-type: multipart/related;
Boundary="1__=88BBE5E8DFC5244F8f9e8a93df938690918c88BBE5E8DFC5244F"
--1__=88BBE5E8DFC5244F8f9e8a93df938690918c88BBE5E8DFC5244F
Content-type: multipart/alternative;
Boundary="2__=88BBE5E8DFC5244F8f9e8a93df938690918c88BBE5E8DFC5244F"
--2__=88BBE5E8DFC5244F8f9e8a93df938690918c88BBE5E8DFC5244F
Content-type: text/plain; charset=US-ASCII
Content-transfer-encoding: quoted-printable
Here u go ..
(See attached file: create_onspaces.ksh)
This script will either require a on-line system or a onstat -d output =
to
work on.
HTH
Thanx much,
Rajib Sarkar
Advisory Software Engineer
DB2/UDB Regional Advanced Support
IBM Data Management Group
If we all did the things we are capable of doing, we would literally
astound ourselves. -- T. Edison
=
"KEVIN STRUC...." =
<kevin.struckhoff =
@newroads.com> =
To
Sent by: ids@iiug.org =
forum.subscriber@ =
cc
iiug.org =
Subj=
ect
Onspaces script [3945] =
12/30/2004 12:10 =
PM =
=
=
=
=
Does anyone have a script that can generate the onspaces commands for a=
n
instance? I need to setup a replication server for HDR. I looked in the=
IIUG software repository but could not find one.
I am currently using 9.20HC3 on an HP-UX 11.11 machine but will finally=
be
upgrding to 9.40 soon.
Thanks.
Kevin
=
--2__=88BBE5E8DFC5244F8f9e8a93df938690918c88BBE5E8DFC5244F
Content-type: text/html; charset=US-ASCII
Content-Disposition: inline
Content-transfer-encoding: quoted-printable
<html><body>
<p>Here u go ..<br>
<br>
<i>(See attached file: create_onspaces.ksh)</i><br>
<br>
This script will either require a on-line system or a onstat -d output =
to work on. <br>
<br>
HTH<br>
<br>
Thanx much,<br>
<br>
Rajib Sarkar<br>
Advisory Software Engineer<br>
DB2/UDB Regional Advanced Support<br>
IBM Data Management Group<br>
<br>
<br>
If we all did the things we are capable of doing, we would literally as=
tound ourselves. -- T. Edison<br>
<br>
<img src=3D"cid:20__=3D88BBE5E8DFC5244F8f9e8a93df938@us.ibm.com" width=3D=
"16" height=3D"16" alt=3D"Inactive hide details for "KEVIN STRUC..=
.." <kevin.struckhoff@newroads.com>">"KEVIN STRUC....&q=
uot; <kevin.struckhoff@newroads.com><br>
<br>
<br>
<table width=3D"100%" border=3D"0" cellspacing=3D"0" cellpadding=3D"0">=
<tr valign=3D"top"><td style=3D"background-image:url(cid:30__=3D88BBE5E=
8DFC5244F8f9e8a93df938@us.ibm.com); background-repeat: no-repeat; " wid=
th=3D"40%">
<ul>
<ul>
<ul>
<ul><b><font size=3D"2">"KEVIN STRUC...." <kevin.struckhof=
f@newroads.com></font></b><font size=3D"2"> </font><br>
<font size=3D"2">Sent by: forum.subscriber@iiug.org</font>
<p><font size=3D"2">12/30/2004 12:10 PM</font></ul>
</ul>
</ul>
</ul>
</td><td width=3D"60%">
<table width=3D"100%" border=3D"0" cellspacing=3D"0" cellpadding=3D"0">=
<tr valign=3D"top"><td width=3D"1%" valign=3D"middle"><img src=3D"cid:4=
0__=3D88BBE5E8DFC5244F8f9e8a93df938@us.ibm.com" border=3D"0" height=3D"=
1" width=3D"58" alt=3D""><br>
<div align=3D"right"><font size=3D"2">To</font></div></td><td width=3D"=
100%"><img src=3D"cid:40__=3D88BBE5E8DFC5244F8f9e8a93df938@us.ibm.com" =
border=3D"0" height=3D"1" width=3D"1" alt=3D""><br>
<font size=3D"2">ids@iiug.org</font></td></tr>
<tr valign=3D"top"><td width=3D"1%" valign=3D"middle"><img src=3D"cid:4=
0__=3D88BBE5E8DFC5244F8f9e8a93df938@us.ibm.com" border=3D"0" height=3D"=
1" width=3D"58" alt=3D""><br>
<div align=3D"right"><font size=3D"2">cc</font></div></td><td width=3D"=
100%"><img src=3D"cid:40__=3D88BBE5E8DFC5244F8f9e8a93df938@us.ibm.com" =
border=3D"0" height=3D"1" width=3D"1" alt=3D""><br>
</td></tr>
<tr valign=3D"top"><td width=3D"1%" valign=3D"middle"><img src=3D"cid:4=
0__=3D88BBE5E8DFC5244F8f9e8a93df938@us.ibm.com" border=3D"0" height=3D"=
1" width=3D"58" alt=3D""><br>
<div align=3D"right"><font size=3D"2">Subject</font></div></td><td widt=
h=3D"100%"><img src=3D"cid:40__=3D88BBE5E8DFC5244F8f9e8a93df938@us.ibm.=
com" border=3D"0" height=3D"1" width=3D"1" alt=3D""><br>
<font size=3D"2">Onspaces script [3945]</font></td></tr>
</table>
<table border=3D"0" cellspacing=3D"0" cellpadding=3D"0">
<tr valign=3D"top"><td width=3D"58"><img src=3D"cid:40__=3D88BBE5E8DFC5=
244F8f9e8a93df938@us.ibm.com" border=3D"0" height=3D"1" width=3D"1" alt=
=3D""></td><td width=3D"336"><img src=3D"cid:40__=3D88BBE5E8DFC5244F8f9=
e8a93df938@us.ibm.com" border=3D"0" height=3D"1" width=3D"1" alt=3D""><=
/td></tr>
</table>
</td></tr>
</table>
<br>
<tt>Does anyone have a script that can generate the onspaces commands f=
or an instance? I need to setup a replication server for HDR. I looked =
in the IIUG software repository but could not find one.<br>
<br>
I am currently using 9.20HC3 on an HP-UX 11.11 machine but will finally=
be upgrding to 9.40 soon. <br>
<br>
Thanks.<br>
<br>
Kevin<br>
<br>
</tt><br>
</body></html>=
--2__=88BBE5E8DFC5244F8f9e8a93df938690918c88BBE5E8DFC5244F--
--1__=88BBE5E8DFC5244F8f9e8a93df938690918c88BBE5E8DFC5244F
Content-type: image/gif;
name="graycol.gif"
Content-Disposition: inline; filename="graycol.gif"
Content-ID: <20__=88BBE5E8DFC5244F8f9e8a93df938@us.ibm.com>
Content-transfer-encoding: base64
R0lGODlhEAAQAKECAMzMzAAAAP///wAAACH5BAEAAAIALAAAAAAQABAAAAIXlI+py+0PopwxUbpu
ZRfKZ2zgSJbmSRYAIf4fT3B0aW1pemVkIGJ5IFVsZWFkIFNtYXJ0U2F2ZXIhAAA7
--1__=88BBE5E8DFC5244F8f9e8a93df938690918c88BBE5E8DFC5244F
Content-type: image/gif;
name="pic06913.gif"
Content-Disposition: inline; filename="pic06913.gif"
Content-ID: <30__=88BBE5E8DFC5244F8f9e8a93df938@us.ibm.com>
Content-transfer-encoding: base64
R0lGODlhWABDALP/AAAAAK04Qf79/o+Gm7WuwlNObwoJFCsoSMDAwGFsmIuezf///wAAAAAAAAAA
AAAAACH5BAEAAAgALAAAAABYAEMAQAT/EMlJq704682770RiFMRinqggEUNSHIchG0BCfHhOjAuh
EDeUqTASLCbBhQrhG7xis2j0lssNDopE4jfIJhDaggI8YB1sZeZgLVA9YVCpnGagVjV171aRVrYR
RghXcAGFhoUETwYxcXNyADJ3GlcSKGAwLwllVC1vjIUHBWsFilKQdI8GA5IcpApeJQt8L09lmgkH
LZikoU5wjqcyAMMFrJIDPAKvCFletKSev1HBw8KrxtjZ2t
As long as you have the logical volumes present and
linked (hopefully
symbolic), you can just perform the restore. No need to initialize the
engine and add the spaces.
Mac
-----Original Message-----
From: forum.subscriber@iiug.org [mailto:forum.subscriber@iiug.org] On Behalf
Of KEVIN STRUC....
Sent: Thursday, December 30, 2004 12:10 PM
To: ids@iiug.org
Subject: Onspaces script [3945]
Does anyone have a script that can generate the onspaces commands for an
instance? I need to setup a replication server for HDR. I looked in the IIUG
software repository but could not find one.
I am currently using 9.20HC3 on an HP-UX 11.11 machine but will finally be
upgrding to 9.40 soon.
Thanks.
Kevin
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