This is a discussion on Error running db2 utilities on ZOS within the DB2 forums, part of the Database Server Software category; --> I am using db2 version 6 on zos. I am trying to runutility using utilities menu option in spufi. ...
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| I am using db2 version 6 on zos. I am trying to runutility using utilities menu option in spufi. After specifying information on the screen: DB2 UTILITIES "DOWN " is not acti ==> elect from the following: 1 FUNCTION ===> EDITJCL (SUBMIT job, EDITJCL, DISPLAY, TERMINATE 2 JOB ID ===> PMEHROT (A unique job identifier string) 3 UTILITY ===> RUNSTATS (CHECK DATA, CHECK INDEX, CHECK LOB, COPY, DIAGNOSE, LOAD, MERGE, MODIFY, QUIESCE, REBUILD, RECOVER, REORG INDEX, REORG LOB, REORG TABLESPACE, REPORT, REPAIR, RUNSTATS, STOSPACE, UNLOAD) 4 STATEMENT DATA SET ===> OMP.DB2.CNTL(RUNSTATS) pecify restart or preview option, otherwise enter NO. 5 RESTART ===> NO (NO, CURRENT, PHASE or PREVIEW) 6 LISTDEF? (YES|NO) ===> NO TEMPLATE? (YES|NO) ===> NO * The data set names panel will be displayed when required by a utility. When I hit enter key, I get following error: >>DSNU EXEC: >> RUNSTATS UTILITY REQUESTED WITH >> CONTROL=NONE, EDIT=SPF, RESTART=NO, >> INDSN=PMEHROT.OMP.DB2.CNTL(RUNSTATS), RECDSN="PROMPT", PUNCHDSN="OMITTED" >> DISCDSN="OMITTED",LISTDSN="OMITTED", TEMPDSN="OMITTED", >> COPYDSN=**NOT REQUIRED**, COPYDSN2=**NOT REQUIRED**, >> RCPYDSN1=**NOT REQUIRED**, RCPYDSN2=**NOT REQUIRED**, >> SYSTEM=DB2T, SUBMIT=NO, UID=PMEHROT, >> UNIT=SYSDA, VOLUME="OMITTED", DB2I=YES. >> THE RESULTING JCL WILL BE WRITTEN TO DSNURUN.CNTL >> ERROR: TSO RETURN CODE IS 348. *** |