Re: How can I tell when a column was added to a table?
--0__=88BBE4ECDFE7406A8f9e8a93df938690918c88BBE4ECDFE7406A
Content-type: multipart/alternative;
Boundary="1__=88BBE4ECDFE7406A8f9e8a93df938690918c88BBE4ECDFE7406A"
--1__=88BBE4ECDFE7406A8f9e8a93df938690918c88BBE4ECDFE7406A
Content-type: text/plain; charset=US-ASCII
Content-transfer-encoding: quoted-printable
Hi Gary,
For the when part, you can probably look through the logs to see when t=
he
ALTER TABLE was done. (look for PTALTER and the partnum of the table). =For
the who part, you will probably need to use the ONAUDIT tool (actually,=
you
can get the when part from that as well).
For what columns have changed ...that's a bit tricky (until and unless =
u
keep a history of dbschema outputs) .. I think the partition pages do s=
tore
the information in Slot #6 but its not straightforward ..it would requi=
re
interpretation until and unless someone's got a tool to interpret that
information.
HTH
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
=
Gary Quiring =
<gquiring@msn.com =
> =
To
Sent by: informix-list@iiug.org =
owner-informix-li =
cc
st@iiug.org =
Subj=
ect
How can I tell when a column was=
04/23/2004 10:42 added to a table? =
AM =
=
=
Please respond to =
Gary Quiring =
=
=
Is there a way to tell who and when a column or other properties were
changed on
a table using IDS 7.3?
Thanks
Gary Quiring
=
--1__=88BBE4ECDFE7406A8f9e8a93df938690918c88BBE4ECDFE7406A
Content-type: text/html; charset=US-ASCII
Content-Disposition: inline
Content-transfer-encoding: quoted-printable
<html><body>
<p>Hi Gary,<br>
For the when part, you can probably look through the logs to see when t=
he ALTER TABLE was done. (look for PTALTER and the partnum of the table=
). For the who part, you will probably need to use the ONAUDIT tool (ac=
tually, you can get the when part from that as well). <br>
<br>
For what columns have changed ...that's a bit tricky (until and unless =
u keep a history of dbschema outputs) .. I think the partition pages do=
store the information in Slot #6 but its not straightforward ..it woul=
d require interpretation until and unless someone's got a tool to inter=
pret that information.<br>
<br>
HTH<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__=3D88BBE4ECDFE7406A8f9e8a93df938@us.ibm.com" width=3D=
"16" height=3D"16" alt=3D"Inactive hide details for Gary Quiring <gq=
uiring@msn.com>">Gary Quiring <gquiring@msn.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__=3D88BBE4E=
CDFE7406A8f9e8a93df938@us.ibm.com); background-repeat: no-repeat; " wid=
th=3D"40%">
<ul>
<ul>
<ul>
<ul><b><font size=3D"2">Gary Quiring <gquiring@msn.com></font></b=
><font size=3D"2"> </font><br>
<font size=3D"2">Sent by: owner-informix-list@iiug.org</font>
<p><font size=3D"2">04/23/2004 10:42 AM</font>
<table border=3D"1">
<tr valign=3D"top"><td width=3D"168" bgcolor=3D"#FFFFFF"><div align=3D"=
center"><font size=3D"2">Please respond to<br>
Gary Quiring</font></div></td></tr>
</table>
</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__=3D88BBE4ECDFE7406A8f9e8a93df938@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__=3D88BBE4ECDFE7406A8f9e8a93df938@us.ibm.com" =
border=3D"0" height=3D"1" width=3D"1" alt=3D""><br>
<font size=3D"2">informix-list@iiug.org</font></td></tr>
<tr valign=3D"top"><td width=3D"1%" valign=3D"middle"><img src=3D"cid:3=
0__=3D88BBE4ECDFE7406A8f9e8a93df938@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__=3D88BBE4ECDFE7406A8f9e8a93df938@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__=3D88BBE4ECDFE7406A8f9e8a93df938@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__=3D88BBE4ECDFE7406A8f9e8a93df938@us.ibm.=
com" border=3D"0" height=3D"1" width=3D"1" alt=3D""><br>
<font size=3D"2">How can I tell when a column was added to a table?</fo=
nt></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__=3D88BBE4ECDFE7=
406A8f9e8a93df938@us.ibm.com" border=3D"0" height=3D"1" width=3D"1" alt=
=3D""></td><td width=3D"336"><img src=3D"cid:30__=3D88BBE4ECDFE7406A8f9=
e8a93df938@us.ibm.com" border=3D"0"
Rajib Sarkar <rsarkar@us.ibm.com> wrote in message
> Hi Gary,
> For the when part, you can probably look through the logs to see when t=
> he
> ALTER TABLE was done. (look for PTALTER and the partnum of the table). => For
> the who part, you will probably need to use the ONAUDIT tool (actually,=
> you
> can get the when part from that as well).
You can get the "who" part from the onlog output as well.
I have used this in the past to identify who is updating something
that changes the "version" in systables and hence causes the stored
procedures to re-optimise.
>
> For what columns have changed ...that's a bit tricky (until and unless =
> u
> keep a history of dbschema outputs) .. I think the partition pages do s=
> tore
> the information in Slot #6 but its not straightforward ..it would requi=
> re
> interpretation until and unless someone's got a tool to interpret that
> information.
>
> HTH
>
> 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
>
>
>
> =
>
> Gary Quiring =
>
> <gquiring@msn.com =
>
> > =
> To
> Sent by: informix-list@iiug.org =
>
> owner-informix-li =
> cc
> st@iiug.org =
>
> Subj=
> ect
> How can I tell when a column was=
>
> 04/23/2004 10:42 added to a table? =
>
> AM =
>
> =
>
> =
>
> Please respond to =
>
> Gary Quiring =
>
> =
>
> =
>
>
>
>
>
> Is there a way to tell who and when a column or other properties were
> changed on
> a table using IDS 7.3?
>
> Thanks
> Gary Quiring
>
> =
>
> --1__=88BBE4ECDFE7406A8f9e8a93df938690918c88BBE4ECDFE7406A
> Content-type: text/html; charset=US-ASCII
> Content-Disposition: inline
> Content-transfer-encoding: quoted-printable
>
> <html><body>
> <p>Hi Gary,<br>
> For the when part, you can probably look through the logs to see when t=
> he ALTER TABLE was done. (look for PTALTER and the partnum of the table=
> ). For the who part, you will probably need to use the ONAUDIT tool (ac=
> tually, you can get the when part from that as well). <br>
> <br>
> For what columns have changed ...that's a bit tricky (until and unless =
> u keep a history of dbschema outputs) .. I think the partition pages do=
> store the information in Slot #6 but its not straightforward ..it woul=
> d require interpretation until and unless someone's got a tool to inter=
> pret that information.<br>
> <br>
> HTH<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__=3D88BBE4ECDFE7406A8f9e8a93df938@us.ibm.com" width=3D=
> "16" height=3D"16" alt=3D"Inactive hide details for Gary Quiring <gq=
> uiring@msn.com>">Gary Quiring <gquiring@msn.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__=3D88BBE4E=
> CDFE7406A8f9e8a93df938@us.ibm.com); background-repeat: no-repeat; " wid=
> th=3D"40%">
> <ul>
> <ul>
> <ul>
> <ul><b><font size=3D"2">Gary Quiring <gquiring@msn.com></font></b=
> ><font size=3D"2"> </font><br>
> <font size=3D"2">Sent by: owner-informix-list@iiug.org</font>
> <p><font size=3D"2">04/23/2004 10:42 AM</font>
> <table border=3D"1">
> <tr valign=3D"top"><td width=3D"168" bgcolor=3D"#FFFFFF"><div align=3D"=
> center"><font size=3D"2">Please respond to<br>
> Gary Quiring</font></div></td></tr>
> </table>
> </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__=3D88BBE4ECDFE7406A8f9e8a93df938@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__=3D88BBE4ECDFE7406A8f9e8a93df938@us.ibm.com" =
> border=3D"0" height=3D"1" width=3D"1" alt=3D""><br>
> <font size=3D"2">informix-list@iiug.org</font></td></tr>
>
> <tr valign=3D"top"><td width=3D"1%" valign=3D"middle"><img src=3D"cid:3=
> 0__=3D88BBE4ECDFE7406A8f9e8a93df938@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__=3D88BBE4ECDFE7406A8f9e8a93df938@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__=3D88BBE4ECDFE7406A8f9e8a93df938@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__=3D88BBE4ECDFE7406A8f9e8a93df938@us.ibm.=
> com" border=3D"0" height=3D"1" width=3D"1" alt=3D""><br>
> <font size=3D"2">How can I tell when a column was added to a table?</fo=
> nt></td></tr>
> </table>
>
> <table border=3D"0" cellspacing=3D"0" cellpadding=3D"0">
> <tr valign=3D"top"><td width=3D"58"><im