[DB2-L] Offloading SMF accounting records

Thomas Weber

[DB2-L] Offloading SMF accounting records
Hi Ludmila,

try http://www.storage.ibm.com/software/sort/mvs/tricks

Regards

Thomas


>
> Hello,
> We are a small shop and just migrating some of our apps to
> DB2. I am the
> DB2 systems girl here, and I am also on the learning curve.
> We have been told to keep 5 days worth of DB2 accounting
> records of SMF
> type 100 and 101.
>
> I am encountering issues in filtering the db2 100 and 101
> records from our
> smf daily dataset.
> I have raw smf dataset (offloaded from Man(n)datasets) and I am just
> writing a SORT to squeeze SMF type 100 or 101 records, but in futile.
>
> Can anyone please send me a sample JCL that wd show me how to
> do it?. It
> wd be helpful.
> We are on DB2 V8 compat mode.
>
> Ludmil
>
> --------------------------------------------------------------
> -------------------
> Welcome to the IDUG DB2-L list. To unsubscribe, go to the
> archives and home page at
> http://www.idugdb2-l.org/archives/db2-l.html. From that page
> select "Join or Leave the list". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. The IDUG List Admins can be reached at
[login to unmask email] Find out the latest on IDUG conferences at
http://conferences.idug.org/index.cfm

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Bart Mertens

Re: Offloading SMF accounting records
(in response to Thomas Weber)
We use this:

//SMFDUMP JOB MSGLEVEL=1
//STARTING EXEC SMFDUMP,SMF=1
//SMFDUMP PROC
//* DUMPEN NAAR Z781.P001.SMFDAG EN
//* DUMPEN EN LEEGMAKEN SYS1.MAN1,SYS1.MAN2 NAAR SMFDAG FILE
//STEP005 EXEC PGM=IFASMFDP
//DUMPIN DD DSN=SYS1.MAN&SMF,DISP=SHR
//DUMPOUT DD DSN=Z781.O001.DSN1.SMFDAG,DISP=MOD
//SYSPRINT DD SYSOUT=*
//SYSIN DD DISP=SHR,DSN=HSYS.O002.SYSPRO.PARMLIB(SMFDMP1)

Don't have the permission to view the parameters (SYSIN) but this is what
the job output says:
IFA010I SMF DUMP PARAMETERS
IFA010I END(2400) -- DEFAULT
IFA010I START(0000) -- DEFAULT
IFA010I DATE(1900000,2099366) -- DEFAULT
IFA010I OUTDD(DUMPOUT,TYPE(100:102)) -- SYSIN
IFA010I INDD(DUMPIN,OPTIONS(DUMP)) -- SYSIN
IFA020I DUMPOUT -- Z781.O001.DSN1.SMFDAG
IFA020I DUMPIN -- SYS1.MAN1

met vriendelijke groeten,
Bart Mertens
Database Administrator DB2
CZ Actief in Gezondheid - Tilburg
* (013) 593 8256
* [login to unmask email]


-----Oorspronkelijk bericht-----
Van: DB2 Data Base Discussion List [mailto:[login to unmask email] Namens
Ludmila Koganer
Verzonden: Wednesday, December 29, 2004 06:35
Aan: [login to unmask email]
Onderwerp: [DB2-L] Offloading SMF accounting records

Hello,
We are a small shop and just migrating some of our apps to DB2. I am the
DB2 systems girl here, and I am also on the learning curve.
We have been told to keep 5 days worth of DB2 accounting records of SMF
type 100 and 101.

I am encountering issues in filtering the db2 100 and 101 records from our
smf daily dataset.
I have raw smf dataset (offloaded from Man(n)datasets) and I am just
writing a SORT to squeeze SMF type 100 or 101 records, but in futile.

Can anyone please send me a sample JCL that wd show me how to do it?. It
wd be helpful.
We are on DB2 V8 compat mode.

Ludmil

----------------------------------------------------------------------------
-----
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home
page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select
"Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org.
The IDUG List Admins can be reached at [login to unmask email] Find
out the latest on IDUG conferences at http://conferences.idug.org/index.cfm


==================
De informatie verzonden met dit e-mail bericht is vertrouwelijk en
uitsluitend bestemd voor de geadresseerde. Indien bovenstaand e-mailbericht
niet aan u is gericht, verzoeken wij u vriendelijk doch dringend het
e-mailbericht te retourneren aan de verzender en het origineel en eventuele
kopieen te verwijderen en te vernietigen. Gebruik van deze informatie door
anderen dan de geadresseerde is verboden. Openbaarmaking, vermenigvuldiging,
verspreiding en/of verstrekking van deze informatie aan derden is niet
toegestaan. CZ staat niet in voor de juiste en volledige overbrenging van de
inhoud van een verzonden e-mail, noch voor tijdige ontvangst daarvan.

==================
The information contained in this communication is confidential and may be
legally privileged. If you are not the intended recipient of this
communication please return the communication to the sender and delete and
destroy all copies. It is intended solely for the use of the individual or
entity to whom it is addressed and others authorised to receive it. If you
are not the intended recipient you are hereby notified that any disclosure,
copying, distribution or taking any action in reliance on the contents of
this information is strictly prohibited and may be unlawful. CZ health
insurance is neither liable for the proper and complete transmission of the
information contained in this communication nor for any delay in its
receipt.

===================

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Ivan Losada

Re: Offloading SMF accounting records
(in response to Bart Mertens)
Hi,
to extract only some type of smf records from the "mans offload" we use
this:
//STEP1 EXEC PGM=ICEMAN
//SORTLIB DD DSN=SYS1.SORTLIB,DISP=SHR
//SYSOUT DD SYSOUT=*
//SORTIN DD DISP=SHR,
// DSN=fichero con la descarga de los man
//SORTOUT DD DISP=(NEW,CATLG,DELETE),
// SPACE=(CYL,(5,5)),
// DSN=fichero de salida
//SYSIN DD *
OPTION COPY
INCLUDE COND=(6,1,BI,EQ,X'66')
/*
//* 66 is the record type in hex (102 in this case)

regards
ivan

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Missy Case

Re: Offloading SMF accounting records
(in response to Ivan Losada)
Lumila,
Because of the large amount of SMF data we have, we use the smfstrip that
only takes the DB2 records off. It can also be used to be a bit more
specific in the date & or time ranges.

//EXTRACTD EXEC PGM=IFASMFDP,REGION=7192K
//SYSPRINT DD SYSOUT=*
//IN DD DSN=FDR.CSE933A.DB2SMF(0),
// DISP=SHR
//OUT1 DD DSN=TS.DBJN.SMF.SYSA4322,DISP=(NEW,CATLG,DELETE),
// UNIT=TAP38,VOL=(PRIVATE,RETAIN,,30),LABEL=(1,SL,RETPD=30),
// DCB=(RECFM=VBS,LRECL=32756,BLKSIZE=32760)
//*
//SYSIN DD *
INDD(IN,OPTIONS(DUMP))
OUTDD(OUT1,TYPE(100,101,102))
DATE(2004322,2004322)
SID(SYSA)
START(0700)
END(1600)
//*
//*

Missy Case
FDR
701-275-6358




Ludmila Koganer
<ludmilakoganer@Y To: [login to unmask email]
AHOO.COM> cc:
Sent by: DB2 Data bcc:
Base Discussion Subject: [DB2-L] Offloading SMF accounting records
List
<[login to unmask email]
ORG>


12/28/2004 11:34
PM
Please respond to
DB2 Database
Discussion list
at IDUG






Hello,
We are a small shop and just migrating some of our apps to DB2. I am the
DB2 systems girl here, and I am also on the learning curve.
We have been told to keep 5 days worth of DB2 accounting records of SMF
type 100 and 101.

I am encountering issues in filtering the db2 100 and 101 records from our
smf daily dataset.
I have raw smf dataset (offloaded from Man(n)datasets) and I am just
writing a SORT to squeeze SMF type 100 or 101 records, but in futile.

Can anyone please send me a sample JCL that wd show me how to do it?. It
wd be helpful.
We are on DB2 V8 compat mode.

Ludmil

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

Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home
page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select
"Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org
. The IDUG List Admins can be reached at [login to unmask email]
Find out the latest on IDUG conferences at
http://conferences.idug.org/index.cfm

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Ludmila Koganer

Re: Offloading SMF accounting records
(in response to Missy Case)
Hi Missy and others,
Thanks for the reply.
I am infact using the IFASMFDP. We have 3 subsystems in one LPAR. The dump
program offloads all records based on the MVS SYSID. I am able to filter
all Type 100 and 101 records (I didnt have 102 but now I have added.) The
frustrating issue is in squeezing the records per each subsystem. I am
trying to use a DFSORT step just after the SMFDP step. The input to this
SORT step is the o/p produced from IFASMFDP.
I am sorting on the following fields, 8 character SysID, SMF record type,
Date, Time,.
I have an include statement as given below.
INCLUDE COND=(6,1,BI,EQ,X'65',AND,15,4,CH,EQ,C'DB2T')
I want to squeeze all 101 types, belonging to subsystem DB2T. It does not
produce any results. However if I omit the subsystem part in the INCLUDE
(AND,15,4,CH,EQ,C'DB2T') it produces the o/p. This o/p contains all
subsystem 101 records which I dont want.
I read the DFSORT manuals plus the link sent in one of the threads but I
couldnt find what is wrong in here.
Can I send you the JCL and o/p offline, if you could review and what is
wrong, It would be helpful for us.


Any ideas?.
thanks,
Ludmil.

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Venkat Srinivasan

Re: Offloading SMF accounting records
(in response to Ludmila Koganer)
Ludmila,
Shouldnt you be sorting on offset 18 which is position 19 for SORT, which
is where ssid is stored?.
At position 15 you won't find the db2 ssid. That is why sort is not
returning any o/p due to the include records condition.
That should solve your issue....?
Make sure that your o/p dataset is vbs and has the same lrecl as the o/p
of ifasmfdp.

Regards,
Venkat

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Henry Boone

Re: Offloading SMF accounting records
(in response to Venkat Srinivasan)
The following are the SORT SYSIN control statements (with comments) I use
when processing SMF data:

INCLUDE COND((0015,004,CH, SMF_SID
EQ,
C'ASYS'), ASYS
AND,
(0019,004,CH, SMF_DB2ID
EQ,
C'DB2P'), DB2P
AND,
(0006,001,CH, SMF_TYPE
EQ,
X'64', 100
OR,
0006,001,CH, SMF_TYPE
EQ,
X'65', 101
OR,
0006,001,CH, SMF_TYPE
EQ,
X'66')) 102


HTH.

/"""""/
!_ _!
(o) (o)
oOOO==(_)==OOOo====================*
* *
* Henry Boone *
* DB2 Systems Programmer *
* SOD/ESMD *
* *
* GEICO Insurance Companies Phone: (301) 718-5334 *
* 4608 Willard Avenue Fax: (301) 986-2408 *
* Chevy Chase, MD 20815 E-Mail: [login to unmask email] *
* *
* .oooO *
*==( )==Oooo.====================*
\ ( ( )
\_) ) /
(_/


-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf
Of Ludmila Koganer
Sent: Wednesday, December 29, 2004 8:03 PM
To: [login to unmask email]
Subject: Re: [DB2-L] Offloading SMF accounting records

Hi Missy and others,
Thanks for the reply.
I am infact using the IFASMFDP. We have 3 subsystems in one LPAR. The dump
program offloads all records based on the MVS SYSID. I am able to filter
all Type 100 and 101 records (I didnt have 102 but now I have added.) The
frustrating issue is in squeezing the records per each subsystem. I am
trying to use a DFSORT step just after the SMFDP step. The input to this
SORT step is the o/p produced from IFASMFDP.
I am sorting on the following fields, 8 character SysID, SMF record type,
Date, Time,.
I have an include statement as given below.
INCLUDE COND=(6,1,BI,EQ,X'65',AND,15,4,CH,EQ,C'DB2T')
I want to squeeze all 101 types, belonging to subsystem DB2T. It does not
produce any results. However if I omit the subsystem part in the INCLUDE
(AND,15,4,CH,EQ,C'DB2T') it produces the o/p. This o/p contains all
subsystem 101 records which I dont want.
I read the DFSORT manuals plus the link sent in one of the threads but I
couldnt find what is wrong in here.
Can I send you the JCL and o/p offline, if you could review and what is
wrong, It would be helpful for us.


Any ideas?.
thanks,
Ludmil.

----------------------------------------------------------------------------
-----
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home
page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select
"Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org.
The IDUG List Admins can be reached at [login to unmask email] Find
out the latest on IDUG conferences at http://conferences.idug.org/index.cfm
====================
This email/fax message is for the sole use of the intended recipient(s) and
may contain confidential and privileged information. Any unauthorized
review, use, disclosure or distribution of this email/fax is prohibited. If
you are not the intended recipient, please destroy all paper and electronic
copies of the original message.

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm