Skip Ribbon Commands
Skip to main content
Navigate Up
Sign In

Quick Launch

Average Rating:

facebook Twitter
Email
Print Bookmark Alert me when this article is updated

Feedback

HOW TO: Get the query details in the session log of IICS task when JDBC_IC type connection is used?
Solution
Any JDBC type task in Informatica cloud would not write the query details by default in the session log. User can set the LOGLEVEL = DEBUG option at agent level to get the query details in session log. 

Do the following:
  1. Navigate to Configure > Runtime Environment > Select the Agent. In Custom Configuration tab > create a new Service as 'Data Integration Server', type  as DTM  and provide the value name as LOGLEVEL and provide the value as DEBUGagent_loglevel.PNG
  2. Once the new DIS version comes up, rerun the task and check the session log. Session log would contain query fired.
More Information
Following is the session log entry once this property is enabled. 

READER_1_1_1> JDBC  Read_20036 [2019-07-22 17:38:17.606] [DEBUG] Enter read();Thread ID: [12]
READER_1_1_1> JDBC  Read_20029 [2019-07-22 17:38:17.606] [DEBUG] Isolation Level : None 
READER_1_1_1> JDBC  Read_20003 [2019-07-22 17:38:17.609] [DEBUG] Executing the following query: [SELECT "ALLEMP"."USERID","ALLEMP"."EMPLOYEEID","ALLEMP"."FIRSTNAME","ALLEMP"."LASTNAME","ALLEMP"."PREFERREDNAMELATIN","ALLEMP".
"EMAILADDRESS","ALLEMP"."EMAILID","ALLEMP"."PRIMARYEMAILIND","ALLEMP"."AGE","ALLEMP"."HIREDATE","ALLEMP"."GEOGRAPHICALLOCATION","ALLEMP"."ACTIVE","ALLEMP".
"TERMINATED","ALLEMP"."REHIRE","ALLEMP"."HIRERESCINDED" FROM "NBHATMB"."ALLEMP"] 
READER_1_1_1> JDBC  Read_20036 [2019-07-22 17:38:17.609] [DEBUG] Enter getPreparedStatementWithFetchSize();Thread ID: [12]
READER_1_1_1> JDBC  Read_20036 [2019-07-22 17:38:17.710] [DEBUG] Exit getPreparedStatementWithFetchSize();Thread ID: [12]
READER_1_1_1> JDBC  Read_20036 [2019-07-22 17:38:17.710] [DEBUG] Enter execQueryAndWriteToBuffer();Thread ID: [12]
READER_1_1_1> JDBC  Read_20036 [2019-07-22 17:38:17.790] [DEBUG] Exit execQueryAndWriteToBuffer();Thread ID: [12]
READER_1_1_1> JDBC  Read_20036 [2019-07-22 17:38:17.790] [DEBUG] Exit read();Thread ID: [12]

Reference
Applies To
Product: Cloud Data Integration
Problem Type: Configuration
User Type: Developer
Project Phase: Implement
Product Version:
Database:
Operating System:
Other Software:
Attachments
Last Modified Date:9/16/2019 10:29 PMID:522093
People who viewed this also viewed

Feedback

Did this KB document help you?



What can we do to improve this information (2000 or fewer characters)