B37 in Change Accumulation Tool

Horacio Villa

B37 in Change Accumulation Tool
Hi,

we're doing our first experiences with Change Accumulation Tool.
The tool is kind of old-fashion: no LISTDEF, no TEMPLATE. You have to
explicitly define a DD for each TS/PART combination you have, and name
them all in the CHANGE command.
It dynamically allocates some DDs like SORTIN2 and SORTOUT2 and I haven't
found how to customize them/tell the utility how much space to get.
And it's abending with B37 on SORTIN2/SORTOUT2.
Any tips about how to go with this?

Cheers,

Horacio Villa

The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the 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

Horacio Villa

Re: B37 in Change Accumulation Tool
(in response to Horacio Villa)
Hi list,

as I haven't received any answer to this question, I wonder if it
succeeded to the list.
Please forgive me if it did before.

Cheers,

Horacio Villa




Horacio Villa/Argentina/Contr/IBM
11/01/2008 19:18

To
DB2-L
cc

Subject
B37 in Change Accumulation Tool





Hi,

we're doing our first experiences with Change Accumulation Tool.
The tool is kind of old-fashion: no LISTDEF, no TEMPLATE. You have to
explicitly define a DD for each TS/PART combination you have, and name
them all in the CHANGE command.
It dynamically allocates some DDs like SORTIN2 and SORTOUT2 and I haven't
found how to customize them/tell the utility how much space to get.
And it's abending with B37 on SORTIN2/SORTOUT2.
Any tips about how to go with this?

Cheers,

Horacio Villa


The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the 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

Avram Friedman

Re: B37 in Change Accumulation Tool
(in response to Horacio Villa)
Horacio,
There is good news and bad news about IBM's family of DB2 add ons.
The good news is that given the strength of the base DB2 product (which is
an IBM product) and the strength of IBM its self one can reasonable expect a
high percentage of tools offerings from this vendor to be high quality and well
supported (at least eventually).
The bad news is IBM is the new kid on the block for many of these tools and it
is not the one of the current perdominant vendors interms of installed
customer base.

I think the non response from your first querry (It did make it out to the list) is
a mesurement of the 'bad news'.

Have you opened a case with the vendor?

If you want a couple of guesses from a non user of this product

1. review the documention ... I found the user guide at
http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?
topic=/com.ibm.db2tools.ggc.doc.ug/ggccon_bkoverview.htm

2. My guess is what is getting sorted is the archive log or a stripped archive
log. The historic real change accum (its an IMS concept) is the after images
get extracted from the log and are sorted in pageset RBA order and then
date / time.

The component that you will be interested in is the specification for the ML
(mini Log) this can be specified in either the run time syntax or the group set
up.

Please recall I am not a user of this tool I just looked it up in the manual.

Regards
Avram Friedman

On Mon, 14 Jan 2008 12:35:12 -0200, Horacio Villa <[login to unmask email]>
wrote:

>Hi list,
>
>as I haven't received any answer to this question, I wonder if it
>succeeded to the list.
>Please forgive me if it did before.
>
>Cheers,
>
>Horacio Villa
>
>
>
>
>Horacio Villa/Argentina/Contr/IBM
>11/01/2008 19:18
>
>To
>DB2-L
>cc
>
>Subject
>B37 in Change Accumulation Tool
>
>
>
>
>
>Hi,
>
>we're doing our first experiences with Change Accumulation Tool.
>The tool is kind of old-fashion: no LISTDEF, no TEMPLATE. You have to
>explicitly define a DD for each TS/PART combination you have, and name
>them all in the CHANGE command.
>It dynamically allocates some DDs like SORTIN2 and SORTOUT2 and I haven't
>found how to customize them/tell the utility how much space to get.
>And it's abending with B37 on SORTIN2/SORTOUT2.
>Any tips about how to go with this?
>
>Cheers,
>
>Horacio Villa
>
>
>The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list
archives, the 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
>

The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the 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

Horacio Villa

Re: B37 in Change Accumulation Tool
(in response to Avram Friedman)
Avram,

thanks for your answer.
I also thought that the non responde was because of the bad news, but
wasn't sure.
I'm just begining to know the product, and I feel it has to mature a lot.
Even the doc is insufficient. There's no reference to this SORTIN2 and
SORTOUT2 and/or their dynamic allocation.
We are opening a case with the lab just now.

Thanks again,

Horacio



Avram Friedman <[login to unmask email]>
Sent by: DB2 Data Base Discussion List <[login to unmask email]>
14/01/2008 13:17
Please respond to
DB2 Database Discussion list at IDUG <[login to unmask email]>


To
[login to unmask email]
cc

Subject
Re: [DB2-L] B37 in Change Accumulation Tool






Horacio,
There is good news and bad news about IBM's family of DB2 add ons.
The good news is that given the strength of the base DB2 product (which is

an IBM product) and the strength of IBM its self one can reasonable expect
a
high percentage of tools offerings from this vendor to be high quality and
well
supported (at least eventually).
The bad news is IBM is the new kid on the block for many of these tools
and it
is not the one of the current perdominant vendors interms of installed
customer base.

I think the non response from your first querry (It did make it out to the
list) is
a mesurement of the 'bad news'.

Have you opened a case with the vendor?

If you want a couple of guesses from a non user of this product

1. review the documention ... I found the user guide at
http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?
topic=/com.ibm.db2tools.ggc.doc.ug/ggccon_bkoverview.htm

2. My guess is what is getting sorted is the archive log or a stripped
archive
log. The historic real change accum (its an IMS concept) is the after
images
get extracted from the log and are sorted in pageset RBA order and then
date / time.

The component that you will be interested in is the specification for the
ML
(mini Log) this can be specified in either the run time syntax or the
group set
up.

Please recall I am not a user of this tool I just looked it up in the
manual.

Regards
Avram Friedman

On Mon, 14 Jan 2008 12:35:12 -0200, Horacio Villa <[login to unmask email]>
wrote:

>Hi list,
>
>as I haven't received any answer to this question, I wonder if it
>succeeded to the list.
>Please forgive me if it did before.
>
>Cheers,
>
>Horacio Villa
>
>
>
>
>Horacio Villa/Argentina/Contr/IBM
>11/01/2008 19:18
>
>To
>DB2-L
>cc
>
>Subject
>B37 in Change Accumulation Tool
>
>
>
>
>
>Hi,
>
>we're doing our first experiences with Change Accumulation Tool.
>The tool is kind of old-fashion: no LISTDEF, no TEMPLATE. You have to
>explicitly define a DD for each TS/PART combination you have, and name
>them all in the CHANGE command.
>It dynamically allocates some DDs like SORTIN2 and SORTOUT2 and I haven't
>found how to customize them/tell the utility how much space to get.
>And it's abending with B37 on SORTIN2/SORTOUT2.
>Any tips about how to go with this?
>
>Cheers,
>
>Horacio Villa
>
>
>The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L
list
archives, the 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
>

The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L
list archives, the 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


The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the 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