Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
db2syscs.exe taking too much memory?
493 views
Skip to first unread message
Glenna
Apr 19, 2002, 10:35:28 AM4/19/02
to
We just brought up DB2 V7.2 FP5 on a Windows 2000 machine (moved from
a V5.2 Solaris system). We have a C program that runs on the server
and processes all the SQL from VB client Winsocks (so we don't have to
install DB2 client & ODBC driver on all our user PCs). Looking at the
Windows processes, it seems that db2syscs.exe is taking way too much
memory. It starts out small (6,624K) on a reboot, then keeps
increasing (now 498,508K). This is causing the system to be very
slow. The server has 654,880 KB ram and a 36 gig hard drive. This is
mainly a read only system and does not have very heavy usage. The
paging file size is set at 960 MB with max size 1920 (avail 13,299).
Do we need more memory? Do I need to change some DB2 config
parameter? Can anyone make any suggestions? Thanks for your help!
a V5.2 Solaris system). We have a C program that runs on the server
and processes all the SQL from VB client Winsocks (so we don't have to
install DB2 client & ODBC driver on all our user PCs). Looking at the
Windows processes, it seems that db2syscs.exe is taking way too much
memory. It starts out small (6,624K) on a reboot, then keeps
increasing (now 498,508K). This is causing the system to be very
slow. The server has 654,880 KB ram and a 36 gig hard drive. This is
mainly a read only system and does not have very heavy usage. The
paging file size is set at 960 MB with max size 1920 (avail 13,299).
Do we need more memory? Do I need to change some DB2 config
parameter? Can anyone make any suggestions? Thanks for your help!
Fan Ruo Xin
Apr 19, 2002, 10:59:11 PM4/19/02
to
Hi,
If you don't care performance, you can decrease buffersize, sortheap, ...
Best Regards,
Fan Ruo Xin
If you don't care performance, you can decrease buffersize, sortheap, ...
Best Regards,
Fan Ruo Xin
Mark Yudkin
Apr 21, 2002, 3:35:13 AM4/21/02
to
You should try putting memory on to your server. YOu current memory size is
OK for a desktop, but it's a joke for a server box with a database.
OK for a desktop, but it's a joke for a server box with a database.
"Glenna" <gschr...@jvlnet.com> wrote in message
news:6a2a4e36.02041...@posting.google.com...
0 new messages