Is there any way in DB2 to get the exact command.
I have an event monitor I created for statments, and all the statment
values are filled with a question mark.
I was using this at another site (different application too) and the
values were filled in properly, but here it is not.
This is DB2 8.2 (8.1fp6) on AIX 5.3ml02
create event monitor LCACAPTURE for statements write to file
'/db2adm/mon' NONBLOCKED REPLACE ON NODE 1 LOCAL
update monitor switches using statement on
set event monitor lcacapture state=1
run my application
set event monitor lcacapture state=0
then from command line
db2evmon -path ./mon > montxt/1.txt
And in 1.txt I have things like
Text : INSERT INTO "EV5R14"."VPMPR ODUCTCLASS" ("TYPE" , "OID" ,
"DATADOMAIN " , "CPROPERTIE S" , "VAGGREGATE D" , "CTIMESTAMP " , "CCREATED"
, "CMODIFIED" , "VEXTERNALI D" , "VEXPOSED" , "VUSER" , "VORGANIZAT ION" ,
"VPROJECT00 11" , "VHISTOID" , "VPREVIOUS" , "VPREVIOUS$ " , "VPREVIOUS# "
, "V508APPDOMAINE " , "V508APPTYP E" , "VID" , "VNAME" , "VDESCRIPTI ON" ,
"VSTATUS" , "V506GRAPH" , "VLEVEL" , "VPC" , "VPRC" , "LASTUPDATEDATE " ,
"LASTMODIFIERID " , "LOCKTIMEST AMP" , "OWNERSITE" , "LOCKSTATUS " ,
"LOCKUSER") VALUES ( ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ,
? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ,
? , ? )
Anyway to capture the actual values here?
Thanks!
Ken 4 3008
yoyo wrote: Is there any way in DB2 to get the exact command. I have an event monitor I created for statments, and all the statment values are filled with a question mark. I was using this at another site (different application too) and the values were filled in properly, but here it is not. This is DB2 8.2 (8.1fp6) on AIX 5.3ml02
create event monitor LCACAPTURE for statements write to file '/db2adm/mon' NONBLOCKED REPLACE ON NODE 1 LOCAL
update monitor switches using statement on
set event monitor lcacapture state=1
run my application
set event monitor lcacapture state=0
then from command line
db2evmon -path ./mon > montxt/1.txt
And in 1.txt I have things like
Text : INSERT INTO "EV5R14"."VPMPR ODUCTCLASS" ("TYPE" , "OID" , "DATADOMAIN " , "CPROPERTIE S" , "VAGGREGATE D" , "CTIMESTAMP " , "CCREATED" , "CMODIFIED" , "VEXTERNALI D" , "VEXPOSED" , "VUSER" , "VORGANIZAT ION" , "VPROJECT00 11" , "VHISTOID" , "VPREVIOUS" , "VPREVIOUS$ " , "VPREVIOUS# " , "V508APPDOMAINE " , "V508APPTYP E" , "VID" , "VNAME" , "VDESCRIPTI ON" , "VSTATUS" , "V506GRAPH" , "VLEVEL" , "VPC" , "VPRC" , "LASTUPDATEDATE " , "LASTMODIFIERID " , "LOCKTIMEST AMP" , "OWNERSITE" , "LOCKSTATUS " , "LOCKUSER") VALUES ( ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? )
The venet monitor logs what the DB2 server received. It may be that your
cleinet (CLI) is stripping out the constants to re-use the package cache.
There is a way via db2trc to capture the statement as well as the bind
variables but it's a tad heavy for my taste.
If you want to intercept a complete workload I'm told the "Rational
Performance Tool" does a good job by intercepting the http-connection.
"Load Runner" is another (3. party) tool that can do the job.
Out of curiousity, may I ask what you are trying to achieve (in the
grand scheme, I mean). Is your purpose load capture, debugging, ... ?
Cheers
Serge
--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab
Serge Rielau wrote: yoyo wrote:
Is there any way in DB2 to get the exact command. I have an event monitor I created for statments, and all the statment values are filled with a question mark. I was using this at another site (different application too) and the values were filled in properly, but here it is not. This is DB2 8.2 (8.1fp6) on AIX 5.3ml02
create event monitor LCACAPTURE for statements write to file '/db2adm/mon' NONBLOCKED REPLACE ON NODE 1 LOCAL
update monitor switches using statement on
set event monitor lcacapture state=1
run my application
set event monitor lcacapture state=0
then from command line
db2evmon -path ./mon > montxt/1.txt
And in 1.txt I have things like
Text : INSERT INTO "EV5R14"."VPMPR ODUCTCLASS" ("TYPE" , "OID" , "DATADOMAIN " , "CPROPERTIE S" , "VAGGREGATE D" , "CTIMESTAMP " , "CCREATED" , "CMODIFIED" , "VEXTERNALI D" , "VEXPOSED" , "VUSER" , "VORGANIZAT ION" , "VPROJECT00 11" , "VHISTOID" , "VPREVIOUS" , "VPREVIOUS$ " , "VPREVIOUS# " , "V508APPDOMAINE " , "V508APPTYP E" , "VID" , "VNAME" , "VDESCRIPTI ON" , "VSTATUS" , "V506GRAPH" , "VLEVEL" , "VPC" , "VPRC" , "LASTUPDATEDATE " , "LASTMODIFIERID " , "LOCKTIMEST AMP" , "OWNERSITE" , "LOCKSTATUS " , "LOCKUSER") VALUES ( ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? )
The venet monitor logs what the DB2 server received. It may be that your cleinet (CLI) is stripping out the constants to re-use the package cache. There is a way via db2trc to capture the statement as well as the bind variables but it's a tad heavy for my taste. If you want to intercept a complete workload I'm told the "Rational Performance Tool" does a good job by intercepting the http-connection. "Load Runner" is another (3. party) tool that can do the job.
Out of curiousity, may I ask what you are trying to achieve (in the grand scheme, I mean). Is your purpose load capture, debugging, ... ?
Cheers Serge
I developing a transfer tool from one PLM application to another, and
I'm kinda of reverse engineering the new PLM tool to find out where it's
writing things when you do certain things in the application.
I can of course go retreive the inserted values from the table and fill
in, but that's a little labour intensive, I was hoping to just see the
full statment in the event monitor.
This is just a test database on my machine with me as the only one using
it right now.
Hmmmm..db2trc.. .I'll check into that one..what do you mean by heavy?
Thanks
Ken
If this is testing only for the moment, you might want to look at the output
of your db2audit command.
Since you can audit in context, it would audit an execute immediate which
would carry the values instead of the ? (or so I think).
This would be useful only if you do not need the values immediately as you
have to stop your auditor and then format the output log to be parsed.
HTH, Pierre.
--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
"yoyo" <yo**@ma.com> a écrit dans le message de news: s4************* *******@century tel.net... Serge Rielau wrote: yoyo wrote:
Is there any way in DB2 to get the exact command. I have an event monitor I created for statments, and all the statment values are filled with a question mark. I was using this at another site (different application too) and the values were filled in properly, but here it is not. This is DB2 8.2 (8.1fp6) on AIX 5.3ml02
create event monitor LCACAPTURE for statements write to file '/db2adm/mon' NONBLOCKED REPLACE ON NODE 1 LOCAL
update monitor switches using statement on
set event monitor lcacapture state=1
run my application
set event monitor lcacapture state=0
then from command line
db2evmon -path ./mon > montxt/1.txt
And in 1.txt I have things like
Text : INSERT INTO "EV5R14"."VPMPR ODUCTCLASS" ("TYPE" , "OID" , "DATADOMAIN " , "CPROPERTIE S" , "VAGGREGATE D" , "CTIMESTAMP " , "CCREATED" , "CMODIFIED" , "VEXTERNALI D" , "VEXPOSED" , "VUSER" , "VORGANIZAT ION" , "VPROJECT00 11" , "VHISTOID" , "VPREVIOUS" , "VPREVIOUS$ " , "VPREVIOUS# " , "V508APPDOMAINE " , "V508APPTYP E" , "VID" , "VNAME" , "VDESCRIPTI ON" , "VSTATUS" , "V506GRAPH" , "VLEVEL" , "VPC" , "VPRC" , "LASTUPDATEDATE " , "LASTMODIFIERID " , "LOCKTIMEST AMP" , "OWNERSITE" , "LOCKSTATUS " , "LOCKUSER") VALUES ( ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? )
The venet monitor logs what the DB2 server received. It may be that your cleinet (CLI) is stripping out the constants to re-use the package cache. There is a way via db2trc to capture the statement as well as the bind variables but it's a tad heavy for my taste. If you want to intercept a complete workload I'm told the "Rational Performance Tool" does a good job by intercepting the http-connection. "Load Runner" is another (3. party) tool that can do the job.
Out of curiousity, may I ask what you are trying to achieve (in the grand scheme, I mean). Is your purpose load capture, debugging, ... ?
Cheers Serge
I developing a transfer tool from one PLM application to another, and I'm kinda of reverse engineering the new PLM tool to find out where it's writing things when you do certain things in the application. I can of course go retreive the inserted values from the table and fill in, but that's a little labour intensive, I was hoping to just see the full statment in the event monitor. This is just a test database on my machine with me as the only one using it right now. Hmmmm..db2trc.. .I'll check into that one..what do you mean by heavy?
Thanks
Ken
yoyo wrote: Hmmmm..db2trc.. .I'll check into that one..what do you mean by heavy?
db2trc is very verbose. Even including a filter in my experience the
dump still chews up some 20k per statement.
Bounce me an email for more info.
Cheers
Serge
--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Rohit |
last post by:
Hi,
Threads in the .NET Framework 1.1 (and possibly in 1.0 also) leak "Event"
handles, by Event handles I mean Win32 Event handles which can be monitored
using the ProcessExplorer from www.sysinternals.com, or even simply look at
the Handle count in the good old windows TaskManager.
To demonstrate the problem, all I did was created a basic Win Forms
application and with Main implemented as:
|
by: JS |
last post by:
I have v8.1 fix5 using Win2k AS on 7 node logical system.
I create event monitor writing to file and turn it on. Using
application, I connect to db and navigate from screen to screen,
generating reports using select sql. I flush the buffer, turn the
event monitor off and format the data with db2evom. But, the output
never contains the statement text. But, if I issue sql from the clp,
these statements appear in the output.
In addition,...
|
by: brandon |
last post by:
I've followed the instructions here
(http://groups-beta.google.com/group/comp.databases.ibm-db2/browse_frm/thread/1f69a5fecafba8d8/c35658a24456ad87?tvc=1&q=db2+statement+event+monitor#c35658a24456ad87)
to enable sql tracing w/ DB2 8.1. However, when I view the db2evmon
output, the values in the queries have been replaced by question marks.
For example:
65) Statement Event ...
Appl Handle: 14
Appl Id: GA990C3C.B410.00F1C5212311
Appl...
|
by: Frank 'Olorin' Rizzi |
last post by:
Hello everyone.
This is quite convoluted, but I'll try to make it simple.
I have a couple of bottom-line questions (I guess):
1~ what happens between the Page_Load routine in the code behind of an aspx
page and the
presentation of the page to the user?
2~ is it true that the engine takes data from the Request.Form and puts them
|
by: Raj |
last post by:
Can we create an event monitor for statements in a partitioned
environment?
CREATE EVENT MONITOR stmt_event FOR STATEMENTS WRITE TO FILE
'/home/rajm/event' ON PARTITION 0 GLOBAL
DB21034E The command was processed as an SQL statement because it was
not a
valid Command Line Processor command. During SQL processing it
returned:
| |
by: Jo |
last post by:
Hi.
I have a few questions regd event monitoring. Would appreciate some
assistance with this.
1. Does the event monitor only insert data into the event monitoring
tables once the connection has been disconnected? sometimes when i
select from the tables the data does not show current connections, only
when i use the FLUSH command the data is updated. so, is my
understanding correct? thanks.
2. Can we activate and deactivate the event...
|
by: bughunter |
last post by:
Local server
C:\TRACE>db2level
DB21085I Instance "DB2" uses "32" bits and DB2 code release "SQL08024"
with
level identifier "03050106".
Informational tokens are "DB2 v8.1.11.973", "s060120", "WR21365", and
FixPak
"11".
|
by: vijay.db |
last post by:
Hi group,
Have a problem with event monitor so my db2diag.log is getting filled
like any thing..
Running DB2 V8.1 Fixpack 6 in AIX server.
Created a event monitor and redirecting it's output to a file..getting
error like
|
by: anon.asdf |
last post by:
In terms of efficieny:
Is it better to use multiple putchar()'s after one another as one gets
to new char's
OR
is it better to collect the characters to a char-array first, and then
use puts() to print to screen
????
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| |
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |