Exporting any object takes minutes instead of seconds to run

Products

• CA Automic Applications Manager (AM)

Issue/Introduction

Exporting objects in Applications Manager should take a few seconds. In some rare instance, it is seen that Exporting any objects takes minutes to run.

When enabling Job level debug IMPEXP as noted in the documentation linked here, rerunning the Job, and reviewing the output file, the following is seen:

Export
Processed 42 rows
Processed 0 printers
Processed 0 dist_lists
Processed 0 spoolers
Processed 0 modules
Processed 0 data_types
Processed 0 sub_vars
Processed 0 applications
Processed 0 libraries
Processed 1 program_types
Processed 0 calendars
Processed 0 prompts
Processed 0 schedules
Processed 0 exceptions
Processed 0 conditions
Processed 0 chain details
Processed 0 roles
Processed 0 role details
Processed 0 docs
Processed 0 agents
Processing time 00:00:00
Export Success

PL/SQL procedure successfully completed.

+ '[' 'Export Success' '!=' '' ']'
+ grep -i 'Export Success' /opt/appworx/tmp/65162.tmp
Export Success
+ err=0
+ '[' 0 -ne 0 ']'
+ '[' -s /opt/appworx/tmp/65162.err ']'
+ rm /opt/appworx/tmp/65162.err
+ key_word=
+ echo Creating export file
Creating export file
+ set -
42 lines produced
+ '[' -f /opt/appworx/export/tmpTest.dat ']'
+ rm /opt/appworx/export/tmpTest.dat
+ /opt/appworx/c/sstrip /opt/appworx/export/Test.exp
++ cat /opt/appworx/export/Test.exp
++ wc -l
+ echo 42 lines produced
42 lines produced
+ '[' -f /opt/appworx/export/tmpTest.dat ']'
+ rm /opt/appworx/tmp/65162.err
+ rm /opt/appworx/tmp/65162.tmp
++ /opt/appworx/c/awdate 20230502134433
+ echo execute took 244 seconds
execute took 244 seconds

 

Environment

Release : 9.4.2

Resolution

Check the "Processing time" to see how long it took to run the sql portion of the Export. If the value is a high as the time it took to run the Export Job, the delay is the Database, and the issue may need to be reviewed by the DBA.

If the Process time is 0 or close to 0 meaning sql portion was very quick to finish, check the following directories for total directory size and file count:

$AW_HOME/exec
$AW_HOME/sql
$AW_HOME/tmp
$AW_HOME/run
$AW_HOME/export

If one or more directories contain a large amount of files or files that are large in size, this could cause a delay in read and write speed to these directories.

Review, move and/or deleted unneeded files.