Database | Proc | Application | Created | Links |
sybsystemprocs | sp_poolconfig | 31 Aug 14 | Defects 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) |