mahadevan
3rd December 2004, 07:46
Hi,
We are using BaaNIVc4 on sql7 withNT environment. the service pack upto 17 and latest porting set.

when we login and connect to some sessions the retireival is very slow, calling
session. it takes some time 3 to 5 minutes. once we open the main sessions other sub sessions has no problem.

how to solve this problem.

please advice.

malutz
6th December 2004, 10:45
Have you created a trace file for starting those sessions? In there you might find a certain table that needs to be reorganized or a poor select-statement.

mahadevan
6th December 2004, 12:34
how to find the trace file. we have not any changes.
please advice.

malutz
6th December 2004, 13:02
Hej,

If you add the following line as a Bshell-command (see Screenshot).
A tracefile with the execution times for queries is generated in the
${BSE}/tmp directory. The file will be called "bshell.<pid>"

-- -set TT_SQL_TRACE=0200

dave_23
6th December 2004, 21:25
What porting set are you on? That was a problem a few porting sets back
since it had to basically re-load all of the DDs into shared memory when you access the first session.


Dave

Francesco
6th December 2004, 23:08
in addition to what Dave already brought up, you might want to check your sm settings.

mahadevan
7th December 2004, 10:01
thanks.
1. let me know how to check the SM setup form the server.