PowerCenter
- PowerCenter 10.5.3
- All Products
Database Configuration
| Sybase System Procedure
| Value
|
---|---|---|
Lock scheme
| sp_configure "lock scheme"
| 0, datarows
|
create procedure dbo.sp_string_rtrunc_proc as set string_rtruncation on sp_modifylogin "user_name", "login script", sp_string_rtrunc_proc
Database Configuration
| Sybase System Procedure
| Value
|
---|---|---|
Maximum amount of total physical memory
| sp_configure "max memory"
| 2097151
|
Procedure cache size
| sp_configure "procedure cache size"
| 500000
|
Number of open objects
| sp_configure "number of open objects"
| 5000
|
Number of open indexes
| sp_configure "number of open indexes"
| 5000
|
Number of open partitions
| sp_configure "number of open partitions"
| 5000
|
Heap memory per user
| sp_configure "heap memory per user"
| 49152
|
Number of locks
| sp_configure "number of locks"
| 100000
|