| ORACLE Unload/Reloads very slow on MVS [message #113888] |
Sat, 03 May 2003 19:02  |
raj patel
Messages: 15
Registered: October 2002
|
Junior Member |
|
|
Hi again, my ORACLE DBA's are concerned that ORACLE database unload/reload's are very slow on the mainframe compared to some NT's systems.
The mainframe is a 9672-R56 and we have fast IBM ESS 2105 disk's.
I would be interested in users hints/tips please.
Thanks Raj.
|
|
|
|
| Re: ORACLE Unload/Reloads very slow on MVS [message #113889 is a reply to message #113888] |
Sat, 03 May 2003 19:03  |
Gia McNerney
Messages: 7
Registered: March 2001
|
Junior Member |
|
|
: Hi again, my ORACLE DBA's are concerned that ORACLE database unload/reload's are very slow on the mainframe compared to some NT's systems.
: The mainframe is a 9672-R56 and we have fast IBM ESS 2105 disk's.
: I would be interested in users hints/tips please.
: Thanks Raj.
Hi Raj,
Hi,
This shouldn't be any slower. A few suggestions:
Specify the BUFFER parm to make it more efficient
Ensure the DCB information is specified for the export dataset.
Ask Operations to up the priority for your jobs.
When we specified the buffer with DCB info, our exports/imports were much quicker (imports are a direct result of the export file).
I'm assuming you are talking about export/import when stating unload and reload?
Gia
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
