I should build a function library for VUGEN so I can reuse these everywhere I go, as I often find myself having to redo these. Anyhow this bit of code will strip out newline characters and rebuild the string so it is new line character free.
My memory is not the best. Recently I had to write a quick Loadrunner script to connect to a JMS queue, using the OC4J Oracle containers for J2EE libraries. A simple task that caused me a little grief due to some quirky configuration details. Well I have posted some quick tips here – so next time I do this I will remember what I did.
The following was done utilising LoadRuner v11.00.0.0 Here we go:-
Read more
If you repeat the execution of short, say 1 hour bursts, of performance tests, you run the risk of skewing your performance results as a result of database caching. This can happen, as we often want to repeat a test utilising the same data, for baselining and then comparison benchmark runs. Using the same data in repeated tests may retrieve data from the database internal cache, reducing or even eliminating disk reads, which can give better preceived performance results.
Well the young boys keep raving about Ruby. I still think Python has a lot more library support via eggs because it has been around longer. Anyhow I gave Ruby a crack for this trivial task and, yes, the same as Python, it does’nt take too much code to automate a painful manual task.
This little script, runs on windows. It will connect to a remote IBM DB2 database, execute a query, then output the result set to a CSV file. You will need some prerequisites before you can do this. Before you continue for this you will need a DB2 client installed, although not the full DB2 client is needed you can download and install the appropriate IBM Data Server Driver for ODBC/JDBC and CLI from here IBM DataServer drivers. If you already have DB2 client software installed then dont worry about this.
I have been having alot of fun with my MacBok of late. I think one of the kids sat on the screen and cracked the LCD screen, and I have been putting off getting that fixed, due to both the cost and downtime involved. This will have to be addressed soon though as the cracked smudge is spreading rather rapidly across the screen and people are commenting on the fantastic screensaver I have.
Prior to the broken LCD screen I had a problem, which a number of people seem to have, where on bootup a question mark folder appears, accompanied by around 5 clicking noises. All this seems to point to a faulty hard drive. Well after googling for a solution and finding none that worked for me I have discovered one that does work.
Lately I have been using The Grinder to simulate some http user traffic. Its a great little free tool. Here are a few tips to help you with correlating data from server responses.
Often in performance testing we need to get processing times of transactions which have been timestamped in a log somewhere. This usually entails multiple log entries for the same transaction which have been processed for in and out entries. Consider timekeeper entries for example, employees clocking in for work and out of work multiple times thoughout the day. Read on for an example SQL that can be helpful
In performance testing it is often necessary to do bulk loads of data into databases via XML payloads, to prepare for a test. For my example I had to load 250,000 elements via XML to create accounts. The XML structure had one root or top level element with many child elements, also many batches of the root elements. I decided I would perform a commit after constructing each root element, with the corresponding amounts of child elements. I made both the batch number of root elements and the child elements both configurable. This resulted in the following PL SQL code. I have deleted out certain parts of the XML so as to protect client.
Read more
There is an almost complete installation guide to installing Hyperic on Ubuntu here Hyperic on Ubuntu . The only part missing is adding the agent and server as part of the automatic startup. This post shows you how to do this.
Read more
If you are looking to perform either of these functions then go no further than downloading the free Java IDE tools, Eclipse or Netbeans. Both of these have adequate functionality for validating XMLs and WSDLs. The latest review on the comparison of these two tools is that they both compare almost on par. Therefore up to you on which one you download. I chose NetBeans so, download from here NetBeans or if you prefer Eclipse
To validate from Netbeans:
1. From main menu select File->Open and select the file to validate
2. Select the validate XML icon
3. Check the Output:XML Check window for errors
Subscribe to my feed | Comrade on Using Ruby to connect to DB2 a… |
 | Gaston on Correlation using The Gri… |
 | Nick on Correlation using The Gri… |
| Gaston on Correlation using The Gri… |
| Nick on Correlation using The Gri… |
