MVSFORUMS.com

satyenderd · Beginner Joined: 26 Aug 2005 Posts: 144 Topics: 73

Hi all,

Herein I have to take the info about the command
-DISPLAY DB(DBLCSP1) SPACENAM(*)USE

OR
-DISPLAY DB(DBLCSP1) USE

to find out which user is accessing which table in this database.
I wrote a jcl which is accepting -DISPLAY THREAD(*)
but not this command.

-DISPLAY DB(DBLCSP1) SPACENAM(*)USE

This is the JCl i am using:

//STEP1 EXEC PGM=IKJEFT01
//STEPLIB DD DISP=SHR,DSN=DB2TN.SHR.DSNLOAD
//*SYSEXEC DD DISP=SHR,DSN=PKG.BMC.V2040.EXEC
//ABNLIGNR DD DUMMY
//SYSTERM DD SYSOUT=*
//SYSPRINT DD SYSOUT=*
//SYSTSPRT DD DSN=T0J0AJ7.PDB2.COMMAND.OUTPUT,
// DISP=(NEW,CATLG,CATLG),
// UNIT=SYSDA,
// SPACE=(TRK,(1,1),RLSE),
// DCB=(RECFM=FB,LRECL=133)
//SYSTSIN DD *
DSN SYSTEM(PDB2)
-DISPLAY DB(DBLCSP1) USE
/*

Please let me, cant i use this command like this.
Please correct me.

Thanks in advance.
_________________
Satya

CraigG · Posted: Fri Aug 01, 2008 8:04 pm Post subject:

What error are you getting?

satyenderd · Beginner Joined: 26 Aug 2005 Posts: 144 Topics: 73

The error (MAXCC=12) is SYSTSIN not found and it is not writing in to the dataset
_________________
Satya

CraigG · Posted: Sat Aug 02, 2008 6:14 am Post subject:

Please post your jcl and the messages.

CraigG · Posted: Sun Aug 03, 2008 2:35 pm Post subject:

satyenderd · Beginner Joined: 26 Aug 2005 Posts: 144 Topics: 73

Hi Craig,

Herein are the error messges:Now its not showing SYSTSIN not found but different error.

ERROR MESSAGES:

ICH70001I T0J0AJ7 LAST ACCESS AT 17:35:01 ON FRIDAY, AUGUST 1, 2008
IEF236I ALLOC. FOR T0J0AJ7C STEP1
IEF237I 781A ALLOCATED TO STEPLIB
IEF237I DMY ALLOCATED TO ABNLIGNR
IEF237I JES2 ALLOCATED TO SYSTERM
IEF237I JES2 ALLOCATED TO SYSPRINT
IGD101I SMS ALLOCATED TO DDNAME (SYSTSPRT)
DSN (T0J0AJ7.PDB2.COMMAND.OUTPUT )
STORCLAS (TEST) MGMTCLAS (TSO) DATACLAS (DEFAULT)
VOL SER NOS= SMT001
IEF237I JES2 ALLOCATED TO SYSTSIN
IEF142I T0J0AJ7C STEP1 - STEP WAS EXECUTED - COND CODE 0012
IEF285I DB2TN.SHR.DSNLOAD KEPT
IEF285I VOL SER NOS= RACFA2.
IEF285I T0J0AJ7.T0J0AJ7C.JOB14965.D0000102.? SYSOUT
IEF285I T0J0AJ7.T0J0AJ7C.JOB14965.D0000103.? SYSOUT
IGD104I T0J0AJ7.PDB2.COMMAND.OUTPUT RETAINED, DDNAME=SYSTSPRT
IEF285I T0J0AJ7.T0J0AJ7C.JOB14965.D0000101.? SYSIN
_________________
Satya

satyenderd · Beginner Joined: 26 Aug 2005 Posts: 144 Topics: 73

Craig, one more update.

I am getting the result in the output dataset, but why the error is still MAXCC=12, I am unable to understand. Ofcourse, this solves my problem but concerned about the error.

Thanks for your quick response.
Good Day.
_________________
Satya

CraigG · Posted: Mon Aug 04, 2008 11:44 am Post subject:

There should have been another message that would have explained why you are getting the return code of 12.

satyenderd · Beginner Joined: 26 Aug 2005 Posts: 144 Topics: 73

Craig, one more update.

I am getting the result in the output dataset, but why the error is still MAXCC=12, I am unable to understand. Ofcourse, this solves my problem but concerned about the error.

Thanks for your quick response.
Good Day.
_________________
Satya

jsharon1248 · Posted: Mon Aug 04, 2008 11:55 am Post subject:

You showed us allocation messages. The error messages are probably in your SYSTSPRT dataset, or, in the JESLOG messages.

Terry_Heinze · Posted: Mon Aug 04, 2008 10:56 pm Post subject:

Please use BBCode to make posts of JCL or data more readable.
_________________
....Terry