Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Microfocus 4.1 and filesizes > 2Gb 1

Status
Not open for further replies.

gbell

MIS
Feb 19, 2002
86
0
0
AU
We're experiencing a problem attempting a conversion on one of the tables where the extracted flat file exceeds two Gigabytes. It's giving a run time error of 194 and the manual says to recode your program to create more than one file - a workaround. With later versions of Micofocus you can configure the system to use files greater than 2 Gig.

Does anyone know if it is possible to configure Microfocus 4.1 for UNIX to accept filesizes greater than 2 Gig, and if so, where and how?

Thanks in advance.
Greg
 
We had the same problem but it was the OS version with the 2gb limit. As a work around we are dumping that table using two msd (copyied to do half each) and are putting it back together on the new machine befoer the msc runs.
 
What I have always done for the dump/convert/load is to use compressed files. Examples below

Email me if you have any questions:
Jeff Sullivan
AddOns Inc
jeff@addonsinc.com

Dump:

MIMS_HOME=/conversion/13s-dump
export MIMS_HOME
cd $MIMS_HOME
pwd
#
date
#
mkfifo MSU90018
nohup gzip -1 <MSU90018 >MSU90018.gz &
#
mimsoci -idbg msd90018
#
date
#


Convert:

# Name: 34-conv
#
# Author: AddOns Inc / Jeff Sullivan
#
# Date: 07-Mar-02
#
# Desc: Perform conversion of the MSF900 file
#
cd /conversion3/52-load
#
rm MSU90018
rm MSN90026
#
mkfifo MSU90018
nohup gunzip </conversion2/52-input/MSU90018.gz >MSU90018 &
#
mkfifo MSN90026.msc900
nohup gzip -1 <MSN90026.msc900 >MSN90026.gz &
#
mimsrts MSC900
#
date
#
# End of Script

Load:

# Name: 61-load
#
# Author: AddOns Inc / Jeff Sullivan
#
# Date: 07-Mar-02
#
# Desc: Perform load the MSF900 file
#
cd /conversion2/52-load
#
rm MSN90026
#
mkfifo MSN90026
#
nohup gunzip </conversion2/52-load/MSN90026.gz >MSN90026 &
#
mimsrts MSL90026
#
date
#
# End of Script


Jeff Sullivan
AddOns Inc
jeff@addonsinc.com
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top