DatabaseProcApplicationCreatedLinks
sybsystemprocssp_poolconfig  14 déc. 14Defects Propagation Dependencies

1     
2     /* This stored procedure is a wrapper for the user to configure buffer pools. 
3     ** It executes the stored procedure (sp_do_poolconfig) which does the actual 
4     ** job.
5     **
6     ** Validations will be done in sp_do_poolconfig.
7     */
8     create or replace procedure sp_poolconfig
9         @cachename varchar(255) = NULL,
10        @parm1 varchar(30) = NULL,
11        @parm2 varchar(40) = NULL,
12        @parm3 varchar(30) = NULL,
13        @parm4 varchar(255) = NULL
14    as
15    
16        declare @ret int /* return status from sp_do_poolconfig */
17        declare @current_mode varchar(10)
18    
19        /* Store the current view */
20        select @current_mode = @@system_view
21    
22        /*
23        ** We will set the view to cluster here to get the entries of syscurconfigs
24        ** for all instances.
25        */
26        if @@clustermode = 'shared disk cluster'
27        begin
28            set system_view cluster
29        end
30    
31        exec @ret = sp_do_poolconfig @cachename, @parm1, @parm2, @parm3, NULL, @parm4
32    
33        /* Set the view back to current mode */
34        if @@clustermode = 'shared disk cluster'
35        begin
36            set system_view @current_mode
37        end
38    
39        return @ret
40    
41    


exec sp_procxmode 'sp_poolconfig', 'AnyMode'
go

Grant Execute on sp_poolconfig to public
go
DEFECTS
 MTYP 4 Assignment type mismatch @current_mode: varchar(10) = int 20
 MGTP 3 Grant to public sybsystemprocs..sp_poolconfig  
 MNER 3 No Error Check should check return value of exec 31
 MTR1 2 Metrics: Comments Ratio Comments: 41% 8
 MTR2 2 Metrics: Cyclomatic Complexity Cyclo: 4 = 3dec - 1exi + 2 8
 MTR3 2 Metrics: Query Complexity Complexity: 12 8

DATA PROPAGATION detailed
ColumnWritten To
@cachenamesysconfigures.name   sp_configure_rset_001.Parameter Name sp_configure_rset_002.Parameter Name sp_configure_rset_003.Parameter Name sp_configure_rset_004.sqlbNoName4 sp_configure_rset_005.Parameter Name sp_configure_rset_006.Parameter Name sp_configure_rset_001.Parameter Name sp_configure_rset_002.Parameter Name sp_configure_rset_003.Parameter Name
sp_configure_rset_004.sqlbNoName30 sp_configure_rset_005.Parameter Name sp_configure_rset_006.Parameter Name sp_countmetadata_rset_001.option name sp_exec_SQL_rset_001.sqlbNoName57 sp_monitorconfig_rset_001.Name sp_monitorconfig_rset_002.Name sp_validateconfigname_rset_001.option_name
@parm1sysattributes.object_info1   °.object_info2   °.char_value   sysconfigures.config   °.value   °.comment   °.value2   °.value3   °.value4   sysattributes.object_info1  
°.object_info2   °.int_value   °.char_value   sp_addconf_rset_001.sqlbNoName0 sp_configure_rset_001.Config Value sp_configure_rset_002.Config Value sp_configure_rset_005.Config Value sp_configure_rset_006.Config Value sp_dropdevice_rset_001.device sp_autoformat_rset_002._clid#af
sp_configure_rset_001.Config Value sp_configure_rset_002.Config Value sp_configure_rset_005.Config Value sp_configure_rset_006.Config Value sp_countmetadata_rset_001.metadata count °.memory required sp_displayroles_rset_001.Role Name sp_displayroles_rset_002.Role Name sp_displayroles_rset_003.Role Name sp_displayroles_rset_004.Role Name
sp_dropdevice_rset_001.device sp_exec_SQL_rset_001.sqlbNoName57 sp_forceonline_object_rset_001.Object °.Index °.status sp_forceonline_object_rset_002.Object °.Index °.status sp_forceonline_page_rset_001.status sp_forceonline_page_rset_002.status
sp_listsuspect_object_rset_001.Object °.Index °.Access sp_listsuspect_page_rset_001.Object °.Index °.Access sp_makesuspect_obj_rset_001.Obj °.Indid °.LogType °.PageType
°.ErrType °.Delay °.TotalNum sp_makesuspect_obj_rset_002.Obj °.Indid °.LogType °.PageType °.ErrType °.Delay °.TotalNum
sp_makesuspect_obj_rset_003.Obj °.Indid °.LogType °.PageType °.ErrType °.Delay °.TotalNum sp_memlog_rset_001.dumps_per_file sp_monitorconfig_rset_001.Configure Value °.System Value
°.Run Value °.Num_free °.Num_active sp_monitorconfig_rset_002.Num_active °.Pct_act °.Max_Used °.Reuse_cnt °.Instance_Name sp_passwordpolicy_rset_001.message sp_passwordpolicy_rset_002.value
sp_passwordpolicy_rset_003.value sp_passwordpolicy_rset_004.Policy_option sp_rjs_retrieve_rset_001.host_name sp_setsuspect_granularity_rset_001.Online mode sp_setsuspect_threshold_rset_001.Cfg. Suspect threshold sp_setsuspect_threshold_rset_002.Cfg. Suspect Threshold sp_ssladmin_rset_001.certificate_path sp_ssladmin_rset_002.Cipher Suite Name °.Preference sp_validateconfigname_rset_001.config_value
@parm2sysconfigures.config   °.comment   °.value3   °.value4   sp_countmetadata_rset_001.metadata count °.memory required sp_exec_SQL_rset_001.sqlbNoName57 sp_monitorconfig_rset_001.Configure Value °.System Value °.Run Value
°.Num_free °.Num_active sp_monitorconfig_rset_002.Num_active °.Pct_act °.Max_Used °.Reuse_cnt °.Instance_Name
@parm3sysconfigures.config   °.comment   °.value3   sp_countmetadata_rset_001.metadata count °.memory required sp_exec_SQL_rset_001.sqlbNoName57 sp_monitorconfig_rset_001.Configure Value °.System Value °.Run Value °.Num_free
°.Num_active sp_monitorconfig_rset_002.Num_active °.Pct_act °.Max_Used °.Reuse_cnt °.Instance_Name

DEPENDENCIES
PROCS AND TABLES USED
calls proc sybsystemprocs..sp_do_poolconfig  
   writes table sybsystemprocs..sp_do_poolconfig_rset_001 
   writes table sybsystemprocs..sp_do_poolconfig_rset_002 
   read_writes table master..sysconfigures (1)  
   calls proc sybsystemprocs..sp_aux_checkroleperm  
      reads table master..syscurconfigs (1)  
      reads table master..sysconfigures (1)  
   calls proc sybsystemprocs..sp_aux_getsize  
   reads table master..syscurconfigs (1)  
   calls proc sybsystemprocs..sp_cacheconfig  
      read_writes table master..sysconfigures (1)  
      calls proc sybsystemprocs..sp_autoformat  
         writes table sybsystemprocs..sp_autoformat_rset_004 
         writes table sybsystemprocs..sp_autoformat_rset_002 
         reads table master..syscolumns (1)  
         writes table sybsystemprocs..sp_autoformat_rset_005 
         reads table master..systypes (1)  
         calls proc sybsystemprocs..sp_autoformat  
         read_writes table tempdb..#colinfo_af (1) 
         reads table tempdb..systypes (1)  
         writes table sybsystemprocs..sp_autoformat_rset_001 
         reads table tempdb..syscolumns (1)  
         writes table sybsystemprocs..sp_autoformat_rset_003 
         calls proc sybsystemprocs..sp_namecrack  
      read_writes table tempdb..#pool_detail (1) 
      writes table sybsystemprocs..sp_cacheconfig_rset_003 
      read_writes table tempdb..#syscacheconfig (1) 
      writes table sybsystemprocs..sp_cacheconfig_rset_002 
      reads table master..syscurconfigs (1)  
      writes table sybsystemprocs..sp_cacheconfig_rset_001 
      read_writes table tempdb..#cache_info (1) 
      calls proc sybsystemprocs..sp_aux_checkroleperm  
      calls proc sybsystemprocs..sp_aux_getsize