Sysmaster Query on last stop/start
Hi, I attempting to find the sysmaster table and column that has the last start of IDS 7.3? Thanks in advance, Doug
Hi, I'm not sure of the sysmaster resource, but you can grep the online log for "Mode" and tail the output. -Chris "Doug Fossmeyer" <dfossmeyer@gmx.net> Sent by: forum.subscriber@iiug.org 05/11/2004 02:51 PM To ids@iiug.org cc Subject Sysmaster Query on last stop/start [2947] Hi, I attempting to find the sysmaster table and column that has the last start of IDS 7.3? Thanks in advance, Doug
--0__=88BBE402DFE49DD08f9e8a93df938690918c88BBE402DFE49DD0
Content-type: multipart/alternative;
Boundary="1__=88BBE402DFE49DD08f9e8a93df938690918c88BBE402DFE49DD0"
--1__=88BBE402DFE49DD08f9e8a93df938690918c88BBE402DFE49DD0
Content-type: text/plain; charset=US-ASCII
Content-transfer-encoding: quoted-printable
The table to look for is sysmaster:sysshmvals.boottime
onstat - will also print out the time since boot ...
Thanx much,
Rajib Sarkar
Advisory Software Engineer (RAS)
IBM Data Management Group
If we all did the things we are capable of doing, we would literally
astound ourselves. -- T. Edison
=
"chris.staub...." =
<chris.staubin@re =
ebok.com> =
To
Sent by: ids@iiug.org =
forum.subscriber@ =
cc
iiug.org =
Subj=
ect
Re: Sysmaster Query on last =
05/11/2004 01:49 stop/start [2948] =
PM =
=
=
=
=
=
Hi,
I'm not sure of the sysmaster resource, but you can grep the online log=
for "Mode" and tail the output.
-Chris
"Doug Fossmeyer" <dfossmeyer@gmx.net>
Sent by: forum.subscriber@iiug.org
05/11/2004 02:51 PM
To
ids@iiug.org
cc
Subject
Sysmaster Query on last stop/start [2947]
Hi, I attempting to find the sysmaster table and column that has the la=
st
start of IDS 7.3?
Thanks in advance,
Doug
=
--1__=88BBE402DFE49DD08f9e8a93df938690918c88BBE402DFE49DD0
Content-type: text/html; charset=US-ASCII
Content-Disposition: inline
Content-transfer-encoding: quoted-printable
<html><body>
<p>The table to look for is sysmaster:sysshmvals.boottime<br>
<br>
onstat - will also print out the time since boot ...<br>
<br>
Thanx much,<br>
<br>
Rajib Sarkar<br>
Advisory Software Engineer (RAS)<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:10__=3D88BBE402DFE49DD08f9e8a93df938@us.ibm.com" width=3D=
"16" height=3D"16" alt=3D"Inactive hide details for "chris.staub..=
.." <chris.staubin@reebok.com>">"chris.staub...." =
<chris.staubin@reebok.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:20__=3D88BBE40=
2DFE49DD08f9e8a93df938@us.ibm.com); background-repeat: no-repeat; " wid=
th=3D"40%">
<ul>
<ul>
<ul>
<ul><b><font size=3D"2">"chris.staub...." <chris.staubin@r=
eebok.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">05/11/2004 01:49 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:3=
0__=3D88BBE402DFE49DD08f9e8a93df938@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:30__=3D88BBE402DFE49DD08f9e8a93df938@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:3=
0__=3D88BBE402DFE49DD08f9e8a93df938@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:30__=3D88BBE402DFE49DD08f9e8a93df938@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:3=
0__=3D88BBE402DFE49DD08f9e8a93df938@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:30__=3D88BBE402DFE49DD08f9e8a93df938@us.ibm.=
com" border=3D"0" height=3D"1" width=3D"1" alt=3D""><br>
<font size=3D"2">Re: Sysmaster Query on last stop/start [2948]</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:30__=3D88BBE402DFE4=
9DD08f9e8a93df938@us.ibm.com" border=3D"0" height=3D"1" width=3D"1" alt=
=3D""></td><td width=3D"336"><img src=3D"cid:30__=3D88BBE402DFE49DD08f9=
e8a93df938@us.ibm.com" border=3D"0" height=3D"1" width=3D"1" alt=3D""><=
/td></tr>
</table>
</td></tr>
</table>
<br>
<tt>Hi,<br>
<br>
I'm not sure of the sysmaster resource, but you can grep the online log=
<br>
for "Mode" and tail the output.<br>
<br>
-Chris<br>
<br>
<br>
<br>
<br>
<br>
<br>
"Doug Fossmeyer" <dfossmeyer@gmx.net> <br>
Sent by: forum.subscriber@iiug.org<br>
05/11/2004 02:51 PM<br>
<br>
To<br>
ids@iiug.org<br>
cc<br>
<br>
Subject<br>
Sysmaster Query on last stop/start [2947]<br>
<br>
<br>
<br>
<br>
<br>
<br>
Hi, I attempting to find the sysmaster table and column that has the la=
st<br>
start of IDS 7.3?<br>
<br>
Thanks in advance,<br>
Doug<br>
<br>
<br>
<br>
<br>
<br>
</tt><br>
</body></html>=
--1__=88BBE402DFE49DD08f9e8a93df938690918c88BBE402DFE49DD0--
--0__=88BBE402DFE49DD08f9e8a93df938690918c88BBE402DFE49DD0
Content-type: image/gif;
name="graycol.gif"
Content-Disposition: inline; filename="graycol.gif"
Content-ID: <10__=88BBE402DFE49DD08f9e8a93df938@us.ibm.com>
Content-transfer-encoding: base64
R0lGODlhEAAQAKECAMzMzAAAAP///wAAACH5BAEAAAIALAAAAAAQABAAAAIXlI+py+0PopwxUbpu
ZRfKZ2zgSJbmSRYAIf4fT3B0aW1pemVkIGJ5IFVsZWFkIFNtYXJ0U2F2ZXIhAAA7
--0__=88BBE402DFE49DD08f9e8a93df938690918c88BBE402DFE49DD0
Content-type: image/gif;
name="pic13611.gif"
Content-Disposition: inline; filename="pic13611.gif"
Content-ID: <20__=88BBE402DFE49DD08f9e8a93df938@us.ibm.com>
Content-transfer-encoding: base64
R0lGODlhWABDALP/AAAAAK04Qf79/o+Gm7WuwlNObwoJFCsoSMDAwGFsmIuezf///wAAAAAAAAAA
AAAAACH5BAEAAAgALAAAAABYAEMAQAT/EMlJq704682770RiFMRinqggEUNSHIchG0BCfHhOjAuh
EDeUqTASLCbBh
--0__=08BBE402DFEB3D068f9e8a93df938690918c08BBE402DFEB3D06 Content-type: multipart/alternative; Boundary="1__=08BBE402DFEB3D068f9e8a93df938690918c08BBE402DFEB3D06" --1__=08BBE402DFEB3D068f9e8a93df938690918c08BBE402DFEB3D06 Content-type: text/plain; charset=US-ASCII Content-transfer-encoding: quoted-printable sysshmvals Mark Scranton Principal Consultant/Teacher IBM Denver IBM Software Group - Data Management Office: 303-773-5067 Cell: 303-929-0914 email: mscranto@us.ibm.com = "chris.staub...." = <chris.staubin@re = ebok.com> = To Sent by: ids@iiug.org = forum.subscriber@ = cc iiug.org = Subj= ect Re: Sysmaster Query on last = 05/11/2004 02:49 stop/start [2948] = PM = = = = = = Hi, I'm not sure of the sysmaster resource, but you can grep the online log= for "Mode" and tail the output. -Chris "Doug Fossmeyer" <dfossmeyer@gmx.net> Sent by: forum.subscriber@iiug.org 05/11/2004 02:51 PM To ids@iiug.org cc Subject Sysmaster Query on last stop/start [2947] Hi, I attempting to find the sysmaster table and column that has the la= st start of IDS 7.3? Thanks in advance, Doug = --1__=08BBE402DFEB3D068f9e8a93df938690918c08BBE402DFEB3D06 Content-type: text/html; charset=US-ASCII Content-Disposition: inline Content-transfer-encoding: quoted-printable <html><body> <p>sysshmvals<br> <br> Mark Scranton<br> Principal Consultant/Teacher<br> IBM Denver<br> <br> IBM Software Group - Data Management<br> Office: 303-773-5067<br> Cell: 303-929-0914<br> email: mscranto@us.ibm.com<br> <br> <br> <img src=3D"cid:10__=3D08BBE402DFEB3D068f9e8a93df938@us.ibm.com" width=3D= "16" height=3D"16" alt=3D"Inactive hide details for "chris.staub..= .." <chris.staubin@reebok.com>">"chris.staub...." = <chris.staubin@reebok.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:20__=3D08BBE40= 2DFEB3D068f9e8a93df938@us.ibm.com); background-repeat: no-repeat; " wid= th=3D"40%"> <ul> <ul> <ul> <ul><b><font size=3D"2">"chris.staub...." <chris.staubin@r= eebok.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">05/11/2004 02:49 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:3= 0__=3D08BBE402DFEB3D068f9e8a93df938@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:30__=3D08BBE402DFEB3D068f9e8a93df938@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:3= 0__=3D08BBE402DFEB3D068f9e8a93df938@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:30__=3D08BBE402DFEB3D068f9e8a93df938@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:3= 0__=3D08BBE402DFEB3D068f9e8a93df938@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:30__=3D08BBE402DFEB3D068f9e8a93df938@us.ibm.= com" border=3D"0" height=3D"1" width=3D"1" alt=3D""><br> <font size=3D"2">Re: Sysmaster Query on last stop/start [2948]</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:30__=3D08BBE402DFEB= 3D068f9e8a93df938@us.ibm.com" border=3D"0" height=3D"1" width=3D"1" alt= =3D""></td><td width=3D"336"><img src=3D"cid:30__=3D08BBE402DFEB3D068f9= e8a93df938@us.ibm.com" border=3D"0" height=3D"1" width=3D"1" alt=3D""><= /td></tr> </table> </td></tr> </table> <br> <tt>Hi,<br> <br> I'm not sure of the sysmaster resource, but you can grep the online log= <br> for "Mode" and tail the output.<br> <br> -Chris<br> <br> <br> <br> <br> <br> <br> "Doug Fossmeyer" <dfossmeyer@gmx.net> <br> Sent by: forum.subscriber@iiug.org<br> 05/11/2004 02:51 PM<br> <br> To<br> ids@iiug.org<br> cc<br> <br> Subject<br> Sysmaster Query on last stop/start [2947]<br> <br> <br> <br> <br> <br> <br> Hi, I attempting to find the sysmaster table and column that has the la= st<br> start of IDS 7.3?<br> <br> Thanks in advance,<br> Doug<br> <br> <br> <br> <br> <br> </tt><br> </body></html>= --1__=08BBE402DFEB3D068f9e8a93df938690918c08BBE402DFEB3D06-- --0__=08BBE402DFEB3D068f9e8a93df938690918c08BBE402DFEB3D06 Content-type: image/gif; name="graycol.gif" Content-Disposition: inline; filename="graycol.gif" Content-ID: <10__=08BBE402DFEB3D068f9e8a93df938@us.ibm.com> Content-transfer-encoding: base64 R0lGODlhEAAQAKECAMzMzAAAAP///wAAACH5BAEAAAIALAAAAAAQABAAAAIXlI+py+0PopwxUbpu ZRfKZ2zgSJbmSRYAIf4fT3B0aW1pemVkIGJ5IFVsZWFkIFNtYXJ0U2F2ZXIhAAA7 --0__=08BBE402DFEB3D068f9e8a93df938690918c08BBE402DFEB3D06 Content-type: image/gif; name="ecblank.gif" Content-Disposition: inline; filename="ecblank.gif" Content-ID: <30__=08BBE402DFEB3D068f9e8a93df938@us.ibm.com> Content-transfer-encoding: base64 R0lGODlhEAABAIAAAAAAAP///yH5BAEAAAEALAAAAAAQAAEAAAIEjI8ZBQA7 --0__=08BBE402DFEB3D068f9e8a93df938690918c08BBE402DFEB3D06--