Admin tools available
Posted in 2015
A user asked for a tool to apply identical schema changes to multiple databases in multi-tenant instances at once (management didn't want a script), and for a way to track how often stored procedures are used. Paul Watson suggested GRID, but Art Kagel clarified GRID is for distributing schema across ER servers, not multiple databases on one server, and recommended scripts or an ESQL/C (or Perl) program instead. For SPL usage, Kagel said you must instrument each procedure to log calls; Mark Scranton later noted his Watcher tool samples "onstat -g prc" every couple of minutes for an approximate picture. No single off-the-shelf tool was identified.
Topics: Stored Procedures & SPL
We're going to be implementing multi-tenant instances. The schema will all be in sync and the same so we're going to have to update them all at one time. I have been asked to find a product that will do this rather than write a script to do it. For example I will have instance that has db1 and db2 in it with a schema change for both. We will need to put the schema into both databases at the same time with one tool. Does anyone know of a tool available that can do anything like this? Also I need to know how often stored procedures are being used. I can't find a query that can show me this leading to my assumption that Informix doesn't track this. If it doesn't does something else? Thanks.
Sounds like a GRID command to me -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of NATE HICKS Sent: Wednesday, December 16, 2015 12:29 PM To: ids@iiug.org Subject: Admin tools available [36265] We're going to be implementing multi-tenant instances. The schema will all be in sync and the same so we're going to have to update them all at one time. I have been asked to find a product that will do this rather than write a script to do it. For example I will have instance that has db1 and db2 in it with a schema change for both. We will need to put the schema into both databases at the same time with one tool. Does anyone know of a tool available that can do anything like this? Also I need to know how often stored procedures are being used. I can't find a query that can show me this leading to my assumption that Informix doesn't track this. If it doesn't does something else? Thanks. **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum.
The only way to track procedure usage would be to instrument each proc to log its usage. Art On Dec 16, 2015 12:29, "NATE HICKS" <nathaniel.hicks@trnswrks.com> wrote: > We're going to be implementing multi-tenant instances. The schema will all > be > in sync and the same so we're going to have to update them all at one > time. I > have been asked to find a product that will do this rather than write a > script > to do it. For example I will have instance that has db1 and db2 in it with > a > schema change for both. We will need to put the schema into both databases > at > the same time with one tool. Does anyone know of a tool available that can > do > anything like this? > > Also I need to know how often stored procedures are being used. I can't > find a > query that can show me this leading to my assumption that Informix doesn't > track this. If it doesn't does something else? > > Thanks. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a113fe51e2391e805270ca9f2
GRID is replication though isn't it? The schemas will all be the same. The data will all be different. I guess I don't remember for sure what all you can do with grid but will have to look into it again.
That's what I was afraid of... Thank you Art!
GRID is for managing the schemas of a database distributed across multiple ER servers. NOT for managing the schema of multiple databases on the same server! Not even multi-tenant databases. Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.com Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Thu, Dec 17, 2015 at 8:35 AM, NATE HICKS <nathaniel.hicks@trnswrks.com> wrote: > GRID is replication though isn't it? The schemas will all be the same. The > data will all be different. I guess I don't remember for sure what all you > can > do with grid but will have to look into it again. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --089e0103e4cebfce430527192edb
Scripts are your friend! Or if the bosses just don't like scripts, write it as an ESQL/C application! (Or even Perl if they don't equate Perl with scripting.) Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.com Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Thu, Dec 17, 2015 at 8:36 AM, NATE HICKS <nathaniel.hicks@trnswrks.com> wrote: > That's what I was afraid of... > > Thank you Art! > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a1140a38824d4870527193327
My Watcher collects SPL usage all the time. It uses "onstat -g prc" during
it's collection that runs about every 2 mins. We can always tells which SPL is
the most active, etc. Since it only runs every 2 mins (the average Watcher
cycle) there is of course a gap where some can be missed. But it's a good
thumbnail of SPL activity.
Thanks -
Mark Scranton
The Mark Scranton Group
mark@markscranton.com