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