SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-26-2008, 03:57 PM
| ||||
| ||||
 reorg problem (db2 v6.1 @ WSeB) --- PLEASE HELP !!! Hi, doing a reorg on our 16 tables ran ok for the 14 little ones, but on the 2 big ones the server rebooted after some minutes, a short time after having occupied about 900 MB of tempory space. The big tables have about 1,000,000 / 10,000,000 records (table size: 100 MB / 1000 MB), each in an extra DMS tablespace; the little ones are in the default tablespace USERSPACE1. The command was: db2 reorg table xxx.yyy use tempspace1 The program versions are: - WarpServer for e-business Convenience Pack 2 with Fixpack 3 - DB2 6.1.0 with Fixpaxk FP11_WR21301 (both in german) ------- There is no more official support for this version... There is no more actual version for OS/2... ------- any ideas? thanx Helmut      |
|
02-26-2008, 04:02 PM
| ||||
| ||||
| Re: reorg problem (db2 v6.1 @ WSeB) --- PLEASE HELP !!! "Helmut Rademacker" <helmut.rademacker@t-online.de> wrote in message news:aaa95e6d.0311041513.3a64eb6f@posting.google.c om... > Hi, > > doing a reorg on our 16 tables ran ok for the 14 little ones, but on > the 2 big ones the server rebooted after some minutes, a short time > after having occupied about 900 MB of tempory space. > > The big tables have about 1,000,000 / 10,000,000 records (table size: > 100 MB / 1000 MB), each in an extra DMS tablespace; the little ones > are in the default tablespace USERSPACE1. > > The command was: db2 reorg table xxx.yyy use tempspace1 > > The program versions are: > - WarpServer for e-business Convenience Pack 2 with Fixpack 3 > - DB2 6.1.0 with Fixpaxk FP11_WR21301 > (both in german) > > ------- > There is no more official support for this version... > There is no more actual version for OS/2... > ------- > > any ideas? > > thanx > Helmut > Not sure how your temporary tablespaces are defined (SMS or DMS) but they may be running out of space. If DMS, make sure the temporary tablespace is about twice the size of the largest table. If SMS, make sure you have lots of disk space available. Also check your sortheaps and make them larger if needed. Keep in mind that DB2 version 6 is unsupported by IBM. |
Linear Mode
