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
 

 

Dataset member detail extraction

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> TSO/ISPF
View previous topic :: :: View next topic  
Author Message
ayansau

New User


Joined: 22 Jun 2007
Posts: 42
Location: Chennai

PostPosted: Mon May 03, 2010 1:55 pm    Post subject: Dataset member detail extraction
Reply with quote

How can I extract detail information of all the members in a PDS?
Like date created, last modified, size, who modified etc..

This is about eache member NOT for the PDS which contains the members.
Back to top
View user's profile Send private message

enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10203
Location: italy

PostPosted: Mon May 03, 2010 1:59 pm    Post subject: Reply to: Dataset member detail extraction
Reply with quote

You can get that info only if the ISPF statistics are properly populated
see the ISPF manuals for the LM****** services at
http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/Shelves/ISPZPM61
Back to top
View user's profile Send private message
Escapa

Senior Member


Joined: 16 Feb 2007
Posts: 1399
Location: IL, USA

PostPosted: Mon May 03, 2010 2:34 pm    Post subject:
Reply with quote

This to be more precise...

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/ISPZSG40/2.29?DT=20050713030339


(Enrico, I agree with your intent of searching but I had it on one of the tabs.. recently used so pasting here) icon_smile.gif
Back to top
View user's profile Send private message
ayansau

New User


Joined: 22 Jun 2007
Posts: 42
Location: Chennai

PostPosted: Mon May 03, 2010 5:28 pm    Post subject:
Reply with quote

ISPEXEC LMDLIST LISTID(dslist-id)
[OPTION(LIST|FREE|SAVE|SAVEC)]
[DATASET(dataset-var)]
[STATS(YES|NO)]
[GROUP(group)]

in this what should be the LISTID?
Code:

/****************************** REXX *********************************/
DSNAME = 'XXXXXXX.SVCTOOL.EMSR.EXEC'                                   
ADDRESS ISPEXEC                                                         
"LMDLIST LISTID(??) STATS(YES) DATASET(DSNAME) OPTION(LIST)"         
Back to top
View user's profile Send private message
prino

Active Member


Joined: 07 Feb 2009
Posts: 984
Location: Oostende, Belgium

PostPosted: Mon May 03, 2010 5:30 pm    Post subject:
Reply with quote

You have very obviously not bothered to actually read the linked-to pages... If you had done so you would know what to use in the LISTID.
Back to top
View user's profile Send private message
Escapa

Senior Member


Joined: 16 Feb 2007
Posts: 1399
Location: IL, USA

PostPosted: Mon May 03, 2010 6:39 pm    Post subject:
Reply with quote

Code:

lvl="my.dataset.name"                                       
"ISPEXEC LMDINIT LISTID(TMPID) LEVEL("LVL")"                           
I=0                                                                     
Do Forever                                                             
"ISPEXEC LMDLIST LISTID("TMPID") OPTION(LIST) DATASET(DSVAR) STATS(YES)"
   If rc = 0 Then DO                                                   
   SAY ZDLCDATE                                                         
   END                                                                 
   Else Leave                                                           
End                                                                     
"ISPEXEC LMDLIST LISTID("TMPID") OPTION(FREE)"                         

here is one sample.. apart from this

If STATS(YES) is specified, the following variables are returned to the variable pool:
(Thanks to Superk. I kept it copied in my notepad from one of his post with link I mentioned above... )

ZDLVOL
Volume serial.

ZDLDEV
Device type.

ZDLDSORG
Data set organization.

ZDLRECFM
Record format.

ZDLLRECL
Logical record length.

ZDLBLKSZ
Block size.

ZDLSIZE
Data set size in tracks.

ZDLSIZEX
Data set size in tracks, long format (12 bytes).

ZDLUSED
Percentage of used tracks or pages (PDSE).

ZDLEXT
Number of extents used.

ZDLEXTX
Number of extents used, long format (5 bytes).

ZDLCDATE
Creation date.

ZDLEDATE
Expiration date.

ZDLRDATE
Date last referenced.

ZDLMIGR
Whether the data set is migrated (YES or NO) based on the value of the VOLUME_OF_MIGRATED_DATA_SETS keyword in the ISPF configuration table. If the volume name of the data set matches the value of VOLUME_OF_MIGRATED_DATA_SETS, ZDLMIGR is set to YES, otherwise it is set to NO.

ZDLDSNTP
Dsname type (PDS, LIBRARY, or ' ').

ZDLSPACU
Space units.

ZUDMVOL
Whether the data set is multivolume (Y) or not (N).
Back to top
View user's profile Send private message
agkshirsagar

Active Member


Joined: 27 Feb 2007
Posts: 685
Location: Earth

PostPosted: Tue May 04, 2010 2:17 am    Post subject:
Reply with quote

Sambhaji,
IMHO Being helpful is good thing but as the saying goes- Give a man a fish and you feed him for a day. Teach a man to fish and you feed him for a lifetime.

OP was given necessary information by Enrico(Teaching to Fish).
Then you pitched in (Gave him fish for the day). (No offense meant.)
Then OP came back asking another question. (Maybe he didn't bother to cook the free fish he got. )
Now you are trying to cook the fish for him as well. icon_smile.gif

(Next step- you will be required to chew the fish for him. icon_lol.gif )

Jokes apart, I think you are making valuable contributions on forum and I hope to see more of you in quality discussions happening around.
Back to top
View user's profile Send private message
ayansau

New User


Joined: 22 Jun 2007
Posts: 42
Location: Chennai

PostPosted: Tue May 04, 2010 10:42 am    Post subject:
Reply with quote

Thanks for the reply Sambhaji.
The code you mentioned is to extract PDS detail. LISTDSI also enough to extract those information.
I want extract member detail. Please see the screen attached.
Code:

VIEW              XXXXXXX.SVCTOOL.EMSR.EXEC                 Row 00001 of 00013
Command ===>                                                  Scroll ===> CSR 
           Name     Prompt       Size   Created          Changed          ID   
_________ EMAEXT                  118  2009/11/25  2010/01/29 03:28:51  USTXI21
_________ EMAEXTV2                122  2009/11/25  2010/01/29 03:28:58  USTXI21
_________ EMAIL                   324  2009/11/24  2010/01/06 02:44:48  ISDXU03
_________ EMFRQ                   246  2009/12/23  2010/04/29 00:26:48  USTXI21
_________ EMHSTMT                 373  2009/06/15  2010/01/29 03:25:14  USTXI21
_________ EMHSTMV2                389  2009/12/15  2010/02/17 10:37:18  ISDXR05
_________ EMSR                     72  2009/11/24  2010/04/29 05:19:37  USTXI21
_________ EMSRCH                 1183  2009/11/26  2010/01/28 04:48:10  USTXI21
_________ EMSRCHV2               1225  2009/12/16  2010/01/28 05:17:31  USTXI21
_________ EMSTMT                  638  2009/10/08  2010/01/29 03:31:06  USTXI21
_________ EMSTMTV2                707  2009/12/14  2010/03/30 01:33:07  ISDXU03
_________ EMSTMTV3                787  2009/12/18  2010/04/15 00:16:46  ISDXU03
_________ EMSTMT1                 666  2009/10/08  2009/12/10 06:09:42  ISDXU03

Please let me know is it possible to retrieve these information??
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10203
Location: italy

PostPosted: Tue May 04, 2010 10:57 am    Post subject: Reply to: Dataset member detail extraction
Reply with quote

Quote:
Please let me know is it possible to retrieve these information??

did You notice my previous answer!
it implies that it can be done, otherwise it would have been a waste of time and resources

the LM****** is the generic library management stuff

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/ISPZSG61/CCONTENTS?SHELF=ISPZPM61&DN=SC34-4819-07&DT=20071211174133

if You had cared to take a look at the index at least You would have noticed ...
that the LMDDISP AND LMDLIST relate to dataset display/list services
ant there are also the equivalent
LMMDISP and LMMLIST for the MEMBERS

see
http://ibmmainframes.com/viewtopic.php?t=25947&highlight=
for a working and tested sample

up to You to cannibalize it to satisfy Your needs by looking at the manuals
Back to top
View user's profile Send private message
Escapa

Senior Member


Joined: 16 Feb 2007
Posts: 1399
Location: IL, USA

PostPosted: Tue May 04, 2010 11:06 am    Post subject:
Reply with quote

This might assist you
http://www.ibmmainframes.com/viewtopic.php?t=44001&highlight=member+creation+date
http://www.ibmmainframes.com/viewtopic.php?t=23894&highlight=member+creation+date
Back to top
View user's profile Send private message
ayansau

New User


Joined: 22 Jun 2007
Posts: 42
Location: Chennai

PostPosted: Tue May 04, 2010 4:30 pm    Post subject: Reply to: Dataset member detail extraction
Reply with quote

Hi,

I got the solution from PDSMAN utility.

Thanks a lot for your help.
Ayan
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


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

PostPosted: Tue May 04, 2010 4:39 pm    Post subject:
Reply with quote

ayansau wrote:
I got the solution from PDSMAN utility.


which reveals the obvious:

3/4's of the questions on this board are based on the lack of familiarity
of the software available at one's own site.
Instead of looking around where they work,
asking their support groups,
asking their peers,
these topics are opened by people
who do not have the initiative to learn about their environment.
Back to top
View user's profile Send private message
superk

Moderator Team Head


Joined: 26 Apr 2004
Posts: 4648
Location: Raleigh, NC, USA

PostPosted: Tue May 04, 2010 4:44 pm    Post subject: Reply to: Dataset member detail extraction
Reply with quote

If the language you want to use is REXX, there is an alternative method to find this information posted here. I've used this code myself.
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 -> TSO/ISPF All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts What is the command to check MODE of ... rohanthengal CLIST & REXX 6 Fri Nov 18, 2016 1:48 pm
No new posts FTP - JCL failed while passing FTP co... Suneetha1612 JCL & VSAM 12 Wed Nov 16, 2016 7:33 pm
No new posts To trim spaces in a pipe delimited da... Nish84 COBOL Programming 16 Mon Oct 10, 2016 1:54 pm
No new posts Allocate dataset withour BLKSIZE Susanta CLIST & REXX 2 Thu Sep 22, 2016 11:51 am
No new posts dataset copy question - REPRO or some... atulxp TSO/ISPF 2 Wed Aug 03, 2016 10:56 pm


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