SQL to query tables version due alters in place

Posted in 2008

Topics: Jobs, Consulting & Announcements

PAULO RAFAEL — Wed, 07 May 2008 16:00:10 — source: IIUG Forums & Mailing Lists

Hi all, Does anyone have a query to extract tables with more than its current version due to alters in place? I know it could be get with onchec -pT, but I need to check my hole database and I need a complete report about these, so I think querying sysmaster could help to obtain it directly and resumed. Thanks in advance.

↪ replying to PAULO RAFAEL

Clifton Bean — Wed, 07 May 2008 16:24:56 — source: IIUG Forums & Mailing Lists

Here is a link to the IBM Webpage: Precise <http://www-1.ibm.com/support/docview.wss?uid=swg21226410>; Identification of Outstanding or Unrealized In-Place Alters . Take care. Clifton M. Bean Informix DBA / AIX System Admin Currency Technics & Metrics Phone: (972) 812-1411 x244 -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of PAULO RAFAEL PADILLA VELAZQUEZ Sent: Wednesday, May 07, 2008 11:00 AM To: ids@iiug.org Subject: SQL to query tables version due alters in place [12009] Hi all, Does anyone have a query to extract tables with more than its current version due to alters in place? I know it could be get with onchec -pT, but I need to check my hole database and I need a complete report about these, so I think querying sysmaster could help to obtain it directly and resumed. Thanks in advance. **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum.