Increase the log level or tracing using control files

Tools

Increase the log level or tracing using control files


Hi All,

Below is my sample control file. I would like to add the tracing level or log level and sending those information to the log file. How to achieve that and where to add in the below control file. Please help me ASAP.

Control file content :

dateform ANSIDATE;

errlimit 1000000;
tenacity 4;
sessions 1;
sleep 6;

LOGON tdp1/rmw_rep,Rfg;

DROP TABLE SA_RMW_T_D.ET_WC_ACTIVITY_DS ;
DROP TABLE SA_RMW_T_D.UV_WC_ACTIVITY_DS ;
DELETE FROM SA_RMW_T_D.WC_ACTIVITY_DS ALL;

set record unformatted;

define
INTEGRATION_ID (CHAR(30) , NULLIF = '*'),
DATASOURCE_NUM_ID (CHAR(12) , NULLIF = '*'),
X_LN_ACTV_CANCEL_REASON (CHAR(30) , NULLIF = '*'),
X_LN_BACK_OFFC_CREATE_DTS (CHAR(19) , NULLIF = '*'),
X_LN_CONT_LGL_EDU_CR_NBR (CHAR(20) , NULLIF = '*'),
X_LN_PLTFM (CHAR(30) , NULLIF = '*'),
X_LN_TRAIN_CRSE_NAME (CHAR(50) , NULLIF = '*'),
X_LN_DELIVERY_MTHD (CHAR(100) , NULLIF = '*'),
X_LN_MEETING_TYPE (CHAR(100) , NULLIF = '*'),
X_LN_NO_ATTENDEES (CHAR(12) , NULLIF = '*'),
X_LN_NO_EXEC_ATTENDEES (CHAR(12) , NULLIF = '*'),
X_LN_NO_NEW_ATTENDEES (CHAR(12) , NULLIF = '*'),
X_LN_VALUE_STMT (CHAR(255) , NULLIF = '*'),
X_LN_VALUE_STMT_TYPE (CHAR(50) , NULLIF = '*'),
X_LN_SALES_REP_LAST_NAME (CHAR(50) , NULLIF = '*'),
X_LN_SALES_REP_FST_NAME (CHAR(50) , NULLIF = '*'),
X_LN_SALES_MGR_LAST_NAME (CHAR(50) , NULLIF = '*'),
X_LN_SALES_MGR_FST_NAME (CHAR(50) , NULLIF = '*'),
X_LN_VP_LAST_NAME (CHAR(50) , NULLIF = '*'),
X_LN_VP_FST_NAME (CHAR(50) , NULLIF = '*'),
X_LN_PREV_ACT_ID (CHAR(15) , NULLIF = '*'),
X_LN_CONSULT_HOURS (CHAR(22) , NULLIF = '*'),
X_LN_ACT_PREFERENCE (CHAR(30) , NULLIF = '*'),
X_LN_CREATED_DT (CHAR(19) , NULLIF = '*'),
X_LN_CREATED_DT_WID (CHAR(12) , NULLIF = '*'),
X_LN_APPT_DURATION_MIN (CHAR(24) , NULLIF = '*'),
X_LN_CREATOR_LOGIN (CHAR(50) , NULLIF = '*'),
X_LN_CONTACT_TRGT_REASON (CHAR(30) , NULLIF = '*'),
newlinechar (CHAR(:CF.PadLength))
file=:CF.ImportFileName;

show;

begin loading SA_RMW_T_D.WC_ACTIVITY_DS errorfiles SA_RMW_T_D.ET_WC_ACTIVITY_DS, SA_RMW_T_D.UV_WC_ACTIVITY_DS
checkpoint 0 ;

insert into SA_RMW_T_D.WC_ACTIVITY_DS (
INTEGRATION_ID,
DATASOURCE_NUM_ID,
X_LN_ACTV_CANCEL_REASON,
X_LN_BACK_OFFC_CREATE_DTS,
X_LN_CONT_LGL_EDU_CR_NBR,
X_LN_PLTFM,
X_LN_TRAIN_CRSE_NAME,
X_LN_DELIVERY_MTHD,
X_LN_MEETING_TYPE,
X_LN_NO_ATTENDEES,
X_LN_NO_EXEC_ATTENDEES,
X_LN_NO_NEW_ATTENDEES,
X_LN_VALUE_STMT,
X_LN_VALUE_STMT_TYPE,
X_LN_SALES_REP_LAST_NAME,
X_LN_SALES_REP_FST_NAME,
X_LN_SALES_MGR_LAST_NAME,
X_LN_SALES_MGR_FST_NAME,
X_LN_VP_LAST_NAME,
X_LN_VP_FST_NAME,
X_LN_PREV_ACT_ID,
X_LN_CONSULT_HOURS,
X_LN_ACT_PREFERENCE,
X_LN_CREATED_DT,
X_LN_CREATED_DT_WID,
X_LN_APPT_DURATION_MIN,
X_LN_CREATOR_LOGIN,
X_LN_CONTACT_TRGT_REASON
) VALUES (
:INTEGRATION_ID,
:DATASOURCE_NUM_ID,
:X_LN_ACTV_CANCEL_REASON,
:X_LN_BACK_OFFC_CREATE_DTS,
:X_LN_CONT_LGL_EDU_CR_NBR,
:X_LN_PLTFM,
:X_LN_TRAIN_CRSE_NAME,
:X_LN_DELIVERY_MTHD,
:X_LN_MEETING_TYPE,
:X_LN_NO_ATTENDEES,
:X_LN_NO_EXEC_ATTENDEES,
:X_LN_NO_NEW_ATTENDEES,
:X_LN_VALUE_STMT,
:X_LN_VALUE_STMT_TYPE,
:X_LN_SALES_REP_LAST_NAME,
:X_LN_SALES_REP_FST_NAME,
:X_LN_SALES_MGR_LAST_NAME,
:X_LN_SALES_MGR_FST_NAME,
:X_LN_VP_LAST_NAME,
:X_LN_VP_FST_NAME,
:X_LN_PREV_ACT_ID,
:X_LN_CONSULT_HOURS,
:X_LN_ACT_PREFERENCE,
:X_LN_CREATED_DT,
:X_LN_CREATED_DT_WID,
:X_LN_APPT_DURATION_MIN,
:X_LN_CREATOR_LOGIN,
:X_LN_CONTACT_TRGT_REASON
) ;

end loading;

logoff;
2 REPLIES

Re: Increase the log level or tracing using control files

Help me on this
Junior Contributor

Re: Increase the log level or tracing using control files

What do you mean by "tracing level or log level"?

Dieter