storage groups

Jim McAlpine

storage groups
I am doing a 3380 to 3390 conversion using DFDSS logical copies of DB2
databases. If a tablespace moves to a new disk name which is not part of the
original DB2 storage group does this cause a problem or are the storage
groups just used at initial allocation. The storage groups are not SMS
managed.

TIA

Jim McAlpine

[login to unmask email]


**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager at [login to unmask email]

This footnote also confirms that this email message has been swept
for the presence of computer viruses.

http://www.qspgroup.com
**********************************************************************



Helen Johnson

Re: storage groups
(in response to Jim McAlpine)
Yes, this does cause a problem. The next time you need an extent, DB2
will
try to find the old 3380 pack. You have to alter the storage group and
add the new pack(s) and you can also remove the old packs if you wish.
We did this a few years ago.

> -----Original Message-----
> From: Jim McAlpine [mailto:[login to unmask email]
> Sent: Wednesday, January 09, 2002 5:02 AM
> To: [login to unmask email]
> Subject: storage groups
>
>
> I am doing a 3380 to 3390 conversion using DFDSS logical copies of DB2
> databases. If a tablespace moves to a new disk name which is
> not part of the
> original DB2 storage group does this cause a problem or are
> the storage
> groups just used at initial allocation. The storage groups are not SMS
> managed.
>
> TIA
>
> Jim McAlpine
>
> [login to unmask email]
>
>
> **********************************************************************
> This email and any files transmitted with it are confidential and
> intended solely for the use of the individual or entity to whom they
> are addressed. If you have received this email in error please notify
> the system manager at [login to unmask email]
>
> This footnote also confirms that this email message has been swept
> for the presence of computer viruses.
>
> http://www.qspgroup.com
> **********************************************************************
>
>
> To change your subscription options or to cancel your
> subscription visit the DB2-L webpage at
> http://www.ryci.com/db2-l. The owners of the list can be
>
>



Isaac Yassin

Re: storage groups
(in response to Helen Johnson)
Hi,
Not while moving, but next extend allocation will go to old disks.
Add the new disks to your storage group.
When the move ends you should remove the old disks.




Isaac Yassin
[login to unmask email]
----- Original Message -----
From: "Jim McAlpine" <[login to unmask email]>
Newsgroups: bit.listserv.db2-l
To: <[login to unmask email]>
Sent: Wednesday, January 09, 2002 1:01 PM
Subject: storage groups


> I am doing a 3380 to 3390 conversion using DFDSS logical copies of DB2
> databases. If a tablespace moves to a new disk name which is not part of the
> original DB2 storage group does this cause a problem or are the storage
> groups just used at initial allocation. The storage groups are not SMS
> managed.
>
> TIA
>
> Jim McAlpine
>
> [login to unmask email]
>
>
> **********************************************************************
> This email and any files transmitted with it are confidential and
> intended solely for the use of the individual or entity to whom they
> are addressed. If you have received this email in error please notify
> the system manager at [login to unmask email]
>
> This footnote also confirms that this email message has been swept
> for the presence of computer viruses.
>
> http://www.qspgroup.com
> **********************************************************************
>
>
> DB2-L webpage at http://www.ryci.com/db2-l. The
owners of the list can
>



III Edward(Ed) J. Finnell

Re: storage groups
(in response to Isaac Yassin)
It can cause a problem. Need to look at sysibm.sysvols to straighten out the
allocation. If they're static and don't grow no big deal. If they try to extend guess
where they're going? Back to the initial allocation.
Edward(Ed) J. Finnell, III
Enterprise Systems/Proj. Mgr.
url:www.ua.edu



Patrick Hignett

Re: storage groups
(in response to III Edward(Ed) J. Finnell)
Any reorgs would also try to use the orrigibnal packs. Also remember a storage group can not contain a mix of 3380s and 3390s

Helen Johnson wrote:

> Yes, this does cause a problem. The next time you need an extent, DB2
> will
> try to find the old 3380 pack. You have to alter the storage group and
> add the new pack(s) and you can also remove the old packs if you wish.
> We did this a few years ago.
>
> > -----Original Message-----
> > From: Jim McAlpine [mailto:[login to unmask email]
> > Sent: Wednesday, January 09, 2002 5:02 AM
> > To: [login to unmask email]
> > Subject: storage groups
> >
> >
> > I am doing a 3380 to 3390 conversion using DFDSS logical copies of DB2
> > databases. If a tablespace moves to a new disk name which is
> > not part of the
> > original DB2 storage group does this cause a problem or are
> > the storage
> > groups just used at initial allocation. The storage groups are not SMS
> > managed.
> >
> > TIA
> >
> > Jim McAlpine
> >
> > [login to unmask email]
> >
> >
> > **********************************************************************
> > This email and any files transmitted with it are confidential and
> > intended solely for the use of the individual or entity to whom they
> > are addressed. If you have received this email in error please notify
> > the system manager at [login to unmask email]
> >
> > This footnote also confirms that this email message has been swept
> > for the presence of computer viruses.
> >
> > http://www.qspgroup.com
> > **********************************************************************
> >
> >
> > To change your subscription options or to cancel your
> > subscription visit the DB2-L webpage at
> > http://www.ryci.com/db2-l. The owners of the list can be
> >
> >
>
> =======================



Eric Pearson

Re: storage groups
(in response to Patrick Hignett)
The storage groups are also used to extend (i.e. obtain SECQTY)
and in certain cases (depending upon your options) LOAD and REORG.

Regards,
eric pearson
NS ITO Database Support


-----Original Message-----
From: Jim McAlpine [mailto:[login to unmask email]
Sent: Wednesday, January 09, 2002 6:02 AM
To: [login to unmask email]
Subject: storage groups


I am doing a 3380 to 3390 conversion using DFDSS logical copies of DB2
databases. If a tablespace moves to a new disk name which is not part of the
original DB2 storage group does this cause a problem or are the storage
groups just used at initial allocation. The storage groups are not SMS
managed.

TIA

Jim McAlpine

[login to unmask email]


**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager at [login to unmask email]

This footnote also confirms that this email message has been swept
for the presence of computer viruses.

http://www.qspgroup.com
**********************************************************************