Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups 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: 10274
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 Loading data to table gives wrong for... Raghu navaikulam DB2 18 Thu Jul 13, 2017 2:11 pm
No new posts Need info on EIBCPOSN value in IBM FA... subratarec CICS 11 Wed Jul 12, 2017 3:45 pm
No new posts Need to write record of PS File in ex... Chandan1993 JCL & VSAM 1 Wed Jun 07, 2017 1:35 am
No new posts Adding big TEXT lines to each record ... bshkris SYNCSORT 4 Sat May 06, 2017 1:40 am
This topic is locked: you cannot edit posts or make replies. Merge two files and update Trailer re... Yashashri JCL & VSAM 1 Thu May 04, 2017 12:54 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us