The Perl Toolchain Summit needs more sponsors. If your company depends on Perl, please support this very important event.

NAME

orac_Informix.pm - the Informix module to the Orac tool

DESCRIPTION

This code is a database object that can be created by the Orac tool. It inherits from orac_Base, which has all the basic data and methods. Some of those are called from here, some are overridden, most are inherited and used as is.

PUBLIC METHODS

 &new()
 &init1()
 &init2()

new

This method overrides orac_Base's; well, actually we call it to set ourselves up, but then we do set Informix specific variables. We return the new object instance, just like we're supose to do.

init1

This methode overrides the "do nothing" version in orac_Base. It's job is to do whatever we need to do just before trying to connect. We return nothing.

init1

This methode overrides the "do nothing" version in orac_Base. It's job is to do whatever we need to do just after successfully connecting to the database. In our case, we always ChopBlanks. We return nothing.

SEMI-PUBLIC METHODS

These should only be called by main:: functions, like the menu functions, or by ourselves, obviously. :-)

onstat_databases

Show the list of the databases, and info about them. No args, no return value.

onstat_dbspaces

Show the list of DBSpaces, and info about them. No args, no return value.

onstat_chunks

Show the list of DB chunks, and info about them. No args, no return value.

onstat_onconfig_params

Show the current $ONCONFIG file. No args, no return value.

dbschema_syns

Show the synonums for all tables. No args, no return value.

dbschema_grants

Show the grants on this database. No args, no return value.

dbschema_indices

Show the list of the indicies for all tables, and info about them. No args, no return value.

NOT IMPLEMENTED YET!

dbschema_schema

Show the schema for the databases. No args, no return value.

NOT IMPLEMENTED YET!

onstat_threads

Show the application threads running in the database. No args, no return value.

NOT IMPLEMENTED YET!

onstat_curr_sql

Show the current SQL statements running in the database. No args, no return value.

NOT IMPLEMENTED YET!

onstat_blobs

Show the list of blob fields, and info about them. No args, no return value.

onstat_io_profile

Show the I/O going on in the database. No args, no return value.

onstat_locks_held

Show the list of locks being held, and info about them, by: database, owner, table. It calls live_update() until the user hits STOP. No args, no return value.

onstat_tblspace_info

Show what's going on in the table space arena. It calls live_update() until the user hits STOP. No args, no return value.

onstat_sessions

Show who's connected? It calls live_update() until the user hits STOP. No args, no return value.

PRIVATE METHODS

These should only be called ourself, they are support functions. There are currently none, or at least none that care to tell anyone about. :-)

post_process_sql

This subroutine is called with the results from show_sql() (or live_update) to allow DB modules to "post process" the output, if required, before it is analyzed to be shown. This is useful for turning numeric flags into words, and other such DB dependent things.

EXPERIMENTAL METHODS

These functions are ones that I'm developing and should not be called by anyone else, unless you like living dangerously. :-) It is hoped that one day, they'll be good enough to move into orac_Base.

 None for now...they've been moved!

# Andy, you can move this if you want. (i.e. feel brave :-)