How to raise file capacity size outside dictionary?

Glenn Baxter Glenn at baxterit.com.au
Thu Apr 12 01:27:00 CDT 2007


Hi Judy, 
The dictionary capacity will limit the file size to 10,000 if you use
or had used QUTIL to create it.
Maybe your problem is PROCESS LIMIT within Qtp 
Ie, to process and output > 10000 records to a file (any file) you need
to increase the default process limit from 10,000 to a higher number.
Depending on your machine type you could 
SET PROCESS NOLIMIT or 
SET PROCESS LIMIT 20000 or 40000 etc
 
If you are on an MPE/MPE/Ix machine AND the file type is
MPE/MPER/KSAM/KSAMXL or possibly IMAGE* you MAY then have a physical
file limit on the file.
If this is the case; and the contents of the file need to be saved; you
will need to
a) unload the file
b) re-create it (with a larger capacity - either via the dictionary or
by adding a CAPACITY 60000 statement to the end of your CREATE
statement)
c) reload it
This will provide additional room before the EOF marker on the file.
*If the file is an IMAGE dataset - unless you may have to unload ALL
datasets in order to increase the capacity - unless you have a database
tool like Flexibase or Adager...
 
Much depends on your machine environment and file types - so maybe some
clues in this regard may allow others to assist you further!
 
Sincerely
Glenn Baxter
____________
Baxter IT Solutions
Software that works.
456 Victoria Parade 
East Melbourne 
Victoria Australia 3002
p: 03-9415-8733
m: 0412-826-503
f: 03-9415-8911
e: glenn at baxterit.com.au <mailto:glenn at baxterit.com.au> 
 
This e-mail message (and attachments) may contain information that is
confidential to Baxter IT Solutions. If you are not the intended
recipient you cannot use, distribute or copy the message or attachments.
In such a case, please notify the sender by return e-mail immediately
and erase all copies of the message and attachments. Opinions,
conclusions and other information in this message and attachments that
do not relate to the official business of Baxter IT Solutions are
neither given nor endorsed by it.
 

________________________________

From: powerh-l-bounces+glenn=baxterit.com.au at lists.sowder.com
[mailto:powerh-l-bounces+glenn=baxterit.com.au at lists.sowder.com] On
Behalf Of Judy Ann Bowyer
Sent: Thursday, 12 April 2007 3:55 PM
To: powerh-l at lists.sowder.com
Subject: How to raise file capacity size outside dictionary?


A file is created by the data dictionary with 10000 recs.  How can I run
QTP request with 20000 recs output file?  Dictionary has Capacity 10000
records.  Request has process limit 10000.
 
Some file in the dictionary do not have Capacity and some do.  Why?
 

Thank you,



Judy Quinn
judyab611 at yahoo.com



________________________________

Now that's room service! Choose from over 150,000 hotels 
in 45,000 destinations on Yahoo! Travel
<http://travel.yahoo.com/hotelsearchpage;_ylc=X3oDMTFtaTIzNXVjBF9TAzk3ND
A3NTg5BF9zAzI3MTk0ODEEcG9zAzIEc2VjA21haWx0YWdsaW5lBHNsawNxMS0wNw-->  to
find your fit.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.sowder.com/pipermail/powerh-l/attachments/20070412/d41dc863/attachment-0001.htm


More information about the powerh-l mailing list