Hi All,
I am trying to automate our Datastage project exports using the dsexport utility. The process to do this seems to be mostly okay, however I am experiencing some difficulties that hopefully someone out there can shed some light on.
Questions
1. Has anyone figured out how to export selected Categorys/Jobs using dsexport? I have already read the archive about this but I am hoping that someone has figured a work around.
2. Is it possible to omit exporting the Job Executables?
3. During the automated export process I am receiving a Run time error, but when I run the export from Manager this error does not occur. Any ideas on this?
4. Is it possible to by-pass the warning that comes out at the end of the export that says certain read-only objects where not exported? I am jumping the gun here because I haven't yet completed a full export from the command line, but I expect that this message will come up.
System Specs
Datastage Server/Client 4.1
Windows NT Server 4.0
Thanks for your help
Cameron
Ammendment to Question 3. I am receiving the Run time error from Manager as well.
The error is Run-time error '6': overflow.
This seems to occur when I include exporting the job executables. When I don't include the job executables the export works fine.
Automatic Project Exports
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
1. No.
2. No.
3. Not without more detailed information. How big is the export file?
What is in, and what is missed, when this occurs? Is it always at
the same point during the export process?
4. There's a command line option that includes the read-only objects.
If this is used, the warning does not appear.
Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518
2. No.
3. Not without more detailed information. How big is the export file?
What is in, and what is missed, when this occurs? Is it always at
the same point during the export process?
4. There's a command line option that includes the read-only objects.
If this is used, the warning does not appear.
Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518
-
- Premium Member
- Posts: 66
- Joined: Wed Mar 05, 2003 6:03 pm
- Location: Brisbane, Australia
- Contact:
Thanks for your replies,
I ran a some test runs yesterday exporting two of our projects using both a command line export and a manager export. The following lists the error message, what job it was exporting and the size of the extract I received when running the export. Where AAAA and BBBB are separate jobs in the two projects.
Project1
Run 1
Command Line - Error
Datastage Export Utility
Run Time Error: '6':
Overflow
Job: Exporting Executable job AAAA
Size: ~78 Mb
Run 2
Command Line - Error
Datastage Export Utility
Run-time error '6':
Overflow
Job: Exporting Executable job AAAA
Size: ~78 Mb
Run 3
Datastage Manager - Error
Datastage Manager
Run-time error '6':
Overflow
Job: Exporting Executable job AAAA
Size: ~78 Mb
Run 4
Command Line - Error
Datastage Export Utility
Run-time error '6':
Overflow
Job: Exporting Executable job AAAA
Size: ~78 Mb
Project2
Run 1
Command Line - Error
Datastage Export Utility
Run-time error '6':
Overflow
Job: Exporting programs for job BBBB
Size: ~60 Mb
Run 2
Command Line - Datastage Export Utility
Run-time error '6':
Overflow
Job: Exporting programs for job BBBB
Size: ~60 Mb
I have exported these jobs individually including their executables and the export worked fine.
Thanks
Cameron
I ran a some test runs yesterday exporting two of our projects using both a command line export and a manager export. The following lists the error message, what job it was exporting and the size of the extract I received when running the export. Where AAAA and BBBB are separate jobs in the two projects.
Project1
Run 1
Command Line - Error
Datastage Export Utility
Run Time Error: '6':
Overflow
Job: Exporting Executable job AAAA
Size: ~78 Mb
Run 2
Command Line - Error
Datastage Export Utility
Run-time error '6':
Overflow
Job: Exporting Executable job AAAA
Size: ~78 Mb
Run 3
Datastage Manager - Error
Datastage Manager
Run-time error '6':
Overflow
Job: Exporting Executable job AAAA
Size: ~78 Mb
Run 4
Command Line - Error
Datastage Export Utility
Run-time error '6':
Overflow
Job: Exporting Executable job AAAA
Size: ~78 Mb
Project2
Run 1
Command Line - Error
Datastage Export Utility
Run-time error '6':
Overflow
Job: Exporting programs for job BBBB
Size: ~60 Mb
Run 2
Command Line - Datastage Export Utility
Run-time error '6':
Overflow
Job: Exporting programs for job BBBB
Size: ~60 Mb
I have exported these jobs individually including their executables and the export worked fine.
Thanks
Cameron