Does anyone have an example of a ksh script that executes a Sybase stored procedure, via the ISQL command, and can detect a deadlock and loop until the process completes successfully? I'm a little confused on where to start.
Thanks in advance for any assistance you can provide.
I want the tomcat to restart when java goes 100% cpu utilize and remain on this , Get pid kill and start tomcat .
top | grep java
We can get pid and cpu utilize , But how can we do on run time.
Please use code tags as required by forum rules! (1 Reply)
Hey, for the purpose of a research project I need to know if a specific type of parallel processing is being utilized by any user-run programs. Is there a way to detect whether a program either returns a value to another program at the end of execution, or just utilizes any form of parallel... (4 Replies)
I'm becoming a dying breed where I work. More and more sys admins are advocating automatically restarting failed services such as tomcat, jboss, etc. I've always been against doing this except with buggy apps that can't be fixed or avoided.
My main argument is that I feel it's a trick used by... (9 Replies)
I have a service that are not 100% stable and stops from time to time.
So I have a script that do restart the service if it does not run.
This script works win on Ubuntu 9.04 but will not start the service in Ubuntu 10.10
If I run the part that do starts the service from CLI, it starts... (2 Replies)
Hi All,
May i please know if it is possible to write a script to check the log messages and automatically restart a service if it is failed or it is stopped.
Appreciate your suggestions.
Thanks in advance.
regards,
Eajaz (2 Replies)
hellou, can anybody help me with nat detection in real time ? i prefer some detection script because i try some nat detection program's for example p0f or i'm using tcpdump, but i would get contain of specific packet. Some ideas? (1 Reply)
How to get information that where is my modem configured in /dev.
I have two modems configured in my device .. one is USB and other is PCI modem.. USB is detected as /dev/USB0. but how to see about PCI modem? (0 Replies)
Apache::Session::Store::Sybase(3pm) User Contributed Perl Documentation Apache::Session::Store::Sybase(3pm)NAME
Apache::Session::Store::Sybase - Store persistent data in a Sybase database
SYNOPSIS
use Apache::Session::Store::Sybase;
my $store = new Apache::Session::Store::MySQL;
$store->insert( $ref );
$store->update( $ref );
$store->materialize( $ref );
$store->remove( $ref );
DESCRIPTION
Apache::Session::Store::Sybase fulfills the storage interface of Apache::Session. Session data is stored in a Sybase database.
SCHEMA
To use this module, you will need at least these columns in a table called 'sessions':
id CHAR(32) # or however long your session IDs are.
a_session IMAGE
To create this schema, you can execute this command using the isql or sqsh programs:
CREATE TABLE sessions (
id CHAR(32) not null primary key,
a_session TEXT
)
go
If you use some other command, ensure that there is a unique index on the id column of the table
CONFIGURATION
The module must know what datasource, username, and password to use when connecting to the database. These values can be set using the
options hash (see Apache::Session documentation). The options are:
DataSource
UserName
Password
Example:
tie %hash, 'Apache::Session::Sybase', $id, {
DataSource => 'dbi:Sybase:database=db;server=server',
UserName => 'database_user',
Password => 'K00l',
Commit => 1,
};
Instead, you may pass in an already-opened DBI handle to your database.
tie %hash, 'Apache::Session::Sybase', $id, {
Handle => $dbh
};
Additional arguments you can pass to the backing store are:
Commit - whether we should commit any changes; if you pass in an already-open database handle that has AutoCommit set to a true value, you
do not need to set this. If you let Apache::Session::Store::Sybase create your database, handle, you must set this to a true value,
otherwise, your changes will not be saved
textsize - the value we should pass to the 'set textsize ' command that sets the max size of the IMAGE field. Default is 32K (at least in
Sybase ASE 11.9.2).
AUTHOR
This module was based on Apache::Session::Store::Oracle which was written by Jeffrey William Baker <jwbaker@acm.org>; it was modified by
Chris Winters <chris@cwinters.com> to work with Apache::Session 1.5+ with changes from earlier version of Apache::Session::DBI::Sybase from
Mark Landry <mdlandry@lincoln.midcoast.com>.
SEE ALSO
Apache::Session
perl v5.10.1 2010-10-18 Apache::Session::Store::Sybase(3pm)
