IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Dataset member detail extraction


IBM Mainframe Forums -> TSO/ISPF
Post new topic   Reply to topic
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
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

Superior Member


Joined: 14 Mar 2007
Posts: 10886
Location: italy

PostPosted: Mon May 03, 2010 1:59 pm
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
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
Reply with quote

This to be more precise...

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
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

Senior Member


Joined: 07 Feb 2009
Posts: 1314
Location: Vilnius, Lithuania

PostPosted: Mon May 03, 2010 5:30 pm
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
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: 691
Location: Earth

PostPosted: Tue May 04, 2010 2:17 am
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
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

Superior Member


Joined: 14 Mar 2007
Posts: 10886
Location: italy

PostPosted: Tue May 04, 2010 10:57 am
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

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
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
Reply with quote

This might assist you
www.ibmmainframes.com/viewtopic.php?t=44001&highlight=member+creation+date
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
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
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

Global Moderator


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

PostPosted: Tue May 04, 2010 4:44 pm
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> TSO/ISPF

 


Similar Topics
Topic Forum Replies
No new posts SORT on detail record, then repeat he... DFSORT/ICETOOL 3
No new posts batch SFTP job using AOPBATCH unable ... All Other Mainframe Topics 7
No new posts Reading Empty Dataset DFSORT/ICETOOL 5
No new posts Mainframe Dataset Binary or ASCII Mainframe Interview Questions 4
No new posts SPOOL to Mainframe dataset in batch mode JCL & VSAM 7
Search our Forums:

Back to Top