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
 
Batch SPUFI JCL Problem

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

New User


Joined: 03 Jun 2008
Posts: 3
Location: Inida

PostPosted: Fri Jun 13, 2008 3:35 pm    Post subject: Batch SPUFI JCL Problem
Reply with quote

Hi,
I have a JCL for extracting records from DB2 table. Below the JCL for your reference
//STEP02 EXEC PGM=IKJEFT01,DYNAMNBR=20
//STEPLIB DD DSN=DB2T.SDSNEXIT,DISP=SHR
// DD DSN=DB2T.SDSNLOAD,DISP=SHR
//SYSREC00 DD DSN=AB54814.SPUFI.OUTPUT,DISP=OLD
//SYSPUNCH DD DUMMY
//SYSTSPRT DD SYSOUT=*
//SYSPRINT DD SYSOUT=*
//SYSUDUMP DD SYSOUT=*
//SYSTSIN DD *
DSN SYSTEM(DB2T)
RUN PROGRAM(DSNTIAUL) PLAN(DSNTIAUL) -
LIB('DB2T.RUNLIB.LOAD')
END
/*
//SYSIN DD *
SELECT * FROM MPR.DESC
/*
//*

I got the following error while i submit the Job. Return Code 12.
ACF0C038 ACF2 LOGONID ATTRIBUTES HAVE REPLACED DEFAULT USER ATTRIBUTES
READY
DSN SYSTEM(DB2T)
DB2T NOT VALID SUBSYSTEM ID, COMMAND TERMINATED
READY
RUN PROGRAM(DSNTIAUL) PLAN(DSNTIAUL) LIB('DB2T.RUNLIB.LOAD')
INVALID KEYWORD, PLAN(DSNTIAUL)
READY
END
READY
END

I believe, DB2T is a valid subsytem ID. I don't know how to verify.

Please help me to solve this issue.

Thanks,
Regards,
Raja
Defeat is not when you fall down, It's when you refuse to get up!!!!!
Back to top
View user's profile Send private message

enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10327
Location: italy

PostPosted: Fri Jun 13, 2008 3:52 pm    Post subject: Reply to: Batch SPUFI JCL Problem
Reply with quote

Quote:
I believe, DB2T is a valid subsytem ID.

You believe.. or your docs say so?
Quote:
I don't know how to verify.

we don t either


http://catb.org/~esr/faqs/smart-questions.html
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


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

PostPosted: Fri Jun 13, 2008 4:08 pm    Post subject:
Reply with quote

before you are into spufi and/or qmf, there is normally a sys-id input area.

Try DB2T in spufi..................
Back to top
View user's profile Send private message
shanmudhaya

New User


Joined: 03 Jun 2008
Posts: 3
Location: Inida

PostPosted: Fri Jun 13, 2008 4:13 pm    Post subject: Reply to: Batch SPUFI JCL Problem
Reply with quote

Thanks for your information Dick..

Thanks,
Regards,
Raja
Defeat is not when you fall down, It's when you refuse to get up!!!!!
Back to top
View user's profile Send private message
birdy K

New User


Joined: 05 Mar 2008
Posts: 72
Location: chennai

PostPosted: Fri Jun 13, 2008 4:17 pm    Post subject:
Reply with quote

If you have File-aid for DB2. There is option to specify Db2 subsystem. Specify there and check. Sorry If you have dont have file-aid for db2 (D2X)
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10327
Location: italy

PostPosted: Fri Jun 13, 2008 4:21 pm    Post subject: Reply to: Batch SPUFI JCL Problem
Reply with quote

just being picky icon_biggrin.gif

using a different tool to enter the db2 subsytem id will not, I believe. solve the TS issue,
what if he gets again something like DB2T NOT VALID SUBSYSTEM ID

the best thing we can do is to teach people when and how to use their organization resources
and this is just the case
Back to top
View user's profile Send private message
am_ne

New User


Joined: 24 Mar 2007
Posts: 25
Location: Bangalore

PostPosted: Fri Jun 13, 2008 4:36 pm    Post subject:
Reply with quote

[I believe, DB2T is a valid subsytem ID. I don't know how to verify.]

If DB2T is a valid DB2 subsystem, then you can see the DB2TMSTR,DB2TDBM1, DB2TDIST etc.. jobs in spool.
If they are active then you can assume the sussystem is active.

You just have to check for DB2T* jobs in spool.

Thanks
Amit[/quote]
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10327
Location: italy

PostPosted: Fri Jun 13, 2008 4:38 pm    Post subject: Reply to: Batch SPUFI JCL Problem
Reply with quote

Quote:
...then you can see the DB2TMSTR,DB2TDBM1, DB2TDIST etc.. jobs in spool. ...


it depends on sdsf customization...
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 Accessing CICS tran with map from JCL... navdeepaggarwal CICS 5 Tue Oct 03, 2017 6:15 pm
No new posts LMINIT problem - not finding DDNAME Danielle.Filteau CLIST & REXX 7 Tue Sep 19, 2017 9:57 pm
No new posts Generate public-private key in batch ... vasanthz All Other Mainframe Topics 3 Fri Sep 15, 2017 9:20 am
No new posts Working with hex values in Filemanage... Emile Straker IBM Tools 0 Tue Sep 12, 2017 1:42 am
No new posts Unable to copy data from spool in a d... srikant314 JCL & VSAM 8 Fri Jul 28, 2017 9:10 pm

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