Kbase P48990: Does -Bt parametr impact Native 4GL client running on AS/400 ?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
2/3/2005 |
|
Status: Unverified
GOAL:
Does -Bt parameter impact Native 4GL client running on AS/400 ?
FACT(s) (Environment):
IBM AS/400 (RISC)
Progress/400 DataServer
FIX:
Buffer Size for Temporary Tables (-Bt) is a valid parameter for Native 4GL client like for any other Progress client. It specifies the size of the buffer pool for blocks/records from the temporary table.
Whenever the allocated buffer space for temp-tables in the main storage is running out the AS/400 system creates additional temporary file in the ASP to handle requests of operations against temp-tables. The process would resemble the paging or swapping mechanism (I/O influences overall performance).
So, increasing -Bt allocates more memory and the "paging" wouldn't occur.