DB2 activity using IBM/Tivoli's PERFORMANCE REPORTER for OS/390

[login to unmask email]

DB2 activity using IBM/Tivoli's PERFORMANCE REPORTER for OS/390
Hi all

Our capacity and planning group has decided to use Performance Reporter to
capture MVS, IMS, CICS, and DB2 info.

Can anyone give me an idea how much overhead I will see with this product.

Tom



James Wu

Re: DB2 activity using IBM/Tivoli's PERFORMANCE REPORTER for OS/3 90
(in response to ttaylor@CHUBB.COM)
I have been using Performance Reporter Since Version 1.1 (now we are
at V1.4) and I love the product. Because it is built on DB2/SQL/QMF, it can
be opened to all users who know SQL.

The CPU overhead on DB2 and MVS is not a big concern because 1).
most of the CPU usage is from the batch collection and DB2 maintenance jobs,
2). usually there are limited number of on-line users during the primary
shift and 3). we can set up QMF resource limits to control the ad-hoc
queries/users.

The DASD space requirement could be high though, depending on the
'Purge Condition' (the retention period of the historical data) in your
shop. You have to ensure you have enough DASD space for DB2 data as well as
the temporary work space for DB2 maintenance jobs. The other concern is the
batch window for DB maintenance (many tables are HUGE). You can reduce the
batch window by partitioning the tablespaces, setting up appropriate Purge
Conditions, Grouping tablespaces in the jobs evenly, etc.

James Wu :-)

[login to unmask email]


> -----Original Message-----
> From: [login to unmask email]
> [SMTP:[login to unmask email]
> Sent: Thursday, December 16, 1999 9:34 AM
> To: [login to unmask email]
> Subject: DB2 activity using IBM/Tivoli's PERFORMANCE REPORTER for
> OS/390
>
> Hi all
>
> Our capacity and planning group has decided to use Performance Reporter to
> capture MVS, IMS, CICS, and DB2 info.
>
> Can anyone give me an idea how much overhead I will see with this product.
>
> Tom
>
>
>
>
>



Isaac Yassin

Re: DB2 activity using IBM/Tivoli's PERFORMANCE REPORTER for OS/390
(in response to James Wu)
Hi,

We used an older version about 2 years ago. Was horrible - slow, ugly,
unfriendly and did a lot of processing for nothing. Reports were ok. , but the
way to get them .....
I especially loved the option to "open" a code value table on each field - it
always caused TS scan ... The only way out was to cancel your TSO session.


[login to unmask email] wrote:
>
> Hi all
>
> Our capacity and planning group has decided to use Performance Reporter to
> capture MVS, IMS, CICS, and DB2 info.
>
> Can anyone give me an idea how much overhead I will see with this product.
>
> Tom
>
>
>

--
Isaac Yassin

DBMS & IT Consultant

Tel: +972 9 9505172
Cel: +972 54 452793
Fax: +972 9 9560803



James Wu

Re: DB2 activity using IBM/Tivoli's PERFORMANCE REPORTER for OS/3 90
(in response to Isaac Yassin)
The key is not to use all Tivoli supplied DDL for tablespaces and indexes.
With some customization, the product works fine in our shop.

James Wu :-)

(847)646-5548
[login to unmask email]

> -----Original Message-----
> From: Isaac Yassin [SMTP:[login to unmask email]
> Sent: Thursday, December 16, 1999 12:12 PM
> To: [login to unmask email]
> Subject: Re: DB2 activity using IBM/Tivoli's PERFORMANCE REPORTER for
> OS/390
>
> Hi,
>
> We used an older version about 2 years ago. Was horrible - slow, ugly,
> unfriendly and did a lot of processing for nothing. Reports were ok. , but
> the
> way to get them .....
> I especially loved the option to "open" a code value table on each field -
> it
> always caused TS scan ... The only way out was to cancel your TSO session.
>
>
> [login to unmask email] wrote:
> >
> > Hi all
> >
> > Our capacity and planning group has decided to use Performance Reporter
> to
> > capture MVS, IMS, CICS, and DB2 info.
> >
> > Can anyone give me an idea how much overhead I will see with this
> product.
> >
> > Tom
> >
> >
> >
>
>
>
> --
> Isaac Yassin
>
> DBMS & IT Consultant
>
> Tel: +972 9 9505172
> Cel: +972 54 452793
> Fax: +972 9 9560803
>
>
>
>
>



[login to unmask email]

Re: DB2 activity using IBM/Tivoli's PERFORMANCE REPORTER for OS/3 90
(in response to James Wu)
James
Using the ispf screens it indicates that there is a DB2 component, but I can't
find any DB2 component listed at either IBM or Tivoli web sites.
What's up with this. I also have no doc

Tom







"Wu, James" <[login to unmask email]> on 12/16/99 03:29:19 PM

Please respond to DB2 Data Base Discussion List <[login to unmask email]>








To: [login to unmask email]

cc: (bcc: Thomas G Taylor/ChubbMail)



Subject: Re: DB2 activity using IBM/Tivoli's PERFORMANCE
REPORTER for OS/3 90








The key is not to use all Tivoli supplied DDL for tablespaces and indexes.
With some customization, the product works fine in our shop.

James Wu :-)

(847)646-5548
[login to unmask email]

> -----Original Message-----
> From: Isaac Yassin [SMTP:[login to unmask email]
> Sent: Thursday, December 16, 1999 12:12 PM
> To: [login to unmask email]
> Subject: Re: DB2 activity using IBM/Tivoli's PERFORMANCE REPORTER for
> OS/390
>
> Hi,
>
> We used an older version about 2 years ago. Was horrible - slow, ugly,
> unfriendly and did a lot of processing for nothing. Reports were ok. , but
> the
> way to get them .....
> I especially loved the option to "open" a code value table on each field -
> it
> always caused TS scan ... The only way out was to cancel your TSO session.
>
>
> [login to unmask email] wrote:
> >
> > Hi all
> >
> > Our capacity and planning group has decided to use Performance Reporter
> to
> > capture MVS, IMS, CICS, and DB2 info.
> >
> > Can anyone give me an idea how much overhead I will see with this
> product.
> >
> > Tom
> >
> >
> >
>
>
>
> --
> Isaac Yassin
>
> DBMS & IT Consultant
>
> Tel: +972 9 9505172
> Cel: +972 54 452793
> Fax: +972 9 9560803
>
>
>
>
>








James Wu

Re: DB2 activity using IBM/Tivoli's PERFORMANCE REPORTER for OS/3 90
(in response to ttaylor@CHUBB.COM)
Tom,

Tivoli's Website only mentions that the product needs DB2 V3 and up.
For more information, you have to obtain the manuals, such as Administration
Guide, from IBM/Tivoli.

James Wu :-)


> -----Original Message-----
> From: [login to unmask email]
> [SMTP:[login to unmask email]
> Sent: Friday, December 17, 1999 11:27 AM
> To: [login to unmask email]
> Subject: Re: DB2 activity using IBM/Tivoli's PERFORMANCE REPORTER for
> OS/3 90
>
> James
> Using the ispf screens it indicates that there is a DB2 component, but I
> can't
> find any DB2 component listed at either IBM or Tivoli web sites.
> What's up with this. I also have no doc
>
> Tom
>
>
>
>
>
>
>
> "Wu, James" <[login to unmask email]> on 12/16/99 03:29:19 PM
>
> Please respond to DB2 Data Base Discussion List <[login to unmask email]>
>
>
>
>
>
>
>
>
> To: [login to unmask email]
>
> cc: (bcc: Thomas G Taylor/ChubbMail)
>
>
>
> Subject: Re: DB2 activity using IBM/Tivoli's PERFORMANCE
> REPORTER for OS/3 90
>
>
>
>
>
>
>
>
> The key is not to use all Tivoli supplied DDL for tablespaces and indexes.
> With some customization, the product works fine in our shop.
>
> James Wu
> :-)
>
> (847)646-5548
> [login to unmask email]
>
> > -----Original Message-----
> > From: Isaac Yassin [SMTP:[login to unmask email]
> > Sent: Thursday, December 16, 1999 12:12 PM
> > To: [login to unmask email]
> > Subject: Re: DB2 activity using IBM/Tivoli's PERFORMANCE REPORTER
> for
> > OS/390
> >
> > Hi,
> >
> > We used an older version about 2 years ago. Was horrible - slow, ugly,
> > unfriendly and did a lot of processing for nothing. Reports were ok. ,
> but
> > the
> > way to get them .....
> > I especially loved the option to "open" a code value table on each field
> -
> > it
> > always caused TS scan ... The only way out was to cancel your TSO
> session.
> >
> >
> > [login to unmask email] wrote:
> > >
> > > Hi all
> > >
> > > Our capacity and planning group has decided to use Performance
> Reporter
> > to
> > > capture MVS, IMS, CICS, and DB2 info.
> > >
> > > Can anyone give me an idea how much overhead I will see with this
> > product.
> > >
> > > Tom
> > >
> > >
> > >
> visit
> > the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list
> can
> >
> >
> > --
> > Isaac Yassin
> >
> > DBMS & IT Consultant
> >
> > Tel: +972 9 9505172
> > Cel: +972 54 452793
> > Fax: +972 9 9560803
> >
> >
> >
> > the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list
> can
> >
>
>
>
> the
>
>
>
>
>
>
>