Job is taking long time Post: 302482264

Sponsored Content

Top Forums UNIX for Dummies Questions & Answers Job is taking long time Post 302482264 by ajaykumarkona on Tuesday 21st of December 2010 05:48:38 AM

12-21-2010

Registered User

The script of the job like this.
Please help me

Code:

#!/bin/ksh               

. $HOME/.jobmanrc

. $pjc_bin_path/PJCEFUNCS    

JOBNAME wedsupvj APPLICATION=$wedb_app_name MAXCOND=01 AUTOSTART

export WEDB_EOM=N

LOADAPPVARIABLES $wedb_env_file  

JOB_PATH $wedb_path_file 

# ============================================================================
# ============================== JOB BEGIN ===================================
# ============================================================================
# ============================ STEP 005 BEGIN ================================
#
# STEP005 DESC Copy and rename the latest supervisor data file from the
# STEP005 DESC hrfiles directory
# STEP005 DESC 
#
# ----------------------------------------------------------------------------
#
STEP_EXECUTE STEP005 cp $WEDB_DATA/hrfiles/SUPV.* $WEDB_DATA/SUPV

STEP_END
#
# ============================= STEP 005 END =================================
#
# ============================ STEP 010 BEGIN ================================
#
# STEP010 DESC    This step truncates the supervisor table
# STEP010 DESC   
#
# ----------------------------------------------------------------------------
#
STEP_EXECUTE STEP010 sqlplus / @$WEDB_SQL/trunc_tab.sql `cat $WEDB_CTL/wedb_load_owner.lst`

STEP_END
# ============================= STEP 010 END =================================
#
# ============================ STEP 015 BEGIN ================================
#
# STEP015 DESC Updates the supervisor table in the daily database
# STEP015 DESC 
#
# ----------------------------------------------------------------------------
#
STEP_EXECUTE STEP015  sqlplus / @$WEDB_SQL/load_supv.sql SUPV $WEDB_DATA

STEP_END
#
# ============================= STEP 015 END =================================
#
# ============================================================================
JOB_END  
# =============================== JOB END ====================================
#                             ENDJOB wedsupvj
# ============================================================================

Last edited by Scott; 12-21-2010 at 07:02 AM.. Reason: Please use code tags

ajaykumarkona

View Public Profile for ajaykumarkona

Find all posts by ajaykumarkona

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

fetchmail taking long time to fetchmail...

Hi peeps, We are having around 60 users. The time set to retrieve the mail is 300 sec. But it's taking around 1 hour to deliver mails. I am using debian sarge 3.1. any clues? And how it will affect if I decrease the time? My machine has got 1 p4 3.0 GHZ processor and 1 GB ram. The home...

2. Red Hat

login process taking a long time

I'm having a bit of a login performance issue.. wondering if anyone has any ideas where I might look. Here's the scenario... Linux Red Hat ES 4 update 5 regardless of where I login from (ssh or on the text console) after providing the password the system seems to pause for between 30...

3. Shell Programming and Scripting

For Loop Taking Too Long

I'm new from UNIX scripting. Please help. I have about 10,000 files from the $ROOTDIR/scp/inbox/string1 directory to compare with the 50 files from /$ROOTDIR/output/tma/pnt/bad/string1/ directory and it takes about 2 hours plus to complete the for loop. Is there a better way to re-write the...

4. Shell Programming and Scripting

<AIX>Problem in purge script, taking very very long time to complete 18.30hrs

Hi, I have here a script which is used to purge older files/directories based on defined purge period. The script consists of 45 find commands, where each command will need to traverse through more than a million directories. Therefore a single find command executes around 22-25 mins...

5. UNIX for Dummies Questions & Answers

gref -f taking long time for big file

grep -f taking long time to compare for big files, any alternate for fast check I am using grep -f file1 file2 to check - to ckeck dups/common rows prsents. But my files contains file1 contains 5gb and file 2 contains 50 mb and its taking such a long time to compare the files. Do we have any...

6. Solaris

Re-sync Taking Extremely Long.

It's almost 3 days now and my resync/re-attach is only at 80%. Is there something I can check in Solaris 10 that would be causing the degradation. It's only a standby machine. My live system completed in 6hrs.

7. Solaris

How to find out bottleneck if system is taking long time in gzip

Dear All, OS = Solaris 5.10 Hardware Sun Fire T2000 with 1 Ghz quode core We have oracle application 11i with 10g database. When ever i am trying to take cold backup of database with 55GB size its taking long time to finish. As the application is down nobody is using the server at all...

8. UNIX for Dummies Questions & Answers

ls is taking long time to list

Hi, All the data are kept on Netapp using NFS. some directories are so fast when doing ls but few of them are slow. After doing few times, it becomes fast. Then again after few minutes, it becomes slow again. Can you advise what's going on? This one directory I am very interested is giving...

9. UNIX and Linux Applications

From past 10 days my one job is taking lots of time

One of my job is taking long running time. I need to identify from the unix log file can you please help how to troubleshoot.

10. Shell Programming and Scripting

Rm -rf is taking very long, will it timeout?

I have so many (hundreds of thousands) files and directories within this one specific directory that my "rm -rf" command to delete them has been taking forever. I did this via the SSH, my question is: if my SSH connection times out before rm -rf finishes, will it continue to delete all of those...

LEARN ABOUT DEBIAN

perl::critic::policy::controlstructures::prohibitlabelswithspeci

Perl::Critic::Policy::ControlStructures::ProhibitLabelsWUserpContPerl::Critic::Policy::ControlStructures::ProhibitLabelsWithSpecialBlockNames(3pm)

NAME

       Perl::Critic::Policy::ControlStructures::ProhibitLabelsWithSpecialBlockNames - Don't use labels that are the same as the special block
       names.

AFFILIATION

       This Policy is part of the core Perl::Critic distribution.

DESCRIPTION

       When using one of the special Perl blocks "BEGIN", "END", "CHECK", "INIT", and "UNITCHECK", it is easy to mistakenly add a colon to the end
       of the block name.  E.g.:

	   # a BEGIN block that gets executed at compile time.
	   BEGIN { <...code...> }

	   # an ordinary labeled block that gets executed at run time.
	   BEGIN: { <...code...> }

       The labels "BEGIN:", "END:", etc. are probably errors.  This policy prohibits the special Perl block names from being used as labels.

CONFIGURATION

       This Policy is not configurable except for the standard options.

SEE ALSO

       The Perl Buzz article on this issue at http://perlbuzz.com/2008/05/colons-invalidate-your-begin-and-end-blocks.html
       <http://perlbuzz.com/2008/05/colons-invalidate-your-begin-and-end-blocks.html>.

ACKNOWLEDGMENT

       Randy Lauen for identifying the problem.

AUTHOR

       Mike O'Regan

COPYRIGHT

       Copyright (c) 2008-2011 Mike O'Regan.  All rights reserved.

       This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself.

perl v5.14.2							 Perl::Critic::Policy::ControlStructures::ProhibitLabelsWithSpecialBlockNames(3pm)

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

fetchmail taking long time to fetchmail...

Discussion started by: squid04

2. Red Hat

login process taking a long time

Discussion started by: retlaw

3. Shell Programming and Scripting

For Loop Taking Too Long

Discussion started by: hanie123

4. Shell Programming and Scripting

<AIX>Problem in purge script, taking very very long time to complete 18.30hrs

Discussion started by: sravicha