Hi,

I would like to use multiple db_resource file for OLTP and data intensive operation (data dump / heavy reads etc). I read on the board that we have an option to use multiple db_resource file using USR_DBx_RES variable. Can anyone help me out as to how exactly is this used.

Thanks in advance
Regards
Max

I think you can get the exact details on Baan Porting Set document. I have never implemented, but one has to define 2 variables USR_DBC_RES (for File Location) and USR_DBS_RES (with db_resource file specs).

-- Avinash

I will try it out.

Regards
Gag's

As example:

- you have your normal $BSE/lib/defaults/db_resource
- you build a new file that fetches more rows or with improvements, called $BSE/lib/defaults/db_resource.fast

- on the BW config parameter field use -- -set (below parameters) or do an export (below parameters) on the user .profile (if using ba6.1):
USR_DBC_RES=lib/defaults/db_resource.fast
USR_DBS_RES=lib/defaults/db_resource.fast

Just a note of clarification, USR_DBC_RES and USR_DBS_RES refer to the database driver client (DBC) which is the bshell and the database driver server (DBS) which is the database driver itself. I have never set these to different values when using a seperate db_resource file, but it is theoretically possible.

Also, per Victor's comments, keep in mind that these variables give the directory path UNDER THE $BSE. I have seen many times when the full $BSE path is supplied and this will not work then.

-- Jim