dbschema utility does not show triggers
A user on IDS 11.50.FC4 reported that dbschema no longer listed a table's triggers, although it did on 10.00. Art Kagel suggested his myschema replacement (in utils2_ak from oninit.com/utils or the IIUG software repository) and opening a PMR, while several others (11.50 xC3, FC4, FC4X1 on Linux/AIX, UC1) said dbschema showed triggers fine for them; IBM's Ping Tang asked for the platform and a reproducible test case. The poster later reported the problem went away after restarting the instance, with no root cause identified.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Hello,
I have observed that on IDS11.50, if we get schema of a table through dbschema
utility it does not show the triggers present on the table.
Whereas on version 10.00 this utility show triggers
Regards,
Anees Ahmad
Get my dbschema replacement utility, myschema, for now and open a case with
IBM to get the bug fixed.
Myschema is included in the package utils2_ak which you can download from
the Oninit web site (www.oninit.com/utils) or from the IIUG Software
Repository (www.iiug.org/software).
Art
Art S. Kagel
Oninit (www.oninit.com)
IIUG Board of Directors (art@iiug.org)
Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Oninit, the IIUG, nor any other organization
with which I am associated either explicitly or implicitly. Neither do
those opinions reflect those of other individuals affiliated with any entity
with which I am affiliated nor those of the entities themselves.
On Wed, Jun 3, 2009 at 8:10 AM, ANEES AHMAD <aanees@i2cinc.com> wrote:
> Hello,
>
> I have observed that on IDS11.50, if we get schema of a table through
> dbschema> utility it does not show the triggers present on the table.
> Whereas on version 10.00 this utility show triggers
>
> Regards,
> Anees Ahmad
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--001636c5ac7a519c0c046b71b8d4
Which version of 11.50? I'm using 11.50FC4 on Redhat Linux and I see my
triggers on tables when using dbschema.
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of ANEES
AHMAD
Sent: Wednesday, June 03, 2009 7:11 AM
To: ids@iiug.org
Subject: dbschema utility does not show triggers [15912]
Hello,
I have observed that on IDS11.50, if we get schema of a table through
dbschema utility it does not show the triggers present on the table.
Whereas on version 10.00 this utility show triggers
Regards,
Anees Ahmad
****************************************************************************
***
Forum Note: Use "Reply" to post a response in the discussion forum.
And I get triggers when I run dbschema using 11.50xC3.
Art
Art S. Kagel
Oninit (www.oninit.com)
IIUG Board of Directors (art@iiug.org)
Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Oninit, the IIUG, nor any other organization
with which I am associated either explicitly or implicitly. Neither do
those opinions reflect those of other individuals affiliated with any entity
with which I am affiliated nor those of the entities themselves.
On Wed, Jun 3, 2009 at 9:50 AM, Jamie Gedye <jgedyedba@teleformix.com>wrote:
> Which version of 11.50? I'm using 11.50FC4 on Redhat Linux and I see my
> triggers on tables when using dbschema.
>
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
> ANEES
> AHMAD
> Sent: Wednesday, June 03, 2009 7:11 AM
> To: ids@iiug.org
> Subject: dbschema utility does not show triggers [15912]
>
> Hello,
>
> I have observed that on IDS11.50, if we get schema of a table through
> dbschema utility it does not show the triggers present on the table.
> Whereas on version 10.00 this utility show triggers
>
> Regards,
> Anees Ahmad
>
>
> ****************************************************************************
> ***
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--001636c5b0ee781cfc046b721670
I am using 11.50.FC4X1 on AIX 5300-07 and when I run dbschema with or without
the -ss option, I get the triggers as well.
Joe Plugge
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Art Kagel
Sent: Wednesday, June 03, 2009 9:01 AM
To: ids@iiug.org
Subject: Re: dbschema utility does not show triggers [15917]
And I get triggers when I run dbschema using 11.50xC3.
Art
Art S. Kagel
Oninit (www.oninit.com)
IIUG Board of Directors (art@iiug.org)
Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Oninit, the IIUG, nor any other organization
with which I am associated either explicitly or implicitly. Neither do
those opinions reflect those of other individuals affiliated with any entity
with which I am affiliated nor those of the entities themselves.
On Wed, Jun 3, 2009 at 9:50 AM, Jamie Gedye <jgedyedba@teleformix.com>wrote:
> Which version of 11.50? I'm using 11.50FC4 on Redhat Linux and I see my
> triggers on tables when using dbschema.
>
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
> ANEES
> AHMAD
> Sent: Wednesday, June 03, 2009 7:11 AM
> To: ids@iiug.org
> Subject: dbschema utility does not show triggers [15912]
>
> Hello,
>
> I have observed that on IDS11.50, if we get schema of a table through
> dbschema utility it does not show the triggers present on the table.
> Whereas on version 10.00 this utility show triggers
>
> Regards,
> Anees Ahmad
>
>
> ****************************************************************************
> ***
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--001636c5b0ee781cfc046b721670
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
Hello, I am talking about 11.50.FC4 Regards, Anees
I am running 11.50.FC4X1, which contains only one customer specific patch that
dealt with memory usage when using enterprise replication.
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of ANEES
AHMAD
Sent: Wednesday, June 03, 2009 10:10 AM
To: ids@iiug.org
Subject: Re: dbschema utility does not show triggers [15919]
Hello,
I am talking about 11.50.FC4
Regards,
Anees
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
Anees
Please provide platform and repro SQL. I would love to look into it.
Regards
-Ping
--- On Wed, 6/3/09, ANEES AHMAD <aanees@i2cinc.com> wrote:
From: ANEES AHMAD <aanees@i2cinc.com>
Subject: Re: dbschema utility does not show triggers [15919]
To: ids@iiug.org
Date: Wednesday, June 3, 2009, 10:09 AM
Hello,
I am talking about 11.50.FC4
Regards,
Anees
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
On Wed, Jun 3, 2009 at 08:09, ANEES AHMAD <aanees@i2cinc.com> wrote: > I am talking about 11.50.FC4 On which platform are you running? (That might have been in the original post, but because there was no shred of the original post left apart from the subject line, it is hard to tell. I fully agree with trimming unnecessary material from prior posts - that doesn't happen enough in general - but the entire removal of all prior material is about as bad as no removal.) -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2008.0513 -- http://dbi.perl.org/ "Blessed are we who can laugh at ourselves, for we shall never cease to be amused." NB: Please do not use this email for correspondence. I don't necessarily read it every week, even. H. L. Mencken - "Nobody ever went broke underestimating the taste of the American public." - http://www.brainyquote.com/quotes/authors/h/h_l_mencken.html
Hello!
Probably you don't have any trigger in the table which you are consulting.
I have run dbschema using 11.50 UC1, and I got triggers
Regards
> To: ids@iiug.org
> From: art.kagel@gmail.com
> Subject: Re: dbschema utility does not show triggers [15917]
> Date: Wed, 3 Jun 2009 10:00:58 -0400
>
> And I get triggers when I run dbschema using 11.50xC3.
>
> Art
>
> Art S. Kagel
> Oninit (www.oninit.com)
> IIUG Board of Directors (art@iiug.org)
>
> Disclaimer: Please keep in mind that my own opinions are my own opinions and
> do not reflect on my employer, Oninit, the IIUG, nor any other organization
> with which I am associated either explicitly or implicitly. Neither do
> those opinions reflect those of other individuals affiliated with any entity
> with which I am affiliated nor those of the entities themselves.
>
> On Wed, Jun 3, 2009 at 9:50 AM, Jamie Gedye <jgedyedba@teleformix.com>wrote:
>
> > Which version of 11.50? I'm using 11.50FC4 on Redhat Linux and I see my
> > triggers on tables when using dbschema.
> >
> > -----Original Message-----
> > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
> > ANEES
> > AHMAD
> > Sent: Wednesday, June 03, 2009 7:11 AM
> > To: ids@iiug.org
> > Subject: dbschema utility does not show triggers [15912]
> >
> > Hello,
> >
> > I have observed that on IDS11.50, if we get schema of a table through
> > dbschema utility it does not show the triggers present on the table.
> > Whereas on version 10.00 this utility show triggers
> >
> > Regards,
> > Anees Ahmad
> >
> >
> >
****************************************************************************
> > ***
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
> >
> >
>
*******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
> --001636c5b0ee781cfc046b721670
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
_________________________________________________________________
Actualiza tu Perfil y gana!
http://www.actualizatuperfil.com.mx/
Hello, The problem resolved by restarting the instance. Regards, Anees