Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

Message Posted: Fri, 27 Apr 2007 @ 16:20:56 GMT


     
  <Prev Next>   <<First <Prev
Next>
Last>>
 


Subj:   Re: FastLoad Errors vs MLoad
 
From:   Ferry, Craig

Here is a sample of the errors I see. Note it just says ERRLIMIT exceeded. In this case there was only one row, but if there would have been more, it would have read all of them and gave me the same errors.

     **** 09:51:00 Number of recs/msg: 64
     **** 09:51:00 Starting to send to RDBMS with record 1
     **** 09:51:00 Sending row 1
     **** 09:51:00 ERRLIMIT exceeded
          -------------------------------------------------------
          -                                                     -
          -          Logoff/Disconnect                          -
          -                                                     -
          -------------------------------------------------------

     **** 09:51:00 Logging off all sessions
     **** 09:51:00 Total processor time used = '0.47 Seconds'
          .        Start : Fri Apr 27 09:50:58 2007
          .        End   : Fri Apr 27 09:51:00 2007
          .        Highest return code encountered = '12'.
     **** 09:51:00 FastLoad Paused

Here is the data record I intentionally created. Note that I entered CRAIG where a numeric field was expected.

     onstat
     -p|2007/04/26|12:01|16:01|240|04:00:00|CRAIG|58279829|891323506|98.04|59
     0458|1371128|16075650|96.33|692275871|17
     54086|39413112|532606601|16573129|153606|285919|90283|114|0|0|0|0|0|0|0|
     0|0|0|8495.74|5028.40|47|94|3559363|21|35355918
     |0|0|124|57024|901303|6665255|490404|2518979|9660164|463038|

Here is the script.

     #!/bin/ksh
     set -x
     . /users/dss/.env_logon_dba_fload
     DATABASE=teradata
     fastload << EOF
     SESSIONS 4;
     ERRLIMIT 1;
     LOGON $DATABASE/${TTID},${TTPSWD};
     DELETE FROM dssbatch.work_onstat_p;
     SET RECORD VARTEXT "|";
     DEFINE record_junk (varchar(10)),
     collect_date (varchar(20)),
     collect_start_time (varchar(20)),
     collect_end_time (varchar(20)),
     collection_minutes (varchar(20)),
     collection_duration (varchar(20)),
     disk_reads (varchar(20)),
     page_reads (varchar(20)),
     buffer_reads (varchar(20)),
     read_perc_cached (varchar(20)),
     disk_writes (varchar(20)),
     page_writes (varchar(20)),
     buffer_writes (varchar(20)),
     write_perc_cached (varchar(20)),
     isam_total (varchar(20)),
     isam_open (varchar(20)),
     isam_start (varchar(20)),
     isam_read (varchar(20)),
     isam_write (varchar(20)),
     isam_rewrite (varchar(20)),
     isam_delete (varchar(20)),
     isam_commit (varchar(20)),
     isam_rollback (varchar(20)),
     gp_read (varchar(20)),
     gp_write (varchar(20)),
     gp_rewrite (varchar(20)),
     gp_delete (varchar(20)),
     gp_allocate (varchar(20)),
     gp_free (varchar(20)),
     gp_cursor (varchar(20)),
     over_lock (varchar(20)),
     over_user_threads (varchar(20)),
     over_buffer (varchar(20)),
     user_cpu (varchar(20)),
     system_cpu (varchar(20)),
     number_checkpoints (varchar(20)),
     buffer_pool_flushes (varchar(20)),
     buffer_waits (varchar(20)),
     lock_waits (varchar(20)),
     lock_requests (varchar(20)),
     deadlock_detected (varchar(20)),
     deadlock_timeout (varchar(20)),
     checkpoint_waits (varchar(20)),
     page_compressed (varchar(20)),
     sequential_scans (varchar(20)),
     index_data_page_read_aheads (varchar(20)),
     index_read_ahead (varchar(20)),
     data_only_scan (varchar(20)),
     read_ahead_pages_used (varchar(20)),
     latch_waits (varchar(20))
     FILE = /dba/dss/informix_performance/profile_data.final.TEST;
     SHOW;
     BEGIN LOADING dssbatch.work_onstat_p
     ERRORFILES dssbatch.fl_onstat_p_er, dssbatch.fl_onstat_p_uv
     CHECKPOINT 5000;
     INSERT INTO dssbatch.work_onstat_p
     (
     collect_date,
     collect_start_time,
     collect_end_time,
     collection_minutes,
     collection_duration,
     disk_reads,
     page_reads,
     buffer_reads,
     read_perc_cached,
     disk_writes,
     page_writes,
     buffer_writes,
     write_perc_cached,
     isam_total,
     isam_open,
     isam_start,
     isam_read,
     isam_write,
     isam_rewrite,
     isam_delete,
     isam_commit,
     isam_rollback,
     gp_read,
     gp_write,
     gp_rewrite,
     gp_delete,
     gp_allocate,
     gp_free,
     gp_cursor,
     over_lock,
     over_user_threads,
     over_buffer,
     user_cpu,
     system_cpu,
     number_checkpoints,
     buffer_pool_flushes,
     buffer_waits,
     lock_waits,
     lock_requests,
     deadlock_detected,
     deadlock_timeout,
     checkpoint_waits,
     page_compressed,
     sequential_scans,
     index_data_page_read_aheads,
     index_read_ahead,
     data_only_scan,
     read_ahead_pages_used,
     latch_waits
     )
     VALUES(
     :collect_date,
     :collect_start_time,
     :collect_end_time,
     :collection_minutes,
     :collection_duration,
     :disk_reads,
     :page_reads,
     :buffer_reads,
     :read_perc_cached,
     :disk_writes,
     :page_writes,
     :buffer_writes,
     :write_perc_cached,
     :isam_total,
     :isam_open,
     :isam_start,
     :isam_read,
     :isam_write,
     :isam_rewrite,
     :isam_delete,
     :isam_commit,
     :isam_rollback,
     :gp_read,
     :gp_write,
     :gp_rewrite,
     :gp_delete,
     :gp_allocate,
     :gp_free,
     :gp_cursor,
     :over_lock,
     :over_user_threads,
     :over_buffer,
     :user_cpu,
     :system_cpu,
     :number_checkpoints,
     :buffer_pool_flushes,
     :buffer_waits,
     :lock_waits,
     :lock_requests,
     :deadlock_detected,
     :deadlock_timeout,
     :checkpoint_waits,
     :page_compressed,
     :sequential_scans,
     :index_data_page_read_aheads,
     :index_read_ahead,
     :data_only_scan,
     :read_ahead_pages_used,
     :latch_waits
     );
     END LOADING;
     LOGOFF;
     EOF

     ERROR=$?
     if [ $ERROR -ne 0 ]
     then
      exit $ERROR
     fi

     exit 0


     
  <Prev Next>   <<First <Prev
Next>
Last>>
 
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020