Re: Informix 9.40: Need Script to Determine Which Tables Have IN-PLACE

Posted in 2004

Rajib Sarkar — Tue, 03 Aug 2004 16:34:36 — source: IIUG Forums & Mailing Lists

--0__=88BBE476DFCA25978f9e8a93df938690918c88BBE476DFCA2597 Content-type: multipart/related; Boundary="1__=88BBE476DFCA25978f9e8a93df938690918c88BBE476DFCA2597" --1__=88BBE476DFCA25978f9e8a93df938690918c88BBE476DFCA2597 Content-type: multipart/alternative; Boundary="2__=88BBE476DFCA25978f9e8a93df938690918c88BBE476DFCA2597" --2__=88BBE476DFCA25978f9e8a93df938690918c88BBE476DFCA2597 Content-type: text/plain; charset=US-ASCII Content-transfer-encoding: quoted-printable Hi Clifton, I've got a script which does that ... Long time back I had tested it for 9.40 and it used to work ... let me = know if there are any problems with it. (See attached file: inplacealter.ksh.txt) Thanx much, Rajib Sarkar Advisory Software Engineer DB2/UDB Regional Advanced Support IBM Data Management Group Ph : (602)-217-2100 Fax: (602)-217-2100 T/L : 667-2100 http://www.ibm.com/software/data/db2/udb/winos2unix/support If we all did the things we are capable of doing, we would literally astound ourselves. -- T. Edison = "Clifton M. Bean" = <cmbean@sbcglobal = .net> = To Sent by: ids@iiug.org = forum.subscriber@ = cc iiug.org = Subj= ect Informix 9.40: Need Script to = 08/02/2004 06:26 Determine Which Tables Have = PM IN-PLACE ALTERS [3312] = = = = = = = Does anyone have a script that will run against a sysmaster table that = will quickly identify which tables within a database have active in-place al= ter tables. I used to have one that worked on 7.3+ instances but the sysmaster tabl= es used by that script no longer exist in 9.40. I added sapmix to the email list believing that, perhaps, an SAP OSS no= te may address this issue and can be used by the non-SAP world to locate t= hese tables. Thanks in advance. Clifton = --2__=88BBE476DFCA25978f9e8a93df938690918c88BBE476DFCA2597 Content-type: text/html; charset=US-ASCII Content-Disposition: inline Content-transfer-encoding: quoted-printable <html><body> Hi Clifton, I've got a script which does that ... Long time back I had tested it for 9.40 and it used to work ... let me = know if there are any problems with it. (See attached file: inplacealter.ksh.txt) Thanx much, Rajib Sarkar Advisory Software Engineer DB2/UDB Regional Advanced Support IBM Data Management Group Ph : (602)-217-2100 Fax: (602)-217-2100 T/L : 667-2100 <a href=3D"http://www.ibm.com/software/data/db2/udb/winos2unix/support"= >http://www.ibm.com/software/data/db2/udb/winos2unix/support</a> ; If we all did the things we are capable of doing, we would literally as= tound ourselves. -- T. Edison <img src=3D"cid:20__=3D88BBE476DFCA25978f9e8a93df938@us.ibm.com" width=3D= "16" height=3D"16" alt=3D"Inactive hide details for "Clifton M. Be= an" <cmbean@sbcglobal.net>">"Clifton M. Bean" <= cmbean@sbcglobal.net> <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__=3D88BBE47= 6DFCA25978f9e8a93df938@us.ibm.com); background-repeat: no-repeat; " wid= th=3D"40%"> <ul> <ul> <ul> <ul>"Clifton M. Bean" <cmbean@sbcgloba= l.net> Sent by: forum.subscriber@iiug.org 08/02/2004 06:26 PM</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__=3D88BBE476DFCA25978f9e8a93df938@us.ibm.com" border=3D"0" height=3D"= 1" width=3D"58" alt=3D""> <div align=3D"right">To</div></td><td width=3D"= 100%"><img src=3D"cid:40__=3D88BBE476DFCA25978f9e8a93df938@us.ibm.com" = border=3D"0" height=3D"1" width=3D"1" alt=3D""> ids@iiug.org</td></tr> <tr valign=3D"top"><td width=3D"1%" valign=3D"middle"><img src=3D"cid:4= 0__=3D88BBE476DFCA25978f9e8a93df938@us.ibm.com" border=3D"0" height=3D"= 1" width=3D"58" alt=3D""> <div align=3D"right">cc</div></td><td width=3D"= 100%"><img src=3D"cid:40__=3D88BBE476DFCA25978f9e8a93df938@us.ibm.com" = border=3D"0" height=3D"1" width=3D"1" alt=3D""> </td></tr> <tr valign=3D"top"><td width=3D"1%" valign=3D"middle"><img src=3D"cid:4= 0__=3D88BBE476DFCA25978f9e8a93df938@us.ibm.com" border=3D"0" height=3D"= 1" width=3D"58" alt=3D""> <div align=3D"right">Subject</div></td><td widt= h=3D"100%"><img src=3D"cid:40__=3D88BBE476DFCA25978f9e8a93df938@us.ibm.= com" border=3D"0" height=3D"1" width=3D"1" alt=3D""> Informix 9.40: Need Script to Determine Which Tables H= ave IN-PLACE ALTERS [3312]</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__=3D88BBE476DFCA= 25978f9e8a93df938@us.ibm.com" border=3D"0" height=3D"1" width=3D"1" alt= =3D""></td><td width=3D"336"><img src=3D"cid:40__=3D88BBE476DFCA25978f9= e8a93df938@us.ibm.com" border=3D"0" height=3D"1" width=3D"1" alt=3D""><= /td></tr> </table> </td></tr> </table> <tt>Does anyone have a script that will run against a sysmaster table t= hat will quickly identify which tables within a database have active in= -place alter tables.   I used to have one that worked on 7.3+ instances but the sysmaster tabl= es used by that script no longer exist in 9.40. I added sapmix to the email list believing that, perhaps, an SAP OSS no= te may address this issue and can be used by the non-SAP world to locat= e these tables. Thanks in advance. Clifton </tt> </body></html>= --2__=88BBE476DFCA25978f9e8a93df938690918c88BBE476DFCA2597-- --1__=88BBE476DFCA25978f9e8a93df938690918c88BBE476DFCA2597 Content-type: image/gif; name="graycol.gif" Content-Disposition: inl

Related threads

How to get the sequence value in ESQL/C program?