Replace example 8 for sp_monitorconfig in the book with the following, which incorporates new parameters introduced in version 12.5.3:
Example 8 Using the optional parameter result_tbl_name to create a user table, saves the sp_monitorconfig result to this table:
1> create table sample_table 2> (Name varchar(35),Config_val int, System_val int, Total_val int, 3> Num_free int, Num_active int, Pct_act char(6), Max_used int, 4> Num_Reuse int, Date varchar(30)) 5> go
The name of the table created becomes the second parameter of sp_monitorconfig:
1> sp_monitorconfig "locks", sample_table 2> go
(return status = 0)
1> sp_monitorconfig "number of alarms", sample_table 2> go
(return status = 0)
1> select * from sample_table 2> go
Name Config_val System_val Total_val Num_free Num_active Pct_act Max_used Num_Reuse Date ------------------- ----------- ---------- --------- --------- ---------- ------- -------- --------- ------------------------------ number of locks 5000 684 5000 4915 85 1.70 117 0 Aug 23 2006 6:53AM number of alarms 40 0 40 28 12 30.00 13 0 Aug 23 2006 6:53AM
The result set saved to the table accumulates until you delete or truncate the table.
If sample_table is in another database, you must provide its fully qualified name in quotes.