[Z/OS] V8 - Image Copy

Sangameswara Panchomarthi

[Z/OS] V8 - Image Copy
Dear List Members,

I have a table space with 2000+ partitions. I would like to setup the jobs to take imagecopies at the partition level. (Example : 500 Partitions per job).

We use IBM utilities only, we do not have vendor products. Is there a way to specify the range of partitions for each job without explicitly specifying all 500 partitions. I have looked at the syntax of COPY and LISTDEF and i could not able to find any simple solution where we can specify the range of partitions.

Do we have any other way to achieve this without explicitly specifying all 500 partitions in the LISTDEF statement. Could you please let me know.

Thank you,
Rao



-----------------------------------------
This transmission may contain information that is privileged,
confidential, legally privileged, and/or exempt from disclosure
under applicable law. If you are not the intended recipient, you
are hereby notified that any disclosure, copying, distribution, or
use of the information contained herein (including any reliance
thereon) is STRICTLY PROHIBITED. Although this transmission and
any attachments are believed to be free of any virus or other
defect that might affect any computer system into which it is
received and opened, it is the responsibility of the recipient to
ensure that it is virus free and no responsibility is accepted by
JPMorgan Chase & Co., its subsidiaries and affiliates, as
applicable, for any loss or damage arising in any way from its use.
If you received this transmission in error, please immediately
contact the sender and destroy the material in its entirety,
whether in electronic or hard copy format. Thank you.

______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
______________________________________________________________________



The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms

Larry Jardine

Re: [Z/OS] V8 - Image Copy
(in response to Sangameswara Panchomarthi)
You can do this in a single job step by using the PARALLEL and UNIT
parameters. Important parts below are (1) PARTLEVEL in the LISTDEF
without specifying a number means to process all partitions at the
partition level; and (2) PARALLEL TAPEUNITS(8) in this case means 4
parallel threads (2 per thread, 1 each for the local and the remote
copies). This accomplishes the same processing as if you had 4 separate
jobs and spread the partition ranges across them. But much easier...

Something like this...

//SYSLISTD DD *
LISTDEF QLIST INCLUDE TABLESPACE db.tsname PARTLEVEL
/*
//SYSIN DD *
TEMPLATE LOC1 DSN 'F2B3PB.&DB..&TS..&PA..LPF(+1)'
STACK(YES)
EXPDL '1999000'
GDGLIMIT(10)
UNIT(T3480)
MODELDCB(F108.GDGMODEL)
TEMPLATE REM1 DSN 'F2B3PB.DBR.&DB..&TS..&PA..RPF(+1)'
STACK(YES)
EXPDL '1999000'
GDGLIMIT(10)
UNIT(T3480)
MODELDCB(F108.GDGMODEL)
COPY LIST QLIST COPYDDN(LOC1) RECOVERYDDN(REM1)
SHRLEVEL CHANGE PARALLEL TAPEUNITS(8)
/*

Larry Jardine
Production DBA
-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of [login to unmask email]
Sent: Tuesday, December 02, 2008 12:11 PM
To: [login to unmask email]
Subject: Re: [DB2-L] [Z/OS] V8 - Image Copy

Dear List Members,

I have a table space with 2000+ partitions. I would like to setup the
jobs to take imagecopies at the partition level. (Example : 500
Partitions per job).

We use IBM utilities only, we do not have vendor products. Is there a
way to specify the range of partitions for each job without explicitly
specifying all 500 partitions. I have looked at the syntax of COPY and
LISTDEF and i could not able to find any simple solution where we can
specify the range of partitions.

Do we have any other way to achieve this without explicitly specifying
all 500 partitions in the LISTDEF statement. Could you please let me
know.

Thank you,
Rao



-----------------------------------------
This transmission may contain information that is privileged,
confidential, legally privileged, and/or exempt from disclosure
under applicable law. If you are not the intended recipient, you
are hereby notified that any disclosure, copying, distribution, or
use of the information contained herein (including any reliance
thereon) is STRICTLY PROHIBITED. Although this transmission and
any attachments are believed to be free of any virus or other
defect that might affect any computer system into which it is
received and opened, it is the responsibility of the recipient to
ensure that it is virus free and no responsibility is accepted by
JPMorgan Chase & Co., its subsidiaries and affiliates, as
applicable, for any loss or damage arising in any way from its use.
If you received this transmission in error, please immediately
contact the sender and destroy the material in its entirety,
whether in electronic or hard copy format. Thank you.

______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
______________________________________________________________________



The IDUG DB2-L Listserv is only part of your membership in IDUG. The
DB2-L list archives, FAQ, and delivery preferences are at
http://www.idug.org/lsidug under the Listserv tab. While at the site,
you can also access the IDUG Online Learning Center, Tech Library and
Code Place, see the latest IDUG conference information and much more.
If you have not yet signed up for Basic Membership in IDUG, available at
no cost, click on Member Services at http://www.idug.org/lsms


This e-mail may contain confidential or privileged information. If
you think you have received this e-mail in error, please advise the
sender by reply e-mail and then delete this e-mail immediately.
Thank you. Aetna

______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
______________________________________________________________________



The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms

Philip Sevetson

Re: [Z/OS] V8 - Image Copy
(in response to Larry Jardine)
Larry and Rao,



Let the user beware. There used to be a memory problem with specifying
too many objects on a LISTDEF, and PARTLEVEL on a 2000-part tablespace
would definitely have tripped the threshold. I don't know if this
problem has persisted into DB2V8/V9



________________________________

From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Jardine, Lawrence J
Sent: Tuesday, December 02, 2008 1:30 PM
To: [login to unmask email]
Subject: Re: [DB2-L] [Z/OS] V8 - Image Copy



You can do this in a single job step by using the PARALLEL and UNIT
parameters. Important parts below are (1) PARTLEVEL in the LISTDEF
without specifying a number means to process all partitions at the
partition level; and (2) PARALLEL TAPEUNITS(8) in this case means 4
parallel threads (2 per thread, 1 each for the local and the remote
copies). This accomplishes the same processing as if you had 4 separate
jobs and spread the partition ranges across them. But much easier...

Something like this...

//SYSLISTD DD *

LISTDEF QLIST INCLUDE TABLESPACE db.tsname PARTLEVEL

/*

//SYSIN DD *

TEMPLATE LOC1 DSN 'F2B3PB.&DB..&TS..&PA..LPF(+1)'

STACK(YES)

EXPDL '1999000'

GDGLIMIT(10)

UNIT(T3480)

MODELDCB(F108.GDGMODEL)

TEMPLATE REM1 DSN 'F2B3PB.DBR.&DB..&TS..&PA..RPF(+1)'

STACK(YES)

EXPDL '1999000'

GDGLIMIT(10)

UNIT(T3480)

MODELDCB(F108.GDGMODEL)

COPY LIST QLIST COPYDDN(LOC1) RECOVERYDDN(REM1)

SHRLEVEL CHANGE PARALLEL TAPEUNITS(8)

/*

Larry Jardine

Production DBA

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of [login to unmask email]
Sent: Tuesday, December 02, 2008 12:11 PM
To: [login to unmask email]
Subject: Re: [DB2-L] [Z/OS] V8 - Image Copy

Dear List Members,

I have a table space with 2000+ partitions. I would like to setup the
jobs to take imagecopies at the partition level. (Example : 500
Partitions per job).

We use IBM utilities only, we do not have vendor products. Is there a
way to specify the range of partitions for each job without explicitly
specifying all 500 partitions. I have looked at the syntax of COPY and
LISTDEF and i could not able to find any simple solution where we can
specify the range of partitions.

Do we have any other way to achieve this without explicitly specifying
all 500 partitions in the LISTDEF statement. Could you please let me
know.

Thank you,

Rao



-----------------------------------------

This transmission may contain information that is privileged,

confidential, legally privileged, and/or exempt from disclosure

under applicable law. If you are not the intended recipient, you

are hereby notified that any disclosure, copying, distribution, or

use of the information contained herein (including any reliance

thereon) is STRICTLY PROHIBITED. Although this transmission and

any attachments are believed to be free of any virus or other

defect that might affect any computer system into which it is

received and opened, it is the responsibility of the recipient to

ensure that it is virus free and no responsibility is accepted by

JPMorgan Chase & Co., its subsidiaries and affiliates, as

applicable, for any loss or damage arising in any way from its use.

If you received this transmission in error, please immediately

contact the sender and destroy the material in its entirety,

whether in electronic or hard copy format. Thank you.

______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *

______________________________________________________________________



The IDUG DB2-L Listserv is only part of your membership in IDUG. The
DB2-L list archives, FAQ, and delivery preferences are at
http://www.idug.org/lsidug under the Listserv tab. While at the site,
you can also access the IDUG Online Learning Center, Tech Library and
Code Place, see the latest IDUG conference information and much more.
If you have not yet signed up for Basic Membership in IDUG, available at
no cost, click on Member Services at http://www.idug.org/lsms

This e-mail may contain confidential or privileged information. If you
think you have received this e-mail in error, please advise the sender
by reply e-mail and then delete this e-mail immediately. Thank you.
Aetna

________________________________


IDUG 2009 - North America * May 11-15, 2009 * Denver, CO, USA
< http://idug.org/lsNA >

The IDUG DB2-L Listserv is only part of your membership in IDUG. The
DB2-L list archives, FAQ, and delivery preferences are at IDUG.ORG
< http://www.idug.org/lsidug > under the Listserv tab. While at the site,
you can also access the IDUG Online Learning Center, Tech Library and
Code Place, see the latest IDUG conference information
< http://www.idug.org/lsconf > , and much more. If you have not yet signed
up for Basic Membership in IDUG, available at no cost, click on Member
Services < http://www.idug.org/lsms >



=========
Confidentiality Notice: This e-mail communication, and any attachments, contains confidential and privileged information for the exclusive use of the recipient(s) named above. If you are not an intended recipient, or the employee or agent responsible to deliver it to an intended recipient, you are hereby notified that you have received this communication in error and that any review, disclosure, dissemination, distribution or copying of it or its contents is prohibited. If you have received this communication in error, please notify me immediately by replying to this message and delete this communication from your computer. Thank you.

Any opinions, expressed or implied, presented are solely those of the author and do not necessarily represent the opinions of the agency or the City.
=========



______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
______________________________________________________________________



The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms

Sangameswara Panchomarthi

Re: [Z/OS] V8 - Image Copy
(in response to Philip Sevetson)
Larry and Phil, Thank you for the Responses.

In my initial post, i was not clear on my intent about 4 JOBs. We have 4 way data sharing on 4 different LPARs. I would like to split the work on 4 LPARs. Example (First LPAR would process the image copy for the partitions 1 to 500, Second LPAR would process the imagecopy for the Partitions 501 to 1000.... Etc)

I would like to reduce the duration of the job execution by spreading the work on 4 different LPARs by running jobs parallelly.

Thanks,
Rao



-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email]On Behalf Of Sevetson, Phil
Sent: Tuesday, December 02, 2008 2:16 PM
To: [login to unmask email]
Subject: Re: [DB2-L] [Z/OS] V8 - Image Copy



Larry and Rao,



Let the user beware. There used to be a memory problem with specifying too many objects on a LISTDEF, and PARTLEVEL on a 2000-part tablespace would definitely have tripped the threshold. I don't know if this problem has persisted into DB2V8/V9




_____


From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf Of Jardine, Lawrence J
Sent: Tuesday, December 02, 2008 1:30 PM
To: [login to unmask email]
Subject: Re: [DB2-L] [Z/OS] V8 - Image Copy



You can do this in a single job step by using the PARALLEL and UNIT parameters. Important parts below are (1) PARTLEVEL in the LISTDEF without specifying a number means to process all partitions at the partition level; and (2) PARALLEL TAPEUNITS(8) in this case means 4 parallel threads (2 per thread, 1 each for the local and the remote copies). This accomplishes the same processing as if you had 4 separate jobs and spread the partition ranges across them. But much easier...

Something like this...

//SYSLISTD DD *

LISTDEF QLIST INCLUDE TABLESPACE db.tsname PARTLEVEL

/*

//SYSIN DD *

TEMPLATE LOC1 DSN 'F2B3PB.&DB..&TS..&PA..LPF(+1)'

STACK(YES)

EXPDL '1999000'

GDGLIMIT(10)

UNIT(T3480)

MODELDCB(F108.GDGMODEL)

TEMPLATE REM1 DSN 'F2B3PB.DBR.&DB..&TS..&PA..RPF(+1)'

STACK(YES)

EXPDL '1999000'

GDGLIMIT(10)

UNIT(T3480)

MODELDCB(F108.GDGMODEL)

COPY LIST QLIST COPYDDN(LOC1) RECOVERYDDN(REM1)

SHRLEVEL CHANGE PARALLEL TAPEUNITS(8)

/*

Larry Jardine

Production DBA

-----Original Message-----
From: DB2 Data Base Discussion List [ mailto:[login to unmask email] On Behalf Of [login to unmask email]
Sent: Tuesday, December 02, 2008 12:11 PM
To: [login to unmask email]
Subject: Re: [DB2-L] [Z/OS] V8 - Image Copy

Dear List Members,

I have a table space with 2000+ partitions. I would like to setup the jobs to take imagecopies at the partition level. (Example : 500 Partitions per job).

We use IBM utilities only, we do not have vendor products. Is there a way to specify the range of partitions for each job without explicitly specifying all 500 partitions. I have looked at the syntax of COPY and LISTDEF and i could not able to find any simple solution where we can specify the range of partitions.

Do we have any other way to achieve this without explicitly specifying all 500 partitions in the LISTDEF statement. Could you please let me know.

Thank you,

Rao



-----------------------------------------

This transmission may contain information that is privileged,

confidential, legally privileged, and/or exempt from disclosure

under applicable law. If you are not the intended recipient, you

are hereby notified that any disclosure, copying, distribution, or

use of the information contained herein (including any reliance

thereon) is STRICTLY PROHIBITED. Although this transmission and

any attachments are believed to be free of any virus or other

defect that might affect any computer system into which it is

received and opened, it is the responsibility of the recipient to

ensure that it is virus free and no responsibility is accepted by

JPMorgan Chase & Co., its subsidiaries and affiliates, as

applicable, for any loss or damage arising in any way from its use.

If you received this transmission in error, please immediately

contact the sender and destroy the material in its entirety,

whether in electronic or hard copy format. Thank you.

______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *

______________________________________________________________________



The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms



_____

=========
Confidentiality Notice: This e-mail communication, and any attachments, contains confidential and privileged information for the exclusive use of the recipient(s) named above. If you are not an intended recipient, or the employee or agent responsible to deliver it to an intended recipient, you are hereby notified that you have received this communication in error and that any review, disclosure, dissemination, distribution or copying of it or its contents is prohibited. If you have received this communication in error, please notify me immediately by replying to this message and delete this communication from your computer. Thank you.

Any opinions, expressed or implied, presented are solely those of the author and do not necessarily represent the opinions of the agency or the City.
=========





This e-mail may contain confidential or privileged information. If you think you have received this e-mail in error, please advise the sender by reply e-mail and then delete this e-mail immediately. Thank you. Aetna

_____


< http://idug.org/lsNA > IDUG 2009 - North America * May 11-15, 2009 * Denver, CO, USA

The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at IDUG.ORG <http://www.idug.org/lsidug> under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information <http://www.idug.org/lsconf> , and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member < http://www.idug.org/lsms > Services


_____

< http://idug.org/lsNA > IDUG 2009 - North America * May 11-15, 2009 * Denver, CO, USA

The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at IDUG.ORG <http://www.idug.org/lsidug> under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information <http://www.idug.org/lsconf> , and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member < http://www.idug.org/lsms > Services




-----------------------------------------
This transmission may contain information that is privileged,
confidential, legally privileged, and/or exempt from disclosure
under applicable law. If you are not the intended recipient, you
are hereby notified that any disclosure, copying, distribution, or
use of the information contained herein (including any reliance
thereon) is STRICTLY PROHIBITED. Although this transmission and
any attachments are believed to be free of any virus or other
defect that might affect any computer system into which it is
received and opened, it is the responsibility of the recipient to
ensure that it is virus free and no responsibility is accepted by
JPMorgan Chase & Co., its subsidiaries and affiliates, as
applicable, for any loss or damage arising in any way from its use.
If you received this transmission in error, please immediately
contact the sender and destroy the material in its entirety,
whether in electronic or hard copy format. Thank you.

______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
______________________________________________________________________



The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms

Philip Sevetson

Re: [Z/OS] V8 - Image Copy
(in response to Sangameswara Panchomarthi)
That's worth trying, but you should plan to do a comparison of a
four-way run with a single run using four drives for output - the
four-jobs-on-four-LPARs run might encounter problems in managing the
different partitions in UTIL status at the same time, or might encounter
Inter-DB2-Write-Interest (Global Buffer Pool) residence and/or locking
issues. Such issues might not lead to an error message, but could cause
significant delays with lock waits and Global Buffer Pool
synchronization waits. (No, I'm not _sure_ this is going to happen, I
haven't tried this with a multi-LPAR Data Sharing Group. But I think
it's possible.)

--Phil



________________________________

From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of [login to unmask email]
Sent: Tuesday, December 02, 2008 2:48 PM
To: [login to unmask email]
Subject: Re: [DB2-L] [Z/OS] V8 - Image Copy



Larry and Phil, Thank you for the Responses.



In my initial post, i was not clear on my intent about 4 JOBs. We have 4
way data sharing on 4 different LPARs. I would like to split the work on
4 LPARs. Example (First LPAR would process the image copy for the
partitions 1 to 500, Second LPAR would process the imagecopy for the
Partitions 501 to 1000.... Etc)



I would like to reduce the duration of the job execution by spreading
the work on 4 different LPARs by running jobs parallelly.



Thanks,

Rao





-----Original Message-----
From: DB2 Data Base Discussion List
[mailto:[login to unmask email]On Behalf Of Sevetson, Phil
Sent: Tuesday, December 02, 2008 2:16 PM
To: [login to unmask email]
Subject: Re: [DB2-L] [Z/OS] V8 - Image Copy

Larry and Rao,



Let the user beware. There used to be a memory problem with
specifying too many objects on a LISTDEF, and PARTLEVEL on a 2000-part
tablespace would definitely have tripped the threshold. I don't know if
this problem has persisted into DB2V8/V9




________________________________


From: DB2 Data Base Discussion List [mailto:[login to unmask email]
On Behalf Of Jardine, Lawrence J
Sent: Tuesday, December 02, 2008 1:30 PM
To: [login to unmask email]
Subject: Re: [DB2-L] [Z/OS] V8 - Image Copy



You can do this in a single job step by using the PARALLEL and
UNIT parameters. Important parts below are (1) PARTLEVEL in the LISTDEF
without specifying a number means to process all partitions at the
partition level; and (2) PARALLEL TAPEUNITS(8) in this case means 4
parallel threads (2 per thread, 1 each for the local and the remote
copies). This accomplishes the same processing as if you had 4 separate
jobs and spread the partition ranges across them. But much easier...

Something like this...

//SYSLISTD DD *

LISTDEF QLIST INCLUDE TABLESPACE db.tsname PARTLEVEL


/*

//SYSIN DD *

TEMPLATE LOC1 DSN 'F2B3PB.&DB..&TS..&PA..LPF(+1)'


STACK(YES)

EXPDL '1999000'

GDGLIMIT(10)

UNIT(T3480)

MODELDCB(F108.GDGMODEL)

TEMPLATE REM1 DSN 'F2B3PB.DBR.&DB..&TS..&PA..RPF(+1)'


STACK(YES)

EXPDL '1999000'

GDGLIMIT(10)

UNIT(T3480)

MODELDCB(F108.GDGMODEL)

COPY LIST QLIST COPYDDN(LOC1) RECOVERYDDN(REM1)

SHRLEVEL CHANGE PARALLEL TAPEUNITS(8)

/*

Larry Jardine

Production DBA

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email]
On Behalf Of [login to unmask email]
Sent: Tuesday, December 02, 2008 12:11 PM
To: [login to unmask email]
Subject: Re: [DB2-L] [Z/OS] V8 - Image Copy

Dear List Members,

I have a table space with 2000+ partitions. I would like to
setup the jobs to take imagecopies at the partition level. (Example :
500 Partitions per job).

We use IBM utilities only, we do not have vendor products. Is
there a way to specify the range of partitions for each job without
explicitly specifying all 500 partitions. I have looked at the syntax of
COPY and LISTDEF and i could not able to find any simple solution where
we can specify the range of partitions.

Do we have any other way to achieve this without explicitly
specifying all 500 partitions in the LISTDEF statement. Could you please
let me know.

Thank you,

Rao



-----------------------------------------

This transmission may contain information that is privileged,

confidential, legally privileged, and/or exempt from disclosure

under applicable law. If you are not the intended recipient,
you

are hereby notified that any disclosure, copying, distribution,
or

use of the information contained herein (including any reliance

thereon) is STRICTLY PROHIBITED. Although this transmission and

any attachments are believed to be free of any virus or other

defect that might affect any computer system into which it is

received and opened, it is the responsibility of the recipient
to

ensure that it is virus free and no responsibility is accepted
by

JPMorgan Chase & Co., its subsidiaries and affiliates, as

applicable, for any loss or damage arising in any way from its
use.

If you received this transmission in error, please immediately

contact the sender and destroy the material in its entirety,

whether in electronic or hard copy format. Thank you.


______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 *
http://IDUG.ORG/lsNA *


______________________________________________________________________



The IDUG DB2-L Listserv is only part of your membership in IDUG.
The DB2-L list archives, FAQ, and delivery preferences are at
http://www.idug.org/lsidug under the Listserv tab. While at the site,
you can also access the IDUG Online Learning Center, Tech Library and
Code Place, see the latest IDUG conference information and much more.
If you have not yet signed up for Basic Membership in IDUG, available at
no cost, click on Member Services at http://www.idug.org/lsms


________________________________


=========
Confidentiality Notice: This e-mail communication, and any
attachments, contains confidential and privileged information for the
exclusive use of the recipient(s) named above. If you are not an
intended recipient, or the employee or agent responsible to deliver it
to an intended recipient, you are hereby notified that you have received
this communication in error and that any review, disclosure,
dissemination, distribution or copying of it or its contents is
prohibited. If you have received this communication in error, please
notify me immediately by replying to this message and delete this
communication from your computer. Thank you.

Any opinions, expressed or implied, presented are solely those
of the author and do not necessarily represent the opinions of the
agency or the City.
=========

This e-mail may contain confidential or privileged information.
If you think you have received this e-mail in error, please advise the
sender by reply e-mail and then delete this e-mail immediately. Thank
you. Aetna


________________________________


IDUG 2009 - North America * May 11-15, 2009 * Denver, CO, USA
< http://idug.org/lsNA >

The IDUG DB2-L Listserv is only part of your membership in IDUG.
The DB2-L list archives, FAQ, and delivery preferences are at IDUG.ORG
< http://www.idug.org/lsidug > under the Listserv tab. While at the site,
you can also access the IDUG Online Learning Center, Tech Library and
Code Place, see the latest IDUG conference information
< http://www.idug.org/lsconf > , and much more. If you have not yet signed
up for Basic Membership in IDUG, available at no cost, click on Member
Services < http://www.idug.org/lsms >




________________________________


IDUG 2009 - North America * May 11-15, 2009 * Denver, CO, USA
< http://idug.org/lsNA >

The IDUG DB2-L Listserv is only part of your membership in IDUG.
The DB2-L list archives, FAQ, and delivery preferences are at IDUG.ORG
< http://www.idug.org/lsidug > under the Listserv tab. While at the site,
you can also access the IDUG Online Learning Center, Tech Library and
Code Place, see the latest IDUG conference information
< http://www.idug.org/lsconf > , and much more. If you have not yet signed
up for Basic Membership in IDUG, available at no cost, click on Member
Services < http://www.idug.org/lsms >


________________________________

IDUG 2009 - North America * May 11-15, 2009 * Denver, CO, USA
< http://idug.org/lsNA >

The IDUG DB2-L Listserv is only part of your membership in IDUG. The
DB2-L list archives, FAQ, and delivery preferences are at IDUG.ORG
< http://www.idug.org/lsidug > under the Listserv tab. While at the site,
you can also access the IDUG Online Learning Center, Tech Library and
Code Place, see the latest IDUG conference information
< http://www.idug.org/lsconf > , and much more. If you have not yet signed
up for Basic Membership in IDUG, available at no cost, click on Member
Services < http://www.idug.org/lsms >



=========
Confidentiality Notice: This e-mail communication, and any attachments, contains confidential and privileged information for the exclusive use of the recipient(s) named above. If you are not an intended recipient, or the employee or agent responsible to deliver it to an intended recipient, you are hereby notified that you have received this communication in error and that any review, disclosure, dissemination, distribution or copying of it or its contents is prohibited. If you have received this communication in error, please notify me immediately by replying to this message and delete this communication from your computer. Thank you.

Any opinions, expressed or implied, presented are solely those of the author and do not necessarily represent the opinions of the agency or the City.
=========



______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
______________________________________________________________________



The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms

Larry Jardine

Re: [Z/OS] V8 - Image Copy
(in response to Philip Sevetson)
I recall a highly-regarded IBMer telling me that LISTDEF in DB2 9 would
support ranges of partitions, like PARTLEVEL x:y, however, I do not see
it in the DB2 9 documentation.



Larry Jardine

Production DBA

DBA Plan/Product Requests:
https://wiki.aetna.com/confluence/display/dbaplan/Requests
< https://wiki.aetna.com/confluence/display/dbaplan/Requests >

________________________________

From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Sevetson, Phil
Sent: Wednesday, December 03, 2008 10:44 AM
To: [login to unmask email]
Subject: Re: [DB2-L] [Z/OS] V8 - Image Copy



That's worth trying, but you should plan to do a comparison of a
four-way run with a single run using four drives for output - the
four-jobs-on-four-LPARs run might encounter problems in managing the
different partitions in UTIL status at the same time, or might encounter
Inter-DB2-Write-Interest (Global Buffer Pool) residence and/or locking
issues. Such issues might not lead to an error message, but could cause
significant delays with lock waits and Global Buffer Pool
synchronization waits. (No, I'm not _sure_ this is going to happen, I
haven't tried this with a multi-LPAR Data Sharing Group. But I think
it's possible.)

--Phil



________________________________

From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of [login to unmask email]
Sent: Tuesday, December 02, 2008 2:48 PM
To: [login to unmask email]
Subject: Re: [DB2-L] [Z/OS] V8 - Image Copy



Larry and Phil, Thank you for the Responses.



In my initial post, i was not clear on my intent about 4 JOBs. We have 4
way data sharing on 4 different LPARs. I would like to split the work on
4 LPARs. Example (First LPAR would process the image copy for the
partitions 1 to 500, Second LPAR would process the imagecopy for the
Partitions 501 to 1000.... Etc)



I would like to reduce the duration of the job execution by spreading
the work on 4 different LPARs by running jobs parallelly.



Thanks,

Rao





-----Original Message-----
From: DB2 Data Base Discussion List
[mailto:[login to unmask email]On Behalf Of Sevetson, Phil
Sent: Tuesday, December 02, 2008 2:16 PM
To: [login to unmask email]
Subject: Re: [DB2-L] [Z/OS] V8 - Image Copy

Larry and Rao,



Let the user beware. There used to be a memory problem with
specifying too many objects on a LISTDEF, and PARTLEVEL on a 2000-part
tablespace would definitely have tripped the threshold. I don't know if
this problem has persisted into DB2V8/V9




________________________________


From: DB2 Data Base Discussion List [mailto:[login to unmask email]
On Behalf Of Jardine, Lawrence J
Sent: Tuesday, December 02, 2008 1:30 PM
To: [login to unmask email]
Subject: Re: [DB2-L] [Z/OS] V8 - Image Copy



You can do this in a single job step by using the PARALLEL and
UNIT parameters. Important parts below are (1) PARTLEVEL in the LISTDEF
without specifying a number means to process all partitions at the
partition level; and (2) PARALLEL TAPEUNITS(8) in this case means 4
parallel threads (2 per thread, 1 each for the local and the remote
copies). This accomplishes the same processing as if you had 4 separate
jobs and spread the partition ranges across them. But much easier...

Something like this...

//SYSLISTD DD *

LISTDEF QLIST INCLUDE TABLESPACE db.tsname PARTLEVEL


/*

//SYSIN DD *

TEMPLATE LOC1 DSN 'F2B3PB.&DB..&TS..&PA..LPF(+1)'


STACK(YES)

EXPDL '1999000'

GDGLIMIT(10)

UNIT(T3480)

MODELDCB(F108.GDGMODEL)

TEMPLATE REM1 DSN 'F2B3PB.DBR.&DB..&TS..&PA..RPF(+1)'


STACK(YES)

EXPDL '1999000'

GDGLIMIT(10)

UNIT(T3480)

MODELDCB(F108.GDGMODEL)

COPY LIST QLIST COPYDDN(LOC1) RECOVERYDDN(REM1)

SHRLEVEL CHANGE PARALLEL TAPEUNITS(8)

/*

Larry Jardine

Production DBA

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email]
On Behalf Of [login to unmask email]
Sent: Tuesday, December 02, 2008 12:11 PM
To: [login to unmask email]
Subject: Re: [DB2-L] [Z/OS] V8 - Image Copy

Dear List Members,

I have a table space with 2000+ partitions. I would like to
setup the jobs to take imagecopies at the partition level. (Example :
500 Partitions per job).

We use IBM utilities only, we do not have vendor products. Is
there a way to specify the range of partitions for each job without
explicitly specifying all 500 partitions. I have looked at the syntax of
COPY and LISTDEF and i could not able to find any simple solution where
we can specify the range of partitions.

Do we have any other way to achieve this without explicitly
specifying all 500 partitions in the LISTDEF statement. Could you please
let me know.

Thank you,

Rao



-----------------------------------------

This transmission may contain information that is privileged,

confidential, legally privileged, and/or exempt from disclosure

under applicable law. If you are not the intended recipient,
you

are hereby notified that any disclosure, copying, distribution,
or

use of the information contained herein (including any reliance

thereon) is STRICTLY PROHIBITED. Although this transmission and

any attachments are believed to be free of any virus or other

defect that might affect any computer system into which it is

received and opened, it is the responsibility of the recipient
to

ensure that it is virus free and no responsibility is accepted
by

JPMorgan Chase & Co., its subsidiaries and affiliates, as

applicable, for any loss or damage arising in any way from its
use.

If you received this transmission in error, please immediately

contact the sender and destroy the material in its entirety,

whether in electronic or hard copy format. Thank you.


______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 *
http://IDUG.ORG/lsNA *


______________________________________________________________________



The IDUG DB2-L Listserv is only part of your membership in IDUG.
The DB2-L list archives, FAQ, and delivery preferences are at
http://www.idug.org/lsidug under the Listserv tab. While at the site,
you can also access the IDUG Online Learning Center, Tech Library and
Code Place, see the latest IDUG conference information and much more.
If you have not yet signed up for Basic Membership in IDUG, available at
no cost, click on Member Services at http://www.idug.org/lsms


________________________________


=========
Confidentiality Notice: This e-mail communication, and any
attachments, contains confidential and privileged information for the
exclusive use of the recipient(s) named above. If you are not an
intended recipient, or the employee or agent responsible to deliver it
to an intended recipient, you are hereby notified that you have received
this communication in error and that any review, disclosure,
dissemination, distribution or copying of it or its contents is
prohibited. If you have received this communication in error, please
notify me immediately by replying to this message and delete this
communication from your computer. Thank you.

Any opinions, expressed or implied, presented are solely those
of the author and do not necessarily represent the opinions of the
agency or the City.
=========

This e-mail may contain confidential or privileged information.
If you think you have received this e-mail in error, please advise the
sender by reply e-mail and then delete this e-mail immediately. Thank
you. Aetna


________________________________


IDUG 2009 - North America * May 11-15, 2009 * Denver, CO, USA
< http://idug.org/lsNA >

The IDUG DB2-L Listserv is only part of your membership in IDUG.
The DB2-L list archives, FAQ, and delivery preferences are at IDUG.ORG
< http://www.idug.org/lsidug > under the Listserv tab. While at the site,
you can also access the IDUG Online Learning Center, Tech Library and
Code Place, see the latest IDUG conference information
< http://www.idug.org/lsconf > , and much more. If you have not yet signed
up for Basic Membership in IDUG, available at no cost, click on Member
Services < http://www.idug.org/lsms >




________________________________


IDUG 2009 - North America * May 11-15, 2009 * Denver, CO, USA
< http://idug.org/lsNA >

The IDUG DB2-L Listserv is only part of your membership in IDUG.
The DB2-L list archives, FAQ, and delivery preferences are at IDUG.ORG
< http://www.idug.org/lsidug > under the Listserv tab. While at the site,
you can also access the IDUG Online Learning Center, Tech Library and
Code Place, see the latest IDUG conference information
< http://www.idug.org/lsconf > , and much more. If you have not yet signed
up for Basic Membership in IDUG, available at no cost, click on Member
Services < http://www.idug.org/lsms >

________________________________

=========
Confidentiality Notice: This e-mail communication, and any attachments,
contains confidential and privileged information for the exclusive use
of the recipient(s) named above. If you are not an intended recipient,
or the employee or agent responsible to deliver it to an intended
recipient, you are hereby notified that you have received this
communication in error and that any review, disclosure, dissemination,
distribution or copying of it or its contents is prohibited. If you have
received this communication in error, please notify me immediately by
replying to this message and delete this communication from your
computer. Thank you.

Any opinions, expressed or implied, presented are solely those of the
author and do not necessarily represent the opinions of the agency or
the City.
=========


________________________________

IDUG 2009 - North America * May 11-15, 2009 * Denver, CO, USA
< http://idug.org/lsNA >

The IDUG DB2-L Listserv is only part of your membership in IDUG. The
DB2-L list archives, FAQ, and delivery preferences are at IDUG.ORG
< http://www.idug.org/lsidug > under the Listserv tab. While at the site,
you can also access the IDUG Online Learning Center, Tech Library and
Code Place, see the latest IDUG conference information
< http://www.idug.org/lsconf > , and much more. If you have not yet signed
up for Basic Membership in IDUG, available at no cost, click on Member
Services < http://www.idug.org/lsms >


________________________________

IDUG 2009 - North America * May 11-15, 2009 * Denver, CO, USA
< http://idug.org/lsNA >

The IDUG DB2-L Listserv is only part of your membership in IDUG. The
DB2-L list archives, FAQ, and delivery preferences are at IDUG.ORG
< http://www.idug.org/lsidug > under the Listserv tab. While at the site,
you can also access the IDUG Online Learning Center, Tech Library and
Code Place, see the latest IDUG conference information
< http://www.idug.org/lsconf > , and much more. If you have not yet signed
up for Basic Membership in IDUG, available at no cost, click on Member
Services < http://www.idug.org/lsms >


______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
______________________________________________________________________



The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms

Sangameswara Panchomarthi

Re: [Z/OS] V8 - Image Copy
(in response to Larry Jardine)
Phil and Larry,

Thank you for your insights. I think i have to explicitly mention each partition number in the LISTDEF statement.

This is very big table with 10 Billion Rows (4+ TB size). I would like to split as many partition ranges as possible and spread the work on multiple LPARs. I will do testing to make sure there is no inter DB2 issues.

Thanks,
Rao

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email]On Behalf Of Jardine, Lawrence J
Sent: Thursday, December 04, 2008 9:27 AM
To: [login to unmask email]
Subject: Re: [DB2-L] [Z/OS] V8 - Image Copy



I recall a highly-regarded IBMer telling me that LISTDEF in DB2 9 would support ranges of partitions, like PARTLEVEL x:y, however, I do not see it in the DB2 9 documentation.



Larry Jardine

Production DBA

DBA Plan/Product Requests: < https://wiki.aetna.com/confluence/display/dbaplan/Requests > https://wiki.aetna.com/confluence/display/dbaplan/Requests


_____


From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf Of Sevetson, Phil
Sent: Wednesday, December 03, 2008 10:44
To: [login to unmask email]
Subject: Re: [DB2-L] [Z/OS] V8 - Image Copy



That's worth trying, but you should plan to do a comparison of a four-way run with a single run using four drives for output - the four-jobs-on-four-LPARs run might encounter problems in managing the different partitions in UTIL status at the same time, or might encounter Inter-DB2-Write-Interest (Global Buffer Pool) residence and/or locking issues. Such issues might not lead to an error message, but could cause significant delays with lock waits and Global Buffer Pool synchronization waits. (No, I'm not _sure_ this is going to happen, I haven't tried this with a multi-LPAR Data Sharing Group. But I think it's possible.)

--Phil




_____


From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf Of [login to unmask email]
Sent: Tuesday, December 02, 2008 2:48 PM
To: [login to unmask email]
Subject: Re: [DB2-L] [Z/OS] V8 - Image Copy



Larry and Phil, Thank you for the Responses.



In my initial post, i was not clear on my intent about 4 JOBs. We have 4 way data sharing on 4 different LPARs. I would like to split the work on 4 LPARs. Example (First LPAR would process the image copy for the partitions 1 to 500, Second LPAR would process the imagecopy for the Partitions 501 to 1000.... Etc)



I would like to reduce the duration of the job execution by spreading the work on 4 different LPARs by running jobs parallelly.



Thanks,

Rao





-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email]On Behalf Of Sevetson, Phil
Sent: Tuesday, December 02, 2008 2:16 PM
To: [login to unmask email]
Subject: Re: [DB2-L] [Z/OS] V8 - Image Copy

Larry and Rao,



Let the user beware. There used to be a memory problem with specifying too many objects on a LISTDEF, and PARTLEVEL on a 2000-part tablespace would definitely have tripped the threshold. I don't know if this problem has persisted into DB2V8/V9




_____


From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf Of Jardine, Lawrence J
Sent: Tuesday, December 02, 2008 1:30 PM
To: [login to unmask email]
Subject: Re: [DB2-L] [Z/OS] V8 - Image Copy



You can do this in a single job step by using the PARALLEL and UNIT parameters. Important parts below are (1) PARTLEVEL in the LISTDEF without specifying a number means to process all partitions at the partition level; and (2) PARALLEL TAPEUNITS(8) in this case means 4 parallel threads (2 per thread, 1 each for the local and the remote copies). This accomplishes the same processing as if you had 4 separate jobs and spread the partition ranges across them. But much easier...

Something like this...

//SYSLISTD DD *

LISTDEF QLIST INCLUDE TABLESPACE db.tsname PARTLEVEL

/*

//SYSIN DD *

TEMPLATE LOC1 DSN 'F2B3PB.&DB..&TS..&PA..LPF(+1)'

STACK(YES)

EXPDL '1999000'

GDGLIMIT(10)

UNIT(T3480)

MODELDCB(F108.GDGMODEL)

TEMPLATE REM1 DSN 'F2B3PB.DBR.&DB..&TS..&PA..RPF(+1)'

STACK(YES)

EXPDL '1999000'

GDGLIMIT(10)

UNIT(T3480)

MODELDCB(F108.GDGMODEL)

COPY LIST QLIST COPYDDN(LOC1) RECOVERYDDN(REM1)

SHRLEVEL CHANGE PARALLEL TAPEUNITS(8)

/*

Larry Jardine

Production DBA

-----Original Message-----
From: DB2 Data Base Discussion List [ mailto:[login to unmask email] On Behalf Of [login to unmask email]
Sent: Tuesday, December 02, 2008 12:11 PM
To: [login to unmask email]
Subject: Re: [DB2-L] [Z/OS] V8 - Image Copy

Dear List Members,

I have a table space with 2000+ partitions. I would like to setup the jobs to take imagecopies at the partition level. (Example : 500 Partitions per job).

We use IBM utilities only, we do not have vendor products. Is there a way to specify the range of partitions for each job without explicitly specifying all 500 partitions. I have looked at the syntax of COPY and LISTDEF and i could not able to find any simple solution where we can specify the range of partitions.

Do we have any other way to achieve this without explicitly specifying all 500 partitions in the LISTDEF statement. Could you please let me know.

Thank you,

Rao



-----------------------------------------

This transmission may contain information that is privileged,

confidential, legally privileged, and/or exempt from disclosure

under applicable law. If you are not the intended recipient, you

are hereby notified that any disclosure, copying, distribution, or

use of the information contained herein (including any reliance

thereon) is STRICTLY PROHIBITED. Although this transmission and

any attachments are believed to be free of any virus or other

defect that might affect any computer system into which it is

received and opened, it is the responsibility of the recipient to

ensure that it is virus free and no responsibility is accepted by

JPMorgan Chase & Co., its subsidiaries and affiliates, as

applicable, for any loss or damage arising in any way from its use.

If you received this transmission in error, please immediately

contact the sender and destroy the material in its entirety,

whether in electronic or hard copy format. Thank you.

______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *

______________________________________________________________________



The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms


_____


=========
Confidentiality Notice: This e-mail communication, and any attachments, contains confidential and privileged information for the exclusive use of the recipient(s) named above. If you are not an intended recipient, or the employee or agent responsible to deliver it to an intended recipient, you are hereby notified that you have received this communication in error and that any review, disclosure, dissemination, distribution or copying of it or its contents is prohibited. If you have received this communication in error, please notify me immediately by replying to this message and delete this communication from your computer. Thank you.

Any opinions, expressed or implied, presented are solely those of the author and do not necessarily represent the opinions of the agency or the City.
=========

This e-mail may contain confidential or privileged information. If you think you have received this e-mail in error, please advise the sender by reply e-mail and then delete this e-mail immediately. Thank you. Aetna


_____


< http://idug.org/lsNA > IDUG 2009 - North America * May 11-15, 2009 * Denver, CO, USA

The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at IDUG.ORG <http://www.idug.org/lsidug> under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information <http://www.idug.org/lsconf> , and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member < http://www.idug.org/lsms > Services




_____


< http://idug.org/lsNA > IDUG 2009 - North America * May 11-15, 2009 * Denver, CO, USA

The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at IDUG.ORG <http://www.idug.org/lsidug> under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information <http://www.idug.org/lsconf> , and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member < http://www.idug.org/lsms > Services


_____


=========
Confidentiality Notice: This e-mail communication, and any attachments, contains confidential and privileged information for the exclusive use of the recipient(s) named above. If you are not an intended recipient, or the employee or agent responsible to deliver it to an intended recipient, you are hereby notified that you have received this communication in error and that any review, disclosure, dissemination, distribution or copying of it or its contents is prohibited. If you have received this communication in error, please notify me immediately by replying to this message and delete this communication from your computer. Thank you.

Any opinions, expressed or implied, presented are solely those of the author and do not necessarily represent the opinions of the agency or the City.
=========


_____

< http://idug.org/lsNA > IDUG 2009 - North America * May 11-15, 2009 * Denver, CO, USA

The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at IDUG.ORG <http://www.idug.org/lsidug> under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information <http://www.idug.org/lsconf> , and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member < http://www.idug.org/lsms > Services


_____

< http://idug.org/lsNA > IDUG 2009 - North America * May 11-15, 2009 * Denver, CO, USA

The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at IDUG.ORG <http://www.idug.org/lsidug> under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information <http://www.idug.org/lsconf> , and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member < http://www.idug.org/lsms > Services


_____

< http://idug.org/lsNA > IDUG 2009 - North America * May 11-15, 2009 * Denver, CO, USA

The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at IDUG.ORG <http://www.idug.org/lsidug> under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information <http://www.idug.org/lsconf> , and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member < http://www.idug.org/lsms > Services




-----------------------------------------
This transmission may contain information that is privileged,
confidential, legally privileged, and/or exempt from disclosure
under applicable law. If you are not the intended recipient, you
are hereby notified that any disclosure, copying, distribution, or
use of the information contained herein (including any reliance
thereon) is STRICTLY PROHIBITED. Although this transmission and
any attachments are believed to be free of any virus or other
defect that might affect any computer system into which it is
received and opened, it is the responsibility of the recipient to
ensure that it is virus free and no responsibility is accepted by
JPMorgan Chase & Co., its subsidiaries and affiliates, as
applicable, for any loss or damage arising in any way from its use.
If you received this transmission in error, please immediately
contact the sender and destroy the material in its entirety,
whether in electronic or hard copy format. Thank you.

______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
______________________________________________________________________



The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms