/ 
Ingres-Utility-IIMonitor-0.10
River stage zero No dependents
/ Ingres::Utility::IIMonitor

NAME

Ingres::Utility::IIMonitor - API to IIMONITOR Ingres utility for IIDBMS servers control

VERSION

Version 0.10

SYNOPSIS

use Ingres::Utility::IIMonitor;

# create a connection to an IIDBMS server
# (server id can be obtained through Ingres::Utility::IINamu)
$foo = Ingres::Utility::IIMonitor->new($serverid);

# showServer() - shows server status
#
# is the server listening to new connections? (OPEN/CLOSED)
$status =$foo->showServer('LISTEN');
#
# is the server being shut down?
$status =$foo->showServer('SHUTDOWN');

# setServer() - sets server status
#
# stop listening to new connections
$status =$foo->setServer('CLOSED');
#
# start shutting down (wait for connections to close)
$status =$foo->setServer('SHUT');

# stop() - stops IIDBMS server (transactions rolled back)
#
$ret = $foo->stop();

DESCRIPTION

This module provides an API to the iimonitor utility for Ingres RDBMS, which provides local control of IIDBMS servers and sessions (system and user conections).

FUNCTIONS

new($serverId)

Connects to an IIDBMS server.

Takes the server id as argument to identify which server to control.

The server id can be obtained through Ingres::Utility::IINamu module.

showServer($serverStatus)

Returns the server status.

Takes the server status to query:

LISTEN = server listening to new connections

SHUTDOWN = server waiting for connections to close to end process.

Returns 'OPEN', 'CLOSED' or 'PENDING' (for shutdown).

setServer

Changes the server status to the state indicated by the argument:

SHUT = server will shutdown after all connections are closed

CLOSED = stops listening to new connections

OPEN = reestablishes listening to new connections

stopServer

Stops server immediatly, rolling back transactions and closing all connections.

DIAGNOSTICS

Ingres environment variable II_SYSTEM not set

Ingres environment variables should be set in the user session running this module. II_SYSTEM provides the root install dir (the one before 'ingres' dir). LD_LIBRARY_PATH too. See Ingres RDBMS docs.

Ingres utility cannot be executed: _COMMAND_FULL_PATH_

The IIMONITOR command could not be found or does not permits execution for the current user.

invalid status: _SERVER_STATUS_PARAM_

The setServer() method received an invalid argument. Should be LISTEN, SHUTDOWN or let void.

CONFIGURATION AND ENVIRONMENT

Requires Ingres environment variables, such as II_SYSTEM and LD_LIBRARY_PATH.

See Ingres RDBMS documentation.

DEPENDENCIES

Expect::Simple

INCOMPATIBILITIES

None reported.

BUGS AND LIMITATIONS

No bugs have been reported.

Please report any bugs or feature requests to bug-ingres-utility-iimonitor at rt.cpan.org, or through the web interface at http://rt.cpan.org.

SUPPORT

You can find documentation for this module with the perldoc command.

perldoc Ingres::Utility::IIMonitor

You can also look for information at:

ACKNOWLEDGEMENTS

Thanks to Computer Associates (CA) for licensing Ingres as open source, and let us hope for Ingres Corp to keep it that way.

AUTHOR

Joner Cyrre Worm <FAJCNLXLLXIH at spammotel.com>

LICENSE AND COPYRIGHT

Copyright (c) 2006, Joner Cyrre Worm <FAJCNLXLLXIH at spammotel.com>. All rights reserved.

Ingres is a registered brand of Ingres Corporation.

This module is free software; you can redistribute it and/or modify it under the same terms as Perl itself. See perlartistic.

DISCLAIMER OF WARRANTY

BECAUSE THIS SOFTWARE IS LICENSED FREE OF CHARGE, THERE IS NO WARRANTY FOR THE SOFTWARE, TO THE EXTENT PERMITTED BY APPLICABLE LAW. EXCEPT WHEN OTHERWISE STATED IN WRITING THE COPYRIGHT HOLDERS AND/OR OTHER PARTIES PROVIDE THE SOFTWARE "AS IS" WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESSED OR IMPLIED, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. THE ENTIRE RISK AS TO THE QUALITY AND PERFORMANCE OF THE SOFTWARE IS WITH YOU. SHOULD THE SOFTWARE PROVE DEFECTIVE, YOU ASSUME THE COST OF ALL NECESSARY SERVICING, REPAIR, OR CORRECTION.

IN NO EVENT UNLESS REQUIRED BY APPLICABLE LAW OR AGREED TO IN WRITING WILL ANY COPYRIGHT HOLDER, OR ANY OTHER PARTY WHO MAY MODIFY AND/OR REDISTRIBUTE THE SOFTWARE AS PERMITTED BY THE ABOVE LICENCE, BE LIABLE TO YOU FOR DAMAGES, INCLUDING ANY GENERAL, SPECIAL, INCIDENTAL, OR CONSEQUENTIAL DAMAGES ARISING OUT OF THE USE OR INABILITY TO USE THE SOFTWARE (INCLUDING BUT NOT LIMITED TO LOSS OF DATA OR DATA BEING RENDERED INACCURATE OR LOSSES SUSTAINED BY YOU OR THIRD PARTIES OR A FAILURE OF THE SOFTWARE TO OPERATE WITH ANY OTHER SOFTWARE), EVEN IF SUCH HOLDER OR OTHER PARTY HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES.