Re: Dependent table row updation

2009/4/20 chandan <[email protected]>:
> Actually the two dependent tables are related to each other by indicies i.e
> there exists an expansion relationship between the two tables T1 and T2.

> So in this case is it possible to insert a new row into the expansion table
> which has values for baseIndex1 and baseIndex2 which do not exist in the
> base table?

I don't know.
What do these tables actually represent?  Does it make sense for
there to be an entry in T2, without a corresponding entry in T1?

Remember that MIB structures don't exist in isolation.
The whole purpose of SNMP is to report "management information",
i.e.  information about some aspect of the system being managed.
So you should always come back to the question of what does
this mean in reality.

For example, the Host Resources MIB contains two tables relating
to the processes running on the system - hrSWRunTable and
hrSWRunPerfTable.
   hrSWRunTable contains "static" information about each process
(the name of the program, arguments, processID, etc), while
hrSWRunPerfTable contains dynamic performance metrics
(CPU time and memory usage).

  So can you have a row in the hrSWRunPerfTable without a
corresponding row in the hrSWRunTable?   Which boils down
to asking
   Can you have a process using CPU and memory, without
also having a name, arguments, processID, etc?
  In this case, the answer is obviously no - a process will
inherently have all these attributes, so it doesn't make sense
to have a row in T2 (hrSWRunPerfTable) without a matching
row in T1 (hrSWRunTable).


   Now you've consistently said nothing about what your tables
are actually modelling, so I can't really comment about whether
you can extend T2 without affecting T1.
   My gut reaction is probably not - adding a row to T2 would
almost inevitably involve extending T1 as well (either explicitly
or implicitly).   But you'll have to decide this for yourself, based
on the real-life subsystem that you are trying to manage.

Dave

------------------------------------------------------------------------------
Stay on top of everything new and different, both inside and 
around Java (TM) technology - register by April 22, and save
$200 on the JavaOne (SM) conference, June 2-5, 2009, San Francisco.
300 plus technical and hands-on sessions. Register today. 
Use priority code J9JMT32. http://p.sf.net/sfu/p
_______________________________________________
Net-snmp-users mailing list
[email protected]
Please see the following page to unsubscribe or change other options:
https://lists.sourceforge.net/lists/listinfo/net-snmp-users