06-15-2005
...or you could use something like a semaphore. Keep a status flag in an OS table for all of your processes to check. When one updates this to say that a failure occurred, start rolling back.
If you are periodically committing records, then use some kind of common batch update identifier in your table. This will help you delete all records common to the batch. If you can't add columns to the table that you are loading, create a new table that keeps key values of records that you are working with.
Thomas
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi all
I am facing some problem taking INCREMENTAL Back up of file systems...........Actually i have mounted the file system of one server in another server..as i don't have tape drive in both servers...............i am using HPUX(L class and C class)servers..
can any one help me ... (1 Reply)
Discussion started by: Prafulla
1 Replies
2. UNIX for Dummies Questions & Answers
Hi..
I am using HP UX 11.0
i want to make automated back up from SAM back up tool....
so i mentioned the file systems and back up device /dev/rmt/0m and time 0:00 and days of the week........
but it was not successful.....the back up job was not started on specified time.....
i am in... (7 Replies)
Discussion started by: Prafulla
7 Replies
3. UNIX for Advanced & Expert Users
Hi ALL:
I am not able to get the response back from weblogic in the shell script.
The weblogic server in different account. I am able to login to that account and bring the server up but while doing a ping, the script is failing. While the same script is running fine if I run it on the account... (1 Reply)
Discussion started by: splax
1 Replies
4. UNIX for Advanced & Expert Users
I have a p570 server with 2 LPARs on it. One of my colleagues did a firmware upgrade on it over the weekend but I have not been able to bring it back online since.
I go to activate the partition from the HMC and it gets stuck on the C20082FF operator panel and just freezes from there.
Does... (2 Replies)
Discussion started by: KeesH
2 Replies
5. Shell Programming and Scripting
Hi,
I am trying to figure out if there is a way to make linux take me back to the previous directory I was working in. For instance, I am in
/home/username/directory1
Then if I cd into /home/username/directory1/temp1/temp2/temp3
I would like to immediately go back to the previous... (2 Replies)
Discussion started by: Legend986
2 Replies
6. Solaris
What is the easiest or preferred way to roll back the solaris cluster patches?
My guess is to do a flash archive pre-patch and then install off of that if it doesn't work.
Any other ideas? (4 Replies)
Discussion started by: adelsin
4 Replies
7. Solaris
Is there an easy way to roll back or uninstall the latest Solaris patch cluster? I'm hoping I don't have to go into each patch that was applied and uninstall them one-by-one.
Thanks! (0 Replies)
Discussion started by: bluescreen
0 Replies
8. Red Hat
Hi,
I want to roll back the packages that are installed during the patch installation of RHEL 5 server. There are in all 110 packages including the kernel package...
kernel-2.6.18-274.el5.x86_64.rpm
kernel-headers-2.6.18-274.el5.x86_64.rpm
How should I proceed ?
I don't want to run rpm... (4 Replies)
Discussion started by: aksijain
4 Replies
9. Shell Programming and Scripting
Hi
is there any shell script to roll back the code when the code is deployed in a wrong way in production servers (3 Replies)
Discussion started by: Purushotham
3 Replies
10. Homework & Coursework Questions
Use and complete the template provided. The entire template must be completed. If you don't, your post may be deleted!
1. The problem statement, all variables and given/known data:
Print out problem with line follow:
echo There are '$cat $fname | wc -l' contacts in database
how do I replace... (2 Replies)
Discussion started by: scopiop
2 Replies
LEARN ABOUT PHP
odbc_foreignkeys
ODBC_FOREIGNKEYS(3) 1 ODBC_FOREIGNKEYS(3)
odbc_foreignkeys - Retrieves a list of foreign keys
SYNOPSIS
resource odbc_foreignkeys (resource $connection_id, string $pk_qualifier, string $pk_owner, string $pk_table, string $fk_qualifier,
string $fk_owner, string $fk_table)
DESCRIPTION
Retrieves a list of foreign keys in the specified table or a list of foreign keys in other tables that refer to the primary key in the
specified table
PARAMETERS
o $connection_id
-The ODBC connection identifier, see odbc_connect(3) for details.
o $pk_qualifier
- The primary key qualifier.
o $pk_owner
- The primary key owner.
o $pk_table
- The primary key table.
o $fk_qualifier
- The foreign key qualifier.
o $fk_owner
- The foreign key owner.
o $fk_table
- The foreign key table.
RETURN VALUES
Returns an ODBC result identifier or FALSE on failure.
The result set has the following columns:
oPKTABLE_QUALIFIER
oPKTABLE_OWNER
oPKTABLE_NAME
oPKCOLUMN_NAME
oFKTABLE_QUALIFIER
oFKTABLE_OWNER
oFKTABLE_NAME
oFKCOLUMN_NAME
oKEY_SEQ
oUPDATE_RULE
oDELETE_RULE
oFK_NAME
oPK_NAME
If $pk_table contains a table name, odbc_foreignkeys(3) returns a result set containing the primary key of the specified table and all of
the foreign keys that refer to it.
If $fk_table contains a table name, odbc_foreignkeys(3) returns a result set containing all of the foreign keys in the specified table and
the primary keys (in other tables) to which they refer.
If both $pk_table and $fk_table contain table names, odbc_foreignkeys(3) returns the foreign keys in the table specified in $fk_table that
refer to the primary key of the table specified in $pk_table. This should be one key at most.
PHP Documentation Group ODBC_FOREIGNKEYS(3)