|
Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com |
HELP: DATABASE TO BIG ?
From: Joao (joao
inforap.pt)
Date: Thu Jul 03 2003 - 10:13:42 CDT
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Hello Again,
My LOADER Version :
ReplMan 7.4.3 Build 010-120-035-462
My Problem is the following :
I Have 2 Machines (No Network Between them)
MACH 1 : AIX 5.2 on IBM RISC
MACH 2 : W2000 Server on P4 i386
I Have a Big database (5 Gb) with about 500 tables some with a few records
other with milions of records.I Need that database be transfered periodicaly
from AIX to W2000.
The Standard Backup is not the solution because not work.(Some
incompatibility between platforms)
My try was :
I have created a program that generates a command file to export all the
tables to file :
DATAEXTRACT FOR DATALOAD TABLE A
OUTFILE 'c:\Backup\restore.ssc'
OUTFILE 'c:\Backup\A.DAT'
//
DATAEXTRACT FOR DATALOAD TABLE A1
OUTFILE 'c:\Backup\restore.ssc' APPEND
OUTFILE 'c:\Backup\A1.DAT'
//
DATAEXTRACT FOR DATALOAD TABLE A2
OUTFILE 'c:\Backup\restore.ssc' APPEND
OUTFILE 'c:\Backup\A2.DAT'
//
and so on ....
Then Run...
But when I Have a table that has milions of records the program stops.
If I Try only that table the program Stops when the file has about 300 Mb
I Try that in 2 diferent machines and the result seams the same...
Any Idea ?????
Any Sugestion ??????
Tanks,
Joćo
_______________________________________________
sapdb.general mailing list
sapdb.general
listserv.sap.com
http://listserv.sap.com/mailman/listinfo/sapdb.general
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]