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
 
How to change retention Period of SPUFI output

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
trilokdewangan

New User


Joined: 19 Jun 2008
Posts: 39
Location: USA

PostPosted: Fri Nov 07, 2008 5:09 pm    Post subject: How to change retention Period of SPUFI output
Reply with quote

Hi,

When we run a spufi, it creates dataset with permanent retention period. Is there any way to alter the RETPD before or during the execution of SPUFI?
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 Nov 07, 2008 5:33 pm    Post subject:
Reply with quote

Talk to your storage people, it is they that set dataset retention periods.
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Sat Nov 08, 2008 3:06 am    Post subject: Re: How to change retention Period of SPUFI output
Reply with quote

Hi,
trilokdewangan wrote:
Is there any way to alter the RETPD before or during the execution of SPUFI?
This seems to be a local jargon of Management class at your shop instead of SPUFI's characteistics. Ran a query at my shop in SPUFI & allocated a file with Management class . . : TPS035, which means data will reside for 35 days. So I would echo Expat.

For the time being

1. You can copy the output-of-SPUFI to other DSN with the management class of your choice &
2. Delete the output from SPUFI.
3. Rename it back to the one which come out from SPUFI if you want to have the same DSN (But what's ther in a name.. icon_smile.gif ).
Back to top
View user's profile Send private message
trilokdewangan

New User


Joined: 19 Jun 2008
Posts: 39
Location: USA

PostPosted: Mon Nov 10, 2008 3:13 pm    Post subject:
Reply with quote

Hi Anuj,

Yes MSGCLAS=TPS035 should work, but I am confused, how we can define MSGCLASS in SPUFI output dataset. We don't have option to define MSGCLAS for SPUFI output, please see the screen below.

Code:
                           CURRENT SPUFI DEFAULTS             SSID: DBB4       
===>                                                                           
                                                                               
Enter the following to control your SPUFI session:                             
 1  SQL TERMINATOR .. ===> ;          (SQL Statement Terminator)               
 2  ISOLATION LEVEL   ===> CS         (RR=Repeatable Read, CS=Cursor Stability)
 3  MAX SELECT LINES  ===> 999999     (Maximum number of lines to be           
                                         returned from a SELECT)               
 4  ALLOW SQL WARNINGS===> NO         (Continue fetching after sqlwarning)     
 5  CHANGE PLAN NAMES ===> NO         (Change the plan names used by SPUFI)   
                                                                               
Output data set characteristics:                                               
 6  RECORD LENGTH ... ===> 4000       (LRECL=Logical record length)           
 7  BLOCK SIZE ...... ===> 8000       (Size of one block)                     
 8  RECORD FORMAT ... ===> FB         (RECFM=F, FB, FBA, V, VB, or VBA)       
 9  DEVICE TYPE ..... ===> dasd       (Must be DASD unit name)                 
                                                                               
Output format characteristics:                                                 
10  MAX NUMERIC FIELD ===> 33         (Maximum width for numeric fields)       
11  MAX CHAR FIELD .. ===> 80         (Maximum width for character fields)     
12  COLUMN HEADING .. ===> NAMES      (NAMES, LABELS, ANY or BOTH)             
                                                                               
 F1=HELP      F2=SPLIT     F3=END       F4=RETURN    F5=RFIND     F6=RCHANGE   
 F7=UP        F8=DOWN      F9=SWAP     F10=LEFT     F11=RIGHT    F12=RETRIEVE 


Please suggest..!
Back to top
View user's profile Send private message
Suresh Ponnusamy

Active User


Joined: 22 Feb 2008
Posts: 107
Location: New York

PostPosted: Mon Nov 10, 2008 8:11 pm    Post subject:
Reply with quote

Hi

You can create a PS file with the MSGCLASS as you mentioned and give that PS file in the SPUFI Output. It should work
Back to top
View user's profile Send private message
trilokdewangan

New User


Joined: 19 Jun 2008
Posts: 39
Location: USA

PostPosted: Tue Nov 11, 2008 2:13 pm    Post subject:
Reply with quote

Hi,

If we need to create PS dataset separately, we can give the RETPD that time....icon_smile.gif
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Tue Nov 11, 2008 11:52 pm    Post subject:
Reply with quote

Hi,
trilokdewangan wrote:
I am confused, how we can define MSGCLASS in SPUFI output dataset. We don't have option to define MSGCLAS for SPUFI output
Just before the panel you've shown there is a panel where you need to provide the DSN name in which you want to capture the output of query(ies) of intrest, at my shop this option is option 4 in SPUFI, while allocating the DSN then to select the Management class of that DSN is your hand.

Code:
4  DATA SET NAME ... ===> 'XXXXX.QUERY.FILE.OUT'
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Tue Nov 11, 2008 11:52 pm    Post subject:
Reply with quote

trilokdewangan wrote:
If we need to create PS dataset separately, we can give the RETPD that time....icon_smile.gif
Are you saying or asking something, 'am not sure - please clarify.
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: Wed Nov 12, 2008 5:25 am    Post subject:
Reply with quote

Hi Anuj,

Quote:
Are you saying or asking something
Saying, i believe. . .

When we create PS datasets, we can specify the RETPD.
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Wed Nov 12, 2008 7:37 am    Post subject:
Reply with quote

Hi Dick,

If so, I hope he is good to go then..

-Ad
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 Subtract the ZD fields to provide neg... Balaryan DFSORT/ICETOOL 4 Wed Oct 11, 2017 10:51 pm
No new posts Partial color change of a field in CI... waseem0424 CICS 5 Fri Sep 29, 2017 7:56 pm
No new posts Where is output from PARM ABEXIT (SNA... packerm CA Products 3 Thu Sep 28, 2017 4:06 pm
No new posts Garbage on output file Hervey Martinez SYNCSORT 4 Wed Sep 27, 2017 12:50 am
No new posts it is possible output a SET value fro... Martylin JCL & VSAM 5 Fri Sep 22, 2017 7:08 am

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