Buck Turgidson wrote:
> In my haste, I added a datafile to a tablespace, but I got it in the
> wrong directory. Can I move a datafile of a tablespace?
>

Short of a redirected restore, I don't know another solution.

For my SMS tablespaces, I always point DB2 at symbolic links that
then point at the actual container. I'm on Red Hat Linux - I'm
not sure if this can be done in Windows. This way, I can change
the container location by adjusting the symbolic link, and DB2
does not become irritated.

aj