only 16 extents .... It was sure no extent related problems ... I don't undestand .. whenever I am adding new volume based on requirement ... these tablespaces are not being extended to newly added volumes and everytime I hav to do REORG thereafter these tablespaces are getting extended to newly added volumes ...
On 9/20/06, Robert Lawrence <[EMAIL PROTECTED]> wrote:
How many extents was it in before you added the volumes? It could have reached its limit with many small extents that after reorganization consolidated to fewer extents. Bob Lawrence DBA Boscovs Dept Stores LLC -----Original Message----- From: IBM Mainframe Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of Jacky Bright Sent: Tuesday, September 19, 2006 5:27 PM To: IBM-MAIN@BAMA.UA.EDU Subject: Production DB2 Problem Hi ... I am facing problem in production DB2. 5 Volumes were configured for Database in storage group while creation of tablespace A. Later in 1 month these 5 volumes were full and added another 2 volumes, however Tablespace A could not extend to these newly created volumes. After performing REORG for Tablespace A , Tablespace VSAM dataset got extended to these newly created volumes. Is it necessary to do REORG of Tablespace everytime you add volumes in storage group. *Note : Tablespace were created using Storage group and not using volumes parameter.* ** What could be the reason for the same ? Please reply urgently Jacky ---------------------------------------------------------------------- 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 ---------------------------------------------------------------------- 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
---------------------------------------------------------------------- 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