You may delete the records in Table2 first where the common columns in two Tables are matched and condition on date field of first table is satisfied.
(I'm not sure with the DB2 would accept exactly the same, but u can try something like this)
After this table1 records may be deleted with the date_id condition
Last edited by Prasad Rao; 08-27-2013 at 10:54 AM..
This User Gave Thanks to Prasad Rao For This Post:
Hello everybody.
Actually I would like to ask you who can I make delete commend by shell script to delete some files from anywhere in my director and send it to specific place but whit the PATH because if want to restore it will return to the original place which I delete it from (As recycle pan... (7 Replies)
I have a local linux machine in which the files are dumped by a remote ubuntu server. If the process in remote server has any problem then empty files are created in local machine. Is there any way using perl script to check if the empty files are being created and delete them and then run a shell... (2 Replies)
Hi User,
I have a text file with a lot of customer records (over 10,000). Each record contained one field called "charge" and it must start with some space (each record may have 15 space, 17 spece, 9 space,etc, then start with <charge> and end with </charge>, in between is a value.
How can I... (3 Replies)
Hi
I need a script that will remove the contents out of a common named folder on our server and all its contents.
We have folder called temp which resides within several different folders and i need to delete the contents at a set time in the night
thanks
Treds (7 Replies)
Hi,
I have a requirement like,
I need to create the directory with date and time stap (i.e YYYYMMDDHMS) every day end need to delete the old directories which is 12 months old. I have tested with following script
cd /export/home/sbeeravo/; find . -type d -mtime +365 -exec rm -rf {} \;
... (2 Replies)
Hi,
I want to delete files that are older than 60 days.... i need to execute the script in 7 differnt folders.... i can run the script in crontab to regularly check....
I am struck @ finding out how the file is 60 days old or not...
Can u please help me on this?
Thanks,
NithZ (6 Replies)
ENVIROMENT
Linux: Fedora Core release 1 (Yarrow)
iPlanet: iPlanet-WebServer-Enterprise/6.0SP1
Log Path: /usr/iplanet/servers/https-company/logs
I have iPlanet log rotation enabled rotating files on a daily basis.
The rotated logs are NOT compressed & are taking up too much space.
I... (7 Replies)
Friends, I had written a small script to delete files from deletefiles.txt file. However, I want to add one more piece to script, so as to check if the file(file abc) which was already deleted earlier exists in 'deletefiles.txt' file, script should comment out that "file abc doesnt exist". Can... (5 Replies)
Hi
My directory structure is as below.
dir1, dir2, dir3
I have the list of files to be deleted in the below path as below.
/staging/retain_for_2years/Cleanup/log $ ls -lrt
total 0
drwxr-xr-x 2 nobody nobody 256 Mar 01 16:15 01-MAR-2015_SPDBS2
drwxr-xr-x 2 root ... (2 Replies)
Hi All,
Do you have any sample script,
- auto get file from SFTP remote server and delete file in remove server after downloaded.
- only download specify filename
- auto upload file from local to SFTP remote server and delete local folder file after uploaded
- only upload specify filename
... (3 Replies)
Discussion started by: weesiong
3 Replies
LEARN ABOUT LINUX
imqdbmgr
imqdbmgr(1M) System Administration Commands imqdbmgr(1M)NAME
imqdbmgr - manage a plugged-in JDBC-compliant Message Queue data store
SYNOPSIS
/usr/bin/imqdbmgr subcommand argument [ [option...]]
/usr/bin/imqdbmgr -h | -help
/usr/bin/imqdbmgr -v | -version
DESCRIPTION
The imqdbmgr utility creates and manages a Java DataBase Connectivity (JDBC) compliant database used for Message Queue persistent storage.
The database can be either embedded or external. To use a JDBC-compliant database (and the imdbmgr utility), you need to first set a number
of JDBC-related properties in the broker instance configuration file. See the Sun Java System Message Queue Administrator's Guide for addi-
tional information.
imqdbmgr supports four management subcommands. These subcommands, and their corresponding arguments and options follow the imqdbmgr command
on the command line. See USAGE and OPTIONS.
The following subcommands are supported:
create
Create a Message Queue database schema.
delete
Delete Message Queue database tables in the current data store.
recreate
Delete Message Queue database tables and recreate Message Queue database schema in the curent data store.
reset
Reset the database table lock to allow other processes to access database tables.
The imqdbmgr subcommands support the following arguments:
all
Indicates the subcommand applies to the data store, as well as the database tables.
lck
Indicates the subcommand applies to the database table lock.
oldtbl
Indicates the subcommand applies to an older version of the database tables.
tbl
Indicates the subcommand applies to the database tables only.
OPTIONS
The following options are supported:
-b brokerName Specify the broker instance name and corresponding instance configuration properties. If this option is not speci-
fied, the default broker instance is assumed.
Use this option with the create, delete, recreate, or reset subcommands.
-D property=value Set system property property to value.
Use this option with the create, delete, recreate, or reset subcommands.
-h | -help Display usage help. Execute nothing else on the command line.
-p password Specify the database password.
Use this option with the create, delete, recreate, or reset subcommands.
-u userName Specify the database user name.
Use this option with the create, delete, recreate, or reset subcommands.
-v | -version Display version information. Execute nothing else on the command line.
USAGE
The following subcommands and associated arguments are supported:
create all
Create a new embedded data store and Message Queue database schema for a specified or default broker instance.
create tbl [-u userName] [-p password]
Create Message Queue database schema in an existing data store for a specified or default broker instance.
delete tbl [-u userName] [-p password]
Delete Message Queue database tables in the current data store for a specified or default broker instance.
delete oldtbl [-u userName] [-p password]
Delete the earlier version of Message Queue database tables. Used after the data store has been automatically migrated to the current
version of Message Queue.
recreate tbl [-u userName] [-p password]
Delete Message Queue database tables and recreate Message Queue database schema in the current data store for a specified or default
broker instance.
reset lck
Reset the database table lock to allow other processes to access database tables.
ENVIRONMENT VARIABLES
The following environment variables affect the execution of this command:
IMQ_JAVAHOME Specify the Java 2 compatible runtime. When this environment variable is not set it defaults to /usr/j2se.
EXIT STATUS
The following exit values are returned:
0 Successful completion.
>0 An error occurred.
FILES
/var/imq/instances/brokerName/dbstore
Recommended directory in which to create an embedded database.
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+-----------------------------+-----------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+-----------------------------+-----------------------------+
|Availability |SUNWiqu |
+-----------------------------+-----------------------------+
SEE ALSO imqadmin(1M), imqbrokerd(1M), imqcmd(1M), imqusermgr(1M), imqkeytool(1M), imqobjmgr(1M), attributes(5)
Sun Java System Message Queue Administrator's Guide
SunOS 5.10 29 Mar 2004 imqdbmgr(1M)