Hi Baan friends

If you are using Sql server 2000 as backend with BaanIV and OS Win2k
then pls can you tell me is the settings in my db_resource file are correct
as my sequential dump backup(online) is taking 2HR time.
I also searched about my prob in this forum and i found some setting
regarding " set RDS_FULL" but in my db_resource file no such setting present
so how i can add it to improve sequential dump speed.

---contents of db_resource file

dbsinit:01
lock_retry:"5*100,5*500"
msql_use_ffo:0

Thanks & Regards
IndoTech

You wouldn't want to set stuff like rds_full/ssts_set_rows in the db_resource file, to speed up bdbpre/bdbpost

you should set them in the environment just for that session in the bw config:
-- -set RDS_FULL=1000 -set SSTS_SET_ROWS=1000

That way, when your users bring up maintain item data, they're not
querying 1000 records at a time...

Dave

OR.........

you can create 2 db_resource files on server-
[DEV:bsp]/app/lms/lmsv/opt/bse/lib/defaults>ll
total 4
-rwxr-xr-x 1 bsp bsp 271 Apr 6 2005 db_resource
-rwxr-xr-x 1 bsp bsp 271 Apr 6 2005 db_resource.fast
[DEV:bsp]/app/lms/lmsv/opt/bse/lib/defaults>cat db_resource.fast
use_shm_info:1
dbsinit:01
ora_init: 0111000
rds_full:500
ssts_set_rows:500
ora_max_array_fetch:500
ora_max_array_insert:500
nls_lang:american_america.we8iso8859p1
nls_sort:binary
oracle_home:/app/common/oracle/product/8.1.7.4
ora_temporary_tablespace:TEMP
and then use it on the BW command -
-set USR_DBC_RES=lib/defaults/db_resource.fast -set USR_DBS_RES=lib/defaults/db_resource.fast

Thank u Dave for ur reply

That u mean i have to set the command in BWconfig and then by login i should run
seqential dump session, is it correct ?

OR

I have to set command like
-- -set RDS_FULL=1000 -set SSTS_SET_ROWS=1000 {session number}

And also
Can u tell me my current db_resource file settings for MSSQL2K are correct or i can
improve it?

Thanks &Regards
IndoTech

Thank u NRao

Can u tel me the db_resource file settings for MSSQL2K. for regular work
and for sequential Backup work

Regards
IndoTech

Thank u Dave for ur reply

That u mean i have to set the command in BWconfig and then by login i should run
seqential dump session, is it correct ?

OR

I have to set command like
-- -set RDS_FULL=1000 -set SSTS_SET_ROWS=1000 {session number}


Both are fine


And also
Can u tell me my current db_resource file settings for MSSQL2K are correct or i can
improve it?

Thanks &Regards
IndoTech

Looks fine. MSSQL doesn't really have a whole lot of options for the db_resource.

Also, the db_resource settings for Level 1 and level 2 are different. Yours look like level 1 settings.

Dave