Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
looking for SMF type 100, 101 102 record layout for DB2 info

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
Gary Lin
Warnings : 1

New User


Joined: 08 Mar 2009
Posts: 15
Location: Taipei, Taiwan

PostPosted: Sat Apr 04, 2009 7:45 pm    Post subject: looking for SMF type 100, 101 102 record layout for DB2 info
Reply with quote

I cound not find any IBM DB2 manual that illustrate the SMF type 100, 101, and 102 record layout which should includes the HEADER, PRODUCR, and DATA, offset, field length, and data type. highly appreciate those who can guide me to get those info.
Back to top
View user's profile Send private message

dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6968
Location: porcelain throne

PostPosted: Sat Apr 04, 2009 9:18 pm    Post subject:
Reply with quote

it maybe that these record types are db2 oriented, but the file is SMF.

so look in SMF documentation or search.

I remember a post a while back that gave the document name/number for individual SMF layouts.

or if you are lucky CICS_GUY or expat will give you your answer.
Back to top
View user's profile Send private message
CICS Guy

Senior Member


Joined: 18 Jul 2007
Posts: 2150
Location: At my coffee table

PostPosted: Sat Apr 04, 2009 9:50 pm    Post subject:
Reply with quote

z/OS V1R10.0 MVS System Management Facilities (SMF)
Back to top
View user's profile Send private message
Gary Lin
Warnings : 1

New User


Joined: 08 Mar 2009
Posts: 15
Location: Taipei, Taiwan

PostPosted: Sun Apr 05, 2009 4:52 pm    Post subject:
Reply with quote

this SMF z/OS MVS system management facilities depicts the type 100, 101, and 102 are in DB2 Administration guide. But there is nothing about the type 100, 101, and 102 record layout within DB2 administration Guide.
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10308
Location: italy

PostPosted: Sun Apr 05, 2009 6:29 pm    Post subject: Reply to: looking for SMF type 100, 101 102 record layout fo
Reply with quote

a bit of curiosity and ingenuity would have helped....

sys1.maclib maclib contains the IFASMFR* stuff ( the mapping macros for zOS smf stuff)

the equvalent maclib for db2 would be ..
<some_db2_prefix>.SDSNMACS
with the powerful tools made available trhu ISPf run a SRCHFOR
using as a search argument "SMF COMMON HEADER"
e voila' les jeux sont faits
You will find the mappig macros for the relevant db2 smf records
are mapped by...
DSNDQWAS,DSNDQWSP,DSNDQWST

follow the same approach for cics

run an assembly step and You will have the layout documented
Back to top
View user's profile Send private message
Gary Lin
Warnings : 1

New User


Joined: 08 Mar 2009
Posts: 15
Location: Taipei, Taiwan

PostPosted: Mon Apr 06, 2009 3:34 pm    Post subject:
Reply with quote

I did find those members: DSNDQWAS,DSNDQWSP,DSNDQWST liks as you have mentioned, but I still don't know what to do to get those type 100, 101, and 102 record layout, would you please be more specific on what/how to do. thanks,
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Mon Apr 06, 2009 8:16 pm    Post subject:
Reply with quote

Hello,

Quote:
run an assembly step and You will have the layout documented
Did you do this in addition to finding the members?

If not, do so now and post anything that causes errors or is not more clear.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Setting Font Type for XMIT satish.ms10 All Other Mainframe Topics 3 Fri Sep 15, 2017 10:01 pm
No new posts Updating the Trailer count in variabl... satheshbabur DFSORT/ICETOOL 6 Wed Aug 30, 2017 9:49 pm
No new posts Repeat part of record multiple times Learncoholic DFSORT/ICETOOL 4 Tue Aug 29, 2017 11:33 am
No new posts Read two inputs and write into output... murali.andaluri DFSORT/ICETOOL 6 Wed Jul 26, 2017 7:35 pm
No new posts Loading data to table gives wrong for... Raghu navaikulam DB2 19 Thu Jul 13, 2017 2:11 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us