 | |
#1
 
| |||
| |||
|
Monitor SQL Statements -
04-02-2009
, 08:42 AM
#2
| |||
| |||
|
|
Hi There! I'm a Informix DBA and I'm starting with SYBASE and I'm searching for a tool for SQL statements that are running, based on a session, such like the Informix command : onstat -g ses < PID where you get the current, and the last parsed SQL statements for a specific session. SYBASE have a tool like that? Preferably a command line tool? Thanks in advance! Guto. |
Advantage),
as well as other products, so please take care to specify the product
you are using.
In current versions of ASE, you would use the monSysSQLText or
monProcessSQLText tables.
-bret
'
#3
| |||
| |||
|
|
On Apr 2, 7:42*am, Guto <gutom... (AT) gmail (DOT) com> wrote: Hi There! I'm a Informix DBA and I'm starting with SYBASE and I'm searching for a tool for SQL statements that are running, based on a session, such like the Informix command : onstat -g ses < PID where you get the current, and the last parsed SQL statements for a specific session. SYBASE have a tool like that? Preferably a command line tool? Thanks in advance! Guto. Sybase has 4 database products (ASE, SQL Anywhere, Sybase IQ, Advantage), as well as other products, so please take care to specify the product you are using. In current versions of ASE, you would use the *monSysSQLText or monProcessSQLText tables. -bret ' |
I miss this info:
here it goes,
I'm running ASE 12.5.4 in a solaris box.
as per I understood, the monSysSQLText or monProcessSQLText are
availabe only
under ASE 15, isn't it?
Regards,
Guto.
#4
| |||
| |||
|
|
On Apr 2, 1:20*pm, Bret_Halford <b... (AT) sybase (DOT) com> wrote: On Apr 2, 7:42*am, Guto <gutom... (AT) gmail (DOT) com> wrote: Hi There! I'm a Informix DBA and I'm starting with SYBASE and I'm searching for a tool for SQL statements that are running, based on a session, such like the Informix command : onstat -g ses < PID where you get the current, and the last parsed SQL statements for a specific session. SYBASE have a tool like that? Preferably a command line tool? Thanks in advance! Guto. Sybase has 4 database products (ASE, SQL Anywhere, Sybase IQ, Advantage), as well as other products, so please take care to specify the product you are using. In current versions of ASE, you would use the *monSysSQLText or monProcessSQLText tables. -bret ' Thanks Bret! I miss this info: here it goes, I'm running ASE 12.5.4 in a solaris box. as per I understood, the monSysSQLText or monProcessSQLText *are availabe only under ASE 15, isn't it? Regards, Guto. |
weren't installed by default
in 12.5.x and are in 15.x. See the P&T Guide volume on monitoring,
and look in the
$SYBASE/ASE-*/scripts directory for the installation script.
cheers,
-bret
#5
| |||
| |||
|
|
On Apr 2, 1:26*pm, Guto <gutom... (AT) gmail (DOT) com> wrote: On Apr 2, 1:20*pm, Bret_Halford <b... (AT) sybase (DOT) com> wrote: On Apr 2, 7:42*am, Guto <gutom... (AT) gmail (DOT) com> wrote: Hi There! I'm a Informix DBA and I'm starting with SYBASE and I'm searching for a tool for SQL statements that are running, based on a session, such like the Informix command : onstat -g ses < PID where you get the current, and the last parsed SQL statements for a specific session. SYBASE have a tool like that? Preferably a command line tool? Thanks in advance! Guto. Sybase has 4 database products (ASE, SQL Anywhere, Sybase IQ, Advantage), as well as other products, so please take care to specify the product you are using. In current versions of ASE, you would use the *monSysSQLText or monProcessSQLText tables. -bret ' Thanks Bret! I miss this info: here it goes, I'm running ASE 12.5.4 in a solaris box. as per I understood, the monSysSQLText or monProcessSQLText *are availabe only under ASE 15, isn't it? Regards, Guto. No, they are available in 12.5.x. *If I remember correctly, they weren't installed by default in 12.5.x and are in 15.x. *See the P&T Guide volume on monitoring, and look in the $SYBASE/ASE-*/scripts directory for the installation script. cheers, -bret- Hide quoted text - - Show quoted text - |
http://www.sypron.nl/mda.html
#6
| |||
| |||
|
|
On Apr 2, 10:52*pm, Bret_Halford <b... (AT) sybase (DOT) com> wrote: On Apr 2, 1:26*pm, Guto <gutom... (AT) gmail (DOT) com> wrote: On Apr 2, 1:20*pm, Bret_Halford <b... (AT) sybase (DOT) com> wrote: On Apr 2, 7:42*am, Guto <gutom... (AT) gmail (DOT) com> wrote: Hi There! I'm a Informix DBA and I'm starting with SYBASE and I'm searchingfor a tool for SQL statements that are running, based on a session, such like the Informix command : onstat -g ses < PID where you get the current, and the last parsed SQL statements fora specific session. SYBASE have a tool like that? Preferably a command line tool? Thanks in advance! Guto. Sybase has 4 database products (ASE, SQL Anywhere, Sybase IQ, Advantage), as well as other products, so please take care to specify the product you are using. In current versions of ASE, you would use the *monSysSQLText or monProcessSQLText tables. -bret ' Thanks Bret! I miss this info: here it goes, I'm running ASE 12.5.4 in a solaris box. as per I understood, the monSysSQLText or monProcessSQLText *are availabe only under ASE 15, isn't it? Regards, Guto. No, they are available in 12.5.x. *If I remember correctly, they weren't installed by default in 12.5.x and are in 15.x. *See the P&T Guide volume on monitoring, and look in the $SYBASE/ASE-*/scripts directory for the installation script. cheers, -bret- Hide quoted text - - Show quoted text - You can find MDA Installation steps herehttp://www.sypron.nl/mda.html- Zitierten Text ausblenden - - Zitierten Text anzeigen - |
1. dbcc traceon(3604) ( to show all output to terminal session )
2. dbcc sqltext(PID) ( to see the active sql - text )
Regards
Rainer
#7
| |||
| |||
|
|
On 3 Apr., 22:12, PDreyer <petrus.dre... (AT) gmail (DOT) com> wrote: On Apr 2, 10:52*pm, Bret_Halford <b... (AT) sybase (DOT) com> wrote: On Apr 2, 1:26*pm, Guto <gutom... (AT) gmail (DOT) com> wrote: On Apr 2, 1:20*pm, Bret_Halford <b... (AT) sybase (DOT) com> wrote: On Apr 2, 7:42*am, Guto <gutom... (AT) gmail (DOT) com> wrote: Hi There! I'm a Informix DBA and I'm starting with SYBASE and I'm searching for a tool for SQL statements that are running, based on a session,such like the Informix command : onstat -g ses < PID where you get the current, and the last parsed SQL statements for a specific session. SYBASE have a tool like that? Preferably a command line tool? Thanks in advance! Guto. Sybase has 4 database products (ASE, SQL Anywhere, Sybase IQ, Advantage), as well as other products, so please take care to specify the product you are using. In current versions of ASE, you would use the *monSysSQLText or monProcessSQLText tables. -bret ' Thanks Bret! I miss this info: here it goes, I'm running ASE 12.5.4 in a solaris box. as per I understood, the monSysSQLText or monProcessSQLText *are availabe only under ASE 15, isn't it? Regards, Guto. No, they are available in 12.5.x. *If I remember correctly, they weren't installed by default in 12.5.x and are in 15.x. *See the P&T Guide volume on monitoring, and look in the $SYBASE/ASE-*/scripts directory for the installation script. cheers, -bret- Hide quoted text - - Show quoted text - You can find MDA Installation steps herehttp://www.sypron.nl/mda.html-Zitierten Text ausblenden - - Zitierten Text anzeigen - otherwise you can use 1. dbcc traceon(3604) ( to show all output to terminal session ) 2. dbcc sqltext(PID) *( to see the active sql - text ) Regards Rainer |
 |
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.