mahadevan
23rd November 2005, 15:50
Hello,
We are using BaaN IV c4 ,Win 2003,sql 2000.

We have taken seq .dump and same was restored by using ttaad4227m000 and ttaad4225m000 (reorganise).
SEQ.dump size aprx: 2.15 gb

Executed following sessions:
1.delete table (normal company not 000)
2.ttaad4227m000 ( normal company not 000)
3.ttaad4225m000 (normal company not 000)


to restore the seq.dump it has taken 6 hours,for reorganise 4 hours.

is it correct this much taking to restore seq.dump , else we need to do some fine tuning.

please advice.

NPRao
23rd November 2005, 20:49
Mahadevan,

Refer to the existing threads for already discussed topics.

Improve speed of sequential dump (http://www.baanboard.com/baanboard/showthread.php?t=24806&highlight=RDS_FULL)

rds_full variable (http://www.baanboard.com/baanboard/showthread.php?t=108&highlight=RDS_FULL)

Try to search with the keywords RDS_FULL and also refer to the database driver manual.