Batch SPUFI JCL Problem

shanmudhaya · New User Joined: 03 Jun 2008 Posts: 3 Location: Inida

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

enrico-sorichetti · Posted: Fri Jun 13, 2008 3:52 pm

dbzTHEdinosauer · Posted: Fri Jun 13, 2008 4:08 pm

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

Try DB2T in spufi..................

shanmudhaya · New User Joined: 03 Jun 2008 Posts: 3 Location: Inida

Thanks for your information Dick..

Thanks,
Regards,
Raja
Defeat is not when you fall down, It's when you refuse to get up!!!!!

birdy K · New User Joined: 05 Mar 2008 Posts: 72 Location: chennai

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)

enrico-sorichetti · Posted: Fri Jun 13, 2008 4:21 pm

just being picky

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

am_ne · New User Joined: 24 Mar 2007 Posts: 25 Location: Bangalore

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

enrico-sorichetti · Posted: Fri Jun 13, 2008 4:38 pm