We have observed this second time. After we added a field in table - tdsls040 some of the user experienced the sale order header and line session to perfomr slow. They experience this problem intermittently. Any reason for such a behavior?

Thanks


Arvind Patil

Is this new field part of the index?

If not, it could be just a coincidence that the users started feeling a bit of slowness in the sessions. Did you check the network traffic or the server resource utilization at the time the users felt the slowness?

Last but not least, Did you run Re-organize tables after this inclusion? or perhaps a Create Run time data dictionary {ttadv5210m000) for the table that was modified?

sk

Suresh,
I only did Convert to Run time Dictionary and didn't do Create or re-orgainize table. I think the Convert process empties the table and again loads the data.
The new field is not part of the index. Also, from my previous experience it seems the problem gets resolved like in a weeks time. I am thinking it is somehow related with Database query optimizer, but I am not a DB expert, so cannot say.


Arvind Patil

B.t.w are the users experiencing this slownes while reading or writing data?

sk

Writing the data and it is intermittent. Say 2 lines will behave normally thne the third omne will take susbtantially long time

AP

Run the Re-organize tables session for the package range of the table that got modified. This may or may not help but running it wont harm your environment.

sk

But After convert to run time, is reorg required?

Arvind patil

Re-org is normally required keep baan database referential integrity in tact . If u do not suspect any problem in this regard , then there is no need to run . This reorg itself can be good overhead on the system .

Which process takes more in process monitor , ntbshell or db driver . Any log message in eventvwr .

Hello avpatil,
In some cases, the table need to update their statistics. I have worked with Informix and Oracle, and this databases have a procedure to perform this.
You should ask to your DBA to verify it.

Good luck.

Under windows environment I am told that once we do convert to run time with "Reconfigure" checked then system automatically does a "Refrential integrity" Check, but under windows environment a separate process is called? Is that a bshell process? And how do we know it is done.

Arvind Patil

Update statistics is a separate process from baan. This process runs directly from database. As a rule of thumb you must update statistics after upload great amount of data to a table. But in some cases, I have found that this process can help on certain baan sessions that runs slow.

How can you know when it is done?
Only the DBA knows when the statistics was updated. This function is a 100% DBA task.

For example, I update the statistics at last once a month.

Good luck.

Hi, I was referring to "Referential Integrity" check. Under windows environment does Baan launches a separate process? If yes, is it a Bshell process or what? And how do we know it is complete. I was not asking "Update stat?

Arvind Patil

I see.
On my unix box, when you run an integrity check, internally the system executes the command refint6.1

On windows boxes, I suppose there are an equivalent.

When the process finish, on my case, the waiting clock, changes and close the black screen opened first.

Hope this help.

Also refer to the -

BaanERP Oracle Database Driver Technical Reference Manual
Document Information
Code: U7076C US
Group: User Documentation
Edition: C
Date: May, 2000

BaanERP porting set 7.X
This section describes the configuration file format as used by the porting sets 7.X. Although these porting sets are capable of handling the configuration file as used by older porting sets, You must use the new configuration files.
File Format: $BSE/lib/ora/ora_driver_param
The driver parameter file provides a means to influence the behavior of the database driver on a per table/index basis for:
The ownership of the database tables (See Chapter Database Security).
The query generation (See Chapter Query Tuning).
The refresh time of the record cache (level-1 mode only).
The following is an example of an entry in the driver parameter file:
*:*:T: group:0214::
In this example, the database driver will create tables owned by a BaanERP group, and will use the iterative technique during the query generation. A driver parameter file is defined for each database driver. The storage file for the BaanERP Oracle database driver is called ora_driver_param and is located in the Windows NT directory %BSE%\lib\ora or the UNIX directory $BSE/lib/ora. If the ora_driver_param file does not exist, the driver will fall back to the functionality of porting set 6.2a.X, and use the ora_storage file to retrieve the required information.

table/index optimization
Description
Specific flags related to indexes and tables can be specified. When specified on a “T” object entry, it
defines the default for all indexes.
Octal values can be used to set the flags for a specific index or table.
00 use default initial technique (filter)
01 ignored, treated like 00
02 ignored, treated like 00
03 initial technique is nested
04 initial technique is iterative
05 initial technique is filter
06 ignored, treated like 00
07 ignored, treated like 00
The following flags can be ORed to this value:
0010 generate statistics at creation of the table
0020 disable index in WHERE clause for descending
joins so it can be used for ORDER BY
0040 (not used)
0100 disable INDEX hint for ascending joins
0200 generate INDEX_DESC hint for descending joins
0400 (reserved)
The following values for the index optimization field are recommended:
0214 for Oracle server versions 7.3.2 and later.
Example 0214 – recommended value for Level 2 mode

Re-org runs refint executable . Normally reconfigs done through bdbreconfig in convert runtime will have 'ignore referential integrity' turned off . So ref integrity is taken care at re-org .

I think B40c3 works on SQL2k SP3a . Also SQL7 will not have level 2 driver . Level 2 driver is definitely way faster .

can you confirm whether the field has got added in the Database Table and whether it is getting updated into the table?

The issue was with update stats. It is running fine with update stats.
Thanks everyone for their inputs.

Arvind Patil