Import from CVSHEADmaster

12 files changed, 2112 insertions, 0 deletions

diff --git a/RDBMS-MIB_src/rdbmsRelTable/rdbmsRelTable.c b/RDBMS-MIB_src/rdbmsRelTable/rdbmsRelTable.c
new file mode 100644
index 0000000..a911d5d
--- /dev/null
+++ b/RDBMS-MIB_src/rdbmsRelTable/rdbmsRelTable.c
@@ -0,0 +1,130 @@
+/*-------------------------------------------------------------------------
+ * rdbmsRelTable.c
+ *
+ *      RDBMSMIB mib module.
+ *
+ *      Copyright (c) 2004-2007, PostgreSQL Global Development Group
+ *      Author: Joshua Tolley
+ *
+ * $Id: rdbmsRelTable.c,v 1.2 2007/09/13 14:20:44 h-saito Exp $
+ *
+ *-------------------------------------------------------------------------
+ */
+
+/* standard Net-SNMP includes */
+#include <net-snmp/net-snmp-config.h>
+#include <net-snmp/net-snmp-includes.h>
+#include <net-snmp/agent/net-snmp-agent-includes.h>
+
+/* include our parent header */
+#include "rdbmsRelTable.h"
+
+#include <net-snmp/agent/mib_modules.h>
+
+#include "rdbmsRelTable_interface.h"
+
+oid rdbmsRelTable_oid[] = { RDBMSRELTABLE_OID };
+int rdbmsRelTable_oid_size = OID_LENGTH(rdbmsRelTable_oid);
+
+void initialize_table_rdbmsRelTable(void);
+
+
+/**
+ * Initializes the rdbmsRelTable module
+ */
+void
+init_rdbmsRelTable(void)
+{
+    DEBUGMSGTL(("verbose:rdbmsRelTable:init_rdbmsRelTable","called\n"));
+
+    /*
+     * TODO:300:o: Perform rdbmsRelTable one-time module initialization.
+     */
+     
+    /*
+     * here we initialize all the tables we're planning on supporting
+     */
+    if (should_init("rdbmsRelTable"))
+        initialize_table_rdbmsRelTable();
+
+} /* init_rdbmsRelTable */
+
+/**
+ * Initialize the table rdbmsRelTable 
+ *    (Define its contents and how it's structured)
+ */
+void
+initialize_table_rdbmsRelTable(void)
+{
+    rdbmsRelTable_registration_ptr user_context;
+    u_long flags;
+
+    DEBUGMSGTL(("verbose:rdbmsRelTable:initialize_table_rdbmsRelTable","called\n"));
+
+    /*
+     * TODO:301:o: Perform rdbmsRelTable one-time table initialization.
+     */
+
+    /*
+     * TODO:302:o: |->Initialize rdbmsRelTable user context
+     * if you'd like to pass in a pointer to some data for this
+     * table, allocate or set it up here.
+     */
+    /*
+     * a netsnmp_data_list is a simple way to store void pointers. A simple
+     * string token is used to add, find or remove pointers.
+     */
+    user_context = netsnmp_create_data_list("rdbmsRelTable", NULL, NULL);
+    
+    /*
+     * No support for any flags yet, but in the future you would
+     * set any flags here.
+     */
+    flags = 0;
+    
+    /*
+     * call interface initialization code
+     */
+    _rdbmsRelTable_initialize_interface(user_context, flags);
+} /* initialize_table_rdbmsRelTable */
+
+/**
+ * pre-request callback
+ *
+ *
+ * @retval MFD_SUCCESS              : success.
+ * @retval MFD_ERROR                : other error
+ */
+int
+rdbmsRelTable_pre_request(rdbmsRelTable_registration_ptr user_context)
+{
+    DEBUGMSGTL(("verbose:rdbmsRelTable:rdbmsRelTable_pre_request","called\n"));
+
+    /*
+     * TODO:510:o: Perform rdbmsRelTable pre-request actions.
+     */
+
+    return MFD_SUCCESS;
+} /* rdbmsRelTable_pre_request */
+
+/**
+ * post-request callback
+ *
+ *
+ * @retval MFD_SUCCESS : success.
+ * @retval MFD_ERROR   : other error (ignored)
+ */
+int
+rdbmsRelTable_post_request(rdbmsRelTable_registration_ptr user_context)
+{
+    DEBUGMSGTL(("verbose:rdbmsRelTable:rdbmsRelTable_post_request","called\n"));
+
+    /*
+     * TODO:511:o: Perform rdbmsRelTable pos-request actions.
+     */
+
+    return MFD_SUCCESS;
+} /* rdbmsRelTable_post_request */
+
+
+/** @{ */
diff --git a/RDBMS-MIB_src/rdbmsRelTable/rdbmsRelTable.h b/RDBMS-MIB_src/rdbmsRelTable/rdbmsRelTable.h
new file mode 100644
index 0000000..1c44b8d
--- /dev/null
+++ b/RDBMS-MIB_src/rdbmsRelTable/rdbmsRelTable.h
@@ -0,0 +1,205 @@
+/*-------------------------------------------------------------------------
+ * rdbmsRelTable.h
+ *
+ *      RDBMSMIB mib module.
+ *
+ *      Copyright (c) 2004-2007, PostgreSQL Global Development Group
+ *      Author: Joshua Tolley
+ *
+ * $Id: rdbmsRelTable.h,v 1.2 2007/09/13 14:20:44 h-saito Exp $
+ *
+ *-------------------------------------------------------------------------
+ */
+
+#ifndef RDBMSRELTABLE_H
+#define RDBMSRELTABLE_H
+
+#ifdef __cplusplus
+extern "C" {
+#endif
+
+
+/** @defgroup misc misc: Miscelaneous routines
+ *
+ * @{
+ */
+#include <net-snmp/library/asn1.h>
+
+/* other required module components */
+    /* *INDENT-OFF*  */
+config_require(RDBMS-MIB/rdbmsRelTable/rdbmsRelTable_interface);
+config_require(RDBMS-MIB/rdbmsRelTable/rdbmsRelTable_data_access);
+config_require(RDBMS-MIB/rdbmsRelTable/rdbmsRelTable_data_get);
+config_require(RDBMS-MIB/rdbmsRelTable/rdbmsRelTable_data_set);
+    /* *INDENT-ON*  */
+
+/* OID and column number definitions for  */
+#include "rdbmsRelTable_oids.h"
+
+/* enum definions */
+#include "rdbmsRelTable_enums.h"
+
+/* *********************************************************************
+ * function declarations
+ */
+void init_rdbmsRelTable(void);
+
+/* *********************************************************************
+ * Table declarations
+ */
+/**********************************************************************
+ **********************************************************************
+ ***
+ *** Table rdbmsRelTable
+ ***
+ **********************************************************************
+ **********************************************************************/
+/*
+ * rdbmsRelTable is subid 9 of rdbmsObjects.
+ * Its status is Current.
+ * OID: .1.3.6.1.2.1.39.1.9, length: 9
+*/
+/* *********************************************************************
+ * When you register your mib, you get to provide a generic
+ * pointer that will be passed back to you for most of the
+ * functions calls.
+ *
+ * TODO:100:r: Review all context structures
+ */
+    /*
+     * TODO:101:o: |-> Review rdbmsRelTable registration context.
+     */
+typedef netsnmp_data_list * rdbmsRelTable_registration_ptr;
+
+/**********************************************************************/
+/*
+ * TODO:110:r: |-> Review rdbmsRelTable data context structure.
+ * This structure is used to represent the data for rdbmsRelTable.
+ */
+/*
+ * This structure contains storage for all the columns defined in the
+ * rdbmsRelTable.
+ */
+typedef struct rdbmsRelTable_data_s {
+    
+        /*
+         * rdbmsRelState(1)/INTEGER/ASN_INTEGER/long(u_long)//l/A/w/E/r/d/h
+         */
+   u_long   rdbmsRelState;
+    
+        /*
+         * rdbmsRelActiveTime(2)/DateAndTime/ASN_OCTET_STR/char(char)//L/A/w/e/R/d/H
+         */
+	int activeTimeYear;
+	int activeTimeMonth;
+	int activeTimeDay;
+	int activeTimeHour;
+	int activeTimeMinutes;
+	int activeTimeSeconds;
+	int activeTimeDeciSeconds;
+	int activeTimeUtcOffsetDirection;
+	int activeTimeUtcOffsetHours;
+	int activeTimeUtcOffsetMinutes;
+    
+} rdbmsRelTable_data;
+
+
+/*
+ * TODO:120:r: |-> Review rdbmsRelTable mib index.
+ * This structure is used to represent the index for rdbmsRelTable.
+ */
+typedef struct rdbmsRelTable_mib_index_s {
+
+        /*
+         * rdbmsDbIndex(1)/INTEGER/ASN_INTEGER/long(long)//l/a/w/e/R/d/h
+         */
+   long   rdbmsDbIndex;
+
+        /*
+         * applIndex(1)/INTEGER/ASN_INTEGER/long(long)//l/a/w/e/R/d/h
+         */
+   long   applIndex;
+
+
+} rdbmsRelTable_mib_index;
+
+    /*
+     * TODO:121:r: |   |-> Review rdbmsRelTable max index length.
+     * If you KNOW that your indexes will never exceed a certain
+     * length, update this macro to that length.
+*/
+#define MAX_rdbmsRelTable_IDX_LEN     2
+
+
+/* *********************************************************************
+ * TODO:130:o: |-> Review rdbmsRelTable Row request (rowreq) context.
+ * When your functions are called, you will be passed a
+ * rdbmsRelTable_rowreq_ctx pointer.
+ */
+typedef struct rdbmsRelTable_rowreq_ctx_s {
+
+    /** this must be first for container compare to work */
+    netsnmp_index        oid_idx;
+    oid                  oid_tmp[MAX_rdbmsRelTable_IDX_LEN];
+    
+    rdbmsRelTable_mib_index        tbl_idx;
+    
+    rdbmsRelTable_data              data;
+
+    /*
+     * flags per row. Currently, the first (lower) 8 bits are reserved
+     * for the user. See mfd.h for other flags.
+     */
+    u_int                       rowreq_flags;
+
+    /*
+     * implementor's context pointer (provided during registration)
+     */
+    rdbmsRelTable_registration_ptr rdbmsRelTable_reg;
+
+    /*
+     * TODO:131:o: |   |-> Add useful data to rdbmsRelTable rowreq context.
+     */
+    
+    /*
+     * storage for future expansion
+     */
+    netsnmp_data_list             *rdbmsRelTable_data_list;
+
+} rdbmsRelTable_rowreq_ctx;
+
+typedef struct rdbmsRelTable_ref_rowreq_ctx_s {
+    rdbmsRelTable_rowreq_ctx *rowreq_ctx;
+} rdbmsRelTable_ref_rowreq_ctx;
+
+/* *********************************************************************
+ * function prototypes
+ */
+    int rdbmsRelTable_pre_request(rdbmsRelTable_registration_ptr user_context);
+    int rdbmsRelTable_post_request(rdbmsRelTable_registration_ptr user_context);
+
+
+extern oid rdbmsRelTable_oid[];
+extern int rdbmsRelTable_oid_size;
+
+
+#include "rdbmsRelTable_interface.h"
+#include "rdbmsRelTable_data_access.h"
+#include "rdbmsRelTable_data_get.h"
+#include "rdbmsRelTable_data_set.h"
+
+/*
+ * DUMMY markers, ignore
+ *
+ * TODO:099:x: *************************************************************
+ * TODO:199:x: *************************************************************
+ * TODO:299:x: *************************************************************
+ * TODO:399:x: *************************************************************
+ * TODO:499:x: *************************************************************
+ */
+
+#ifdef __cplusplus
+}
+#endif
+
+#endif /* RDBMSRELTABLE_H */
diff --git a/RDBMS-MIB_src/rdbmsRelTable/rdbmsRelTable_data_access.c b/RDBMS-MIB_src/rdbmsRelTable/rdbmsRelTable_data_access.c
new file mode 100644
index 0000000..e2b6327
--- /dev/null
+++ b/RDBMS-MIB_src/rdbmsRelTable/rdbmsRelTable_data_access.c
@@ -0,0 +1,322 @@
+/*-------------------------------------------------------------------------
+ * rdbmsRelTable_data_access.c
+ *
+ *      RDBMSMIB mib module.
+ *
+ *      Copyright (c) 2004-2007, PostgreSQL Global Development Group
+ *      Author: Joshua Tolley
+ *
+ * $Id: rdbmsRelTable_data_access.c,v 1.4 2007/09/13 14:20:44 h-saito Exp $
+ *
+ *-------------------------------------------------------------------------
+ */
+
+#include "pgsnmpd.h"
+
+/* include our parent header */
+#include "rdbmsRelTable.h"
+#include "rdbmsRelTable_data_access.h"
+
+/** @defgroup data_access data_access: Routines to access data
+ *
+ * These routines are used to locate the data used to satisfy
+ * requests.
+ * 
+ * @{
+ */
+/**********************************************************************
+ **********************************************************************
+ ***
+ *** Table rdbmsRelTable
+ ***
+ **********************************************************************
+ **********************************************************************/
+/*
+ * rdbmsRelTable is subid 9 of rdbmsObjects.
+ * Its status is Current.
+ * OID: .1.3.6.1.2.1.39.1.9, length: 9
+*/
+
+/**
+ * initialization for rdbmsRelTable data access
+ *
+ * This function is called during startup to allow you to
+ * allocate any resources you need for the data table.
+ *
+ * @param rdbmsRelTable_reg
+ *        Pointer to rdbmsRelTable_registration
+ *
+ * @retval MFD_SUCCESS : success.
+ * @retval MFD_ERROR   : unrecoverable error.
+ */
+int
+rdbmsRelTable_init_data(rdbmsRelTable_registration_ptr rdbmsRelTable_reg)
+{
+    DEBUGMSGTL(("verbose:rdbmsRelTable:rdbmsRelTable_init_data","called\n"));
+
+    /*
+     * TODO:303:o: Initialize rdbmsRelTable data.
+     */
+    /*
+    ***************************************************
+    ***             START EXAMPLE CODE              ***
+    ***---------------------------------------------***/
+    /*
+     * if you are the sole writer for the file, you could
+     * open it here. However, as stated earlier, we are assuming
+     * the worst case, which in this case means that the file is
+     * written to by someone else, and might not even exist when
+     * we start up. So we can't do anything here.
+     */
+    /*
+    ***---------------------------------------------***
+    ***              END  EXAMPLE CODE              ***
+    ***************************************************/
+
+    return MFD_SUCCESS;
+} /* rdbmsRelTable_init_data */
+
+/**
+ * container-cached overview
+ *
+ */
+
+/***********************************************************************
+ *
+ * cache
+ *
+ ***********************************************************************/
+/**
+ * container initialization
+ *
+ * @param container_ptr_ptr A pointer to a container pointer. If you
+ *        create a custom container, use this parameter to return it
+ *        to the MFD helper. If set to NULL, the MFD helper will
+ *        allocate a container for you.
+ * @param  cache A pointer to a cache structure. You can set the timeout
+ *         and other cache flags using this pointer.
+ *
+ *  This function is called at startup to allow you to customize certain
+ *  aspects of the access method. For the most part, it is for advanced
+ *  users. The default code should suffice for most cases. If no custom
+ *  container is allocated, the MFD code will create one for your.
+ *
+ *  This is also the place to set up cache behavior. The default, to
+ *  simply set the cache timeout, will work well with the default
+ *  container. If you are using a custom container, you may want to
+ *  look at the cache helper documentation to see if there are any
+ *  flags you want to set.
+ *
+ * @remark
+ *  This would also be a good place to do any initialization needed
+ *  for you data source. For example, opening a connection to another
+ *  process that will supply the data, opening a database, etc.
+ */
+void
+rdbmsRelTable_container_init(netsnmp_container **container_ptr_ptr,
+                        netsnmp_cache *cache)
+{
+    DEBUGMSGTL(("verbose:rdbmsRelTable:rdbmsRelTable_container_init","called\n"));
+    
+    if((NULL == cache) || (NULL == container_ptr_ptr)) {
+        snmp_log(LOG_ERR,"bad params to rdbmsRelTable_container_init\n");
+        return;
+    }
+
+    /*
+     * For advanced users, you can use a custom container. If you
+     * do not create one, one will be created for you.
+     */
+    *container_ptr_ptr = NULL;
+
+    /*
+     * TODO:345:A: Set up rdbmsRelTable cache properties.
+     *
+     * Also for advanced users, you can set parameters for the
+     * cache. Do not change the magic pointer, as it is used
+     * by the MFD helper. To completely disable caching, set
+     * cache->enabled to 0.
+     */
+    cache->timeout = RDBMSRELTABLE_CACHE_TIMEOUT; /* seconds */
+} /* rdbmsRelTable_container_init */
+
+/**
+ * load cache data
+ *
+ * TODO:350:M: Implement rdbmsRelTable cache load
+ *
+ * @param container container to which items should be inserted
+ *
+ * @retval MFD_SUCCESS              : success.
+ * @retval MFD_RESOURCE_UNAVAILABLE : Can't access data source
+ * @retval MFD_ERROR                : other error.
+ *
+ *  This function is called to cache the index(es) (and data, optionally)
+ *  for the every row in the data set.
+ *
+ * @remark
+ *  While loading the cache, the only important thing is the indexes.
+ *  If access to your data is cheap/fast (e.g. you have a pointer to a
+ *  structure in memory), it would make sense to update the data here.
+ *  If, however, the accessing the data invovles more work (e.g. parsing
+ *  some other existing data, or peforming calculations to derive the data),
+ *  then you can limit yourself to setting the indexes and saving any
+ *  information you will need later. Then use the saved information in
+ *  rdbmsRelTable_row_prep() for populating data.
+ *
+ * @note
+ *  If you need consistency between rows (like you want statistics
+ *  for each row to be from the same time frame), you should set all
+ *  data here.
+ *
+ */
+int
+rdbmsRelTable_cache_load(netsnmp_container *container)
+{
+    rdbmsRelTable_rowreq_ctx *rowreq_ctx;
+   long   applIndex = 1;
+   int resultCount, errorCode = MFD_SUCCESS, i, tmpInt, count = 0;
+   PGresult *pg_db_qry;
+
+    DEBUGMSGTL(("verbose:rdbmsRelTable:rdbmsRelTable_cache_load","called\n"));
+
+    /*
+     * TODO:351:M: |-> Load/update data in the rdbmsRelTable container.
+     * loop over your rdbmsRelTable data, allocate a rowreq context,
+     * set the index(es) [and data, optionally] and insert into
+     * the container.
+     */
+
+    if (PQstatus(dbconn) == CONNECTION_OK) 
+	    pg_db_qry = PQexec(dbconn, "SELECT datid, EXTRACT(YEAR FROM pg_postmaster_start_time()), EXTRACT(MONTH FROM pg_postmaster_start_time()), EXTRACT(DAY FROM pg_postmaster_start_time()), EXTRACT(HOUR FROM pg_postmaster_start_time()), EXTRACT(MINUTE FROM pg_postmaster_start_time()), EXTRACT(SECOND FROM pg_postmaster_start_time()), EXTRACT(MILLISECOND FROM pg_postmaster_start_time()), EXTRACT(TIMEZONE_HOUR FROM pg_postmaster_start_time()), EXTRACT(TIMEZONE_MINUTE FROM pg_postmaster_start_time()) FROM pg_stat_database");
+    else {
+	    snmp_log(LOG_ERR, "Can't get connected to the database");
+	    return MFD_RESOURCE_UNAVAILABLE;
+    }
+    if (PQresultStatus(pg_db_qry) != PGRES_TUPLES_OK) {
+	    snmp_log(LOG_ERR, "Didn't get any results from the database");
+	    PQclear(pg_db_qry);
+	    /*PQfinish(dbconn);*/
+	    /* It's probably an error if I didn't find *any* databases */
+	    return MFD_RESOURCE_UNAVAILABLE;
+    }
+
+    resultCount = PQntuples(pg_db_qry);
+
+    for(i = 0; i < resultCount; i++) {
+
+        /*
+         * TODO:352:M: |   |-> set indexes in new rdbmsRelTable rowreq context.
+         */
+        rowreq_ctx = rdbmsRelTable_allocate_rowreq_ctx();
+        if (NULL == rowreq_ctx) {
+            snmp_log(LOG_ERR, "memory allocation failed\n");
+            errorCode = MFD_RESOURCE_UNAVAILABLE;
+	    break;
+        }
+	tmpInt = atoi(PQgetvalue(pg_db_qry, i, 0));
+        if(MFD_SUCCESS != rdbmsRelTable_indexes_set(rowreq_ctx
+                               , tmpInt
+                               , applIndex
+               )) {
+            snmp_log(LOG_ERR,"error setting index while loading "
+                     "rdbmsRelTable cache.\n");
+            rdbmsRelTable_release_rowreq_ctx(rowreq_ctx);
+            continue;
+        }
+
+        /*
+         * TODO:352:r: |   |-> populate rdbmsRelTable data context.
+         * Populate data context here. (optionally, delay until row prep)
+         */
+
+    /* All databases are active */
+    if(MFD_SUCCESS !=
+       rdbmsRelState_map(&rowreq_ctx->data.rdbmsRelState, INTERNAL_RDBMSRELSTATE_ACTIVE)) {
+        return MFD_ERROR;
+    }
+    
+	rowreq_ctx->data.activeTimeYear = atoi(PQgetvalue(pg_db_qry, i, 1));
+	rowreq_ctx->data.activeTimeMonth = atoi(PQgetvalue(pg_db_qry, i, 2));
+	rowreq_ctx->data.activeTimeDay = atoi(PQgetvalue(pg_db_qry, i, 3));
+	rowreq_ctx->data.activeTimeHour = atoi(PQgetvalue(pg_db_qry, i, 4));
+	rowreq_ctx->data.activeTimeMinutes = atoi(PQgetvalue(pg_db_qry, i, 5));
+	rowreq_ctx->data.activeTimeSeconds = atoi(PQgetvalue(pg_db_qry, i, 6));
+	rowreq_ctx->data.activeTimeDeciSeconds = atoi(PQgetvalue(pg_db_qry, i, 7));
+	rowreq_ctx->data.activeTimeUtcOffsetHours = atoi(PQgetvalue(pg_db_qry, i, 8));
+	rowreq_ctx->data.activeTimeUtcOffsetMinutes = atoi(PQgetvalue(pg_db_qry, i, 9));
+	tmpInt = rowreq_ctx->data.activeTimeUtcOffsetHours * 60 + rowreq_ctx->data.activeTimeUtcOffsetMinutes;
+	if (tmpInt == 0)
+		rowreq_ctx->data.activeTimeUtcOffsetDirection = 0;
+	else 
+		rowreq_ctx->data.activeTimeUtcOffsetDirection = (tmpInt > 0 ? 1 : -1);
+    
+        
+        /*
+         * insert into table container
+         */
+        CONTAINER_INSERT(container, rowreq_ctx);
+        ++count;
+    }
+
+    DEBUGMSGT(("verbose:rdbmsRelTable:rdbmsRelTable_cache_load",
+               "inserted %d records\n", count));
+
+    PQclear(pg_db_qry);
+
+    return errorCode;
+} /* rdbmsRelTable_cache_load */
+
+/**
+ * cache clean up
+ *
+ * @param container container with all current items
+ *
+ *  This optional callback is called prior to all
+ *  item's being removed from the container. If you
+ *  need to do any processing before that, do it here.
+ *
+ * @note
+ *  The MFD helper will take care of releasing all the row contexts.
+ *
+ */
+void
+rdbmsRelTable_cache_free(netsnmp_container *container)
+{
+    DEBUGMSGTL(("verbose:rdbmsRelTable:rdbmsRelTable_cache_free","called\n"));
+
+    /*
+     * TODO:380:M: Free rdbmsRelTable cache.
+     */
+} /* rdbmsRelTable_cache_free */
+
+/**
+ * prepare row for processing.
+ *
+ *  When the agent has located the row for a request, this function is
+ *  called to prepare the row for processing. If you fully populated
+ *  the data context during the index setup phase, you may not need to
+ *  do anything.
+ *
+ * @param rowreq_ctx pointer to a context.
+ *
+ * @retval MFD_SUCCESS     : success.
+ * @retval MFD_ERROR       : other error.
+ */
+int
+rdbmsRelTable_row_prep( rdbmsRelTable_rowreq_ctx *rowreq_ctx)
+{
+    DEBUGMSGTL(("verbose:rdbmsRelTable:rdbmsRelTable_row_prep","called\n"));
+
+    netsnmp_assert(NULL != rowreq_ctx);
+
+    /*
+     * TODO:390:o: Prepare row for request.
+     * If populating row data was delayed, this is the place to
+     * fill in the row for this request.
+     */
+
+    return MFD_SUCCESS;
+} /* rdbmsRelTable_row_prep */
+
+/** @} */
diff --git a/RDBMS-MIB_src/rdbmsRelTable/rdbmsRelTable_data_access.h b/RDBMS-MIB_src/rdbmsRelTable/rdbmsRelTable_data_access.h
new file mode 100644
index 0000000..195fa5f
--- /dev/null
+++ b/RDBMS-MIB_src/rdbmsRelTable/rdbmsRelTable_data_access.h
@@ -0,0 +1,77 @@
+/*-------------------------------------------------------------------------
+ * rdbmsRelTable_data_access.h
+ *
+ *      RDBMSMIB mib module.
+ *
+ *      Copyright (c) 2004-2007, PostgreSQL Global Development Group
+ *      Author: Joshua Tolley
+ *
+ * $Id: rdbmsRelTable_data_access.h,v 1.2 2007/09/13 14:20:44 h-saito Exp $
+ *
+ *-------------------------------------------------------------------------
+ */
+
+#ifndef RDBMSRELTABLE_DATA_ACCESS_H
+#define RDBMSRELTABLE_DATA_ACCESS_H
+
+#ifdef __cplusplus
+extern "C" {
+#endif
+
+
+/* *********************************************************************
+ * function declarations
+ */
+
+/* *********************************************************************
+ * Table declarations
+ */
+/**********************************************************************
+ **********************************************************************
+ ***
+ *** Table rdbmsRelTable
+ ***
+ **********************************************************************
+ **********************************************************************/
+/*
+ * rdbmsRelTable is subid 9 of rdbmsObjects.
+ * Its status is Current.
+ * OID: .1.3.6.1.2.1.39.1.9, length: 9
+*/
+
+
+    int rdbmsRelTable_init_data(rdbmsRelTable_registration_ptr rdbmsRelTable_reg);
+
+
+/*
+ * TODO:180:o: Review rdbmsRelTable cache timeout.
+ * The number of seconds before the cache times out
+ */
+#define RDBMSRELTABLE_CACHE_TIMEOUT   60
+
+void rdbmsRelTable_container_init(netsnmp_container **container_ptr_ptr,
+                             netsnmp_cache *cache);
+int rdbmsRelTable_cache_load(netsnmp_container *container);
+void rdbmsRelTable_cache_free(netsnmp_container *container);
+
+    /*
+    ***************************************************
+    ***             START EXAMPLE CODE              ***
+    ***---------------------------------------------***/
+/* *********************************************************************
+ * Since we have no idea how you really access your data, we'll go with
+ * a worst case example: a flat text file.
+ */
+#define MAX_LINE_SIZE 256
+    /*
+    ***---------------------------------------------***
+    ***              END  EXAMPLE CODE              ***
+    ***************************************************/
+    int rdbmsRelTable_row_prep( rdbmsRelTable_rowreq_ctx *rowreq_ctx);
+
+
+#ifdef __cplusplus
+}
+#endif
+
+#endif /* RDBMSRELTABLE_DATA_ACCESS_H */
diff --git a/RDBMS-MIB_src/rdbmsRelTable/rdbmsRelTable_data_get.c b/RDBMS-MIB_src/rdbmsRelTable/rdbmsRelTable_data_get.c
new file mode 100644
index 0000000..9895a63
--- /dev/null
+++ b/RDBMS-MIB_src/rdbmsRelTable/rdbmsRelTable_data_get.c
@@ -0,0 +1,378 @@
+/*-------------------------------------------------------------------------
+ * rdbmsRelTable_data_get.c
+ *
+ *      RDBMSMIB mib module.
+ *
+ *      Copyright (c) 2004-2007, PostgreSQL Global Development Group
+ *      Author: Joshua Tolley
+ *
+ * $Id: rdbmsRelTable_data_get.c,v 1.2 2007/09/13 14:20:44 h-saito Exp $
+ *
+ *-------------------------------------------------------------------------
+ */
+
+/* standard Net-SNMP includes */
+#include <net-snmp/net-snmp-config.h>
+#include <net-snmp/net-snmp-includes.h>
+#include <net-snmp/agent/net-snmp-agent-includes.h>
+
+/* include our parent header */
+#include "rdbmsRelTable.h"
+
+
+/** @defgroup data_get data_get: Routines to get data
+ *
+ * TODO:230:M: Implement rdbmsRelTable get routines.
+ * TODO:240:M: Implement rdbmsRelTable mapping routines (if any).
+ *
+ * These routine are used to get the value for individual objects. The
+ * row context is passed, along with a pointer to the memory where the
+ * value should be copied.
+ *
+ * @{
+ */
+/**********************************************************************
+ **********************************************************************
+ ***
+ *** Table rdbmsRelTable
+ ***
+ **********************************************************************
+ **********************************************************************/
+/*
+ * rdbmsRelTable is subid 9 of rdbmsObjects.
+ * Its status is Current.
+ * OID: .1.3.6.1.2.1.39.1.9, length: 9
+*/
+
+/* ---------------------------------------------------------------------
+ * TODO:200:r: Implement rdbmsRelTable data context functions.
+ */
+
+
+/**
+ * set mib index(es)
+ *
+ * @param tbl_idx mib index structure
+ *
+ * @retval MFD_SUCCESS     : success.
+ * @retval MFD_ERROR       : other error.
+ *
+ * @remark
+ *  This convenience function is useful for setting all the MIB index
+ *  components with a single function call. It is assume that the C values
+ *  have already been mapped from their native/rawformat to the MIB format.
+ */
+int
+rdbmsRelTable_indexes_set_tbl_idx(rdbmsRelTable_mib_index *tbl_idx, long rdbmsDbIndex_val, long applIndex_val)
+{
+    DEBUGMSGTL(("verbose:rdbmsRelTable:rdbmsRelTable_indexes_set_tbl_idx","called\n"));
+
+    /* rdbmsDbIndex(1)/INTEGER/ASN_INTEGER/long(long)//l/a/w/e/R/d/h */
+    tbl_idx->rdbmsDbIndex = rdbmsDbIndex_val;
+    
+    /* applIndex(1)/INTEGER/ASN_INTEGER/long(long)//l/a/w/e/R/d/h */
+    tbl_idx->applIndex = applIndex_val;
+    
+
+    return MFD_SUCCESS;
+} /* rdbmsRelTable_indexes_set_tbl_idx */
+
+/**
+ * @internal
+ * set row context indexes
+ *
+ * @param reqreq_ctx the row context that needs updated indexes
+ *
+ * @retval MFD_SUCCESS     : success.
+ * @retval MFD_ERROR       : other error.
+ *
+ * @remark
+ *  This function sets the mib indexs, then updates the oid indexs
+ *  from the mib index.
+ */
+int
+rdbmsRelTable_indexes_set(rdbmsRelTable_rowreq_ctx *rowreq_ctx, long rdbmsDbIndex_val, long applIndex_val)
+{
+    DEBUGMSGTL(("verbose:rdbmsRelTable:rdbmsRelTable_indexes_set","called\n"));
+
+    if(MFD_SUCCESS != rdbmsRelTable_indexes_set_tbl_idx(&rowreq_ctx->tbl_idx
+                                   , rdbmsDbIndex_val
+                                   , applIndex_val
+           ))
+        return MFD_ERROR;
+
+    /*
+     * convert mib index to oid index
+     */
+    rowreq_ctx->oid_idx.len = sizeof(rowreq_ctx->oid_tmp) / sizeof(oid);
+    if(0 != rdbmsRelTable_index_to_oid(&rowreq_ctx->oid_idx,
+                                    &rowreq_ctx->tbl_idx)) {
+        return MFD_ERROR;
+    }
+
+    return MFD_SUCCESS;
+} /* rdbmsRelTable_indexes_set */
+
+
+/*---------------------------------------------------------------------
+ * RDBMS-MIB::rdbmsRelEntry.rdbmsRelState
+ * rdbmsRelState is subid 1 of rdbmsRelEntry.
+ * Its status is Current, and its access level is ReadOnly.
+ * OID: .1.3.6.1.2.1.39.1.9.1.1
+ * Description:
+The state of this server's access to this database.
+           Active(2) means the server is actively using the database.
+           Available(3) means the server could use the database if
+           necessary.  Restricted(4) means the database is in some
+           administratively determined state of less-than-complete
+           availability.  Unavailable(5) means the database is not
+           available through this server.  Other(1) means the
+           database/server is in some other condition, possibly
+           described in the vendor private MIB.
+ *
+ * Attributes:
+ *   accessible 1     isscalar 0     enums  1      hasdefval 0
+ *   readable   1     iscolumn 1     ranges 0      hashint   0
+ *   settable   0
+ *
+ * Enum range: 3/8. Values:  other(1), active(2), available(3), restricted(4), unavailable(5)
+ *
+ * Its syntax is INTEGER (based on perltype INTEGER)
+ * The net-snmp type is ASN_INTEGER. The C type decl is long (u_long)
+ */
+/**
+ * map a value from its original native format to the MIB format.
+ *
+ * @retval MFD_SUCCESS         : success
+ * @retval MFD_ERROR           : Any other error
+ *
+ * @note parameters follow the memset convention (dest, src).
+ *
+ * @note generation and use of this function can be turned off by re-running
+ * mib2c after adding the following line to the file
+ * default-node-rdbmsRelState.m2d :
+ *   @eval $m2c_node_skip_mapping = 1@
+ *
+ * @remark
+ *  If the values for your data type don't exactly match the
+ *  possible values defined by the mib, you should map them here.
+ *  Otherwise, just do a direct copy.
+ */
+int
+rdbmsRelState_map(u_long *mib_rdbmsRelState_val_ptr, u_long raw_rdbmsRelState_val)
+{
+    netsnmp_assert(NULL != mib_rdbmsRelState_val_ptr);
+    
+    DEBUGMSGTL(("verbose:rdbmsRelTable:rdbmsRelState_map","called\n"));
+    
+    /*
+     * TODO:241:o: |-> Implement rdbmsRelState enum mapping.
+     * uses INTERNAL_* macros defined in the header files
+     */
+    switch(raw_rdbmsRelState_val) {
+        case INTERNAL_RDBMSRELSTATE_OTHER:
+             *mib_rdbmsRelState_val_ptr = RDBMSRELSTATE_OTHER;
+             break;
+
+        case INTERNAL_RDBMSRELSTATE_ACTIVE:
+             *mib_rdbmsRelState_val_ptr = RDBMSRELSTATE_ACTIVE;
+             break;
+
+        case INTERNAL_RDBMSRELSTATE_AVAILABLE:
+             *mib_rdbmsRelState_val_ptr = RDBMSRELSTATE_AVAILABLE;
+             break;
+
+        case INTERNAL_RDBMSRELSTATE_RESTRICTED:
+             *mib_rdbmsRelState_val_ptr = RDBMSRELSTATE_RESTRICTED;
+             break;
+
+        case INTERNAL_RDBMSRELSTATE_UNAVAILABLE:
+             *mib_rdbmsRelState_val_ptr = RDBMSRELSTATE_UNAVAILABLE;
+             break;
+
+             default:
+                 snmp_log(LOG_ERR, "couldn't map value %ld for rdbmsRelState\n", raw_rdbmsRelState_val );
+                 return MFD_ERROR;
+    }
+
+    return MFD_SUCCESS;
+} /* rdbmsRelState_map */
+
+/**
+ * Extract the current value of the rdbmsRelState data.
+ *
+ * Set a value using the data context for the row.
+ *
+ * @param rowreq_ctx
+ *        Pointer to the row request context.
+ * @param rdbmsRelState_val_ptr
+ *        Pointer to storage for a long variable
+ *
+ * @retval MFD_SUCCESS         : success
+ * @retval MFD_SKIP            : skip this node (no value for now)
+ * @retval MFD_ERROR           : Any other error
+ */
+int
+rdbmsRelState_get( rdbmsRelTable_rowreq_ctx *rowreq_ctx, u_long * rdbmsRelState_val_ptr )
+{
+   /** we should have a non-NULL pointer */
+   netsnmp_assert( NULL != rdbmsRelState_val_ptr );
+
+
+    DEBUGMSGTL(("verbose:rdbmsRelTable:rdbmsRelState_get","called\n"));
+
+    netsnmp_assert(NULL != rowreq_ctx);
+
+/*
+ * TODO:231:o: |-> Extract the current value of the rdbmsRelState data.
+ * set (* rdbmsRelState_val_ptr ) from rowreq_ctx->data
+ */
+    (* rdbmsRelState_val_ptr ) = rowreq_ctx->data.rdbmsRelState;
+
+    return MFD_SUCCESS;
+} /* rdbmsRelState_get */
+
+/*---------------------------------------------------------------------
+ * RDBMS-MIB::rdbmsRelEntry.rdbmsRelActiveTime
+ * rdbmsRelActiveTime is subid 2 of rdbmsRelEntry.
+ * Its status is Current, and its access level is ReadOnly.
+ * OID: .1.3.6.1.2.1.39.1.9.1.2
+ * Description:
+The time the database was made active by the server.  If an
+           instance of rdbmsRelState is not active(1), then attempts to
+           access the corresponding instance of this object may result
+           in either noSuchName (SNMPv1) or noSuchInstance (SNMPv2)
+           being returned by the agent.
+ *
+ * Attributes:
+ *   accessible 1     isscalar 0     enums  0      hasdefval 0
+ *   readable   1     iscolumn 1     ranges 1      hashint   1
+ *   settable   0
+ *   hint: 2d-1d-1d,1d:1d:1d.1d,1a1d:1d
+ *
+ * Ranges:  8, 11;
+ *
+ * Its syntax is DateAndTime (based on perltype OCTETSTR)
+ * The net-snmp type is ASN_OCTET_STR. The C type decl is char (char)
+ * This data type requires a length.  (Max 11)
+ */
+/**
+ * map a value from its original native format to the MIB format.
+ *
+ * @retval MFD_SUCCESS         : success
+ * @retval MFD_ERROR           : Any other error
+ *
+ * @note parameters follow the memset convention (dest, src).
+ *
+ * @note generation and use of this function can be turned off by re-running
+ * mib2c after adding the following line to the file
+ * default-node-rdbmsRelActiveTime.m2d :
+ *   @eval $m2c_node_skip_mapping = 1@
+ *
+ * @remark
+ *  If the values for your data type don't exactly match the
+ *  possible values defined by the mib, you should map them here.
+ *  Otherwise, just do a direct copy.
+ */
+int
+rdbmsRelActiveTime_map(char **mib_rdbmsRelActiveTime_val_ptr_ptr, size_t *mib_rdbmsRelActiveTime_val_ptr_len_ptr, char *raw_rdbmsRelActiveTime_val_ptr, size_t raw_rdbmsRelActiveTime_val_ptr_len, int allow_realloc)
+{
+    int converted_len;
+
+    netsnmp_assert(NULL != raw_rdbmsRelActiveTime_val_ptr);
+    netsnmp_assert((NULL != mib_rdbmsRelActiveTime_val_ptr_ptr) && (NULL != mib_rdbmsRelActiveTime_val_ptr_len_ptr));
+    
+    DEBUGMSGTL(("verbose:rdbmsRelTable:rdbmsRelActiveTime_map","called\n"));
+    
+    /*
+     * TODO:241:r: |-> Implement rdbmsRelActiveTime non-integer mapping
+     * it is hard to autogenerate code for mapping types that are not simple
+     * integers, so here is an idea of what you might need to do. It will
+     * probably need some tweaking to get right.
+     */
+    /*
+     * if the length of the raw data doesn't directly correspond with
+     * the length of the mib data, set converted_len to the
+     * space required.
+     */
+    converted_len = raw_rdbmsRelActiveTime_val_ptr_len; /* assume equal */
+    if((NULL == *mib_rdbmsRelActiveTime_val_ptr_ptr) || (*mib_rdbmsRelActiveTime_val_ptr_len_ptr < converted_len)) {
+        if(! allow_realloc) {
+            snmp_log(LOG_ERR,"not enough space for value mapping\n");
+            return SNMP_ERR_GENERR;
+        }
+        *mib_rdbmsRelActiveTime_val_ptr_ptr = realloc( *mib_rdbmsRelActiveTime_val_ptr_ptr, converted_len * sizeof(**mib_rdbmsRelActiveTime_val_ptr_ptr));
+        if(NULL == *mib_rdbmsRelActiveTime_val_ptr_ptr) {
+            snmp_log(LOG_ERR,"could not allocate memory\n");
+            return SNMP_ERR_GENERR;
+        }
+    }
+    *mib_rdbmsRelActiveTime_val_ptr_len_ptr = converted_len;
+    memcpy( *mib_rdbmsRelActiveTime_val_ptr_ptr, raw_rdbmsRelActiveTime_val_ptr, converted_len );
+
+    return MFD_SUCCESS;
+} /* rdbmsRelActiveTime_map */
+
+/**
+ * Extract the current value of the rdbmsRelActiveTime data.
+ *
+ * Set a value using the data context for the row.
+ *
+ * @param rowreq_ctx
+ *        Pointer to the row request context.
+ * @param rdbmsRelActiveTime_val_ptr_ptr
+ *        Pointer to storage for a char variable
+ * @param rdbmsRelActiveTime_val_ptr_len_ptr
+ *        Pointer to a size_t. On entry, it will contain the size (in bytes)
+ *        pointed to by rdbmsRelActiveTime.
+ *        On exit, this value should contain the data size (in bytes).
+ *
+ * @retval MFD_SUCCESS         : success
+ * @retval MFD_SKIP            : skip this node (no value for now)
+ * @retval MFD_ERROR           : Any other error
+*
+ * @note If you need more than (*rdbmsRelActiveTime_val_ptr_len_ptr) bytes of memory,
+ *       allocate it using malloc() and update rdbmsRelActiveTime_val_ptr_ptr.
+ *       <b>DO NOT</b> free the previous pointer.
+ *       The MFD helper will release the memory you allocate.
+ *
+ * @remark If you call this function yourself, you are responsible
+ *         for checking if the pointer changed, and freeing any
+ *         previously allocated memory. (Not necessary if you pass
+ *         in a pointer to static memory, obviously.)
+ */
+int
+rdbmsRelActiveTime_get( rdbmsRelTable_rowreq_ctx *rowreq_ctx, char **rdbmsRelActiveTime_val_ptr_ptr, size_t *rdbmsRelActiveTime_val_ptr_len_ptr )
+{
+	int rc;
+   /** we should have a pointer and enough storage */
+   netsnmp_assert( (NULL != rdbmsRelActiveTime_val_ptr_ptr) && (NULL != *rdbmsRelActiveTime_val_ptr_ptr));
+   netsnmp_assert( (NULL != rdbmsRelActiveTime_val_ptr_len_ptr) && ((* rdbmsRelActiveTime_val_ptr_len_ptr) >= 11));
+
+   /*
+    * TODO:231:o: |-> copy rdbmsRelActiveTime data.
+    * get the date from your context pointer.
+    */
+
+   /* call convenience function to set data */
+   rc = netsnmp_dateandtime_set_buf_from_vars((u_char *)*rdbmsRelActiveTime_val_ptr_ptr, rdbmsRelActiveTime_val_ptr_len_ptr,
+	rowreq_ctx->data.activeTimeYear,
+	rowreq_ctx->data.activeTimeMonth,
+	rowreq_ctx->data.activeTimeDay,
+	rowreq_ctx->data.activeTimeHour,
+	rowreq_ctx->data.activeTimeMinutes,
+	rowreq_ctx->data.activeTimeSeconds,
+	rowreq_ctx->data.activeTimeDeciSeconds,
+	rowreq_ctx->data.activeTimeUtcOffsetDirection,
+	rowreq_ctx->data.activeTimeUtcOffsetHours,
+	rowreq_ctx->data.activeTimeUtcOffsetMinutes);
+   if(rc != SNMP_ERR_NOERROR)
+      return rc;
+
+
+    return MFD_SUCCESS;
+} /* rdbmsRelActiveTime_get */
+
+
+
+/** @} */
diff --git a/RDBMS-MIB_src/rdbmsRelTable/rdbmsRelTable_data_get.h b/RDBMS-MIB_src/rdbmsRelTable/rdbmsRelTable_data_get.h
new file mode 100644
index 0000000..2f86b58
--- /dev/null
+++ b/RDBMS-MIB_src/rdbmsRelTable/rdbmsRelTable_data_get.h
@@ -0,0 +1,63 @@
+/*-------------------------------------------------------------------------
+ * rdbmsRelTable_data_get.h
+ *
+ *      RDBMSMIB mib module.
+ *
+ *      Copyright (c) 2004-2007, PostgreSQL Global Development Group
+ *      Author: Joshua Tolley
+ *
+ * $Id: rdbmsRelTable_data_get.h,v 1.2 2007/09/13 14:20:44 h-saito Exp $
+ *
+ *-------------------------------------------------------------------------
+ */
+
+#ifndef RDBMSRELTABLE_DATA_GET_H
+#define RDBMSRELTABLE_DATA_GET_H
+
+#ifdef __cplusplus
+extern "C" {
+#endif
+
+/* *********************************************************************
+ * GET function declarations
+ */
+
+/* *********************************************************************
+ * GET Table declarations
+ */
+/**********************************************************************
+ **********************************************************************
+ ***
+ *** Table rdbmsRelTable
+ ***
+ **********************************************************************
+ **********************************************************************/
+/*
+ * rdbmsRelTable is subid 9 of rdbmsObjects.
+ * Its status is Current.
+ * OID: .1.3.6.1.2.1.39.1.9, length: 9
+*/
+    /*
+     * indexes
+     */
+    int rdbmsDbIndex_map(long *mib_rdbmsDbIndex_val_ptr, long raw_rdbmsDbIndex_val);
+    int applIndex_map(long *mib_applIndex_val_ptr, long raw_applIndex_val);
+
+    int rdbmsRelState_map(u_long *mib_rdbmsRelState_val_ptr, u_long raw_rdbmsRelState_val);
+    int rdbmsRelState_get( rdbmsRelTable_rowreq_ctx *rowreq_ctx, u_long * rdbmsRelState_val_ptr );
+    int rdbmsRelActiveTime_map(char **mib_rdbmsRelActiveTime_val_ptr_ptr, size_t *mib_rdbmsRelActiveTime_val_ptr_len_ptr, char *raw_rdbmsRelActiveTime_val_ptr, size_t raw_rdbmsRelActiveTime_val_ptr_len, int allow_realloc);
+    int rdbmsRelActiveTime_get( rdbmsRelTable_rowreq_ctx *rowreq_ctx, char **rdbmsRelActiveTime_val_ptr_ptr, size_t *rdbmsRelActiveTime_val_ptr_len_ptr );
+
+
+int rdbmsRelTable_indexes_set_tbl_idx(rdbmsRelTable_mib_index *tbl_idx, long rdbmsDbIndex_val, long applIndex_val);
+int rdbmsRelTable_indexes_set(rdbmsRelTable_rowreq_ctx *rowreq_ctx, long rdbmsDbIndex_val, long applIndex_val);
+
+
+
+
+#ifdef __cplusplus
+}
+#endif
+
+#endif /* RDBMSRELTABLE_DATA_GET_H */
+/** @} */
diff --git a/RDBMS-MIB_src/rdbmsRelTable/rdbmsRelTable_data_set.c b/RDBMS-MIB_src/rdbmsRelTable/rdbmsRelTable_data_set.c
new file mode 100644
index 0000000..a2de409
--- /dev/null
+++ b/RDBMS-MIB_src/rdbmsRelTable/rdbmsRelTable_data_set.c
@@ -0,0 +1,30 @@
+/*-------------------------------------------------------------------------
+ * rdbmsRelTable_data_set.c
+ *
+ *      RDBMSMIB mib module.
+ *
+ *      Copyright (c) 2004-2007, PostgreSQL Global Development Group
+ *      Author: Joshua Tolley
+ *
+ * $Id: rdbmsRelTable_data_set.c,v 1.2 2007/09/13 14:20:44 h-saito Exp $
+ *
+ *-------------------------------------------------------------------------
+ */
+
+/* standard Net-SNMP includes */
+#include <net-snmp/net-snmp-config.h>
+#include <net-snmp/net-snmp-includes.h>
+#include <net-snmp/agent/net-snmp-agent-includes.h>
+
+/* include our parent header */
+#include "rdbmsRelTable.h"
+
+
+/** @defgroup data_set data_set: Routines to set data
+ *
+ * These routines are used to set the value for individual objects. The
+ * row context is passed, along with the new value.
+ * 
+ * @{
+ */
+/** @} */
diff --git a/RDBMS-MIB_src/rdbmsRelTable/rdbmsRelTable_data_set.h b/RDBMS-MIB_src/rdbmsRelTable/rdbmsRelTable_data_set.h
new file mode 100644
index 0000000..3b62de5
--- /dev/null
+++ b/RDBMS-MIB_src/rdbmsRelTable/rdbmsRelTable_data_set.h
@@ -0,0 +1,34 @@
+/*-------------------------------------------------------------------------
+ * rdbmsRelTable_data_set.h
+ *
+ *      RDBMSMIB mib module.
+ *
+ *      Copyright (c) 2004-2007, PostgreSQL Global Development Group
+ *      Author: Joshua Tolley
+ *
+ * $Id: rdbmsRelTable_data_set.h,v 1.2 2007/09/13 14:20:44 h-saito Exp $
+ *
+ *-------------------------------------------------------------------------
+ */
+
+#ifndef RDBMSRELTABLE_DATA_SET_H
+#define RDBMSRELTABLE_DATA_SET_H
+
+#ifdef __cplusplus
+extern "C" {
+#endif
+
+/* *********************************************************************
+ * SET function declarations
+ */
+
+/* *********************************************************************
+ * SET Table declarations
+ */
+
+
+#ifdef __cplusplus
+}
+#endif
+
+#endif /* RDBMSRELTABLE_DATA_SET_H */
diff --git a/RDBMS-MIB_src/rdbmsRelTable/rdbmsRelTable_enums.h b/RDBMS-MIB_src/rdbmsRelTable/rdbmsRelTable_enums.h
new file mode 100644
index 0000000..7415b02
--- /dev/null
+++ b/RDBMS-MIB_src/rdbmsRelTable/rdbmsRelTable_enums.h
@@ -0,0 +1,76 @@
+/*-------------------------------------------------------------------------
+ * rdbmsRelTable_enums.h
+ *
+ *      RDBMSMIB mib module.
+ *
+ *      Copyright (c) 2004-2007, PostgreSQL Global Development Group
+ *      Author: Joshua Tolley
+ *
+ * $Id: rdbmsRelTable_enums.h,v 1.2 2007/09/13 14:20:44 h-saito Exp $
+ *
+ *-------------------------------------------------------------------------
+ */
+
+#ifndef RDBMSRELTABLE_ENUMS_H
+#define RDBMSRELTABLE_ENUMS_H
+
+#ifdef __cplusplus
+extern "C" {
+#endif
+
+ /*
+ * NOTES on enums
+ * ==============
+ *
+ * Value Mapping
+ * -------------
+ * If the values for your data type don't exactly match the
+ * possible values defined by the mib, you should map them
+ * below. For example, a boolean flag (1/0) is usually represented
+ * as a TruthValue in a MIB, which maps to the values (1/2).
+ *
+ */
+/*************************************************************************
+ *************************************************************************
+ *
+ * enum definitions for table rdbmsRelTable
+ *
+ *************************************************************************
+ *************************************************************************/
+
+/*************************************************************
+ * constants for enums for the MIB node
+ * rdbmsRelState (INTEGER / ASN_INTEGER)
+ *
+ * since a Textual Convention may be referenced more than once in a
+ * MIB, protect againt redefinitions of the enum values.
+ */
+#ifndef RDBMSRELSTATE_ENUMS
+#define RDBMSRELSTATE_ENUMS
+
+#define RDBMSRELSTATE_OTHER  1 
+#define RDBMSRELSTATE_ACTIVE  2 
+#define RDBMSRELSTATE_AVAILABLE  3 
+#define RDBMSRELSTATE_RESTRICTED  4 
+#define RDBMSRELSTATE_UNAVAILABLE  5 
+
+
+#endif /* RDBMSRELSTATE_ENUMS */
+
+    /*
+     * TODO:140:o: Define interal representation of rdbmsRelState enums.
+     * (used for value mapping; see notes at top of file)
+     */
+#define INTERNAL_RDBMSRELSTATE_OTHER  1 
+#define INTERNAL_RDBMSRELSTATE_ACTIVE  2 
+#define INTERNAL_RDBMSRELSTATE_AVAILABLE  3 
+#define INTERNAL_RDBMSRELSTATE_RESTRICTED  4 
+#define INTERNAL_RDBMSRELSTATE_UNAVAILABLE  5 
+
+
+
+#ifdef __cplusplus
+}
+#endif
+
+#endif /* RDBMSRELTABLE_ENUMS_H */
diff --git a/RDBMS-MIB_src/rdbmsRelTable/rdbmsRelTable_interface.c b/RDBMS-MIB_src/rdbmsRelTable/rdbmsRelTable_interface.c
new file mode 100644
index 0000000..6329fac
--- /dev/null
+++ b/RDBMS-MIB_src/rdbmsRelTable/rdbmsRelTable_interface.c
@@ -0,0 +1,712 @@
+/*-------------------------------------------------------------------------
+ * rdbmsRelTable_interface.c
+ *
+ *      RDBMSMIB mib module.
+ *
+ *      Copyright (c) 2004-2007, PostgreSQL Global Development Group
+ *      Author: Joshua Tolley
+ *
+ * $Id: rdbmsRelTable_interface.c,v 1.2 2007/09/13 14:20:44 h-saito Exp $
+ *
+ *-------------------------------------------------------------------------
+ */
+
+#include "pgsnmpd.h"
+
+/* include our parent header */
+#include "rdbmsRelTable.h"
+
+
+#include <net-snmp/library/container.h>
+
+#include "rdbmsRelTable_interface.h"
+
+/**********************************************************************
+ **********************************************************************
+ ***
+ *** Table rdbmsRelTable
+ ***
+ **********************************************************************
+ **********************************************************************/
+/*
+ * rdbmsRelTable is subid 9 of rdbmsObjects.
+ * Its status is Current.
+ * OID: .1.3.6.1.2.1.39.1.9, length: 9
+*/
+typedef struct rdbmsRelTable_interface_ctx_s {
+
+   netsnmp_container              *container;
+   netsnmp_cache                  *cache; /* optional cache */
+
+   rdbmsRelTable_registration_ptr      user_ctx;
+   
+   netsnmp_table_registration_info  tbl_info;
+
+   netsnmp_baby_steps_access_methods access_multiplexer;
+
+} rdbmsRelTable_interface_ctx;
+
+static rdbmsRelTable_interface_ctx rdbmsRelTable_if_ctx;
+
+static void _rdbmsRelTable_container_init(
+    rdbmsRelTable_interface_ctx *if_ctx);
+
+
+static Netsnmp_Node_Handler _mfd_rdbmsRelTable_pre_request;
+static Netsnmp_Node_Handler _mfd_rdbmsRelTable_post_request;
+static Netsnmp_Node_Handler _mfd_rdbmsRelTable_object_lookup;
+static Netsnmp_Node_Handler _mfd_rdbmsRelTable_get_values;
+/**
+ * @internal
+ * Initialize the table rdbmsRelTable 
+ *    (Define its contents and how it's structured)
+ */
+void
+_rdbmsRelTable_initialize_interface(rdbmsRelTable_registration_ptr reg_ptr,  u_long flags)
+{
+    netsnmp_baby_steps_access_methods *access_multiplexer =
+        &rdbmsRelTable_if_ctx.access_multiplexer;
+    netsnmp_table_registration_info *tbl_info = &rdbmsRelTable_if_ctx.tbl_info;
+    netsnmp_handler_registration *reginfo;
+    netsnmp_mib_handler *handler;
+    int    mfd_modes = 0;
+
+    DEBUGMSGTL(("internal:rdbmsRelTable:_rdbmsRelTable_initialize_interface","called\n"));
+
+
+    /*************************************************
+     *
+     * save interface context for rdbmsRelTable
+     */
+    /*
+     * Setting up the table's definition
+     */
+    netsnmp_table_helper_add_indexes(tbl_info,
+                                  ASN_INTEGER, /** index: rdbmsDbIndex */
+                                  ASN_INTEGER, /** index: applIndex */
+                             0);
+
+    /*  Define the minimum and maximum accessible columns.  This
+        optimizes retrival. */
+    tbl_info->min_column = RDBMSRELTABLE_MIN_COL;
+    tbl_info->max_column = RDBMSRELTABLE_MAX_COL;
+
+    /*
+     * save users context
+     */
+    rdbmsRelTable_if_ctx.user_ctx = reg_ptr;
+
+    /*
+     * call data access initialization code
+     */
+    rdbmsRelTable_init_data(reg_ptr);
+
+    /*
+     * set up the container
+     */
+    _rdbmsRelTable_container_init(&rdbmsRelTable_if_ctx);
+    if (NULL == rdbmsRelTable_if_ctx.container) {
+        snmp_log(LOG_ERR,"could not initialize container for rdbmsRelTable\n");
+        return;
+    }
+    
+    /*
+     * access_multiplexer: REQUIRED wrapper for get request handling
+     */
+    access_multiplexer->object_lookup = _mfd_rdbmsRelTable_object_lookup;
+    access_multiplexer->get_values = _mfd_rdbmsRelTable_get_values;
+
+    /*
+     * no wrappers yet
+     */
+    access_multiplexer->pre_request = _mfd_rdbmsRelTable_pre_request;
+    access_multiplexer->post_request = _mfd_rdbmsRelTable_post_request;
+
+
+    /*************************************************
+     *
+     * Create a registration, save our reg data, register table.
+     */
+    DEBUGMSGTL(("rdbmsRelTable:init_rdbmsRelTable",
+                "Registering rdbmsRelTable as a mibs-for-dummies table.\n"));		 
+    handler = netsnmp_baby_steps_access_multiplexer_get(access_multiplexer);
+    reginfo = netsnmp_handler_registration_create("rdbmsRelTable", handler,
+                                                  rdbmsRelTable_oid,
+                                                  rdbmsRelTable_oid_size,
+                                                  HANDLER_CAN_BABY_STEP |
+                                                  HANDLER_CAN_RONLY
+                                                  );
+    if(NULL == reginfo) {
+        snmp_log(LOG_ERR,"error registering table rdbmsRelTable\n");
+        return;
+    }
+    reginfo->my_reg_void = &rdbmsRelTable_if_ctx;
+
+    /*************************************************
+     *
+     * set up baby steps handler, create it and inject it
+     */
+    if( access_multiplexer->object_lookup )
+        mfd_modes |= BABY_STEP_OBJECT_LOOKUP;
+    if( access_multiplexer->set_values )
+        mfd_modes |= BABY_STEP_SET_VALUES;
+    if( access_multiplexer->irreversible_commit )
+        mfd_modes |= BABY_STEP_IRREVERSIBLE_COMMIT;
+    if( access_multiplexer->object_syntax_checks )
+        mfd_modes |= BABY_STEP_CHECK_OBJECT;
+
+    if( access_multiplexer->pre_request )
+        mfd_modes |= BABY_STEP_PRE_REQUEST;
+    if( access_multiplexer->post_request )
+        mfd_modes |= BABY_STEP_POST_REQUEST;
+    
+    if( access_multiplexer->undo_setup )
+        mfd_modes |= BABY_STEP_UNDO_SETUP;
+    if( access_multiplexer->undo_cleanup )
+        mfd_modes |= BABY_STEP_UNDO_CLEANUP;
+    if( access_multiplexer->undo_sets )
+        mfd_modes |= BABY_STEP_UNDO_SETS;
+    
+    if( access_multiplexer->row_creation )
+        mfd_modes |= BABY_STEP_ROW_CREATE;
+    if( access_multiplexer->consistency_checks )
+        mfd_modes |= BABY_STEP_CHECK_CONSISTENCY;
+    if( access_multiplexer->commit )
+        mfd_modes |= BABY_STEP_COMMIT;
+    if( access_multiplexer->undo_commit )
+        mfd_modes |= BABY_STEP_UNDO_COMMIT;
+    
+    handler = netsnmp_baby_steps_handler_get(mfd_modes);
+    netsnmp_inject_handler(reginfo, handler);
+
+    /*************************************************
+     *
+     * inject row_merge helper with prefix rootoid_len + 2 (entry.col)
+     */
+    handler = netsnmp_get_row_merge_handler(reginfo->rootoid_len + 2);
+    netsnmp_inject_handler(reginfo, handler);
+
+    /*************************************************
+     *
+     * inject container_table helper
+     */
+    handler =
+        netsnmp_container_table_handler_get(tbl_info,
+                                            rdbmsRelTable_if_ctx.container,
+                                            TABLE_CONTAINER_KEY_NETSNMP_INDEX);
+    netsnmp_inject_handler( reginfo, handler );
+
+    /*************************************************
+     *
+     * inject cache helper
+     */
+    if(NULL != rdbmsRelTable_if_ctx.cache) {
+        handler = netsnmp_cache_handler_get(rdbmsRelTable_if_ctx.cache);
+        netsnmp_inject_handler( reginfo, handler );
+    }
+
+    /*
+     * register table
+     */
+    netsnmp_register_table(reginfo, tbl_info);
+} /* _rdbmsRelTable_initialize_interface */
+
+void
+rdbmsRelTable_valid_columns_set(netsnmp_column_info *vc)
+{
+    rdbmsRelTable_if_ctx.tbl_info.valid_columns = vc;
+} /* rdbmsRelTable_valid_columns_set */
+
+/**
+ * @internal
+ * convert the index component stored in the context to an oid
+ */
+int
+rdbmsRelTable_index_to_oid(netsnmp_index *oid_idx,
+                         rdbmsRelTable_mib_index *mib_idx)
+{
+    int err = SNMP_ERR_NOERROR;
+    
+    /*
+     * temp storage for parsing indexes
+     */
+    /*
+     * rdbmsDbIndex(1)/INTEGER/ASN_INTEGER/long(long)//l/a/w/e/R/d/h
+     */
+    netsnmp_variable_list var_rdbmsDbIndex;
+    /*
+     * applIndex(1)/INTEGER/ASN_INTEGER/long(long)//l/a/w/e/R/d/h
+     */
+    netsnmp_variable_list var_applIndex;
+
+    /*
+     * set up varbinds
+     */
+    memset( &var_rdbmsDbIndex, 0x00, sizeof(var_rdbmsDbIndex) );
+    var_rdbmsDbIndex.type = ASN_INTEGER;
+    memset( &var_applIndex, 0x00, sizeof(var_applIndex) );
+    var_applIndex.type = ASN_INTEGER;
+
+    /*
+     * chain temp index varbinds together
+     */
+    var_rdbmsDbIndex.next_variable =  &var_applIndex; var_applIndex.next_variable =  NULL;
+
+
+    DEBUGMSGTL(("verbose:rdbmsRelTable:rdbmsRelTable_index_to_oid","called\n"));
+
+        /* rdbmsDbIndex(1)/INTEGER/ASN_INTEGER/long(long)//l/a/w/e/R/d/h */
+    snmp_set_var_value(&var_rdbmsDbIndex, (u_char*)&mib_idx->rdbmsDbIndex,
+                       sizeof(mib_idx->rdbmsDbIndex));
+
+        /* applIndex(1)/INTEGER/ASN_INTEGER/long(long)//l/a/w/e/R/d/h */
+    snmp_set_var_value(&var_applIndex, (u_char*)&mib_idx->applIndex,
+                       sizeof(mib_idx->applIndex));
+
+
+    err = build_oid_noalloc(oid_idx->oids, oid_idx->len, (size_t *)&oid_idx->len,
+                           NULL, 0, &var_rdbmsDbIndex);
+    if(err)
+        snmp_log(LOG_ERR,"error %d converting index to oid\n", err);
+
+    /*
+     * parsing may have allocated memory. free it.
+     */
+    snmp_reset_var_buffers( &var_rdbmsDbIndex );
+
+    return err;
+} /* rdbmsRelTable_index_to_oid */
+
+/**
+ * extract rdbmsRelTable indexes from a netsnmp_index
+ *
+ * @retval SNMP_ERR_NOERROR  : no error
+ * @retval SNMP_ERR_GENERR   : error
+ */
+int
+rdbmsRelTable_index_from_oid(netsnmp_index *oid_idx,
+                         rdbmsRelTable_mib_index *mib_idx)
+{
+    int err = SNMP_ERR_NOERROR;
+    
+    /*
+     * temp storage for parsing indexes
+     */
+    /*
+     * rdbmsDbIndex(1)/INTEGER/ASN_INTEGER/long(long)//l/a/w/e/R/d/h
+     */
+    netsnmp_variable_list var_rdbmsDbIndex;
+    /*
+     * applIndex(1)/INTEGER/ASN_INTEGER/long(long)//l/a/w/e/R/d/h
+     */
+    netsnmp_variable_list var_applIndex;
+
+    /*
+     * set up varbinds
+     */
+    memset( &var_rdbmsDbIndex, 0x00, sizeof(var_rdbmsDbIndex) );
+    var_rdbmsDbIndex.type = ASN_INTEGER;
+    memset( &var_applIndex, 0x00, sizeof(var_applIndex) );
+    var_applIndex.type = ASN_INTEGER;
+
+    /*
+     * chain temp index varbinds together
+     */
+    var_rdbmsDbIndex.next_variable =  &var_applIndex; var_applIndex.next_variable =  NULL;
+
+
+    DEBUGMSGTL(("verbose:rdbmsRelTable:rdbmsRelTable_index_from_oid","called\n"));
+
+    /*
+     * parse the oid into the individual index components
+     */
+    err = parse_oid_indexes( oid_idx->oids, oid_idx->len,
+                             &var_rdbmsDbIndex );
+    if (err == SNMP_ERR_NOERROR) {
+        /*
+         * copy out values
+         */
+    mib_idx->rdbmsDbIndex = *((long *)var_rdbmsDbIndex.val.string);
+    mib_idx->applIndex = *((long *)var_applIndex.val.string);
+
+
+    }
+
+    /*
+     * parsing may have allocated memory. free it.
+     */
+    snmp_reset_var_buffers( &var_rdbmsDbIndex );
+
+    return err;
+} /* rdbmsRelTable_index_from_oid */
+
+
+/* *********************************************************************
+ * @internal
+ * allocate resources for a rdbmsRelTable_rowreq_ctx
+ */
+rdbmsRelTable_rowreq_ctx *
+rdbmsRelTable_allocate_rowreq_ctx(void)
+{
+    rdbmsRelTable_rowreq_ctx *rowreq_ctx =
+                  SNMP_MALLOC_TYPEDEF(rdbmsRelTable_rowreq_ctx);
+
+    DEBUGMSGTL(("internal:rdbmsRelTable:rdbmsRelTable_allocate_rowreq_ctx","called\n"));
+
+    if(NULL == rowreq_ctx) {
+        snmp_log(LOG_ERR,"Couldn't allocate memory for a "
+                 "rdbmsRelTable_rowreq_ctx.\n");
+    }
+
+    rowreq_ctx->oid_idx.oids = rowreq_ctx->oid_tmp;
+
+    rowreq_ctx->rdbmsRelTable_data_list = NULL;
+    rowreq_ctx->rdbmsRelTable_reg = rdbmsRelTable_if_ctx.user_ctx;
+
+
+    return rowreq_ctx;
+} /* rdbmsRelTable_allocate_rowreq_ctx */
+
+/*
+ * @internal
+ * release resources for a rdbmsRelTable_rowreq_ctx
+ */
+void
+rdbmsRelTable_release_rowreq_ctx(rdbmsRelTable_rowreq_ctx *rowreq_ctx)
+{
+    DEBUGMSGTL(("internal:rdbmsRelTable:rdbmsRelTable_release_rowreq_ctx","called\n"));
+
+    netsnmp_assert(NULL != rowreq_ctx);
+    
+
+    /*
+     * free index oid pointer
+     */
+    if(rowreq_ctx->oid_idx.oids != rowreq_ctx->oid_tmp)
+        free(rowreq_ctx->oid_idx.oids);
+
+    SNMP_FREE(rowreq_ctx);
+} /* rdbmsRelTable_release_rowreq_ctx */
+
+/**
+ * @internal
+ * wrapper
+ */
+static int
+_mfd_rdbmsRelTable_pre_request(netsnmp_mib_handler *handler,
+                            netsnmp_handler_registration *reginfo,
+                            netsnmp_agent_request_info *agtreq_info,
+                            netsnmp_request_info *requests)
+{
+    int rc = rdbmsRelTable_pre_request(rdbmsRelTable_if_ctx.user_ctx);
+    if (MFD_SUCCESS != rc) {
+        /*
+         * nothing we can do about it but log it
+         */
+        DEBUGMSGTL(("internal:rdbmsRelTable","error %d from "
+                    "rdbmsRelTable_pre_request\n", rc));
+        netsnmp_request_set_error_all(requests, SNMP_VALIDATE_ERR(rc));
+    }
+    
+    return SNMP_ERR_NOERROR;
+} /* _mfd_rdbmsRelTable_pre_request */
+
+/**
+ * @internal
+ * wrapper
+ */
+static int
+_mfd_rdbmsRelTable_post_request(netsnmp_mib_handler *handler,
+                             netsnmp_handler_registration *reginfo,
+                             netsnmp_agent_request_info *agtreq_info,
+                             netsnmp_request_info *requests)
+{
+    rdbmsRelTable_rowreq_ctx *rowreq_ctx;
+    int rc = rdbmsRelTable_post_request(rdbmsRelTable_if_ctx.user_ctx);
+    if (MFD_SUCCESS != rc) {
+        /*
+         * nothing we can do about it but log it
+         */
+        DEBUGMSGTL(("internal:rdbmsRelTable","error %d from "
+                    "rdbmsRelTable_post_request\n", rc));
+    }
+    
+    /*
+     * if there are no errors, check for and handle row creation/deletion
+     */
+    rc = netsnmp_check_requests_error(requests);
+    if ((SNMP_ERR_NOERROR == rc) &&
+        (NULL !=
+         (rowreq_ctx = netsnmp_container_table_row_extract(requests)))) {
+        if (rowreq_ctx->rowreq_flags & MFD_ROW_CREATED) {
+            rowreq_ctx->rowreq_flags &= ~MFD_ROW_CREATED;
+            CONTAINER_INSERT(rdbmsRelTable_if_ctx.container, rowreq_ctx);
+        }
+        else if (rowreq_ctx->rowreq_flags & MFD_ROW_DELETED) {
+            CONTAINER_REMOVE(rdbmsRelTable_if_ctx.container, rowreq_ctx);
+            rdbmsRelTable_release_rowreq_ctx(rowreq_ctx);
+        }
+    }
+
+    return SNMP_ERR_NOERROR;
+} /* _mfd_rdbmsRelTable_post_request */
+
+/**
+ * @internal
+ * wrapper
+ */
+static int
+_mfd_rdbmsRelTable_object_lookup(netsnmp_mib_handler *handler,
+                         netsnmp_handler_registration *reginfo,
+                         netsnmp_agent_request_info *agtreq_info,
+                         netsnmp_request_info *requests)
+{
+    rdbmsRelTable_rowreq_ctx *rowreq_ctx =
+                  netsnmp_container_table_row_extract(requests);
+    
+    DEBUGMSGTL(("internal:rdbmsRelTable:_mfd_rdbmsRelTable_object_lookup","called\n"));
+
+    /*
+     * get our context from mfd
+     * rdbmsRelTable_interface_ctx *if_ctx =
+     *             (rdbmsRelTable_interface_ctx *)reginfo->my_reg_void;
+     */
+
+    if(NULL == rowreq_ctx) {
+        netsnmp_request_set_error_all(requests, SNMP_ERR_NOCREATION);
+    }
+    else {
+        rdbmsRelTable_row_prep(rowreq_ctx);
+    }
+
+    return SNMP_ERR_NOERROR;
+} /* _mfd_rdbmsRelTable_object_lookup */
+
+/***********************************************************************
+ *
+ * GET processing
+ *
+ ***********************************************************************/
+/*
+ * @internal
+ * Retrieve the value for a particular column
+ */
+NETSNMP_STATIC_INLINE int
+_rdbmsRelTable_get_column( rdbmsRelTable_rowreq_ctx *rowreq_ctx,
+                       netsnmp_variable_list *var, int column )
+{
+    int rc = SNMPERR_SUCCESS;
+    
+    DEBUGMSGTL(("internal:rdbmsRelTable:_mfd_rdbmsRelTable_get_column","called\n"));
+
+
+    netsnmp_assert(NULL != rowreq_ctx);
+
+    switch(column) {
+
+    /* rdbmsRelState(1)/INTEGER/ASN_INTEGER/long(u_long)//l/A/w/E/r/d/h */
+    case COLUMN_RDBMSRELSTATE:
+    var->val_len = sizeof(u_long);
+    var->type = ASN_INTEGER;
+rc = rdbmsRelState_get(rowreq_ctx, (u_long *)var->val.string );
+        break;
+
+    /* rdbmsRelActiveTime(2)/DateAndTime/ASN_OCTET_STR/char(char)//L/A/w/e/R/d/H */
+    case COLUMN_RDBMSRELACTIVETIME:
+    var->type = ASN_OCTET_STR;
+rc = rdbmsRelActiveTime_get(rowreq_ctx, (char **)&var->val.string, &var->val_len );
+        break;
+
+     default:
+         snmp_log(LOG_ERR,"unknown column %d in _rdbmsRelTable_get_column\n", column);
+         break;
+    }
+
+    return rc;
+} /* _rdbmsRelTable_get_column */
+
+int
+_mfd_rdbmsRelTable_get_values(netsnmp_mib_handler *handler,
+                         netsnmp_handler_registration *reginfo,
+                         netsnmp_agent_request_info *agtreq_info,
+                         netsnmp_request_info *requests)
+{
+    rdbmsRelTable_rowreq_ctx *rowreq_ctx =
+                  netsnmp_container_table_row_extract(requests);
+    netsnmp_table_request_info * tri;
+    u_char                     * old_string;
+    void                      (*dataFreeHook)(void *);
+    int                        rc;
+
+    DEBUGMSGTL(("internal:rdbmsRelTable:_mfd_rdbmsRelTable_get_values","called\n"));
+
+    netsnmp_assert(NULL != rowreq_ctx);
+    
+    for(;requests; requests = requests->next) {
+        /*
+         * save old pointer, so we can free it if replaced
+         */
+        old_string = requests->requestvb->val.string;
+        dataFreeHook = requests->requestvb->dataFreeHook;
+        if(NULL == requests->requestvb->val.string) {
+            requests->requestvb->val.string = requests->requestvb->buf;
+            requests->requestvb->val_len = sizeof(requests->requestvb->buf);
+        }
+        else if(requests->requestvb->buf == requests->requestvb->val.string) {
+            if(requests->requestvb->val_len != sizeof(requests->requestvb->buf))
+                requests->requestvb->val_len = sizeof(requests->requestvb->buf);
+        }
+
+        /*
+         * get column data
+         */
+        tri = netsnmp_extract_table_info(requests);
+        if(NULL == tri)
+            continue;
+        
+        rc = _rdbmsRelTable_get_column(rowreq_ctx, requests->requestvb, tri->colnum);
+        if(rc) {
+            if(MFD_SKIP == rc) {
+                requests->requestvb->type = ASN_PRIV_RETRY;
+                rc = SNMP_ERR_NOERROR;
+            }
+        }
+        else if (NULL == requests->requestvb->val.string) {
+            snmp_log(LOG_ERR,"NULL varbind data pointer!\n");
+            rc = SNMP_ERR_GENERR;
+        }
+        if(rc)
+            netsnmp_request_set_error(requests, SNMP_VALIDATE_ERR(rc));
+
+        /*
+         * if the buffer wasn't used previously for the old data (i.e. it
+         * was allcoated memory)  and the get routine replaced the pointer,
+         * we need to free the previous pointer.
+         */
+        if(old_string && (old_string != requests->requestvb->buf) &&
+           (requests->requestvb->val.string != old_string)) {
+            if(dataFreeHook)
+                (*dataFreeHook)(old_string);
+            else
+                free(old_string);
+        }
+    } /* for results */
+
+    return SNMP_ERR_NOERROR;
+} /* _mfd_rdbmsRelTable_get_values */
+
+/***********************************************************************
+ *
+ * SET processing
+ *
+ ***********************************************************************/
+
+/*
+ * NOT APPLICABLE (per MIB or user setting)
+ */
+/***********************************************************************
+ *
+ * DATA ACCESS
+ *
+ ***********************************************************************/
+/**
+ * @internal
+ */
+static int
+_cache_load(netsnmp_cache *cache, void *vmagic)
+{
+    DEBUGMSGTL(("internal:rdbmsRelTable:_cache_load","called\n"));
+
+    if((NULL == cache) || (NULL == cache->magic)) {
+        snmp_log(LOG_ERR, "invalid cache for rdbmsRelTable_cache_load\n");
+        return -1;
+    }
+
+    /** should only be called for an invalid or expired cache */
+    netsnmp_assert((0 == cache->valid) || (1 == cache->expired));
+    
+    /*
+     * call user code
+     */
+    return rdbmsRelTable_cache_load((netsnmp_container*)cache->magic);
+} /* _cache_load */
+
+/**
+ * @internal
+ */
+static void
+_cache_item_free(rdbmsRelTable_rowreq_ctx *rowreq_ctx, void *context)
+{
+    DEBUGMSGTL(("internal:rdbmsRelTable:_cache_item_free","called\n"));
+
+    if(NULL == rowreq_ctx)
+        return;
+
+    rdbmsRelTable_release_rowreq_ctx(rowreq_ctx);
+} /* _cache_item_free */
+
+/**
+ * @internal
+ */
+static void
+_cache_free(netsnmp_cache *cache, void *magic)
+{
+    netsnmp_container *container;
+
+    DEBUGMSGTL(("internal:rdbmsRelTable:_cache_free","called\n"));
+
+    if((NULL == cache) || (NULL == cache->magic)) {
+        snmp_log(LOG_ERR, "invalid cache in rdbmsRelTable_cache_free\n");
+        return;
+    }
+
+    container = (netsnmp_container*)cache->magic;
+
+    /*
+     * call user code
+     */
+    rdbmsRelTable_cache_free(container);
+    
+    /*
+     * free all items. inefficient, but easy.
+     */
+    CONTAINER_CLEAR(container,
+                    (netsnmp_container_obj_func *)_cache_item_free,
+                    NULL);
+} /* _cache_free */
+
+/**
+ * @internal
+ * initialize the iterator container with functions or wrappers
+ */
+void
+_rdbmsRelTable_container_init(rdbmsRelTable_interface_ctx *if_ctx)
+{
+    DEBUGMSGTL(("internal:rdbmsRelTable:_rdbmsRelTable_container_init","called\n"));
+    
+    /*
+     * set up the cache
+     */
+    if_ctx->cache = netsnmp_cache_create(30, /* timeout in seconds */
+                                         _cache_load, _cache_free,
+                                         rdbmsRelTable_oid,
+                                         rdbmsRelTable_oid_size);
+
+    if(NULL == if_ctx->cache) {
+        snmp_log(LOG_ERR, "error creating cache for rdbmsRelTable\n");
+        return;
+    }
+
+    if_ctx->cache->flags = NETSNMP_CACHE_DONT_INVALIDATE_ON_SET;
+
+    rdbmsRelTable_container_init(&if_ctx->container, if_ctx->cache);
+    if(NULL == if_ctx->container)
+        if_ctx->container = netsnmp_container_find("rdbmsRelTable:table_container");
+    if(NULL == if_ctx->container) {
+        snmp_log(LOG_ERR,"error creating container in "
+                 "rdbmsRelTable_container_init\n");
+        return;
+    }
+    if_ctx->cache->magic = (void*)if_ctx->container;
+} /* _rdbmsRelTable_container_init */
+
diff --git a/RDBMS-MIB_src/rdbmsRelTable/rdbmsRelTable_interface.h b/RDBMS-MIB_src/rdbmsRelTable/rdbmsRelTable_interface.h
new file mode 100644
index 0000000..148c92d
--- /dev/null
+++ b/RDBMS-MIB_src/rdbmsRelTable/rdbmsRelTable_interface.h
@@ -0,0 +1,50 @@
+/*-------------------------------------------------------------------------
+ * rdbmsRelTable_interface.h
+ *
+ *      RDBMSMIB mib module.
+ *
+ *      Copyright (c) 2004-2007, PostgreSQL Global Development Group
+ *      Author: Joshua Tolley
+ *
+ * $Id: rdbmsRelTable_interface.h,v 1.2 2007/09/13 14:20:44 h-saito Exp $
+ *
+ *-------------------------------------------------------------------------
+ */
+
+#ifndef RDBMSRELTABLE_INTERFACE_H
+#define RDBMSRELTABLE_INTERFACE_H
+
+#ifdef __cplusplus
+extern "C" {
+#endif
+
+
+#include "rdbmsRelTable.h"
+
+/* ********************************************************************
+ * Table declarations
+ */
+
+/* PUBLIC interface initialization routine */
+void _rdbmsRelTable_initialize_interface(rdbmsRelTable_registration_ptr user_ctx,
+                                    u_long flags);
+
+    rdbmsRelTable_rowreq_ctx * rdbmsRelTable_allocate_rowreq_ctx(void);
+void rdbmsRelTable_release_rowreq_ctx(rdbmsRelTable_rowreq_ctx *rowreq_ctx);
+
+int rdbmsRelTable_index_to_oid(netsnmp_index *oid_idx,
+                            rdbmsRelTable_mib_index *mib_idx);
+int rdbmsRelTable_index_from_oid(netsnmp_index *oid_idx,
+                              rdbmsRelTable_mib_index *mib_idx);
+
+/*
+ * access to certain internals. use with caution!
+ */
+void rdbmsRelTable_valid_columns_set(netsnmp_column_info *vc);
+
+
+#ifdef __cplusplus
+}
+#endif
+
+#endif /* RDBMSRELTABLE_INTERFACE_H */
diff --git a/RDBMS-MIB_src/rdbmsRelTable/rdbmsRelTable_oids.h b/RDBMS-MIB_src/rdbmsRelTable/rdbmsRelTable_oids.h
new file mode 100644
index 0000000..371f101
--- /dev/null
+++ b/RDBMS-MIB_src/rdbmsRelTable/rdbmsRelTable_oids.h
@@ -0,0 +1,35 @@
+/*-------------------------------------------------------------------------
+ * rdbmsRelTable_oids.h
+ *
+ *      RDBMSMIB mib module.
+ *
+ *      Copyright (c) 2004-2007, PostgreSQL Global Development Group
+ *      Author: Joshua Tolley
+ *
+ * $Id: rdbmsRelTable_oids.h,v 1.2 2007/09/13 14:20:44 h-saito Exp $
+ *
+ *-------------------------------------------------------------------------
+ */
+
+#ifndef RDBMSRELTABLE_OIDS_H
+#define RDBMSRELTABLE_OIDS_H
+
+#ifdef __cplusplus
+extern "C" {
+#endif
+
+
+/* column number definitions for table rdbmsRelTable */
+#define RDBMSRELTABLE_OID              1,3,6,1,2,1,39,1,9
+#define COLUMN_RDBMSRELSTATE		1
+#define COLUMN_RDBMSRELACTIVETIME		2
+
+#define RDBMSRELTABLE_MIN_COL		COLUMN_RDBMSRELSTATE
+#define RDBMSRELTABLE_MAX_COL		COLUMN_RDBMSRELACTIVETIME
+
+
+#ifdef __cplusplus
+}
+#endif
+
+#endif /* RDBMSRELTABLE_OIDS_H */