You can alter the tablespace with an alter add command. Its in the SQL
reference.

Dan Callahan IT Specialist
603-472-4121 t/l 525-4121
[Email address protected]
[Email address protected]




"jim_pascual"
<db2udbdba-ezmlms
hield-x6517519.x1 To
[Email Address Removed] "LazyDBA Discussion"
.com> <[Email address protected]
cc
07/22/2004 11:00
AM Subject
Auto extending allocated size of
tablespaces.














Hi,

Is there a way or scripts in db2udb8 on WIN2000 to auto extend the
allocated size of tablespaces when it reached the maxsize?




---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: db2udbdba-[Email address protected]



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