List of Contributions

Khurram Shahzad

Contact Details

My Content

1 to 6 of 6 total
Posted By Khurram Shahzad Mon May 31, 2021 02:29 AM
Found In Egroup: Informix
\ view thread
I have written the following script to capture queries running more than a minute. echo "execute function task('set sql tracing on',1000,2,'low','global')"|dbaccess sysadmin >logs/slow_queries.out-$(dt) while true; do echo "unload to logs/slow.unl select dbinfo('UTC_TO_DATETIME',sq.sql_finis ...
Posted By Khurram Shahzad Fri January 08, 2021 06:59 AM
Found In Egroup: Informix
\ view thread
I am observing following spin locks Top spi where Num Loops are high Num Waits Num Loops Avg Loop/Wait Name 206 8530238207 41408923.33 mtcb mutex_list_lock 1741 242603370 139347.14 fast mutex, lockhash[705] 29975 216380509 7218.7 class cl_lock, class = 0 151370 172400295 ...
Posted By Khurram Shahzad Mon November 30, 2020 09:53 AM
Found In Egroup: Informix
\ view thread
Thanks for your reply. If I increase log buffer size to 64 MB , Would it help? my database mode is unbuffered logging and in many tables we are also using text and lvarchar columns. Secondly what would be the implications of big log buffer as we are running OLTP system. ------------------------------ ...
Posted By Khurram Shahzad Mon November 30, 2020 09:50 AM
Found In Egroup: Informix
\ view thread
Hi, Thanks for your reply. If I increase log buffer size to 64 MB , Would it help? Secondly what would be the impact on OLTP . Regards, ************************** Khurram Shahzad Sr. Architect Database Operations i2c Inc. 1300 Island Drive, Suite 105 Redwood City, CA ...
Posted By Khurram Shahzad Fri November 27, 2020 04:51 AM
Found In Egroup: Informix
\ view thread
... ------------------------------ Khurram Shahzad ------------------------------
Posted By Khurram Shahzad Mon November 23, 2020 10:58 AM
Found In Egroup: Informix
\ view thread
We have a situation where we are storing PDF files in a table each file size is more than 100mb and log buffer size is 1mb. We are observing wait on buffer logs and slow response on other OLTP transactions. We have also HDR and two RSS nodes . ------------------------------ Khurram Shahzad ...