Finally: SQL procedure tracing

Serge Rielau

Hi SQL Procedure developers,

As threatened in earlier posts the SQL PL Tracing facility is finally
oot-and-aboot.

SQL procedure tracing: Analyzing SQL procedure flow
This article describes an API that allows for transparent tracing of SQL
procedures as well as explicit tracing of non-SQL procedures in DB2
Universal Database (UDB) V8.2 for LUW. An example SQL interface to this
API is provided, as well.

http://www-106.ibm.com/developerwork...lau/index.html

Feedback is much appreciated.
I want to keep the ball rolling on this one :-)

Cheers
Serge

Nov 12 '05 #1

Subscribe Reply

1707

Rhino

"Serge Rielau" <sr*****@ca.e ye-bee-em.com> wrote in message
news:41******** @news3.prserv.n et...

Hi SQL Procedure developers,

As threatened in earlier posts the SQL PL Tracing facility is finally
oot-and-aboot.

SQL procedure tracing: Analyzing SQL procedure flow
This article describes an API that allows for transparent tracing of SQL
procedures as well as explicit tracing of non-SQL procedures in DB2
Universal Database (UDB) V8.2 for LUW. An example SQL interface to this
API is provided, as well.

http://www-106.ibm.com/developerwork...lau/index.html
Feedback is much appreciated.
I want to keep the ball rolling on this one :-)

One small nit, Serge. In reading the Installation section of the article and
saw:

You are on a Windows® 32-bit system or Linux Intel 32-bit:
1.. download the respective zip file and extract it
My immediate thought was that there was no information about what specific
file to download and there was information about where to find it. That was
frustrating. It wasn't until I got to the end of the article and found the
Download section that I realized you *had* provided the files.

An impatient reader *could* have the same thoughts that I did when starting
the article but give up and not bother with trying to trace his SQL
procedure because information about the key files *appeared* to be missing.
Therefore, I think the article would be stronger if the download links were
more visible; perhaps you could move the Download section into or just
before the Installation section or provide an internal link to it from point
a) 1) of the Installation instructions.

I also think it would be a good idea to put a Download link in the Contents
part of the page; that's the first place I looked after starting the
Installation section and when I didn't see Download, I thought you'd
forgotten to provide any information about where to find the files.

Aside from that, the article seems pretty good although I won't be able to
say for sure until I upgrade to V8.x and have a chance to try your
suggestions myself.

Rhino

Nov 12 '05 #2

Serge Rielau

Rhino,

Thanks for the feedback. The template is actually standard, but I can do
two things:
1. Pass the general comments on to the Editor to update the template
2. Add some text (or link) to get my article fixed in particluar.

Cheers
Serge

Nov 12 '05 #3

Knut Stolze

Serge Rielau wrote:

Rhino,

Thanks for the feedback. The template is actually standard, but I can do
two things:
1. Pass the general comments on to the Editor to update the template
2. Add some text (or link) to get my article fixed in particluar.

Serge, I usually add some text in the article itself that explicitly
mentions the "download section below".

--
Knut Stolze
Information Integration
IBM Germany / University of Jena

Nov 12 '05 #4

Similar topics

6098

Tracing values in DTS package/stored procedure

by: Mike | last post by:

Hello, I'm currently working on debugging a very large DTS package that was created by someone else for the purpose of importing data into my company's database. The data is mainly user/contact-related data for our customer base. We ran into problems when one import, of about 40,000 rows, took upwards of six hours to complete. Many of the stored procedures used by this package were written using XML. I've re-written many of them

Microsoft SQL Server

1690

Implementing Tracing throughout an application

by: Trace User | last post by:

Hello, I have a design question regarding Tracing and Trace Switches. I understand that Trace Switches can be configured through an application's .config file. When a switch is instantiated, the application automatically checks the configuration file for a matching named switch. If there's a match, the configuration parameters are set.

.NET Framework

1474

Issue with a stored procedure

by: James Foreman | last post by:

I'm building a stored procedure that simulates cars arriving in a car park, and staying for different amounts of time, based on historical data. So, first I define a cursor that's populated by querying last year's bookings for the period that I'm interested in. This is about 6,500 bookings. The sp then looks at the first booking and compares it to how many cars are already in the car park. If adding that booking would violate the

DB2 Database

1260

tracing

by: Paul Ibison | last post by:

HI when I have a page which calls a component I want to do the following - tracing set to false on the pag tracing set to true in the componen tracing set to false in the page after the call to the component. This is so any further tracing calls are ignored However, I find that there are no tracing results. Can I do this sort of thing - perhaps I am missing something Regards Paul Ibiso

ASP.NET

1655

Tracing simple question

by: serge calderara | last post by:

Dear all, I have an applicatin that generate a querry to an SQL server, then display results on a second webform. I try to see how tracing works, then I have notice that as soon as I implement tracing on the page, when I click on the BACK button of explorer I get a warning message that information of the page needs to be resend to be displayed ?

ASP.NET

1751

efficiently using .net Tracing

by: deepukutty | last post by:

Hi all, I know tht we can do tracing in two ways.one in application level and the other is at Page level. I am able to see the details of trace either on the page itself or .../trace.axd page. I want to use maximum out of the available trace details . or let me put it like this.... tell me the actual scenario's where these trace details will be use ful and

ASP.NET

1362

Getting More Tracing Output in ASP.NET App.

by: cnys | last post by:

We have an ASP.NET 2.0 (C#) app and we're trying to add tracing into it. The tracing functionality within .NET is great, but when we output this to a file, it's kind of sparse. So, we're looking for ideas on how to get more tracing info. output to our log file than what's currently output by calling the Write methods. Here are some snippets of what we're thinking of:

ASP.NET

1327

ASP.NET Application - Tracing Doesn't Work

by: rehto | last post by:

We have an ASP.NET 2.0 (C#) app and we want to enable tracing (see the code snippets below). The first time a user navigates to the app., the tracing works fine (the ASP.NET tracing appears on the screen and writes to a text file). The problem happens any subsequent time the app. is used--tracing doesn't happen. It's as if tracing just turns itself off. So, we only get tracing on the first time the app runs but never any other time. ...

ASP.NET

2551

SQL procedure tracing

by: Prashant Sogarwal | last post by:

Hi I am trying to debug a stored procedure by using the source code given by Serge in one of the DW article about SQL procedure tracing (http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0409rielau/) I am unable to get rid of these errors while linking the sqlpltrc program using sqlpltrc.exp file on AIX 5.2, any help is appreciated. xlc_r $EXTRA_CFLAG -qmkshrobj -o $1 $1.o -ldb2 -ldb2psmd

DB2 Database

8174

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

8680

Problem With Comparison Operator <=> in G++

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...

C / C++

8624

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

7164

AI Job Threat for Devs

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...

Career Advice

6111

Access Europe - Using VBA to create a class based on a table - Wed 1 May

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...

Microsoft Access / VBA

4176

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

2607

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

1786

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

1485

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

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...

General