Hi All,
We have requirement to pass a CIM to QAD's simulation cost rollup. This, we need will need to do for around 50 sites and around 24 cost sets for each site ie 50 * 24 CIMs.
Version of QAD is eB2 character version on unix.
While doing this, the process, it takes hell a lot of time. Moreover, the BI file grows like anything. Sometime it crosses 2gb and the database crashes.
Is there any parameter we need to look into to reduce the growth of BI file and improve the performance?
The DB is in multi user mode. The BI file which i mention above is actually the b1 file.
The parameter for main database in thestartup script is below
-L 400000 -c 350 -B 1000
The parameter while connecting the db is below
-Bt 350 -D 100 -mmax 3000 -nb 200 -s 63
Please note that this is being done in development environment and there are hardly 10 users. The server is IBM AIX and it has minimum configuration like 1 GB RAM and 1 processor.
Any idea will help us. Little urgent please.
Mugundan
We have requirement to pass a CIM to QAD's simulation cost rollup. This, we need will need to do for around 50 sites and around 24 cost sets for each site ie 50 * 24 CIMs.
Version of QAD is eB2 character version on unix.
While doing this, the process, it takes hell a lot of time. Moreover, the BI file grows like anything. Sometime it crosses 2gb and the database crashes.
Is there any parameter we need to look into to reduce the growth of BI file and improve the performance?
The DB is in multi user mode. The BI file which i mention above is actually the b1 file.
The parameter for main database in thestartup script is below
-L 400000 -c 350 -B 1000
The parameter while connecting the db is below
-Bt 350 -D 100 -mmax 3000 -nb 200 -s 63
Please note that this is being done in development environment and there are hardly 10 users. The server is IBM AIX and it has minimum configuration like 1 GB RAM and 1 processor.
Any idea will help us. Little urgent please.
Mugundan