| How to read sqlloader log files for rejected records [message #97692] |
Thu, 14 November 2002 15:24  |
Shelley
Messages: 2
Registered: November 2002
|
Junior Member |
|
|
I am trying to make a utility that can read the sql loader log files , check if records got rejected ( if the number of records rejected is >0) , if yes then it should send an alert through mail.
The problem that I am having right now that how do I check in the log file that that the number of rejected records is zero?
|
|
|
|
|
|
| Re: How to read sqlloader log files for rejected records [message #97741 is a reply to message #97692] |
Thu, 12 December 2002 12:39  |
Sanjay
Messages: 236
Registered: July 2000
|
Senior Member |
|
|
The BOTTOM 19 lines of the log file CLEARLY tells you how many rows got inserted and rejected and so on. You have it there so just do a 'grep' on the key work.
or do
tail -19 sqlloader.log | mailx ....
Example (bottom 19 lines)
443 Rows successfully loaded.
0 Rows not loaded due to data errors.
0 Rows not loaded because all WHEN clauses were failed.
0 Rows not loaded because all fields were null.
Space allocated for bind array: 65016 bytes(63 rows)
Space allocated for memory besides bind array: 0 bytes
Total logical records skipped: 0
Total logical records read: 443
Total logical records rejected: 0
Total logical records discarded: 0
Run began on Tue Aug 20 15:00:57 2002
Run ended on Tue Aug 20 15:00:58 2002
Elapsed time was: 00:00:01.41
CPU time was: 00:00:00.04
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
