SeanHoppe.com > CLEO Tips > Cleo EDI Integrator > How-to Perform an EMERGENCY Purge with DLTDTA

How-to Perform an EMERGENCY Purge with DLTDTA

7th November 2019

CLEO EDI Integrator DLTDTA command with REORG parameter as NO

There are times users realize that they are coming close to 32,000 members in Cleo’s (EXTOL) tables EXDINPP and EXDDWPP3

Note: This can be done with CMD: DSPMBRCNT

In our previous post we discussion we discussed how to use the CMD DLTDTA.

In today’s post we will use CMD: DLTDTA but we will NOT perform Reorganize log files. This will allow end-users to execute DLTDTA during the workday and NOT interrupt production process flow.

In order to perform the emergency purge we will look to the REORG parameter. When we choose REORG(*NO), Cleo EDI Integrator will not place a database lock, on the respective DB2 tables, during a purge.


By: on
load('http://www.seanhoppe.com/EXTOL-Blog-Feed2/'); $feed2 = array(); foreach ($rss2->getElementsByTagName('item') as $node2) { $item2 = array ( 'title' => $node2->getElementsByTagName('title')->item(0)->nodeValue, 'desc' => $node2->getElementsByTagName('description')->item(0)->nodeValue, 'link' => $node2->getElementsByTagName('link')->item(0)->nodeValue, 'date' => $node2->getElementsByTagName('pubDate')->item(0)->nodeValue, ); array_push($feed2, $item2); } $limit2 = 5; $rss3 = new DOMDocument(); $rss3->load('http://www.ebithree.com/EBIThree-RSS/'); $feed3 = array(); foreach ($rss3->getElementsByTagName('item') as $node3) { $item3 = array ( 'title' => $node3->getElementsByTagName('title')->item(0)->nodeValue, 'link' => $node3->getElementsByTagName('link')->item(0)->nodeValue, ); array_push($feed3, $item3); } $limit3 = 5; $rss4 = new DOMDocument(); //$rss4->load('http://www.ebithree.com/EBIThree-RSS/'); $rss4->load('http://www.ebiworld.com/EBI-Feed/'); $feed4 = array(); foreach ($rss4->getElementsByTagName('item') as $node4) { $item4 = array ( 'title' => $node4->getElementsByTagName('title')->item(0)->nodeValue, 'link' => $node4->getElementsByTagName('link')->item(0)->nodeValue, ); array_push($feed4, $item4); } $limit4 = 5; echo ' '; ?>