Jacky,
I believe for DB2 stogroups to use SMS the DB2 stogroup should be defined
as VOLUMES('*') for it to work the way you wish with the proper ACS
routines. We are not SMS managed so I am not sure how to accomplish this. I
would try an ALTER STOGROUP STGP1 REMOVE VOLUMES (PDB001) followed by an
ALTER STOGROUP STGP1 ADD VOLUMES('*'). Look it up in DB2 SQL REFERENCE.
This is all speculation on my part. If you had added those volumes to the
DB2 stogroup then it may have worked on the dataset extend since then DB2
would have done an ADDVOL (volser) to the dataset. I guess that DB2 looks at
the DB2 stogroup that the tablespace is defined on and sees which volumes
are in the DB2 stogroup in this case only PDB001 that can accept new extents
and thus fails since it does not have any other volsers that it can do an
IDCAMS ADDVOL statement with. If it sees an '*' for volumes in the DB2
STOGROUP then it passes it off to SMS. The reason that REORG works is that
the SMS ACS routines are probably invoked prior to looking at the DB2
STOGROUP and thus knows which volumes it can be created on without
determining which volumes are in the DB2 STOGROUP the tablespace resides in.
Bob Lawrence
DBA
Boscovs Dept Stores LLC
-----Original Message-----
From: IBM Mainframe Discussion List [mailto:[EMAIL PROTECTED] On Behalf
Of Jacky Bright
Sent: Wednesday, 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).
----------------------------------------------------------------------
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
