You could use the listf <fileset> ,9 to show locks or if it's a database
file you can also use DBUTIL "show <db> locks" to view files.
-----Original Message-----
From: HP-3000 Systems Discussion [mailto:[log in to unmask]] On
Behalf Of Tony Summers
Sent: Monday, April 10, 2006 9:24 AM
To: [log in to unmask]
Subject: [HP3000-L] Access to system tables
Anyone any advice on accessing the HP3000 system tables - in particular
I want to be able find what files currently have an FLOCK on them.
(Background - we have on-going system performance problems; our
"amateur" observations in glance suggest our applications are impeding
due to high number of FLOCKs and/or Control Block waits : but several
traces in our in-house database handler have failed to identify any
major bottleneck; we suspect a rather subtle mix of third party
products and own applications are causing MPE to struggle and report
high number of impedes: e.g. processes slowing down and/or constantly
be swapped in and out of the MPE dispatcher. We have, at HP's
suggestion, system maintenance planned for Easter weekend, but I'm being
rather pessimistic that the cause is self-inflicted and thus won't go
away.
Thanks in advance.
For our in-depth analysis of the budget, visit our website at
www.smith.williamson.co.uk
The contents of this email are confidential to the intended recipient
and may not be disclosed. Although it is believed that this email and
any attachments are virus free, it is the responsibility of the
recipient to confirm this.
Smith & Williamson Corporate Finance Limited - A member of the London
Stock Exchange.
A member of M&A International Inc. http://www.mergers.net Registered in
England No. 4533970. Authorised and regulated by the Financial Services
Authority Smith & Williamson Investment Management Limited, Registered
No. 976145. Authorised and regulated by the Financial Services
Authority.
Smith & Williamson Pension Consultancy Limited - Independent
Intermediary. Registered No. 3133226. Authorised and regulated by the
Financial Services Authority.
Smith & Williamson Fund Administration Limited, Registered No. 1934644.
Authorised and regulated by the Financial Services Authority.
Smith & Williamson Limited - A member of Nexia International.
Registered in England No. 4534022. Regulated by the Institute of
Chartered Accountants in England & Wales for a range of investment
business activities.
NCL Investments Limited, Registered No. 1913794.
Member of the London Stock Exchange authorised and regulated by the
Financial Services Authority.
Registered Office: 25 Moorgate, London EC2R 6AY
Telephone: 020 7131 4000 http://www.smith.williamson.co.uk
Nexia Audit Limited - A member of Nexia International. Registered in
England No. 4469576. Registered to carry on audit work and regulated by
the Institute of Chartered Accountants in England & Wales for a range of
investment business activities.
Registered Office: 25 Moorgate, London EC2R 6AY
Telephone: 020 7131 4000 http://www.nexiaaudit.co.uk
______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email
______________________________________________________________________
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
|