OnDemand User Group
Support Forums => z/OS Server => Topic started by: mvega on September 14, 2017, 04:29:51 PM
-
good afternoon,
I'm running this jcl and it ends with rc 00, but it does not do anything, it does not create the table, and it does not execute any type of analysis, I would appreciate help as soon as possible, since it is very urgent to me.
Thank you
this is the jcl
//* ---------------------------------------------------------- 00270000
//* AUDITAR BBDD ONDEMAND 00280000
//* ---------------------------------------------------------- 00290000
//CREATE EXEC PGM=BPXBATCH,REGION=0M
//STDPARM DD *
SH
export DSNAOINI=/hsbc/ARScodeD/V9R5M0/config/cli.ini;
export STEPLIB=SYS3.DB2.LTA0.SDSNLOD2:SYS3.DB2.LTA0.SDSNLOAD;
/hsbc/ARScodeD/V9R5M0/bin/arsslu -I ARCHIVE -c -v
/*
//SYSOUT DD SYSOUT=*
//STDERR DD SYSOUT=*
//STDOUT DD SYSOUT=*
//**************************************************************
//POPULATE EXEC PGM=BPXBATCH,REGION=0M
//STDPARM DD *
SH
export DSNAOINI=/hsbc/ARScodeD/V9R5M0/config/cli.ini;
export STEPLIB=SYS3.DB2.LTA0.SDSNLOD2:SYS3.DB2.LTA0.SDSNLOAD;
/hsbc/ARScodeD/V9R5M0/bin/arsslu -I ARCHIVE -p -v
/*
//SYSOUT DD SYSOUT=*
//STDERR DD SYSOUT=*
//STDOUT DD SYSOUT=*
//**************************************************************
//ANALYZE EXEC PGM=BPXBATCH,REGION=0M
//STDPARM DD *
SH
export DSNAOINI=/hsbc/ARScodeD/V9R5M0/config/cli.ini;
export STEPLIB=SYS3.DB2.LTA0.SDSNLOD2:SYS3.DB2.LTA0.SDSNLOAD;
/hsbc/ARScodeD/V9R5M0/bin/arsslu -I ARCHIVE -a -v
/*
//SYSOUT DD SYSOUT=*
//STDERR DD SYSOUT=*
//STDOUT DD SYSOUT=*
//*************************************************************
//DELETE EXEC PGM=BPXBATCH,REGION=0M
//STDPARM DD *
SH
export DSNAOINI=/hsbc/ARScodeD/V9R5M0/config/cli.ini;
export STEPLIB=SYS3.DB2.LTA0.SDSNLOD2:SYS3.DB2.LTA0.SDSNLOAD;
/hsbc/ARScodeD/V9R5M0/bin/arsslu -I ARCHIVE -d -v </hsbc/ARS/arsL0tmp/yes;
/*
//SYSOUT DD SYSOUT=*
//STDERR DD SYSOUT=*
//STDOUT DD SYSOUT=*
-
Let's take one step at a time.
The first step, CREATE.
I have the following in STDOUT, what do you have?
********************************* TOP OF DATA **********************************
ARS4026I Creating table ARSSERV4.arsslu
ARS4034I Creating index ARSSERV4.arsslu.ARSSERV4.arsslu_idx
ARS4042I Updating runstat statistics for table ARSSERV4.arsslu
1DSNU000I 258 09:27:56.44 DSNUGUTC - OUTPUT START FOR UTILITY, UTILID = ODV73
DSNU1044I 258 09:27:56.45 DSNUGTIS - PROCESSING SYSIN AS EBCDIC
0DSNU050I 258 09:27:56.45 DSNUGUTC - RUNSTATS TABLESPACE ARS950DB.ARSSLUT TA
SHRLEVEL CHANGE
DSNU610I -DSNB 258 09:27:56.49 DSNUSUTP - SYSTABLEPART CATALOG UPDATE FOR ARS9
DSNU604I -DSNB 258 09:27:56.49 DSNUSEF2 - TABLESPACE IS EMPTY
DSNU610I -DSNB 258 09:27:56.49 DSNUSUTB - SYSTABLES CATALOG UPDATE FOR ARSSERV
DSNU610I -DSNB 258 09:27:56.49 DSNUSUCO - SYSCOLUMNS CATALOG UPDATE FOR ARSSER
DSNU610I -DSNB 258 09:27:56.49 DSNUSUTS - SYSTABLESPACE CATALOG UPDATE FOR ARS
DSNU610I -DSNB 258 09:27:56.49 DSNUSUIP - SYSINDEXPART CATALOG UPDATE FOR ARSS
DSNU604I -DSNB 258 09:27:56.50 DSNUSEOF - INDEXSPACE IS EMPTY
DSNU610I -DSNB 258 09:27:56.50 DSNUSUCO - SYSCOLUMNS CATALOG UPDATE FOR ARSSER
DSNU610I -DSNB 258 09:27:56.50 DSNUSUIX - SYSINDEXES CATALOG UPDATE FOR ARSSER
DSNU620I -DSNB 258 09:27:56.50 DSNUSEOF - RUNSTATS CATALOG TIMESTAMP = 2017-09
DSNU010I 258 09:27:56.50 DSNUGBAC - UTILITY EXECUTION COMPLETE, HIGHEST RETU
******************************** BOTTOM OF DATA ********************************
Ed
-
Hi,
thanks for your answer, we were able to execute the jcl correctly, it was a configuration problem in the system.
Thank you