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
 

 

Fetching report from HSM

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
MFSubbu

New User


Joined: 16 Feb 2008
Posts: 19
Location: Bangalore

PostPosted: Thu Mar 11, 2010 2:24 pm    Post subject: Fetching report from HSM
Reply with quote

Hi,

First of all, I am not sure under which topic this should be posted. Kindly divert this to the right forum.

My requirement: To find HSM dataset that have been archived for more than one year.

I am new to HSM, I am trying to find out various commands to get the report from HSM like DCOLLECT, TTOC etc. I even dont know I am trying the right commands.

While Trying LIST TTOC command when i issued the command directly, the below is the output i got from the syslog, but the output file is empty.

F HSM, LIST TTOC ODS(DCOLLECT.OUT5)
ARC0140I LIST COMPLETED, 23 LINE(S) OF DATA 284
ARC0140I (CONT.) OUTPUT

When i issue the same through JCL i get the following

READY
HSENDCMD LIST TTOC
ARC1007I COMMAND REQUEST 00102238 SENT TO DFSMSHSM
READY
END

Below is my JCL.

//HLIST JOB (MI05),'HSM REPORT',TIME=1440,
// MSGLEVEL=(1,1),MSGCLASS=Q,CLASS=A,NOTIFY=STHIAGA
//STEP1 EXEC PGM=IKJEFT01,REGION=512K
//SYSPRINT DD SYSOUT=*
//SYSTSPRT DD SYSOUT=*
//OUTDS DD DSN=STHIAGA.DCOLLECT.OUT5,DISP=SHR
//SYSTSIN DD *
HSENDCMD LIST TTOC
/*

Here agian my output file is empty
Back to top
View user's profile Send private message

expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8593
Location: Back in jolly old England

PostPosted: Thu Mar 11, 2010 2:28 pm    Post subject:
Reply with quote

The date and time of dataset migration are contained in the DCOLLECT M records.

Click HERE to see the relevant manual section.
Back to top
View user's profile Send private message
MFSubbu

New User


Joined: 16 Feb 2008
Posts: 19
Location: Bangalore

PostPosted: Thu Mar 11, 2010 2:41 pm    Post subject:
Reply with quote

Expat,

I am not aware of what command should be used. I tried with SMSDATE SCDS().. where the output didnt list the dataset name.

I also tried with MIGRATEDATA

Belwo is the error

IDC21804I FAILURE DURING MIGRATION DATA COLLECTION SERVICE PROCESSING -
IDC21804I RETURN CODE WAS X'08' REASON CODE WAS X'00000001

JCL used is

//DCOLLECT JOB (MI05),'ACCOUNT CREATION',TIME=1440,
// MSGLEVEL=(1,1),MSGCLASS=Q,CLASS=A,NOTIFY=STHIAG
//STEP1 EXEC PGM=IDCAMS
//SYSPRINT DD SYSOUT=*
//OUTDS DD DSN=STHIAGA.DCOLLECT.OUT4,DISP=SHR
//* DSORG=PS,
//* DCB=(RECFM=VB,LRECL=32756,BLKSIZE=0),
//* SPACE=(1,(100,100)),AVGREC=K,
//* DISP=(NEW,CATLG,KEEP)
//SYSIN DD *
DCOLLECT -
OFILE(OUTDS) -
MIGRATEDATA
/*
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8593
Location: Back in jolly old England

PostPosted: Thu Mar 11, 2010 2:49 pm    Post subject:
Reply with quote

You will need to read the manual to find out the requirements of specifying MIGRATEDATA.

I can see from your JCL what is wrong.
Back to top
View user's profile Send private message
PeterHolland

Global Moderator


Joined: 27 Oct 2009
Posts: 2433
Location: Netherlands, Amstelveen

PostPosted: Thu Mar 11, 2010 2:50 pm    Post subject:
Reply with quote

MCDS is missing.

MIGRATEDATA requires collection of information on migrated data sets from the specified MCDS (Migration Control Data Set). The desired MCDS must be allocated to the ddname MCDS.
Back to top
View user's profile Send private message
MFSubbu

New User


Joined: 16 Feb 2008
Posts: 19
Location: Bangalore

PostPosted: Fri Mar 12, 2010 9:20 am    Post subject:
Reply with quote

After specifying the MCDS name.. i am able to get the output... but the expiration date for all the datasets are 00000, but my requirement is to find out the datasets which are expired for more than one year.
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8593
Location: Back in jolly old England

PostPosted: Fri Mar 12, 2010 12:17 pm    Post subject:
Reply with quote

If the dataset has expired it would not be held by HSM, so the dataset has not expired.

In your original post you asked for the archive date - which I assume you to mean as migration date - Another example of terminology misuse icon_evil.gif

So if you were kind enough to say exactly what you want then maybe we could help you more.
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 -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Splitting of single report to seperat... abdulrafi TSO/ISPF 7 Mon Mar 27, 2017 3:59 pm
No new posts Easytrieve report shalem CA Products 4 Sun Feb 26, 2017 9:08 am
No new posts Detailed Transaction History report f... Kyle Carroll CICS 5 Tue Oct 18, 2016 12:42 am
No new posts Easytrieve - Report writing - Only 1 ... Abhi Nature CA Products 2 Wed Sep 14, 2016 11:40 am
No new posts Can we use OPTIMIZE FOR 1 ROWS for fe... cvijay784 DB2 1 Fri Aug 05, 2016 11:56 am


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