Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Algorithm to load files efficiently without missing or accidently archiving....
Top Forums Shell Programming and Scripting Algorithm to load files efficiently without missing or accidently archiving.... Post 302599954 by agama on Sunday 19th of February 2012 02:54:58 PM
Old 02-19-2012
You could try something like this:

Code:
#!/usr/bin/env ksh
trap "rm -f /tmp/PID$$.*; exit" EXIT 2 3 15

incoming_dir=/path/of/incoming/directory

if ! cd $incoming
then
    echo "unable to switch to incoming directory"
    exit 1
fi

wrk_list=/tmp/PID$$.wrk
file_list=/tmp/PID$$.file
while true
do
    delay=300               # default to short delay
    find . -name "*done" >$wrk_list
    while read done_file                # find and process all done files
    do
        base=${done_file%%.*}
        find . -name "*${base##*_}*" >$file_list
        while read file
        do
            echo "put command(s) to load file into db here"
            delay=3600      # did work, sleep longer
        done <$file_list
    done <$wrk_list

    sleep $delay        # wait for (more) work
done

This will check for done files and wait 5 minutes between checks if it doesn't find any to work on. When it does find some work to do, it sleeps for 30 minutes before checking again -- assuming that it will be at least that long before another set of files is available, so there's not a need to check more frequentially immediately after doing some work.

The script will also handle more than one done file, so if the script isn't running when done files come in, it will do all of them that were waiting. If it is important to process the files in order, then you'll need to sort the list of done files accordingly.

BIG NOTE: I didn't test this script at all, so there might be typos, or other issues.
Last edited by agama; 02-19-2012 at 03:55 PM.. Reason: typo
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Archiving and moving the files

hi all i have a requirement where in i have to zip all the files with "*.bkp" after 14 days and move the zip files to Archive directory .... i am able to achieve the first functionality but not able to achive the second one ...here is my code find ${LOG_DIR} -name "*.bkp" -mtime +14 | xargs -i... (1 Reply)
Discussion started by: nvuradi
1 Replies

2. UNIX Desktop Questions & Answers

how to search files efficiently using patterns

hi friens, :) if i need to find files with extension .c++,.C++,.cpp,.Cpp,.CPp,.cPP,.CpP,.cpP,.c,.C wat is the pattern for finding them :confused: (2 Replies)
Discussion started by: arunsubbhian
2 Replies

3. Shell Programming and Scripting

Archiving the files

Hi, Suppose I have 2 files of yesterday's. And today I have received 3 files. Before processing anything I want to archieve the 2 files of yesterday's into a different folder. How can this be done? Regards, Sunitha (1 Reply)
Discussion started by: Sunitha_edi82
1 Replies

4. UNIX for Dummies Questions & Answers

Archiving and move files in the same time

Hi All, I have tried so many command but none work like i wanted. I would like archive which i assume it will move the files and archive it somewhere. for example: if i have a folder and files: /home/blah/test /home/blah/hello /home/blah/foo/bar i would like to archive folder... (6 Replies)
Discussion started by: c00kie88
6 Replies

5. Shell Programming and Scripting

Archiving the Files in a folder

My requirement is to put all the files from output directory(ATT) to archive directory(archive\) creating a new folder with datetimestamp(20100212_120014) every time it runs. where ${IMF_TARGET_DIR} is my base directory. ${IMF_ARCHIVE_DIR} is my Archive directory... (1 Reply)
Discussion started by: vsmeruga
1 Replies

6. Shell Programming and Scripting

Issue while archiving the files

Hi, In our current process we are reading the file, (which is placed by external vendor)from one particular folder and processing those files through ETL(informatica). We are reading these file as " ls -ltr *.txt" Once the process is finish these files are moved to archived script by "mv"... (1 Reply)
Discussion started by: Amey Joshi
1 Replies

7. UNIX for Dummies Questions & Answers

Archiving the files in a .txt file

HI , I have a file abc.txt, which has some .csv files listed. example. abc.txt 1.csv 2.csv 3.csv 4.csv 5.csv I want to move all the files listed in abc.txt to a archive directory,and zip the moved files. Can anyone help me with the script. Thanks,sai (1 Reply)
Discussion started by: saii
1 Replies

8. Shell Programming and Scripting

Archiving older files

Hello Group, I would request your help to build a shell script in order to find files older than 90 days then create the same directory structure under the second disk (/archive directory) and move the file preserving the same timestamps (ownership, etc). Also keep the log of files moved... (4 Replies)
Discussion started by: csierra
4 Replies

9. Shell Programming and Scripting

Archiving the files

hi, Am trying to acrhive a bunch of files on some ftp site and somehow managed to come out with the below logic. I'm getting "syntax error: unexpected end of file" error. Interestingly this below snipeet works fine if run for the first time but the subsequent runs fail! Anybody has any idea... (3 Replies)
Discussion started by: Amee5
3 Replies

10. Shell Programming and Scripting

Efficiently altering and merging files in perl

I have two files fileA HEADER LINE A CommentLine A Content A .... .... .... TAILER AfileB HEADER LINE B CommentLine B Content B .... .... .... TAILER BI want to merge these two files as HEADER LINE A CommentLine A Content A (4 Replies)
Discussion started by: sam05121988
4 Replies

LEARN ABOUT PHP

oci_set_module_name

OCI_SET_MODULE_NAME(3)													    OCI_SET_MODULE_NAME(3)

oci_set_module_name - Sets the module name

SYNOPSIS

       bool oci_set_module_name (resource  $connection, string	$module_name)

DESCRIPTION

	Sets the module name for Oracle tracing.

	The module name is registered with the database when the next 'roundtrip' from PHP to the database occurs, typically when an SQL statement
       is executed.

	The name can subsequently be queried from database administration views such as V$SESSION. It can be used for tracing and monitoring  such
       as with V$SQLAREA and DBMS_MONITOR.SERV_MOD_ACT_STAT_ENABLE.

	The value may be retained across persistent connections.

PARAMETERS

	      o $connection
		-An Oracle connection identifier, returned by oci_connect(3), oci_pconnect(3), or oci_new_connect(3).

	      o $module_name
		- User chosen string up to 48 bytes long.

RETURN VALUES

	Returns TRUE on success or FALSE on failure.

NOTES

       Note

	      Oracle version requirement

	      This function is available when PHP is linked with Oracle Database libraries from version 10 g onwards.

       Tip

	      Performance

	      With  older  versions of OCI8 or the Oracle Database, the client information can be set using the Oracle DBMS_APPLICATION_INFO pack-
	      age. This is less efficient than using oci_set_client_info(3).

       Caution

	      Roundtrip Gotcha

	      Some but not all OCI8 functions cause roundtrips. Roundtrips to the database may not occur  with	queries  when  result  caching	is
	      enabled.

EXAMPLES

       Example #1

	      Setting the module name

	      <?php

	      $c = oci_connect('hr', 'welcome', 'localhost/XE');

	      // Record the module
	      oci_set_module_name($c, 'Home Page');

	      // Code that causes a roundtrip, for example a query:
	      $s = oci_parse($c, 'select * from dual');
	      oci_execute($s);
	      oci_fetch_all($s, $res);

	      sleep(30);
	      ?>

	      // While the script is running, the administrator can see the
	      // modules in use:

	      sqlplus system/welcome
	      SQL> select module from v$session;

SEE ALSO

       oci_set_action(3), oci_set_client_info(3), oci_set_client_identifier(3).

PHP Documentation Group 												    OCI_SET_MODULE_NAME(3)
All times are GMT -4. The time now is 04:44 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy