How to locate scratch (intermediate) files created by QTP oniSeries (AS/400)

[Robert Mills]

Daniel,
 
Fire up QTP and enter the command 
 
   SHOW TRACE
 
If it does not object then enter the command
 
  SET TRACE SORT
 
If it still does not object then add this at the start of one of your
programs (before the run statement).
 
You should get something like the following:
 
 
Sort/Scratch File Size

Record EMPLOYEES - Record Size 112 - Total Size 188

Record SKILLS - Record Size 14 - Total Size 90

Sort Key Area Size 4

Sort/Scratch File Size (in bytes) 282

regards, 
  
Robert W.Mills 
Systems Development Manager 
Pinnacle Arvato 
(020) 8309 3604 
 

  _____  

From:
powerh-l-bounces+robert.mills=pinnaclearvato.co.uk at lists.sowder.com
[mailto:powerh-l-bounces+robert.mills=pinnaclearvato.co.uk at lists.sowder.
com] On Behalf Of Andrew.Tymm at computacenter.com
Sent: 13 June 2007 16:56
To: Daniel Mielke
Cc: powerh-l at lists.sowder.com
Subject: RE: How to locate scratch (intermediate) files created by QTP
oniSeries (AS/400)



Daniel

We've not actually applied it yet (scheduled for next week) due to a
major migration project taking place. 

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. 

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. 

Hopefully we'll be able to look at the scratch files during the testing 

Regards 

Andrew Tymm
Senior Analyst/Programmer / DBA 



	"Daniel Mielke" <DMielke at aic.com> 

13/06/2007 16:49 


        
        To:        Andrew Tymm/Hatfield/CCenter at CCenter,
<powerh-l at lists.sowder.com> 
        cc:         
        Subject:        RE: How to locate scratch (intermediate) files
created by QTP on iSeries (AS/400)



Hi Andrew, 
  
First let me say how *shocked* I am to see an AS/400 question on the
list.  It has been so long, and sadly a dying breed. 
  
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. 
  
Is there a failure in your QTP? 
  

  _____  


From: powerh-l-bounces+dmielke=aic.com at lists.sowder.com
[mailto:powerh-l-bounces+dmielke=aic.com at lists.sowder.com] On Behalf Of
Andrew.Tymm at computacenter.com
Sent: Wednesday, June 13, 2007 11:18 AM
To: powerh-l at lists.sowder.com
Subject: How to locate scratch (intermediate) files created by QTP on
iSeries (AS/400) 
  

Hi 

We've received a fix for our "dictionary is locked for update" error but
have been informed it introduces the following error in QTP :- 

------------------------------------------------------------------------
------------------------------------------------------------------------
---------------------------------------------------- 
Here is an explanation of the possible scenario which can cause QTP to
abort... 

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 
than 16MB then QTP creates a linked list of the UserSpace objects.
However when creating the linked lists it might 
miscalculate when to link two user spaces together.   The miscalculation
would vary depending on the record size and the number of 
records being processed.  For some record sizes the problem would never
occur.   

So the problem would arise if 
1.  QTP need to create a scratch file. 
2.  The record size and the number of records cause the miscalculation
to occur. Unfortunately, there are no specific details. 
------------------------------------------------------------------------
------------------------------------------------------------------------
---------------------------------------------------- 

Does anybody know how to locate/read the scratch files on iSeries/AS400
so we can analyze the impact of this "feature"? 

Regards 

Andrew Tymm
Senior Analyst/Programmer / DBA 

********************************************************************** 

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 

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 

The contents of this email are intended for the named addressee only. 

It contains information which may be confidential and which may also be
privileged. 

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. 

If you receive it in error please notify us immediately and then destroy
it. 

Computacenter information is available from: 

http://www.computacenter.com 

********************************************************************** 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.sowder.com/pipermail/powerh-l/attachments/20070613/24bd271d/attachment.html