You want to post your question on the DB2-l listserv as well
Robert Galambos
Compuware Senior Technical Specialist
IBM Certified Solutions Expert -
DB2 UDB for OS/390 Database Administration
[EMAIL PROTECTED]
Tel: +1 905 886 7000
Toll Free: +1 800 263 7189
Fax: +1 905 886 7023
Quebec: +1 877-281-1888
Compuware Canada
Service is our best product
Les renseignements contenus dans le présent message électronique sont
confidentiels et concernent exclusivement le(s) destinataire(s) désigné(s). Il
est strictement interdit de distribuer ou de copier ce message. Si vous avez
reçu ce message par erreur, veuillez répondre par courriel à l'expéditeur et
effacer ou détruire toutes les copies du présent message.
-----Original Message-----
From: IBM Mainframe Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of
Jacky Bright
Sent: September 20, 2006 1:44 PM
To: [email protected]
Subject: Production DB2 Problem - some more details ..
I am giving you some more details with regard to my problem...
Database Storage Group Definition:
CREATE STOGROUP STGP1 VOLUMES(PDB001)
VCAT DBSTGP;
In the SMS There is storage group named DBSTGP and volumes included under this
storage group are
PDB001
PDB002
PDB003
PDB004
PDB005
When these 5 volumes got full, I hav added another 2 volumes PDBR006 and
PDBR007. However, Simple tablespace could not extend to these newly added
volumes and we were getting EXTEND Failed error for tablespace related vsam
dataset. After performing REORG tablespace dataset got extended to these newly
added volumes(PDBR006,PDBR007).
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
The contents of this e-mail are intended for the named addressee only. It
contains information that may be confidential. Unless you are the named
addressee or an authorized designee, you may not copy or use it, or disclose it
to anyone else. If you received it in error please notify us immediately and
then destroy it.
----------------------------------------------------------------------
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
