ICF Catalog how to Split into Sub-Systems per IBM Recommended

Omar Ali

ICF Catalog how to Split into Sub-Systems per IBM Recommended
Our Shop is a PeopleSoft environment running DB2 v8.1 NFM, we currently have 1 ICF catalog that holds everything, My System Programmer is asking us DBA's some Questions on Braking up the ICF Catalog into Multi Parts per what IBM is recommending, how do we go about doing this, are there a specify order that we need to followed? Not sure ?
there are Bootstraps, VSAM-files, Logs etc involved there are Thousands of entrees, we'll like to brake out into each subsystem we currently have 3 Non-Prod subsystem, and 1 production. How do we accomplish this in each sub-systems, any advise help will be appreciated

Always Thanks in Advance
and have a Great Thanksgiving to you all

Omar
E-Mail [login to unmask email]
-----------------------------------------
The substance of this message, including any attachments, may be
confidential, legally privileged and/or exempt from disclosure
pursuant to Massachusetts law. It is intended
solely for the addressee. If you received this in error, please
contact the sender and delete the material from any computer.

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.idug.org/db2-videos.html has hundreds of video presentations!
Did you miss out on attending an IDUG conference?
Many of the presentations were recorded and are available on our website!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's DB2-L

Omar Ali

Re: ICF Catalog how to Split into Sub-Systems per IBM Recommended
(in response to Omar Ali)
Hi Group,
I have a Question but not sure if I'm saying this correctly, here goes,
Our Shop is a PeopleSoft environment running DB2 v8.1 NFM, we currently have 1 ICF catalog that holds everything, My System Programmer is asking us DBA's some Questions on Braking up the ICF Catalog into Multi Parts per what IBM is recommending, how do we go about doing this, are there a specify order that we need to followed? Not sure ?
there are Bootstraps, VSAM-files, Logs etc involved there are Thousands of entrees, we'll like to brake out into each subsystem we currently have 3 Non-Prod subsystem, and 1 production. How do we accomplish this in each sub-systems, any advise help will be appreciated

Always Thanks in Advance
and have a Great Thanksgiving to you all

Omar
E-Mail [login to unmask email]
-----------------------------------------
The substance of this message, including any attachments, may be
confidential, legally privileged and/or exempt from disclosure
pursuant to Massachusetts law. It is intended
solely for the addressee. If you received this in error, please
contact the sender and delete the material from any computer.

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.idug.org/db2-videos.html has hundreds of video presentations!
Did you miss out on attending an IDUG conference?
Many of the presentations were recorded and are available on our website!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's DB2-L

Avram Friedman

Re: ICF Catalog how to Split into Sub-Systems per IBM Recommended
(in response to Kirk Hampton)
Please post the question to IBM and the recomendation.
I suspect something got lost in the translation.

In general of each DB2 subsystem uses diffrent high level qualifers splitting
the ICF catalog is not difficult but may result in an extended outage. There
are IDCAMS / AMS utilities that will do the job. In addition there may be ISV
products.

This split would normally be done by the operating system Systems
Programmer or Storage Manager, not the DBA.

If the data set High Level Qualifiers are not diffrent the task is a major one
and in most cases should not be attempted ... find a diffrent solution.

DB2 objects are 'multi cataloged' In the ISV catalog, In the DB2 Catalog
and directory in the BSDS, in control cards and job streams etc etc etc.
There is a ICG catalog fature called Multil Level Aliases but this tends to be
ineffective for DB2 objects as table space names tend to be
hlq.DSNDBD.dbname.**

So post the original question to IBM and the recomendation, perhaps the list
can help find a better more workable solution.

Avram Friedman

On Thu, 19 Nov 2009 15:43:57 -0500, Ali, Omar
<[login to unmask email]> wrote:

>Our Shop is a PeopleSoft environment running DB2 v8.1 NFM, we currently
have 1 ICF catalog that holds everything, My System Programmer is asking
us DBA's some Questions on Braking up the ICF Catalog into Multi Parts
per what IBM is recommending, how do we go about doing this, are there a
specify order that we need to followed? Not sure ?
there are Bootstraps, VSAM-files, Logs etc involved there are Thousands of
entrees, we'll like to brake out into each subsystem we currently have 3 Non-
Prod subsystem, and 1 production. How do we accomplish this in each sub-
systems, any advise help will be appreciated

Always Thanks in Advance
and have a Great Thanksgiving to you all

Omar
E-Mail [login to unmask email]
-----------------------------------------
The substance of this message, including any attachments, may be
confidential, legally privileged and/or exempt from disclosure
pursuant to Massachusetts law. It is intended
solely for the addressee. If you received this in error, please
contact the sender and delete the material from any computer.
>
>_________________________________________________________
____________
>
>* IDUG North America * Tampa, Florida, * May 10-14 2010 *
http://IDUG.ORG/NA *
>_________________________________________________________
____________
>
>http://www.idug.org/db2-videos.html has hundreds of video presentations!
>Did you miss out on attending an IDUG conference?
>Many of the presentations were recorded and are available on our website!
>_________________________________________________________
____________
>
>If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L
is the home of IDUG's DB2-L

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.idug.org/db2-videos.html has hundreds of video presentations!
Did you miss out on attending an IDUG conference?
Many of the presentations were recorded and are available on our website!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's DB2-L

Kirk Hampton

Re: ICF Catalog how to Split into Sub-Systems per IBM Recommended
(in response to Omar Ali)
My first reaction is, why would the SysProg be asking you DBA's anything
about ICF catalogs, he should know more than you about it.

I must assume that each of your subsystems uses a different VCAT name
(dataset high-level qualifier) even thought they are in the same ICF
catalog. Unless he is wanting you to change high-level qualifiers, it
should be not a huge deal to move one or more of your high-level
qualifiers from one ICF catalog to another.

What exactly is IBM recommending, and why ?

Kirk Hampton
DB2 z/OS SysProg
HCL Technologies
Mesquite, TX



-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Ali, Omar
Sent: Thursday, November 19, 2009 2:44 PM
To: Hampton, Kirk
Subject: ICF Catalog how to Split into Sub-Systems per IBM Recommended

Our Shop is a PeopleSoft environment running DB2 v8.1 NFM, we currently
have 1 ICF catalog that holds everything, My System Programmer is asking
us DBA's some Questions on Braking up the ICF Catalog into Multi Parts
per what IBM is recommending, how do we go about doing this, are there a
specify order that we need to followed? Not sure ?
there are Bootstraps, VSAM-files, Logs etc involved there are Thousands
of entrees, we'll like to brake out into each subsystem we currently
have 3 Non-Prod subsystem, and 1 production. How do we accomplish this
in each sub-systems, any advise help will be appreciated

Always Thanks in Advance
and have a Great Thanksgiving to you all

Omar
E-Mail [login to unmask email]
-----------------------------------------
The substance of this message, including any attachments, may be
confidential, legally privileged and/or exempt from disclosure
pursuant to Massachusetts law. It is intended
solely for the addressee. If you received this in error, please
contact the sender and delete the material from any computer.

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 *
http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.idug.org/db2-videos.html has hundreds of video presentations!
Did you miss out on attending an IDUG conference?
Many of the presentations were recorded and are available on our
website!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L
is the home of IDUG's DB2-L

Confidentiality Notice: This email message, including any attachments,
contains or may contain confidential information intended only for the
addressee. If you are not an intended recipient of this message, be
advised that any reading, dissemination, forwarding, printing, copying
or other use of this message or its attachments is strictly prohibited. If
you have received this message in error, please notify the sender
immediately by reply message and delete this email message and any
attachments from your system.

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.idug.org/db2-videos.html has hundreds of video presentations!
Did you miss out on attending an IDUG conference?
Many of the presentations were recorded and are available on our website!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's DB2-L

Omar Ali

Re: ICF Catalog how to Split into Sub-Systems per IBM Recommended
(in response to Avram Friedman)
Hi Avram, Kirk,
I think my system programmer is posing the Question to the DBA's to get some sort of ideas, not sure? But on each subsystem the High level Qualifiers are different for Example in one of the subsystem there are names like DB2L.DSNDBD.dbname.**, DB2T.DSNDBD.dbname.**, and in another there are names like DB2Q.DSNDBD.dbname.**, and production likes like DB2P.DSNDBD.dbname.** I'm not sure what IBM is recommending but I can surely asked to get more Info. I'll forward this e-mail to my System Programmer with the tools that was mentions thank you for the heads up and advice

Omar
-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Avram Friedman
Sent: Thursday, November 19, 2009 4:26 PM
To: [login to unmask email]
Subject: Re: [DB2-L] ICF Catalog how to Split into Sub-Systems per IBM Recommended

Please post the question to IBM and the recomendation.
I suspect something got lost in the translation.

In general of each DB2 subsystem uses diffrent high level qualifers splitting the ICF catalog is not difficult but may result in an extended outage. There are IDCAMS / AMS utilities that will do the job. In addition there may be ISV products.

This split would normally be done by the operating system Systems
Programmer or Storage Manager, not the DBA.

If the data set High Level Qualifiers are not diffrent the task is a major one and in most cases should not be attempted ... find a diffrent solution.

DB2 objects are 'multi cataloged' In the ISV catalog, In the DB2 Catalog
and directory in the BSDS, in control cards and job streams etc etc etc.
There is a ICG catalog fature called Multil Level Aliases but this tends to be ineffective for DB2 objects as table space names tend to be
hlq.DSNDBD.dbname.**

So post the original question to IBM and the recomendation, perhaps the list
can help find a better more workable solution.

Avram Friedman

On Thu, 19 Nov 2009 15:43:57 -0500, Ali, Omar
<[login to unmask email]> wrote:

>Our Shop is a PeopleSoft environment running DB2 v8.1 NFM, we currently
have 1 ICF catalog that holds everything, My System Programmer is asking
us DBA's some Questions on Braking up the ICF Catalog into Multi Parts
per what IBM is recommending, how do we go about doing this, are there a
specify order that we need to followed? Not sure ?
there are Bootstraps, VSAM-files, Logs etc involved there are Thousands of
entrees, we'll like to brake out into each subsystem we currently have 3 Non-
Prod subsystem, and 1 production. How do we accomplish this in each sub-
systems, any advise help will be appreciated

Always Thanks in Advance
and have a Great Thanksgiving to you all

Omar
E-Mail [login to unmask email]
-----------------------------------------
The substance of this message, including any attachments, may be
confidential, legally privileged and/or exempt from disclosure
pursuant to Massachusetts law. It is intended
solely for the addressee. If you received this in error, please
contact the sender and delete the material from any computer.

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.idug.org/events/index.html is your DB2 Events calendar! RUG meetings,
Webcasts, Conferences- what is going on next?
RUG leaders- get your events on the calendar today!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's DB2-L

Omar Ali

Re: ICF Catalog how to Split into Sub-Systems per IBM Recommended
(in response to Omar Ali)
Just an FYI concerning the ICF catalog, IBM is recommending that in the near future the BOOTSTRAPS, and LOGS be separated form the ICF Catalog moving to DB2 Next, there is a REDBOOK documenting the Processes, this is what my SYSTEM Programmers were asking us DBA's if anyone attempted this before? And how to go about separating this from the catalog
I guest he is looking for suggestions before contacting IBM for advice
Any suggestion
Thanks in advance
Omar
-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Ali, Omar
Sent: Friday, November 20, 2009 8:23 AM
To: [login to unmask email]
Subject: Re: [DB2-L] ICF Catalog how to Split into Sub-Systems per IBM Recommended

Hi Avram, Kirk,
I think my system programmer is posing the Question to the DBA's to get some sort of ideas, not sure? But on each subsystem the High level Qualifiers are different for Example in one of the subsystem there are names like DB2L.DSNDBD.dbname.**, DB2T.DSNDBD.dbname.**, and in another there are names like DB2Q.DSNDBD.dbname.**, and production likes like DB2P.DSNDBD.dbname.** I'm not sure what IBM is recommending but I can surely asked to get more Info. I'll forward this e-mail to my System Programmer with the tools that was mentions thank you for the heads up and advice

Omar
-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Avram Friedman
Sent: Thursday, November 19, 2009 4:26 PM
To: [login to unmask email]
Subject: Re: [DB2-L] ICF Catalog how to Split into Sub-Systems per IBM Recommended

Please post the question to IBM and the recomendation.
I suspect something got lost in the translation.

In general of each DB2 subsystem uses diffrent high level qualifers splitting the ICF catalog is not difficult but may result in an extended outage. There are IDCAMS / AMS utilities that will do the job. In addition there may be ISV products.

This split would normally be done by the operating system Systems
Programmer or Storage Manager, not the DBA.

If the data set High Level Qualifiers are not diffrent the task is a major one and in most cases should not be attempted ... find a diffrent solution.

DB2 objects are 'multi cataloged' In the ISV catalog, In the DB2 Catalog
and directory in the BSDS, in control cards and job streams etc etc etc.
There is a ICG catalog fature called Multil Level Aliases but this tends to be ineffective for DB2 objects as table space names tend to be
hlq.DSNDBD.dbname.**

So post the original question to IBM and the recomendation, perhaps the list
can help find a better more workable solution.

Avram Friedman

On Thu, 19 Nov 2009 15:43:57 -0500, Ali, Omar
<[login to unmask email]> wrote:

>Our Shop is a PeopleSoft environment running DB2 v8.1 NFM, we currently
have 1 ICF catalog that holds everything, My System Programmer is asking
us DBA's some Questions on Braking up the ICF Catalog into Multi Parts
per what IBM is recommending, how do we go about doing this, are there a
specify order that we need to followed? Not sure ?
there are Bootstraps, VSAM-files, Logs etc involved there are Thousands of
entrees, we'll like to brake out into each subsystem we currently have 3 Non-
Prod subsystem, and 1 production. How do we accomplish this in each sub-
systems, any advise help will be appreciated

Always Thanks in Advance
and have a Great Thanksgiving to you all

Omar
E-Mail [login to unmask email]
-----------------------------------------
The substance of this message, including any attachments, may be
confidential, legally privileged and/or exempt from disclosure
pursuant to Massachusetts law. It is intended
solely for the addressee. If you received this in error, please
contact the sender and delete the material from any computer.

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.idug.org/events/index.html is your DB2 Events calendar! RUG meetings,
Webcasts, Conferences- what is going on next?
RUG leaders- get your events on the calendar today!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's DB2-L

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.idug.org/rug/index.html - with almost 150 IDUG Regional User Groups,
there is probably one near you!
Regional User Groups are your local connection to the Worldwide DB2 User Community
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's DB2-L

Robert Catterall

Re: ICF Catalog how to Split into Sub-Systems per IBM Recommended
(in response to Omar Ali)
Hello, Anil -- sorry about the delayed response.

It may be that you've been asked to put the BSDS and active log data sets in
a separate ICF catalog so as to enable your organization to utilize the
BACKUP SYSTEM and RESTORE SYSTEM utilities that were introduced with DB2 for
z/OS V8. I wrote a blog entry on BACKUP SYSTEM and RESTORE SYSTEM a few
weeks ago, and near the end of that entry I provided an outline of the
process by which you'd move the BSDS and active log data sets to a separate
ICF catalog. Here's a link to that blog entry:

http://www.catterallconsulting.com/2009/10/thoughts-on-db2-for-zos-backup-system.html

I hope that the information in that blog post will be useful to you.

Robert


On Mon, Nov 23, 2009 at 10:39 AM, Ali, Omar <[login to unmask email]>wrote:

> Just an FYI concerning the ICF catalog, IBM is recommending that in the
> near future the BOOTSTRAPS, and LOGS be separated form the ICF Catalog
> moving to DB2 Next, there is a REDBOOK documenting the Processes, this is
> what my SYSTEM Programmers were asking us DBA's if anyone attempted this
> before? And how to go about separating this from the catalog
> I guest he is looking for suggestions before contacting IBM for advice
> Any suggestion
> Thanks in advance
> Omar
> -----Original Message-----
> From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Ali, Omar
> Sent: Friday, November 20, 2009 8:23 AM
> To: [login to unmask email]
> Subject: Re: [DB2-L] ICF Catalog how to Split into Sub-Systems per IBM
> Recommended
>
> Hi Avram, Kirk,
> I think my system programmer is posing the Question to the DBA's to get
> some sort of ideas, not sure? But on each subsystem the High level
> Qualifiers are different for Example in one of the subsystem there are names
> like DB2L.DSNDBD.dbname.**, DB2T.DSNDBD.dbname.**, and in another there are
> names like DB2Q.DSNDBD.dbname.**, and production likes like
> DB2P.DSNDBD.dbname.** I'm not sure what IBM is recommending but I can surely
> asked to get more Info. I'll forward this e-mail to my System Programmer
> with the tools that was mentions thank you for the heads up and advice
>
> Omar
> -----Original Message-----
> From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Avram Friedman
> Sent: Thursday, November 19, 2009 4:26 PM
> To: [login to unmask email]
> Subject: Re: [DB2-L] ICF Catalog how to Split into Sub-Systems per IBM
> Recommended
>
> Please post the question to IBM and the recomendation.
> I suspect something got lost in the translation.
>
> In general of each DB2 subsystem uses diffrent high level qualifers
> splitting the ICF catalog is not difficult but may result in an extended
> outage. There are IDCAMS / AMS utilities that will do the job. In addition
> there may be ISV products.
>
> This split would normally be done by the operating system Systems
> Programmer or Storage Manager, not the DBA.
>
> If the data set High Level Qualifiers are not diffrent the task is a major
> one and in most cases should not be attempted ... find a diffrent solution.
>
> DB2 objects are 'multi cataloged' In the ISV catalog, In the DB2 Catalog
> and directory in the BSDS, in control cards and job streams etc etc etc.
> There is a ICG catalog fature called Multil Level Aliases but this tends to
> be ineffective for DB2 objects as table space names tend to be
> hlq.DSNDBD.dbname.**
>
> So post the original question to IBM and the recomendation, perhaps the
> list
> can help find a better more workable solution.
>
> Avram Friedman
>
> On Thu, 19 Nov 2009 15:43:57 -0500, Ali, Omar
> <[login to unmask email]> wrote:
>
> >Our Shop is a PeopleSoft environment running DB2 v8.1 NFM, we currently
> have 1 ICF catalog that holds everything, My System Programmer is asking
> us DBA's some Questions on Braking up the ICF Catalog into Multi Parts
> per what IBM is recommending, how do we go about doing this, are there a
> specify order that we need to followed? Not sure ?
> there are Bootstraps, VSAM-files, Logs etc involved there are Thousands of
> entrees, we'll like to brake out into each subsystem we currently have 3
> Non-
> Prod subsystem, and 1 production. How do we accomplish this in each sub-
> systems, any advise help will be appreciated
>
> Always Thanks in Advance
> and have a Great Thanksgiving to you all
>
> Omar
> E-Mail [login to unmask email]
> -----------------------------------------
> The substance of this message, including any attachments, may be
> confidential, legally privileged and/or exempt from disclosure
> pursuant to Massachusetts law. It is intended
> solely for the addressee. If you received this in error, please
> contact the sender and delete the material from any computer.
>
> _____________________________________________________________________
>
> * IDUG North America * Tampa, Florida, * May 10-14 2010 *
> http://IDUG.ORG/NA *
> _____________________________________________________________________
>
> http://www.idug.org/events/index.html is your DB2 Events calendar! RUG
> meetings,
> Webcasts, Conferences- what is going on next?
> RUG leaders- get your events on the calendar today!
> _____________________________________________________________________
>
> If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is
> the home of IDUG's DB2-L
>
> _____________________________________________________________________
>
> * IDUG North America * Tampa, Florida, * May 10-14 2010 *
> http://IDUG.ORG/NA *
> _____________________________________________________________________
>
> http://www.idug.org/rug/index.html - with almost 150 IDUG Regional User
> Groups,
> there is probably one near you!
> Regional User Groups are your local connection to the Worldwide DB2 User
> Community
> _____________________________________________________________________
>
> If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is
> the home of IDUG's DB2-L
>



--
Robert Catterall
Catterall Consulting
www.catterallconsulting.com

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.IDUG.org membership is now free.
Do you have people in your office who are not an IDUG member?
Show them how to access the information and help train the next generation of DB2 Users!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's DB2-L

Omar Ali

Re: ICF Catalog how to Split into Sub-Systems per IBM Recommended
(in response to Robert Catterall)
Thank You all Robert I'll read the Blog
Thanks Again
________________________________
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Robert Catterall
Sent: Monday, November 30, 2009 11:22 AM
To: [login to unmask email]
Subject: Re: [DB2-L] ICF Catalog how to Split into Sub-Systems per IBM Recommended

Hello, Anil -- sorry about the delayed response.

It may be that you've been asked to put the BSDS and active log data sets in a separate ICF catalog so as to enable your organization to utilize the BACKUP SYSTEM and RESTORE SYSTEM utilities that were introduced with DB2 for z/OS V8. I wrote a blog entry on BACKUP SYSTEM and RESTORE SYSTEM a few weeks ago, and near the end of that entry I provided an outline of the process by which you'd move the BSDS and active log data sets to a separate ICF catalog. Here's a link to that blog entry:

http://www.catterallconsulting.com/2009/10/thoughts-on-db2-for-zos-backup-system.html

I hope that the information in that blog post will be useful to you.

Robert

On Mon, Nov 23, 2009 at 10:39 AM, Ali, Omar <[login to unmask email]<mailto:[login to unmask email]>> wrote:
Just an FYI concerning the ICF catalog, IBM is recommending that in the near future the BOOTSTRAPS, and LOGS be separated form the ICF Catalog moving to DB2 Next, there is a REDBOOK documenting the Processes, this is what my SYSTEM Programmers were asking us DBA's if anyone attempted this before? And how to go about separating this from the catalog
I guest he is looking for suggestions before contacting IBM for advice
Any suggestion
Thanks in advance
Omar
-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email]<mailto:[login to unmask email]>] On Behalf Of Ali, Omar
Sent: Friday, November 20, 2009 8:23 AM
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: Re: [DB2-L] ICF Catalog how to Split into Sub-Systems per IBM Recommended

Hi Avram, Kirk,
I think my system programmer is posing the Question to the DBA's to get some sort of ideas, not sure? But on each subsystem the High level Qualifiers are different for Example in one of the subsystem there are names like DB2L.DSNDBD.dbname.**, DB2T.DSNDBD.dbname.**, and in another there are names like DB2Q.DSNDBD.dbname.**, and production likes like DB2P.DSNDBD.dbname.** I'm not sure what IBM is recommending but I can surely asked to get more Info. I'll forward this e-mail to my System Programmer with the tools that was mentions thank you for the heads up and advice

Omar
-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email]<mailto:[login to unmask email]>] On Behalf Of Avram Friedman
Sent: Thursday, November 19, 2009 4:26 PM
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: Re: [DB2-L] ICF Catalog how to Split into Sub-Systems per IBM Recommended

Please post the question to IBM and the recomendation.
I suspect something got lost in the translation.

In general of each DB2 subsystem uses diffrent high level qualifers splitting the ICF catalog is not difficult but may result in an extended outage. There are IDCAMS / AMS utilities that will do the job. In addition there may be ISV products.

This split would normally be done by the operating system Systems
Programmer or Storage Manager, not the DBA.

If the data set High Level Qualifiers are not diffrent the task is a major one and in most cases should not be attempted ... find a diffrent solution.

DB2 objects are 'multi cataloged' In the ISV catalog, In the DB2 Catalog
and directory in the BSDS, in control cards and job streams etc etc etc.
There is a ICG catalog fature called Multil Level Aliases but this tends to be ineffective for DB2 objects as table space names tend to be
hlq.DSNDBD.dbname.**

So post the original question to IBM and the recomendation, perhaps the list
can help find a better more workable solution.

Avram Friedman

On Thu, 19 Nov 2009 15:43:57 -0500, Ali, Omar
<[login to unmask email]<mailto:[login to unmask email]>> wrote:

>Our Shop is a PeopleSoft environment running DB2 v8.1 NFM, we currently
have 1 ICF catalog that holds everything, My System Programmer is asking
us DBA's some Questions on Braking up the ICF Catalog into Multi Parts
per what IBM is recommending, how do we go about doing this, are there a
specify order that we need to followed? Not sure ?
there are Bootstraps, VSAM-files, Logs etc involved there are Thousands of
entrees, we'll like to brake out into each subsystem we currently have 3 Non-
Prod subsystem, and 1 production. How do we accomplish this in each sub-
systems, any advise help will be appreciated

Always Thanks in Advance
and have a Great Thanksgiving to you all

Omar
E-Mail [login to unmask email]<mailto:[login to unmask email]>
-----------------------------------------
The substance of this message, including any attachments, may be
confidential, legally privileged and/or exempt from disclosure
pursuant to Massachusetts law. It is intended
solely for the addressee. If you received this in error, please
contact the sender and delete the material from any computer.

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.idug.org/events/index.html is your DB2 Events calendar! RUG meetings,
Webcasts, Conferences- what is going on next?
RUG leaders- get your events on the calendar today!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's DB2-L

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
_____________________________________________________________________
http://www.idug.org/rug/index.html - with almost 150 IDUG Regional User Groups,
there is probably one near you!
Regional User Groups are your local connection to the Worldwide DB2 User Community
_____________________________________________________________________
If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's DB2-L



--
Robert Catterall
Catterall Consulting
www.catterallconsulting.com < http://www.catterallconsulting.com >
________________________________

[ http://www.idug.org/images/M_images/idug%20na3.jpg ] < http://www.idug.org/db2-north-america-conference/index.html >

The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are not already an IDUG member, please register here. < http://www.idug.org/register >

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.idug.org/db2-videos.html has hundreds of video presentations!
Did you miss out on attending an IDUG conference?
Many of the presentations were recorded and are available on our website!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's DB2-L