<br><font size=2 face="sans-serif">Robert</font>
<br>
<br><font size=2 face="sans-serif">Thanks, but unfortunately neither of those commands work on this version of QTP (6.07.F)<br>
</font><font size=2 face="AR Sans Serif"><br>
Regards </font>
<p><font size=1 face="Arial"><b>Andrew Tymm<br>
Senior Analyst/Programmer / DBA </b></font>
<br>
<br>
<br>
<table width=100%>
<tr valign=top>
<td>
<td><font size=1 face="sans-serif"><b>"Robert Mills" <robert.mills@pinnaclearvato.co.uk></b></font>
<p><font size=1 face="sans-serif">13/06/2007 17:12</font>
<br>
<td><font size=1 face="Arial"> </font>
<br><font size=1 face="sans-serif"> To: Andrew Tymm/Hatfield/CCenter@CCenter, "Daniel Mielke" <DMielke@aic.com></font>
<br><font size=1 face="sans-serif"> cc: <powerh-l@lists.sowder.com></font>
<br><font size=1 face="sans-serif"> Subject: RE: How to locate scratch (intermediate) files created by QTP oniSeries (AS/400)</font></table>
<br>
<br>
<br><font size=2 color=blue face="Arial">Daniel,</font>
<br><font size=3 face="Times New Roman"> </font>
<br><font size=2 color=blue face="Arial">Fire up QTP and enter the command </font>
<br><font size=3 face="Times New Roman"> </font>
<br><font size=2 color=blue face="Arial"> SHOW TRACE</font>
<br><font size=3 face="Times New Roman"> </font>
<br><font size=2 color=blue face="Arial">If it does not object then enter the command</font>
<br><font size=3 face="Times New Roman"> </font>
<br><font size=2 color=blue face="Arial"> SET TRACE SORT</font>
<br><font size=3 face="Times New Roman"> </font>
<br><font size=2 color=blue face="Arial">If it still does not object then add this at the start of one of your programs (before the run statement).</font>
<br><font size=3 face="Times New Roman"> </font>
<br><font size=2 color=blue face="Arial">You should get something like the following:</font>
<br><font size=3 face="Times New Roman"> </font>
<br><font size=3 face="Times New Roman"> </font>
<br><font size=1 face="Courier">Sort/Scratch File Size</font>
<p><font size=1 face="Courier">Record EMPLOYEES - Record Size 112 - Total Size 188</font>
<p><font size=1 face="Courier">Record SKILLS - Record Size 14 - Total Size 90</font>
<p><font size=1 face="Courier">Sort Key Area Size 4</font>
<p><font size=1 face="Courier">Sort/Scratch File Size (in bytes) 282</font>
<p><font size=2 face="Comic Sans MS">regards,</font><font size=3 face="Times New Roman"> </font><font size=3 face="Arial"><br>
</font><font size=3 face="Times New Roman"> </font><font size=2 face="Comic Sans MS"><br>
Robert W.Mills</font><font size=3 face="Times New Roman"> </font><font size=2 face="Comic Sans MS"><br>
Systems Development Manager</font><font size=3 face="Times New Roman"> </font><font size=2 face="Comic Sans MS"><br>
Pinnacle Arvato</font><font size=3 face="Times New Roman"> </font><font size=2 face="Comic Sans MS"><br>
(020)</font><font size=3 face="Times New Roman"> </font><font size=2 face="Comic Sans MS">8309 3604</font><font size=3 face="Times New Roman"> </font>
<br><font size=3 face="Times New Roman"> </font>
<br>
<br>
<hr><font size=2 face="Tahoma"><b>From:</b> powerh-l-bounces+robert.mills=pinnaclearvato.co.uk@lists.sowder.com [mailto:powerh-l-bounces+robert.mills=pinnaclearvato.co.uk@lists.sowder.com] <b>On Behalf Of </b>Andrew.Tymm@computacenter.com<b><br>
Sent:</b> 13 June 2007 16:56<b><br>
To:</b> Daniel Mielke<b><br>
Cc:</b> powerh-l@lists.sowder.com<b><br>
Subject:</b> RE: How to locate scratch (intermediate) files created by QTP oniSeries (AS/400)</font><font size=3 face="Times New Roman"><br>
</font>
<br><font size=2 face="sans-serif"><br>
Daniel</font><font size=2 face="AR Sans Serif"><br>
</font><font size=2 face="sans-serif"><br>
We've not actually applied it yet (scheduled for next week) due to a major migration project taking place.</font><font size=3 face="Times New Roman"> <br>
</font><font size=2 face="sans-serif"><br>
We are currently trying to analyze our system to work out if we have any QTPs that might be impacted. We were hoping someone who had a good working knowledge of Powerhouse on the AS/400 might be able to provide us with an easy way to look at the scratch files rather than us having to go through each program and calculate the estimated size of any potential scratch files.</font><font size=3 face="Times New Roman"> <br>
</font><font size=2 face="sans-serif"><br>
Our plan is to create a data environment and run all of our QTPs without the fix applied and then refresh the data and rerun/compare the tests after application. </font><font size=3 face="Times New Roman"><br>
</font><font size=2 face="sans-serif"><br>
Hopefully we'll be able to look at the scratch files during the testing</font><font size=3 face="Times New Roman"> <br>
</font><font size=2 face="AR Sans Serif"><br>
Regards </font>
<p><font size=1 face="Arial"><b>Andrew Tymm<br>
Senior Analyst/Programmer / DBA </b></font><font size=3 face="Times New Roman"><br>
<br>
</font>
<table width=100%>
<tr valign=top>
<td width=1%>
<td width=30%><font size=1 face="sans-serif"><b>"Daniel Mielke" <DMielke@aic.com></b></font><font size=3 face="Times New Roman"> </font>
<p><font size=1 face="sans-serif">13/06/2007 16:49</font><font size=3 face="Times New Roman"> </font>
<td width=67%><font size=1 face="Arial"> </font><font size=1 face="sans-serif"><br>
To: Andrew Tymm/Hatfield/CCenter@CCenter, <powerh-l@lists.sowder.com></font><font size=3 face="Times New Roman"> </font><font size=1 face="sans-serif"><br>
cc: </font><font size=3 face="Times New Roman"> </font><font size=1 face="sans-serif"><br>
Subject: RE: How to locate scratch (intermediate) files created by QTP on iSeries (AS/400)</font></table>
<br><font size=3 face="Times New Roman"><br>
<br>
</font><font size=2 color=#000080 face="Arial"><br>
Hi Andrew,</font><font size=3 face="Times New Roman"> </font><font size=2 color=#000080 face="Arial"><br>
</font><font size=3 face="Times New Roman"> </font><font size=2 color=#000080 face="Arial"><br>
First let me say how *<b>shocked</b>* I am to see an AS/400 question on the list. It has been so long, and sadly a dying breed.</font><font size=3 face="Times New Roman"> </font><font size=2 color=#000080 face="Arial"><br>
</font><font size=3 face="Times New Roman"> </font><font size=2 color=#000080 face="Arial"><br>
I would venture that the UserSpace objects get created in QTEMP. So, if you're running your QTP interactively, you might be able to view them. Now, viewing UserSpace objects is not as easy as DSPPFM (Display Physical File Member);you'll have to use an API to do that.</font><font size=3 face="Times New Roman"> </font><font size=2 color=#000080 face="Arial"><br>
</font><font size=3 face="Times New Roman"> </font><font size=2 color=#000080 face="Arial"><br>
Is there a failure in your QTP?</font><font size=3 face="Times New Roman"> </font><font size=2 color=#000080 face="Arial"><br>
</font><font size=3 face="Times New Roman"> </font>
<div align=center>
<br><font size=3 face="Times New Roman"><br>
</font>
<hr></div>
<br><font size=2 face="Tahoma"><b><br>
From:</b> powerh-l-bounces+dmielke=aic.com@lists.sowder.com [mailto:powerh-l-bounces+dmielke=aic.com@lists.sowder.com] <b>On Behalf Of </b>Andrew.Tymm@computacenter.com<b><br>
Sent:</b> Wednesday, June 13, 2007 11:18 AM<b><br>
To:</b> powerh-l@lists.sowder.com<b><br>
Subject:</b> How to locate scratch (intermediate) files created by QTP on iSeries (AS/400)</font><font size=3 face="Times New Roman"> <br>
</font><font size=2 face="sans-serif"><br>
<br>
Hi</font><font size=3 face="Times New Roman"> </font><font size=2 face="sans-serif"><br>
<br>
We've received a fix for our "dictionary is locked for update" error but have been informed it introduces the following error in QTP :-</font><font size=3 face="Times New Roman"> </font><font size=2 face="sans-serif"><br>
<br>
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------</font><font size=3 face="Times New Roman"> </font><font size=2 color=blue face="Arial"><br>
Here is an explanation of the possible scenario which can cause QTP to abort...</font><font size=3 face="Times New Roman"> </font><font size=2 color=blue face="Arial"><br>
<br>
When QTP creates a scratch file it creates a series of UserSpace objects which have a limit of 16MB. If the scratch file is larger <br>
than 16MB then QTP creates a linked list of the UserSpace objects. However when creating the linked lists it might <br>
miscalculate when to link two user spaces together. The miscalculation would vary depending on the record size and the number of <br>
records being processed. For some record sizes the problem would never occur. </font><font size=3 face="Times New Roman"> </font><font size=2 color=blue face="Arial"><br>
<br>
So the problem would arise if <br>
1. QTP need to create a scratch file.</font><font size=3 face="Times New Roman"> </font><font size=2 color=blue face="Arial"><br>
2. The record size and the number of records cause the miscalculation to occur. Unfortunately, there are no specific details.</font><font size=3 face="Times New Roman"> </font><font size=2 face="sans-serif"><br>
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------</font><font size=3 face="Times New Roman"> </font><font size=2 face="sans-serif"><br>
<br>
Does anybody know how to locate/read the scratch files on iSeries/AS400 so we can analyze the impact of this "feature"?</font><font size=3 face="Times New Roman"> </font><font size=2 face="AR Sans Serif"><br>
<br>
Regards </font>
<p><font size=1 face="Arial"><b>Andrew Tymm<br>
Senior Analyst/Programmer / DBA</b></font><font size=3 face="Times New Roman"> </font>
<p><font size=1 face="Arial">**********************************************************************</font><font size=3 face="Times New Roman"> </font>
<p><font size=1 face="Arial">COMPUTACENTER PLC is registered in England and Wales with the registered number 03110569. Its registered office is at Hatfield Business Park, Hatfield Avenue, Hatfield, Hertfordshire AL10 9TW</font><font size=3 face="Times New Roman"> </font>
<p><font size=1 face="Arial">COMPUTACENTER (UK) Limited is registered in England and Wales with the registered number 01584718. Its registered office is at Hatfield Business Park, Hatfield Avenue, Hatfield, Hertfordshire AL10 9TW </font>
<p><font size=1 face="Arial">The contents of this email are intended for the named addressee only.</font><font size=3 face="Times New Roman"> </font>
<p><font size=1 face="Arial">It contains information which may be confidential and which may also be privileged.</font><font size=3 face="Times New Roman"> </font>
<p><font size=1 face="Arial">Unless you are the named addressee (or authorised to receive mail for the addressee) you may not copy or use it, or disclose it to anyone else.</font><font size=3 face="Times New Roman"> </font>
<p><font size=1 face="Arial">If you receive it in error please notify us immediately and then destroy it.</font><font size=3 face="Times New Roman"> </font>
<p><font size=1 face="Arial">Computacenter information is available from:</font><font size=3 face="Times New Roman"> </font>
<p><font size=1 face="Arial">http://www.computacenter.com</font><font size=3 face="Times New Roman"> </font>
<p><font size=1 face="Arial">**********************************************************************</font><font size=3 face="Times New Roman"> </font>
<p>
<p>