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

[Joe Boyle]

With problem qtps, you could always use quiz to sort the data out to
subfiles ( quiz is more efficient than qtp with sort files ). Then access
the subfiles with 'sorted' syntax, qtp would not usually generate a scratch
file in this scenario.

 

  _____  

From: powerh-l-bounces+atla38=dsl.pipex.com at lists.sowder.com
[mailto:powerh-l-bounces+atla38=dsl.pipex.com at lists.sowder.com] On Behalf Of
Andrew.Tymm at computacenter.com
Sent: 13 June 2007 16:18
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/f9a4aa94/attachment.htm