List of Contributions

John Smith

Contact Details

My Content

1 to 20 of 50+ total

drop down space/chunks

Posted By John Smith Tue June 13, 2023 09:17 AM
Found In Egroup: Informix \ view thread
Hello to All have a dbspace with many chunks, on down state, and could not drop them, pleaase help 700000132d96bc0 9 0x60005 26 5 4096 ND BA informix test_dbs 700000132d9ae28 26 9 25 26214350 0 PD-B-- /chunks/test_dbs_ol_sgma_chk01 700000132d9b028 27 9 25 26214350 0 PD-B-- /chunks/te ...

RE: question about CPUs

Posted By John Smith Thu May 18, 2023 05:05 AM
Found In Egroup: Informix \ view thread
Thanks Vladimir, so, i have a machine with 7 Cores, SMT4, 14 CPU VPCLASS (i think it s recommended to put 2 VP per Core with SMT4) and (onstat -z ; sleep 60 ; onstat -p) difference is 5, is it using 5 trom the 7 Cores or 5 CPU VPCLASS ? thanks ------------------------------ John Smith ...

RE: question about CPUs

Posted By John Smith Wed May 17, 2023 11:56 AM
Found In Egroup: Informix \ view thread
Thanks Art, no, affinity is not used i prefer to continue with g glo, so the part of output to use is the "total" part, it is expressed on seconds let s say, 200000 seconds, but i don"t know to what compare this value to know the percentrage of CPUs used on the system ------------------------------ ...

question about CPUs

Posted By John Smith Wed May 17, 2023 11:21 AM
Found In Egroup: Informix \ view thread
Hello How could we know exactly how many Cores Informix is using on a Power IBM Server (AIX) ? Not the Sys view but the informix view ( -g glo helps ?) thanks in advance ------------------------------ John Smith ------------------------------

RE: unable to select, delete the data and unable to drop the table, response says Long transaction detected

Posted By John Smith Wed March 08, 2023 04:53 AM
Found In Egroup: Informix \ view thread
Hello for your delete i think this may work, if possible Put database on nologging mode or change table mode to raw, delete, then put it in standard mode ------------------------------ John Smith ------------------------------

virtual segments

Posted By John Smith Tue February 21, 2023 06:01 AM
Found In Egroup: Informix \ view thread
Hello, Are perf issues related to virtual segments ? if so, need an explanation please i know that when seeing many virtual segments we have to resize the shmvirtsize, but we cannot resize indefinitely :), could we find out the sessions using those virtual segments ? thanks in advance ...

Updatable Seconday

Posted By John Smith Wed October 19, 2022 12:44 PM
Found In Egroup: Informix \ view thread
Hi All Till now i always used HDR as a Read only Server, but Could it be updatable ? and if so will the data updated on HDR be written on the Priimary ? Thanks in advance ps: working with informix 11.70, 12.1 and 14.1, ------------------------------ John Smith ------------------------------ ...

RE: IO WAIT

Posted By John Smith Tue October 18, 2022 11:16 AM
Found In Egroup: Informix \ view thread
Hello also notcied that cache is alsmost full at the statement run, the statement need other data to load in the case, so increasing buffers could be the solution ? sql_runtime 3,848010607535 sql_lockreq 3903 sql_lockwaits 0 sql_lockwttime 0,00 sql_rdcache 99,51897381080 ===>>> sql_logspace ...

RE: IO WAIT

Posted By John Smith Fri October 14, 2022 11:38 AM
Found In Egroup: Informix \ view thread
Thanks Art Yes i also noticed io vp / wkup :), just a littre > 1, for this moment i'm focused on this statetement , not the whole system tuning but :).. another question ; the number of kaio vp depends ont number of cpu vp, right ? (no kaio vp parameter) , so the more cpu vps we have, more kaio vps ...

RE: IO WAIT

Posted By John Smith Fri October 14, 2022 09:36 AM
Found In Egroup: Informix \ view thread
Hi thanks for your reply :) No i wanted to say Sample not example, sorry :), it is a real query, ran more than 47000 times in a 2 hours intervals, and 2 sec was the max runtime.. the execution plan is good and already using a index the checkpoint are good The kaio_reads/kaio_writes are fair, ...

RE: IO WAIT

Posted By John Smith Fri October 14, 2022 08:51 AM
Found In Egroup: Informix \ view thread
OK question : if 2 users select the same table, will the table be loaded twice on bufferpool ? or only once ? ------------------------------ John Smith ------------------------------

RE: IO WAIT

Posted By John Smith Fri October 14, 2022 08:24 AM
Found In Egroup: Informix \ view thread
Thanks for the explanation Art :) in fact its needed to be very quick, less than 1 sec, and this 2 sec duration is the max i found within 2 hours tracing about buffers i also checked with your ratios script and no btrs are good i see, output after a full day from 8am to 8pm which 4K br ...

IO WAIT

Posted By John Smith Fri October 14, 2022 07:53 AM
Found In Egroup: Informix \ view thread
Hello Traced some sql statements and noticed some iowaits, i checked io on chunk (-g iof) but needed also any feedbacks about analysing io wait please this example is useful to understand my case, runtime in 2 sec, but totaltime 12 sec, no locks, no sorts ...nothing but io waits see also below ...

How many sql statements

Posted By John Smith Tue September 27, 2022 10:31 AM
Found In Egroup: Informix \ view thread
Hello In order to activate SQLTrace, wanted to have an idea on how much sql statements are run during a day? is there a system table that record this stat ? or is there another way (Informix 14.1) thanks in advance ------------------------------ John Smith ------------------------------ ...

RE: list sql statements

Posted By John Smith Fri September 16, 2022 06:00 AM
Found In Egroup: Informix \ view thread
Hello and thanks :) i totally forgot sql trace, but can i activate it to have the informations without impacting users activitiy ? sqltrace= low is sufficient ? ------------------------------ John Smith ------------------------------

list sql statements

Posted By John Smith Fri September 16, 2022 04:40 AM
Found In Egroup: Informix \ view thread
Hello Usually i use onstat -g top to figure out the most consuming CPU sessions, but i need also to list all sql statements (not onstat -g stm with only thos on cache), with there costs, duration, prefectly , these informations (sessid, sql statement, cost, duration , cpu consuming) Thanks ...

RE: onpladm help please!

Posted By John Smith Mon April 11, 2022 10:00 AM
Found In Egroup: Informix \ view thread
Hello is HPL deprecated ? do you have the reference please ? is the info on IBM site ? thanks ------------------------------ John Smith ------------------------------

Only on temp dbspace is used

Posted By John Smith Mon January 31, 2022 11:44 AM
Found In Egroup: Informix \ view thread
Hello Team on 12.1 server , i have many temp dbspaces , but got an error when one of them is full !! is there a way to fix it ? without increasing their sizes ? i also set PSORT_DBTEMP variable but nothing changed ! thanks in advance for your help ------------------------------ John ...

RE: session(s) taking the most cpu ressources

Posted By John Smith Fri January 28, 2022 12:22 PM
Found In Egroup: Informix \ view thread
Thank you so much :) ------------------------------ John Smith ------------------------------

session(s) taking the most cpu ressources

Posted By John Smith Fri January 28, 2022 11:56 AM
Found In Egroup: Informix \ view thread
Hello please, is there a way to identify sessions that taking the most part of a CPU ressources ? regards ------------------------------ John Smith ------------------------------ #Informix