CPYTOIMPF performance problem

5 pts.
Tags:
CPYTOIMPF
CPYTOIMPF performance
IFS
V5R4
V6R1
Since moving from V5R4M0 to V6R1M0 our program that copies from a PF to an import file on the IFS using the CPYTOIMPF command has had major performance issues. What used to take 30 minutes to copy now takes as much as 24 hours.

Answer Wiki

Thanks. We'll let you know when a new response is added.

Hi,

Are you on the latest PTF level? Do you get any error messages in the joblog or QSYSOPR? Have you tried running the job in debug to see if it gives any extra diagnostics?

Regards,

Martin Gilbert.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Tpinky
    I responded to a previous question like this back in Sept. Here is the same response I gave then... You could try using CPYTOSTMF instead of CPYTOIMPF. CPYTOIMPF/CPYFRMIMPF uses the underlying DB2 engine. IBM, starting in V5R3, got fussy about getting your CCSID correct. In previous releases I think IBM used to do a CPYTOSTMF then a CPYTOIMPF. Breaking it down into two tasks is another perversion that has shown some success. However getting the CCSID right is best bet. It's when you do things like creating a temporary file in QTEMP that some utilities requires not to be externally defined (CRTPF ... RCDLEN(###) type of file) that makes it tough. Hope this helps...
    4,165 pointsBadges:
    report
  • slack400
    I'm with Tpinky. We're doing the pervse method of using the STMF and then IMPF commands.
    2,705 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following