Home » Infrastructure » Other Operating Systems » EXP-00030 from MVS exp
| EXP-00030 from MVS exp [message #233343] |
Wed, 25 April 2007 14:48  |
DN8747
Messages: 1
Registered: April 2007
|
Junior Member |
|
|
I'm trying to set up a job that will do an exp from MVS. I tried to use the example script through the script section of the site http://orafaq.com/scripts/mvs/export.txt
When I run the job, I'm consistently getting the following error:
Export: Release 9.2.0.4.21 - Production on Wed Apr 25 13:59:01 2007
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Username:
EXP-00030: Unexpected End-Of-File encountered while reading input
EXP-00000: Export terminated unsuccessfully
:-) .STEPS01 .SYSERR 9
Yes, the client version on our complex is a bit old, and changing it is out of my control. We're trying to connect to an AIX based 10g instance through the process.
I've tried pretty much everything I can think of, switching member based parfiles to inline in the JCL, switching from tape to disk for the out file, changing the DCB for the out file, removing all members I could, etc.. The version I'm currently working with looks like the following:
//DN8747OC JOB (1MDB,CPSC,03,5),'ORACLE EXP',
// SCHENV=HA00,NOTIFY=&SYSUID
//***************************************************************
//JOBLIB DD DSN=SUPT.ORACLE.SERVER.CMDLOAD,DISP=SHR
// DD DSN=SUPT.ORACLE.SERVER.MESG,DISP=SHR
//***************************************************************
//STEPS01 EXEC PGM=EXP
//SYSMDUMP DD SYSOUT=*
//SYSOUT DD SYSOUT=*,DCB=(LRECL=132,BLKSIZE=1320,RECFM=VB)
//SYSERR DD SYSOUT=*,DCB=(LRECL=132,BLKSIZE=1320,RECFM=VB)
//ORAPRINT DD SYSOUT=*
//ARCDATA DD DSN=DN8747.ORA.EXPTST.A070425,
// UNIT=3590TAPE,VOL=(,RETAIN,,99),
// DCB=(PSDSCB,RECFM=FB,BLKSIZE=32760),
// DISP=(NEW,CATLG,DELETE),
// RETPD=2000
//TNSNAMES DD DSN=MDNCNSA.CNTLLIB(TNSNAMES),DISP=SHR
//PARFILE DD DSN=DN8747.ORACLE.TEST.CNTLCARD(MDNCNPF),DISP=SHR
// DD DSN=DN8747.ORACLE.TEST.SQL(MDNCNDEP),DISP=SHR
Where arcdata is the tape file I'm trying to write out to from the exp.
MDNCNPF contains the following:
USERID=userid/password@tnsname
MDNCNDEP contains the following:
FILE=/DD/ARCDATA
CONSISTENT=Y
DIRECT=Y
BUFFER=9999999
COMPRESS=Y
ROWS=Y
CONSTRAINTS=Y
GRANTS=Y
INDEXES=Y
TRIGGERS=Y
TABLES=(STATE_NAME_LOOKUP)
The TNSNAMES member works with the SQLPlus and Loader jobs we have using it. I've tried moving the parfile info to be inline, like the example had (below), but no luck. Any ideas where the problem may be coming in?
//PARFILE DD *
USERID=USERNAME/PASSWORD
FILE=/DD/EXPORT
CONSISTENT=Y
DIRECT=Y
BUFFER=9999999
RECORD=N
|
|
|
|
|
|
Goto Forum:
Current Time: Thu Oct 30 19:10:00 CDT 2025
|
] 
Blog
Search
Help
Members
Register
Login
Home
