DatabaseProcApplicationCreatedLinks
sybsystemprocssp_poolconfig  31 Aug 14Defects 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 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: 3 = 2dec - 1exi + 2 8
 MTR3 2 Metrics: Query Complexity Complexity: 12 8

DEPENDENCIES
PROCS AND TABLES USED
calls proc sybsystemprocs..sp_do_poolconfig  
   calls proc sybsystemprocs..sp_cacheconfig  
      calls proc sybsystemprocs..sp_autoformat  
         calls proc sybsystemprocs..sp_autoformat  
         reads table master..syscolumns (1)  
         reads table tempdb..syscolumns (1)  
         calls proc sybsystemprocs..sp_namecrack  
         reads table master..systypes (1)  
         read_writes table tempdb..#colinfo_af (1) 
         reads table tempdb..systypes (1)  
      read_writes table tempdb..#syscacheconfig (1) 
      read_writes table master..sysconfigures (1)  
      read_writes table tempdb..#cache_info (1) 
      calls proc sybsystemprocs..sp_aux_getsize  
      read_writes table tempdb..#pool_detail (1) 
      reads table master..syscurconfigs (1)  
   reads table master..syscurconfigs (1)  
   calls proc sybsystemprocs..sp_aux_getsize  
   read_writes table master..sysconfigures (1)