Question

11
Replies
1555
Views
Close popover
nagavenkata naveen (nagavenkatan1807)
igate global solutions

igate global solutions
IN
nagavenkatan1807 Member since 2015 15 posts
igate global solutions
Posted: February 10, 2016
Last activity: March 17, 2016
Closed
Solved

Error when trying to use truncate query using RDB-Delete method

Hi Everyone,

I wrote an activity where in step 1, I am using RDB-Delete method where my connect SQL rule delete tab contains truncate query like below.

TRUNCATE TABLE tablename IMMEDIATE;

The activity is a Agent Activity and is running for every 1 hour for truncating the table. I am getting the below error.

code: -428 SQLState: 25001 Message: DB2 SQL error: SQLCODE: -428, SQLSTATE: 25001, SQLERRMC: null

Could anyone help me in fixing this.

Please note that delete query in place of Truncate is working fine but there is a performance issue because the delete query like below is not having where clause so trying to acquire lock on whole table and deleting one row at a time there by causing performance issue at PEGA level and deadlock issue at DB level.

delete from tablename;

Thanks,

Naveen

Data Integration System Administration
Moderation Team has archived post,
Close popover This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.