Informix

Stavros:

You can query the SMI tables in sysmaster. The details span five tables or more however, so not trivial depending on what you need to see. The best documentation of what's in sysmaster is the sysmaster.sql script in $INFORMIXDIR/etc

Some interesting tables include:

• syssesprof
• syssessions
• sysrstcb
• systcblst
• sysseswts
• syssessiontempspaceusage
• syssqscb
  
• sysconblock
  
• sysenvses
  
• sysscblst
  

Hi,

Do you have APARs for these?

Under what conditions do they occur?

Can someone from HCL comment on how this passed QA?

Regards,

David.

Hi,

Do you have APARs for these? 

I did not see these in the fix list for 14.10.FC9W1, can you test on that version?

Regards,

David.

David:

Yes the fix for this os included on 14.10.FC9W1

Art

HI,

I was asking about:

"there is a couple of other onstat output problems with changing structure (onstat -g top session cpu|bwr|bfw, onstat -g top sessmem gro which I observed) or incorrect output (onstat -x).

We asked to fix as well."

Do we have APARs for these?

Hello David,

some of them yes (onstat -g ses <sid>, onstat -x

 some of them not yet:

onstat -g top session cpu

IBM Informix Dynamic Server Version 14.10.FC9W1DE -- On-Line -- Up 00:07:22 -- 6603536 Kbytes
2023-02-23 15:33:43

Top Resource Usage (Max lines 10, Time interval 5 seconds):

Top sessions (CPU usage)

--------------------
 sid        CPU_time
 93           0.0031
Errors found in session block list.
May be caused by changing data structures.

...

onstat -g top session bfr

IBM Informix Dynamic Server Version 14.10.FC9W1DE -- On-Line -- Up 00:11:47 -- 6603536 Kbytes
2023-02-23 15:38:08

Top Resource Usage (Max lines 10, Time interval 5 seconds):

Top sessions (buffer reads)

-----------------------------
 sid    bfrd            bfwrt
 101    3                   2
Errors found in session block list.
May be caused by changing data structures.

...

onstat -g top session bfw

IBM Informix Dynamic Server Version 14.10.FC9W1DE -- On-Line -- Up 00:13:00 -- 6603536 Kbytes
2023-02-23 15:39:21

Top Resource Usage (Max lines 10, Time interval 5 seconds):

Top sessions (buffer reads)

-----------------------------
 sid    bfwrt            bfrd
 101    8                  12
Errors found in session block list.
May be caused by changing data structures.

...

For some could not get data:

onstat -g top sessmem gro

IBM Informix Dynamic Server Version 14.10.FC9W1DE -- On-Line -- Up 00:14:20 -- 6603536 Kbytes
2023-02-23 15:40:41

Top Resource Usage (Max lines 10, Time interval 5 seconds):

(No session pool growth to display)

Regards

$ onstat -g ses 68

IBM Informix Dynamic Server Version 14.10.FC9DE -- On-Line -- Up 00:37:23 -- 327812 Kbytes
Changing data structure forced command termination.

$ onstat-g-ses.sh 68

IBM Informix Dynamic Server Version 14.10.FC9DE -- On-Line -- Up 00:37:28 -- 327812 Kbytes

session           effective                            #RSAM    total      used       dynamic
id       user     user      tty      pid      hostname threads  memory     memory     explain
...

$ cat onstat-g-ses.sh
# Work-around to IT42548 - Doug Lawry, Oninit Consulting, January 2023

case $1 in

[1-9]*)

    sid=$1 ; shift

    exec onstat -g ses 0 "$@" |
    awk -v sid=$sid '
        NR <= 5 { print }
        $1 == sid { found = 1 }
        found != 1 { next }
        /^-+$/ { exit }
        { print }
    ' ;;

*)

    exec onstat -g ses "$@" ;;

esac

$ onstat.g.ses 65

IBM Informix Dynamic Server Version 14.10.FC9DE -- On-Line -- Up 23:37:27 -- 1119364 Kbytes
2023-01-18 14:44:12

session           effective                            #RSAM    total      used       dynamic  
65       informix -         4        153001   Elezar-II 1        217088     197848     off  

Program :
/opt/informix/infmx.14.10.FC9DE/bin/oninit

tid      name     rstcb            flags    curstk   status
84       CDRNsA1  44ae9150         ---P---  3280     sleeping secs: 3     -

Memory pools    count 1
name         class addr              totalsize  freesize   #allocfrag #freefrag  
65           V     48762040         217088     19240      75         12         

name             free       used         name             free       used       
overhead         0          3352         scb              0          144        
opentable        0          5992         filetable        0          1016       
log              0          16536        temprec          0          120992     
ralloc           0          9632         gentcb           0          1592       
ostcb            0          2992         sqscb            0          24856      
hashfiletab      0          552          sqtcb            0          8752       
fragman          0          720          sapi             0          144        
cdr              0          576           

sqscb info
scb              sqscb            optofc   pdqpriority optcompind  directives
44ca91c0         487c5028         0        0           0           1          

Sess       SQL            Current            Iso Lock       SQL  ISAM F.E.  
Id         Stmt type      Database           Lvl Mode       ERR  ERR  Vers  Explain     
65                        syscdr             CR  Not Wait   0    0    9.03  Off         

$ onstat -g ses 68

IBM Informix Dynamic Server Version 14.10.FC9DE -- On-Line -- Up 00:37:23 -- 327812 Kbytes
Changing data structure forced command termination.

$ onstat-g-ses.sh 68

IBM Informix Dynamic Server Version 14.10.FC9DE -- On-Line -- Up 00:37:28 -- 327812 Kbytes

session           effective                            #RSAM    total      used       dynamic
id       user     user      tty      pid      hostname threads  memory     memory     explain
...

$ cat onstat-g-ses.sh
# Work-around to IT42548 - Doug Lawry, Oninit Consulting, January 2023

case $1 in

[1-9]*)

    sid=$1 ; shift

    exec onstat -g ses 0 "$@" |
    awk -v sid=$sid '
        NR <= 5 { print }
        $1 == sid { found = 1 }
        found != 1 { next }
        /^-+$/ { exit }
        { print }
    ' ;;

*)

    exec onstat -g ses "$@" ;;

esac