Re: MCP DMSII Program statistics

On Mar 5, 2:28 pm, "BillyPIg" <o...@xxxxxxxxx> wrote:
Maybe on the V Series, but not on the A.  WYSIWYGot.

Pig"Vern" <VLfar...@xxxxxxxxxxx> wrote in message

news:7db67a5a-600e-40af-8c28-d8ab5a4499dd@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx



Folks,

What happened to these ?

I searched the Unisys docs for MCP 11.0 and there are Global and
structure stats...but for the programs it appeared to have gone away.

I used these 15 years ago on A and V series.

I would think that SYSTEM/DBMONITOR would include these, as they are
important to know how programs are accessing databases in a production
env.

Thanks, Vern- Hide quoted text -

- Show quoted text -

That's too bad, but I'm afraid its true.

I once saved Unisys from a lawsuit when they moved from Medium Systems
Thrift (flat file) to a DMSII based product on a V-530 on those
program stats alone as the converted programs were running poorly due
to poor data conversion.

I have a daily run of SYSTEM/LOGGER showing me the processor hogs. We
can examine those hogs further, but we don't know how many processor
cycles are getting eaten up by the data, bad user input, or poor
programming that may cause unnecessary DMSII (Enterprise Server
Database) error processing.

This site has VIEWPOINT also, which is using quite a bit of processor
sampling.

The goal, mandated by management is to reduce the monthly MIP$ usage.

~ Vern
.

Relevant Pages

  • Re: What is your database application development environment?
    ... development environment. ... Production - Test - Sandbox ... Most call it Dev, Test-QA, Production, but whatever you call it, this is the ... Dev databases are much smaller. ...
    (borland.public.delphi.non-technical)
  • Re: Compare data in tables of different structures
    ... Currently we have two Oralce 9i databases in the production ... We synchronize them *logically* every day. ... differences first only, not solve them at this stage. ... and we will migrate this system to a new one, but at this moment we have to solve this for the production people. ...
    (comp.databases.oracle.server)
  • Re: how to find differences between production and test databases
    ... At the moment both databases have exactly the same metadata i.e. tables ... The production database differs in a handful of rows. ... For non-PK fields, doing a JOIN between both tables on the PK and specifying ... for NULL in the WHERE clause. ...
    (microsoft.public.data.ado)
  • strange Problem
    ... I have 2 Services on our production System ... that links 2 separate databases ... updates and selects i use ...
    (comp.databases.ms-sqlserver)