Hello: I have been testing with DB2 (version 7) and discovered that for a SMS-managed tablespace that additional volumes are added dynamically.
These tablespaces have no DATACLAS associated with them, and the SMS STORAGE GROUP is a 'normal' storage group (no EXTEND group or OVERFLOW group associated with it.) What I see is that when one of the volumes is filled up, DB2 automatically will find an additional volume (from the SMS storage group) to extend on to. Has DB2 always done this, or is this a new feature added by some version of DB2? I am not using any third-party product that dynamically adds volumes. Can someone confirm that this is 'normal' behaviour for SMS-managed DB2 table spaces? Even better, is this documented somewhere? Thank you for any insight you can provide. Paul ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html

