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

Wed Jun 13 11:18:17 CDT 2007

Robert

Thanks, but unfortunately neither of those commands work on this version 
of QTP (6.07.F)

Regards 
Andrew Tymm
Senior Analyst/Programmer / DBA 

"Robert Mills" <robert.mills at pinnaclearvato.co.uk>
13/06/2007 17:12

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

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/e31a8ee9/attachment.html