hi gurus - thank god I'm getting this error on a play database but it'll
be great if I can learn the steps to fix besides restoring from backup.

What I'm trying to do is to compare the I/O performance between a
container located in NETAPP Storage versus LOCAL hard disk.

So I started with creating a new tablespace via a 3rd party GUI tool. For
some reason, the generated script was hanging and so is "LIST TABLESPACES"
The file SQLTAG.NAM with 0 byte was created and I had to kill the instance
to terminate the application holding the lock.

Now that the instance was restarted, I could no longer connect to the
database due to the I/O error. Is there a way I can fix up this play db?

CREATE TABLESPACE LOCAL4K
IN DATABASE PARTITION GROUP IBMDEFAULTGROUP
PAGESIZE 4K
MANAGED BY SYSTEM
USING
('/usr/tmp '
)
EXTENTSIZE 32
PREFETCHSIZE 32
BUFFERPOOL DATABP
OVERHEAD 24.10
TRANSFERRATE 0.90
DROPPED TABLE RECOVERY OFF;

Cheers
Ray

DB2 & UDB email list listserv db2-l LazyDBA home page