CICS/DB2 Accounting Question

Michael Figaro

CICS/DB2 Accounting Question
I just changed a CICS transaction from using a pooled to using a protected thread. Before this I generated one 101 record for each transaction. Now it seems that many of the transactions are getting accumulated into a single 101 record.

Can someone tell me how to cause a 101 record to get written for each transaction? I looked at the code and the program is issuing a syncpoint before existing.

This is CICS 3.2 and DB2 V8.

Thanks,

Michael Figaro
Software Consultant
p: 281.207.4937 | m: 713.805.4956

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
** The most DB2 technical sessions of any conference
** Access IBM experts and developers
_____________________________________________________________________

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

Richard Gugel

Re: CICS/DB2 Accounting Question
(in response to Michael Figaro)
Micheal

The Accountrec on the CICS DB2entry influences this behavior. It is documented in CICS DB2 guide in the CICS documentation library. Look at topic
10.10.2 Controlling the relationship between DB2 accounting records and CICS performance class records in particular.

HTH
Rich Gugel

-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Michael Figaro
Sent: Thursday, December 02, 2010 11:18 AM
To: [login to unmask email]
Subject: [DB2-L] CICS/DB2 Accounting Question

I just changed a CICS transaction from using a pooled to using a protected thread. Before this I generated one 101 record for each transaction. Now it seems that many of the transactions are getting accumulated into a single 101 record.

Can someone tell me how to cause a 101 record to get written for each transaction? I looked at the code and the program is issuing a syncpoint before existing.

This is CICS 3.2 and DB2 V8.

Thanks,

Michael Figaro
Software Consultant
p: 281.207.4937 | m: 713.805.4956

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
** The most DB2 technical sessions of any conference
** Access IBM experts and developers
_____________________________________________________________________

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

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
** The most DB2 technical sessions of any conference
** Access IBM experts and developers
_____________________________________________________________________

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

Ted MacNEIL

Re: CICS/DB2 Accounting Question
(in response to Richard Gugel)
>Can someone tell me how to cause a 101 record to get written for each transaction?

Technically, 101's are not written at the end of a transaction.
They are written at the termination of a thread, unless things have changed.

Protected (Entry?) Threads do not terminate at the end of an individual transaction, but at the end of a period of time of inactivity.

As a capacity analyst, I've always hated this shortfall.

At the last time we considered going back to pooled threads, the overhead of using them was considered excessive.

At the time 2.2 came out with better instrumentation, I was not working in a shop with CICS/DB2 connections.
So, I don't know if there is any better information available.

It may be worth exploring.
-
Ted MacNEIL
[login to unmask email]

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
** The most DB2 technical sessions of any conference
** Access IBM experts and developers
_____________________________________________________________________

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

Gregory Palgrave

Re: CICS/DB2 Accounting Question
(in response to Ted MacNEIL)
Hi Michael,

Last time I played with DB2 & CICS we still used RCT entries, and there was a mechanism then to cut an accounting record after each transaction, although I can't remember exactly what it was called.

Google tells me that for RDO definitions, there is also an ACCOUNTREC({NONE|TASK|TXID|UOW}) option that changes the amount of DB2 accounting records that get produced, which may be what you need. I'll leave you to dig through the manual for the details :)

Cheers

Greg

-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Michael Figaro
Sent: Friday, 3 December 2010 1:18 AM
To: [login to unmask email]
Subject: [DB2-L] CICS/DB2 Accounting Question

I just changed a CICS transaction from using a pooled to using a protected thread. Before this I generated one 101 record for each transaction. Now it seems that many of the transactions are getting accumulated into a single 101 record.

Can someone tell me how to cause a 101 record to get written for each transaction? I looked at the code and the program is issuing a syncpoint before existing.

This is CICS 3.2 and DB2 V8.

Thanks,

Michael Figaro
Software Consultant
p: 281.207.4937 | m: 713.805.4956


_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
** The most DB2 technical sessions of any conference
** Access IBM experts and developers
_____________________________________________________________________

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

Max Scarpa

Re: CICS/DB2 Accounting Question
(in response to Gregory Palgrave)
It's the classic problem happening when you implement protected thread,
the stacking of threads. You could use (ACCT time/number of threads) to
have a rough evaluation about tx times. But it's better to use ACCOUNTREC
to cut SMF records for every tx/UOW etc. (Once you had to use TOKENE
parameter,). But protected thread need monitoring so if you need more
infos see for example:

- CICS-DB2 Performance:Hints, Tips, and War Stories by Robert Catterall

- Exploiting the CICS-DB2 borderland by Svenn-Aage
Sønderskov

- DB2/CICS interface - A view of interface between DB2 / CICS by Patricia
Townsend (good for monitoring suggestions)

HTH

Max Scarpa

The Fifth Rule: You have taken yourself too seriously.

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** The best DB2 technical sessions in the world
** Independent, not-for-profit, User Run - the IDUG difference!
_____________________________________________________________________

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

Jan Vanbrabant

Re: CICS/DB2 Accounting Question
(in response to Max Scarpa)
Hi Max,

*Re. *

*CICS-DB2 Performance: Hints, Tips, and War Stories (Robert Catterall) *



I googled

http://www.share.org/proceedings/sh97/data/S1355.PDF

But: not found and it's redirecting to the SHARE home page.
This presentation is from a previous Share, hence not available, unless you
are a share memeber.
Though being GSE, you can't have access to previous proceedings. An old
pain................

Can you (or someone alse) route me (and probably others) to Robert's
presentation?

Thanks.
jan

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** The best DB2 technical sessions in the world
** Independent, not-for-profit, User Run - the IDUG difference!
_____________________________________________________________________

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

Max Scarpa

Re: CICS/DB2 Accounting Question
(in response to Jan Vanbrabant)
Sent, hope you received it . It0s an old article, I think there are more
recent versions but I've to dig more.

Max


_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** The best DB2 technical sessions in the world
** Independent, not-for-profit, User Run - the IDUG difference!
_____________________________________________________________________

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

Jan Vanbrabant

Re: CICS/DB2 Accounting Question
(in response to Max Scarpa)
It's OK, Max, thanks!

You put me on orbit to go and read the excellent (by the way) CICS-DB2
Guide:


*SC34-7011-01 CICS TS for z/OS V4R1 DB2 Guide*

Chapter10. Accounting and monitoring in a CICS DB2 environment
............139

Relating DB2 accounting records to CICS performance class records
.........155

What are the issues when matching DB2 accounting records and
CICS performance records? ... 156

Controlling the relationship between DB2 accounting records
and CICS performance class records ... 157

Using data in the DB2 accounting record to identify the
corresponding CICS performance classrecords .... 158

Strategies to match DB2 accounting records and CICS
performance class records and charge resources back to the user ...159



http://publib.boulder.ibm.com/infocenter/cicsts/v4r1/topic/com.ibm.cics.ts.doc/pdf/dfhtk_pdf.pdf



:-D



Thanks a lot!

jan


On Fri, Dec 3, 2010 at 11:37 AM, Max Scarpa <[login to unmask email]> wrote:

> Sent, hope you received it . It0s an old article, I think there are more
> recent versions but I've to dig more.
>
> Max
>
>
> ------------------------------
>
> [image: Independent, not-for-profit, User Run - the IDUG difference! ] < http://www.idug.org/ >
>
> 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 * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** The best DB2 technical sessions in the world
** Independent, not-for-profit, User Run - the IDUG difference!
_____________________________________________________________________

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