Kbase 15250: proshut output is paged in V7 - how to workaround
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
5/10/1998 |
|
proshut output is paged in V7 - how to workaround
The output from the proshut utility is paged in V7 and was not paged
in V6. Some customers may desire the non-paged output functionality
of V6.
A workaround is to use promon instead of proshut to get information
about users connected to the database. This information can be
obtained from the "User Control" option in the main menu of promon.
The "Modify Defaults" option of promon has an option to set the page
size. To achieve "non-paged" output, the page size can be set to a
value that is large enough so that all output will be outputted with
no paging in between.
NOTE: Selecting 8 (Shut Down Database) will be paged because this
selection executes proshut (not promon).
Example:
PROGRESS MONITOR Version 7
Database: /tmp_mnt/users/ts/pduros/work/v7demo
1. User Control
2. Locking and Waiting Statistics
3. Block Access
4. Record Locking Table
5. Activity
6. Shared Resources
7. Database Status
8. Shut Down Database
T. Transactions Control
L. Resolve Limbo Transactions
C. Coordinator Information
M. Modify Defaults
Q. Quit
Enter your selection: M
1 Page size: 24
2 Clear screen for first page: Yes
3 Short pause after each page: 4
4 Long pause after last page: 8
5 Monitor Sampling Interval: 30 sec.
6 APW queue delay: 100 ms.
7 APW queue start: 1
8 APW scan delay: 1 sec.
9 APW scan count: 1
a APW write limit: 25
Enter your selection: 1
Page size: 250
-> Notice the page size is now set to 250 for promon output.
Another workaround:
You can also use proshut to get around paging.
proshut dbname -bn
The -bn parameter will shut down the data base IF no users are
connected to that data base.
HOWEVER, if there is at least one user (local or remote) connected to
the data base, then you will get a listing of all the users without
paging. So, this list can then be fed into a script.
WARNING - Executing the the -bn parameter WILL SHUT DOWN THE DATA BASE
if no users (clients) are connected. APW's, AIW's, BIW's, and PROWDOG
are NOT considered users. If these are the ONLY "things" connected,
the -bn will shut down the data base. If you want to prevent the
data base from shutting down, then include a connection in the script,
i.e., mpro dbname
Please note, in version 7.3D and above, two new options have been
added to proshut:
proshut <dbmame> -C list - lists all processes connected to
the database
proshut <dbname> -C disconnect <num> - initiates a disconnect for
the specified user.
Both on these option can only be run via a self-service proshut. If
you attempt to run proshut with -S and -H you will get a message
saying this isn't allowed.
Progress Software Technical Support Note # 15250