Trying to increase Db2 stack size to solve instance crash problems
I am performing a bunch of concurrent queries, 12 Java threads executing
400 consecutive updates to be precise - all on the same 2 Db2 tables. The
Db2 version is 8.1 with fixpak 2 running on Windows 2000 professional. The
purpose of this program is to generate DB2 database deadlock(s) in order
to test my database deadlock handling Java code. However the test eventually
fails with a closed/null connection/communication type error as a result
of the DB2 instance crashing unexpectedly. One of the DB2 support guys recommended
to a colleague of mine to increase the default stack size for db2syscs.exe
using the db2hdr utility as follows:
f:\ibm\db2\misc>db2hdr f:\ibm\db2\bin\db2syscs.exe /s:512,32
which solved the problem for him on his own Db2 server( also version 8.1
with fixpak 2 running on Windows 2000 professional) but when I went to execute
the same command on mine(same spec) I get this output:
could not restore f:\ibm\db2\bin\db2syscs.exe.backup do it manually
so I then execute 'db2syscs.exe.backup' manually and then stop and restart
the DB2 instance however the stack size change doesn't seem to have taken
effect as my original instance crash problem is still occurring.
Is there something I'm doing wrong/overlooking perhaps, does anyone know?
Thanks in advance,
Stop ur Db2 service and then issue the update command.
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL