how to increase the performance of datadeploy

nagendra

Hi all,

Teamsite 6.5 sp2, opendeploy Version 6.0.2.0.0 Build 46963 Interwoven 20050402, solaris 9.

For simple delete query like 'delete from table where pkid=?' is taking around 9 seconds. how to increase the performance of dd?


ENG: 2007-03-27 05:13:09 BST GMT+01:00 Begin logfile [/data/software/iw/iw-home/OpenDeployNG/log/src.wft_contsync_datadeploy.log] ---------
ENG: 2007-03-27 05:13:09 BST GMT+01:00 Job ID=m48616 Deployment=wft_contsync_datadeploy
ENG: 2007-03-27 05:13:09 BST GMT+01:00 internalDepName is :wft_contsync_datadeploy

ENG: 2007-03-27 05:13:09 BST GMT+01:00 Value of attrs {PAD6=null, DEPLOYSUFFIX=, JOBID=m48616, LOGLEVEL=VERBOSE, PAD3=null, ENDTIME=null, PAD5=null, MINUTEINV=0, HOURINV=0, SYNCH=true, REPAIR=false, VERIFY=false, EXTERNALTASKID=null, YEARINV=0, REPEAT=false, WEEKDAY=null, PAD2=null, OWNER=iwadmin, KEYVALUES=iwdd=DELETE-DOCUMENT_METADATA-EA
file=generated/content/editorial/news/wholesale_news/news_items/news 2005/November/second quarter results_summary.html
iwdd-op=do-sql
user-op=DELETE-DOCUMENT_METADATA-ENTRY
db1=oracle
dbase1=xxxxx:1521:xxxx
dbuser1=xxxxxx
dbpass1=xxxxxx
, DEPLOYNAME=wft_contsync_datadeploy, NO_RECUR=NO_RECUR, STARTTIME=Tue Mar 27 05:13:09 BST 2007, PAD4=null, RECURSET=NO_RECUR, DEPUUID=7881d7b0-dc19-11db-90ec-9bfbb05f98a8, DAYINV=0, PAD1=null, STARTDEPLOY=true, MONTHDAYS=null, SOURCEHOST=ecoapp24-lgs, DESCRIPTION=, SOURCEINSTANCE=initial, WEEKINV=0}

ENG: 2007-03-27 05:13:09 BST GMT+01:00 Invoking TMicrodDataDeploy(wft_contsync_datadeploy , {PAD6=null, DEPLOYSUFFIX=, JOBID=m48616, LOGLEVEL=VERBOSE, PAD3=null, ENDTIME=null, PAD5=null, MINUTEINV=0, HOURINV=0, SYNCH=true, REPAIR=false, VERIFY=false, EXTERNALTASKID=null, YEARINV=0, REPEAT=false, WEEKDAY=null, PAD2=null, OWNER=iwadmin, KEYVALUES=iwdd=DELETE-DOCUMENT_METADATA-EA
file=generated/content/editorial/news/wholesale_news/news_items/news 2005/November/second quarter results_summary.html
iwdd-op=do-sql
user-op=DELETE-DOCUMENT_METADATA-ENTRY
db1=oracle
dbase1=xxxxx:1521:xxxx
dbuser1=xxxxxx
dbpass1=xxxxxx
, DEPLOYNAME=wft_contsync_datadeploy, NO_RECUR=NO_RECUR, STARTTIME=Tue Mar 27 05:13:09 BST 2007, PAD4=null, RECURSET=NO_RECUR, DEPUUID=7881d7b0-dc19-11db-90ec-9bfbb05f98a8, DAYINV=0, PAD1=null, STARTDEPLOY=true, MONTHDAYS=null, SOURCEHOST=ecoapp24-lgs, DESCRIPTION=, SOURCEINSTANCE=initial, WEEKINV=0} , /data/software/iw/iw-home/OpenDeployNG/conf/wft_contsync_datadeploy.xml , com.interwoven.deploy.engine.TMacroDataDeploy@1c6afe2 , wft_contsync_datadeploy , false )

ENG: 2007-03-27 05:13:09 BST GMT+01:00 DD Attrs :iwdd=DELETE-DOCUMENT_METADATA-EA
file=generated/content/editorial/news/wholesale_news/news_items/news 2005/November/second quarter results_summary.html
iwdd-op=do-sql
user-op=DELETE-DOCUMENT_METADATA-ENTRY
db1=oracle
dbase1=xxxxx:1521:xxxx
dbuser1=xxxxxx
dbpass1=xxxxxx

ENG: 2007-03-27 05:13:09 BST GMT+01:00 DD cmd line params : {dbpass1=xxxxxx, dbase1=xxxxx:1521:xxxx, iwdd=DELETE-DOCUMENT_METADATA-EA, user-op=DELETE-DOCUMENT_METADATA-ENTRY, iwdd-op=do-sql, file=generated/content/editorial/news/wholesale_news/news_items/news 2005/November/second quarter results_summary.html, dbuser1=xxxxxx, db1=oracle}
ENG: 2007-03-27 05:13:09 BST GMT+01:00 Legid wft_contsync_datadeploy
ENG: 2007-03-27 05:13:09 BST GMT+01:00 Get config for deployment :[wft_contsync_datadeploy]
ENG: 2007-03-27 05:13:09 BST GMT+01:00 Starting internal deployment wft_contsync_datadeploy.DELETE-DOCUMENT_METADATA-EA, Thread-97265
ENG: 2007-03-27 05:13:09 BST GMT+01:00 setting fOKToUse to true
ENG: 2007-03-27 05:13:09 BST GMT+01:00 Waiting for 1 children to complete phases
ENG: 2007-03-27 05:13:09 BST GMT+01:00 Acquire latch
ENG: 2007-03-27 05:13:18 BST GMT+01:00 Signal Completion to Parent done
ENG: 2007-03-27 05:13:18 BST GMT+01:00 Done Acquiring latch
ENG: 2007-03-27 05:13:18 BST GMT+01:00 All 1 children completed their phases
ENG: 2007-03-27 05:13:18 BST GMT+01:00 Waiting for 1 children for completion of disconnect routine
ENG: 2007-03-27 05:13:18 BST GMT+01:00 Manager is com.interwoven.deploy.engine.TMacroDeployInitiator@1712651
ENG: 2007-03-27 05:13:18 BST GMT+01:00 Adding MacroDD to Completed session
ENG: 2007-03-27 05:13:18 BST GMT+01:00 Completed session queue capacity reached. Removed oldest session.


ENG: 2007-03-27 05:13:18 BST GMT+01:00 Job ID=m48616 Deployment=wft_contsync_datadeploy Elapsed Time=9208 ms <<<
ENG: 2007-03-27 05:13:18 BST GMT+01:00 End logfile [/data/software/iw/iw-home/OpenDeployNG/log/src.wft_contsync_datadeploy.log]