Job is taking long time


 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers Job is taking long time
# 1  
Old 12-18-2010
Job is taking long time

Hi ,

We have 20 jobs are scheduled.
In that one of our job is taking long time ,it's not completing.
If we are not terminating it's running infinity time actually the job completion time is 5 minutes.
The job is deleting some records from the table and two insert statements and one select statement.All the SQL statements are executed properly.And the log file is created.
But the job is not completing.
We can manually kill that job.But how can we make the automated process to make that job complete .
We are facing serious problem,because some other jobs are dependent on that job.

Please help me.

Thanks in advance.
# 2  
Old 12-19-2010
What code is actually run on the server? And what OS and DBSM is involved? You might be able to trace it, see what system call it's blocking on...
# 3  
Old 12-19-2010
This sounds like a record deadlock. Another process has the table record locked for update, your process is waiting for the record to be given up, so it can delete the record. A DBA can get into the db, and trace what processes have the record open.
You have to supply the table name(s).
# 4  
Old 12-21-2010
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 08:02 AM.. Reason: Please use code tags
# 5  
Old 12-21-2010
As jim mcnamara told, there might be deadlock on one or more tables used by this script that can be checked by DBA.
OR may be you are running sql script but not quiting at the end in sql script.
You may add some debug statements in above script at different steps (echo statements) and see at which point this script is stopping, that may give some clue.
# 6  
Old 12-21-2010
But it is completing automatically sometimes.
# 7  
Old 12-21-2010
Then there should not be any issue with sql script.
Table lock is one possibility.
Would be better to put debug statements in script (create some log) and check log when script doesn't complete.
 
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. 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... (5 Replies)
Discussion started by: phpchick
5 Replies

2. 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. (1 Reply)
Discussion started by: Nsharma3006
1 Replies

3. 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... (3 Replies)
Discussion started by: samnyc
3 Replies

4. 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 Replies)
Discussion started by: yoojamu
8 Replies

5. 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. (9 Replies)
Discussion started by: ravzter
9 Replies

6. 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... (10 Replies)
Discussion started by: gkskumar
10 Replies

7. 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... (7 Replies)
Discussion started by: sravicha
7 Replies

8. 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... (5 Replies)
Discussion started by: hanie123
5 Replies

9. 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... (4 Replies)
Discussion started by: retlaw
4 Replies

10. 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 Replies)
Discussion started by: squid04
2 Replies
Login or Register to Ask a Question

Featured Tech Videos