Problem while running a rexx Db2 script thru JCL

mannepalli · New User Joined: 05 May 2008 Posts: 4 Location: Bangalore

Hello Every body,

I'm facing a problem. Please help me out ...

Problem: i have a rexx + db2 program . i can able to run/execute this program using tso exec command.

But when i'm running the same program thru JCL its giving me Db2 substem not found sqlcode = - 924

I'm thinking that ... while running in tso background its system default libraries is different and while running thru JCl system default libraries is different.

If my assumption is correct what is the order for system libraries Tso and JCL.

If my assumption is wrong Please give correct solution ..

Thanks alot .. .

expat · Posted: Sat Jan 30, 2010 3:05 pm Post subject:

Unfortunately psychic days are not permitted on weekends.

Without seeing the JCL that you try to execute, and the associated output, we know nothing, so can not possibly help you.

However, something to ponder. Does the program that you attempt to execute live in one of the ISPLLIB concatenations.

dick scherrer · Posted: Sat Jan 30, 2010 9:37 pm Post subject:

Hello and welcome to the forum,

Suggest you talk with your dba for the specifics for your system.

Or simply look at some other process that is working and clone this.

mannepalli · New User Joined: 05 May 2008 Posts: 4 Location: Bangalore

Hi .. Let me explain bit clear ,.

If i give Tso ex 'U639038.EXEC.REXX(DB2REXX)' ex
in ISPF pannel .. its running my Program and giving correct results and

When i'm executing the same program thru jcl i'm facing the problem.
Below i'm giving the JCL.

//STEP4 EXEC PGM=IKJEFT01,PARM='%DB2REXX'
//SYSEXEC DD DSN=U639038.EXEC.REXX,DISP=SHR
//SYSTSPRT DD SYSOUT=*
//SYSPRINT DD SYSOUT=*
//SYSTSIN DD DUMMY

dick scherrer · Posted: Mon Feb 01, 2010 8:20 pm Post subject:

Hello,

What did the dba tell you?

Why have you not yet determined which subsystem is being used rather than the one you want?

All of the answers are on your system. We do not have access to your system. . .

Unfortunately, most of the work in getting help from the forum is on the requestor. . . We can only help with what you provide (as Expat mentioned, not every day is psychic day).

Do not let this discourage you - most of us had to learn how to ask for technical help

mannepalli · New User Joined: 05 May 2008 Posts: 4 Location: Bangalore

Heloo dick scherrer,

I dont think its DBA problem .. .

Because i'm able to access the same Substem by running the program in Tso background.

GuyC · Posted: Tue Feb 02, 2010 6:58 pm Post subject:

-924 Connection to DB2 has failed because of an unexpected internal error, identified by the 'reason-code'.

So what's the reason code ?

mannepalli · New User Joined: 05 May 2008 Posts: 4 Location: Bangalore

HI .. .

Sql CA after submitting the JCL.

SQLCA ::
SQLSTATE=58006
SQLWARN = , , , , , , , , , ,
Sqlerrd= 0,0,0,0,0,0'
SQLERRP =DSNTZALI
SQLERRMC =00000002 00000008 00F30002
SQLCODE =-924

My main doubt is, Same program is running perfectly
if i give Tso ex'dataset name'
why its erroring when i run the same program thru JCL .

Robert Sample · Posted: Tue Feb 02, 2010 7:50 pm Post subject:

GuyC · Posted: Tue Feb 02, 2010 8:09 pm Post subject:

00F30002
Explanation:
The requested DB2 subsystem, as specified by the subsystem name, is not active. The option to notify the requester, either via an ECB post or a
SEND/MODIFY MVS command, is accepted.

Srihari Gonugunta · Posted: Tue Feb 02, 2010 8:33 pm Post subject:

Srinivas,
One option based on my prev exp is to use proper CLASS parameter in which your DB2 subsystem is active. Use the job card from some existing jobs which are using DB2 and running fine.

dick scherrer · Posted: Tue Feb 02, 2010 9:57 pm Post subject:

Hello,