Maximo List Archive

This is an archive of the Maximo Yahoo Community. The content of this pages may be a sometimes obsolete so please check post dates.
Thanks to the community owner Christopher Wanko for providing the content.



Queries

From: George (2011-09-29 14:35)

Hello all how are we today?
Is there a way to see who ran a query?
I keep getting Warnings in my maximo.log.
Here is part of the warning.
29 Sep 2011 06:11:37:651 [WARN] app (PLUSGWO) object (WORKORDER)
I see alot of these and beginning to wonder if these are causing my system to crash.
thx,
mrggutz


From: Victor (2011-09-29 14:40)

Hell George,
I am doing well, how about you ?
Please turn on the SQL logging of Maximo. Then you will be able to see the Query and user who ran the query in the logs.
Below are some useful links :
Logging in Maximo : https://www-304.ibm.com/support/docview.wss?uid=swg21264064
Creating a Log file in maximo : https://www-304.ibm.com/support/docview.wss?uid=swg21385917
SQL logging and Debug properties :
https://www-304.ibm.com/support/docview.wss?uid=swg21291250
Hope this helps.
Thanks,
Victor.
--- In MAXIMO@yahoogroups.com, "George" <ggutierrez@...> wrote:
>
> Hello all how are we today?
> Is there a way to see who ran a query?
> I keep getting Warnings in my maximo.log.
> Here is part of the warning.
> 29 Sep 2011 06:11:37:651 [WARN] app (PLUSGWO) object (WORKORDER)
>
> I see alot of these and beginning to wonder if these are causing my system to crash.
>
> thx,
> mrggutz
>


From: George (2011-09-29 14:43)

Victor,
I will give it a try.
thank you.
--- In MAXIMO@yahoogroups.com, "Victor" <vikas17.j@...> wrote:
>
> Hell George,
>
> I am doing well, how about you ?
>
> Please turn on the SQL logging of Maximo. Then you will be able to see the Query and user who ran the query in the logs.
>
> Below are some useful links :
>
> Logging in Maximo : https://www-304.ibm.com/support/docview.wss?uid=swg21264064
> Creating a Log file in maximo : https://www-304.ibm.com/support/docview.wss?uid=swg21385917
>
> SQL logging and Debug properties :
>
> https://www-304.ibm.com/support/docview.wss?uid=swg21291250
>
> Hope this helps.
>
> Thanks,
>
> Victor.
>
> --- In MAXIMO@yahoogroups.com, "George" <ggutierrez@> wrote:
> >
> > Hello all how are we today?
> > Is there a way to see who ran a query?
> > I keep getting Warnings in my maximo.log.
> > Here is part of the warning.
> > 29 Sep 2011 06:11:37:651 [WARN] app (PLUSGWO) object (WORKORDER)
> >
> > I see alot of these and beginning to wonder if these are causing my system to crash.
> >
> > thx,
> > mrggutz
> >
>