Question

11
Replies
1386
Views
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
Share this page LinkedIn