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.

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.

how to find the trace file. we have not any changes.
please advice.

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

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

in addition to what Dave already brought up, you might want to check your sm settings.

thanks.
1. let me know how to check the SM setup form the server.