Hi all,
I have large daily log file(s) that hold the times for requests and responses on different system requests. What I want to do is work out average transaction times for the day (one log = one day).
The problem I'm having is figuring out how to skip rows, i've sorted the output by uniq... (2 Replies)
We are getting below error when processing a transaction through ESB.
I work for SOA admin and checked the JCA connection is working fine also code also working fine in other envs.
An unhandled exception has been thrown in the ESB system. The exception reported is:... (1 Reply)
HI,
Can anyone explain me the concept behind ZFS transactional semantics (either a transaction is entirely commited or it is not)? so data and disk failures are reduced. (5 Replies)
Can some one help me related to .sql file issue.
I have a .sqlfile and tried to read the file thru unix. In the .sqlfile I have error rows as well and when error comes I dont want to proceed further and need to roll back all the transactions.
sample .sql file below
insert into
test... (2 Replies)
Hi ,
I have a situation where I have to Process files ( move , edit or rename ) in a folder ..... This folder is a FTP folder and Files keep coming in when they are available ... So I should perform my actions on those which which completed transaction .. .
Is there a way to identify a... (3 Replies)
How do I determine the resources needed based on volume of transactions. By resources I mean, the cores, memory etc. Is there a way to arrive at that value? (1 Reply)
Discussion started by: ggayathri
1 Replies
LEARN ABOUT REDHAT
start_transaction
START TRANSACTION(7) SQL Commands START TRANSACTION(7)NAME
START TRANSACTION - start a transaction block
SYNOPSIS
START TRANSACTION [ ISOLATION LEVEL { READ COMMITTED | SERIALIZABLE } ]
INPUTS
None.
OUTPUTS
START TRANSACTION
Message returned if successful.
WARNING: BEGIN: already a transaction in progress
If there is already a transaction in progress when the command is issued.
DESCRIPTION
This command begins a new transaction. If the isolation level is specified, the new transaction has that isolation level. In all other
respects, the behavior of this command is identical to the BEGIN [begin(7)] command.
NOTES
The isolation level of a transaction can also be set with the SET TRANSACTION [set_transaction(7)] command. If no isolation level is speci-
fied, the default isolation level is used.
COMPATIBILITY
SQL99
SERIALIZABLE is the default isolation level in SQL99, but it is not the usual default in PostgreSQL: the factory default setting is READ
COMMITTED. PostgreSQL does not provide the isolation levels READ UNCOMMITTED and REPEATABLE READ. Because of lack of predicate locking,
the SERIALIZABLE level is not truly serializable. See the User's Guide for details.
In SQL99 this statement can specify two other properties of the new transaction: whether the transaction is read-only and the size of the
diagnostics area. Neither of these concepts are currently supported in PostgreSQL.
SQL - Language Statements 2002-07-26 START TRANSACTION(7)