469,284 Members | 2,492 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,284 developers. It's quick & easy.

DB2 Instance Crashing

We are in the process of migrating from Version 7, running on an OS/2
server, to Version 8.2, running on a Windows 2003 server. I have
created two databases on the new server, and have moved the data into
the databases. One of the databases has a single user entering
transactions and the DB2 instance has crashed multiple times. The
Windows Event Viewer has the following warnings prior to DB2 crashing.
The first message occurs 4 times, the one showing and for the
table spackes. Then the last warning occurs.

2006-04-25- Instance:DB2 Node:000
PID:2000(db2syscs.exe) TID:976 Appid:0A0365AF.B308.060425121145
buffer pool services sqlbStartPools Probe:2 Database:XYZ

ADM6073W The table space "SYSCATSPACE" (ID "0") is configured to use
pool ID "1", but this buffer pool is not active at this time. In the
the table space will use buffer pool ID "4096". The inactive buffer
should become available at next database startup provided that the
memory is available.
2006-04-25- Instance:DB2 Node:000
PID:2000(db2syscs.exe) TID:976 Appid:0A0365AF.B308.060425121145
sort/list services sqlsOptimizeNumMergeRuns Probe:10 Database:XYZ

ADM9000W Prefetching was disabled during sort merge; performance may
suboptimal. If this message persists, consider increasing the buffer
pool size
for temporary table space "TEMPSPACE1" (ID "1") or increase the value
of the
SORTHEAP DB configuration parameter to reduce the extent of sort

On the OS/2 server, the SORTHEAP parameter was set to 256, and there
was never a problem. On the Windows 2003 server, I have moved it to
1352 pages, but still get the errors. At this point there are only a
few users that connect to the new server, but I need to resolve this
before I continue the upgrade\migration. Does anyone have any

Thanks in advance,

Apr 25 '06 #1
2 2971
>From you message, not enough memory for DB2

Apr 25 '06 #2
The server has 3 GB of RAM. I think it is a configuration setting. I
have been adjusting them, but the problem is still occurring. Last
night I used the Configuration Advisor on the database that has been
having the errors. Hopefully this will eliminate the errors. I have
also thought about creating a separate instance for each database. Are
the any pros or cons to this?

Apr 26 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by Yannick Majoros | last post: by
4 posts views Thread by Krice | last post: by
14 posts views Thread by Java and Swing | last post: by
6 posts views Thread by Peter Morris | last post: by
2 posts views Thread by =?Utf-8?B?QW5uZXh4eHh4eHg=?= | last post: by
1 post views Thread by CARIGAR | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.