<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.6000.16441" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=683010516-13062007><FONT face=Arial
color=#0000ff size=2>Daniel,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=683010516-13062007><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=683010516-13062007><FONT face=Arial
color=#0000ff size=2>Fire up QTP and enter the command </FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=683010516-13062007><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=683010516-13062007><FONT face=Arial
color=#0000ff size=2> SHOW TRACE</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=683010516-13062007><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=683010516-13062007><FONT face=Arial
color=#0000ff size=2>If it does not object then enter the
command</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=683010516-13062007><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=683010516-13062007><FONT face=Arial
color=#0000ff size=2> SET TRACE SORT</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=683010516-13062007><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=683010516-13062007><FONT face=Arial
color=#0000ff size=2>If it still does not object then add this at the start of
one of your programs (before the run statement).</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=683010516-13062007><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=683010516-13062007><FONT face=Arial
color=#0000ff size=2>You should get something like the
following:</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=683010516-13062007><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=683010516-13062007><FONT face=Courier
size=1></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=683010516-13062007><FONT face=Courier
size=1>Sort/Scratch File Size</DIV>
<DIV dir=ltr align=left>
<P align=left>Record EMPLOYEES - Record Size 112 - Total Size 188</P>
<P align=left>Record SKILLS - Record Size 14 - Total Size 90</P>
<P align=left>Sort Key Area Size 4</P>
<P>Sort/Scratch File Size (in bytes) 282</P></FONT></SPAN></DIV>
<DIV><FONT face="Comic Sans MS" size=2>regards,</FONT> <BR><FONT
face=Arial> </FONT> <BR><FONT face="Comic Sans MS" size=2>Robert
W.Mills</FONT> <BR><FONT face="Comic Sans MS" size=2>Systems Development
Manager</FONT> <BR><FONT face="Comic Sans MS" size=2>Pinnacle
Arvato</FONT> <BR><FONT face="Comic Sans MS" size=2>(0</FONT><FONT
face="Comic Sans MS" size=2>20</FONT><FONT face="Comic Sans MS" size=2>)</FONT>
<FONT face="Comic Sans MS" size=2>8309 3604</FONT> </DIV>
<DIV> </DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><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<BR><B>Sent:</B> 13 June 2007
16:56<BR><B>To:</B> Daniel Mielke<BR><B>Cc:</B>
powerh-l@lists.sowder.com<BR><B>Subject:</B> RE: How to locate scratch
(intermediate) files created by QTP oniSeries (AS/400)<BR></FONT><BR></DIV>
<DIV></DIV><BR><FONT face=sans-serif size=2>Daniel<BR></FONT><FONT
face="AR Sans Serif" size=2><BR></FONT><FONT face=sans-serif size=2>We've not
actually applied it yet (scheduled for next week) due to a major migration
project taking place.</FONT> <BR><BR><FONT face=sans-serif size=2>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>
<BR><BR><FONT face=sans-serif size=2>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. <BR></FONT><BR><FONT face=sans-serif
size=2>Hopefully we'll be able to look at the scratch files during the
testing</FONT> <BR><BR><FONT face="AR Sans Serif" size=2>Regards </FONT>
<P><FONT face=Arial size=1><B>Andrew Tymm<BR>Senior Analyst/Programmer / DBA
</B></FONT><BR><BR><BR>
<TABLE width="100%">
<TBODY>
<TR vAlign=top>
<TD>
<TD><FONT face=sans-serif size=1><B>"Daniel Mielke"
<DMielke@aic.com></B></FONT>
<P><FONT face=sans-serif size=1>13/06/2007 16:49</FONT> <BR></P>
<TD><FONT face=Arial size=1> </FONT><BR><FONT
face=sans-serif size=1> To:
Andrew Tymm/Hatfield/CCenter@CCenter,
<powerh-l@lists.sowder.com></FONT> <BR><FONT face=sans-serif
size=1> cc: </FONT>
<BR><FONT face=sans-serif size=1> Subject:
RE: How to locate scratch (intermediate) files
created by QTP on iSeries (AS/400)</FONT></TR></TBODY></TABLE><BR><BR><BR><FONT
face=Arial color=#000080 size=2>Hi Andrew,</FONT> <BR><FONT face=Arial
color=#000080 size=2> </FONT> <BR><FONT face=Arial color=#000080
size=2>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> <BR><FONT
face=Arial color=#000080 size=2> </FONT> <BR><FONT face=Arial color=#000080
size=2>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> <BR><FONT
face=Arial color=#000080 size=2> </FONT> <BR><FONT face=Arial color=#000080
size=2>Is there a failure in your QTP?</FONT> <BR><FONT face=Arial color=#000080
size=2> </FONT>
<DIV align=center><BR>
<HR>
</DIV><BR><FONT face=Tahoma size=2><B>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> <BR><FONT
face="Times New Roman" size=3> </FONT> <BR><FONT face=sans-serif
size=2><BR>Hi</FONT><FONT face="Times New Roman" size=3> <BR></FONT><FONT
face=sans-serif size=2><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 face="Times New Roman" size=3> <BR></FONT><FONT
face=sans-serif
size=2><BR>----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------</FONT><FONT
face="Times New Roman" size=3> </FONT><FONT face=Arial color=blue
size=2><BR>Here is an explanation of the possible scenario which can cause QTP
to abort...</FONT><FONT face="Times New Roman" size=3> <BR></FONT><FONT
face=Arial color=blue size=2><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
face="Times New Roman" size=3> <BR></FONT><FONT face=Arial color=blue
size=2><BR>So the problem would arise if <BR>1. QTP need to create a
scratch file.</FONT><FONT face="Times New Roman" size=3> </FONT><FONT face=Arial
color=blue size=2><BR>2. The record size and the number of records cause
the miscalculation to occur. Unfortunately, there are no specific
details.</FONT><FONT face="Times New Roman" size=3> </FONT><FONT face=sans-serif
size=2><BR>----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------</FONT><FONT
face="Times New Roman" size=3> <BR></FONT><FONT face=sans-serif size=2><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 face="Times New Roman" size=3>
<BR></FONT><FONT face="AR Sans Serif" size=2><BR>Regards </FONT>
<P><FONT face=Arial size=1><B>Andrew Tymm<BR>Senior Analyst/Programmer /
DBA</B></FONT><FONT face="Times New Roman" size=3> </FONT>
<P><FONT face=Arial
size=1>**********************************************************************</FONT>
<P><FONT face=Arial size=1>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>
<P><FONT face=Arial size=1>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 face=Arial size=1></FONT>
<P><FONT face=Arial size=1>The contents of this email are intended for the named
addressee only.</FONT>
<P><FONT face=Arial size=1>It contains information which may be confidential and
which may also be privileged.</FONT>
<P><FONT face=Arial size=1>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>
<P><FONT face=Arial size=1>If you receive it in error please notify us
immediately and then destroy it.</FONT>
<P><FONT face=Arial size=1>Computacenter information is available from:</FONT>
<P><FONT face=Arial size=1>http://www.computacenter.com</FONT>
<P><FONT face=Arial
size=1>**********************************************************************</FONT>
<P>
<P></P></BODY></HTML>