Limit of Current Stack i.e curstk

Posted in 2009

Topics: Versions, Editions & End-of-Life

ANEES AHMAD — Sat, 31 Oct 2009 16:24:16 — source: IIUG Forums & Mailing Lists

Hello, Can anybody guide me about Current Stack variable. What does it do actually? In the below mentioned output you can see that the value of curstk is -1599039121 which I guess is around 1.5GB. Is there any limit on the value of 'curstk' and why is it showing negative? IBM Informix Dynamic Server Version 11.50.FC3W1 -- On-Line (Prim) -- Up 28 days 10:54:59 -- 2756608 Kbytes session effective #RSAM total used dynamic id user user tty pid hostname threads memory memory explain 89168 scmroot - - -1 app2 1 4624384 1822624 off tid name rstcb flags curstk status 76256 sqlexec 11ad14dd0 ---P--- -1599039121 running- Memory pools count 2 name class addr totalsize freesize #allocfrag #freefrag 89168 V 14b5db040 4620288 2800952 2992 1542 89168*O0 V 1762b6040 4096 808 1 1 name free used name free used overhead 0 6576 mtmisc 0 800 scb 0 144 opentable 0 388488 filetable 0 41528 ru 0 600 log 0 16536 temprec 0 27808 keys 0 31040 ralloc 0 804616 gentcb 0 1760 ostcb 0 2872 sort 0 128 sqscb 0 366048 sql 0 72 rdahead 0 576 hashfiletab 0 552 osenv 0 2568 sqtcb 0 13256 fragman 0 94040 sapi 0 128 udr 0 22488 sqscb info scb sqscb optofc pdqpriority sqlstats optcompind directives 14103f028 1638c6028 0 0 0 2 1 Sess SQL Current Iso Lock SQL ISAM F.E. Id Stmt type Database Lvl Mode ERR ERR Vers Explain 89168 UPDATE database_3001 CR Wait 5 0 0 9.28 Off

↪ replying to ANEES AHMAD

ANEES AHMAD — Thu, 05 Nov 2009 15:32:09 — source: IIUG Forums & Mailing Lists

Hello, Would anybody like to answer this question please? Regards, Anees Ahmad