I have to process the error log files created by netezza load and reprocess them. Did anybody do this before? I would like to know the best way to automate the whole process of reading the log files and passing the table definitions and loading it back with default values. ANy insight in this direction would be great.
Thanks,
Abhishek.
NZLoad Log Files
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 108
- Joined: Sat Feb 05, 2005 6:52 pm
- Location: US
NZLoad Log Files
Every great mistake has a halfway moment, a split second when it can be recalled and perhaps remedied.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
First question (from a non-Netezza person): are the NZLoad log files in text format or in some binary format? Second question: if they are in text format, is there any consistency to the layout of lines - that is, other than treating the line as a single VARCHAR, is there any metadata you could apply to make processing of the file easier to manage in a DataStage job?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Premium Member
- Posts: 108
- Joined: Sat Feb 05, 2005 6:52 pm
- Location: US